{"id":"https://openalex.org/W2140957972","doi":"https://doi.org/10.1145/1265530.1265548","title":"Quasi-inverses of schema mappings","display_name":"Quasi-inverses of schema mappings","publication_year":2007,"publication_date":"2007-06-11","ids":{"openalex":"https://openalex.org/W2140957972","doi":"https://doi.org/10.1145/1265530.1265548","mag":"2140957972"},"language":"en","primary_location":{"id":"doi:10.1145/1265530.1265548","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1265530.1265548","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the twenty-sixth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems","raw_type":"proceedings-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/A5027117465","display_name":"Ronald Fagin","orcid":"https://orcid.org/0000-0002-7374-0347"},"institutions":[{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]},{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Ronald Fagin","raw_affiliation_strings":["IBM Almaden Research Center","IBM Almaden Research Center,#TAB#"],"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center,#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5041825861","display_name":"Phokion G. Kolaitis","orcid":"https://orcid.org/0000-0002-8407-8563"},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Phokion G. Kolaitis","raw_affiliation_strings":["IBM Almaden Research Center","IBM Almaden Research Center,#TAB#"],"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center,#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5105463891","display_name":"Lucian Popa","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Lucian Popa","raw_affiliation_strings":["IBM Almaden Research Center","IBM Almaden Research Center,#TAB#"],"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center,#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5026007789","display_name":"Wang-Chiew Tan","orcid":"https://orcid.org/0009-0003-4659-2291"},"institutions":[{"id":"https://openalex.org/I185103710","display_name":"University of California, Santa Cruz","ror":"https://ror.org/03s65by71","country_code":"US","type":"education","lineage":["https://openalex.org/I185103710"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Wang-Chiew Tan","raw_affiliation_strings":["UC Santa Cruz","[UC Santa Cruz.]"],"affiliations":[{"raw_affiliation_string":"UC Santa Cruz","institution_ids":["https://openalex.org/I185103710"]},{"raw_affiliation_string":"[UC Santa Cruz.]","institution_ids":["https://openalex.org/I185103710"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5027117465"],"corresponding_institution_ids":["https://openalex.org/I1341412227","https://openalex.org/I4210085935"],"apc_list":null,"apc_paid":null,"fwci":7.7009,"has_fulltext":false,"cited_by_count":33,"citation_normalized_percentile":{"value":0.97535843,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"123","last_page":"132"},"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.9986000061035156,"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.9986000061035156,"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.9970999956130981,"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.9801999926567078,"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/schema","display_name":"Schema (genetic algorithms)","score":0.7454648017883301},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6528691053390503},{"id":"https://openalex.org/keywords/operator","display_name":"Operator (biology)","score":0.5733007192611694},{"id":"https://openalex.org/keywords/inverse","display_name":"Inverse","score":0.5158485770225525},{"id":"https://openalex.org/keywords/composition-operator","display_name":"Composition operator","score":0.49434518814086914},{"id":"https://openalex.org/keywords/conceptual-schema","display_name":"Conceptual schema","score":0.4682653546333313},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.41177159547805786},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3903180956840515},{"id":"https://openalex.org/keywords/algebra-over-a-field","display_name":"Algebra over a field","score":0.3666123151779175},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.32288867235183716},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.29420924186706543},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2208724319934845},{"id":"https://openalex.org/keywords/compact-operator","display_name":"Compact operator","score":0.17949643731117249},{"id":"https://openalex.org/keywords/pure-mathematics","display_name":"Pure mathematics","score":0.14548331499099731},{"id":"https://openalex.org/keywords/linguistics","display_name":"Linguistics","score":0.09945815801620483},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.05761227011680603}],"concepts":[{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.7454648017883301},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6528691053390503},{"id":"https://openalex.org/C17020691","wikidata":"https://www.wikidata.org/wiki/Q139677","display_name":"Operator (biology)","level":5,"score":0.5733007192611694},{"id":"https://openalex.org/C207467116","wikidata":"https://www.wikidata.org/wiki/Q4385666","display_name":"Inverse","level":2,"score":0.5158485770225525},{"id":"https://openalex.org/C21513729","wikidata":"https://www.wikidata.org/wiki/Q5156798","display_name":"Composition operator","level":4,"score":0.49434518814086914},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.4682653546333313},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.41177159547805786},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3903180956840515},{"id":"https://openalex.org/C136119220","wikidata":"https://www.wikidata.org/wiki/Q1000660","display_name":"Algebra over a field","level":2,"score":0.3666123151779175},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.32288867235183716},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.29420924186706543},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2208724319934845},{"id":"https://openalex.org/C79013869","wikidata":"https://www.wikidata.org/wiki/Q1780743","display_name":"Compact operator","level":3,"score":0.17949643731117249},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.14548331499099731},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.09945815801620483},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.05761227011680603},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C100660578","wikidata":"https://www.wikidata.org/wiki/Q18733","display_name":"Recall","level":2,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C158448853","wikidata":"https://www.wikidata.org/wiki/Q425218","display_name":"Repressor","level":4,"score":0.0},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","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/C2778029271","wikidata":"https://www.wikidata.org/wiki/Q5421931","display_name":"Extension (predicate logic)","level":2,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C86339819","wikidata":"https://www.wikidata.org/wiki/Q407384","display_name":"Transcription factor","level":3,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1265530.1265548","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1265530.1265548","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the twenty-sixth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Reduced inequalities","id":"https://metadata.un.org/sdg/10","score":0.4300000071525574}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":23,"referenced_works":["https://openalex.org/W49766897","https://openalex.org/W101493532","https://openalex.org/W1482203786","https://openalex.org/W1487949759","https://openalex.org/W1514152137","https://openalex.org/W1558832481","https://openalex.org/W1560604137","https://openalex.org/W1776524264","https://openalex.org/W1924653415","https://openalex.org/W1969053136","https://openalex.org/W1992673035","https://openalex.org/W1993268751","https://openalex.org/W2020228538","https://openalex.org/W2061712899","https://openalex.org/W2095395853","https://openalex.org/W2102729564","https://openalex.org/W2125822162","https://openalex.org/W2159686758","https://openalex.org/W2159793945","https://openalex.org/W2291199017","https://openalex.org/W2397785463","https://openalex.org/W2832013179","https://openalex.org/W2997050146"],"related_works":["https://openalex.org/W629399385","https://openalex.org/W2585783528","https://openalex.org/W1851277853","https://openalex.org/W962397878","https://openalex.org/W4248994601","https://openalex.org/W2071528560","https://openalex.org/W45221955","https://openalex.org/W139721835","https://openalex.org/W2092058806","https://openalex.org/W290184810"],"abstract_inverted_index":{"Schema":[0],"mappings":[1],"are":[2,26],"high-level":[3],"specifications":[4],"that":[5,72],"describe":[6],"the":[7,19,23,33,36,48],"relationship":[8],"between":[9],"two":[10],"database":[11],"schemas.":[12],"Two":[13],"operators":[14],"on":[15,32],"schema":[16,74],"mappings,":[17],"namely":[18],"composition":[20],"operator":[21,38,53],"and":[22],"inverse":[24,37],"operator,":[25],"regarded":[27],"as":[28,45],"especially":[29],"important.":[30],"Progress":[31],"study":[34],"of":[35,51],"was":[39],"not":[40],"made":[41],"until":[42],"very":[43],"recently,":[44],"even":[46],"finding":[47],"exact":[49],"semantics":[50],"this":[52,63],"turned":[54],"out":[55],"to":[56],"be":[57],"a":[58,73],"fairly":[59],"delicate":[60],"task.":[61],"Furthermore,":[62],"notion":[64],"is":[65,70],"rather":[66],"restrictive,":[67],"since":[68],"it":[69],"rare":[71],"mapping":[75],"possesses":[76],"an":[77],"inverse.":[78]},"counts_by_year":[{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":2},{"year":2012,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}