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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
W3C Semantic Web: http://www.w3.org/standards/semanticweb/
- 2.
LUBM—Lehigh University Benchmark: http://swat.cse.lehigh.edu/projects/lubm/
- 3.
DBPedia: http://wiki.dbpedia.org/
- 4.
References
The Protégé ontology editor: http://protege.stanford.edu/ (2012)
Astrova, I., Korda, N., Kalja, A.: Storing OWL ontologies in SQL relational databases. Int. J. Electr. Comput. Syst. Eng. 1(4), 242–247 (2007)
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)
Bagui, S.: Mapping OWL to the entity relationship and extended entity relationship models. Int. J. Knowl. Web Intell. 1(1), 125–149 (2009)
Bagui, S., Earp, R.: Database design using entity-relationship diagrams. Auerbach Publications, Boca Raton (2003)
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)
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)
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)
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
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)
Batini, C., Ceri, S., Navathe, S.B.: Conceptual Database Design: An Entity-Relationship Approach. Benjamin/Cummings, Redwood City (1992)
Berardi, D., Calvanese, D., De Giacomo, G.: Reasoning on UML class diagrams. Artif. Intell. 168(1–2), 70–118 (2005)
Berners-Lee, T., Hendler, J., Lassila, O.: The semantic web. Sci. Am. 284(5), 28–37 (2001)
Bizer, C., Seaborne, A.: D2RQ-treating non-RDF databases as virtual RDF graphs. In: Proceedings of the 3rd international semantic web conference (ISWC2004)
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)
Bobillo, F., Straccia, U.: Fuzzy ontology representation using OWL 2. Int. J. Approximate Reasoning 52(7), 1073–1094 (2011)
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)
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)
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)
Calvanese, D., Lenzerini, M., Nardi, D.: Description Logics for Conceptual Data Modeling, chap. 8, pp. 229–264. Kluwer Academic Publisher, Dordrecht (1998)
Chen, P.: The entity-relationship model—toward a unified view of data. ACM Trans. Database Syst. (TODS) 1(1), 9–36 (1976)
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)
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)
Date, C.: An Introduction to Database Systems. Addison-Wesley, Reading (1990)
Fahad, M.: Er2owl: generating owl ontology from er diagram. In: Intelligent information processing, pp. 28–37 (2008)
Jean, S., Pierra, G., Ait-Ameur: Domain ontologies: a database-oriented analysis. In: Web information systems and technologies (WEBIST 2006), pp. 238–254 (2006)
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)
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)
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)
Medina, J.M., Pons, O., Vila, M.A.: GEFRED: a generalized model of fuzzy relational databases. Inf. Sci. 76(1–2), 87–109 (1994)
Motik, B., Horrocks, I., Sattler, U.: Bridging the gap between OWL and relational databases. J. Web Semant. 7(2), 74–89 (2009)
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)
Navathe, S., Elmasri, R.: Fundamentals of database systems. Addison Wesley, Reading (2007)
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)
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)
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)
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)
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)
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)
Teorey, T.J.: Distributed database design: A practical approach and example. SIGMOD Rec. 18(4), 23–39 (1989)
Thalheim, B.: Foundations of entity—relationship modeling. Ann. Math. Artif. Intell. 7(1–4), 197–256 (1993)
Trinkunas, J., Vasilecas, O.: A graph oriented model for ontology transformation into conceptual data model. Inf. Technol. Control 36(1A), 126–132 (2007)
Umano, M.: Freedom-O: A fuzzy database system.In: Fuzzy Information and Decision Processes. North-Holland, New York (1982)
Vysniauskas, E., Nemuraite, L.: Transforming ontology representation from OWL to relational database. Inf. Technol. Control 35A(3), 333–343 (2006)
Zemankova-Leech, M., Kandel, A.: Implementing imprecision in information systems. Inf. Sci. 37, 107–141 (1985)
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)
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
Corresponding author
Editor information
Editors and Affiliations
Rights 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)