Skip to main content
SpringerLink
Log in

Semantic Data Management Using Fuzzy Relational Databases

  • Chapter
  • First Online:
Book cover Flexible Approaches in Data, Information and Knowledge Management

Part of the book series: Studies in Computational Intelligence ((SCI,volume 497))

Abstract

This chapter presents a schema and a transformation algorithm to store OWL ontologies in Object Relational Databases. The database schema allows the storage of an ontology structure, while the transformation algorithm creates an appropriate schema to store its instances preserving all information. We allow the use of instance data of imprecise nature, mostly fuzzy numerical data. An OWL ontology is defined allowing numerical fuzzy datatypes as the range of properties. In order to manage all the information, instance data handling is delegated onto a Fuzzy ORDBMS, which is briefly described. We present here a complete description of the structures conforming the storage schema proposed, and the algorithms used to transform the OWL ontology to a database schema. We also discuss the role of ontologies as relational database design tools.

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 EPUB and 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
Hardcover Book
USD 109.99
Price excludes VAT (USA)
  • Durable hardcover 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

Notes

  1. 1.

    W3C Semantic Web: http://www.w3.org/standards/semanticweb/

  2. 2.

    LUBM—Lehigh University Benchmark: http://swat.cse.lehigh.edu/projects/lubm/

  3. 3.

    DBPedia: http://wiki.dbpedia.org/

  4. 4.

    http://www.w3.org/TR/owl-features/

