Skip to main content

Schema evolution for object-based accounting database systems

  • Conference paper
  • First Online:

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 858))

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.

Unable to display preview. Download preview PDF.

References

  1. 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.

    Google Scholar 

  2. 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.

    Google Scholar 

  3. Chen, J.-L. “Heuristic-Based Conceptual Database Schema Evolution,” Technical Report, University of Southern California, September 1994.

    Google Scholar 

  4. Chen, P. P., “The entity-relationship model: Toward a unified View of data.,” ACM Transactions on Database Systems, 1:9–36, 1976.

    Article  Google Scholar 

  5. 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.

    Google Scholar 

  6. Grabski, S. and Marsh, R., “Integrating Accounting and Advanced Manufacturing Information Systems: An ABC and REA-Based Approach,” AIS Research Symposium, 1994, Phoenix, AZ.

    Google Scholar 

  7. Hammer, M. and McLeod, D., “Database Description with SDM: A Semantic Database Model”, ACM TODS 6, 3, September 1981, 351–387.

    Article  Google Scholar 

  8. Li, Q. and McLeod, D., Conceptual Database Evolution Through Learning, Object-Oriented Databases and Applications, Gupta, R. and Horowitz, E. (Editors), Prentice-Hall, 1989.

    Google Scholar 

  9. McCarthy, W., “The REA Accounting Model: A Generalized Framework for Accounting Systems in a Shared Environment,” Accounting Review, July 1982, pp. 554–578.

    Google Scholar 

  10. NeXTSTEP Version 3, NeXT Computer, Inc., 1990. (note: NeXTStep is a registed trademark of NeXT Computer, Inc.)

    Google Scholar 

  11. 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.

    Google Scholar 

  12. 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.

    Google Scholar 

  13. 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.

    Google Scholar 

  14. 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.

    Google Scholar 

  15. Versant ODBMS, “Versant System Manual,” Versant Object technology, 1992, Menlo Park, CA. (note: Versant is a trademark of Versant Object Technology Co.)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Elisa Bertino Susan Urban

Rights and permissions

Reprints 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

Publish with us

Policies and ethics