{"id":"https://openalex.org/W2903231649","doi":"https://doi.org/10.17706/jsw.13.11.573-599","title":"An Approach for Generation of SPARQL Query from SQL Algebra based Transformation Rules of RDB to Ontology","display_name":"An Approach for Generation of SPARQL Query from SQL Algebra based Transformation Rules of RDB to Ontology","publication_year":2018,"publication_date":"2018-01-01","ids":{"openalex":"https://openalex.org/W2903231649","doi":"https://doi.org/10.17706/jsw.13.11.573-599","mag":"2903231649"},"language":"en","primary_location":{"id":"doi:10.17706/jsw.13.11.573-599","is_oa":true,"landing_page_url":"https://doi.org/10.17706/jsw.13.11.573-599","pdf_url":"http://www.jsoftware.us/vol13/356-JSW15349.pdf","source":{"id":"https://openalex.org/S114141714","display_name":"Journal of Software","issn_l":"1796-217X","issn":["1796-217X"],"is_oa":true,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318660","host_organization_name":"Academy Publisher","host_organization_lineage":["https://openalex.org/P4310318660"],"host_organization_lineage_names":["Academy Publisher"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Software","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"http://www.jsoftware.us/vol13/356-JSW15349.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5001839092","display_name":"Mohamed A. G. Hazber","orcid":"https://orcid.org/0000-0002-0381-7441"},"institutions":[{"id":"https://openalex.org/I37461747","display_name":"Wuhan University","ror":"https://ror.org/033vjfk17","country_code":"CN","type":"education","lineage":["https://openalex.org/I37461747"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Mohamed A. G. Hazber","raw_affiliation_strings":["School of Computer Science, Wuhan University, Wuhan, China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science, Wuhan University, Wuhan, China","institution_ids":["https://openalex.org/I37461747"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100451253","display_name":"Bing Li","orcid":"https://orcid.org/0000-0002-2165-2636"},"institutions":[{"id":"https://openalex.org/I37461747","display_name":"Wuhan University","ror":"https://ror.org/033vjfk17","country_code":"CN","type":"education","lineage":["https://openalex.org/I37461747"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Bing Li","raw_affiliation_strings":["School of Computer Science, Wuhan University, Wuhan, China"],"affiliations":[{"raw_affiliation_string":"School of Computer Science, Wuhan University, Wuhan, China","institution_ids":["https://openalex.org/I37461747"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5051512158","display_name":"Guandong Xu","orcid":"https://orcid.org/0000-0003-4493-6663"},"institutions":[{"id":"https://openalex.org/I114017466","display_name":"University of Technology Sydney","ror":"https://ror.org/03f0f6041","country_code":"AU","type":"education","lineage":["https://openalex.org/I114017466"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Guandong Xu","raw_affiliation_strings":["Advanced Analytics Institute, University of Technology Sydney, Australia"],"affiliations":[{"raw_affiliation_string":"Advanced Analytics Institute, University of Technology Sydney, Australia","institution_ids":["https://openalex.org/I114017466"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018304404","display_name":"Mohammed A. S. Mosleh","orcid":"https://orcid.org/0000-0002-9869-1991"},"institutions":[{"id":"https://openalex.org/I33851549","display_name":"Coimbatore Medical College and Hospital","ror":"https://ror.org/03dn3wf28","country_code":"IN","type":"education","lineage":["https://openalex.org/I33851549"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Mohammed A. S. Mosleh","raw_affiliation_strings":["School of IT & Science, Dr. G.R.Damodaran College of Science, Coimbatore, India"],"affiliations":[{"raw_affiliation_string":"School of IT & Science, Dr. G.R.Damodaran College of Science, Coimbatore, India","institution_ids":["https://openalex.org/I33851549"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5083995138","display_name":"Xiwu Gu","orcid":null},"institutions":[{"id":"https://openalex.org/I47720641","display_name":"Huazhong University of Science and Technology","ror":"https://ror.org/00p991c53","country_code":"CN","type":"education","lineage":["https://openalex.org/I47720641"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xiwu Gu","raw_affiliation_strings":["School of Computer Science and Technology, Huazhong University of Science and Technology, Wuhan, China","PUBLICATIONS"],"affiliations":[{"raw_affiliation_string":"School of Computer Science and Technology, Huazhong University of Science and Technology, Wuhan, China","institution_ids":["https://openalex.org/I47720641"]},{"raw_affiliation_string":"PUBLICATIONS","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100432137","display_name":"Yuhua Li","orcid":"https://orcid.org/0000-0002-1846-4941"},"institutions":[{"id":"https://openalex.org/I47720641","display_name":"Huazhong University of Science and Technology","ror":"https://ror.org/00p991c53","country_code":"CN","type":"education","lineage":["https://openalex.org/I47720641"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yuhua Li","raw_affiliation_strings":["School of Computer Science and Technology, Huazhong University of Science and Technology, Wuhan, China","PUBLICATIONS"],"affiliations":[{"raw_affiliation_string":"School of Computer Science and Technology, Huazhong University of Science and Technology, Wuhan, China","institution_ids":["https://openalex.org/I47720641"]},{"raw_affiliation_string":"PUBLICATIONS","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5001839092"],"corresponding_institution_ids":["https://openalex.org/I37461747"],"apc_list":null,"apc_paid":null,"fwci":0.6515,"has_fulltext":true,"cited_by_count":4,"citation_normalized_percentile":{"value":0.7757561,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"13","issue":"11","first_page":"573","last_page":"599"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9997000098228455,"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.9997000098228455,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9922999739646912,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9921000003814697,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/sparql","display_name":"SPARQL","score":0.9136195182800293},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8590937256813049},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6874724626541138},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.6061098575592041},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.49974536895751953},{"id":"https://openalex.org/keywords/ontology","display_name":"Ontology","score":0.4818459749221802},{"id":"https://openalex.org/keywords/named-graph","display_name":"Named graph","score":0.4508095979690552},{"id":"https://openalex.org/keywords/transformation","display_name":"Transformation (genetics)","score":0.45015639066696167},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.4208659529685974},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3488253355026245},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.28894534707069397},{"id":"https://openalex.org/keywords/rdf","display_name":"RDF","score":0.2105005383491516},{"id":"https://openalex.org/keywords/semantic-web","display_name":"Semantic Web","score":0.13196679949760437},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.12943506240844727}],"concepts":[{"id":"https://openalex.org/C41009113","wikidata":"https://www.wikidata.org/wiki/Q54871","display_name":"SPARQL","level":4,"score":0.9136195182800293},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8590937256813049},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6874724626541138},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.6061098575592041},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.49974536895751953},{"id":"https://openalex.org/C25810664","wikidata":"https://www.wikidata.org/wiki/Q44325","display_name":"Ontology","level":2,"score":0.4818459749221802},{"id":"https://openalex.org/C110893760","wikidata":"https://www.wikidata.org/wiki/Q3115590","display_name":"Named graph","level":5,"score":0.4508095979690552},{"id":"https://openalex.org/C204241405","wikidata":"https://www.wikidata.org/wiki/Q461499","display_name":"Transformation (genetics)","level":3,"score":0.45015639066696167},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4208659529685974},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3488253355026245},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.28894534707069397},{"id":"https://openalex.org/C147497476","wikidata":"https://www.wikidata.org/wiki/Q54872","display_name":"RDF","level":3,"score":0.2105005383491516},{"id":"https://openalex.org/C2129575","wikidata":"https://www.wikidata.org/wiki/Q54837","display_name":"Semantic Web","level":2,"score":0.13196679949760437},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.12943506240844727},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.17706/jsw.13.11.573-599","is_oa":true,"landing_page_url":"https://doi.org/10.17706/jsw.13.11.573-599","pdf_url":"http://www.jsoftware.us/vol13/356-JSW15349.pdf","source":{"id":"https://openalex.org/S114141714","display_name":"Journal of Software","issn_l":"1796-217X","issn":["1796-217X"],"is_oa":true,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318660","host_organization_name":"Academy Publisher","host_organization_lineage":["https://openalex.org/P4310318660"],"host_organization_lineage_names":["Academy Publisher"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Software","raw_type":"journal-article"},{"id":"pmh:oai:opus.lib.uts.edu.au:10453/139451","is_oa":true,"landing_page_url":"http://hdl.handle.net/10453/139451","pdf_url":null,"source":{"id":"https://openalex.org/S4306401357","display_name":"UTS ePRESS (University of Technology Sydney)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I114017466","host_organization_name":"University of Technology Sydney","host_organization_lineage":["https://openalex.org/I114017466"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Journal Article"}],"best_oa_location":{"id":"doi:10.17706/jsw.13.11.573-599","is_oa":true,"landing_page_url":"https://doi.org/10.17706/jsw.13.11.573-599","pdf_url":"http://www.jsoftware.us/vol13/356-JSW15349.pdf","source":{"id":"https://openalex.org/S114141714","display_name":"Journal of Software","issn_l":"1796-217X","issn":["1796-217X"],"is_oa":true,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318660","host_organization_name":"Academy Publisher","host_organization_lineage":["https://openalex.org/P4310318660"],"host_organization_lineage_names":["Academy Publisher"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Software","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2903231649.pdf","grobid_xml":"https://content.openalex.org/works/W2903231649.grobid-xml"},"referenced_works_count":34,"referenced_works":["https://openalex.org/W77899589","https://openalex.org/W1214084238","https://openalex.org/W1503023288","https://openalex.org/W2013970953","https://openalex.org/W2067812505","https://openalex.org/W2073350799","https://openalex.org/W2080845149","https://openalex.org/W2081624704","https://openalex.org/W2094598697","https://openalex.org/W2110077960","https://openalex.org/W2132309377","https://openalex.org/W2132731949","https://openalex.org/W2154687603","https://openalex.org/W2162736805","https://openalex.org/W2166306255","https://openalex.org/W2171884570","https://openalex.org/W2188661153","https://openalex.org/W2242459625","https://openalex.org/W2248098515","https://openalex.org/W2274356958","https://openalex.org/W2377722226","https://openalex.org/W2407005024","https://openalex.org/W2486829137","https://openalex.org/W2501334843","https://openalex.org/W4253004905","https://openalex.org/W4285719527","https://openalex.org/W6628014111","https://openalex.org/W6641973250","https://openalex.org/W6653988084","https://openalex.org/W6670660508","https://openalex.org/W6674244251","https://openalex.org/W6679827517","https://openalex.org/W6724428146","https://openalex.org/W6821143472"],"related_works":["https://openalex.org/W2038821533","https://openalex.org/W1976467436","https://openalex.org/W2169207980","https://openalex.org/W2397414079","https://openalex.org/W1574546694","https://openalex.org/W2515258154","https://openalex.org/W2356335648","https://openalex.org/W2344525199","https://openalex.org/W2614542053","https://openalex.org/W2145395633"],"abstract_inverted_index":{"Semantic":[0,49,81,192],"web":[1,4,21,31],"is":[2,274,292],"a":[3,96,228,244],"of":[5,19,27,53,67,79,130,152,184,230,236,288],"linked":[6],"RDF":[7,125,254],"data":[8,14,28,42,62,85,171],"that":[9,251],"can":[10],"exchange":[11],"and":[12,35,61,65,77,138,149,220,280],"reuse":[13],"allowing":[15],"for":[16,74,94,217,241,247],"more":[17,201],"use":[18],"traditional":[20],"documents.":[22],"However,":[23],"the":[24,30,48,75,80,84,109,157,161,174,182,204,212,223,289],"huge":[25],"amount":[26],"on":[29,147],"are":[32,71],"still":[33],"formed":[34],"stored":[36],"in":[37,108,136,160,181,253],"relational":[38,59,110,132,162,237,245,261],"databases":[39],"(RDBs),":[40],"such":[41],"cannot":[43],"be":[44],"used":[45],"directly":[46,155],"via":[47],"Web.":[50],"Consequently,":[51],"construction":[52],"ontology":[54,69,107,123,154,179],"(Semantic":[55],"Web":[56,82],"-side)":[57,64],"from":[58,83,156],"schema":[60,219],"(RDBs":[63],"querying":[66],"constructed":[68],"semantically":[70],"fundamental":[72,234],"challenges":[73],"development":[76],"integration":[78],"source":[86],"(i.e.":[87,124],"database).":[88],"This":[89,114],"paper":[90],"proposes":[91],"an":[92],"approach":[93,115,273,284,291],"providing":[95,207],"formulated":[97],"operation":[98,134,263],"rules":[99,151,209,231],"to":[100,128,169,187,199,210],"express":[101],"semantic":[102,196,268],"queries":[103,120,135,264,269],"against":[104],"structured":[105],"graph":[106,267],"query":[111,197],"language":[112],"SQL.":[113],"applied":[116],"by":[117,140,233,294],"rewriting":[118],"SPARQL":[119,248],"over":[121,249],"generated":[122,178],"triples)":[126],"corresponding":[127],"advantages":[129],"SQL":[131,260],"algebra":[133,238,246,262],"RDBs":[137,250],"performed":[139],"two":[141],"phases.":[142],"The":[143,177,271,286],"first":[144,205],"phase":[145,206],"focused":[146],"proposing":[148],"improving":[150],"extracting":[153],"important":[158],"concepts":[159],"database":[163,166],"with":[164,276,282],"considering":[165],"containing":[167],"null-values":[168],"avoid":[170],"losses":[172],"during":[173],"transformation":[175],"process.":[176],"represented":[180,252],"form":[183],"OWL-RDFS/RDF":[185],"triples":[186],"ensure":[188],"its":[189],"availability":[190],"at":[191],"Web,":[193],"thus":[194],"help":[195],"engines":[198],"answer":[200],"queries.":[202],"Furthermore,":[203],"additional":[208],"generate":[211],"Internationalized":[213],"Resource":[214],"Identifiers":[215],"(IRIs)":[216],"RDB":[218],"data.":[221],"In":[222,256],"second":[224],"phase,":[225],"we":[226],"proposed":[227,272,290],"set":[229],"inspired":[232],"operations":[235],"(SQL":[239],"algebra)":[240],"rewrit":[242],"ing":[243],"triples.":[255],"other":[257],"words,":[258],"translating":[259],"into":[265],"equivalent":[266],"(SPARQL).":[270],"demonstrated":[275],"examples,":[277],"validated,":[278],"implemented":[279],"compared":[281],"existing":[283],"methods.":[285],"effectiveness":[287],"evaluated":[293],"experimental":[295],"results.":[296]},"counts_by_year":[{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":3}],"updated_date":"2026-01-13T01:12:25.745995","created_date":"2018-12-11T00:00:00"}