{"id":"https://openalex.org/W1504439773","doi":null,"title":"An efficient SQL-based RDF querying scheme","display_name":"An efficient SQL-based RDF querying scheme","publication_year":2005,"publication_date":"2005-08-30","ids":{"openalex":"https://openalex.org/W1504439773","mag":"1504439773"},"language":"en","primary_location":{"id":"pmh:oai:CiteSeerX.psu:10.1.1.60.7556","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.60.7556","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.vldb2005.org/program/paper/fri/p1216-chong.pdf","raw_type":"text"},"volume":null,"type":"article","is_traditional":true,"indexed_in":[],"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/A5088658114","display_name":"Eugene Inseok Chong","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Eugene Inseok Chong","raw_affiliation_strings":["Oracle, One Oracle Drive, Nashua, NH#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle, One Oracle Drive, Nashua, NH#TAB#","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101134579","display_name":"Souripriya Das","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Souripriya Das","raw_affiliation_strings":["Oracle, One Oracle Drive, Nashua, NH#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle, One Oracle Drive, Nashua, NH#TAB#","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5082591693","display_name":"George Eadon","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"George Eadon","raw_affiliation_strings":["Oracle, One Oracle Drive, Nashua, NH#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Oracle, One Oracle Drive, Nashua, NH#TAB#","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5085227942","display_name":"Jagannathan Srinivasan","orcid":"https://orcid.org/0000-0002-1435-4374","observed_orcids":["https://orcid.org/0000-0002-1435-4374"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jagannathan Srinivasan","raw_affiliation_strings":["Oracle, One Oracle Drive, Nashua, NH#TAB#"],"raw_orcid":"https://orcid.org/0000-0002-1435-4374","affiliations":[{"raw_affiliation_string":"Oracle, One Oracle Drive, Nashua, NH#TAB#","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":19.0451,"has_fulltext":false,"cited_by_count":288,"citation_normalized_percentile":{"value":0.99420455,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":88,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"1216","last_page":"1227"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.8276000022888184,"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.8276000022888184,"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.14489999413490295,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T11106","display_name":"Data Management and Algorithms","score":0.004900000058114529,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/rdf-querying","display_name":"RDF querying","score":0.9430000185966492},{"id":"https://openalex.org/keywords/query-reformulation","display_name":"query rewriting","score":0.6990000009536743},{"id":"https://openalex.org/keywords/b-tree-index","display_name":"B-tree index","score":0.7409999966621399},{"id":"https://openalex.org/keywords/materialized-views","display_name":"materialized views","score":0.8999999761581421},{"id":"https://openalex.org/keywords/user-defined-rules","display_name":"user-defined rules","score":0.7570000290870667},{"id":"https://openalex.org/keywords/oracle-database","display_name":"Oracle database","score":0.7689999938011169},{"id":"https://openalex.org/keywords/uniprot","display_name":"UniProt","score":0.5170000195503235},{"id":"https://openalex.org/keywords/scalability","display_name":"scalability","score":0.3959999978542328},{"id":"https://openalex.org/keywords/query-optimization","display_name":"query optimization","score":0.3799999952316284}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8815854787826538},{"id":"https://openalex.org/C147497476","wikidata":"https://www.wikidata.org/wiki/Q54872","display_name":"RDF","level":3,"score":0.6308337450027466},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6070939302444458},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6065014004707336},{"id":"https://openalex.org/C15657843","wikidata":"https://www.wikidata.org/wiki/Q1751819","display_name":"RDF Schema","level":5,"score":0.6004492044448853},{"id":"https://openalex.org/C96956885","wikidata":"https://www.wikidata.org/wiki/Q6138701","display_name":"RDF query language","level":5,"score":0.5921880602836609},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.583380937576294},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.556371808052063},{"id":"https://openalex.org/C41009113","wikidata":"https://www.wikidata.org/wiki/Q54871","display_name":"SPARQL","level":4,"score":0.5151716470718384},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.4739289879798889},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.46617817878723145},{"id":"https://openalex.org/C29321653","wikidata":"https://www.wikidata.org/wiki/Q2288360","display_name":"Simple Knowledge Organization System","level":5,"score":0.4567829370498657},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4560955762863159},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.4362814426422119},{"id":"https://openalex.org/C69075417","wikidata":"https://www.wikidata.org/wiki/Q515701","display_name":"Linked data","level":3,"score":0.4174032211303711},{"id":"https://openalex.org/C2129575","wikidata":"https://www.wikidata.org/wiki/Q54837","display_name":"Semantic Web","level":2,"score":0.21597698330879211},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.20495378971099854},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.14878630638122559},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.1398104429244995},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:CiteSeerX.psu:10.1.1.60.7556","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.60.7556","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.vldb2005.org/program/paper/fri/p1216-chong.pdf","raw_type":"text"},{"id":"mag:1504439773","doi":null,"is_oa":false,"landing_page_url":"https://www.vldb.org/conf/2005/papers/p1216-chong.pdf","pdf_url":null,"source":{"id":"https://openalex.org/S4306421142","display_name":"Very Large Data Bases","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Very Large Data Bases","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W23685451","https://openalex.org/W29172951","https://openalex.org/W1799456667","https://openalex.org/W2066580290","https://openalex.org/W2081580037","https://openalex.org/W2084987750","https://openalex.org/W2132582487"],"related_works":["https://openalex.org/W2381036667","https://openalex.org/W1411772405","https://openalex.org/W1592226407","https://openalex.org/W2122812212","https://openalex.org/W2140312225","https://openalex.org/W2599071819","https://openalex.org/W7097695891","https://openalex.org/W2000656232","https://openalex.org/W2071927086","https://openalex.org/W7077177895"],"abstract_inverted_index":{"Devising":[0],"a":[1,72,83,125],"scheme":[2,75],"for":[3,28,179],"efficient":[4],"and":[5,50,107,189,218,229],"scalable":[6],"querying":[7,29,105,180],"of":[8,19,94,139,147,159,174],"Resource":[9],"Description":[10],"Framework":[11],"(RDF)":[12],"data":[13,56,67],"has":[14,33,57],"been":[15],"an":[16,199],"active":[17],"area":[18],"current":[20],"research.":[21],"However,":[22],"most":[23],"approaches":[24],"define":[25],"new":[26],"languages":[27],"RDF":[30,90,181,224],"data,":[31,182],"which":[32,183],"the":[34,64,117,145,148,172,175,203],"following":[35],"shortcomings:":[36],"1)":[37],"They":[38,52],"are":[39],"difficult":[40],"to":[41,58,63,88],"integrate":[42],"with":[43,110,144],"SQL":[44,62,73,84,126],"queries":[45,111],"used":[46],"in":[47,142,193],"database":[48],"applications,":[49],"2)":[51],"incur":[53],"inefficiency":[54],"as":[55,124,162,164],"be":[59,99],"transformed":[60],"from":[61,226],"corresponding":[65],"language":[66],"format.":[68],"This":[69,169],"paper":[70,170],"proposes":[71],"based":[74],"that":[76],"avoids":[77],"these":[78],"problems.":[79],"Specifically,":[80],"it":[81],"introduces":[82],"table":[85,96,119,131,177],"function":[86,97,120,132,178],"RDF_MATCH":[87,95,118,176],"query":[89,141,152],"data.":[91,115,231],"The":[92,150],"results":[93],"can":[98,184],"further":[100],"processed":[101],"by":[102,156,206],"SQL's":[103],"rich":[104],"capabilities":[106],"seamlessly":[108],"combined":[109],"on":[112],"traditional":[113],"relational":[114],"Furthermore,":[116],"invocation":[121],"is":[122,153],"rewritten":[123,140],"query,":[127],"thereby":[128],"avoiding":[129,207],"run-time":[130],"procedural":[133,208],"overheads.":[134],"It":[135,196],"also":[136,197],"enables":[137],"optimization":[138],"conjunction":[143],"rest":[146],"query.":[149],"resulting":[151],"executed":[154],"efficiently":[155],"making":[157],"use":[158],"B-tree":[160],"indexes":[161],"well":[163],"specialized":[165],"subject-property":[166],"materialized":[167],"views.":[168],"describes":[171],"functionality":[173],"optionally":[185],"include":[186],"user-defined":[187],"rulebases,":[188],"discusses":[190],"its":[191],"implementation":[192],"Oracle":[194],"RDBMS.":[195],"presents":[198],"experimental":[200],"study":[201],"characterizing":[202,212],"overhead":[204],"eliminated":[205],"code":[209],"at":[210],"runtime,":[211],"performance":[213],"under":[214],"various":[215],"input":[216],"conditions,":[217],"demonstrating":[219],"scalability":[220],"using":[221],"80":[222],"million":[223],"triples":[225],"UniProt":[227],"protein":[228],"annotation":[230]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":10},{"year":2020,"cited_by_count":12},{"year":2019,"cited_by_count":7},{"year":2018,"cited_by_count":7},{"year":2017,"cited_by_count":8},{"year":2016,"cited_by_count":15},{"year":2015,"cited_by_count":16},{"year":2014,"cited_by_count":18},{"year":2013,"cited_by_count":18},{"year":2012,"cited_by_count":27}],"updated_date":"2026-11-04T10:54:05.112534","created_date":"2016-06-24T00:00:00"}