Incomplete Data and Data Dependencies in Relational Databases

Incomplete Data and Data Dependencies in Relational Databases

4.11 - 1251 ratings - Source

The chase has long been used as a central tool to analyze dependencies and their effect on queries. It has been applied to different relevant problems in database theory such as query optimization, query containment and equivalence, dependency implication, and database schema design. Recent years have seen a renewed interest in the chase as an important tool in several database applications, such as data exchange and integration, query answering in incomplete data, and many others. It is well known that the chase algorithm might be non-terminating and thus, in order for it to find practical applicability, it is crucial to identify cases where its termination is guaranteed. Another important aspect to consider when dealing with the chase is that it can introduce null values into the database, thereby leading to incomplete data. Thus, in several scenarios where the chase is used the problem of dealing with data dependencies and incomplete data arises. This book discusses fundamental issues concerning data dependencies and incomplete data with a particular focus on the chase and its applications in different database areas. We report recent results about the crucial issue of identifying conditions that guarantee the chase termination. Different database applications where the chase is a central tool are discussed with particular attention devoted to query answering in the presence of data dependencies and database schema design. Table of Contents: Introduction / Relational Databases / Incomplete Databases / The Chase Algorithm / Chase Termination / Data Dependencies and Normal Forms / Universal Repairs / Chase and Database ApplicationsIntuitively, a repair of an inconsistent database I is a consistent database J that differs from I in a a€œminimala€ way. ... 1999, Caroprese et al., 2009, Chomicki and Marcinkowski, 2005, Flesca et al., 2010, Grahne and Onet, 2010, Greco et al., 2003, anbsp;...

Title:Incomplete Data and Data Dependencies in Relational Databases
Author:Segio Greco, Cristian Molinaro, Francesca Spezzano
Publisher:Morgan & Claypool Publishers - 2012-08-15


You Must CONTINUE and create a free account to access unlimited downloads & streaming