Skip to main content
SpringerLink
Log in

Applying a Fuzzy Approach to Relaxing Cardinality Constraints

  • Conference paper
Database and Expert Systems Applications (DEXA 2004)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 3180))

Included in the following conference series:

Abstract

In database applications the verification of cardinality constraints is a serious and complex problem that appears when the modifications operations are performed in a large cascade. Many efforts have been devoted to solve this problem, but some solutions lead to other problems such as the complex execution model or an impact on the database performance. In this paper a method to reducing and simplifying the complex verification of cardinality constraints by relaxing these constraints using fuzzy concepts is proposed.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Elmasri, R., Navathe, S.: Fundamentals of Database Systems, 3rd edn. Addison-Wesley, Reading (2000)

    Google Scholar 

  2. Teorey, T.J.: Database Modeling & Design, 3rd edn. Morgan Kaufmann Series in data management systems (1999)

    Google Scholar 

  3. Teorey, T., Yang, D., Fry, J.: A Logical Design Methodology for Relation Databases Using the Extended Entity-Relationship Model. Computer Surveys 18(2) (1986)

    Google Scholar 

  4. Song, I.-Y., Evans, M., Park, E.K.: A Comparative Analysis of Entity-Relationship Diagrams. Journal of Computer and Software Engineering 3(4), 427–459 (1995)

    Google Scholar 

  5. Chen, P.: The Entity-Relationship Model – Toward a Unified View of Data. ACM Transactions on Database Systems 1(1) (1976)

    Google Scholar 

  6. Cuadra, D., Nieto, C., Castro, E., Martínez, P., Velasco, M.: Preserving relationship cardinality constraints in relational schemata. In: Database Integrity: Challenges and Solutions, Idea Group Publishing, USA (2002)

    Google Scholar 

  7. Al-Jumaily, H., Cuadra, D., Martínez, P.: PANDORA CASE TOOL: Generating triggers for cardinality constraints verification in RDBMS. In: IADIS International Conference, Portugal (2003)

    Google Scholar 

  8. Al-Jumaily, H., Cuadra, D., Martínez, P.: Incorporando Técnicas Activas para la Conservación de Semántica en la Transformación de Esquemas. VIII Jornadas de Ingeniería del Software y Bases de Datos, Alicante (November 12-14, 2003)

    Google Scholar 

  9. Paton, N.W.: Active Rules in Database Systems. Springer, New York (1998)

    Google Scholar 

  10. Lazarevic, B., Misic: Extending the entity-relationship model to capture dynamic behaviour. European Journal Information Systems 1(2), 95–106 (1991)

    Article  Google Scholar 

  11. Balaban, M., Shoval, P.: MEER - An EER model enhanced with structure methods. Information Systems 27, 245–275 (2002)

    Article  MATH  Google Scholar 

  12. Chen, G.: Fuzzy Logic in Data Modeling; Semantic, Constraints, and Database Design. Kluwer Academic Publishers, London (1998)

    Google Scholar 

  13. Galindo, J., Urrutia, A., Carrasco, R., Piattini, M.: Fuzzy Constraints using the Enhanced Entity-Relationship Model. In: XXI International Conference of the Chilean Computer Science Society, Chile (2001)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Dept of Computer Sciences, University of Carlos III in Madrid, Spain

    Harith T. Al-Jumaily, Dolores Cuadra & Paloma Martínez

Authors
  1. Harith T. Al-Jumaily
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Dolores Cuadra
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Paloma Martínez
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. University of Zaragoza, Ciudad Universitaria, Plaza San Francisco, 50009, Zaragoza

    Fernando Galindo

  2. Seikei University, Japan

    Makoto Takizawa

  3. Institute of Informatics in Business and Government, University of Linz, Altenbergerstr. 69, 4040, Linz, Austria

    Roland Traunmüller

Rights and permissions

Reprints and permissions

Copyright information

© 2004 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Al-Jumaily, H.T., Cuadra, D., Martínez, P. (2004). Applying a Fuzzy Approach to Relaxing Cardinality Constraints. In: Galindo, F., Takizawa, M., Traunmüller, R. (eds) Database and Expert Systems Applications. DEXA 2004. Lecture Notes in Computer Science, vol 3180. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-30075-5_63

Download citation

  • DOI: https://doi.org/10.1007/978-3-540-30075-5_63

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-22936-0

  • Online ISBN: 978-3-540-30075-5

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation