ISBN: 1558604367 | july 1999 | PDF | 504 pages | Morgan Kaufmann Publishers | 2.2MB
Whether you’re a database designer, programmer, analyst, or manager, you’ve probably encountered some of the challenges-and experienced some of the frustrations-associated with time-varying data. Where do you turn to fix the problem and see that it doesn’t happen again? In Developing Time-Oriented Database Applications in SQL, a leading SQL researcher teaches you effective techniques for designing and building database applications that must integrate past and current data. Written to meet a pervasive, enduring need, this book will be indispensible if you happen to be part of the flurry of activity leading up to Y2K.
* Offers incisive 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 areas such as event data, state-based data, partitioned data, and audit logs.
* Contains over 400 code fragments with detailed explanations.