skip to main content
10.1145/1028664.1028734acmconferencesArticle/Chapter ViewAbstractPublication PagessplashConference Proceedingsconference-collections
Article

Improving quality in conceptual modeling

Published: 23 October 2004 Publication History

Abstract

Quality of a conceptual model can be defined along three dimensions - syntax, semantics and pragmatic. Pragmatic quality has been improved in the literature through schema transformations. We suggest an approach that also improves the semantic quality by schema transformations. A semantic quality parameter 'extent of normalization' is defined. Based on this parameter and functional dependencies from problem domain, a set of rules is suggested to improve a given conceptual model. We also show that relational schema produced after these transformations is normalized up to 3NF at least.

References

[1]
Assenova, P., Johannesson, P. (1996) Improving Quality in Conceptual Modelling by the Use of Schema Transformations. ACM SIGMOD 15th Int'l Conf. On Conceptual Modeling.
[2]
Chen, P.P. (1976) The entity relationship model: towards a unified view of data. ACM Transactions on Database Design, 1(1), 9--36.
[3]
Codd, E.F. (1972) Further normalization of the data base relational model. Data Base Systems, Courant Computer Science Symphosia Series, Vol. 6, Prentice-Hall, 33--64.
[4]
Codd, E.F. (1974) Relational investigations in relational database systems. Proceedings of the IFIP Congress.
[5]
Cosmadakis, S., Kanellakis, P. C., Vardi, M. (1990) Polynomial-time Implication Problems For Unary Inclusion Dependencies. JACM, 37(1), 15--46.
[6]
Elmasri, R., and Navathe, S. (2004) Fundamentals of database systems, 4th Ed. Pearson Education, Inc.
[7]
Elmasri, R., Weeldreyer, J., and Henver, A. (1985) The category concept: An extension to the entity-relationship model. International Journal on Data and Knowledge Engineering, 1(1).
[8]
Engels, G., Gogolla, M., Hohenstein, U., Hülsmann, K., L&246;hr-Richter, P., Saake, G., Ehrich D. (1992) Conceptual modelling of database applications using an extended ER model. Data and Knowledge Engineering, 9(2), 157--204.
[9]
Fagin, R. (1977) Multivalued Dependencies and a New Normal Form For Relational Databases. ACM Transactions on Database Systems, 2(3).
[10]
Gogolla, M., and Hohenstein, U. (1991) Towards a semantic view of an extended entity-relationship model. ACM Transactions on Database Systems, 16(3), 369--416.
[11]
Halpin, T. A. (1996) Business Rules and Object-Role Modeling, Database Prog. & Design, 9(10), CA, 66--72.
[12]
Hussain, T., Shamail, S., Awais, M.M. (2004), Multi-Valued Relationship Attributes in Extended Entity Relationship Model and Their Mapping to Relational Schema, WSEAS Transactions on Information Science and Applications, 1(1), 269--273.
[13]
Teorey, T., Yang, D., and Fry, J. (1986) A logical design methodology for relational databases using the extended entity relationship model. ACM Computing Surveys, 18(2), 197--222.
[14]
Thalheim, B. (2000) Entity-Relationship Modeling: Foundations of Database Technology. Springer-Verlag.
[15]
Tsou, D. M., and Fischer, P. C. (1982) Decomposition of a Relational Scheme into Boyce Codd Normal Form. SIGACT News 14(3), 23--29.
[16]
Ullman, J. D. (1990) Principles of database systems. 2nd Ed., Computer Science Press.

Cited By

View all
  • (2018)Automated Evaluation of Correctness and Quality of Database Conceptual SchemasProceedings of the 2018 International Conference on Big Data Engineering and Technology10.1145/3297730.3297749(20-25)Online publication date: 25-Aug-2018
  • (2009)Conceptual ModelingConceptual Modeling: Foundations and Applications10.1007/978-3-642-02463-4_9(139-152)Online publication date: 4-Jul-2009

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
OOPSLA '04: Companion to the 19th annual ACM SIGPLAN conference on Object-oriented programming systems, languages, and applications
October 2004
348 pages
ISBN:1581138334
DOI:10.1145/1028664
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 23 October 2004

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. ER model
  2. conceptual model
  3. functional dependency
  4. normalization
  5. schema transformation

Qualifiers

  • Article

Conference

OOPSLA04
Sponsor:

Upcoming Conference

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)3
  • Downloads (Last 6 weeks)0
Reflects downloads up to 08 Feb 2025

Other Metrics

Citations

Cited By

View all
  • (2018)Automated Evaluation of Correctness and Quality of Database Conceptual SchemasProceedings of the 2018 International Conference on Big Data Engineering and Technology10.1145/3297730.3297749(20-25)Online publication date: 25-Aug-2018
  • (2009)Conceptual ModelingConceptual Modeling: Foundations and Applications10.1007/978-3-642-02463-4_9(139-152)Online publication date: 4-Jul-2009

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media