Skip to main content
SpringerLink
Log in

Data Structure Extraction in Database Reverse Engineering

  • Conference paper
Advances in Conceptual Modeling (ER 1999)

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

Included in the following conference series:

  • 492 Accesses

Abstract

Database reverse engineering is a complex activity that can be modeled as a sequence of two major processes, namely data structure extraction and data structure conceptualization. The first process consists in reconstructing the logical - that is, DBMS-dependent - schema, while the second process derives the conceptual specification of the data from this logical schema. This paper concentrates on the first process, and more particularly on the reasonings and the decision process through which the implicit and hidden data structures and constraints are elicited from various sources.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

7 References

  1. Anderson, M.: Reverse Engineering of Legacy Systems: From Valued-Based to Object-Based Models, PhD thesis, Lausanne, EPFL (1997)

    Google Scholar 

  2. Batini, C., Ceri, S. and Navathe, S.B.: Conceptual Database Design-An Entity-Relationship Approach, Benjamin/Cummings (1992).

    Google Scholar 

  3. Englebert, V., Henrard J., Hick, J.-M., Roland, D. and Hainaut, J.-L.: DB-MAIN: un Atelier d’Ingénierie de Bases de Données, Ingénierie des Système d’Information, V4 no1, HERMES-AFCET (1996).

    Google Scholar 

  4. Hainaut, J.-L., Chandelon, M., Tonneau, C. and Joris M.: Contribution to a Theory of Database Reverse Engineering, in Proc. of WCRE’93, Baltimore, IEEE Computer Society Press (1993).

    Google Scholar 

  5. Hainaut, J.-L, Roland, D., Hick J-M., Henrard, J. and Englebert, V.: Database Reverse Engineering: from Requirements to CARE Tools, Journal of Automated Software Engineering, 3(1) (1996).

    Google Scholar 

  6. Henrard, J., Englebert, V., Hick, J-M., Roland, D., Hainaut, J-L.: Program understanding in databases reverse engineering, in Proc. of DEXA’98, Vienna (1998).

    Google Scholar 

  7. Jerding, D., Rugaber, S.: Using Visualization for Architectural Localization and Extraction, in Proc. of WCRE’97, Amsterdam (1997).

    Google Scholar 

  8. Joris, M., Van Hoe, R., Hainaut, J.-L., Chandelon, M., Tonneau, C. and Bodart, F. et al.: PHENIX: Methods and Tools for Database Reverse Engineering, in Proc 5th Int. Conf. on Software Engieering and Applications. Toulouse, EC2 Publish (1992).

    Google Scholar 

  9. Petit, J.-M., Kouloumdjian, J., Bouliaut, J.-F. and Toumani, F: Using Queries to Improve Database Reverse Engineering, in Proc of the 13th Int. Conf. on ER Approach, Manchester. Springer-Verlag (1994).

    Google Scholar 

  10. Montes de Oca C., Carver D. L., A Visual Representation Model for Software Subsystem Decomposition, in Proc of WCRE’98, Hawai, USA, IEEE Computer Society Press (1998).

    Google Scholar 

  11. Weiser, M.: Program Slicing, IEEE TSE, 10, 352–357 (1984).

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Institut d’Informatique, University of Namur, rue Grandgagnage, 21, B-5000, Namur

    J. Henrard, J. -L. Hainaut, J. -M. Hick, D. Roland & V. Englebert

Authors
  1. J. Henrard
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. J. -L. Hainaut
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. J. -M. Hick
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. D. Roland
    View author publications

    You can also search for this author in PubMed Google Scholar

  5. V. Englebert
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Department of Computer Science, Louisiana State University, 298 Coates Hall, Baton Rouge, LA, 70803, USA

    Peter P. Chen

  2. Department of Computer Science, Brigham Young University, Provo, UT, 84602, USA

    David W. Embley

  3. INSA-LISI, 20 Avenue Albert Einstein, F-69621, Villeurbanne Cedex, France

    Jacques Kouloumdjian

  4. Marriott School of Management, Brigham Young University, P.O. Box 23087, Provo, UT, 84602-3087, USA

    Stephen W. Liddle

  5. School of Computer and Information Science, University of South Australia, Mawson Lakes, 5095, South Australia

    John F. Roddick

Rights and permissions

Reprints and permissions

Copyright information

© 1999 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Henrard, J., Hainaut, J.L., Hick, J.M., Roland, D., Englebert, V. (1999). Data Structure Extraction in Database Reverse Engineering. In: Chen, P.P., Embley, D.W., Kouloumdjian, J., Liddle, S.W., Roddick, J.F. (eds) Advances in Conceptual Modeling. ER 1999. Lecture Notes in Computer Science, vol 1727. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-48054-4_13

Download citation

  • DOI: https://doi.org/10.1007/3-540-48054-4_13

  • Publisher Name: Springer, Berlin, Heidelberg

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

  • Online ISBN: 978-3-540-48054-9

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation