Advertisement

Inference of Aggregate Relationships through Database Reverse Engineering

  • Christian Soutou
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1507)

Abstract

This paper presents a process to improve the reverse engineering of relational databases. Our process extracts the current aggregate relationships from a relational database through a combination of data dictionary, data schema and data instance analysis. The process we propose can refine conceptual diagrams of commercial tools with reverse engineering options as Power AMC (Sybase), Designer (Oracle).

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 1.
    Andersson, M.: Extracting an Entity Relationship Schema from a Relational Database through Reverse Engineering. In: Loucopoulos, P. (ed.) ER 1994. LNCS, vol. 881, pp. 403–419. Springer, Heidelberg (1994)Google Scholar
  2. 2.
    Batini, C., Ceri, S., Navathe, S.B.: Conceptual Database Design: an Entity Relationship Approach. Benjamin Cummings (1992)Google Scholar
  3. 3.
    Castellanos, M.: A Methodology for Semantically Enriching Interoperable Databases. In: Proceedings of the 11th British National Conference on Databases, pp. 58–75 (1993)Google Scholar
  4. 4.
    Chen, P.P.: The Entity-Relationship Model: Towards a Unified View of Data. ACM Transactions on Database Systems 1(1), 2–36 (1976)CrossRefGoogle Scholar
  5. 5.
    Chiang, R., Barron, T., Storey, V.C.: Reverse engineering of relational databases: Extraction of an EER model from a relational database. Journal of Data and KnowledgeEngineering 12(2), 107–142 (1994)CrossRefGoogle Scholar
  6. 6.
    Comyn-Wattiau, I., Akoka, J.: Reverse Engineering of Relational Database Physical Schemas. In: Thalheim, B. (ed.) ER 1996. LNCS, vol. 1157, pp. 372–391. Springer, Heidelberg (1996)Google Scholar
  7. 7.
    Davis, K.H., Arora, A.K.: Converting a Relational Database Model into an EntityRelationship Model. In: Proceedings of the 6th International Conference on Entity-Relationship Approach, pp. 243–257 (November 1987)Google Scholar
  8. 8.
    Englebert, V., Henrard, J., Hick, J.M., Roland, D., Hainaut, J.L.: DB-MAIN: a database oriented CASE Tool. Engineering of Information Systems 4(1), 87–116 (1996)Google Scholar
  9. 9.
    Gardarin, G.: Translating relational to object databases. Engineering of Information Systems 2(3), 317–346 (1994)Google Scholar
  10. 10.
    Hainaut, J.L., Tonneau, C., Joris, M., Chandelon, M.: Transformation-based Database Reverse Engineering. In: Elmasri, R.A., Kouramajian, V., Thalheim, B. (eds.) ER 1993. LNCS, vol. 823, pp. 364–375. Springer, Heidelberg (1994)Google Scholar
  11. 11.
    Johanneson, P.: A method for Translating Relational Schemas into Conceptual Schemas. In: Proceedings of the 10th Int. Conference on Data Engineering, pp. 190–201 (1994)Google Scholar
  12. 12.
    Markowitz, K.M., Makowsky, J.A.: Identifying Extended Entity-Relationship Object Structures in Relational Schemas. IEEE, Transactions on Software Engineering 16(8), 777–790 (1990)CrossRefGoogle Scholar
  13. 13.
    Moulin, P., Randon, J., Savoysky, S., Spaccapietra, S., Tardieu, H., Teboul, M.: Conceptual model as database design tool. In: Nijssen, G.M. (ed.) Proceedings of the IFIP Working conference on Modelling in Database Management Systems. North-Holland, Amsterdam (1976)Google Scholar
  14. 14.
    Narasimham, B., Navathe, S.B., Jayaraman, S.: On Mapping ER and Relational Models into OO Schemas. In: Elmasri, R.A., Kouramajian, V., Thalheim, B. (eds.) ER 1993. LNCS, vol. 823, pp. 402–413. Springer, Heidelberg (1994)CrossRefGoogle Scholar
  15. 15.
    Navathe, S.B., Awong, H.: Abstracting Relational and Hierarchical Data with a Semantic Data Model. In: Proceedings of the 6th International Conference on Entity-Relationship Approach, pp. 277–305 (November 1987)Google Scholar
  16. 16.
    Petit, J.M., Kouloumdjian, J., Boulicaut, J.F., Toumani, F.: Using Queries to Improve Database Reverse Engineering. In: Loucopoulos, P. (ed.) ER 1994. LNCS, vol. 881, pp. 369–386. Springer, Heidelberg (1994)Google Scholar
  17. 17.
    Premerlani, W.J., Blaha, M.R.: An Approach for Reverse Engineering of Relational Databases. In: Proceedings of the IEEE Working Conference on Reverse Engineering, Baltimore, pp. 151–160 (November 1993)Google Scholar
  18. 18.
    Shoval, P., Shreiber, N.: Database Reverse engineering: From the Relational to the Binary Relationship Model. Journal of Data and Knowledge Engineering 10, 293–315 (1993)CrossRefGoogle Scholar
  19. 19.
    Signore, O., Loffredo, M., Gregori, M., Cima, M.: Reconstruction of ER Schema from Database Application: a Cognitive Approach. In: Loucopoulos, P. (ed.) ER 1994. LNCS, vol. 881, pp. 387–402. Springer, Heidelberg (1994)Google Scholar
  20. 20.
    Smith, H.A., Smith, D.C.P.: Database Abstractions: Aggregation and Generalization. ACM Transactions on Database Systems 2(2), 105–133 (1977)CrossRefGoogle Scholar
  21. 21.
    Song, Y.I., Jones, T.H.: Analysis of Binary Relationships within Ternary Relationships in ER Modeling. In: Elmasri, R.A., Kouramajian, V., Thalheim, B. (eds.) ER 1993. LNCS, vol. 823, pp. 271–282. Springer, Heidelberg (1994)Google Scholar
  22. 22.
    Soutou, C.: Extracting N-ary Relationships through Database Reverse Engineering. In: Thalheim, B. (ed.) ER 1996. LNCS, vol. 1157, pp. 392–405. Springer, Heidelberg (1996)Google Scholar
  23. 23.
    Soutou, C.: Relational Database Reverse Engineering: Extraction of Cardinality Constraints. Journal of Data and Knowledge Engineering (to appear)Google Scholar
  24. 24.
    Spaccapietra, S., Parent, C.: ERC+:an Object Based Entity Relationship Approach. In: Loucopoulos, P., Zicari, R. (eds.) Conceptual Modeling, Databases and CASE: An Integrated View of Information Systems Development. John Wiley, Chichester (1993)Google Scholar
  25. 25.
    Tardieu, H., Rochfeld, A., Colleti, R.: La méthode MERISE, Les Editions d’Organisation, Paris (1986) Google Scholar
  26. 26.
    Teorey, T.J., Yang, D., Fry, J.P.: A logical design methodology for relational databases using the extended entity-relationship model. ACM Computing Surveys 18(12), 197–222 (1986)zbMATHCrossRefGoogle Scholar
  27. 27.
    Vermeer, M.W.W., Apers, P.M.G.: Reverse Engineering of Relational Database Applications. In: Papazoglou, M.P. (ed.) ER 1995 and OOER 1995. LNCS, vol. 1021, pp. 89–100. Springer, Heidelberg (1995)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1998

Authors and Affiliations

  • Christian Soutou
    • 1
  1. 1.Université de Toulouse II, IUT ‘B’, Groupe de Recherche ICAREBlagnacFRANCE

Personalised recommendations