Abstract
When an (accounting) database schema does not meet the requirements of a firm, the schema must be changed. Such schema evolution can be considered as realizable via a sequence of operators. This research proceeds in the following three steps. First, we define a set of basic evolution schema operators and employ the evolution heuristics to guide the evolution process. Second, we explore how domain-specific knowledge can be used to guide the use of evolution operators to complete the evolution task. A well-known accounting data model is used here to guide the schema evolution process. Third, we discuss a tool built to implement the evolution operators, using the evolution heuristics and domain-specific knowledge.
This is a preview of subscription content, log in via an institution.
Preview
Unable to display preview. Download preview PDF.
References
Banerjee, J., Chou, H-T., Garza, J., Kim, W., Woelk, D., Ballou, N., and Kim, H., “Data Model Issues for Object-Oriented Applications,” ACM TOOIS, 5:1, January, 1987.
Banerjee, J., Kim, W., Kim, H., and Korth, H., Semantics and Implementation of Schema Evolution in Object-Oriented Databases, Proc. ACM/SIGMOD Annual Conference on Management of Data, San Francisco, California, May 1987.
Chen, J.-L. “Heuristic-Based Conceptual Database Schema Evolution,” Technical Report, University of Southern California, September 1994.
Chen, P. P., “The entity-relationship model: Toward a unified View of data.,” ACM Transactions on Database Systems, 1:9–36, 1976.
Chiristodoulakis, S., Vanderbroek, J., Li, J., Wan, S., Wang, Y., Papa, M., and Bertino, E., “Development of a Multimedia Information System for an Office Environment.” In Proc. of the 10th Int'l Conf. on VLDB, 1984, Pp. 261–271.
Grabski, S. and Marsh, R., “Integrating Accounting and Advanced Manufacturing Information Systems: An ABC and REA-Based Approach,” AIS Research Symposium, 1994, Phoenix, AZ.
Hammer, M. and McLeod, D., “Database Description with SDM: A Semantic Database Model”, ACM TODS 6, 3, September 1981, 351–387.
Li, Q. and McLeod, D., Conceptual Database Evolution Through Learning, Object-Oriented Databases and Applications, Gupta, R. and Horowitz, E. (Editors), Prentice-Hall, 1989.
McCarthy, W., “The REA Accounting Model: A Generalized Framework for Accounting Systems in a Shared Environment,” Accounting Review, July 1982, pp. 554–578.
NeXTSTEP Version 3, NeXT Computer, Inc., 1990. (note: NeXTStep is a registed trademark of NeXT Computer, Inc.)
Navathe, S. B., Geum, S., Desci, D. K., and Lam, H., “Conceptual Design for Non-database Experts with an Interactive Schema Tailing Tool”, Proc. of the 9th Intl. Conf. on the Entity-Relationship approach, Lausanne, Switzerland, Oct., 1990.
Penney, D. J. and Stein, J., Class Modification in the GemStone Object-Oriented DBMS. In Proceedings of the Conference on Object-Oriented Programming Systems, Languages, and Applications, pages 111–117, 1987.
Skarra, A. H., and Zdonik, S. B., The Management of Changing Types in an Object-Oriented Database, Proc. ACM Conference on Object-Oriented Programming Systems, Languages, and Applications, Portland, Oregon, September 1986.
Su, S., Krishnamurthy, V. and Lam, H., “An Object-Oriented Semantic Association Model (OSAM*),” AI in Industrial Engineering and Manufacturing: Theoretical Issues and Applications, Kumara, S., Kashyap, R., and Soyster, A. (Eds.). American Institue of Industrial Engineering, 1989.
Versant ODBMS, “Versant System Manual,” Versant Object technology, 1992, Menlo Park, CA. (note: Versant is a trademark of Versant Object Technology Co.)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1994 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Chen, J.L., McLeod, D., O'Leary, D. (1994). Schema evolution for object-based accounting database systems. In: Bertino, E., Urban, S. (eds) Object-Oriented Methodologies and Systems. ISOOMS 1994. Lecture Notes in Computer Science, vol 858. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0014015
Download citation
DOI: https://doi.org/10.1007/BFb0014015
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-58451-3
Online ISBN: 978-3-540-48804-0
eBook Packages: Springer Book Archive