Clustering relations into abstract ER schemas for database reverse engineering

Science of Computer Programming

Volumn 45, Issue 2-3, 2002, Pages 137-153

  Sousa, Pedro ^a,b   Pedro de Jesus, Lurdes ^a,b   Pereira, Gonçalo ^b   E Abreu, Fernando Brito ^b  

^a UNIVERSITY OF LISBON   (Portugal)

^b INESC   (Portugal)

Author keywords

[No Author keywords available]

Indexed keywords

DATA STRUCTURES; DATABASE SYSTEMS; MATHEMATICAL MODELS; SEMANTICS;

DATABASE REVERSE ENGINEERING (DBRE) METHODS; RELATIONAL SCHEMA;

REVERSE ENGINEERING;

EID: 0036836975     PISSN: 01676423     EISSN: None     Source Type: Journal    
DOI: 10.1016/S0167-6423(02)00057-6     Document Type: Conference Paper

References (16)

1. J. Akoka, I. Comyn-Wattiau, A framework for automatic clustering of semantic models, in: R. Elmasri, V. Kouramajian (Eds.), Proc. 12th Internat. Conf. on Entity-Relationship Approach, Arlington, TX, USA, 1993, pp. 432-446.
2. S. Baase, Computer Algorithms - Introduction to Design and Analysis,2nd Edition, Computer Science, Addison-Wesley, Reading, MA, 1988.
3. Batini C., Ceri S., Shamkant N. Conceptual Database Design - An Entity-Relationship Approach. 1992;Benjamin/Cummings, Menlo Park, CA.
4. Blaha M., Premerlani W. Object-Oriented Modelling and Design for Database Applications. 1998;Prentice-Hall, Englewood Cliffs, NJ.
5. Chiang R., Barron T., Storey V. Reverse engineering of relational databases. extraction of an eer model from a relational database Data Knowl Eng. 12:1994;107-142.
6. Christian S. Extracting n-ary relationships through database reverse engineering. Thalheim B. Proc. 15th Internat. Conf. on Conceptual Modeling. 1996;392-405 Cottbus, Germany.
7. Feldman P., Miller D. Entity model clustering. structuring a data model by abstraction Comput. J. 29(4):1986.
8. C. Francalanci, B. Pernici, Abstraction Levels for Entity-Relationships Schemas, vol. 881, Manchester, UK, 1994, pp. 456-473.
9. J.-L. Hainaut, C. Tonneau, M. Joris, M. Chandelon, Transformation-based database reverse engineering, in: R. Elmasri, V. Kouramajian (Eds.), Proc. 12th Internat. Conf. on Entity-Relationship Approach, Arlington, TX, USA, 1993, pp. 364-375.
10. P. Jaeschke, A. Oberweis, W. Stucky, Extending er model clustering by relationship clustering, in: R. Elmasri, V. Kouramajian (Eds.), Proc. 12th Internat. Conf. on Entity-Relationship Approach, Arlington, TX, USA, 1993, pp. 447-459.
11. P. Johannesson, A method for transforming relational schemas into conceptual schemas, in: Rusinkiewicz (Ed.), Proc. 10th Internat. Conf. on Data Engineering, IEEE Press, Houston, 1994, pp. 115-122.
12. Markowitz V., Makowsk J. Identifying extended entity-relationship object structures in relational schemas. IEEE Trans. Software Eng. 16(8):1990.
13. J.-M. Petit, J. Kouloumdjian, J.-F. Boulicaut, F. Toumani, Using queries to improve database reverse engineering. in: Proc. 13th Internat. Conf. on Entity-Relationship Approach, Lecture Notes in Computer Science, vol. 881, Manchester, UK, 1994, pp. 369-386.
14. J.-M. Petit, F. Toumani, J.-F. Boulicaut, J. Kouloumdjian, Towards the reverse engineering of denormalized relational databases, in: I. Press (Ed.), Proc. 12th Internat. Conf. on Data Engineering, Lecture Notes in Computer Science, vol. 881, New Orleans, LA, USA, 1996.
15. O. Signore, M. Loffredo, M. Gregori, M. Cima, Using procedural patterns in abstracting relational schemata, in Proc. 13th Internat. Conf. on Entity-Relationship Approach, Lecture Notes in Computer Science, vol. 881, 1994.
16. Teorey T.J., Wei G., Bolton D., Koenig J.A. Er model clustering as an aid for user communication and documentation in database design. Commun. ACM. 3(8):1989.