Richard T. Snodgrass

Richard T. Snodgrass
Born (1955-04-19) April 19, 1955
Amarillo, Texas, USA
Residence Tucson, Arizona
Citizenship USA
Fields Computer Scientist
Institutions University of North Carolina
University of Arizona
Alma mater Carnegie Mellon University (Ph.D 1982)
Carnegie Mellon University (MS 1978)
Carleton College (BA 1977)
Doctoral advisor William Allan Wulf
Known for temporal databases
query language design
query optimization and evaluation
Notable awards

Outstanding Contribution to ACM Award (2004)[1]


ACM SIGMOD Contributions Award (2002)[2]

Richard Thomas Snodgrass is an American computer scientist and writer, currently employed as a professor at the University of Arizona. He is best known for his work on temporal databases, query language design, query optimization and evaluation, storage structures, database design, and ergalics (the science of computing).[3][4][5]

Biography

Snodgrass was born on April 19, 1955. He attended Carleton College for a Bachelor of Arts (Physics) and then Carnegie Mellon University for an M.S. as well as a Ph.D in Computer Science, which he earned in 1982 under the guidance of William Allan Wulf. Snodgrass is a Professor of Computer Science at the University of Arizona.[6] He has been an ACM Fellow since 1999.[7] Currently, he is a member of the Advisory Board of ACM SIGMOD,[8] of the ACM History Committee,[9] and of the Editorial Board of ACM Ubiquity.[10]

He is married to Merrie Brucks, the Robert and Kathleen Eckert Professor of Marketing at the Eller College of Management.

Work

Snodgrass and his doctoral student originated the concept of valid time and transaction time.[11] As of December 2011, ISO/IEC 9075, Database Language SQL:2011 Part 2: SQL/Foundation included clauses in table definitions to define "application-time period tables" (valid-time tables) and "system-versioned tables" (transaction-time tables).

TSQL2, a temporal extension to the SQL-92 language standard, was designed by the TSQL2 committee, which was formed in July, 1993. Snodgrass chaired the TSQL2 language design committee.[12] The committee produced a preliminary language specification the following January, which appeared in the March 1994 ACM SIGMOD Record.[13]

Various members of the temporal database research community have worked to transfer some of the constructs and insights of TSQL2 into SQL3, termed SQL/Temporal. Snodgrass initiated SQL/Temporal part of the SQL3 draft standard. SQL/Temporal has been partially implemented in Oracle, Teradata version 14, and IBM DB2 10.[14][15][16]

Snodgrass along with Christian Jensen co-chairs TimeCenter, an international center for the support of temporal database applications on traditional and emerging DBMS technologies. The center has published more than 90 articles since 1997, many of which have been accepted in leading computer science journals.

ACM Activities

Snodgrass has worked continuously as a volunteer for Association for Computing Machinery (ACM) since the mid-90s. Previously, he has chaired the ACM Publications Board and the ACM History Committee[17] and has served on ACM Council. He has chaired the ACM SIGMOD Special Interest Group on Management of Data from 1997-2001. In 2001-07, he was Editor-in-Chief of the ACM Transactions on Database Systems.[18]

Snodgrass presented to the ACM Council a proposal for "a new ACM service, the ACM Computing Portal," a web-based repository of bibliographic information of all the computing literature. The proposal arrived at a ballpark figure of one million items that captured the entire history of computing, from roughly 1940 to 2000. The ACM Portal, also called the ACM Guide, was released to the public on May 21, 2003.[19]

As the chair of the ACM Publications Board, Snodgrass developed a strategic vision for the Association for Computing Machinery to become the preferred publisher for computer science and proposed a far-ranging policy that recognizes the rights and responsibilities of readers, authors, reviewers, editors and libraries.[20]

Publications

Snodgrass is the author or editor of several books including:

Snodgrass has written more than 90 refereed articles in the following areas:

