Developing Time-Oriented Database Applications in SQL


Автор: Snodgrass R.T.
Издательство: Morgan Kaufmann

Год: 2000
Страниц: 544
Язык: английский
Формат: pdf
ISBN: 

 


Аннотация:

 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.

 

Скачать книгу из интернета:

Вас заинтересует / Intresting for you:

SQL для чайников
SQL для чайников 5638 просмотров Алексей Вятский Tue, 21 Nov 2017, 13:26:01
Redis Essentials
Redis Essentials 826 просмотров Алексей Вятский Mon, 05 Aug 2019, 05:41:13
T-SQL Fundamentals - 3rd Editi...
T-SQL Fundamentals - 3rd Editi... 1674 просмотров Алексей Вятский Mon, 05 Aug 2019, 05:39:41
MySQL Explained: Your Step By ...
MySQL Explained: Your Step By ... 1229 просмотров Алексей Вятский Sun, 04 Aug 2019, 11:57:44
Войдите чтобы комментировать