A relational information resource dictionary system
Communications of the ACM
Role of data dictionaries in information resource management
Information and Management
Semantic database modeling: survey, applications, and research issues
ACM Computing Surveys (CSUR)
A language for simple interactive retrieval from a database system
Data & Knowledge Engineering
The Integrated Dictionary/Directory System
ACM Computing Surveys (CSUR)
An Intelligent Information Dictionary for Semantic Manipulation of Relational Databases
EDBT '88 Proceedings of the International Conference on Extending Database Technology: Advances in Database Technology
Dynamic Derivation of Personalized Views
VLDB '88 Proceedings of the 14th International Conference on Very Large Data Bases
Enforcing Inclusion Dependencies and Referencial Integrity
VLDB '88 Proceedings of the 14th International Conference on Very Large Data Bases
Semantic Integrity Dependencies and Delayed Integrity Checking
VLDB '82 Proceedings of the 8th International Conference on Very Large Data Bases
Metadata Management for Large Statistical Databases
VLDB '82 Proceedings of the 8th International Conference on Very Large Data Bases
Join processing in relational databases
ACM Computing Surveys (CSUR)
Automatic logical navigation for relational databases
SAC '93 Proceedings of the 1993 ACM/SIGAPP symposium on Applied computing: states of the art and practice
LOIS: The ``Lights Out'' Integrity Subsystem
BNCOD 18 Proceedings of the 18th British National Conference on Databases: Advances in Databases
Referential integrity quality metrics
Decision Support Systems
Extending Middleware Protocols for Database Replication with Integrity Support
OTM '08 Proceedings of the OTM 2008 Confederated International Conferences, CoopIS, DOA, GADA, IS, and ODBASE 2008. Part I on On the Move to Meaningful Internet Systems:
| Hi-index | 0.01 |
Interactive use of relational database management systems (DBMS) requires a user to be knowledgeable about the semantics of the application represented in the database. In many cases, however, users are not trained in the application field and are not DBMS experts. Two categories of functionality are problematic for such users: (1) updating a database without violating integrity constraints imposed by the domain and (2) using join operations to retrieve data from more than one relation. We have been conducting research to help an uninformed or casual user interact with a relational DBMS.This paper describes two capabilities to aid an interactive database user who is neither an application specialist nor a DBMS expert. We have developed deferred Referential Integrity Checking (RIC) and Intelligent Join (IJ) which extend the operations of a relational DBMS. These facilities are made possible by explicit representation of database semantics combined with a relational schema. Deferred RIC is a static validation procedure that checks uniqueness of tuples, non-null keys, uniqueness of keys, and inclusion dependencies. IJ allows a user to identify only the “target” data which is to be retrieved without the need to additionally specify “join clauses”. In this paper we present the motivation for these facilities, describe the features of each, and present examples of their use.