References

  1. ↑ "2004 Outstanding Contributions to ACM Award / Richard T. Snodgrass". Association for Computing Machinery. Retrieved April 28, 2010.
  2. ↑ "2002 SIGMOD Contributions Award / Richard T. Snodgrass". SIGMOD. Retrieved April 28, 2010.
  3. ↑ http://www.informatik.uni-trier.de/~ley/db/indices/a-tree/s/Snodgrass:Richard_T=.html
  4. ↑ http://academic.research.microsoft.com/Author/300418.aspx
  5. ↑ http://portal.acm.org/author_page.cfm?id=81452613035
  6. ↑ http://www.cs.arizona.edu/people/rts/
  7. ↑ "ACM: Fellows Award / Richard T. Snodgrass". Association for Computing Machinery. Retrieved April 27, 2010.
  8. ↑ "SIGMOD Advisory Board / Richard T. Snodgrass". SIGMOD. Retrieved April 28, 2010.
  9. ↑ "ACM History Committee / Richard T. Snodgrass". Association for Computing Machinery. Retrieved April 28, 2010.
  10. ↑ "ACM Ubiquity Editorial Board / Richard T. Snodgrass". Association for Computing Machinery. Retrieved April 28, 2010.
  11. ↑ Richard T. Snodgrass and Ilsoo Ahn, "Temporal Databases," IEEE Computer 19(9), September, 1986, pp. 35–42.
  12. ↑ "TSQL2 Temporal Query Language / Richard T. Snodgrass". SIGMOD. Retrieved April 28, 2010.
  13. ↑ "ACM SIGMOD Record / Richard T. Snodgrass". SIGMOD. Retrieved April 28, 2010.
  14. ↑ "Transaction Management with LogMiner and Flashback Data Archive". Oracle Database. Retrieved April 28, 2010.
  15. ↑ "Oracle 11g Database New Features". Oracle Database. Retrieved April 28, 2010.
  16. ↑ "Workspace manager valid Time Support". Oracle Database. Retrieved April 28, 2010.
  17. ↑ "ACM History Committee / Richard T. Snodgrass". Association for Computing Machinery. Retrieved April 28, 2010.
  18. ↑ "People History of ACM Transactions on Database Systems / Richard T. Snodgrass". ACM Transactions on Database Systems. Retrieved April 27, 2010.
  19. ↑ "ACM Portal". Association for Computing Machinery. Retrieved April 28, 2010.
  20. ↑ "ACM Publications Board". Association for Computing Machinery. Retrieved April 28, 2010.
  21. ↑ Christian S. Jensen and Richard T. Snodgrass, "Temporal Data Management," IEEE Transactions on Knowledge and Data Engineering 11(1):36–44, January/February 1999.
  22. ↑ Richard T. Snodgrass, "Towards a Science of Temporal Databases," Keynote Address, Proceedings of the International Symposium on Temporal Representation and Reasoning, Alicante, Spain, V. Goranko and X. Sean Wang (ed), pages 6-7, June 2007.
  23. ↑ Paolo Terenziani and Richard T. Snodgrass, "Reconciling Point-Based and Interval-Based Semantics in Temporal Databases: A Treatment of the Telic/Atelic Distinction," IEEE Transactions on Knowledge and Data Engineering 16(5):540–551, May 2004.
  24. ↑ Christian S. Jensen, Richard T. Snodgrass and M. D. Soo, "Extending Existing Dependency Theory to Temporal Databases," IEEE Transactions on Knowledge and Data Engineering 8(4), August 1996, pp. 563–582.
  25. ↑ Curtis E. Dyreson and Richard T. Snodgrass, "Timestamp Semantics and Representation," Information Systems 18(3), September 1993, pp. 143–166.
  26. ↑ Suchen Hsu and Richard T. Snodgrass, "Optimal Block Size for Set-valued Attributes," Information Processing Letters 45(3), March 1993, pp. 153–158.
  27. ↑ Michael Böhlen, Christian S. Jensen, and Richard T. Snodgrass, "Temporal Statement Modifiers," ACM Transactions on Database Systems 25(4):407–456. December 2000.
  28. ↑ Curtis E. Dyreson and Richard T. Snodgrass, "Supporting Valid-time Indeterminacy," ACM Transactions on Database Systems 23(1), March 1998, pp. 1–57.
  29. ↑ Edward McKenzie and Richard T. Snodgrass, "An Evaluation of Relational Algebras Incorporating the Time Dimension in Databases," ACM Computing Surveys 23(4), December 1991, pp. 501–543.
  30. ↑ Edward McKenzie and Richard T. Snodgrass, "Schema Evolution and the Relational Algebra," Information Systems 15(2), June 1990, pp. 207–232.
  31. ↑ David Lomet, Richard T. Snodgrass, and Christian S. Jensen, "Using the Lock Manager to Choose Timestamps," in Proceedings of the Ninth International Database Engineering and Applications Symposium (IDEAS 2005), Montreal, Canada, July 2005.
  32. ↑ Dengfeng Gao, Christian S. Jensen, Richard T. Snodgrass and Michael Soo, "Join Operations in Temporal Databases," International Journal on Very Large Databases 14(1):2-29, March 2005.
  33. ↑ Curtis Dyreson, Richard T. Snodgrass, Faiz Currim, Sabah Currim, and Shailesh Joshi, "Weaving Temporal and Reliability Aspects into a Schema Tapestry," Data and Knowledge Engineering 63(3):726-747, 2007.
  34. ↑ Kyriacos E. Pavlou and Richard T. Snodgrass, "The Tiled Bitmap Forensic Analysis Algorithm," IEEE Transactions on Knowledge and Data Engineering 22(4):590-601, April 2010.
  35. ↑ Kyri Pavlou and Richard T. Snodgrass, "Forensic Analysis of Database Tampering," ACM Transactions on Database Systems 33(4), December, 2008, 45+26 pages.
  36. ↑ Richard T. Snodgrass, "A Relational Approach to Monitoring Complex Systems," ACM Transactions on Computer Systems 6(2), May 1988, pp. 157–196.

External links

This article is issued from Wikipedia - version of the Sunday, May 01, 2016. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.