000 05321cam a2200541Ii 4500
001 ocn889804287
003 OCoLC
005 20190328114808.0
006 m o d
007 cr cnu---unuuu
008 140902s2014 mau ob 001 0 eng d
040 _aOPELS
_beng
_erda
_epn
_cOPELS
_dUKMGB
_dUMI
_dE7B
_dN$T
_dDEBBG
_dDEBSZ
_dOCLCF
_dOCLCQ
_dU3W
_dD6H
_dCEF
_dOTZ
_dAU@
015 _aGBB497722
_2bnb
016 7 _a016863826
_2Uk
019 _a892421220
020 _a9780124080553
_q(electronic bk.)
020 _a0124080553
_q(electronic bk.)
020 _a0124080677
020 _a9780124080676
020 _z9780124080676
035 _a(OCoLC)889804287
_z(OCoLC)892421220
050 4 _aQA76.9.D3
_bF35 2014
072 7 _aCOM
_x021000
_2bisacsh
082 0 4 _a005.75/3
_223
100 1 _aJohnston, Tom,
_eauthor.
245 1 0 _aBitemporal data : theory and practice /
_h[electronic resource]
_cTom Johnston.
264 1 _aWaltham, MA :
_bMorgan Kaufmann,
_c2014.
300 _a1 online resource
336 _atext
_btxt
_2rdacontent
337 _acomputer
_bc
_2rdamedia
338 _aonline resource
_bcr
_2rdacarrier
588 0 _aPrint version record.
504 _aIncludes bibliographical references and index.
505 0 _aCover image; Title page; Table of Contents; Copyright; Dedication; Foreword; Preface; Perspectives on the Relational Paradigm of Data; The Temporal SQL Standards: ISO 9075:2011 and TSQL2; Audience; A Companion Volume to Managing Time in Relational Databases; An Extensive Glossary; A Note on Style; Looking Forward; Acknowledgments; Chapter 1. Bitemporal Data: Preliminaries; Nontemporal, Unitemporal and Bitemporal Data; Semantics and its Implementations; Glossary List; Part 1: Theory; Part 1. Theory; Chapter 2. Time and Temporal Terminology; Time; Temporal Terminology; Glossary List.
505 8 _aChapter 3. The Relational Paradigm: MathematicsTables and Columns; Columns and Domains; Cartesian Products; Functions and Primary Keys; Relations; Glossary List; Chapter 4. The Relational Paradigm: Logic; Propositional Logic; Predicate Logic; Logic and the Relational Paradigm; Glossary List; Chapter 5. The Relational Paradigm: Ontology; Types and Instances; Instances and Identity; The Relational Paradigm Ontology: Aristotelian Roots; The Relational Paradigm Ontology; On Using Ontologies; Integrating the Mathematics and Ontology of the Relational Paradigm; Glossary List.
505 8 _aChapter 6. The Relational Paradigm: SemanticsRows, Statements, Assertions and Kindred Notions; Rows, Inscriptions and Sentences; Statements; Speech Acts; Glossary List; Chapter 7. The Allen Relationships; Why the Allen Relationships are Important; A Taxonomy of the Allen Relationships; A Binary Partitioning of the Allen Relationships Taxonomy; An Allen Relationship Thought Experiment; Glossary List; Chapter 8. Temporal Integrity Concepts and Notations; Cubes, Slices and Cells: Data in Three-Dimensional Temporal Space; Semantically Anomalous Relational Tables; Implicit Bitemporal Time.
505 8 _aGlossary ListChapter 9. Temporal Entity Integrity; Entity Integrity; Bitemporal Entity Integrity; State-Time Entity Integrity; Conventional Entity Integrity; Glossary List; Chapter 10. Temporal Referential Integrity; Temporal Foreign Keys; Episodes; State-Time Referential Integrity; Bitemporal Referential Integrity; Conventional Referential Integrity; Glossary List; Part 2: Practice; Part 2. Practice; Chapter 11. Temporal Transactions; An Overview of Temporal Transactions; Basic Temporal Transactions on State-Time Tables; Basic Temporal Transactions on Bitemporal Tables.
505 8 _aWhenever Temporal TransactionsTemporal Merge Transactions; Glossary List; Chapter 12. Basic Temporal Queries; Temporal Query Syntax; Bitemporal Tables and Views; Point-In-Time Range Queries; Range Queries; Glossary List; Chapter 13. Advanced Temporal Queries; A Basic Temporal Range Multi-Table Query; A Complex Temporal Range Multi-Table Query; Why Temporal Range Multi-Table Queries are Complex; Glossary List; Chapter 14. Future Assertion Time; Future Assertion Time: Semantics; Future Assertion Time: Implementation; Glossary List; Chapter 15. Temporal Requirements.
520 _aBitemporal data is coming, and major database management systems are beginning to support it. You need to know what is going on ""under the hood"" and this book that will make you the expert on bitemporal data that every IT organization should have on its staff. There''s a lot more to bitemporal data than adding a second timestamp to history tables: for example, a temporal update of a single customer in a bitemporal customer table could require up to a dozen physical SQL transactions to complete. Vendors will eventually make it possible to write bitemporal transactions and bitemporal queri.
650 0 _aTemporal databases.
650 0 _aDatabase management.
650 7 _aCOMPUTERS
_xDatabase Management.
_2bisacsh
650 7 _aDatabase management.
_2fast
_0(OCoLC)fst00888037
650 7 _aTemporal databases.
_2fast
_0(OCoLC)fst01147471
655 4 _aElectronic books.
776 0 8 _iPrint version:
_aJohnstone, Tom.
_tBitemporal data
_z9780124080676
_w(DLC) 2014014129
_w(OCoLC)880374764
856 4 0 _3ScienceDirect
_uhttp://www.sciencedirect.com/science/book/9780124080676
999 _c246952
_d246952