The Problem of Incomplete Information in Relational Databases [electronic resource] / edited by Gösta Grahne.

Contributor(s): Grahne, Gösta [editor.] | SpringerLink (Online service)Material type: TextTextSeries: Lecture Notes in Computer Science ; 554Publisher: Berlin, Heidelberg : Springer Berlin Heidelberg, 1991Description: VIII, 164 p. online resourceContent type: text Media type: computer Carrier type: online resourceISBN: 9783540465072Subject(s): Computer science | Computer software | Database management | Artificial intelligence | Computer Science | Database Management | Algorithm Analysis and Problem Complexity | Artificial Intelligence (incl. Robotics)Additional physical formats: Printed edition:: No titleDDC classification: 005.74 LOC classification: QA76.9.D3Online resources: Click here to access online
Contents:
Relational databases -- Semantic aspects of incomplete information -- Syntactic and algorithmic aspects of incomplete information -- Computational complexity aspects of incomplete information -- Some conclusive aspects.
In: Springer eBooksSummary: In a relational database the information is recorded as rows in tables. However, in many practical situations the available information is incomplete and the values for some columns are missing. Yet few existing database management systems allow the user to enter null values in the database. This monograph analyses the problems raised by allowing null values in relational databases. The analysis covers semantical, syntactical, and computational aspects. Algorithms for query evaluation, dependency enforcement and updates in the presence of null values are also given. The analysis of the computational complexity of the algorithms suggests that from a practical point of view the database should be stored as Horn tables, which are generalizations of ordinary relations, allowing null values and Horn clause-like restrictions on these null values. Horn tables efficiently support a large class of queries, dependencies and updates.
Item type: E-BOOKS
Tags from this library: No tags from this library for this title. Log in to add tags.
    Average rating: 0.0 (0 votes)
Current library Home library Call number Materials specified URL Status Date due Barcode
IMSc Library
IMSc Library
Link to resource Available EBK5808

Relational databases -- Semantic aspects of incomplete information -- Syntactic and algorithmic aspects of incomplete information -- Computational complexity aspects of incomplete information -- Some conclusive aspects.

In a relational database the information is recorded as rows in tables. However, in many practical situations the available information is incomplete and the values for some columns are missing. Yet few existing database management systems allow the user to enter null values in the database. This monograph analyses the problems raised by allowing null values in relational databases. The analysis covers semantical, syntactical, and computational aspects. Algorithms for query evaluation, dependency enforcement and updates in the presence of null values are also given. The analysis of the computational complexity of the algorithms suggests that from a practical point of view the database should be stored as Horn tables, which are generalizations of ordinary relations, allowing null values and Horn clause-like restrictions on these null values. Horn tables efficiently support a large class of queries, dependencies and updates.

There are no comments on this title.

to post a comment.
The Institute of Mathematical Sciences, Chennai, India

Powered by Koha