Ultrawrap: SPARQL execution on relational data

Journal of Web Semantics

Volumn 22, Issue , 2013, Pages 19-39

  Sequeda, Juan F ^a   Miranker, Daniel P ^a  

^a University of Texas at Austin   (United States)

Author keywords

RDB2RDF; RDF; Relational databases; Semantic web; SPARQL; SQL

Indexed keywords

RDB2RDF; RDF; RELATIONAL DATABASE; SPARQL; SQL;

OPTIMIZATION; QUERY LANGUAGES; QUERY PROCESSING; SEMANTIC WEB; SYNTACTICS;

RELATIONAL DATABASE SYSTEMS;

EID: 84885574207     PISSN: 15708268     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.websem.2013.08.002     Document Type: Article

References (54)

1. H. Garcia-Molina, J. Ullman, and J. Widom Database Systems: The Complete Book 2009 Pearson Prentice Hall
2. RDF Primer, http://www.w3.org/TR/rdf-primer.
3. E. Prud'hommeaux, A. Seaborne, SPARQL query language for RDF, W3C Recommendation 15 January 2008, http://www.w3.org/TR/rdf-sparql-query/.
4. I.S. Mumick, H. Pirahesh, Implementation of magic-sets in a relational database system, in: SIGMOD Record, 23 (2), 1994, pp. 103-114.
5. M. Stonebraker, A. Jhingran, J. Goh, S. Potamianos, On rules, procedure, caching and views in data base systems, in: SIGMOD Record, 19 (2), 1990, pp. 281-290.
6. C. Bizer, T. Heath, and T. Berner-Lee Linked data - the story so far Int. J. Semantic Web Inf. Syst. 5 3 2009 1 22
7. D2R Server, http://d2rq.org/d2r-server.
8. SquirrelRDF, http://jena.sourceforge.net/SquirrelRDF.
9. Virtuoso RDF Views, http://virtuoso.openlinksw.com/whitepapers/ relational%20rdf%20views%20mapping.html.
10. J. Broekstra, A. Kampman, F. van Harmelen, Sesame: a generic architecture for storing and querying RDF and RDF schema, in: ISWC, 2002, pp. 54-68.
11. T. Neumann, and G. Weikum The RDF-3X engine for scalable management of RDF data VLDB J. 19 1 2010 91 113
12. C. Weiss, P. Karras, and A. Bernstein Hexastore: sextuple indexing for semantic web data management PVLDB 1 1 2008 1008 1019
13. D. Abadi, A. Marcus, S. Madden, K. Hollenbach, Scalable semantic web data management using vertical partitioning, in: VLDB, 2007, pp. 411-422.
14. E.I. Chong, S. Das, G. Eadon, J. Srinivasan, An efficient SQL-based RDF querying scheme, in: VLDB, 2005, pp. 1216-1227.
15. B. Elliott, E. Cheng, C. Thomas-Ogbuji, Z. Ozsoyoglu, A complete translation from SPARQL into efficient SQL, in: IDEAS, 2009, pp. 31-42.
16. K. Wilkinson, Jena property table implementation, in: SSWS, 2006.
17. C. Franke, S. Morin, A. Chebotko, J. Abraham, P. Brazier, Distributed semantic web data management in HBase and MySQL cluster, in: CLOUD, 2011, pp. 105-112.
18. J. Huang, D.J. Abadi, and K. Ren Scalable SPARQL querying on large RDF graphs PVLDB 4 11 2011 1123 1134
19. G. Ladwig, A. Harth, CumulusRDF: linked data management on nested key-value stores, in: SSWS, 2011.
20. W. Chang, Conversion of relational database into triplestores, US Patent 8,037,108, filed July 22, 2009, issued October 11, 2011.
21. B. He, M. Patel, Z. Zhang, and K.C.-C. Chang Accessing the deep web Commun. ACM 50 2007 94 101
22. R. Angles, C. Gutierrez, The expressive power of SPARQL, in: ISWC, 2008, pp. 114-129.
23. C. Bizer, and A. Schultz The Berlin SPARQL benchmark Int. J. Semantic Web Inf. Syst. 5 2 2009 1 24
24. A. Gray, N. Gray, I. Ounis, Can RDB2RDF tools feasibily expose large science archives for data integration? in: ESWC, 2009, pp. 491-505.
25. J.F. Sequeda, R. Depena, S.H. Tirmizi, D.P. Miranker, Ultrawrap: SQL views for RDB2RDF, ISWC 2011.
26. Ultrawrap, http://ribs.csres.utexas.edu/ultrawrap/benchmark.html.
27. U. Chakravarthy, J. Grant, and J. Minker Logic-based approach to semantic query optimization ACM Trans. Database Syst. 15 2 1990 162 207
28. A. Chebotko, S. Lu, and F. Fotouhi Semantics preserving SPARQL-to-SQL translation Data Knowl. Eng. 68 10 2009 973 1000
29. 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 XG Report 2009
30. M. Svihla, I. Jelinek, Benchmarking RDF production tools, in: DEXA, 2007, pp. 700-709.
31. M. Schmidt, T. Hornung, N. Kuchlin, G. Lausen, C. Pinkel, An experimental comparison of RDF data management approaches in a SPARQL benchmark scenario, in: ISWC, 2008, pp. 82-97.
32. H. MahmoudiNasab, S. Sakr, An experimental evaluation of relational RDF storage and querying techniques, in: DASFAA Workshops, 2010, pp. 215-226.
33. 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 Semant. Web J. 2 1 2011 43 53
34. P. Cangialosi, C. Consoli, A. Faraotti, G. Vetere, Accessing data through ontologies with ONDA, in: CASCON, 2010, pp. 13-26.
35. M. Rodriguez-Muro, D. Calvanese, Quest, an OWL 2 QL reasoner for ontology-based data access, in: OWLED, 2012.
36. M. Arenas, A. Bertails, E. Prud'hommeaux, J.F. Sequeda, A direct mapping of relational data to RDF, W3C Recommendation, 27 September 2012, http://www.w3.org/TR/rdb-direct-mapping/.
37. S. Das, S. Sundara, R. Cyganiak, R2RML: RDB to RDF mapping language. W3C Recommendation, 27 September 2012, http://www.w3.org/TR/r2rml/.
38. J.F. Sequeda, M. Arenas, D.P. Miranker, On directly mapping relational databases to RDF and OWL, in: WWW, 2012, pp. 649-658.
39. J.F. Sequeda, S. Tirmizi, O. Corcho, and D.P. Miranker Survey of directly mapping SQL databases to the semantic web Knowl. Eng. Rev. 26 4 2011 445 486
40. S.H. Tirmizi, J.F. Sequeda, D.P. Miranker, Translating SQL applications to the semantic web, in: DEXA, 2008, pp. 450-464.
41. R. Fagin, L. Haas, M. Hernandez, R. Miller, L. Popa, and Y. Velegrakis Clio: schema mapping creation and data exchange Conceptual Model. Found. Appl. 2009 198 236
42. A. Tian, J.F. Sequeda, D.P. Miranker, QODI: query as context in automatic data integration, in: ISWC 2013.
43. Personal communication with Conor Cunningham.
44. Q. Cheng, J. Gryz, F. Koo, T.Y. Cliff Leung, L. Liu, X. Qian, K. Schiefer, Implementation of two semantic query optimization techniques in DB2 universal database, in: VLDB, 1999, pp. 687-698.
45. S. Shenoy, Z. Ozsoyoglu, A system for semantic query optimization, in: SIGMOD, 1987, pp. 181-195.
46. Berlin SPARQL Benchmark, http://wifo5-03.informatik.uni-mannheim.de/ bizer/berlinsparqlbenchmark/.
47. D. Abadi, A. Marcus, S. Madden, and K. Hollenbach Using the Barton libraries dataset as an RDF benchmark, Technical Report MIT-CSAIL-TR-2007-036, MIT 2007
48. R. Krishnamurthy, W. Litwin, W. Kent, Language features for interoperability of databases with schematic discrepancies, in: SIGMOD, 1991, pp. 40-49.
49. L. Lakshmanan, F. Sadri, I. Subramanian, SchemaSQL-a language for interoperability in relational multi-database systems, in: VLDB, 1996, pp. 239-250.
50. R. Ahmed, A. Lee, D. Das, Join predicate push-down optimizations. US Patent 7,945,562, filed March 8, 2007, issued May 17, 2011.
51. D. Abadi, S. Madden, N. Hachem, Column-stores vs. row-stores: how different are they really? in: SIGMOD, 2008, pp. 967-980.
52. N. Bruno, Teaching an old elephant new tricks, in: CIDR, 2009.
53. L. Sidirourgos, R. Goncalves, M. Kersten, N. Nes, and S. Manegold Column-store support for RDF data management: not all swans are white PVLDB 2008 1553 1563
54. F. Barbancon, D.P. Miranker, Implementing federated database systems by compiling SchemaSQL, in: IDEAS, 2002, pp. 192-201.