Institutional Subscription

Resources

Secure Checkout

Personal information is secured with SSL technology.

Free Shipping

Free global shipping No minimum order.

Table of Contents

Preface. Part I Preliminaries: A Review of Relational Concepts. An Overview of Tutorial D. Part II Laying the Foundation: Time and the Database. What Is the Problem? Intervals. Opeartors on Intervals. The EXPAND and COLLAPSE Operators. The PACK and UNPACK Operators. Generalizing the Relational Operators. Part III Building on the Foundations: Database Design. Integrity Constraints I: Candidate Keys and Related Constraints. Integrity Constraints II: General Constraints. Database Queries. Database Updates. Stated Times and Logged Times. Point and Interval Types Revisited. Appendixes: Implementation Considerations. Generalizing the EXPAND and COLLAPSE Operators. References and Bibliography. Index.

Description

Temporal database systems are systems that provide special support for storing, querying, and updating historical and/or future data. Current DBMSs provide essentially no temporal features at all, but this situation is likely to change soon for a variety of reasons; in fact, temporal databases are virtually certain to become important sooner rather than later, in the commercial world as well as in academia. This book provides an in-depth description of the foundations and principles on which those temporal DBMSs will be built. These foundations and principles are firmly rooted in the relational model of data; thus, they represent an evolutionary step, not a revolutionary one, and they will stand the test of time.

Key Features

This book is arranged in three parts and a set of appendixes:

Preliminaries: Provides a detailed review of the relational model, and an overview of the Tutorial D language.

Building on the Foundations: Applies the material of the previous part to issues of temporal database design, temporal constraints, temporal query and update, and much more.

Appendixes: Include annotated references and bibliography, implementation considerations, and other topics.

Key features:

Describes a truly relational approach to the temporal data problem.

Addresses implementation as well as model issues.

Covers recent research on new database design techniques, a new normal form, new relational operators, new update operators, a new approach to the problem of "granularity," support for "cyclic point types," and other matters.

Ratings and Reviews

Review's title & body can't be emptyPlease enter a star rating for this reviewName field cannot be emptyInvalid emailYour review has already been submitted.Max length was exceededPlease fill out all of the mandatory (*) fieldsOne or more of your answers does not meet the required criteria

Your review was sent successfully and is now waiting for our team to publish it.

See what people are saying about

Loading...

Reviews(0)

write a review

Updating Results

About the Authors

C.J. Date Author

C. J. Date has a unique stature in the database industry. Author or coauthor of well over 30 books on database management (including the bestselling An Introduction to Database Systems, currently in its 8th edition), he enjoys a reputation that’s second to none for his ability to explain complex technical issues in a clear and understandable fashion. He was inducted into the Computing Industry Hall of Fame in 2004.

Affiliations and Expertise

Hugh Darwen Author

Hugh Darwen was employed in IBM’s software development divisions from 1967 to 2004. In the early part of his career, he was involved in DBMS development; from 1978 to 1982, he was one of the chief architects of an IBM product called Business System 12, a product that faithfully embraced the principles of the relational model. He was an active participant in the development of the international standard for SQL (and related standards) from 1988 to 2004. Based in the UK, he currently teaches relational database theory at Warwick University and is a tutor and course development consultant for the Open University. He has written two books on database management as well as coauthoring several with C.J. Date. He has received honorary degrees from the University of Wolverhampton and the Open University.

Affiliations and Expertise

Warwick University, UK

Nikos Lorentzos Author

Nikos A. Lorentzos is a Professor at the Agricultural University of Athens. He is mainly known for his research in temporal (and also in spatio-temporal) databases. He has participated in relevant European Union funded projects (prime researcher for the development of a Temporal DBMS). The temporal model he has proposed has been extensively evaluated by independent researchers with positive comments, it is decribed in books addressed to university students, it has been the basis of PhDs undertaken in Europe and it has attracted the interest of DBMS developers. He is co-editor of the book Spatiotemporal Databases: The Chorochronos Approach (spatio-temporal databases). He is active in Temporal, Spatial and Spatio-temporal Databases as well as in the development of DSSs and Expert Systems in the forestry and the agricultural domain.

Affiliations and Expertise

Professor at the Agricultural University of Athens, Greece

C.J. Date Author

C. J. Date has a unique stature in the database industry. Author or coauthor of well over 30 books on database management (including the bestselling An Introduction to Database Systems, currently in its 8th edition), he enjoys a reputation that’s second to none for his ability to explain complex technical issues in a clear and understandable fashion. He was inducted into the Computing Industry Hall of Fame in 2004.

Affiliations and Expertise

Hugh Darwen Author

Hugh Darwen was employed in IBM’s software development divisions from 1967 to 2004. In the early part of his career, he was involved in DBMS development; from 1978 to 1982, he was one of the chief architects of an IBM product called Business System 12, a product that faithfully embraced the principles of the relational model. He was an active participant in the development of the international standard for SQL (and related standards) from 1988 to 2004. Based in the UK, he currently teaches relational database theory at Warwick University and is a tutor and course development consultant for the Open University. He has written two books on database management as well as coauthoring several with C.J. Date. He has received honorary degrees from the University of Wolverhampton and the Open University.

Affiliations and Expertise

Warwick University, UK

Nikos Lorentzos Author

Nikos A. Lorentzos is a Professor at the Agricultural University of Athens. He is mainly known for his research in temporal (and also in spatio-temporal) databases. He has participated in relevant European Union funded projects (prime researcher for the development of a Temporal DBMS). The temporal model he has proposed has been extensively evaluated by independent researchers with positive comments, it is decribed in books addressed to university students, it has been the basis of PhDs undertaken in Europe and it has attracted the interest of DBMS developers. He is co-editor of the book Spatiotemporal Databases: The Chorochronos Approach (spatio-temporal databases). He is active in Temporal, Spatial and Spatio-temporal Databases as well as in the development of DSSs and Expert Systems in the forestry and the agricultural domain.

Affiliations and Expertise

Professor at the Agricultural University of Athens, Greece

Request Quote

Tax Exemption

We cannot process tax exempt orders online. If you wish to place a tax exempt order
please contact us.