References

  1. The Protégé ontology editor: http://protege.stanford.edu/ (2012)

  2. Astrova, I., Korda, N., Kalja, A.: Storing OWL ontologies in SQL relational databases. Int. J. Electr. Comput. Syst. Eng. 1(4), 242–247 (2007)

    Google Scholar 

  3. Baader, F., Werner, N.: The Description Logic Handbook: Theory, Implementation, and Applications, chap. Basic Description Logics, pp. 47–100. Cambridge University Press, New York (2003)

    Google Scholar 

  4. Bagui, S.: Mapping OWL to the entity relationship and extended entity relationship models. Int. J. Knowl. Web Intell. 1(1), 125–149 (2009)

    Article  Google Scholar 

  5. Bagui, S., Earp, R.: Database design using entity-relationship diagrams. Auerbach Publications, Boca Raton (2003)

    Google Scholar 

  6. Barranco, C.D., Campaña, J.R., Medina, J.M.: Improving query expressiveness in product search interfaces using fuzzy logic. WSEAS Trans. Bus. Econ. 2(2), 80–87 (2005)

    Google Scholar 

  7. Barranco, C.D., Campaña, J.R., Medina, J.M.: A B+-Tree based indexing technique for fuzzy numerical data. Fuzzy Sets Syst. (Advances in Intelligent Databases and Information Systems) 159(12), 1431–1449 (2008)

    Google Scholar 

  8. Barranco, C.D., Campaña, J.R., Medina, J.M.: Handbook of Research on Fuzzy Information Processing in Databases, chap. Towards a Fuzzy Object-Relational Database Model, 1st edn., pp. 431–461. Hershey, Pennsylvania (2008)

    Google Scholar 

  9. Barranco, C.D., Campaña, J.R., Medina, J.M., Pons, O.: On storing ontologies including fuzzy datatypes in relational databases. Fuzzy systems conference, 2007. FUZZ-IEEE 2007. IEEE, international pp. 1–6, 23–26 July 2007

    Google Scholar 

  10. Barrasa, J., Corcho, O., Gómez-Pérez, A.: R2O, an extensible and semantically based database-to-ontology mapping language. In: Proceedings of the second workshop on semantic web and databases (SWDB2004) (2004)

    Google Scholar 

  11. Batini, C., Ceri, S., Navathe, S.B.: Conceptual Database Design: An Entity-Relationship Approach. Benjamin/Cummings, Redwood City (1992)

    Google Scholar 

  12. Berardi, D., Calvanese, D., De Giacomo, G.: Reasoning on UML class diagrams. Artif. Intell. 168(1–2), 70–118 (2005)

    Article  MATH  Google Scholar 

  13. Berners-Lee, T., Hendler, J., Lassila, O.: The semantic web. Sci. Am. 284(5), 28–37 (2001)

    Article  Google Scholar 

  14. Bizer, C., Seaborne, A.: D2RQ-treating non-RDF databases as virtual RDF graphs. In: Proceedings of the 3rd international semantic web conference (ISWC2004)

    Google Scholar 

  15. Blanco, I.J., Vila, M.A., Martinez-Cruz, C.: The use of ontologies for representing database schemas of fuzzy information. Int. J. Intell. Syst. 23(4), 419–445 (2008)

    Google Scholar 

  16. Bobillo, F., Straccia, U.: Fuzzy ontology representation using OWL 2. Int. J. Approximate Reasoning 52(7), 1073–1094 (2011)

    Article  MathSciNet  Google Scholar 

  17. Borgida, A., Lenzerini, M., Rosati, R.: The Description Logic Handbook: Theory, Implementation, and Applications, chap. Description Logics for Databases, pp. 462–484. Cambridge University Press, New York (2003)

    Google Scholar 

  18. Calvanese, D., De Giacomo, G., Lembo, D., Lenzerini, M., Rosati, R.: Tractable reasoning and efficient query answering in description logics: the DL-Lite family. J. Autom Reasoning 39(3), 385–429 (2007)

    Article  MATH  Google Scholar 

  19. Calvanese, D., De Giacomo, G., Lembo, D., Lenzerini, M., Rosati, R., Vetere, G.: DL-Lite: practical reasoning for rich DLs. In: Proceedings of the 2004 description logic workshop (DL 2004). CEUR electronic workshop proceedings (2004)

    Google Scholar 

  20. Calvanese, D., Lenzerini, M., Nardi, D.: Description Logics for Conceptual Data Modeling, chap. 8, pp. 229–264. Kluwer Academic Publisher, Dordrecht (1998)

    Google Scholar 

  21. Chen, P.: The entity-relationship model—toward a unified view of data. ACM Trans. Database Syst. (TODS) 1(1), 9–36 (1976)

    Article  Google Scholar 

  22. Cubero, J.C., Marín, N., Medina, J.M., Pons, O., Vila, M.A.: Fuzzy object management in an object-relational framework. In: X International conference of information processing and management of uncertainty in knowledge-based systems, pp. 1767–1774 (2004)

    Google Scholar 

  23. Das, S., Chong, E.I., Eadon, G., Srinivasan, J.: Supporting ontology-based semantic matching in RDBMS. In: Proceedings of the 30th VLDB conference. Toronto, Canada, pp. 1054–1065 (2004)

    Google Scholar 

  24. Date, C.: An Introduction to Database Systems. Addison-Wesley, Reading (1990)

    Google Scholar 

  25. Fahad, M.: Er2owl: generating owl ontology from er diagram. In: Intelligent information processing, pp. 28–37 (2008)

    Google Scholar 

  26. Jean, S., Pierra, G., Ait-Ameur: Domain ontologies: a database-oriented analysis. In: Web information systems and technologies (WEBIST 2006), pp. 238–254 (2006)

    Google Scholar 

  27. Kalyanpur, A., Parsia, B., Sirin, E., Grau, B.C., Hendler, J.: Swoop: a web ontology editing browser. Web Semant. Sci. Serv. Agents WWW 4(2), 144–153 (2006)

    Article  Google Scholar 

  28. Martínez-Cruz, C., Blanco, I.J., Vila, M.A.: Describing fuzzy DB schemas as ontologies: a system architecture view. In: Information Processing and Management of Uncertainty in Knowledge-Based Systems. Applications, Communications in Computer and Information Science, vol. 81, pp. 147–157. Springer, Berlin (2010)

    Google Scholar 

  29. Medina, J.M., Galindo, J., Berzal, F., Serrano, J.M.: Using object relational features to build a fuzzy database server. In: VIII international conference of information processing and management of uncertainty in knowledge-based systems (IPMU 2002), pp. 307–314 (2002)

    Google Scholar 

  30. Medina, J.M., Pons, O., Vila, M.A.: GEFRED: a generalized model of fuzzy relational databases. Inf. Sci. 76(1–2), 87–109 (1994)

    Article  Google Scholar 

  31. Motik, B., Horrocks, I., Sattler, U.: Bridging the gap between OWL and relational databases. J. Web Semant. 7(2), 74–89 (2009)

    Article  Google Scholar 

  32. Myroshnichenko, I., Murphy, M.C.: Mapping er schemas to owl ontologies. In: Proceedings of the 2009 IEEE international conference on semantic computing, ICSC ’09, pp. 324–329 (2009)

    Google Scholar 

  33. Navathe, S., Elmasri, R.: Fundamentals of database systems. Addison Wesley, Reading (2007)

    Google Scholar 

  34. Pokorný, J., Vojtáš, P.: A data model for flexible querying. In Proceedings of ADBIS’01. Lecture Notes in Computer Science, vol. 2151, pp. 280–293 (2001)

    Google Scholar 

  35. Prade, H., Testemale, C.: Generalizing database relational algebra for the treatment of incomplete or uncertain information and vague queries. Inf. Sci. 34, 115–143 (1984)

    Article  MathSciNet  MATH  Google Scholar 

  36. Roldán García, M., Navas Delgado, I., Aldana Montes, J.: A design methodology for semantic web database-based systems. In: ICITA (1), pp. 233–237 (2005)

    Google Scholar 

  37. Straccia, U.: A fuzzy description logic for the semantic web. In: Sanchez, E. (ed.) Fuzzy Logic and the Semantic Web, Capturing Intelligence, chap. 4, pp. 73–90. Elsevier, Amsterdam (2006)

    Google Scholar 

  38. Straccia, U.: SoftFacts: A top-k retrieval engine for ontology mediated access to relational databases. In: Proceedings of the 2010 IEEE International Conference on Systems, Man and, Cybernetics (SMC-10), pp. 4115–4122 (2010)

    Google Scholar 

  39. Sugumaran, V., Storey, V.C.: The role of domain ontologies in database design: an ontology management and conceptual modeling environment. ACM Trans. Database Syst. 31(3), 1064–1094 (2006)

    Article  Google Scholar 

  40. Teorey, T.J.: Distributed database design: A practical approach and example. SIGMOD Rec. 18(4), 23–39 (1989)

    Article  Google Scholar 

  41. Thalheim, B.: Foundations of entity—relationship modeling. Ann. Math. Artif. Intell. 7(1–4), 197–256 (1993)

    Article  MathSciNet  MATH  Google Scholar 

  42. Trinkunas, J., Vasilecas, O.: A graph oriented model for ontology transformation into conceptual data model. Inf. Technol. Control 36(1A), 126–132 (2007)

    Google Scholar 

  43. Umano, M.: Freedom-O: A fuzzy database system.In: Fuzzy Information and Decision Processes. North-Holland, New York (1982)

    Google Scholar 

  44. Vysniauskas, E., Nemuraite, L.: Transforming ontology representation from OWL to relational database. Inf. Technol. Control 35A(3), 333–343 (2006)

    Google Scholar 

  45. Zemankova-Leech, M., Kandel, A.: Implementing imprecision in information systems. Inf. Sci. 37, 107–141 (1985)

    Article  Google Scholar 

  46. Zhang, F., Ma, Z.M., Yan, L., Wang, Y.: A description logic approach for representing and reasoning on fuzzy object-oriented database models. Fuzzy Sets Syst. 186(1), 1–25 (2012)

    Article  MathSciNet  MATH  Google Scholar 

