{"product_id":"9780080963372","title":"Managing Time in Relational Databases: How to Design, Update and Query Temporal Data","description":"\u003cp\u003e\u003ci\u003eManaging Time in Relational Databases: How to Design, Update and Query Temporal Data\u003c\/i\u003e introduces basic concepts that will enable businesses to develop their own framework for managing temporal data. It discusses the management of uni-temporal and bi-temporal data in relational databases, so that they can be seamlessly accessed together with current data; the encapsulation of temporal data structures and processes; ways to implement temporal data management as an enterprise solution; and the internalization of pipeline datasets. \u003c\/p\u003e \u003cp\u003eThe book is organized into three parts. Part 1 traces the history of temporal data management and presents a taxonomy of bi-temporal data management methods. Part 2 provides an introduction to Asserted Versioning, covering the origins of Asserted Versioning; core concepts of Asserted Versioning; the schema common to all asserted version tables, as well as the various diagrams and notations used in the rest of the book; and how the basic scenario works when the target of that activity is an asserted version table. Part 3 deals with designing, maintaining, and querying asserted version databases. It discusses the design of Asserted Versioning databases; temporal transactions; deferred assertions and other pipeline datasets; Allen relationships; and optimizing Asserted Versioning databases. \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eIntegrates an enterprise-wide viewpoint with a strong conceptual model of temporal data management allowing for realistic implementation of database application development.\u003c\/li\u003e\n\u003cli\u003eProvides 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.\u003c\/li\u003e\n\u003cli\u003eWritten 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. \u003c\/li\u003e\n\u003c\/ul\u003e","brand":"Elsevier Science","offers":[{"title":"Default Title","offer_id":47079418691824,"sku":"9780080963372","price":72.95,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9780080963372_p0.jpg?v=1763638956","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9780080963372","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}