{"id":"https://openalex.org/W2612325503","doi":"https://doi.org/10.1145/3070607.3070610","title":"Querying Semantic Knowledge Bases with SQL-on-Hadoop","display_name":"Querying Semantic Knowledge Bases with SQL-on-Hadoop","publication_year":2017,"publication_date":"2017-05-08","ids":{"openalex":"https://openalex.org/W2612325503","doi":"https://doi.org/10.1145/3070607.3070610","mag":"2612325503"},"language":"en","primary_location":{"id":"doi:10.1145/3070607.3070610","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3070607.3070610","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 4th ACM SIGMOD Workshop on Algorithms and Systems for MapReduce and Beyond","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5063183711","display_name":"Martin Przyjaciel-Zablocki","orcid":null},"institutions":[{"id":"https://openalex.org/I161046081","display_name":"University of Freiburg","ror":"https://ror.org/0245cg223","country_code":"DE","type":"education","lineage":["https://openalex.org/I161046081"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Martin Przyjaciel-Zablocki","raw_affiliation_strings":["University of Freiburg"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Freiburg","institution_ids":["https://openalex.org/I161046081"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5065370253","display_name":"Alexander Sch\u00e4tzle","orcid":null},"institutions":[{"id":"https://openalex.org/I161046081","display_name":"University of Freiburg","ror":"https://ror.org/0245cg223","country_code":"DE","type":"education","lineage":["https://openalex.org/I161046081"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Alexander Sch\u00e4tzle","raw_affiliation_strings":["University of Freiburg"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Freiburg","institution_ids":["https://openalex.org/I161046081"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5113532644","display_name":"Georg Lausen","orcid":null},"institutions":[{"id":"https://openalex.org/I161046081","display_name":"University of Freiburg","ror":"https://ror.org/0245cg223","country_code":"DE","type":"education","lineage":["https://openalex.org/I161046081"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Georg Lausen","raw_affiliation_strings":["University of Freiburg"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Freiburg","institution_ids":["https://openalex.org/I161046081"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I161046081"],"apc_list":null,"apc_paid":null,"fwci":0.5537,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.68153606,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"10"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9979000091552734,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9979000091552734,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9976000189781189,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9947999715805054,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8417812585830688},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7030035853385925},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4533670246601105},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4288768172264099},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.3595554232597351},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3332565426826477}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8417812585830688},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7030035853385925},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4533670246601105},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4288768172264099},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.3595554232597351},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3332565426826477}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3070607.3070610","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3070607.3070610","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 4th ACM SIGMOD Workshop on Algorithms and Systems for MapReduce and Beyond","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":52,"referenced_works":["https://openalex.org/W36810566","https://openalex.org/W156852397","https://openalex.org/W1510908550","https://openalex.org/W1539367018","https://openalex.org/W1545218723","https://openalex.org/W1567632848","https://openalex.org/W1582089387","https://openalex.org/W1598064945","https://openalex.org/W1756831351","https://openalex.org/W1810256132","https://openalex.org/W1812636409","https://openalex.org/W1823445833","https://openalex.org/W1937427849","https://openalex.org/W1964903741","https://openalex.org/W1971922661","https://openalex.org/W1993042845","https://openalex.org/W2000656232","https://openalex.org/W2003500287","https://openalex.org/W2016753842","https://openalex.org/W2017722765","https://openalex.org/W2023062809","https://openalex.org/W2033258621","https://openalex.org/W2034956447","https://openalex.org/W2038412523","https://openalex.org/W2042716381","https://openalex.org/W2073074467","https://openalex.org/W2081385143","https://openalex.org/W2101491706","https://openalex.org/W2102440263","https://openalex.org/W2110086534","https://openalex.org/W2122465391","https://openalex.org/W2122865749","https://openalex.org/W2124564928","https://openalex.org/W2126079271","https://openalex.org/W2140239055","https://openalex.org/W2140613126","https://openalex.org/W2153225416","https://openalex.org/W2156774188","https://openalex.org/W2161077919","https://openalex.org/W2226975844","https://openalex.org/W2250093878","https://openalex.org/W2250132166","https://openalex.org/W2293919922","https://openalex.org/W2396745562","https://openalex.org/W2406733608","https://openalex.org/W2550375374","https://openalex.org/W2613995098","https://openalex.org/W3184829694","https://openalex.org/W6601485932","https://openalex.org/W6632331903","https://openalex.org/W6697236245","https://openalex.org/W6798710381"],"related_works":["https://openalex.org/W2003932708","https://openalex.org/W2284877871","https://openalex.org/W2138102289","https://openalex.org/W1967424056","https://openalex.org/W868043274","https://openalex.org/W2513523087","https://openalex.org/W1187916458","https://openalex.org/W2373861055","https://openalex.org/W1559716973","https://openalex.org/W3109364360"],"abstract_inverted_index":{"The":[0,161],"constant":[1],"growth":[2],"of":[3,91,98,111,129,150,203],"semantically-annotated":[4],"data":[5,32,119],"and":[6,23,106,113,135,139],"an":[7,72],"increasing":[8],"interest":[9],"in":[10,102,153,200],"cross-domain":[11],"knowledge":[12,170],"bases":[13,171],"raises":[14],"the":[15,36,80,99,127,148,201],"need":[16],"for":[17,21,30,41,167,178],"expressive":[18,54,73],"query":[19,39,76,175],"languages":[20,55],"RDF":[22,75,158],"novel":[24],"approaches":[25],"that":[26,192],"enable":[27],"their":[28,143],"evaluation":[29,131],"web-scale":[31],"sizes.":[33],"However,":[34],"SPARQL,":[35],"W3C":[37],"standard":[38],"language":[40,77],"RDF,":[42],"suffers":[43],"from":[44],"a":[45,88],"rather":[46],"limited":[47],"capability":[48],"to":[49,125,155],"express":[50],"navigational":[51],"queries.":[52],"More":[53,189],"have":[56],"been":[57],"theoretically":[58],"studied,":[59],"however":[60],"not":[61],"implemented.":[62],"In":[63],"this":[64],"paper,":[65],"we":[66],"continue":[67],"our":[68,92,123,151],"work":[69],"on":[70,79,109,137,181],"TRIAL-QL,":[71],"(SQL-like)":[74],"based":[78],"Triple":[81],"Algebra":[82],"with":[83,183],"Recursion":[84],"[31].":[85],"We":[86,121],"present":[87],"new":[89],"version":[90],"TRIAL-QL":[93],"processor,":[94],"which":[95],"takes":[96],"advantage":[97],"current":[100],"momentum":[101],"in-memory":[103],"SQL-on-Hadoop":[104],"solutions":[105],"is":[107],"built":[108],"top":[110],"Impala":[112,138],"SPARK":[114,140],"while":[115,141],"using":[116],"one":[117,186],"unified":[118],"storage.":[120],"use":[122],"system":[124,152],"study":[126],"application":[128],"multiple":[130],"algorithms,":[132],"storage":[133],"strategies":[134],"optimizations":[136],"highlighting":[142],"properties.":[144],"Comprehensive":[145],"experiments":[146],"examine":[147],"performance":[149],"comparison":[154],"other":[156],"competitive":[157],"management":[159],"systems.":[160],"obtained":[162],"results":[163,198],"demonstrate":[164],"its":[165],"suitability":[166],"querying":[168],"semantic":[169],"by":[172],"providing":[173],"interactive":[174],"response":[176],"times":[177],"selective":[179],"queries":[180],"datasets":[182],"more":[184],"than":[185],"billion":[187,197],"triple.":[188],"data-intensive":[190],"use-cases":[191],"produce,":[193],"e.g.":[194],"over":[195],"25":[196],"finished":[199],"order":[202],"minutes.":[204]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":1}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}