On the foundations of the universal relation model
- 3 June 1984
- journal article
- Published by Association for Computing Machinery (ACM) in ACM Transactions on Database Systems
- Vol. 9 (2) , 283-308
- https://doi.org/10.1145/329.318580
Abstract
The universal relation model aims at achieving complete access-path independence in relational databases by relieving the user of the need for logical navigation among relations. We clarify the assumptions underlying it and explore the approaches suggested for implementing it. The essential idea of the universal relation model is that access paths are embedded in attribute names. Thus attribute names must play unique “roles.” Furthermore, it assumes that for every set of attributes there is a basic relationship that the user has in mind. The user's queries refer to these basic relationships rather than to the underlying database. Two fundamentally different approaches to the universal relation model have been taken. According to the first approach, the user's view of the database is a universal relation or many universal relations, about which the user poses queries. The second approach sees the model as having query-processing capabilities that relieve the user of the need to specify the logical access path. Thus, while the first approach gives a denotational semantics to query answering, the second approach gives it an operational semantics. We investigate the relationship between these two approaches.Keywords
This publication has 35 references indexed in Scilit:
- Joined normal formACM Transactions on Database Systems, 1982
- Horn clauses and database dependenciesJournal of the ACM, 1982
- A simplied universal relation assumption and its propertiesACM Transactions on Database Systems, 1982
- Testing satisfaction of functional dependenciesJournal of the ACM, 1982
- Relational databaseCommunications of the ACM, 1982
- Efficient optimization of a class of relational expressionsACM Transactions on Database Systems, 1979
- The theory of joins in relational databasesACM Transactions on Database Systems, 1979
- Logic and Data BasesPublished by Springer Nature ,1978
- Synthesizing third normal form relations from functional dependenciesACM Transactions on Database Systems, 1976
- A relational model of data for large shared data banksCommunications of the ACM, 1970