article

Bringing relational databases into the semantic web: a survey

Authors:

Dimitrios-Emmanuel Spanos,

Periklis Stavrou,

Nikolas MitrouAuthors Info & Claims

Semantic Web, Volume 3, Issue 2

Pages 169 - 209

Published: 01 April 2012 Publication History

Abstract

Relational databases are considered one of the most popular storage solutions for various kinds of data and they have been recognized as a key factor in generating huge amounts of data for Semantic Web applications. Ontologies, on the other hand, are one of the key concepts and main vehicle of knowledge in the Semantic Web research area. The problem of bridging the gap between relational databases and ontologies has attracted the interest of the Semantic Web community, even from the early years of its existence and is commonly referred to as the database-to-ontology mapping problem. However, this term has been used interchangeably for referring to two distinct problems: namely, the creation of an ontology from an existing database instance and the discovery of mappings between an existing database instance and an existing ontology. In this paper, we clearly define these two problems and present the motivation, benefits, challenges and solutions for each one of them. We attempt to gather the most notable approaches proposed so far in the literature, present them concisely in tabular format and group them under a classification scheme. We finally explore the perspectives and future research steps for a seamless and meaningful integration of databases into the Semantic Web.

References

[1]

ISO/IEC 9075-1 :2008, SQL Part 1: Framework (SQL/Framework), International Organization for Standardization, 27 January 2009.

[2]

ISO/IEC 9075-14:2008. SQL Part 14: XML-Related Specifications (SQL/XML), International Organization for Standardization, 27 January 2009.

[3]

S. Abiteboul, R. Hull and V. Vianu, Foundations of Databases, 1st edn, Addison-Wesley, New York City, NY, 1995.

[4]

N. Alalwan, H. Zedan and F. Siewe, Generating OWL ontology for database integration, in: Proc. of the Third International Conference on Advances in Semantic Processing (SEMAPRO 2009), P. Dini, J. Hendler, J. Noll et al., eds, IEEE, 2009, pp. 22-31.

Digital Library

[5]

K. M. Albarrak and E. H. Sibley, Translating relational & object-relational database models into OWL models, in: Proc. of the 2009 IEEE International Conference on Information Reuse & Integration (IRI 2009), S. Rubin and S.-C. Chen, eds, IEEE, 2009, pp. 336-341.

[6]

R. Alhajj, Extracting the extended entity-relationship model from a legacy relational database, Information Systems, 28(6) (2003), 597-618.

Digital Library

[7]

Y. An, A. Borgida, R.J. Miller and J. Mylopoulos, A semantic approach to discovering schema mapping expressions, in: Proc. of 2007 IEEE 23rd International Conference on Data Engineering (ICDE 2007), R. Chirkova and V. Oria, eds, IEEE, 2007, pp. 206-215.

[8]

Y. An, A. Borgida and J. Mylopoulos, Discovering the semantics of relational tables through mappings, Journal on Data Semantics, VII (2006), 1-32.

Digital Library

[9]

Y. An, X. Hu and I.-Y. Song, Round-trip engineering for maintaining conceptual-relational mappings, in: Advanced Information Systems Engineering: 20th International Conference (CAiSE 2008), Z. Bellahsène and M. Léonard, eds, Lecture Notes on Computer Science, Vol. 5074, Springer, 2008, pp. 296-311.

[10]

R. Angles and C. Gutierrez, The expressive power of SPARQL, in: The Semantic Web - ISWC 2008: 7th International Semantic Web Conference, A. Sheth, S. Staab, M. Dean, M. Paolucci, D. Maynard, T. Finin and K. Thirunarayan, eds, Lecture Notes in Computer Science. Vol. 5318, Springer, 2008, pp. 114-129.

[11]

I. Astrova, Reverse engineering of relational databases to ontologies, in: The Semantic Web: Research and Applications: First European Semantic Web Symposium (ESWS 2004), C, J. Bussler, J. Davies, D. Fensel and R. Studer, eds, Lecture Notes in Computer Science, Vol. 3053, Springer, 2004, pp. 327-341.

[12]

I. Astrova, Rules for mapping SQL relational databases to OWL ontologies, in: Metadata and Semantics, M.-A. Sicilia and M. D. Lytras, eds, Springer, 2009, pp. 415-424.

[13]

P. Atzeni, S. Paolozzi and P. Del Nostro, Ontologies and databases: Going back and forth, in: Proc. of the 4th International VLDB Workshop on Ontology-based Techniques for Databases in Information Systems and Knowledge Systems (ODBIS 2008), 2008, pp. 9-16.

[14]