Download references

Acknowledgments

This work has been partially supported by the “Consejería de Economía, Innovación, Ciencia y Empleo de Andalucía” (Spain) under research projects P10-TIC-6109 and P11-TIC-7460.

Author information

Authors and Affiliations

  1. Department of Computer Science and Artificial Intelligence, University of Granada, 18071 , Granada, Spain

    Jesús R. Campaña, Juan M. Medina & Maria A. Vila

Authors
  1. Jesús R. Campaña
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Juan M. Medina
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Maria A. Vila
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Jesús R. Campaña .

Editor information

Editors and Affiliations

  1. IRISA/ENSSAT, Université de Rennes 1, Lannion Cedex, France

    Olivier Pivert

  2. Systems Research Institute, Polish Academy of Sciences, Warsaw, Poland

    Sławomir Zadrożny

Rights and permissions

Reprints and permissions

Copyright information

© 2014 Springer International Publishing Switzerland

About this chapter

Cite this chapter

Campaña, J.R., Medina, J.M., Vila, M.A. (2014). Semantic Data Management Using Fuzzy Relational Databases. In: Pivert, O., Zadrożny, S. (eds) Flexible Approaches in Data, Information and Knowledge Management. Studies in Computational Intelligence, vol 497. Springer, Cham. https://doi.org/10.1007/978-3-319-00954-4_6

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-00954-4_6

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-00953-7

  • Online ISBN: 978-3-319-00954-4

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics

Search

Navigation