Richard T. Snodgrass
Encyclopedia
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 database
s, query language design, query optimization and evaluation, storage structures, database design, and ergalics (the science of computing).
for a Bachelor in 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
.
He has been an ACM Fellow since 1999.
Currently, he is a member of the Advisory Board of ACM SIGMOD
, of the ACM History Committee, and of the Editorial Board of ACM Ubiquity.
He is married to Merrie Brucks, the Robert and Kathleen Eckert Professor of Marketing at the Eller College of Management
.
and transaction time
.
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. The committee produced a preliminary language specification the following January, which appeared in the March 1994 ACM SIGMOD Record.
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
.
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 over 90 articles since 1997, many of which have been accepted in leading computer science journals.
(ACM) since the mid-90s. Previously, he has chaired the ACM Publications Board and the ACM History Committee 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
.
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 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.
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.
Snodgrass has written over 90 refereed articles in the following areas:
Computer scientist
A computer scientist is a scientist who has acquired knowledge of computer science, the study of the theoretical foundations of information and computation and their application in computer systems....
and writer, currently employed as a professor at the University of Arizona
University of Arizona
The University of Arizona is a land-grant and space-grant public institution of higher education and research located in Tucson, Arizona, United States. The University of Arizona was the first university in the state of Arizona, founded in 1885...
. He is best known for his work on temporal database
Temporal database
A temporal database is a database with built-in time aspects, for example a temporal data model and a temporal version of Structured Query Language.More specifically the temporal aspects usually include valid-time and transaction-time...
s, query language design, query optimization and evaluation, storage structures, database design, and ergalics (the science of computing).
Biography
Snodgrass was born on April 19, 1955. He attended Carleton CollegeCarleton College
Carleton College is an independent non-sectarian, coeducational, liberal arts college in Northfield, Minnesota, USA. The college enrolls 1,958 undergraduate students, and employs 198 full-time faculty members. In 2012 U.S...
for a Bachelor in Arts (Physics) and then Carnegie Mellon University
Carnegie Mellon University
Carnegie Mellon University is a private research university in Pittsburgh, Pennsylvania, United States....
for an M.S. as well as a Ph.D. in Computer Science
Computer science
Computer science or computing science is the study of the theoretical foundations of information and computation and of practical techniques for their implementation and application in computer systems...
, which he earned in 1982 under the guidance of William Allan Wulf
William Wulf
William Allan Wulf is a computer scientist notable for his work in programming languages and compilers.Born in Chicago, Illinois, he attended the University of Illinois, receiving a BS in Engineering Physics and an MS in Electrical Engineering, then achieved the first Ph.D. in Computer Science...
. Snodgrass is a Professor of Computer Science
Computer science
Computer science or computing science is the study of the theoretical foundations of information and computation and of practical techniques for their implementation and application in computer systems...
at the University of Arizona
University of Arizona
The University of Arizona is a land-grant and space-grant public institution of higher education and research located in Tucson, Arizona, United States. The University of Arizona was the first university in the state of Arizona, founded in 1885...
.
He has been an ACM Fellow since 1999.
Currently, he is a member of the Advisory Board of ACM SIGMOD
SIGMOD
SIGMOD is the Association for Computing Machinery's Special Interest Group on Management of Data, which specializes in large-scale data management problems and databases....
, of the ACM History Committee, and of the Editorial Board of ACM Ubiquity.
He is married to Merrie Brucks, the Robert and Kathleen Eckert Professor of Marketing at the Eller College of Management
Eller College of Management
The Eller College of Management is a business and public administration school at the University of Arizona located in Tucson, Arizona. The Eller College of Management began in 1913 as bachelor's degree program in commerce before becoming the University of Arizona School of Business and Public...
.
Work
Snodgrass and his doctoral student originated the concept of valid timeValid time
Valid time , a concept originated by Richard T. Snodgrass and his doctoral student, is used in temporal databases. It denotes the time period during which a database fact was, is, or will be valid in the modeled reality....
and transaction time
Transaction time
Transaction time , a concept originated by Richard T. Snodgrass and his doctoral student, is used in temporal databases. It denotes the time period during which a database fact is/was stored in the database....
.
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. The committee produced a preliminary language specification the following January, which appeared in the March 1994 ACM SIGMOD Record.
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
Oracle Database
The Oracle Database is an object-relational database management system produced and marketed by Oracle Corporation....
.
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 over 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 MachineryAssociation for Computing Machinery
The Association for Computing Machinery is a learned society for computing. It was founded in 1947 as the world's first scientific and educational computing society. Its membership is more than 92,000 as of 2009...
(ACM) since the mid-90s. Previously, he has chaired the ACM Publications Board and the ACM History Committee and has served on ACM Council. He has chaired the ACM SIGMOD Special Interest Group on Management of Data
SIGMOD
SIGMOD is the Association for Computing Machinery's Special Interest Group on Management of Data, which specializes in large-scale data management problems and databases....
from 1997-2001. In 2001-07, he was Editor-in-Chief of the ACM Transactions on Database Systems
ACM Transactions on Database Systems
The ACM Transactions on Database Systems is one of the journals produced by the Association for Computing Machinery. TODS publishes one volume yearly. Each volume has four issues, which appear in March, June, September and December....
.
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 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.
As the chair of the ACM Publications Board, Snodgrass developed a strategic vision for the Association for Computing Machinery
Association for Computing Machinery
The Association for Computing Machinery is a learned society for computing. It was founded in 1947 as the world's first scientific and educational computing society. Its membership is more than 92,000 as of 2009...
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.
Publications
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 over 90 refereed articles in the following areas:
- General Topics in Temporal Databases
- Conceptual Design of Temporal Databases
- Logical Design of Temporal Databases
- Physical Design of Temporal Databases
- Design of Query Languages for Temporal Databases
- Algebras for Temporal Databases
- Implementation of Temporal Databases
- Temporal XML
- Auditing, Compliance, and Forensic Analysis
- Monitoring Distributed Systems
- Software Development Environments
External links
- Richard T. Snodgrass University of Arizona faculty homepage
- TimeCenter
- TSQL2 Temporal Query Language