DEVELOPING TIME-ORIENTED DATABASE APPLICATIONS IN SQL
DEVELOPING TIME-ORIENTED DATABASE APPLICATIONS IN SQL by Richard T. Snodgrass Morgan Kaufmann Publishers, July 1999, ISBN 1-55860-436-7, 504+xxiv pages. "I highly recommend this book to anyone interested in temporal data---either designing and building databases that record information over time, or just understanding the concepts that underlie representing temporal information... an excellent job of organizing and summarizing this important area." -- From the foreword by Jim Gray, Microsoft Research "...a long time in the making, not only because the subject matter can seem overwhelmingly complex if not presented carefully, but also because of the great number of examples that Snodgrass has taken from real application systems and translated into standard SQL." -- From the foreword by Jim Melton, Oracle Corporation CONTENTS Fundamental Concepts -- Instants and Intervals -- Periods -- Defining State Tables -- Querying State Tables -- Modifying State Tables -- Retaining a Tracking Log -- Transaction-Time State Tables -- Bitemporal Tables -- Temporal Database Design -- Language Directions -- Prospects -- Glossary -- Principles FEATURES * Offers advice on recording temporal data using SQL data types, defining appropriate integrity constraints, updating temporal tables, and querying temporal tables with interactive and embedded SQL. * Provides case studies detailing real-world problems and solutions in areassuch as event data, state-based data, partitioned data, and audit logs. * Contains over 400 code fragments with detailed explanations. * Includes a CD-ROM containing the code fragments implemented for IBM DB2Universal Database (UDB), Ingres, Informix-Universal Server, Microsoft Access, Microsoft SQL Server, Sybase SQLServer, Oracle8 Server, and UniSQL, as well as evaluation copies of the programs discussed in the book. MORE INFORMATION http://www.mkp.com/books_catalog/1-55860-436-7.asp Morgan Kaufmann Publishers San Francisco, California http://www.mkp.com orders@mkp.com * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!