{"id":"https://openalex.org/W2061712899","doi":"https://doi.org/10.1145/1142351.1142359","title":"Inverting schema mappings","display_name":"Inverting schema mappings","publication_year":2006,"publication_date":"2006-06-26","ids":{"openalex":"https://openalex.org/W2061712899","doi":"https://doi.org/10.1145/1142351.1142359","mag":"2061712899"},"language":"en","primary_location":{"id":"doi:10.1145/1142351.1142359","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1142351.1142359","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-fifth 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"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Ronald Fagin","raw_affiliation_strings":["IBM Almaden Research Center, San Jose, CA","IBM Almaden Research Center San Jose , CA"],"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center San Jose , CA","institution_ids":["https://openalex.org/I4210085935"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5027117465"],"corresponding_institution_ids":["https://openalex.org/I4210085935"],"apc_list":null,"apc_paid":null,"fwci":8.3737,"has_fulltext":false,"cited_by_count":37,"citation_normalized_percentile":{"value":0.97383167,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"50","last_page":"59"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9987999796867371,"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.9987999796867371,"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.9969000220298767,"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.9519000053405762,"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/schema","display_name":"Schema (genetic algorithms)","score":0.7186902165412903},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6666790246963501},{"id":"https://openalex.org/keywords/inverse","display_name":"Inverse","score":0.6426659822463989},{"id":"https://openalex.org/keywords/conceptual-schema","display_name":"Conceptual schema","score":0.5454732179641724},{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.5219380855560303},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.5010678768157959},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.4981253147125244},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.47474533319473267},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.30367857217788696},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.3035721182823181},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2956048846244812},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.21609371900558472},{"id":"https://openalex.org/keywords/linguistics","display_name":"Linguistics","score":0.09048080444335938}],"concepts":[{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.7186902165412903},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6666790246963501},{"id":"https://openalex.org/C207467116","wikidata":"https://www.wikidata.org/wiki/Q4385666","display_name":"Inverse","level":2,"score":0.6426659822463989},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.5454732179641724},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.5219380855560303},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.5010678768157959},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.4981253147125244},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.47474533319473267},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.30367857217788696},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.3035721182823181},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2956048846244812},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.21609371900558472},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.09048080444335938},{"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/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1142351.1142359","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1142351.1142359","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-fifth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems","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":17,"referenced_works":["https://openalex.org/W49766897","https://openalex.org/W101493532","https://openalex.org/W1966294080","https://openalex.org/W1992673035","https://openalex.org/W2020228538","https://openalex.org/W2025151754","https://openalex.org/W2028222220","https://openalex.org/W2073279331","https://openalex.org/W2102729564","https://openalex.org/W2110810394","https://openalex.org/W2125822162","https://openalex.org/W2140957972","https://openalex.org/W2155758146","https://openalex.org/W2159686758","https://openalex.org/W2163004878","https://openalex.org/W3127113455","https://openalex.org/W6675529698"],"related_works":["https://openalex.org/W2092058806","https://openalex.org/W945629821","https://openalex.org/W156948967","https://openalex.org/W2093134728","https://openalex.org/W2153512431","https://openalex.org/W629399385","https://openalex.org/W166845585","https://openalex.org/W1992271858","https://openalex.org/W2103472145","https://openalex.org/W4238907651"],"abstract_inverted_index":{"A":[0,129],"schema":[1,13,27,39,57,103,112,161],"mapping":[2,40,49,58,85,104,113],"is":[3,17,41,50,54,89,137,148,175,225],"a":[4,25,38,56,84,94,102,111,116,149,170,178,183,203],"specification":[5],"that":[6,80,223],"describes":[7],"how":[8,188,200,215],"data":[9,22],"structured":[10,23],"under":[11,24],"one":[12,194,207],"(the":[14,28],"source":[15,66,70,120],"schema)":[16],"to":[18,106,189,201,216],"be":[19,107],"transformed":[20],"into":[21],"different":[26],"target":[29,62,74],"schema).":[30],"Although":[31],"the":[32,43,78,81,90,138,155,218],"notion":[33,79],"of":[34,37,46,83,110,119,132,140,160,180,228],"an":[35,47,108,125,127,146,191,226],"inverse":[36,48,88,109,126,205],"important,":[42],"exact":[44],"definition":[45,96],"somewhat":[51],"elusive.":[52],"This":[53],"because":[55],"may":[59],"associate":[60],"many":[61,69],"instances":[63,71],"with":[64,72,182],"each":[65,73],"instance,":[67],"and":[68,86,157,168,211],"instance.":[75],"Based":[76],"on":[77,154],"composition":[82],"its":[87],"identity,":[91],"we":[92,186,198,213],"give":[93],"formal":[95],"for":[97,101,115],"what":[98],"it":[99],"means":[100],"M\u2032":[105,224],"M":[114,210],"class":[117,139,220],"S":[118,136,174,221],"instances.":[121],"We":[122,152],"call":[123],"such":[124,222],"S-inverse.":[128],"particular":[130],"case":[131,145,159],"interest":[133],"arises":[134],"when":[135,193,206],"all":[141],"instances,":[142],"in":[143],"which":[144],"S-inverse":[147,192,227],"global":[150,204],"inverse.":[151],"focus":[153],"important":[156],"practical":[158],"mappings":[162],"defined":[163,176],"by":[164,177],"source-to-target":[165],"tuple-generating":[166],"dependencies,":[167],"uncover":[169],"rich":[171],"theory.":[172],"When":[173],"set":[179],"dependencies":[181],"finite":[184],"chase,":[185],"show":[187,199,214],"construct":[190,202],"exists.":[195,208],"In":[196],"particular,":[197],"Given":[209],"M\u2032,":[212],"define":[217],"largest":[219],"M.":[229]},"counts_by_year":[{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":3},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}