Facebook Icon Image Google Plus Icon Image Twitter Icon Image Logo Image

Time and Relational Theory

Temporal Databases in the Relational Model and SQL

Time and Relational Theory Image

Book details:

Publisher:Morgan Kaufmann Publishers In
Category: Morgan Kaufmann
Posted:Aug 19 2016
Book format:PDF
Book size:10.32 MB

Book Description:

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. * Understand how the relational model provides an ideal basis for taming the complexities of temporal databases * Learn how to analyze and evaluate commercial temporal products with this timely and important information * Be able to use sound principles in designing and using temporal databases * Understand the temporal support recently added to SQL with coverage of the new SQL features in this unique, accurate, and authoritative reference * Appreciate the benefits of a truly relational approach to the problem with this clear, user friendly presentation

Download Link:

Related Books:

Database Design and Relational Theory Image

Database Design and Relational Theory

Jun 30 2016 What makes this book different from others on database design? Many resources on design practice do little to explain the underlying theory, and books on design theory are aimed primarily at theoreticians. In this book, renowned expert Chris Date bridges the gap by introducing design theory in ways practitioners can understandamp;#8212;drawing on lessons learned over four decades of experience to demonstrate why proper database design is so critical in the first place. Every chapter includes a set of exercises that show how to apply the theoretical ideas in practice, provide additional informa...

SQL and Relational Theory Image

SQL and Relational Theory

Jun 30 2016 Understanding SQL's underlying theory is the best way to guarantee that your SQL code is correct and your database schema is robust and maintainable. On the other hand, if you're not well versed in the theory, you can fall into several traps. In SQL and Relational Theory, author C.J. Date demonstrates how you can apply relational theory directly to your use of SQL. With numerous examples and clear explanations of the reasoning behind them, you'll learn how to deal with common SQL dilemmas, such as:Should database access granted be through views instead of base tables? Nulls in your database ar...

SQL and Relational Theory 2nd Edition Image

SQL and Relational Theory 2nd Edition

Jun 30 2016 SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put the theory into practice. In this insightful book, author C.J. Date explains relational theory in depth, and demonstrates through numerous examples and exercises how you can apply it directly to your use of SQL. This second edition includes new material on recursive queries, 'missing information without nulls, new update operators, and topics such as aggregate operators, grouping and ungrouping, and view updating. If you have a modest-to-advanced backgro...

View Updating and Relational Theory Image

View Updating and Relational Theory

Jun 30 2016 Views are virtual tables. That means they should be updatable, just as "real" or base tables are. In fact, view updatability isn't just desirable, it's crucial, for practical reasons as well as theoretical ones. But view updating has always been a controversial topic. Ever since the relational model first appeared, there has been widespread skepticism as to whether (in general) view updating is even possible. In stark contrast to this conventional wisdom, this book shows how views, just like base tables, can always be updated (so long as the updates don't violate any integrity constr...