Dependencies in Relational Databases

Dependencies in Relational Databases PDF Author: Bernhard Thalheim
Publisher: Vieweg+teubner Verlag
ISBN:
Category : Computers
Languages : en
Pages : 224

Get Book Here

Book Description

Dependencies in Relational Databases

Dependencies in Relational Databases PDF Author: Bernhard Thalheim
Publisher: Vieweg+teubner Verlag
ISBN:
Category : Computers
Languages : en
Pages : 224

Get Book Here

Book Description


Incomplete Data and Data Dependencies in Relational Databases

Incomplete Data and Data Dependencies in Relational Databases PDF Author: Sergio Greco
Publisher: Springer Nature
ISBN: 3031018931
Category : Computers
Languages : en
Pages : 111

Get Book Here

Book Description
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 Applications

Database Systems

Database Systems PDF Author: S. K. Singh
Publisher: Pearson Education India
ISBN: 9788131760925
Category : Database design
Languages : en
Pages : 954

Get Book Here

Book Description
The second edition of this bestselling title is a perfect blend of theoretical knowledge and practical application. It progresses gradually from basic to advance concepts in database management systems, with numerous solved exercises to make learning easier and interesting. New to this edition are discussions on more commercial database management systems.

Database Design and Relational Theory

Database Design and Relational Theory PDF Author: C. J. Date
Publisher: "O'Reilly Media, Inc."
ISBN: 1449328016
Category : Computers
Languages : en
Pages : 277

Get Book Here

Book Description
Because databases often stay in production for decades, careful design is critical to making the database serve the needs of your users over years, and to avoid subtle errors or performance problems. In this book, C.J. Date, a leading exponent of relational databases, lays out the principles of good database design.

Dependencies in Relational Databases

Dependencies in Relational Databases PDF Author:
Publisher: Springer-Verlag
ISBN: 366312018X
Category : Technology & Engineering
Languages : de
Pages : 223

Get Book Here

Book Description


A Guided Tour of Relational Databases and Beyond

A Guided Tour of Relational Databases and Beyond PDF Author: Mark Levene
Publisher: Springer Science & Business Media
ISBN: 0857293494
Category : Computers
Languages : en
Pages : 632

Get Book Here

Book Description
Addressing important extensions of the relational database model, including deductive, temporal, and object-oriented databases, this book provides an overview of database modeling with the Entity-Relationship (ER) model and the relational model. The book focuses on the primary achievements in relational database theory, including query languages, integrity constraints, database design, computable queries, and concurrency control. This reference will shed light on the ideas underlying relational database systems and the problems that confront database designers and researchers.

Foundations of Information and Knowledge Systems

Foundations of Information and Knowledge Systems PDF Author: Andreas Herzig
Publisher: Springer Nature
ISBN: 3030399516
Category : Mathematics
Languages : en
Pages : 352

Get Book Here

Book Description
This book constitutes the refereed proceedings of the 11th International Symposium on Foundations of Information and Knowledge Systems, FoIKS 2020, held in Dortmund, Germany, in February 2020. The 19 revised full papers presented were carefully reviewed and selected from 33 submissions. The papers address various topics such as big data; database design; dynamics of information; information fusion; integrity and constraint management; intelligent agents; knowledge discovery and information retrieval; knowledge representation, reasoning and planning; logics in databases and AI; mathematical foundations; security in information and knowledge systems; semi-structured data and XML; social computing; the semantic web and knowledge management; and the world wide web.​

The Structure of the Relational Database Model

The Structure of the Relational Database Model PDF Author: Jan Paredaens
Publisher: Springer Science & Business Media
ISBN: 3642699561
Category : Computers
Languages : en
Pages : 242

Get Book Here

Book Description
This book presents an overview of the most fundamental aspects of the theory that underlies the Relational Database Model. As such it is self-contained though experience with formal models and abstract data manipulating on the one hand and with the practical use of a relational system on the other hand can help the reader. Such experience will offer the reader a better understanding of and a motivation for the different concepts, theories and results mentioned in the book. We have focussed on the most basic concepts and aspects of the relational model, without trying to give a complete overview of the state of the art of database theory. Recently a lot of books on databases in general and on the relational model in particular have been published. Most of them describe the use of database systems. 'Some clarify how information has to be structured and organized before it can be used to build applications. Others help the user in writing down his applications or in finding tricky ways to optimize the running time or the necessary space. Another category of books treat more fundamental and more general aspects such as the description of the relational model, independent of any implementation, the decomposition in normal forms or the global design of distributed databases. Few, however, are the books that describe in a formal way some of the subjects mentioned above.

Principles of Database Management

Principles of Database Management PDF Author: Wilfried Lemahieu
Publisher: Cambridge University Press
ISBN: 1107186129
Category : Computers
Languages : en
Pages : 817

Get Book Here

Book Description
Introductory, theory-practice balanced text teaching the fundamentals of databases to advanced undergraduates or graduate students in information systems or computer science.

Improving data quality in relational databases

Improving data quality in relational databases PDF Author: Tennyson X. Chen
Publisher: RTI Press
ISBN:
Category : Computers
Languages : en
Pages : 20

Get Book Here

Book Description
The traditional vertical decomposition methods in relational database normalization fail to prevent common data anomalies. Although a database may be highly normalized, the quality of the data stored in this database may still deteriorate because of potential data anomalies. In this paper, we first discuss why practitioners need to further improve their databases after they apply the traditional normalization methods, because of the existence of functional entanglement, a phenomenon we defined. We outline two methods for identifying functional entanglements in a normalized database as the first step toward data quality improvement. We then analyze several practical methods for preventing common data anomalies by eliminating and restricting the effects of functional entanglements. The goal of this paper is to reveal shortcomings of the traditional database normalization methods with respect to the prevention of common data anomalies, and offer practitioners useful techniques for improving data quality.