Towards the Reverse Engineering of Denormalized Relational Databases.

@inproceedings{DBLP:conf/icde/PetitTBK96,
  author    = {Jean-Marc Petit and
               Farouk Toumani and
               Jean-Fran\c{c}ois Boulicaut and
               Jacques Kouloumdjian},
  editor    = {Stanley Y. W. Su},
  title     = {Towards the Reverse Engineering of Denormalized Relational Databases},
  booktitle = {Proceedings of the Twelfth International Conference on Data Engineering,
               February 26 - March  1, 1996, New Orleans, Louisiana},
  publisher = {IEEE Computer Society},
  year      = {1996},
  isbn      = {0-8186-7240-4},
  pages     = {218-227},
  ee        = {db/conf/icde/PetitTBK96.html},
  crossref  = {DBLP:conf/icde/96},
  bibsource = {DBLP, http://dblp.uni-trier.de}
}

Abstract

Copyright © 1996 by The Institute of Electrical and Electronic Engineers, Inc. (IEEE). Abstract used with permission.

ACM SIGMOD Anthology

• Windows: Click the letter of your CD drive
  A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
• Mac: Click here
• UNIX/LINUX: mount the CD and click on the path of your mount point:
  /Anthology/An2-7 or /cdrom

• Windows: Click the letter of your CD drive
  A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
• Mac: Click here
• UNIX/LINUX: mount the DVD and click on the path of your mount point:
  /Anthology/aDVD1 or /dvd

Printed Edition

References

[1]

Martin Andersson: Extracting an Entity Relationship Schema from a Relational Database through Reverse Engineering. ER 1994: 403-419 BibTeX

[2]

Carlo Batini, Stefano Ceri, Shamkant B. Navathe: Conceptual Database Design: An Entity-Relationship Approach. Benjamin/Cummings 1992, ISBN 0-8053-0244-1
BibTeX

[3]

Marco A. Casanova, Jose E. Amaral de Sa: Designing Entity-Relationship Schemes for Conventional Information Systems. ER 1983: 265-277 BibTeX

[4]

Peter P. Chen: The Entity-Relationship Model - Toward a Unified View of Data. ACM Trans. Database Syst. 1(1): 9-36(1976) BibTeX

[5]

Roger H. L. Chiang, Terence M. Barron, Veda C. Storey: Reverse Engineering of Relational Databases: Extraction of an EER Model from a Relational Database. Data Knowl. Eng. 12(2): 107-142(1994) BibTeX

[6]

Ramez Elmasri, Shamkant B. Navathe: Fundamentals of Database Systems, 2nd Edition. Benjamin/Cummings 1994, ISBN 0-8053-1748-1
Contents BibTeX

[7]

Jean-Luc Hainaut, Vincent Englebert, Jean Henrard, Jean-Marc Hick, Didier Roland: Requirements for Information System Reverse Engineering Support. WCRE 1995: 134-145 BibTeX

[8]

Richard Hull, Roger King: Semantic Database Modeling: Survey, Applications, and Research Issues. ACM Comput. Surv. 19(3): 201-260(1987) BibTeX

[9]

Manfred A. Jeusfeld, Uwe A. Johnen: An Executable Meta Model for Re-Engineering of Database Schemas. ER 1994: 533-547 BibTeX

[10]

Paul Johannesson: A Method for Transforming Relational Schemas Into Conceptual Schemas. ICDE 1994: 190-201 BibTeX

[11]

David Maier, Jeffrey D. Ullman, Moshe Y. Vardi: On the Foundations of the Universal Relation Model. ACM Trans. Database Syst. 9(2): 283-308(1984) BibTeX

[12]

Heikki Mannila, Kari-Jouko Räihä: Algorithms for Inferring Functional Dependencies from Relations. Data Knowl. Eng. 12(1): 83-99(1994) BibTeX

[13]

Victor M. Markowitz, Johann A. Makowsky: Identifying Extended Entity-Relationship Object Structures in Relational Schemas. IEEE Trans. Software Eng. 16(8): 777-790(1990) BibTeX

[14]

Victor M. Markowitz, Arie Shoshani: Representing Extended Entity-Relationship Structures in Relational Databases: A Modular Approach. ACM Trans. Database Syst. 17(3): 423-464(1992) BibTeX

[15]

Shamkant B. Navathe, A. M. Awong: Abstracting Relational and Hierarchical Data with a Semantic Data Model. ER 1987: 305-333 BibTeX

[16]

Jean-Marc Petit, Jacques Kouloumdjian, Jean-François Boulicaut, Farouk Toumani: Using Queries to Improve Database Reverse Engineering. ER 1994: 369-386 BibTeX

[17]

...

[18]

Jean-Marc Petit, Farouk Toumani, Jacques Kouloumdjian: Relational Database Reverse Engineering: A Method Based on Query Analysis. Int. J. Cooperative Inf. Syst. 4(2-3): 287-316(1995) BibTeX

[19]

William J. Premerlani, Michael R. Blaha: An Approach for Reverse Engineering of Relational Databases. Commun. ACM 37(5): 42-49, 134(1994) BibTeX

[20]

...

[21]

Peretz Shoval, Nili Shreiber: Database Reverse Engineering: From the Relational to the Binary Relationship model. Data Knowl. Eng. 10: 293-315(1993) BibTeX

[22]

Oreste Signore, Mario Loffredo, Mauro Gregori, Marco Cima: Reconstruction of ER Schema from Database Applications: a Cognitive Approach. ER 1994: 387-402 BibTeX

[23]

Toby J. Teorey, Dongqing Yang, James P. Fry: A Logical Design Methodology for Relational Databases Using the Extended Entity-Relationship Model. ACM Comput. Surv. 18(2): 197-222(1986) BibTeX

[24]

Jeffrey D. Ullman: Principles of Database Systems, 1st Edition. Computer Science Press 1980
BibTeX

Referenced by

1. Noel Novelli, Rosine Cicchetti: FUN: An Efficient Algorithm for Mining Functional and Embedded Dependencies. ICDT 2001: 189-203
2. Ykä Huhtala, Juha Kärkkäinen, Pasi Porkka, Hannu Toivonen: Efficient Discovery of Functional and Approximate Dependencies Using Partitions. ICDE 1998: 392-401
3. Ahmed Mostefaoui, Jacques Kouloumdjian: Translating Relational Queries to Object-Oriented Queries According to ODMG-93. ADBIS 1998: 328-338