Bitemporal Data: Theory and Practice

0 avg rating
( 0 ratings by GoodReads )
 
9780124080676: Bitemporal Data: Theory and Practice

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.

"synopsis" may belong to another edition of this title.

Product Description:

Bitemporal 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 queries, without having to tell the DBMS how to carry them out. Bitemporal Data will qualify you to compare and contrast the bitemporal offerings from DBMS vendors. * Includes vendor-neutral explanations of bitemporal concepts and bitemporal functionality, and an unbiased review of the bitemporal offerings from the major DBMS vendors * Clarifies business user requests for temporal data by understanding what information bitemporal data provides that other kinds of data - such as data in non-temporal tables, history tables, data warehouses, or fact-dimension databases - do not provide * Explains the substantial increase in complexity between as-written temporal transactions and temporal queries, and the physical SQL activity required to carry out those temporal commands

About the Author:

Dr. Tom Johnston is the Chief Scientist at Asserted Versioning, LLC, which has developed a middleware product which supports the standard theory of bitemporal data, and which also implements the Asserted Versioning extensions to that standard theory. He is the co-author of Managing Time in Relational Databases (Morgan-Kaufmann, 2010). He lives in Atlanta, Georgia.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Johnston, Tom
Published by ELSEVIER SCIENCE TECHNOLOGY, United States (2014)
ISBN 10: 0124080677 ISBN 13: 9780124080676
New Paperback Quantity Available: 1
Seller
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description ELSEVIER SCIENCE TECHNOLOGY, United States, 2014. Paperback. Book Condition: New. 230 x 188 mm. Language: English . Brand New Book. 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. Bookseller Inventory # AAZ9780124080676

More Information About This Seller | Ask Bookseller a Question

Buy New
33.14
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

2.

Johnston, Tom
Published by Elsevier Science & Technology
ISBN 10: 0124080677 ISBN 13: 9780124080676
New Paperback Quantity Available: 4
Seller
THE SAINT BOOKSTORE
(Southport, United Kingdom)
Rating
[?]

Book Description Elsevier Science & Technology. Paperback. Book Condition: new. BRAND NEW, Bitemporal Data: Theory and Practice, Tom Johnston, 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. Bookseller Inventory # B9780124080676

More Information About This Seller | Ask Bookseller a Question

Buy New
29.29
Convert Currency

Add to Basket

Shipping: 5.94
From United Kingdom to U.S.A.
Destination, Rates & Speeds

3.

Johnston, Tom
Published by Elsevier Science & Technology 2014-08-20, San Francisco (2014)
ISBN 10: 0124080677 ISBN 13: 9780124080676
New paperback Quantity Available: 1
Seller
Blackwell's
(Oxford, OX, United Kingdom)
Rating
[?]

Book Description Elsevier Science & Technology 2014-08-20, San Francisco, 2014. paperback. Book Condition: New. Bookseller Inventory # 9780124080676

More Information About This Seller | Ask Bookseller a Question

Buy New
32.18
Convert Currency

Add to Basket

Shipping: 4.50
From United Kingdom to U.S.A.
Destination, Rates & Speeds

4.

Johnston, Tom
Published by ELSEVIER SCIENCE TECHNOLOGY, United States (2014)
ISBN 10: 0124080677 ISBN 13: 9780124080676
New Paperback Quantity Available: 1
Seller
The Book Depository US
(London, United Kingdom)
Rating
[?]

Book Description ELSEVIER SCIENCE TECHNOLOGY, United States, 2014. Paperback. Book Condition: New. 230 x 188 mm. Language: English . Brand New Book. 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. Bookseller Inventory # AAZ9780124080676

More Information About This Seller | Ask Bookseller a Question

Buy New
36.83
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

5.

Johnston, Tom
Published by Morgan Kaufmann (2014)
ISBN 10: 0124080677 ISBN 13: 9780124080676
New Quantity Available: 1
Seller
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description Morgan Kaufmann, 2014. PAP. Book Condition: New. New Book. Shipped from UK in 4 to 14 days. Established seller since 2000. Bookseller Inventory # GB-9780124080676

More Information About This Seller | Ask Bookseller a Question

Buy New
28.39
Convert Currency

Add to Basket

Shipping: 9
From United Kingdom to U.S.A.
Destination, Rates & Speeds

6.

Johnston, Tom
ISBN 10: 0124080677 ISBN 13: 9780124080676
New Paperback Quantity Available: 1
Seller
Ria Christie Collections
(Uxbridge, United Kingdom)
Rating
[?]

Book Description Paperback. Book Condition: New. Not Signed; 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 effectiv. book. Bookseller Inventory # ria9780124080676_rkm

More Information About This Seller | Ask Bookseller a Question

Buy New
36.72
Convert Currency

Add to Basket

Shipping: 3.34
From United Kingdom to U.S.A.
Destination, Rates & Speeds

7.

Johnston, Tom
Published by Morgan Kaufmann (2014)
ISBN 10: 0124080677 ISBN 13: 9780124080676
New Softcover First Edition Quantity Available: 1
Rating
[?]

Book Description Morgan Kaufmann, 2014. Book Condition: New. Num Pages: 400 pages, Approx. 170 illustrations. BIC Classification: UN. Category: (P) Professional & Vocational. Dimension: 186 x 235 x 17. Weight in Grams: 794. . 2014. 1st Edition. Paperback. . . . . . Bookseller Inventory # V9780124080676

More Information About This Seller | Ask Bookseller a Question

Buy New
40.42
Convert Currency

Add to Basket

Shipping: FREE
From Ireland to U.S.A.
Destination, Rates & Speeds

8.

Johnston, Tom
Published by Morgan Kaufmann
ISBN 10: 0124080677 ISBN 13: 9780124080676
New Softcover Quantity Available: 1
Seller
Kennys Bookstore
(Olney, MD, U.S.A.)
Rating
[?]

Book Description Morgan Kaufmann. Book Condition: New. Num Pages: 400 pages, Approx. 170 illustrations. BIC Classification: UN. Category: (P) Professional & Vocational. Dimension: 186 x 235 x 17. Weight in Grams: 794. . 2014. 1st Edition. Paperback. . . . . Books ship from the US and Ireland. Bookseller Inventory # V9780124080676

More Information About This Seller | Ask Bookseller a Question

Buy New
42.52
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

9.

Johnston, Tom
ISBN 10: 0124080677 ISBN 13: 9780124080676
New Quantity Available: 1
Seller
Bookshub
(Karol Bagh, India)
Rating
[?]

Book Description Book Condition: New. New. US edition. Perfect condition. Ship by express service to USA, Canada, Australia, France, Italy, UK, Germany and Netherland. Customer satisfaction our priority. Bookseller Inventory # ABE-190516-5834

More Information About This Seller | Ask Bookseller a Question

Buy New
42.78
Convert Currency

Add to Basket

Shipping: FREE
From India to U.S.A.
Destination, Rates & Speeds

10.

Johnston, Tom
ISBN 10: 0124080677 ISBN 13: 9780124080676
New Quantity Available: 1
Seller
EBOOKSTORE2010
(New Delhi, ND, India)
Rating
[?]

Book Description Book Condition: Brand New. New. US edition. Customer Satisfaction guaranteed!!. Bookseller Inventory # SHAK5834

More Information About This Seller | Ask Bookseller a Question

Buy New
42.82
Convert Currency

Add to Basket

Shipping: FREE
From India to U.S.A.
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book