Time and Relational Theory: Temporal Databases in the Relational Model and SQL

— —

C.J. Date (Independent author, lecturer, researcher, and consultant, specializing in relational database technology) Hugh Darwen (Warwick University, UK)

Time and Relational Theory

Temporal Databases in the Relational Model and SQL

C.J. Date (Independent author, lecturer, researcher, and consultant, specializing in relational database technology), Hugh Darwen (Warwick University, UK), Nikos Lorentzos (Professor at the Agricultural University of Athens, Greece)

$76.95

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

Morgan Kaufmann Publishers In
16 July 2014

Database programming; SQL Server & MS SQL

Series: The Morgan Kaufmann Series in Data Management Systems

Time and Relational Theory provides an in-depth description of temporal database systems, which provide special facilities for storing, querying, and updating historical and future data. Traditionally, database management systems provide little or no special support for temporal data at all. This situation is changing because:

Cheap storage enables retention of large volumes of historical data in data warehouses

Users are now faced with temporal data problems, and need solutions

Temporal features have recently been incorporated into the SQL standard, and vendors have begun to add temporal support to their DBMS products

Based on the groundbreaking text Temporal Data & the Relational Model (Morgan Kaufmann, 2002) and new research led by the authors, Time and Relational Theory is the only book to offer a complete overview of the functionality of a temporal DBMS. Expert authors Nikos Lorentzos, Hugh Darwen, and Chris Date describe an approach to temporal database management that is firmly rooted in classical relational theory and will stand the test of time.

This book covers the SQL:2011 temporal extensions in depth and identifies and discusses the temporal functionality still missing from SQL.

By: C.J. Date (Independent author lecturer researcher and consultant specializing in relational database technology), Hugh Darwen (Warwick University, UK), Nikos Lorentzos (Professor at the Agricultural University of Athens, Greece)
Imprint: Morgan Kaufmann Publishers In
Country of Publication: United States
Edition: 2nd edition
Dimensions: Height: 234mm, Width: 191mm, Spine: 24mm
Weight: 1.110kg
ISBN: 9780128006313
ISBN 10: 0128006315
Series: The Morgan Kaufmann Series in Data Management Systems
Pages: 560
Publication Date: 16 July 2014
Audience: Professional and scholarly , Undergraduate
Format: Paperback
Publisher's Status: Active

PART I A REVIEW OF RELATIONAL CONCEPTS 1: Types and Relations 2: Relational Algebra 3: Relation Variables PART II LAYING THE FOUNDATIONS 4: Time and the Database5: What’s the Problem? 6: Intervals 7: Interval Operators 8: The EXPAND and COLLAPSE Operators 9: The PACK and UNPACK Operators I: The Single-Attribute Case 10: The PACK and UNPACK Operators II: The Multiattribute Case 11: Generalizing the Algebraic Operators PART III BUILDING ON THE FOUNDATIONS 12: Database Design I: Structure 13: Database Design II: Keys and Related Constraints14: Database Design III: General Constraints 15: Queries 16: Updates 17: Stated Time and Logged Time 18: Point and Interval Types Revisited PART IV SQL SUPPORT 19: The SQL Standard

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. 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. 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.

Reviews for Time and Relational Theory: Temporal Databases in the Relational Model and SQL

"""... if you are looking for a good introduction to temporal relational database functionality, or an adjunct to the explanation of temporal capabilities in your DBMS manuals, look no further…"" --Data and Technology Today, Nov 2014"