Extending a relational database with deferred referential integrity checking and intelligent joins

1989 ◽  
Author(s):  
Stephanie Cammarata ◽  
Prasadram Ramachandra ◽  
Darrell Shane
Keyword(s):  
Relational Database ◽  
Integrity Checking ◽  
Referential Integrity

Extending a relational database with deferred referential integrity checking and intelligent joins

1989 ◽  
Vol 18 (2) ◽  
pp. 88-97
Author(s):  
Stephanie Cammarata ◽  
Prasadram Ramachandra ◽  
Darrell Shane
Keyword(s):  
Relational Database ◽  
Integrity Checking ◽  
Referential Integrity

WB-T: A WORDNET-BASED TRANSLATION ALGORITHM FOR RDB-TO-XML CONVERSION

2009 ◽  
Vol 23 (01) ◽  
pp. 145-158
Author(s):  
JANGWON KIM ◽  
DONGWON JEONG ◽  
JINHYUNG KIM ◽  
DOO-KWON BAIK
Keyword(s):  
Data Management ◽  
Relational Database ◽  
Extraction Time ◽  
Management Systems ◽  
Mobile Environment ◽  
Data Management Systems ◽  
Query Pattern ◽  
Web Environment ◽  
Exchange Information ◽  
Referential Integrity

XML has grown to represent and exchange information which is used widely in various computing areas such as web environment, mobile environment, data management systems. Especially, the most important issue for practical purposes is how to achieve the interoperability between XML model and relational database model. Until now, various algorithms have been proposed to achieve it. However, existing algorithms do not consider implicit referential integrity relation. VP-T and QP-T have been proposed to resolve the problem — QP-T enhanced VP-T based on query pattern. However, both have a critical restriction that column titles for an attribute are identically represented. Therefore, several referential integrity relations might not be extracted. In this paper, we introduce a novel translation algorithm whose name is WordNet-based Translation algorithm (WB-T) to resolve the above issues. WB-T can check similarity between column titles based on WordNet and extract more exact implicit referential integrity relation than the previous algorithms. WB-T provides improved extraction accuracy and reduces the extraction time.

scholarly journals A design specification and a server implementation of the inverse referential integrity constraints

2013 ◽  
Vol 10 (1) ◽  
pp. 283-320 ◽  
Author(s):  
Slavica Aleksic ◽  
Sonja Ristic ◽  
Ivan Lukovic ◽  
Milan Celikovic
Keyword(s):  
Relational Database ◽  
Database Management ◽  
Database Management Systems ◽  
Integrity Constraints ◽  
Management Systems ◽  
Design Specification ◽  
Referential Integrity ◽  
Relational Database Management ◽  
Relational Database Management Systems

The inverse referential integrity constraints (IRICs) are specialization of non-key-based inclusion dependencies (INDs). Keybased INDs (referential integrity constraints) may be fully enforced by most current relational database management systems (RDBMSs). On the contrary, non-key-based INDs are completely disregarded by actual RDBMSs, obliging the users to manage them via custom procedures and/or triggers. In this paper we present an approach to the automated implementation of IRICs integrated in the SQL Generator tool that we developed as a part of the IIS

scholarly journals Measurement of the achieved performance levels of the web applications with distributed relational database

2007 ◽  
Vol 20 (1) ◽  
pp. 31-43 ◽  
Author(s):  
Dragan Simic ◽  
Srecko Ristic ◽  
Slobodan Obradovic
Keyword(s):  
Operating System ◽  
Relational Database ◽  
High Performance ◽  
Web Applications ◽  
Computer Cluster ◽  
Performance Levels ◽  
Referential Integrity ◽  
Microsoft Windows ◽  
Performance Computing ◽  
The Web

This paper describes the methods and means used for creating a computer cluster using ordinary PCs. The cluster is running a replicated relational database, and two custom Web applications, used as the database clients. Operating system running all this is Linux 2.4, with Linux Virtual Server (LVS) used as the load-balancing solution, MySQL 4.0 as the replicated database (supporting transactions and referential integrity), and Apache 1.3 as the Web server. PHP4 is used for Web applications development. Additionally, a High Performance Computing (HPC) cluster is implemented using OpenMOSIX. Measurement and comparison of achieved performance levels is done as the final aim, using two custom applications developed for that purpose, acting as clients of two deployed Web applications. Performance-measurement applications are running under Microsoft Windows, and are developed using Borland Delphi 7.

Source-Oriented Data Processing. The triumph of the micro over the macro?

1996 ◽  
Vol 8 (3) ◽  
pp. 160-168 ◽  
Author(s):  
Janet Burt ◽  
Tom Beaumont James
Keyword(s):  
Data Processing ◽  
Relational Database ◽  
Database System ◽  
Relational Database System ◽  
Historical Databases ◽  
Oriented Approach

This article discusses the different approaches to the treatment of historical databases: the relational database system and κλειω, a source-oriented approach.

Sign in / Sign up

Export Citation Format

Share Document