A new tool to analyze ER-schemas

Proceedings - 2nd Asia-Pacific Conference on Quality Software, APAQS 2001

Volumn , Issue , 2001, Pages 302-307

  Boufares, Faouzi ^a   Kraïem, Naoufel ^b  

^a CNRS   (France)

^b UNIVERSITY OF MANOUBA   (Tunisia)

Author keywords

Cardinality constraints; CASE tools; Conceptual modeling; Constraints; Entity Relationship model; ER meta model; Information system; Meta modeling; Valid ER schemas

Indexed keywords

DATA MINING; DATABASE SYSTEMS; INFORMATION SYSTEMS; SEMANTICS; SOFTWARE ENGINEERING;

CARDINALITY CONSTRAINTS; CONCEPTUAL MODEL; CONSTRAINTS; ENTITY-RELATIONSHIP MODELING; META MODEL; VALID ER-SCHEMAS;

COMPUTER AIDED SOFTWARE ENGINEERING;

EID: 1542704650     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/APAQS.2001.990035     Document Type: Conference Paper

References (23)

1. P. P. Chen, "The Entity-Relationship Model -Towards a Unified View of Data", volume 1, ACM Transactions On Database Systems, March 1976, pages 9-36.
2. L. Palopoli, D. Sacca and D. Ursino, "DLp : A Description Logic for Extracting and Managing Complex Terminological and Structural Properties from Database Schemes", IS'99, Information Systems, volume 24, No 5, July 1999, pages 401-424.
3. F. Bounaas and D. Rieu, "Rtutilisation pour I'ingtnierie des modèles", MFPE'97, First international Workshop on The Many Facets of Process Engineering", Gammarth, Tunisia, September 22-23 1997, pages 229-244.
4. J. Akoka, I. Comyn-Wattiau and N. Lammari, "Relational Database Reverse Engineering, Elicitation of Generalization Hierarchies", Advances in Conceptual Modeling, ER'99 Workshops on Evolution and Change in Data Management, LNCS 1727, Paris, France, November 1999, pages 173-185.
5. J. M. Smith and D. C. P. Smith, "Database abstractions : Aggregation and Generalization", ACM Transactions On Database Systems", volume 2, N"2, June 1977, pages 105-133.
6. G. Engels, M. Gogolla, U. Hohenstein, K. Hulsmann, P. Lohr-Richter, G. Saake and H. D. Ehrich, "Conceptual modelling of database applications using an extended ER model", Data and Knowledge Engineering, volume 9, 1993, pages 157-204.
7. R. Elmasri and S. B. Navathe, "Fandamentals of Database Systems", The Benjamin Cummings Publishing Company, Inc., Second Edition 1994 .
8. Ch. Soutou, "Objet-relationnel sous oracle& Modélisation avec UML", Eyrolles, Paris 1999.
9. S.K. Lellahi and F. Boufarbs, "Meta-Model and loose Semantics for ER-Model", Rapport Technique LIPN No 2000-3, Mai 2000.
10. J. P. Matheron, "Approfondir MERISE", Eyrolles, Paris 1991.
11. A. Rochfeld and P. Negros, "Relationship of relationships and other inter-relationship links in E-R model", Data and Knowledge Engineering, volume 9, 1993, pages 205-221.
12. J. B. Behm and T. J. Teorey, "Relative Constraints in ER Data Models", ER'93 : Entity-Relationship Approach, 12th International Conference on the Entity-Relationship Approach, LNCS 823, Arlington, Texas, USA, December 1993, pages 46-59.
13. O. Rauh and E. Stickel, "Standard Transformations for the Normalization of ER Schemata", IS'96, Information Systems, volume 21, No 2, 1996, pages 187-208.
14. S. Hartmann, "On Interactions of Cardinality Constraints, Key, and Functional Dependencies", FolKS'2000 : Foundations of Information and Knowledge Systems, First International Symposium, LNCS 1762, Burg, Germany, February 2000, pages 136- 155.
15. B. Thalheim, "Fandamentals of Cardinality Constraints", ER'92 : Entity-Relationship Approach, 11th International Conference on the Entity-Relationship Approach, LNCS 645, Karlsruhe, Germany, October 7-9 1992, pages 7-23.
16. S. Hartmann, "On the Consistency of Int-cardinality Constraints", ER'98 : Conceptual Modeling, 17th International Conference on Conceptual Modeling, LNCS 1507, Singapore, November 1998, pages 150-163.
17. F. Boufarès, "Un outil intelligent pour I'analyse des schémas EA", Rapport Technique LIPN No 2001-3, Mars 2001.
18. P.T. Quang and C. Chartier Kastler, "MERISE Appliquée, Conception des Systèmes d'Information, de la Théorie i à Pratique", Eyrolles, Paris 1989.
19. M. Lenzerini and P. Nobili ,"On the satisfiability of dependency constraints in Entity-Relationship schemata", IS 90, Information Systems, volume 15, No 4, 1990, pages 453-461.
20. B. Thalheim, "The Higher-Order Entity-Relationship Model and (DB)2", MFDBS'89 : 2nd Symposium on Mathematical Fandamentals of Database Systems, LNCS 364, Visegrad, Hungary, June 26-301989, pages 382-397.
21. M. Balaban and P. Shoval, "Resolving the Weak Status of Weak Entity Types in Entity Relationship Schemas", ER'99, Conceptual Modeling, 18th International Conference on conceptual Modeling, LNCS 1728, Paris, France, November 1999, pages 367-383.
22. J. Dullea and 11-Yeol Song, "A Taxonomy of Recursive Relationships and Their Structural Validity in ER Modeling", ER'99, Conceptual Modeling, 18th International Conference on Conceptual Modeling, LNCS 1728, Paris, France, November 1999, pages 384-398.
23. F. Boufarès and N. Kraïem "An intelligent tool for analyzing ER-schemas in order to discover unreliable sets of cardinality constraints", 5th World multiconference on Systemics, Cybernetics and Informatics (SCI2001) and 7th international conference on Informations Systems Analysis and Synthesis (ISAS2001), July 22-25, 2001, Orlando, Florida, USA.