Skip to main content

Combining reverse with forward database engineering a step forward to solve the legacy system dilemma

  • Conference paper
  • First Online:

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

Abstract

An object oriented methodology for building a high level abstraction of a legacy database application is described. The methodology combines two different paradigms of software engineering: classical forward with reverse engineering. The structural part of a given system is determined by reverse engineering, while the functional and behavioural views on the application are developed by using classical forward engineering techniques. Based on the background of the Austrian National Forest Inventory as a case study we demonstrate how structural, functional, and behavioural views relate to each other and how an enhanced conceptualization of a legacy database application may be constructed.

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. Maintenance, Reverse Engineering and Design Recovery. Special Issue of IEEE Software, Vol. 7, No. 1. Jan. 1990.

    Google Scholar 

  2. Reverse Engineering. Special Issue of Comm. of the ACM, Vol. 37, No. 5, May 1994.

    Google Scholar 

  3. Systematic Reuse. Special Issue of IEEE Software, Vol. 11, No. 5. Sept. 1994.

    Google Scholar 

  4. Legacy Systems. Special Issue of IEEE Software, Vol. 12, No. 1. Jan. 1995.

    Google Scholar 

  5. Chen, P. P. (1976). The Entity Relationship Model: Towards a Unified View of Data. ACM Trans. on Database Systems (TODS), Vol. 1(1).

    Google Scholar 

  6. H. Hasenauer, G. Pernul. Semantic Enhancement of Forest Inventories by Reengineering. Proc. Int. Symposium on Environmental Software Systems (ISESS'95). PennState Great Valley, Malvern, USA. June 1995. (R. Denzer, ed). Chapman & Hall, 1995.

    Google Scholar 

  7. Navathe, S. B., Awong, A. M. (1987). Abstracting relational and hierarchical data with a semantic data model. Proc. of 6th Conf. on the Entity-Relationship Approach.

    Google Scholar 

  8. Markowitz, V. M., Makovsky, J. A. Identifying extended ER object structures in relational schemas. IEEE Trans. on Softw. Eng., Vol. 16, No. 8. Aug. 1990.

    Google Scholar 

  9. Markowitz, V. M., Soshani, A. (1989). On the correctness of representing extended ER structures in the relational model. Proc. of the ACM SIGMOD Conf.

    Google Scholar 

  10. Premerlani, W. J., Blaha, M. R. (1994). An Approach for Reverse Engineering of Relational Databases. In [2].

    Google Scholar 

  11. Davis K.H., Arora A.K.; Converting a relational database model into an entity-relationship model. Proc. of 6th Conf. on the Entity-Relationship Approach.

    Google Scholar 

  12. Johannesson P., Kalman K. A method for translation relational schemas into conceptual schemas. Proc. of 8th Conf. on the Entity-Relationship Approach.

    Google Scholar 

  13. Fonkam M.M., Gray W.A. An approach to eliciting the semantics of relational databases. Proc. Intern. Converence on Advance Information System Engineering (CAISE '92), May 1992.

    Google Scholar 

  14. Hainout J.-L., Tonneau C., Joris M., Chandelon M. Transformation-based database reverse engineering. Proc. of the Intern. Converence on ER-Approach 1993.

    Google Scholar 

  15. R. Mittermeir, R. R. Kloesch, H. C. Gall. Object Recovery from Procedural Systems for Changing the Architecture of Applications. Proc. 3rd. Int. Conf on Systems Integration (ICSI'94).

    Google Scholar 

  16. Booch, G. (1990). Object-Oriented Design with Applications. Benjamin Cummings, 1990.

    Google Scholar 

  17. Wirfs-Brock, R., Wilkerson, B., Wiener, L. (1990). Designing Object-Oriented Software. Prentice Hall, 1990.

    Google Scholar 

  18. Jacobson, I. (1992). Object-Oriented Software Engineering. Addison Wesley, 1992.

    Google Scholar 

  19. Rumbauh, J. et al. (1991). Object-Oriented Modeling and Design. Prentice Hall, Englewood Cliffs, NJ, 1991.

    Google Scholar 

  20. Gane, C. P., and Sarson, T. (1979). Structured System Analysis: Tools and Techniques. Prentice Hall, Englewood Cliffs, NJ, 1979.

    Google Scholar 

  21. Kappel, G., Schrefl, M. (1991). Object/Behavior Diagrams. Proc. IEEE Data Engineering Conference, 1991.

    Google Scholar 

  22. Forstliche Bundesversuchsanstalt, Instruktionen für die Feldarbeit der österreichischen Waldinventur 1992–1996. Fassung 1994. Eigenverlag der FBVA.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Norman Revell A Min Tjoa

Rights and permissions

Reprints and permissions

Copyright information

© 1995 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Pernul, G., Hasenauer, H. (1995). Combining reverse with forward database engineering a step forward to solve the legacy system dilemma. In: Revell, N., Tjoa, A.M. (eds) Database and Expert Systems Applications. DEXA 1995. Lecture Notes in Computer Science, vol 978. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0049116

Download citation

  • DOI: https://doi.org/10.1007/BFb0049116

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-60303-0

  • Online ISBN: 978-3-540-44790-0

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics