Managing Time in Relational Databases: How to Design, Update and Query Temporal Data (Hardcover)

Managing Time in Relational Databases shows how to make the rich information content of bi-temporal data available to business users, while simplifying the design, maintenance and retrieval of that data. Metadata declarations eliminate the need to directly model temporal data. Temporal data maintenance is isolated in code that can be invoked to update bi-temporal data in any database and from any application program, across the enterprise. Anyone who can write queries against conventional data will be able to write queries against the bi-temporal data structures described in this book.

KEY FEATURES

1. Integrates an enterprise-wide viewpoint with a strong conceptual model of temporal data management allowing for realistic implementation of database application development.

2. Provides a true practical guide to the different possible methods of time-oriented databases with techniques of using existing funtionality to solve real world problems within an enterprise data architecture environment.

3. Written by IT professionals for IT professionals, this book employs a heavily example-driven approach which reinforces learning by showing the results of puting the techniques discussed into practice.

《在關聯式資料庫中管理時間》展示了如何使雙時間資料的豐富信息內容對業務用戶可用，同時簡化該資料的設計、維護和檢索。通過元數據聲明，消除了直接建模時間資料的需求。時間資料的維護被隔離在代碼中，可以被調用以在企業中的任何資料庫和應用程序中更新雙時間資料。任何能夠對常規資料進行查詢的人都能夠對本書中描述的雙時間資料結構進行查詢。

主要特點：

1. 將企業整體視角與時間資料管理的強大概念模型相結合，實現了實際的資料庫應用程序開發。

2. 提供了一個真正的實用指南，介紹了不同可能的時間導向資料庫方法，並介紹了在企業資料架構環境中使用現有功能解決現實世界問題的技術。

3. 本書由IT專業人士為IT專業人士撰寫，採用了大量的實例驅動方法，通過展示將討論的技術應用於實踐中的結果來加強學習。