Bitemporal Data

Theory and Practice

Nonfiction, Computers, Database Management, Programming, Programming Languages, General Computing
Cover of the book Bitemporal Data by Tom Johnston, Elsevier Science
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Tom Johnston ISBN: 9780124080553
Publisher: Elsevier Science Publication: August 19, 2014
Imprint: Morgan Kaufmann Language: English
Author: Tom Johnston
ISBN: 9780124080553
Publisher: Elsevier Science
Publication: August 19, 2014
Imprint: Morgan Kaufmann
Language: English

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
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

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.

More books from Elsevier Science

Cover of the book Multilingual Information Management by Tom Johnston
Cover of the book Pregnancy and Parturition by Tom Johnston
Cover of the book Advances in Cellular Neurobiology by Tom Johnston
Cover of the book Structural and Evolutionary Genomics by Tom Johnston
Cover of the book Statistical Postprocessing of Ensemble Forecasts by Tom Johnston
Cover of the book Obesity by Tom Johnston
Cover of the book Natural Gas Hydrates in Flow Assurance by Tom Johnston
Cover of the book Advances in Physical Organic Chemistry by Tom Johnston
Cover of the book Propagating Insight: A Tribute to the Works of Yngve Ohrn by Tom Johnston
Cover of the book Recent Progress in Hormone Research by Tom Johnston
Cover of the book Current Topics in Experimental Endocrinology by Tom Johnston
Cover of the book The Science of the Cold Fusion Phenomenon by Tom Johnston
Cover of the book Improving the Safety and Quality of Eggs and Egg Products by Tom Johnston
Cover of the book Encyclopedia of Quaternary Science by Tom Johnston
Cover of the book Nutrition Economics by Tom Johnston
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy