Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
ISO IEC 9075-*:2008. Database languages - SQL (2008)
Abiteboul, S., Bonner, A.J.: Objects and views. In: SIGMOD Conference, pp. 238–247 (1991)
Cattell, R.G.G., Barry, D.K.: The Object Data Standard: ODMG 3.0. Morgan Kaufmann, San Francisco (2000)
Eisenberg, A., Melton, J., Kulkarni, K.G., Michels, J.-E., Zemke, F.: SQL:2003 has been published. SIGMOD Record 33(1), 119–126 (2004)
Garcia, J., Ortin, M.J., Garcia, G.: Extending the ODMG standard with views. Information & Software Technology 44(3), 161–173 (2002)
Guerrini, G., Bertino, E., Catania, B., Molina, J.G.: A formal view of object-oriented database systems. TAPOS 3(3), 157–183 (1997)
Lacroix, Z., Delobel, C., Breche, P.: Object views. Networking and Information Systems 1(2-3), 231–250 (1998)
Motschnig-Pitrik, R.: Requirements and comparison of view mechanisms for object-oriented databases. Information Systems 21(3), 229–252 (1996)
Roantree, M., Kennedy, J.B., Barclay, P.J.: Providing views and closure for the object data management group object model. Information & Software Technology 41(15), 1037–1044 (1999)
Rundensteiner, E.A.: Multiview: A methodology for supporting multiple views in object-oriented databases. In: Proceedings of the 18th International Conference on Very Large Data Bases (VLDB), pp. 187–198 (1992)
Torres, M., Samos, J.: Closed external schemas in object-oriented databases. In: Mayr, H.C., Lazanský, J., Quirchmayr, G., Vogel, P. (eds.) DEXA 2001. LNCS, vol. 2113, pp. 826–835. Springer, Heidelberg (2001)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2010 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Torres, M., Samos, J., Garví, E. (2010). Closing Schemas in Object-Relational Databases. In: Dearle, A., Zicari, R.V. (eds) Objects and Databases. ICOODB 2010. Lecture Notes in Computer Science, vol 6348. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-16092-9_13
Download citation
DOI: https://doi.org/10.1007/978-3-642-16092-9_13
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-16091-2
Online ISBN: 978-3-642-16092-9
eBook Packages: Computer ScienceComputer Science (R0)