Development of an assertion model of integrity constraints in object-oriented databases

Object-Oriented Databases (OODBs) have been designed to support large and complex programming projects. The data accuracy, consistency, and integrity in OODBs are extremely important for developers and users. Checking the integrity constraints in OODBs is a fundamental problem in database design...

Full description

Saved in:
Bibliographic Details
Main Author: Zaqaibeh, Belal Mohammad
Format: Thesis
Language:English
English
Published: 2006
Subjects:
Online Access:http://psasir.upm.edu.my/id/eprint/8714/1/FSKTM_2006_11%20IR.pdf
http://psasir.upm.edu.my/id/eprint/8714/
Tags: Add Tag
No Tags, Be the first to tag this record!
id my.upm.eprints.8714
record_format eprints
spelling my.upm.eprints.87142023-12-28T03:05:39Z http://psasir.upm.edu.my/id/eprint/8714/ Development of an assertion model of integrity constraints in object-oriented databases Zaqaibeh, Belal Mohammad Object-Oriented Databases (OODBs) have been designed to support large and complex programming projects. The data accuracy, consistency, and integrity in OODBs are extremely important for developers and users. Checking the integrity constraints in OODBs is a fundamental problem in database design. Existing OODB Management Systems (OODBMSs) lack to a capability of an ad-hoc declarative specification of enforcing and maintaining integrity constraints that are appeared among attributes in association, composition, and inheritance hierarchies' relationships. A critical problem in the existing OODBs is that they cannot support User-Defmed Constraints (UDCs) that can be defmed in classes with composition (logical or physical composition) and inherence (single or mUltiple inheritance) hierarchies. Integrity constraints in the current OODBMSs are maintained either by disallowing and rolling back transaction or modifying operations that may produce a violation. The constraints must be maintained in the backward direction along the class composition hierarchy as well as in the forward direction. In this work an Assertion Model of Integrity Constraints (AMIC) is proposed. The AMIC keeps the derivation path along with the attributes' relationships that are derived from association, composition, and inheritance hierarchies. The AMIC techniques are designed to implement the needed functions that are collecting the attributes' relationships and checking the integrity constraints. Moreover, AMIC keeps UDCs with their relationships in both single classes and multilevel classes (intra-class and inter-class). Furthermore, the AMIC can maintain constraints in a single object and a set of distributed objects (intra-object and inter-object). Therefore, this makes the new model extendable and can be integrated with any existing constraints' service. A new technique called Detection Method (DM) isdesigned to check the Object Meta Data (OMD) to detect the constraints violation before it occurs. The AMIC is designed for both Centralized Integrity Maintenance (CIM) and Application-Oriented Integrity Maintenance (AOIM). The AMIC can also enforce and maintain structural and logical integrity constraints, in addition to enforce and maintain redundant, inconsistent, and duplicate constraints. 2006-06 Thesis NonPeerReviewed text en http://psasir.upm.edu.my/id/eprint/8714/1/FSKTM_2006_11%20IR.pdf Zaqaibeh, Belal Mohammad (2006) Development of an assertion model of integrity constraints in object-oriented databases. Doctoral thesis, Universiti Putra Malaysia. Object-oriented databases Database design English
institution Universiti Putra Malaysia
building UPM Library
collection Institutional Repository
continent Asia
country Malaysia
content_provider Universiti Putra Malaysia
content_source UPM Institutional Repository
url_provider http://psasir.upm.edu.my/
language English
English
topic Object-oriented databases
Database design
spellingShingle Object-oriented databases
Database design
Zaqaibeh, Belal Mohammad
Development of an assertion model of integrity constraints in object-oriented databases
description Object-Oriented Databases (OODBs) have been designed to support large and complex programming projects. The data accuracy, consistency, and integrity in OODBs are extremely important for developers and users. Checking the integrity constraints in OODBs is a fundamental problem in database design. Existing OODB Management Systems (OODBMSs) lack to a capability of an ad-hoc declarative specification of enforcing and maintaining integrity constraints that are appeared among attributes in association, composition, and inheritance hierarchies' relationships. A critical problem in the existing OODBs is that they cannot support User-Defmed Constraints (UDCs) that can be defmed in classes with composition (logical or physical composition) and inherence (single or mUltiple inheritance) hierarchies. Integrity constraints in the current OODBMSs are maintained either by disallowing and rolling back transaction or modifying operations that may produce a violation. The constraints must be maintained in the backward direction along the class composition hierarchy as well as in the forward direction. In this work an Assertion Model of Integrity Constraints (AMIC) is proposed. The AMIC keeps the derivation path along with the attributes' relationships that are derived from association, composition, and inheritance hierarchies. The AMIC techniques are designed to implement the needed functions that are collecting the attributes' relationships and checking the integrity constraints. Moreover, AMIC keeps UDCs with their relationships in both single classes and multilevel classes (intra-class and inter-class). Furthermore, the AMIC can maintain constraints in a single object and a set of distributed objects (intra-object and inter-object). Therefore, this makes the new model extendable and can be integrated with any existing constraints' service. A new technique called Detection Method (DM) isdesigned to check the Object Meta Data (OMD) to detect the constraints violation before it occurs. The AMIC is designed for both Centralized Integrity Maintenance (CIM) and Application-Oriented Integrity Maintenance (AOIM). The AMIC can also enforce and maintain structural and logical integrity constraints, in addition to enforce and maintain redundant, inconsistent, and duplicate constraints.
format Thesis
author Zaqaibeh, Belal Mohammad
author_facet Zaqaibeh, Belal Mohammad
author_sort Zaqaibeh, Belal Mohammad
title Development of an assertion model of integrity constraints in object-oriented databases
title_short Development of an assertion model of integrity constraints in object-oriented databases
title_full Development of an assertion model of integrity constraints in object-oriented databases
title_fullStr Development of an assertion model of integrity constraints in object-oriented databases
title_full_unstemmed Development of an assertion model of integrity constraints in object-oriented databases
title_sort development of an assertion model of integrity constraints in object-oriented databases
publishDate 2006
url http://psasir.upm.edu.my/id/eprint/8714/1/FSKTM_2006_11%20IR.pdf
http://psasir.upm.edu.my/id/eprint/8714/
_version_ 1787137187515465728
score 13.211869