{"id":"https://openalex.org/W2114766826","doi":"https://doi.org/10.1145/1071610.1071618","title":"Relational languages for metadata integration","display_name":"Relational languages for metadata integration","publication_year":2005,"publication_date":"2005-06-01","ids":{"openalex":"https://openalex.org/W2114766826","doi":"https://doi.org/10.1145/1071610.1071618","mag":"2114766826"},"language":"en","primary_location":{"id":"doi:10.1145/1071610.1071618","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1071610.1071618","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"},"type":"article","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/A5023269394","display_name":"Catharine M. Wyss","orcid":null},"institutions":[{"id":"https://openalex.org/I4210119109","display_name":"Indiana University Bloomington","ror":"https://ror.org/02k40bc56","country_code":"US","type":"education","lineage":["https://openalex.org/I4210119109","https://openalex.org/I592451"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Catharine M. Wyss","raw_affiliation_strings":["Indiana University, Bloomington, IN"],"affiliations":[{"raw_affiliation_string":"Indiana University, Bloomington, IN","institution_ids":["https://openalex.org/I4210119109"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5070997520","display_name":"Edward L. Robertson","orcid":null},"institutions":[{"id":"https://openalex.org/I4210119109","display_name":"Indiana University Bloomington","ror":"https://ror.org/02k40bc56","country_code":"US","type":"education","lineage":["https://openalex.org/I4210119109","https://openalex.org/I592451"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Edward L. Robertson","raw_affiliation_strings":["Indiana University, Bloomington, IN"],"affiliations":[{"raw_affiliation_string":"Indiana University, Bloomington, IN","institution_ids":["https://openalex.org/I4210119109"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5023269394"],"corresponding_institution_ids":["https://openalex.org/I4210119109"],"apc_list":null,"apc_paid":null,"fwci":7.117,"has_fulltext":false,"cited_by_count":57,"citation_normalized_percentile":{"value":0.97268847,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":"30","issue":"2","first_page":"624","last_page":"660"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9997000098228455,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9997000098228455,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9990000128746033,"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/T11106","display_name":"Data Management and Algorithms","score":0.995199978351593,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/computer-science","display_name":"Computer science","score":0.8254460096359253},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.6181861162185669},{"id":"https://openalex.org/keywords/relational-algebra","display_name":"Relational algebra","score":0.6127064228057861},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5332306027412415},{"id":"https://openalex.org/keywords/metadata","display_name":"Metadata","score":0.5179411768913269},{"id":"https://openalex.org/keywords/interoperability","display_name":"Interoperability","score":0.511405885219574},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.49500077962875366},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.47127339243888855},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.45840907096862793},{"id":"https://openalex.org/keywords/relational-calculus","display_name":"Relational calculus","score":0.4360448122024536},{"id":"https://openalex.org/keywords/xquery","display_name":"XQuery","score":0.4348561763763428},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.43460845947265625},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.3968963027000427},{"id":"https://openalex.org/keywords/xml","display_name":"XML","score":0.3481517434120178},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3342738151550293},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3209017515182495},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.11097681522369385},{"id":"https://openalex.org/keywords/document-structure-description","display_name":"Document Structure Description","score":0.09628760814666748}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8254460096359253},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6181861162185669},{"id":"https://openalex.org/C95916125","wikidata":"https://www.wikidata.org/wiki/Q840540","display_name":"Relational algebra","level":3,"score":0.6127064228057861},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5332306027412415},{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.5179411768913269},{"id":"https://openalex.org/C20136886","wikidata":"https://www.wikidata.org/wiki/Q749647","display_name":"Interoperability","level":2,"score":0.511405885219574},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.49500077962875366},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.47127339243888855},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.45840907096862793},{"id":"https://openalex.org/C99436015","wikidata":"https://www.wikidata.org/wiki/Q1722436","display_name":"Relational calculus","level":4,"score":0.4360448122024536},{"id":"https://openalex.org/C2780512708","wikidata":"https://www.wikidata.org/wiki/Q850661","display_name":"XQuery","level":4,"score":0.4348561763763428},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.43460845947265625},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.3968963027000427},{"id":"https://openalex.org/C8797682","wikidata":"https://www.wikidata.org/wiki/Q2115","display_name":"XML","level":2,"score":0.3481517434120178},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3342738151550293},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3209017515182495},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.11097681522369385},{"id":"https://openalex.org/C68699486","wikidata":"https://www.wikidata.org/wiki/Q265904","display_name":"Document Structure Description","level":3,"score":0.09628760814666748}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1071610.1071618","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1071610.1071618","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Database Systems","raw_type":"journal-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.177.942","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.177.942","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://se-pubs.dbs.uni-leipzig.de/files/Wyss2005Relationallanguagesfor.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":48,"referenced_works":["https://openalex.org/W47776782","https://openalex.org/W96866586","https://openalex.org/W132530506","https://openalex.org/W1500120746","https://openalex.org/W1527137462","https://openalex.org/W1535080919","https://openalex.org/W1537244157","https://openalex.org/W1546474256","https://openalex.org/W1551066637","https://openalex.org/W1558832481","https://openalex.org/W1561055565","https://openalex.org/W1565494300","https://openalex.org/W1567277549","https://openalex.org/W1568349357","https://openalex.org/W1580024578","https://openalex.org/W1584213049","https://openalex.org/W1585724235","https://openalex.org/W1604542907","https://openalex.org/W1888032506","https://openalex.org/W1962807519","https://openalex.org/W1963499787","https://openalex.org/W1967104660","https://openalex.org/W1977583107","https://openalex.org/W1979966822","https://openalex.org/W1992673035","https://openalex.org/W1997533292","https://openalex.org/W2004943427","https://openalex.org/W2005835473","https://openalex.org/W2023449612","https://openalex.org/W2029207367","https://openalex.org/W2055897254","https://openalex.org/W2064466058","https://openalex.org/W2083250222","https://openalex.org/W2099825534","https://openalex.org/W2112719612","https://openalex.org/W2119240138","https://openalex.org/W2124812961","https://openalex.org/W2165023040","https://openalex.org/W2170192471","https://openalex.org/W2172549414","https://openalex.org/W2185907055","https://openalex.org/W2193692765","https://openalex.org/W2753710282","https://openalex.org/W2911554492","https://openalex.org/W2988119170","https://openalex.org/W4248717900","https://openalex.org/W4254819021","https://openalex.org/W4285719527"],"related_works":["https://openalex.org/W206482712","https://openalex.org/W1494193231","https://openalex.org/W3174970460","https://openalex.org/W2013334450","https://openalex.org/W1979093255","https://openalex.org/W1525937901","https://openalex.org/W79051208","https://openalex.org/W4243306847","https://openalex.org/W2137485709","https://openalex.org/W2093882190"],"abstract_inverted_index":{"In":[0,207],"this":[1,115],"article,":[2],"we":[3,143,213],"develop":[4],"a":[5,25,28,35,158,166],"relational":[6,89,122,140,151,231],"algebra":[7],"for":[8,32,88,124,150],"metadata":[9,90,125],"integration,":[10,91,126],"Federated":[11,128,177],"Interoperable":[12,178],"Relational":[13,40,129],"Algebra":[14,41],"(FIRA).":[15],"FIRA":[16,53,93,156,218],"has":[17],"many":[18],"desirable":[19],"properties":[20],"such":[21],"as":[22,157,244,246],"compositionality,":[23],"closure,":[24],"deterministic":[26],"semantics,":[27],"modest":[29],"complexity,":[30],"support":[31],"nested":[33],"queries,":[34],"subalgebra":[36],"equivalent":[37,173],"to":[38,174,202,209,219],"canonical":[39,159,230],"(RA),":[42],"and":[43,154,192,205,251],"robustness":[44],"under":[45],"certain":[46],"classes":[47],"of":[48,57,66,71,75,106,114,119,147,195,217,241,249],"schema":[49],"evolution.":[50],"Beyond":[51],"this,":[52],"queries":[54,222],"are":[55,186],"capable":[56],"producing":[58],"fully":[59],"dynamic":[60,96],"output":[61,77,97,111],"schemas,":[62,98],"where":[63,99],"the":[64,69,76,81,100,127,139,145,188,193,215,235],"number":[65,70,105],"relations":[67,74],"and/or":[68],"columns":[72,108],"in":[73,102],"varies":[78],"dynamically":[79],"with":[80,138,237],"input":[82,107],"instance.":[83],"Among":[84],"existing":[85],"query":[86,152,169],"languages":[87,153],"only":[92],"provides":[94],"generalized":[95],"values":[101],"any":[103],"(fixed)":[104],"can":[109],"determine":[110],"schemas.Further":[112],"contributions":[113,185],"article":[116,236],"include":[117],"development":[118],"an":[120,238,247],"extended":[121,239],"model":[123],"Data":[130],"Model":[131],",":[132],"which":[133],"is":[134,172],"strictly":[135],"downward":[136],"compatible":[137],"model.":[141],"Additionally,":[142],"define":[144],"notion":[146,194],"Transformational":[148],"Completeness":[149],"postulate":[155],"transformationally":[160],"complete":[161],"language.":[162],"We":[163,233],"also":[164],"give":[165],"declarative,":[167],"SQL-like":[168],"language":[170],"that":[171,226],"FIRA,":[175],"called":[176],"Structured":[179],"Query":[180],"Language":[181],"(FISQL).While":[182],"our":[183],"main":[184],"conceptual,":[187],"federated":[189],"model,":[190],"FISQL/FIRA,":[191],"transformational":[196],"completeness":[197],"nevertheless":[198],"have":[199],"important":[200],"applications":[201],"data":[203],"integration":[204],"OLAP.":[206],"addition":[208],"summarizing":[210],"these":[211],"applications,":[212],"illustrate":[214],"use":[216],"optimize":[220],"FISQL":[221],"using":[223],"rule-based":[224],"transformations":[225],"directly":[227],"parallel":[228],"their":[229],"counterparts.":[232],"conclude":[234],"discussion":[240],"related":[242],"work":[243,253],"well":[245],"indication":[248],"current":[250],"future":[252],"on":[254],"FISQL/FIRA.":[255]},"counts_by_year":[{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":1},{"year":2016,"cited_by_count":4},{"year":2015,"cited_by_count":5},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":3}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}