Abstract | Keywords | Export | Availability | Bookmark

Choose an application

• Reference Manager
• EndNote
• RefWorks (Direct export to RefWorks)

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. The enclosed CD-ROM contains all of the code fragments-implemented for Oracle8 Server, IBM DB2 Universal Database, Microsoft SQL Server, and other systems-and evaluation copies of the programs discussed in the book. * 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.

SQL (Computer program language) --- Database design --- SQL (Langage de programmation) --- Bases de données --- Conception --- Database design. --- Geografie --- Geografische Informatie Systemen --- Databanken. --- SQL (Computer program language). --- Bases de données