{"id":"https://openalex.org/W2293935537","doi":"https://doi.org/10.1145/1514894.1514920","title":"Reconcilable differences","display_name":"Reconcilable differences","publication_year":2009,"publication_date":"2009-03-23","ids":{"openalex":"https://openalex.org/W2293935537","doi":"https://doi.org/10.1145/1514894.1514920","mag":"2293935537"},"language":"en","primary_location":{"id":"doi:10.1145/1514894.1514920","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1514894.1514920","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1514894.1514920","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 12th International Conference on Database Theory","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/1514894.1514920","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5101760885","display_name":"Todd J. Green","orcid":"https://orcid.org/0000-0001-6490-2669"},"institutions":[{"id":"https://openalex.org/I79576946","display_name":"University of Pennsylvania","ror":"https://ror.org/00b30xv10","country_code":"US","type":"education","lineage":["https://openalex.org/I79576946"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Todd J. Green","raw_affiliation_strings":["University of Pennsylvania, Philadelphia, PA"],"affiliations":[{"raw_affiliation_string":"University of Pennsylvania, Philadelphia, PA","institution_ids":["https://openalex.org/I79576946"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063822723","display_name":"Zachary G. Ives","orcid":"https://orcid.org/0000-0001-7527-2957"},"institutions":[{"id":"https://openalex.org/I79576946","display_name":"University of Pennsylvania","ror":"https://ror.org/00b30xv10","country_code":"US","type":"education","lineage":["https://openalex.org/I79576946"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zachary G. Ives","raw_affiliation_strings":["University of Pennsylvania, Philadelphia, PA"],"affiliations":[{"raw_affiliation_string":"University of Pennsylvania, Philadelphia, PA","institution_ids":["https://openalex.org/I79576946"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5036528289","display_name":"Val Tannen","orcid":"https://orcid.org/0009-0008-6847-7274"},"institutions":[{"id":"https://openalex.org/I79576946","display_name":"University of Pennsylvania","ror":"https://ror.org/00b30xv10","country_code":"US","type":"education","lineage":["https://openalex.org/I79576946"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Val Tannen","raw_affiliation_strings":["University of Pennsylvania, Philadelphia, PA"],"affiliations":[{"raw_affiliation_string":"University of Pennsylvania, Philadelphia, PA","institution_ids":["https://openalex.org/I79576946"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5101760885"],"corresponding_institution_ids":["https://openalex.org/I79576946"],"apc_list":null,"apc_paid":null,"fwci":5.4382,"has_fulltext":true,"cited_by_count":23,"citation_normalized_percentile":{"value":0.9614016,"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":"212","last_page":"224"},"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.9998999834060669,"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.9998999834060669,"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.9991999864578247,"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.9986000061035156,"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/undecidable-problem","display_name":"Undecidable problem","score":0.7482633590698242},{"id":"https://openalex.org/keywords/negation","display_name":"Negation","score":0.7308590412139893},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7260046601295471},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.6237050294876099},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.6098745465278625},{"id":"https://openalex.org/keywords/variety","display_name":"Variety (cybernetics)","score":0.5534579157829285},{"id":"https://openalex.org/keywords/xquery","display_name":"XQuery","score":0.5001020431518555},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.48312947154045105},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4806443750858307},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.4519590139389038},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.4495278596878052},{"id":"https://openalex.org/keywords/relational-algebra","display_name":"Relational algebra","score":0.4331846833229065},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3741151690483093},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.359494149684906},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.31586170196533203},{"id":"https://openalex.org/keywords/decidability","display_name":"Decidability","score":0.2626323699951172},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.2070048749446869},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.14335989952087402},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.1359235942363739},{"id":"https://openalex.org/keywords/xml","display_name":"XML","score":0.10159003734588623},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.1014481782913208}],"concepts":[{"id":"https://openalex.org/C192034797","wikidata":"https://www.wikidata.org/wiki/Q3502995","display_name":"Undecidable problem","level":3,"score":0.7482633590698242},{"id":"https://openalex.org/C2185349","wikidata":"https://www.wikidata.org/wiki/Q190558","display_name":"Negation","level":2,"score":0.7308590412139893},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7260046601295471},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.6237050294876099},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.6098745465278625},{"id":"https://openalex.org/C136197465","wikidata":"https://www.wikidata.org/wiki/Q1729295","display_name":"Variety (cybernetics)","level":2,"score":0.5534579157829285},{"id":"https://openalex.org/C2780512708","wikidata":"https://www.wikidata.org/wiki/Q850661","display_name":"XQuery","level":4,"score":0.5001020431518555},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.48312947154045105},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4806443750858307},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.4519590139389038},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4495278596878052},{"id":"https://openalex.org/C95916125","wikidata":"https://www.wikidata.org/wiki/Q840540","display_name":"Relational algebra","level":3,"score":0.4331846833229065},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3741151690483093},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.359494149684906},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.31586170196533203},{"id":"https://openalex.org/C153269930","wikidata":"https://www.wikidata.org/wiki/Q430001","display_name":"Decidability","level":2,"score":0.2626323699951172},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.2070048749446869},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.14335989952087402},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.1359235942363739},{"id":"https://openalex.org/C8797682","wikidata":"https://www.wikidata.org/wiki/Q2115","display_name":"XML","level":2,"score":0.10159003734588623},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.1014481782913208},{"id":"https://openalex.org/C68699486","wikidata":"https://www.wikidata.org/wiki/Q265904","display_name":"Document Structure Description","level":3,"score":0.0}],"mesh":[],"locations_count":7,"locations":[{"id":"doi:10.1145/1514894.1514920","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1514894.1514920","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1514894.1514920","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 12th International Conference on Database Theory","raw_type":"proceedings-article"},{"id":"pmh:oai:repository.upenn.edu:20.500.14332/8792","is_oa":false,"landing_page_url":"https://repository.upenn.edu/handle/20.500.14332/8792","pdf_url":null,"source":{"id":"https://openalex.org/S4377196331","display_name":"Scholarly Commons (University of Pennsylvania)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I79576946","host_organization_name":"University of Pennsylvania","host_organization_lineage":["https://openalex.org/I79576946"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"published","raw_type":"Presentation"},{"id":"pmh:oai:repository.upenn.edu:db_research-1050","is_oa":false,"landing_page_url":"https://repository.upenn.edu/db_research/45","pdf_url":null,"source":{"id":"https://openalex.org/S4306402083","display_name":"ScholarlyCommons (University of Pennsylvania)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I79576946","host_organization_name":"University of Pennsylvania","host_organization_lineage":["https://openalex.org/I79576946"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Database Research Group (CIS)","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.145.9661","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.145.9661","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cis.upenn.edu/~tjgreen/papers/icdt2009_differences.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.221.1916","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.221.1916","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cis.upenn.edu/%7Ezives/research/diffs-tocs.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.232.4801","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.232.4801","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.ucdavis.edu/%7Egreen/papers/tocs11_differences.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.259.7798","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.259.7798","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"text"}],"best_oa_location":{"id":"doi:10.1145/1514894.1514920","is_oa":true,"landing_page_url":"https://doi.org/10.1145/1514894.1514920","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/1514894.1514920","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 12th International Conference on Database Theory","raw_type":"proceedings-article"},"sustainable_development_goals":[{"score":0.5099999904632568,"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2293935537.pdf","grobid_xml":"https://content.openalex.org/works/W2293935537.grobid-xml"},"referenced_works_count":27,"referenced_works":["https://openalex.org/W655258421","https://openalex.org/W1573467490","https://openalex.org/W1969990839","https://openalex.org/W1975733288","https://openalex.org/W1979514837","https://openalex.org/W2012670464","https://openalex.org/W2029038562","https://openalex.org/W2033026830","https://openalex.org/W2048531653","https://openalex.org/W2056660085","https://openalex.org/W2056907916","https://openalex.org/W2079590017","https://openalex.org/W2090337980","https://openalex.org/W2099477710","https://openalex.org/W2125332694","https://openalex.org/W2136195851","https://openalex.org/W2150616017","https://openalex.org/W2152191782","https://openalex.org/W2153329411","https://openalex.org/W2156717879","https://openalex.org/W2160770337","https://openalex.org/W2163491591","https://openalex.org/W2200545814","https://openalex.org/W2293299776","https://openalex.org/W2485417371","https://openalex.org/W2752885492","https://openalex.org/W4250587856"],"related_works":["https://openalex.org/W1880902590","https://openalex.org/W2068199351","https://openalex.org/W2085988990","https://openalex.org/W2089781037","https://openalex.org/W2056340443","https://openalex.org/W2046615742","https://openalex.org/W2609335432","https://openalex.org/W2015372451","https://openalex.org/W1516375613","https://openalex.org/W206482712"],"abstract_inverted_index":{"Exact":[0],"query":[1,19,47],"reformulation":[2],"using":[3],"views":[4],"in":[5,18,59,76],"positive":[6,103],"relational":[7,30],"languages":[8],"is":[9],"well":[10],"understood,":[11],"and":[12,21,49,66],"has":[13],"a":[14,56,62,83,94],"variety":[15],"of":[16,28,79,86],"applications":[17],"optimization":[20],"data":[22],"sharing.":[23],"Generalizations":[24],"to":[25,52,61],"larger":[26],"fragments":[27],"the":[29,37,43,77],"algebra":[31],"(RA)":[32],"---":[33,40],"specifically,":[34],"support":[35],"for":[36,46],"difference":[38],"operator":[39],"would":[41],"increase":[42],"options":[44],"available":[45],"reformulation,":[48],"also":[50],"apply":[51],"view":[53,58,64,67],"adaptation":[54],"(updating":[55],"materialized":[57],"response":[60],"modified":[63],"definition)":[65],"maintenance.":[68],"Unfortunately,":[69],"most":[70],"questions":[71],"about":[72],"queries":[73],"become":[74],"undecidable":[75],"presence":[78],"difference/negation.":[80],"We":[81],"present":[82],"novel":[84],"way":[85],"managing":[87],"this":[88],"difficulty":[89],"via":[90],"an":[91],"excursion":[92],"through":[93],"non-standard":[95],"semantics,":[96],"Z-relations,":[97],"where":[98],"tuples":[99],"are":[100],"annotated":[101],"with":[102],"or":[104],"negative":[105],"integers.":[106]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":2},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}