Abstract
Like data, conceptual schemata change and need to be updated. If not performed with care, updates can cause problems. In this paper, we present a procedure which safely adds a fact type to a conceptual schema. This procedure, as well as being used for simple schema updates, may be applied to design and integration problems. We also present procedures for the safe removal of a fact type, and the safe elimination of redundant information from the conceptual schema.
Chapter PDF
Similar content being viewed by others
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
References
Michel Andany, José Léonard and Carole Palisser. Management of schema evolution in databases. In Proc. 17th International Conference on Very Large Data Bases (VLDB), pages 161–170, 1991.
Bogdan Czejdo, Marek Rusinkiewicz, and David Embley. An approach to schema integration and query formulation in federated database systems. Proceedings of the Third International Conference on Data Engineering, pages 477–484, 1987.
Christoph Eick. Methodology for the design and transformation of conceptual schemas. In Proc. 17th International Conference on Very Large Data Bases (VLDB), pages 25–34, 1991.
Terence A. Halpin and Maria E. Orlowska. Fact-oriented modelling for data analysis. Information Systems, 2(2):97–119, April 1992.
William Kent. Solving domain mismatch and schema mismatch problems with an object-oriented database programming language. In Proc. 17th International Conference on Very Large Data Bases (VLDB), pages 147–160, 1991.
J. Larson, S. Navathe, and R. Elmasri. A theory of attribute equivalence in databases with application to schema integration. IEEE Transactions on Software Engineering, 15(4):449–463, 1989.
Victor M. Markowitz and Johann A. Makowsky. Incremental reorganization of relational databases. In Proc. 13th VLDB Conference, pages 127–135, 1987.
S.B. Navathe and S.G. Gadgil. A methodology for view integration in logical database design. In Proceedings of the Eighth International Conference on Very Large Data Bases, Mexico City, pages 142–155, 1982.
S.B. Navathe, T. Sashidhar, and R. Elmasri. Relationship merging in schema integration. In Proceedings of the Tenth International Conference on Very Large Data Bases, Singapore, pages 78–90, 1984.
G.M. Nijssen and T.A. Halpin. Conceptual Schema and Relational Database Design. Prentice Hall, Englewood Cliffs, New Jersey, 1989.
Maria E. Orlowska and C.A. Ewald. Meta-level updates: The evolution of fact-based schemata. Technical Report 211, Key Centre for Software Technology, Department of Computer Science, University of Queensland, 1991.
Maria E. Orlowska and C.A. Ewald. Schema evolution — the design and integration of fact-based schemata. In Proc. Databases '92: Australian Database Conference, 1992.
Maria E. Orlowska and Yanchun Zhang. On enhancements of semantic methodologies for relational database design. In Databases in the 1990s: Proceedings of the Australian Database Research Conference, pages 97–108, 1990.
J. Rybnik, Z. Brzezinski, J. Getta, and W. Stepniewski. UNIBASE-an integrated access to databases. In Proceedings of the Tenth International Conference on Very Large Data Bases, Singapore, pages 388–396, 1984.
Peretz Shoval and Sara Zohn. Binary-relationship integration methodolgy. Data and Knowledge Engineering, pages 225–250, 1991.
Michael Siegel and Stuart E. Madnick A metadata approach to resolving semantic conflicts. In Proc. 17th International Conference on Very Large Data Bases (VLDB), pages 133–145, 1991.
K. Tanaka and Y. Kambayashi. Logical integration of locally independent relational databases into a distributed database. In Proceedings of the Seventh International Conference on Very Large Data Bases, pages 131–141, 1981.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1993 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Ewald, C.A., Orlowska, M.E. (1993). A procedural approach to schema evolution. In: Rolland, C., Bodart, F., Cauvet, C. (eds) Advanced Information Systems Engineering. CAiSE 1993. Lecture Notes in Computer Science, vol 685. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-56777-1_2
Download citation
DOI: https://doi.org/10.1007/3-540-56777-1_2
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-56777-6
Online ISBN: 978-3-540-47735-8
eBook Packages: Springer Book Archive