{"id":"https://openalex.org/W3028872147","doi":"https://doi.org/10.1145/3375395.3387666","title":"Queries with Arithmetic on Incomplete Databases","display_name":"Queries with Arithmetic on Incomplete Databases","publication_year":2020,"publication_date":"2020-05-29","ids":{"openalex":"https://openalex.org/W3028872147","doi":"https://doi.org/10.1145/3375395.3387666","mag":"3028872147"},"language":"en","primary_location":{"id":"doi:10.1145/3375395.3387666","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3375395.3387666","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 39th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","raw_type":"proceedings-article"},"type":"preprint","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://iris.uniroma1.it/bitstream/11573/1474734/4/Console_Postprint_Queries-with-Arithmetic_2020.pdf.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5069002162","display_name":"Marco Console","orcid":"https://orcid.org/0009-0004-5526-019X"},"institutions":[{"id":"https://openalex.org/I3130638677","display_name":"Edinburgh College","ror":"https://ror.org/04vpa6h32","country_code":"GB","type":"education","lineage":["https://openalex.org/I3130638677"]},{"id":"https://openalex.org/I98677209","display_name":"University of Edinburgh","ror":"https://ror.org/01nrxwf90","country_code":"GB","type":"education","lineage":["https://openalex.org/I98677209"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Marco Console","raw_affiliation_strings":["University of Edinburgh, Edinburgh, United Kingdom","University of Edinburgh (Old College South Bridge Edinburgh EH8 9YL - United Kingdom)"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Edinburgh, Edinburgh, United Kingdom","institution_ids":["https://openalex.org/I98677209"]},{"raw_affiliation_string":"University of Edinburgh (Old College South Bridge Edinburgh EH8 9YL - United Kingdom)","institution_ids":["https://openalex.org/I3130638677","https://openalex.org/I98677209"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5057207055","display_name":"Matthias Hofer","orcid":"https://orcid.org/0000-0003-2029-5814"},"institutions":[{"id":"https://openalex.org/I3130638677","display_name":"Edinburgh College","ror":"https://ror.org/04vpa6h32","country_code":"GB","type":"education","lineage":["https://openalex.org/I3130638677"]},{"id":"https://openalex.org/I98677209","display_name":"University of Edinburgh","ror":"https://ror.org/01nrxwf90","country_code":"GB","type":"education","lineage":["https://openalex.org/I98677209"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Matthias Hofer","raw_affiliation_strings":["University of Edinburgh, Edinburgh, United Kingdom","University of Edinburgh (Old College South Bridge Edinburgh EH8 9YL - United Kingdom)"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Edinburgh, Edinburgh, United Kingdom","institution_ids":["https://openalex.org/I98677209"]},{"raw_affiliation_string":"University of Edinburgh (Old College South Bridge Edinburgh EH8 9YL - United Kingdom)","institution_ids":["https://openalex.org/I3130638677","https://openalex.org/I98677209"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5069883356","display_name":"Leonid Libkin","orcid":"https://orcid.org/0000-0002-6698-2735"},"institutions":[{"id":"https://openalex.org/I29607241","display_name":"\u00c9cole Normale Sup\u00e9rieure - PSL","ror":"https://ror.org/05a0dhs15","country_code":"FR","type":"other","lineage":["https://openalex.org/I2746051580","https://openalex.org/I29607241"]},{"id":"https://openalex.org/I3130638677","display_name":"Edinburgh College","ror":"https://ror.org/04vpa6h32","country_code":"GB","type":"education","lineage":["https://openalex.org/I3130638677"]},{"id":"https://openalex.org/I98677209","display_name":"University of Edinburgh","ror":"https://ror.org/01nrxwf90","country_code":"GB","type":"education","lineage":["https://openalex.org/I98677209"]}],"countries":["FR","GB"],"is_corresponding":false,"raw_author_name":"Leonid Libkin","raw_affiliation_strings":["University of Edinburgh and ENS-Paris/PSL, Edinburgh, United Kingdom","VALDA  - Value from Data (ENS Paris - France)","University of Edinburgh (Old College South Bridge Edinburgh EH8 9YL - United Kingdom)"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Edinburgh and ENS-Paris/PSL, Edinburgh, United Kingdom","institution_ids":["https://openalex.org/I98677209","https://openalex.org/I29607241"]},{"raw_affiliation_string":"VALDA  - Value from Data (ENS Paris - France)","institution_ids":[]},{"raw_affiliation_string":"University of Edinburgh (Old College South Bridge Edinburgh EH8 9YL - United Kingdom)","institution_ids":["https://openalex.org/I3130638677","https://openalex.org/I98677209"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.9126,"has_fulltext":true,"cited_by_count":9,"citation_normalized_percentile":{"value":0.80148588,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"179","last_page":"189"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.9994999766349792,"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/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.9994999766349792,"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.9993000030517578,"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"}},{"id":"https://openalex.org/T11596","display_name":"Constraint Satisfaction and Optimization","score":0.9984999895095825,"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/correctness","display_name":"Correctness","score":0.8334043025970459},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.700911819934845},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6055450439453125},{"id":"https://openalex.org/keywords/database-theory","display_name":"Database theory","score":0.529362678527832},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3974664807319641},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.3961968421936035},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3806056082248688},{"id":"https://openalex.org/keywords/arithmetic","display_name":"Arithmetic","score":0.3638184070587158},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.24812227487564087},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.22003492712974548}],"concepts":[{"id":"https://openalex.org/C55439883","wikidata":"https://www.wikidata.org/wiki/Q360812","display_name":"Correctness","level":2,"score":0.8334043025970459},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.700911819934845},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6055450439453125},{"id":"https://openalex.org/C12439846","wikidata":"https://www.wikidata.org/wiki/Q4809258","display_name":"Database theory","level":3,"score":0.529362678527832},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3974664807319641},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.3961968421936035},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3806056082248688},{"id":"https://openalex.org/C94375191","wikidata":"https://www.wikidata.org/wiki/Q11205","display_name":"Arithmetic","level":1,"score":0.3638184070587158},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.24812227487564087},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.22003492712974548}],"mesh":[],"locations_count":5,"locations":[{"id":"doi:10.1145/3375395.3387666","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3375395.3387666","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 39th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","raw_type":"proceedings-article"},{"id":"pmh:oai:iris.uniroma1.it:11573/1474734","is_oa":true,"landing_page_url":"http://hdl.handle.net/11573/1474734","pdf_url":"https://iris.uniroma1.it/bitstream/11573/1474734/4/Console_Postprint_Queries-with-Arithmetic_2020.pdf.pdf","source":{"id":"https://openalex.org/S4377196107","display_name":"IRIS Research product catalog (Sapienza University of Rome)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"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":null,"raw_type":"info:eu-repo/semantics/conferenceObject"},{"id":"pmh:oai:pure.ed.ac.uk:publications/ab489c59-6f52-4b57-add1-481ea8b8c0f3","is_oa":true,"landing_page_url":"http://hdl.handle.net/20.500.11820/ab489c59-6f52-4b57-add1-481ea8b8c0f3","pdf_url":"https://www.pure.ed.ac.uk/ws/files/156897401/Queries_with_Arithmetic_CONSOLE_DOA08032020_AFV.pdf","source":{"id":"https://openalex.org/S4406922455","display_name":"Edinburgh Research Explorer","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":""},{"id":"pmh:oai:pure.ed.ac.uk:publications/ab489c59-6f52-4b57-add1-481ea8b8c0f3","is_oa":true,"landing_page_url":"https://www.research.ed.ac.uk/en/publications/ab489c59-6f52-4b57-add1-481ea8b8c0f3","pdf_url":"https://www.pure.ed.ac.uk/ws/files/156897401/Queries_with_Arithmetic_CONSOLE_DOA08032020_AFV.pdf","source":{"id":"https://openalex.org/S4306400321","display_name":"Edinburgh Research Explorer (University of Edinburgh)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I98677209","host_organization_name":"University of Edinburgh","host_organization_lineage":["https://openalex.org/I98677209"],"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":"Console, M, Hofer, M & Libkin, L 2020, Queries with Arithmetic on Incomplete Databases. in Proceedings of the 39th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems. New York, NY, USA, pp. 179\u2013189, 2020 ACM SIGMOD/PODS International Conference on Management of Data, Portland, Oregon, United States, 14/06/20. https://doi.org/10.1145/3375395.3387666","raw_type":"contributionToPeriodical"},{"id":"pmh:oai:HAL:hal-03127717v1","is_oa":true,"landing_page_url":"https://inria.hal.science/hal-03127717","pdf_url":null,"source":{"id":"https://openalex.org/S4306402512","display_name":"HAL (Le Centre pour la Communication Scientifique Directe)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1294671590","host_organization_name":"Centre National de la Recherche Scientifique","host_organization_lineage":["https://openalex.org/I1294671590"],"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":"SIGMOD/PODS 2020 : International Conference on Management of Data, Jun 2020, Portland / Virtual, United States. pp.179-189, ⟨10.1145/3375395.3387666⟩","raw_type":"info:eu-repo/semantics/conferenceObject"}],"best_oa_location":{"id":"pmh:oai:iris.uniroma1.it:11573/1474734","is_oa":true,"landing_page_url":"http://hdl.handle.net/11573/1474734","pdf_url":"https://iris.uniroma1.it/bitstream/11573/1474734/4/Console_Postprint_Queries-with-Arithmetic_2020.pdf.pdf","source":{"id":"https://openalex.org/S4377196107","display_name":"IRIS Research product catalog (Sapienza University of Rome)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"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":null,"raw_type":"info:eu-repo/semantics/conferenceObject"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G3829625337","display_name":null,"funder_award_id":"S003800","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"},{"id":"https://openalex.org/G4250056808","display_name":null,"funder_award_id":"EP/N023056/1,EP/M025268/1,EP/S003800/1","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"},{"id":"https://openalex.org/G4378070110","display_name":null,"funder_award_id":"N023056","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"},{"id":"https://openalex.org/G53695486","display_name":null,"funder_award_id":"EP/N023056/1","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"},{"id":"https://openalex.org/G5458651130","display_name":null,"funder_award_id":"M025268","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"}],"funders":[{"id":"https://openalex.org/F4320331438","display_name":"Universit\u00e9 de Paris","ror":null},{"id":"https://openalex.org/F4320334627","display_name":"Engineering and Physical Sciences Research Council","ror":"https://ror.org/0439y7842"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3028872147.pdf","grobid_xml":"https://content.openalex.org/works/W3028872147.grobid-xml"},"referenced_works_count":39,"referenced_works":["https://openalex.org/W88577015","https://openalex.org/W1522991784","https://openalex.org/W1779256329","https://openalex.org/W1985239372","https://openalex.org/W1990391007","https://openalex.org/W1992673035","https://openalex.org/W1998510030","https://openalex.org/W2006367173","https://openalex.org/W2028864278","https://openalex.org/W2031639195","https://openalex.org/W2048617325","https://openalex.org/W2059819407","https://openalex.org/W2097244109","https://openalex.org/W2099367286","https://openalex.org/W2115826669","https://openalex.org/W2116631029","https://openalex.org/W2120436863","https://openalex.org/W2160312889","https://openalex.org/W2160983447","https://openalex.org/W2162052349","https://openalex.org/W2169083729","https://openalex.org/W2207251955","https://openalex.org/W2297697128","https://openalex.org/W2304387544","https://openalex.org/W2334621812","https://openalex.org/W2338322935","https://openalex.org/W2411138143","https://openalex.org/W2611804663","https://openalex.org/W2810687134","https://openalex.org/W2888359544","https://openalex.org/W2911521611","https://openalex.org/W2948174565","https://openalex.org/W3013448635","https://openalex.org/W3122481131","https://openalex.org/W4211101708","https://openalex.org/W4246140018","https://openalex.org/W4255327858","https://openalex.org/W4300550233","https://openalex.org/W4300564796"],"related_works":["https://openalex.org/W584886505","https://openalex.org/W613682957","https://openalex.org/W3162115094","https://openalex.org/W2188578519","https://openalex.org/W1501195592","https://openalex.org/W1665257821","https://openalex.org/W3009893816","https://openalex.org/W2369206174","https://openalex.org/W2990952607","https://openalex.org/W2513523087"],"abstract_inverted_index":{"The":[0],"standard":[1],"notion":[2,41],"of":[3,11,17,25,42],"query":[4],"answering":[5],"over":[6],"incomplete":[7,19],"database":[8],"is":[9,21],"that":[10,49],"certain":[12,43],"answers,":[13],"guaranteeing":[14],"correctness":[15],"regardless":[16],"how":[18],"data":[20,59],"interpreted.":[22],"In":[23],"majority":[24],"real-life":[26],"databases,":[27],"relations":[28],"have":[29],"numerical":[30,62],"columns":[31],"and":[32,36],"queries":[33],"use":[34],"arithmetic":[35],"comparisons.":[37],"Even":[38],"though":[39],"the":[40],"answers":[44],"still":[45],"applies,":[46],"we":[47],"explain":[48],"it":[50],"becomes":[51],"much":[52],"more":[53],"problematic":[54],"in":[55,61],"situations":[56],"when":[57],"missing":[58],"occurs":[60],"columns.":[63]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":2}],"updated_date":"2026-07-12T07:33:03.550515","created_date":"2020-06-05T00:00:00"}