Welcome to P K Kelkar Library, Online Public Access Catalogue (OPAC)

Normal view MARC view ISBD view

Incomplete data and data dependencies in relational databases

By: Greco, Sergio.
Contributor(s): Molinaro, Cristian | Spezzano, Francesca.
Material type: materialTypeLabelBookSeries: Synthesis digital library of engineering and computer science: ; Synthesis lectures on data management: # 29.Publisher: San Rafael, Calif. (1537 Fourth Street, San Rafael, CA 94901 USA) : Morgan & Claypool, c2012Description: 1 electronic text (xi, 111 p.) : ill., digital file.ISBN: 9781608459278 (electronic bk.).Subject(s): Relational databases | Querying (Computer science) | Data mining | Database design | incomplete databases | inconsistent databases | data dependencies | chase algorithm | consistent query answersDDC classification: 005.7565 Online resources: Abstract with links to resource Also available in print.
Contents:
1. Introduction --
2. Relational databases -- 2.1 Relational model -- 2.2 Query languages -- 2.2.1 Relational algebra -- 2.2.2 Relational calculus -- 2.2.3 Domain independent and safe RC queries -- 2.2.4 Datalog -- 2.3 Conjunctive queries --
3. Incomplete databases -- 3.1 Incomplete databases -- 3.2 Representation systems -- 3.3 Nulls in SQL --
4. The chase algorithm -- 4.1 Data dependencies -- 4.2 Universal solutions and query answers -- 4.3 Dependency skolemization -- 4.4 Standard chase algorithm -- 4.5 Oblivious chase -- 4.6 Core chase -- 4.7 Comparison among chase algorithms --
5. Chase termination -- 5.1 Chase termination criteria -- 5.2 Relationship among chase termination conditions -- 5.3 Constraint rewriting --
6. Data dependencies and normal forms -- 6.1 Basic notations and terminology -- 6.2 Functional dependencies -- 6.3 Multivalued dependencies -- 6.4 Join dependencies -- 6.5 Decompositions -- 6.6 Normal forms -- 6.7 Chasing with FDs and JDs --
7. Universal repairs -- 7.1 Universal repairs -- 7.2 Special classes of dependencies -- 7.2.1 LAV -- 7.2.2 GAV -- 7.2.3 Terminating dependencies --
8. Chase and database applications -- 8.1 Query containment under constraints -- 8.2 Query optimization -- 8.3 Data exchange -- 8.4 Data integration -- 8.5 Query answering on incomplete data --
Bibliography -- Authors' biographies.
Abstract: 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.
    average rating: 0.0 (0 votes)
Item type Current location Call number Status Date due Barcode Item holds
E books E books PK Kelkar Library, IIT Kanpur
Available EBKE430
Total holds: 0

Mode of access: World Wide Web.

System requirements: Adobe Acrobat Reader.

Part of: Synthesis digital library of engineering and computer science.

Series from website.

Includes bibliographical references (p. 97-110).

1. Introduction --

2. Relational databases -- 2.1 Relational model -- 2.2 Query languages -- 2.2.1 Relational algebra -- 2.2.2 Relational calculus -- 2.2.3 Domain independent and safe RC queries -- 2.2.4 Datalog -- 2.3 Conjunctive queries --

3. Incomplete databases -- 3.1 Incomplete databases -- 3.2 Representation systems -- 3.3 Nulls in SQL --

4. The chase algorithm -- 4.1 Data dependencies -- 4.2 Universal solutions and query answers -- 4.3 Dependency skolemization -- 4.4 Standard chase algorithm -- 4.5 Oblivious chase -- 4.6 Core chase -- 4.7 Comparison among chase algorithms --

5. Chase termination -- 5.1 Chase termination criteria -- 5.2 Relationship among chase termination conditions -- 5.3 Constraint rewriting --

6. Data dependencies and normal forms -- 6.1 Basic notations and terminology -- 6.2 Functional dependencies -- 6.3 Multivalued dependencies -- 6.4 Join dependencies -- 6.5 Decompositions -- 6.6 Normal forms -- 6.7 Chasing with FDs and JDs --

7. Universal repairs -- 7.1 Universal repairs -- 7.2 Special classes of dependencies -- 7.2.1 LAV -- 7.2.2 GAV -- 7.2.3 Terminating dependencies --

8. Chase and database applications -- 8.1 Query containment under constraints -- 8.2 Query optimization -- 8.3 Data exchange -- 8.4 Data integration -- 8.5 Query answering on incomplete data --

Bibliography -- Authors' biographies.

Abstract freely available; full-text restricted to subscribers or individual document purchasers.

Compendex

INSPEC

Google scholar

Google book search

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.

Also available in print.

Title from PDF t.p. (viewed on August 17, 2012).

There are no comments for this item.

Log in to your account to post a comment.

Powered by Koha