Artboard 33Artboard 16Artboard 18Artboard 13Artboard 42Artboard 21Artboard 4Artboard 5Artboard 45Artboard 22Artboard 7Artboard 42Artboard 23Artboard 12Artboard 28Artboard 17?Artboard 28Artboard 43Artboard 49Artboard 47Artboard 15Artboard 32Artboard 6Artboard 22Artboard 5Artboard 25Artboard 1Artboard 42Artboard 11Artboard 41Artboard 11Artboard 23Artboard 10Artboard 4Artboard 9Artboard 6Artboard 8Artboard 7Artboard 3Artboard 12Artboard 25Artboard 34Artboard 43Artboard 44Artboard 16Artboard 24Artboard 13Artboard 5Artboard 24Artboard 31Artboard 1Artboard 12Artboard 27Artboard 30Artboard 36Artboard 44Artboard 9Artboard 17Artboard 6Artboard 27Artboard 30Artboard 29Artboard 26Artboard 2Artboard 20Artboard 35Artboard 15Artboard 14Artboard 50Artboard 26Artboard 14Artboard 40Artboard 21Artboard 10Artboard 37Artboard 46Artboard 33Artboard 8

Managing Time in Databases - A Comprehensive Approach (Cód: 3438842)

JOHNSTON,TOM; Weis, Randall


Ooops! Este produto não está mais a venda.
Mas não se preocupe, temos uma versão atualizada para você.

Ooopss! Este produto está fora de linha, mas temos outras opções para você.
Veja nossas sugestões abaixo!

R$ 212,60

em até 7x de R$ 30,37 sem juros


Em até 1x sem juros de

Cartão Saraiva:


Em até 7x sem juros de

Managing Time in Databases - A Comprehensive Approach



This book presents a comprehensive view of how to manage a temporal database. Temporal data management refers to an integrated method of managing data about the past, present, and future of the objects and events of interest to the user. That is, managing non-current data in relational databases in such a way that past data can be seamlessly accessed together with current data with result sets containing both current and non-current data that can be retrieved with queries simple enough for a business user to write and with result set response times very close to those for result sets containing current data only.

For example, let'apos;s say that from July through August of last year we had on our database a row stating that the unit cost of a product was $25.50 during the first quarter of that year. But in September, we realized that we had made a mistake and that the unit cost was actually $23.50. End users need the ability to issue a query which can tell them both what the unit cost really was in the first quarter of last year and also a query which can tell them what they said the first-quarter unit cost was last July.

The practical and comprehensive nature of this material is demonstrated in each chapter by a mixture of diagrams and text typical for a book about data architecture and data models. The chapters dealing specifically with managing temporal and bi-temporal data will rely heavily on an example-driven approach, each example presenting specific real-world scenarios. Each scenario is structured around (a) a before-image of a sample table or tables; (b) a bi-temporal timeline graphic; (c) a specific bi-temporal transaction; and (d) one or more snapshots of the sample table or tables, showing the results of applying each transaction. (Bi-temporal relational data is temporarily delimited into two dimensions, i.e., valid time and transaction time.)

For example, a hedge fund company needs to bi-temporally manage a lot of their econometric data because GDP, CPI and the many other data sources they use have scheduled releases, then followed up by one or more revisions later on. Such data describes (a) what the economy was like during a specific time period (valid time) and (b) a series of corrections to prior releases of that data (transaction time).

Value proposition: This book presents a simplified approach to managing temporal and bi-temporal data that reduces the complexity of data queries and transactions making inserts, updates and deletes simple enough that anyone who could write them against non-temporal tables could also write them against temporal tables. This is accomplished by developing declarative specifications that replace time-intensive design work for data modelers who must incorporate temporal semantics into their work. In this way, query complexity is minimized. It allows the database designer to situate this special kind of temporal data management in the context of an enterprise data architecture, together with other ways of managing non-current data.


1. Integrates an enterprise-wide viewpoint with a strong conceptual model of temporal data management allowing for realistic implementation of database application development.

2. Provides 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.

3. Written 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.


Peso 0.00 Kg
Produto sob encomenda Não
Número de Páginas 512 (aproximado)
Idioma 337
Acabamento e-book
Territorialidade Internacional
Formato Livro Digital Epub
Gratuito Não
Proteção Drm Sim
Tamanho do Arquivo 5707
Início da Venda 19/08/2010
Código do Formato Epub
Cód. Barras 9780080963372
Ano da Publicação 110
AutorJOHNSTON,TOM; Weis, Randall