Skip to main content
SpringerLink
Log in

Vague Normalization in a Relational Database Model

  • Conference paper
Computer Applications for Database, Education, and Ubiquitous Computing (EL 2012, DTA 2012)

Part of the book series: Communications in Computer and Information Science ((CCIS,volume 352))

  • 1351 Accesses

Abstract

Vague relational database models generalize the classical relational database model by allowing uncertain and imprecise information by means of vague set theory. In this paper, we have introduced vague extensions of the normal forms for a similarity based vague relational database model. Firstly, we have designed an algorithm to find the vague closure of an attribute set which can be utilized to find vague key. Next, with the concepts of α-vfd and partial α-vfd as introduced in [1], we have defined different vague normal forms in a vague relational database. We have also presented examples based on real life application to demonstrate how normalization based on α-vfds of vague relation may be done.

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 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.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. Mishra, J., Ghosh, S.: A New Functional Dependency in a Vague Relational Database Model. International Journal of Computer Applications 39, 29–36 (2012)

    Article  Google Scholar 

  2. Codd, E.: A Relational Model for Large Shared Data Banks. Comm. of ACM 13, 377–387 (1970)

    Article  MATH  Google Scholar 

  3. Mishra, J., Ghosh, S.: A Multivalued Integrity Constraint in Fuzzy Relational Database. International Journal of Computational Cognition 9, 72–78 (2011)

    Google Scholar 

  4. Sözat, M.I., Yazici, A.: A complete axiomatization for fuzzy functional and multivalued dependencies in fuzzy database relations. Fuzzy Sets and Systems 117, 161–181 (2001)

    Article  MATH  MathSciNet  Google Scholar 

  5. Ma, Z.M., Zhang, W.J.: Multivalued dependencies in extended possibility-based fuzzy relational databases. In: IFSA World Congress and 20th NAFIPS International Conference, vol. 1, pp. 352–356 (2001)

    Google Scholar 

  6. Chen, G., Kerre, E.E., Vandenbulcke, J.: Normalization Based on ffd in a Fuzzy Relational Data Model. Information Systems 21, 299–310 (1996)

    Article  Google Scholar 

  7. Raju, K.V.S.V.N., Majumdar, A.K.: Fuzzy functional dependencies and lossless join decomposition of fuzzy relational database system. ACM Transactions on Database Systems 13, 129–166 (1988)

    Article  Google Scholar 

  8. Liu, W.Y.: Fuzzy Data Dependencies and Implication of Fuzzy Data Dependencies. Fuzzy Sets and Systems 92, 341–348 (1997)

    Article  MATH  MathSciNet  Google Scholar 

  9. Bosc, P., Dubois, D., Prade, H.: Fuzzy functional dependencies and redundancy elimination. Journal of the American Society for Information Science 49, 217–235 (1998)

    Article  Google Scholar 

  10. Yazici, A., Sozat, M.I.: The Integrity Constraints for Similarity-Based Fuzzy Relational Databases. International Journal of Intelligent Systems 13, 641–659 (1998)

    Article  Google Scholar 

  11. Shenoi, S., Melton, A.: Functional dependencies and normal forms in the fuzzy relational database model. Information Sciences 60, 1–28 (1992)

    Article  MATH  MathSciNet  Google Scholar 

  12. Bahar, O., Yazici, A.: Normalization and Lossless Join Decomposition of Similarity-Based Fuzzy Relational Databases. International Journal of Intelligent Systems 19, 885–917 (2004)

    Article  MATH  Google Scholar 

  13. Zadeh, L.A.: Fuzzy Sets. Information and Controls 8, 338–353 (1965)

    Article  MATH  MathSciNet  Google Scholar 

  14. Gau, W.L., Buehrer, D.J.: Vague Sets. IEEE Trans. Syst. Man, Cybernetics 23, 610–614 (1993)

    Article  MATH  Google Scholar 

  15. Lu, A., Ng, W.: Managing Merged Data by Vague Functional Dependencies. In: Atzeni, P., Chu, W., Lu, H., Zhou, S., Ling, T.-W. (eds.) ER 2004. LNCS, vol. 3288, pp. 259–272. Springer, Heidelberg (2004)

    Chapter  Google Scholar 

  16. Zhao, F., Ma, Z.M.: Functional Dependencies in Vague Relational Databases. In: IEEE International Conference on Systems Man and Cybernetics, pp. 4006–4010 (2006)

    Google Scholar 

  17. Lu, A., Ng, W.: Maintaining consistency of vague databases using data dependencies. Data and Knowledge Engineering 68, 622–641 (2009)

    Article  Google Scholar 

  18. Codd, E.F.: The relational Model for Database Management. Addison-Wesley (1990)

    Google Scholar 

  19. Date, C.J.: An introduction to Data Base Systems 8/E. Addison Wesley (2004)

    Google Scholar 

  20. Elmasri, R., Navathe, S.B.: Fundamentals of Database Systems. Pearson Education (2007)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. College of Engineering and Management, Kolaghat, West Bengal, India, Pin: 721171

    Jaydev Mishra

  2. Vellore Institute of Technology University, Vellore, Tamilnadu, India, Pin: 632014

    Sharmistha Ghosh

Authors
  1. Jaydev Mishra
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Sharmistha Ghosh
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. GVSA and University of Tasmania, Hobart, TAS, Australia

    Tai-hoon Kim

  2. Hosei University, 3-7-2, Kajino-cho, 184-8584, Koganei-shi, Tokyo, Japan

    Jianhua Ma

  3. National Chiao Tung University, Hsinchu, Taiwan, R.O.C.

    Wai-chi Fang

  4. Victoria University, 8001, Melbourne, VIC, Australia

    Yanchun Zhang

  5. University of Calabria, Via P. Bucci, 41C, I-87036, Rende, Cosenza, Italy

    Alfredo Cuzzocrea

Rights and permissions

Reprints and permissions

Copyright information

© 2012 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Mishra, J., Ghosh, S. (2012). Vague Normalization in a Relational Database Model. In: Kim, Th., Ma, J., Fang, Wc., Zhang, Y., Cuzzocrea, A. (eds) Computer Applications for Database, Education, and Ubiquitous Computing. EL DTA 2012 2012. Communications in Computer and Information Science, vol 352. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-35603-2_49

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-35603-2_49

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-35602-5

  • Online ISBN: 978-3-642-35603-2

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation