fbpx
Wikipedia

Richard T. Snodgrass

January 01, 1970

Richard Thomas Snodgrass (born April 19, 1955) is an American computer scientist and writer and is professor emeritus at the University of Arizona.[3] 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).[4][5][6]

Richard T. Snodgrass
Born (1955-04-19) April 19, 1955 (age 69)
Amarillo, Texas, United States
CitizenshipUnited States
Alma materCarnegie Mellon University (Ph.D 1982)
Carnegie Mellon University (MS 1978)
Carleton College (BA 1977)
Known fortemporal databases
query language design
query optimization and evaluation
AwardsOutstanding Contribution to ACM Award (2004)[1]
ACM SIGMOD Contributions Award (2002)[2]
Scientific career
FieldsComputer Scientist
InstitutionsUniversity of North Carolina
University of Arizona
Doctoral advisorWilliam Allan Wulf

Biography edit

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 PhD in Computer Science, which he earned in 1982 under the guidance of William Allan Wulf. He has been an ACM Fellow since 1999.[7] He has been 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 Emeritus at the Eller College of Management.

Work edit

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.

Association for Computing Machinery edit

Snodgrass worked as a volunteer for Association for Computing Machinery (ACM) from the mid-1990s. 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 to 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] This resource was later expanded into the ACM Digital Library, which has opened for public access more than 100,000 scientific articles from 1951 through 2000.[20]

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.[21]

Publications edit

Snodgrass is the author or editor of several books including:

  • Developing Time-Oriented Database Applications in SQL, Richard T. Snodgrass, Morgan Kaufmann Publishers, Inc., San Francisco, July, 1999, 504+xxiii pages, ISBN 1-55860-436-7.
  • The TSQL2 Temporal Query Language, The TSQL2 Language Design Committee consisted of Richard T. Snodgrass (chair), Ilsoo Ahn, Gad Ariav, Don Batory, James Clifford, Curtis E. Dyreson, Ramez Elmasri, Fabio Grandi, Christian S. Jensen, Wolfgang Käfer, Nick Kline, Krishna Kulkarni, T. Y. Cliff Leung, Nikos Lorentzos, John F. Roddick, Arie Segev, Michael D. Soo and Suryanarayana M. Sripada, Kluwer Academic Publishers, 1995, 674+xxiv pages, ISBN 0-8053-2413-5, QA76.9.D3T4125.
  • Temporal Databases: Theory, Design, and Implementation, Abdullah Tansel, James Clifford, Shashi Gadia, Sushil Jajodia, Arie Segev, and Richard T. Snodgrass (editors), Database Systems and Applications Series, Benjamin/Cummings Pub. Co., Redwood City, CA, March 1993, 633+xx pages, ISBN 0-8053-2413-5, QA76.9.D3T4125.
  • The Interface Description Language: Definition and Use, Richard T. Snodgrass with contributions from Karen P. Shannon, Jerry S. Kickenson, Mike A. Shapiro, Dean D. Throop, William B. Warren, David A. Lamb, John R. Nestor, and William A. Wulf, Principles of Computer Science Series, Computer Science Press, Rockville, MD, 1989, 615+xv pages.

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

  • General Topics in Temporal Databases[22][23]
  • Conceptual Design of Temporal Databases
  • Logical Design of Temporal Databases[24][25]
  • Physical Design of Temporal Databases[26][27]
  • Design of Query Languages for Temporal Databases[28][29]
  • Algebras for Temporal Databases[30][31]
  • Implementation of Temporal Databases[32][33]
  • Temporal XML[34]
  • Auditing, Compliance, and Forensic Analysis[35][36]
  • Monitoring Distributed Systems[37]
  • Software Development Environments

References edit

  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. ^ "Richard T. Snodgrass". rts.cs.arizona.edu. Retrieved December 7, 2020.
  4. ^ "dblp: Richard T. Snodgrass". www.informatik.uni-trier.de. Retrieved December 7, 2020.
  5. ^ . academic.microsoft.com. Archived from the original on March 16, 2016. Retrieved December 7, 2020.
  6. ^ "Richard T. Snodgrass - Home". portal.acm.org. Retrieved December 7, 2020.
  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. ^ Snodgrass, Richard Thomas; Ahn, Ilsoo; Ariav, Gad; Batory, Don; Clifford, James; Dyreson, Curtis E.; Elmasri, Ramez; Grandi, Fabio; Jensen, Christian S.; Käfer, Wolfgang; Kline, Nick; Kulkarni, Krishna; Leung, T. Y. Cliff; Lorentzos, Nikos; Roddick, John F.; Segev, Arie; Soo, Michael D.; Sripada, Suryanarayana M. (September 1994). "ACM SIGMOD Record / Richard T. Snodgrass". ACM SIGMOD Record. 23 (3). SIGMOD: 27–33. doi:10.1145/187436.187449. S2CID 5253847.
  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 Digital Library". Association for Computing Machinery. Retrieved July 26, 2022.
  21. ^ "ACM Publications Board". Association for Computing Machinery. Retrieved April 28, 2010.
  22. ^ Christian S. Jensen and Richard T. Snodgrass, "Temporal Data Management," IEEE Transactions on Knowledge and Data Engineering 11(1):36–44, January/February 1999.
  23. ^ 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.
  24. ^ 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.
  25. ^ 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.
  26. ^ Curtis E. Dyreson and Richard T. Snodgrass, "Timestamp Semantics and Representation," Information Systems 18(3), September 1993, pp. 143–166.
  27. ^ Suchen Hsu and Richard T. Snodgrass, "Optimal Block Size for Set-valued Attributes," Information Processing Letters 45(3), March 1993, pp. 153–158.
  28. ^ Michael Böhlen, Christian S. Jensen, and Richard T. Snodgrass, "Temporal Statement Modifiers," ACM Transactions on Database Systems 25(4):407–456. December 2000.
  29. ^ Curtis E. Dyreson and Richard T. Snodgrass, "Supporting Valid-time Indeterminacy," ACM Transactions on Database Systems 23(1), March 1998, pp. 1–57.
  30. ^ 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.
  31. ^ Edward McKenzie and Richard T. Snodgrass, "Schema Evolution and the Relational Algebra," Information Systems 15(2), June 1990, pp. 207–232.
  32. ^ 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.
  33. ^ 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.
  34. ^ 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.
  35. ^ 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.
  36. ^ Kyri Pavlou and Richard T. Snodgrass, "Forensic Analysis of Database Tampering," ACM Transactions on Database Systems 33(4), December, 2008, 45+26 pages.
  37. ^ Richard T. Snodgrass, "A Relational Approach to Monitoring Complex Systems," ACM Transactions on Computer Systems 6(2), May 1988, pp. 157–196.

External links edit

  • Richard T. Snodgrass University of Arizona faculty homepage
  • TimeCenter
  • TSQL2 Temporal Query Language

