Parallel Handling of Integrity Constraints
@inproceedings{Grefen1990ParallelHO, title={Parallel Handling of Integrity Constraints}, author={Paul Grefen and Jan Flokstra}, booktitle={PRISMA Workshop}, year={1990} }
Integrity constraints form an important part of a data model. Therefore, a complete integrity constraint handling subsystem is considered an important part of any modern DBMS. In implementing an integrity constraint handling subsystem, there are two major problem areas: providing enough functionality and delivering good performance in constraint enforcement. In the PRISMA project, an integrity constraint handling subsystem for a relational DBMS is developed, that meets both requirements…
4 Citations
Integrity Control in Relational Database Systems - An Overview
- Computer ScienceData Knowl. Eng.
- 1993
The Development of a Semantic Integrity Constraint Subsystem for a Distributed Database
- Computer ScienceBNCOD
- 1996
A two level approach where constraint validation can be performed before or after an update is made, and the algorithm proposed by [NIC82] to generate post-tests and modify it to generate pre-tests which allow the initial constraints to be checked locally.
A Strategy for Semantic Integrity Enforcement in a Parallel Database Machine
- Computer ScienceBNCOD
- 1994
A theorem-proving method is used for deriving integrity tests to prove the integrity of the database which takes into account knowledge about the transaction, the partitioning strategy, and the truth of all constraints in the initial database state.
SICSDD: Techniques and Implementation
- Computer ScienceCDB
- 1997
The constituent techniques and the implementation of a semantic integrity subsystem for a distributed database (SICSDD) provides complete functionality and an efficient strategy for constraint enforcement.
References
SHOWING 1-10 OF 35 REFERENCES
Parallel handling of integrity constraints on fragmented relations
- Computer Science[1990] Proceedings. Second International Symposium on Databases in Parallel and Distributed Systems
- 1990
It is shown how integrity constraints formulated in terms of global relations can be translated into a fragmented form in the PRISMA DBMS.
Implementation of integrity constraints and views by query modification
- Computer ScienceSIGMOD '75
- 1975
The mechanism being implemented in one relational system to prevent integrity violations which can result from improper updates by a process is indicated.
Implementing PRISMA/DB in an OOPL
- Computer ScienceIWDM
- 1989
From this approach, it is hoped to gain a better understanding of parallelism, which can be used to enhance the performance of PRISMA/DB.
A Distributed, Main-Memory Database Machine
- Computer ScienceIWDM
- 1987
The PRISMA database machine is a distributed, main-memory database management system implemented in an object-oriented language that runs on top of a large message-passing multi-computer system.
Constraint Equations: Declarative Expression of Constraints With Automatic Enforcement
- Computer ScienceVLDB
- 1984
Algebraic rules for symbolic manipulation of these Equations allow derivation of new Equations and their logical consequences from existing Equations, according to the algorithms presented here.
PRISMA Database Machine: A Distributed, Main-Memory Approach
- Computer ScienceEDBT
- 1988
The PRISMA database machine is a distributed, main-memory database management system implemented in an object-oriented language that runs on top of a multi-computer system.
Pipelining in query execution
- Computer ScienceProceedings. PARBASE-90: International Conference on Databases, Parallel Architectures, and Their Applications
- 1990
It is shown that the use of an adjusted algorithm can improve the performance of a nested query execution containing join operations. Apart from the equijoin, the union, Cartesian product, Theta…
Referential Integrity
- Computer ScienceVLDB
- 1981
The problem of referential integrity is discussed and a proposal for dealing with it in a relational framework is described in some detail. The proposal is consistent with a more general integrity…
An Introduction to Database Systems
- Computer Science
- 1975
Readers of this book will gain a strong working knowledge of the overall structure, concepts, and objectives of database systems and will become familiar with the theoretical principles underlying the construction of such systems.
DOOM: A Decentralized Object-Oriented Machine
- Computer ScienceIEEE Micro
- 1987
Research into the potentials and problems of parallelism led to a new programming language and supportive parallel operating system and architecture. Studies continue on a 100-node prototype.