SIGMOD '91 Proceedings of the 1991 ACM SIGMOD international conference on Management of data
Requirements and comparison of view mechanisms for object-oriented databases
Information Systems
A formal model of views for object-oriented database systems
Theory and Practice of Object Systems
The object data standard: ODMG 3.0
The object data standard: ODMG 3.0
Multiview: A Methodology for Supporting Multiple Views in Object-Oriented Databases
VLDB '92 Proceedings of the 18th International Conference on Very Large Data Bases
Closed External Schemas in Object-Oriented Databases
DEXA '01 Proceedings of the 12th International Conference on Database and Expert Systems Applications
ACM SIGMOD Record
| Hi-index | 0.00 |
Schema closure is a property that guarantees that no schema component has external references, that is, references to components that are not included in the schema. In the context of object-relational databases, schema closure implies that types, tables and views do not have references to components that are not included in the schema. In order to achieve schema closure, in this work two basic approaches known as enlargement closure and reduction closure are proposed. Enlargement closure includes in the schema every referenced component. Reduction closure, on the other hand, is based on the transformation of the components that have external references, eliminating these references to fulfill schema closure. In this work, both closure approaches and the algorithms to carry out the closure in each of them are described. These algorithms generate and incorporate the needed components, whether being types or views, to reach the schema closure making easier therefore the definition of external schemas. Finally, to illustrate the concepts proposed in this work, we explain how to carry out schema closure in SQL:2008.