S. Auer, S. Dietzold, J. Lehmann, S. Hellmann and D. Aumueller, Triplify: Light-weight linked data publication from relational databases, in: Proc. of the 18th International Conference on World Wide Web (WWW'09), ACM, 2009, pp. 621- 630.

Digital Library

[15]

F. Baader, D. L. McGuinness, P.F. Patel-Schneider and D. Nardi, The Description Logic Handbook: Theory, Implementation, and Applications, 2nd edn, Cambridge University Press, 2007.

[16]

M. Baglioni, M. V. Masserotti, C. Renso and L. Spinsanti, Building geospatial ontologies from geographical databases, in: GeoSpatial Semantics: Second International Conference (GeoS 2007), F. Fonseca, M. A. Rodríguez and S. Levashkin, eds, Lecture Notes in Computer Science, Vol. 4853, Springer, 2007, pp.195-209.

[17]

J. Barrasa-Rodriguez and A. Gómez-Pérez, Upgrading relational legacy data to the semantic web, in: Proc. of the 15th International Conference on World Wide Web (WWW'06), ACM, 2006, pp. 1069-1070.

Digital Library

[18]

J. Barrasa, O. Corcho and A. Gómez-Pérez, R20, an extensible and semantically based database-to-ontology mapping language, in: Second International Workshop on Semantic Web and Databases (SWDB 2004), 2004.

[19]

D. Beckett and J. Grant, SWAD-Europe Deliverable 10.2: Mapping Semantic Web Data with RDBMSes, available at: http://www.w3.org/2001/sw/Europe/reports/scalable_rdbms_mapping_report/%, Technical Report, 2003.

[20]

A. Behm, A. Geppert and K. R. Dittrich, On the migration of relational schemas and data to object -oriented database systems, in: Proc. of the 5th International Conference on ReTechnologies for Information Systems (ReTIS 1997), 1997. pp.13-33.

[21]

C. Ben Necib and J.-C. Freytag, Semantic query transformation using ontologies, in: Proc. of 9th International Database Engineering & Application Symposium (IDEAS 2005), B.C. Desai and G. Vossen, eds, IEEE, 2005, pp. 187-199.

[22]

T. Bemers-Lee, Relational Databases on the Semantic Web, available at: http://www.w3.org/DesignIssues/RDB-RDF.html, 1998.

[23]

T. Bemers-Lee, Semantic Web Road map, available at: http://www.w3.org/DesignIssues/Semantic.html. 1998.

[24]

A. Bertails and E. G. Prud'hommeaux, Interpreting relational databases in the RDF domain, in: Proc. of the 2011 Knowledge Capture Conference (K-CAP 2011), M. A. Musen and O. Corcho, eds, ACM, 2011, pp. 129-135.

Digital Library

[25]

C. Bizer and R. Cyganiak, D2R server -Publishing relational databases on the semantic web, Poster in 5th International Semantic Web Conference (ISWC 2006), 2006.

[26]

C. Bizer and A. Schultz, The Berlin SPARQL Benchmark, International Journal on Semantic Web and Information Systems, 5(2) (2009), 1-24.

[27]

C. Bizer and A. Seaborne, D2RQ -Treating non-RDF Databases as virtual RDF graphs, Poster in 3rd International Semantic Web Conference (ISWC 2004), 2004.

[28]

C. Blakeley, Virtuoso RDF Views -Getting Started Guide, available at: http://www.openlinksw.co.uk/virtuoso/Whitepapers/pdf/Virtuoso_SQL_to_RD%F_Mapping.pdf, OpenLink Software, 2007.

[29]

A. Buccella, M. R. Penabad, F. R. Rodriguez, A. Farina and A. Cechich, From relational databases to OWL ontologies, in Proc. of 6th Russian Conference on Digital Libraries (RCDL 2004), 2004.

[30]

G. Bümans and K. Čerans, RDB20WL: A practical approach for transforming RDB data into RDF/OWL, in: Proc. of the 6th International Conference on Semantic Systems (1-SEMANTICS 2010), A. Paschke, N. Henze and T. Pellegrini, eds, ACM, 2010.

[31]

K. Byrne, Having triplets -Holding cultural data as RDF, in: Proc. of the ECDL 2008 Workshop on Information Access to Cultural Heritage, M. Larson, K. Fernie, J. Oomen and J. Cigarran, eds, 2008.

[32]

D. Calvanese, G. De Giacomo, D. Lembo, M. Lenzerini, A. Poggi, M. Rodriguez-Muro, R. Rosati, M. Ruzzi and D. F. Savo, The MASTRO system for ontology-based data access, Semantic Web Journal, 2(1) (2011),43-53.

Digital Library

[33]

D. Calvanese, M. Lenzerini and D. Nardi, Unifying classbased representation formalisms, Journal of Artificial Intelligenee Research, 11 (1999), 199-240.

Digital Library

[34]

F. Cerbah, Mining the content of relational databases to learn ontologies with deeper taxonomies, in: Proc. of 2008 IEEE/WIC/ACM International Conference on Web Intelligence and Intelligent Agent Technology Workshops (WI-IAT 2008), Y. Li, G. Pasi, C. Zhang, N. Cercone and L. Cao, eds, IEEE, 2008, pp. 553-557.

[35]

P.-A. Champin, G.-J. Houben and P. Thiran, CROSS: An OWL wrapper for reasoning on relational databases, in: Conceptual Modeling ER 2007: 26th International Conference on Conceptual Modeling, C. Parent, K.-D. Schewe, V.C. Storey and B. Thalheim, eds, Lecture Notes in Computer Science, Vol. 4801, Springer, 2007, pp. 502-517.

[36]

N. Chatterjee and M. Krishna, Semantic integration of heterogeneous databases on the web, in: International Conference on Computing: Theory and Applications (ICCTA 2007), B. B. Bhattacharyya, C. A. Murthy, B. B. Chaudhuri and B. Chanda, eds, IEEE, 2007, pp. 325-329.

Digital Library

[37]

A. Chebotko, S. Lu and F. Fotouhi, Semantics preserving SPARQL-to-SQL translation, Data & Knowledge Engineering, 68(10) (2009), 973-1000.

Digital Library

[38]

H. Chen, Z. Wu, Y. Mao and G. Zheng, DartGrid: A semantic infrastructure for building database grid applications, Concurrency and Computation: Practice and Experience, 18(14) (2006), 1811-1828.

Digital Library

[39]

P. P.-S. Chen, The entity-relationship model Toward a unified view of data, ACM Transactions on Database Systems (TODS), 1(1) (1976),9-36.

[40]

R. H. Chiang, T. M. Barron and V.C. Storey, Reverse engineering of relational databases: Extraction of an EER model from a relational database, Data & Knowledge Engineering, 12(2) (1994),107-142.

Digital Library

[41]

E. F. Codd, A relational model of data for large shared data banks, Communications of the ACM, 13(6) (1970), 377-387.

Digital Library

[42]

O. Curé and R. Squelbut, A database trigger strategy to maintain knowledge bases developed via data migration, in: Progress in Artificial Intelligence: 12th Portuguese Conference on Artificial Intelligence (EPIA 2005), C. Bento, A. Cardoso and G. Dias, eds, Lecture Notes in Computer Science, Vol. 3808, Springer, 2005, pp. 206-217.

Digital Library

[43]

C. Curino, G. Orsi, E. Panigati and L. Tanca, Accessing and documenting relational databases through OWL ontologies, in: Flexible Query Answering Systems: 8th International Conference (FQAS 2009), T. Andreasen, R. R. Yager, H. Bulskov, H. Christiansen and H. Legind Larsen, eds, Lecture Notes in Computer Science, Vol. 5822, Springer, 2009, pp. 431-442.

Digital Library

[44]

R. Cyganiak, A relational algebra for SPARQL, Technical Report HPL-2005-170, Hewlett-Packard, 2005.

[45]

S. Das and J. Srinivasan, Database technologies for RDF, in: Reasoning Web. Semantic Technologies for Information Systems: 5th International Summer School 2009, S. Tessaris, E. Franconi, T. Eiter, C. Gutierrez, S. Handschuh, M.-C. Rousset and R. A. Schmidt, eds, Lecture Notes in Computer Science, Vol. 5689, Springer, 2009, pp. 205-221.

[46]

J. de Bruijn, F. Martin-Recuerda, D. Manov and M. Ehrig, State-of-the-art survey on ontology merging and aligning, SEKT Project, Deliverable D4.2.1, 2004.

[47]

M. del Mar Roldan-Garcia and J. F. Aldana-Montes, A survey on disk oriented querying and reasoning on the semantic web, in: Proc. of 22nd International Conference on Data Engineering Workshops (ICDEW'06), R. S. Barga and X. Zhou, eds, IEEE, 2006.

Digital Library

[48]

C. Dolbear and G. Hart, Ontological bridge building - Using ontologies to merge spatial datasets, in: Semantic Scientific Knowledge Integration: AAAI Spring Symposium (AAAI/SSS Workshop), D. L. McGuinness, P. Fox and B. Brodaric, eds, 2008, pp. 15-20.

[49]

E. Dragut and R. Lawrence, Composing mappings between schemas using a reference ontology, in: On the Move to Meaningful Internet Systems 2004: CoopIS, DOA, and ODBASE, R. Meersman and Z. Tari, eds, Lecture Notes in Computer Science, Vol. 3290, Springer, 2004, pp. 783-800.

[50]

B. Elliott, E. Cheng, C. Thomas-Ogbuji and Z. M. Ozsoyoglu, A complete translation from SPARQL into efficient SQL, in: Proc. of the 2009 International Database Engineering & Applications Symposium (IDEAS '09), B.C. Desai, ed., ACM, 2009, pp. 31-42.

Digital Library

[51]

R. Elmasri and S. B. Navathe, Fundamentals of Database Systems, 6th edn, The Benjamin/Cummings Publishing Company, Inc., San Francisco, CA, USA, 2010.

[52]

M. Fahad, ER20WL: Generating OWL ontology from ER diagram, in: Intelligent Information Processing IV: 5th IFIP International Conlerence on Intelligent Information Processing, Z. Shi, E. Mercier-Laurent and D. Leake, eds, Springer, 2008, pp. 28-37.

[53]

M. Fisher, M. Dean and G. Joiner, Use of OWL and SWRL for semantic relational database translation, in: Proc. of the Fourth OWLED Workshop on OWL: Experiences and Directions, K. Clark and P. F. Patel-Schneider, eds, 2008.

[54]

J. Geller, S. A. Chun and Y.J. An, Toward the semantic deep web, Computer, 41(9) (2008), 95-97.

Digital Library

[55]

R. Ghawi and N. Cullot, Database-to-ontology mapping generation for semantic interoperability, in: 3rd International Workshop on Database Interoperability (InterDB 2007), held in conjunction with VLDB 2007, 2007.

[56]

A. Gomez-Perez, O. Corcho-Garcia and M. Fernandez-Lopez, Ontological Engineering, 1st edn, Springer-Verlag New York, Inc., Secaucus, NJ, USA, 2003.

[57]

A.J. G. Gray, N. Gray and J. Ounis, Can RDB2RDF tools feasibly expose large science archives for data integration?, in: The Semantic Web: Research and Applications: 6th European Semantic Web Conference (ESWC 2009), L. Aroyo, P. Traverso, F. Ciravegna et al., eds, Lecture Notes in Computer Science, Vol. 5554, Springer, 2009, pp. 491-505.

[58]

T. Gruber, Toward principles for the design of ontologies used for knowledge sharing, International Journal of Human Computer Studies, 43(5-6) (1995), 907-928.

Digital Library

[59]

N. Guarino, Formal ontology and information systems, in: Formal Ontologies in Information Systems: Proceedings of the 1st International Conference (FOIS'98), IOS Press, 1998, pp.3-15.

[60]

T. Heath and C. Bizer, Linked Data: Evolving the Web into a Global Data Space, Morgan & Claypool Publishers, San Rafael, 2011.

Digital Library

[61]

S. Hellmann, J. Unbehauen, A. Zaveri, J. Lehmann, S. Auer, S. Tramp, H. Williams, O. Erling, T. Thibodeau Jr, K. Idehen, A. Blumauer and H. Nagy, Report on knowledge extraction from structured sources, LOD2 Project, Deliverable 3.1.1, available at: http://static.lod2.eu/Deliverables/deliverable-3.1.1.pdf, 2011.

[62]

J. Hendler, Web 3.0: Chicken farms on the Semantic Web, IEEE Computer, 41(1) (2008), 106-108.

[63]

M. Hert, G. Reif and H.C. Gall, Updating relational data via SPARQL/update, in: Proc. of the 2010 EDBT/ICDT Workshops, F. Daniel. L. Delcambre, F. Fotouhi et al., eds, ACM, 2010.

Digital Library

[64]

M. Hert, G. Reif and H.C. Gall, A Comparison of RDB to-RDF Mapping Languages, in: Proc. of the 7th International Conference on Semantic Systems (I-SEMANTICS 2011), C. Ghidini, A.-C. Ngonga Ngomo, S. Lindstaedt and T. Pellegrini, eds, ACM, 2011, pp. 25-32.

Digital Library

[65]

G. Hillairet, F. Bertrand and J.Y. Lafaye, MDE for publishing data on the semantic web, in: Transforming and Weaving Ontologies in Model Driven Engineering: Proceedings of the 1st International Workshop (TWOMDE 2008), F. Silva Parreiras, J. Z. Pan, U. Assmann and J. Henriksson, eds, 2008, pp. 32-46.

[66]

W. Hu and Y. Qu, Discovering simple mappings between relational database schemas and ontologies, in: The Semantic Web: 6th International Semantic Web Conference. 2nd Asian Semantic Web Conference (ISWCN 2007 + ASWC 2007), K. Aberer, K.-S. Choi, N. Noy et al., eds, Lecture Notes in Computer Science, Vol. 4825, Springer, 2007, pp. 225- 238.

[67]

P. Johannesson, A method for transforming relational schemas into conceptual schemas, in: Proc. of the 10th International Conference on Data Engineering (ICDE 1994), IEEE, 1994, pp. 190-201.

[68]

D. Jurić, M. Banek and Z. Skočir, Uncovering the deep web: Transferring relational database content and metadata to OWL ontologies, in: Knowledge-Based Intelligent Information and Engineering Systems: 12th International Conference (KES 2008), I. Lovrek, R.J. Howlett and L.C. Jain, eds, Lecture Notes in Computer Science, Vol. 5177, Springer, 2008, pp. 456-463.

[69]

Y. Kalfoglou and M. Schorlemmer, Ontology mapping: The state of the art, The Knowledge Engineering Review, 18(1) (2003), 1-31.

Digital Library

[70]

V. Kashyap, Design and creation of ontologies for environmental information retrieval, in: First Agricultural Service Ontology (AOS) Workshop, 2001.

[71]

N. Konstantinou, D.-E. Spanos, M. Chalas, E. Solidakis and N. Mitrou, VisAVis: An approach to an intermediate layer between ontologies and relational database contents, in: Proc. of the CAiSE'06 3rd International Workshop on Web Information Systems Modeling, (WISM'06), F. Frasincar, G.-J. Houben and P. Thiran, eds, 2006, pp. 1050-1061.

[72]

N. Konstantinou, D.-E. Spanos and N. Mitrou, Ontology and database mapping: A survey of current implementations and future directions, Journal of Web Engineering, 7(1) (2008), 1-24.

Digital Library

[73]

N. Konstantinou, D.-E. Spanos, P. Stavrou and N. Mitrou, Technically approaching the semantic web bottleneck, International Journal of Web Engineering and Technology, 6(1) (2010), 83-111.

Digital Library

[74]

M. Korotkiy and J. L. Top, From relational data to RDFS models, in: Web Engineering: 4th International Conference (ICWE 2004), N. Koch, P. Fratemali and M. Wirsing, eds, Lecture Notes in Computer Science, Vol. 3140, Springer, 2004, pp. 430-434.

[75]

A. Kupfer, S. Eckstein, K. Neumann and B. Mathiak, Handling changes of database schemas and corresponding ontologies, in: Advances in Conceptual Modeling - Theory and Practice: ER 2006 Workshops, J. F. Roddick, V.R. Benjamins, S. S.-S. Cherfi el al., eds, Lecture Notes in Computer Science, Vol. 4231, Springer, 2006, pp. 227-236.

[76]

M. Laclavík, RDB20nto: Relational database data to ontology individuals mapping, in: Tools for Acquisition, Organisation and Presenting of Information and Knowledge, P. Návrat, P. Bartoš, M. Bieliková, L. Hluchý and P. Vojtáš, eds, 2006, pp.86-89.

[77]

N. Lammari, I. Comyn-Wattiau and J. Akoka, Extracting generalization hierarchies from relational databases: A reverse engineering approach, Data & Knowledge Engineering, 63(2) (2007), 568-589.

Digital Library

[78]

G. Lausen, Relational databases in RDF: Keys and foreign keys, in: Semantic Web, Ontologies and Databases: VLDB Workshop (SWDB-ODBIS 2007), V. Christophides, M. Collard and C. Gutierrez, eds, Lecture Notes in Computer Science, Vol. 5005, Springer, 2007, pp. 43-56.

[79]

G. Lausen, M. Meier and M. Schmidt, SPARQLing constraints for RDF, in: Advances in Database Technology: Proceedings of the 11th International conference on Extending Database Technology (EDBT '08), A. Kemper, P. Valduriez, N. Mouaddib et al., eds, ACM, 2008, pp. 499-509.

Digital Library

[80]

M. Lenzerini, Data integration: A theoretical perspective, in: Proc. of the twenty-first ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems, 2002, pp. 233-246.

Digital Library

[81]

D. Levshin, Mapping relational databases to the semantic web with original meaning, in: Knowledge Science, Engineering and Management: Third International Conference (KSEM 2009), D. Karagiannis and Z. Jin, eds, Lecture Notes in Computer Science, Vol. 5914, Springer, 2009, pp. 5-16.

[82]

M. Li, X. Du and S. Wang, A semi-automatic ontology acquisition method for the semantic web, in: Advances in WebAge Information Management: 6th International Conference (WAIM 2005), W. Fan, Z. Wu and J. Yang, eds, Lecture Notes in Computer Science, Vol. 3739, Springer, 2005, pp. 209-220.

Digital Library

[83]

J. Lu, F. Cao, L. Ma, Y. Yu and Y. Pan, An effective SPARQL support over relational databases, in: Semantic Web, Ontologies and Databases: VLDB Workshop (SWDB-ODBIS 2007), V. Christophides, M. Collard and C. Gutierrez, eds, Lecture Notes in Computer Science, Vol. 5005, Springer, 2007, pp. 57-76.

[84]

L. Lubyte and S. Tessaris, Automatic extraction of ontologies wrapping relational data sources, in: Database and Expert Systems Applications: 20th International Conference (DEXA 2009), S. S. Bhowmick, J. Küng and R. Wagner, eds, Lecture Notes in Computer Science, Vol. 5690, Springer, 2009, pp. 128-142.

Digital Library

[85]

F. Maali, R. Cyganiak and V. Peristeras, Re-using cool URls: Entity reconciliation against LOD hubs, in: Proc. of the 4th Linked Data on the Web Workshop (LDOW 2011), 2011.

[86]

A. Maedche and S. Staab, Ontology learning for the semantic web, IEEE Intelligent Systems, 16(2) (2001), 72-79.

Digital Library

[87]

P. Martin, J. R. Cordy and R. Abu-Hamdeh, Information capacity preserving translations of relational schemas using structural transformation, External Technical Report, ISSN 0836-0227-95-392, Ontario, Canada, 1995.

[88]

A. Miller and D. McNeil, Revelytix ROB Mapping Language Specification, available at: http://www.knoodl.com/ui/groups/Mapping_Ontology_Community/wiki/User_Guide/media/RDB_Mapping_Specification_v0.2, Revelytix, 2010.

[89]

B. Motik, On the properties of metamodeling in OWL, journal of Logic and Computation, 17(4) (2007), 617-637.

[90]

B. Motik, I. Horrocks and U. Sattler, Bridging the gap between OWL and relational databases, in: Proc. of the 16th International Conference on World Wide Web (WWW 2007), C. Williamson and M. E. Zurko, eds, ACM Press, 2007, pp. 807-816.

[91]

V. Mulwad, T. Finin, Z. Syed and A. Joshi, Using Linked Data to interpret tables, in: Proc. of the First International Workshop on Consuming Linked Data (COLD 2010), O. Hartig, A. Harth and J. Sequeda, eds, 2010.

[92]

I. Myroshnichenko and M.C. Murphy, Mapping ER schemas to OWL ontologies, in: Proc. of the 2009 IEEE International Conference on Semantic Computing (ICSC 2009), S.-C. Chen, R. Glasberg, J. Heflin et al., eds, IEEE, 2009, pp. 324-329.

Digital Library

[93]

C. Nyulas, M. O'Connor and S. Tu, DataMaster -A plug-in for importing schemas and data from relational databases into protégé, in: 10th International Protégé Conference, 2007.

[94]

P. Papapanagiotou, P. Katsiouli, V. Tsetsos, C. Anagnostopoulos and S. Hadjiefthymiades, RONTO: Relational to ontology schema matching, AIS SIGSEMIS Bulletin, 3(3-4) (2006), 32-36.

[95]

C. Pérez De Laborda and S. Conrad, Relational. OWL A data and schema representation format based on OWL, in: Proc. of the Second Asia-Pacific Conference on Conceptual Modeling (APCCM2005), S. Hartmann and M. Stumptner, eds,2005, pp. 89-96.

[96]

C. Pérez De Laborda and S. Conrad, Database to semantic web mapping using RDF query languages, in: Conceptual Modeling - ER 2006: 25th International Conference on Conceptual Modeling, D. W. Embley, A. Olivé and S. Ram, eds, Lecture Notes in Computer Science, Vol. 4215, 2006, pp. 241-254.

[97]

C. Pérez De Laborda, M. Zloch and S. Conrad, RDQuery -Querying relational databases on-the-fly with RDF-QL, Poster in the 15th International Conlerence on Knowledge Engineering and Knowledge Management (EKAW 2006), 2006.

[98]

A. Poggi, D. Lembo, D. Calvanese, G. De Giacomo, M. Lenzerini and R. Rosati, Linking Data to ontologies, journal on Data Semantics, 10 (2008),133-173.

[99]

A. Poggi, M. Rodriguez-Muro and M. Ruzzi, Ontology-based database access with DIG-MASTRO and the OBDA plugin for protégeé in: Proc. of the Fourth OWLED Workshop on OWL: Experiences and Directions, K. Clark and P. F. Patel-Schneider, eds, 2008.

[100]

S. Polfliet and R. Ichise, Automated mapping generation for converting databases into Linked Data, in: Proc. of the ISWC 2010 Posters & Demonstrations Track: Collected Abstracts, A. Polleres and H. Chen, eds, 2010, pp. 173-176.

[101]

W. J. Premerlani and M. R. Blaha, An approach for reverse engineering of relational databases, Communications of the ACM, 37(5) (1997), 42-49.

Digital Library

[102]

R. Ramakrishnan and J. Gehrke, Database Management Systems, 3rd ed., McGraw-Hili, New York City, NY, 2002.

[103]

S. Ramanathan and J. Hodges, Extraction of object-oriented structures from existing relational databases, ACM SIGMOD Record, 26(1) (1997), 59-64.

Digital Library

[104]

S. Ramanujam, V. Khadilkar, L. Khan, M. Kantarcioglu, B. Thuraisingham and S. Seida, Update-enabled triplification of relational data into virtual RDF stores, International journal of Semantic Computing, 4(4) (2010), 423-451.

[105]

S. Sahoo, W. Halb, S. Hellmann, K. Idehen, T. Thibodeau, S. Auer, J. Sequeda and A. Ezzat, A Survey of current approaches for mapping of relational databases to RDF, W3C RDB2RDF Incubator Group Report, 2009.

[106]

P. E. Salas, K. K. Breitman, J. F. Viterbo and M. A. Casanova, Interoperability by design using the StdTrip tool: An a priori approach, in: Proc. of the 6th International Conference on Semantic Systems (I-SEMANTICS 2010), A. Paschke, N. Henze and T. Pellegrini, eds, ACM, 2010.

Digital Library

[107]

M. Schmidt, T. Hornung, G. Lausen and e. Pinkel, Sp²Bench: A SPARQL performance benchmark, in: Proc. of the 25th International Conference on Data Engineering (ICDE 2009), J. Li and P. S. Yu, eds, IEEE, 2008, pp. 222-233.

[108]

M. Schneider and G. Sutcliffe, Reasoning in the OWL 2 full ontology language using first-order automated theorem proving, in: Automated Deduction - CADE-23: 23rd International Conference on Automated Deduction, N. Bjømer and Y. Sofronie-Stokkermans, eds, Lecture Notes in Computer Science, Vol. 6803, Springer, 2011, pp. 461-475.

[109]

A. Seaborne, D. Steer and S. Williams, SQL-RDF, in: W3C Workshop on RDF Access to Relational Databases, 2007.

[110]

J. F. Sequeda, R. Depena and D. P. Miranker, Ultrawrap: Using SQL views for RDB2RDF, Poster in 8th International Semantic Web Conference (ISWC 2009), 2009.

[111]

J. F. Sequeda, S. H. Tirmizi, O. Corcho and D. P. Miranker, Direct mapping SQL datababases to the semantic web: A survey (Technical Report. TR-09-04), University of Texas, Austin, Department of Computer Sciences, 2009.

[112]

G. Shen, Z. Huang, X. Zhu and X. Zhao, Research on the rules of mapping from relational model to OWL, in: Proc. of the OWLED '06 Workshop on OWL: Experiences and Directions, B. Cuenca-Grau, P. Hitzler, C. Shankey and E. Wallace, eds, 2006.

[113]

A. Sheth and R. Meersman, Amicalola report: Database and information systems research challenges and opportunities in semantic web and enterprises, ACM SIGMOD Record, 31(4) (2002), 98-106.

Digital Library

[114]

A. P. Sheth and J. A. Larson, Federated database systems for managing distributed, heterogeneous, and autonomous databases, ACM Computing Surveys, 22(3) (1990), 183-236.

Digital Library

[115]

E. Sirin and J. Tao, Towards integrity constraints in OWL, in: Proc. of the 6th International Workshop on OWL: Experiences and Directions (OWLED 2009), R. Hoekstra and P. F. Patel-Schneider, eds, 2009.

[116]

K. Sonia and S. Khan, R2O transformation system: Relation to ontology transformation for scalable data integration, in: Proc. of the 2008 International Database Engineering & Applications Symposium (IDEAS '08), J. Bernardino and B.C. Desai, eds, ACM, 2008, pp. 291-295.

Digital Library

[117]

L. Stojanovic, N. Stojanovic and R. Volz, Migrating dataintensive web sites into the semantic web, in: Proc. of the 2002 ACM Symposium on Applied Computing (SAC'02), G. B. Lamont, ed., ACM, 2002, pp. 1100-1107.

Digital Library

[118]

M. Svihla and I. Jelinek, Two layer mapping from database to RDF, in: Proc. of the Sixth International Scientific Conference Electronic Computers and Informatics (ECI2004), 2004, pp. 270-275.

[119]

M. Svihla and I. Jelinek, Benchmarking RDF production tools, in: Database and Expert Systems Applications: 18th International Conference (DEXA 2007), R. Wagner, N. Revell and G. Pernul, eds, Lecture Notes in Computer Science, Vol. 4653, Springer, 2007, pp. 700-709.

[120]

S. H. Tirmizi, J. F. Sequeda and D. P. Miranker, Translating SQL applications to the semantic web, in: Database and Expert Systems Applications: 19th International Conference (DEXA 2008), S. S. Bhowmick, J. Küng and R. Wagner, eds, Lecture Notes in Computer Science, Vol. 5181, Springer, 2008, pp.450-464.

[121]

Q. Trinh, K. Barker and R. Alhajj, RDB2ONT: A tool forgenerating OWL ontologies from relational database systems, in: Proc. of the Advanced International Conference on Telecommunications and International Conference on Internet and Web Applications and Services (AICT-ICIW'06), T. Atmaca, P. Dini, P. Lorenz and J. Neuman de Sousa, eds, IEEE, 2006.

[122]

S. R. Upadhyaya and P. S. Kumar, ERONTO: A tool for extracting ontologies from extended E/R diagrams, in: Proc. of the 2005 ACM Symposium on Applied Computing (SAC'05), L. M. Liebrock, ed., ACM, 2005, pp. 666-670.

Digital Library

[123]

K. N. Vavliakis, T.K. Grollios and P. A. Mitkas, RDOTE - Transforming relational databases into semantic web data, in: Proc. of the ISWC 2010 Posters & Demonstrations Track: Collected Abstracts, A. Polleres and H. Chen, eds, 2010, pp. 121-124.

[124]

J. Volz, C. Bizer, M. Gaedke and G. Kobilarov, Discovering and maintaining links on the web of data, in: The Semantic Web - ISWC 2009: 8th International Semantic Web Conference, A. Bernstein, D. R. Karger, T. Heath, L. Feigenbaum, D. Maynard, E. Motta and K. Thirunarayan, eds, Lecture Notes in Computer Science, Vol. 5823, Springer, 2009, pp. 650-665.

[125]

R. Volz, S. Handschuh, S. Staab, L. Stojanovic and N. Stojanovic, Unveiling the hidden bride: Deep annotation for mapping and migrating legacy data to the semantic web, Web Semantics: Science. Services and Agents on the World Wide Web, 1(2) (2004),187-206.

[126]

H. Wache, T Vögele, U. Visser, H. Stuckenschmidt, G. Schuster, H. Neumann and S. Hübner, Ontology-based integration of information -A survey of existing approaches, in: Proc. of the IJCAI-01 Workshop on Ontologies and Information Sharing, A. Gomez-Perez, M. Gruninger, H. Stuckenschmidt and M. Uschold, eds, 2001, pp. 108-117.

[127]

Z. Xu, X. Cao, Y. Dong and W. Su, Formal approach and automated tool for translating ER schemata into OWL ontologies, in: Advances in Knowledge Discovery and Data Mining: 8th Pacific-Asia Conference (PAKDD 2004), H. Dai, R. Srikant and C. Zhang, eds, Lecture Notes in Computer Science, Vol. 3056, Springer, 2004, pp. 464-475.

[128]

Z. Xu, S. Zhang and Y. Dong, Mapping between relational database schema and OWL ontology for deep annotation, in: Proc. of the 2006 IEEE/WIC/ACM International Conference on Web Intelligence, T. Nishida, Z. Shi, U. Visser et al., eds, IEEE, 2006, pp. 548-552.

Digital Library

[129]

S. Zhao and E. Chang, From database to semantic web ontology: An overview, in: On the Move to Meaningful Internet Systems: OTM 2007 Workshops, R. Meersman, Z. Tari and P. Herrero, eds, Lecture Notes in Computer Science, Vol. 4806, Springer, 2007, pp. 1205-1214.

[130]

C. Zhou, C. Xu, H. Chen and K. Idehen, Browser-based semantic mapping tool for linked data in semantic web, in: Proc. of the WWW 2008 Workshop on Linked Data on the Web (LDOW 2008), C. Bizer, T. Heath, K. Idehen and T. Berners-Lee, eds, 2008.

Cited By

De Uña DRümmele NGange GSchachte PStuckey P(2018)Machine learning and constraint programming for relational-to-ontology schema mappingProceedings of the 27th International Joint Conference on Artificial Intelligence10.5555/3304415.3304597(1277-1283)Online publication date: 13-Jul-2018
https://dl.acm.org/doi/10.5555/3304415.3304597
Horwitz AFan YBrown RPage K(2017)Tools for Music Bibliographic Network AnalysisProceedings of the 4th International Workshop on Digital Libraries for Musicology10.1145/3144749.3144761(55-58)Online publication date: 28-Oct-2017
https://dl.acm.org/doi/10.1145/3144749.3144761
(2017)Ontology Based Data Access in StatoilWeb Semantics: Science, Services and Agents on the World Wide Web10.1016/j.websem.2017.05.00544:C(3-36)Online publication date: 1-May-2017
https://dl.acm.org/doi/10.1016/j.websem.2017.05.005
Show More Cited By

Index Terms

Bringing relational databases into the semantic web: a survey
1. Information systems
  1. Data management systems
    1. Database design and models
  2. Information retrieval

Index terms have been assigned to the content through auto-classification.

Recommendations

Bringing relational databases into the Semantic Web: A survey
On real-time and ubiquitous social semantics

Relational databases are considered one of the most popular storage solutions for various kinds of data and they have been recognized as a key factor in generating huge amounts of data for Semantic Web applications. Ontologies, on the other hand, are ...
Ontology learning from relational databases
Abstract
An ontology is a formal, explicit specification of a shared conceptualization. Ontologies are used in many fields, such as software engineering, information extraction, semantic search, knowledge management, recommender systems, ...
Generating OWL Ontology from Relational Database
MUSIC '12: Proceedings of the 2012 Third FTRA International Conference on Mobile, Ubiquitous, and Intelligent Computing

The Semantic Web aims to enrich the existing Web by building an infrastructure layer of a web of data. Three-quarters of the data on the Web come from relational databases. Thus, in the context of the Semantic Web, it has become one of the most ...

Comments

Information & Contributors

Information

Published In

cover image Semantic Web

Semantic Web Volume 3, Issue 2

April 2012

95 pages

ISSN:1570-0844

EISSN:2210-4968

Issue’s Table of Contents

Publisher

IOS Press

Netherlands

Publication History

Published: 01 April 2012

Author Tags

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

15
Total Citations
View Citations
0
Total Downloads

Downloads (Last 12 months)0
Downloads (Last 6 weeks)0

Reflects downloads up to 11 Aug 2024

Other Metrics

View Author Metrics

Citations

Cited By

De Uña DRümmele NGange GSchachte PStuckey P(2018)Machine learning and constraint programming for relational-to-ontology schema mappingProceedings of the 27th International Joint Conference on Artificial Intelligence10.5555/3304415.3304597(1277-1283)Online publication date: 13-Jul-2018
https://dl.acm.org/doi/10.5555/3304415.3304597
Horwitz AFan YBrown RPage K(2017)Tools for Music Bibliographic Network AnalysisProceedings of the 4th International Workshop on Digital Libraries for Musicology10.1145/3144749.3144761(55-58)Online publication date: 28-Oct-2017
https://dl.acm.org/doi/10.1145/3144749.3144761
(2017)Ontology Based Data Access in StatoilWeb Semantics: Science, Services and Agents on the World Wide Web10.1016/j.websem.2017.05.00544:C(3-36)Online publication date: 1-May-2017
https://dl.acm.org/doi/10.1016/j.websem.2017.05.005
Tao MOta KDong M(2017)Ontology-based data semantic management and application in IoT- and cloud-enabled smart homesFuture Generation Computer Systems10.1016/j.future.2016.11.01276:C(528-539)Online publication date: 1-Nov-2017
https://dl.acm.org/doi/10.1016/j.future.2016.11.012
Patelli ALewis PEkart AWang HNabney IBennett DLucas RCole A(2017)An architecture for the autonomic curation of crowdsourced knowledgeCluster Computing10.1007/s10586-017-0908-220:3(2031-2046)Online publication date: 1-Sep-2017
https://dl.acm.org/doi/10.1007/s10586-017-0908-2
Soylu AGiese MJimenez-Ruiz EKharlamov EZheleznyakov DHorrocks I(2017)Ontology-based end-user visual query formulationUniversal Access in the Information Society10.1007/s10209-016-0465-016:2(435-467)Online publication date: 1-Jun-2017
https://dl.acm.org/doi/10.1007/s10209-016-0465-0
Pipitone APirrone R(2016)Aligning Relational Schema and OWL Ontologies with Hidden Markov ModelInternational Journal of Knowledge Society Research10.4018/IJKSR.20160401017:2(1-24)Online publication date: 1-Apr-2016
https://dl.acm.org/doi/10.4018/IJKSR.2016040101
Ristoski PPaulheim H(2016)Semantic Web in data mining and knowledge discoveryWeb Semantics: Science, Services and Agents on the World Wide Web10.1016/j.websem.2016.01.00136:C(1-22)Online publication date: 1-Jan-2016
https://dl.acm.org/doi/10.1016/j.websem.2016.01.001
Soylu AGiese MJimenez-Ruiz EVega-Gorgojo GHorrocks I(2016)Experiencing OptiqueVQSUniversal Access in the Information Society10.1007/s10209-015-0404-515:1(129-152)Online publication date: 1-Mar-2016
https://dl.acm.org/doi/10.1007/s10209-015-0404-5
Shu YRatcliffe DCompton MSquire GTaylor K(2015)A semantic approach to data translationKnowledge-Based Systems10.1016/j.knosys.2014.11.02375:C(104-123)Online publication date: 1-Feb-2015
https://dl.acm.org/doi/10.1016/j.knosys.2014.11.023
Show More Cited By

View Options

View options

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

Media

Figures

Other

Tables

View Issue’s Table of Contents