Bitemporal Data: Theory and Practice (Paperback)
暫譯: 雙時態資料:理論與實務 (平裝本)

Tom Johnston

  • 出版商: Morgan Kaufmann
  • 出版日期: 2014-08-20
  • 定價: $2,100
  • 售價: 8.5$1,785
  • 語言: 英文
  • 頁數: 400
  • 裝訂: Paperback
  • ISBN: 0124080677
  • ISBN-13: 9780124080676
  • 相關分類: OracleSQL資料庫
  • 立即出貨 (庫存 < 4)

商品描述

Bitemporal data has always been important. But it was not until 2011 that the ISO released a SQL standard that supported it. Currently, among major DBMS vendors, Oracle, IBM and Teradata now provide at least some bitemporal functionality in their flagship products. But to use these products effectively, someone in your IT organization needs to know more than how to code bitemporal SQL statements. Perhaps, in your organization, that person is you.

To correctly interpret business requests for temporal data, to correctly specify requirements to your IT development staff, and to correctly design bitemporal databases and applications, someone in your enterprise needs a deep understanding of both the theory and the practice of managing bitemporal data. Someone also needs to understand what the future may bring in the way of additional temporal functionality, so their enterprise can plan for it. Perhaps, in your organization, that person is you.

This is the book that will show the do-it-yourself IT professional how to design and build bitemporal databases and how to write bitemporal transactions and queries, and will show those who will direct the use of vendor-provided bitemporal DBMSs exactly what is going on "under the covers" of that software.

  • Explains the business value of bitemporal data in terms of the information that can be provided by bitemporal tables and not by any other form of temporal data, including history tables, version tables, snapshot tables, or slowly-changing dimensions.
  • Provides an integrated account of the mathematics, logic, ontology and semantics of relational theory and relational databases, in terms of which current relational theory and practice can be seen as unnecessarily constrained to the management of nontemporal and incompletely temporal data.
  • Explains how bitemporal tables can provide the time-variance and nonvolatility hitherto lacking in Inmon historical data warehouses.
  • Explains how bitemporal dimensions can replace slowly-changing dimensions in Kimball star schemas, and why they should do so.
  • Describes several extensions to the current theory and practice of bitemporal data, including the use of episodes, "whenever" temporal transactions and queries, and future transaction time.
  • Points out a basic error in the ISO's bitemporal SQL standard, and warns practitioners against the use of that faulty functionality. Recommends six extensions to the ISO standard which will increase the business value of bitemporal data.
  • Points towards a tritemporal future for bitemporal data, in which an Aristotelian ontology and a speech-act semantics support the direct management of the statements inscribed in the rows of relational tables, and add the ability to track the provenance of database content to existing bitemporal databases.

This book also provides the background needed to become a business ontologist, and explains why an IT data management person, deeply familiar with corporate databases, is best suited to play that role. Perhaps, in your organization, that person is you.

商品描述(中文翻譯)

雙時態數據一直以來都非常重要。但直到2011年,ISO才發布了支持雙時態的SQL標準。目前,在主要的資料庫管理系統(DBMS)供應商中,Oracle、IBM和Teradata的旗艦產品至少提供了一些雙時態功能。但要有效使用這些產品,您IT組織中的某個人需要了解的不僅僅是如何編寫雙時態SQL語句。也許,在您的組織中,那個人就是您。

為了正確解釋業務對時態數據的請求,正確向您的IT開發人員指定需求,以及正確設計雙時態數據庫和應用程序,您企業中的某個人需要對管理雙時態數據的理論和實踐有深入的理解。還需要有人了解未來可能帶來的額外時態功能,以便他們的企業能夠為此做好規劃。也許,在您的組織中,那個人就是您。

這本書將向自助的IT專業人士展示如何設計和構建雙時態數據庫,以及如何編寫雙時態交易和查詢,並將向那些指導使用供應商提供的雙時態DBMS的人展示該軟件“幕後”的運作情況。


  • 解釋雙時態數據的商業價值,特別是雙時態表所能提供的信息,而這些信息是其他任何形式的時態數據(包括歷史表、版本表、快照表或緩慢變化的維度)所無法提供的。

  • 提供關於關聯理論和關聯數據庫的數學、邏輯、本體論和語義的綜合說明,從而使當前的關聯理論和實踐被視為不必要地限制於管理非時態和不完全時態數據。

  • 解釋雙時態表如何提供Inmon歷史數據倉庫中缺乏的時間變異性和非波動性。

  • 解釋雙時態維度如何取代Kimball星型架構中的緩慢變化維度,以及為什麼應該這樣做。

  • 描述對當前雙時態數據理論和實踐的幾個擴展,包括使用事件、“隨時”時態交易和查詢,以及未來交易時間。

  • 指出ISO的雙時態SQL標準中的一個基本錯誤,並警告從業者避免使用該有缺陷的功能。建議對ISO標準進行六項擴展,以提高雙時態數據的商業價值。

  • 指向雙時態數據的三時態未來,其中亞里士多德本體論和言語行為語義支持直接管理關聯表中所記錄的語句,並為現有的雙時態數據庫增加追蹤數據庫內容來源的能力。

這本書還提供了成為商業本體論者所需的背景,並解釋了為什麼對企業數據庫非常熟悉的IT數據管理人員最適合擔任這一角色。也許,在您的組織中,那個人就是您。