January 01, 1970
richard, snodgrass, richard, thomas, snodgrass, born, april, 1955, american, computer, scientist, writer, professor, emeritus, university, arizona, best, known, work, temporal, databases, query, language, design, query, optimization, evaluation, storage, struc. Richard Thomas Snodgrass born April 19 1955 is an American computer scientist and writer and is professor emeritus at the University of Arizona 3 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 4 5 6 Richard T SnodgrassBorn 1955 04 19 April 19 1955 age 69 Amarillo Texas United StatesCitizenshipUnited StatesAlma materCarnegie Mellon University Ph D 1982 Carnegie Mellon University MS 1978 Carleton College BA 1977 Known fortemporal databases query language design query optimization and evaluationAwardsOutstanding Contribution to ACM Award 2004 1 ACM SIGMOD Contributions Award 2002 2 Scientific careerFieldsComputer ScientistInstitutionsUniversity of North CarolinaUniversity of ArizonaDoctoral advisorWilliam Allan Wulf Contents 1 Biography 2 Work 3 Association for Computing Machinery 4 Publications 5 References 6 External linksBiography editSnodgrass 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 PhD in Computer Science which he earned in 1982 under the guidance of William Allan Wulf He has been an ACM Fellow since 1999 7 He has been 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 Emeritus at the Eller College of Management Work editSnodgrass 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 Association for Computing Machinery editSnodgrass worked as a volunteer for Association for Computing Machinery ACM from the mid 1990s 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 to 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 This resource was later expanded into the ACM Digital Library which has opened for public access more than 100 000 scientific articles from 1951 through 2000 20 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 21 Publications editSnodgrass is the author or editor of several books including Developing Time Oriented Database Applications in SQL Richard T Snodgrass Morgan Kaufmann Publishers Inc San Francisco July 1999 504 xxiii pages ISBN 1 55860 436 7 The TSQL2 Temporal Query Language The TSQL2 Language Design Committee consisted of Richard T Snodgrass chair Ilsoo Ahn Gad Ariav Don Batory James Clifford Curtis E Dyreson Ramez Elmasri Fabio Grandi Christian S Jensen Wolfgang Kafer Nick Kline Krishna Kulkarni T Y Cliff Leung Nikos Lorentzos John F Roddick Arie Segev Michael D Soo and Suryanarayana M Sripada Kluwer Academic Publishers 1995 674 xxiv pages ISBN 0 8053 2413 5 QA76 9 D3T4125 Temporal Databases Theory Design and Implementation Abdullah Tansel James Clifford Shashi Gadia Sushil Jajodia Arie Segev and Richard T Snodgrass editors Database Systems and Applications Series Benjamin Cummings Pub Co Redwood City CA March 1993 633 xx pages ISBN 0 8053 2413 5 QA76 9 D3T4125 The Interface Description Language Definition and Use Richard T Snodgrass with contributions from Karen P Shannon Jerry S Kickenson Mike A Shapiro Dean D Throop William B Warren David A Lamb John R Nestor and William A Wulf Principles of Computer Science Series Computer Science Press Rockville MD 1989 615 xv pages Snodgrass has written more than 90 refereed articles in the following areas General Topics in Temporal Databases 22 23 Conceptual Design of Temporal Databases Logical Design of Temporal Databases 24 25 Physical Design of Temporal Databases 26 27 Design of Query Languages for Temporal Databases 28 29 Algebras for Temporal Databases 30 31 Implementation of Temporal Databases 32 33 Temporal XML 34 Auditing Compliance and Forensic Analysis 35 36 Monitoring Distributed Systems 37 Software Development EnvironmentsReferences edit 2004 Outstanding Contributions to ACM Award Richard T Snodgrass Association for Computing Machinery Retrieved April 28 2010 2002 SIGMOD Contributions Award Richard T Snodgrass SIGMOD Retrieved April 28 2010 Richard T Snodgrass rts cs arizona edu Retrieved December 7 2020 dblp Richard T Snodgrass www informatik uni trier de Retrieved December 7 2020 Microsoft Academic academic microsoft com Archived from the original on March 16 2016 Retrieved December 7 2020 Richard T Snodgrass Home portal acm org Retrieved December 7 2020 ACM Fellows Award Richard T Snodgrass Association for Computing Machinery Retrieved April 27 2010 SIGMOD Advisory Board Richard T Snodgrass SIGMOD Retrieved April 28 2010 ACM History Committee Richard T Snodgrass Association for Computing Machinery Retrieved April 28 2010 ACM Ubiquity Editorial Board Richard T Snodgrass Association for Computing Machinery Retrieved April 28 2010 Richard T Snodgrass and Ilsoo Ahn Temporal Databases IEEE Computer 19 9 September 1986 pp 35 42 TSQL2 Temporal Query Language Richard T Snodgrass SIGMOD Retrieved April 28 2010 Snodgrass Richard Thomas Ahn Ilsoo Ariav Gad Batory Don Clifford James Dyreson Curtis E Elmasri Ramez Grandi Fabio Jensen Christian S Kafer Wolfgang Kline Nick Kulkarni Krishna Leung T Y Cliff Lorentzos Nikos Roddick John F Segev Arie Soo Michael D Sripada Suryanarayana M September 1994 ACM SIGMOD Record Richard T Snodgrass ACM SIGMOD Record 23 3 SIGMOD 27 33 doi 10 1145 187436 187449 S2CID 5253847 Transaction Management with LogMiner and Flashback Data Archive Oracle Database Retrieved April 28 2010 Oracle 11g Database New Features Oracle Database Retrieved April 28 2010 Workspace manager valid Time Support Oracle Database Retrieved April 28 2010 ACM History Committee Richard T Snodgrass Association for Computing Machinery Retrieved April 28 2010 People History of ACM Transactions on Database Systems Richard T Snodgrass ACM Transactions on Database Systems Retrieved April 27 2010 ACM Portal Association for Computing Machinery Retrieved April 28 2010 ACM Digital Library Association for Computing Machinery Retrieved July 26 2022 ACM Publications Board Association for Computing Machinery Retrieved April 28 2010 Christian S Jensen and Richard T Snodgrass Temporal Data Management IEEE Transactions on Knowledge and Data Engineering 11 1 36 44 January February 1999 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 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 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 Curtis E Dyreson and Richard T Snodgrass Timestamp Semantics and Representation Information Systems 18 3 September 1993 pp 143 166 Suchen Hsu and Richard T Snodgrass Optimal Block Size for Set valued Attributes Information Processing Letters 45 3 March 1993 pp 153 158 Michael Bohlen Christian S Jensen and Richard T Snodgrass Temporal Statement Modifiers ACM Transactions on Database Systems 25 4 407 456 December 2000 Curtis E Dyreson and Richard T Snodgrass Supporting Valid time Indeterminacy ACM Transactions on Database Systems 23 1 March 1998 pp 1 57 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 Edward McKenzie and Richard T Snodgrass Schema Evolution and the Relational Algebra Information Systems 15 2 June 1990 pp 207 232 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 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 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 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 Kyri Pavlou and Richard T Snodgrass Forensic Analysis of Database Tampering ACM Transactions on Database Systems 33 4 December 2008 45 26 pages Richard T Snodgrass A Relational Approach to Monitoring Complex Systems ACM Transactions on Computer Systems 6 2 May 1988 pp 157 196 External links edit nbsp Biography portal Richard T Snodgrass University of Arizona faculty homepage TimeCenter TSQL2 Temporal Query Language Retrieved from https en wikipedia org w index php title Richard T Snodgrass amp oldid 1212679104, wikipedia, wiki, book, books, library,

article

, read, download, free, free download, mp3, video, mp4, 3gp, jpg, jpeg, gif, png, picture, music, song, movie, book, game, games.