{"id":"https://openalex.org/W2099477710","doi":"https://doi.org/10.1145/1058150.1058170","title":"Containment of aggregate queries","display_name":"Containment of aggregate queries","publication_year":2005,"publication_date":"2005-03-01","ids":{"openalex":"https://openalex.org/W2099477710","doi":"https://doi.org/10.1145/1058150.1058170","mag":"2099477710"},"language":"en","primary_location":{"id":"doi:10.1145/1058150.1058170","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1058150.1058170","pdf_url":null,"source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"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 SIGMOD Record","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/A5006348713","display_name":"Sara Cohen","orcid":"https://orcid.org/0000-0002-8482-9435"},"institutions":[{"id":"https://openalex.org/I174306211","display_name":"Technion \u2013 Israel Institute of Technology","ror":"https://ror.org/03qryx823","country_code":"IL","type":"education","lineage":["https://openalex.org/I174306211"]}],"countries":["IL"],"is_corresponding":true,"raw_author_name":"Sara Cohen","raw_affiliation_strings":["Israel Institute of Technology, Haifa, Israel","Israel Institute of Technology, Haifa (Israel)"],"affiliations":[{"raw_affiliation_string":"Israel Institute of Technology, Haifa, Israel","institution_ids":["https://openalex.org/I174306211"]},{"raw_affiliation_string":"Israel Institute of Technology, Haifa (Israel)","institution_ids":["https://openalex.org/I174306211"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5006348713"],"corresponding_institution_ids":["https://openalex.org/I174306211"],"apc_list":null,"apc_paid":null,"fwci":0.7786,"has_fulltext":false,"cited_by_count":30,"citation_normalized_percentile":{"value":0.77536557,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":"34","issue":"1","first_page":"77","last_page":"85"},"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/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9959999918937683,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8426620960235596},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.7459116578102112},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.716709315776825},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.6805857419967651},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5747698545455933},{"id":"https://openalex.org/keywords/terabyte","display_name":"Terabyte","score":0.5681486129760742},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.5316769480705261},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.42176416516304016},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.33218497037887573},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.26100796461105347},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.23749783635139465}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8426620960235596},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.7459116578102112},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.716709315776825},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.6805857419967651},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5747698545455933},{"id":"https://openalex.org/C199683683","wikidata":"https://www.wikidata.org/wiki/Q8799","display_name":"Terabyte","level":2,"score":0.5681486129760742},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.5316769480705261},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.42176416516304016},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.33218497037887573},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.26100796461105347},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.23749783635139465},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1058150.1058170","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1058150.1058170","pdf_url":null,"source":{"id":"https://openalex.org/S47508943","display_name":"ACM SIGMOD Record","issn_l":"0163-5808","issn":["0163-5808","1943-5835"],"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 SIGMOD Record","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":44,"referenced_works":["https://openalex.org/W150943429","https://openalex.org/W187851124","https://openalex.org/W1485145428","https://openalex.org/W1488870204","https://openalex.org/W1527733826","https://openalex.org/W1561908196","https://openalex.org/W1562880585","https://openalex.org/W1604794355","https://openalex.org/W1879587332","https://openalex.org/W1975733288","https://openalex.org/W1975880448","https://openalex.org/W1976392306","https://openalex.org/W1979514837","https://openalex.org/W1992681763","https://openalex.org/W1992810975","https://openalex.org/W2004405116","https://openalex.org/W2007093013","https://openalex.org/W2043778692","https://openalex.org/W2048531653","https://openalex.org/W2049233281","https://openalex.org/W2050468042","https://openalex.org/W2055586952","https://openalex.org/W2072764742","https://openalex.org/W2079590017","https://openalex.org/W2086316704","https://openalex.org/W2090337980","https://openalex.org/W2094394144","https://openalex.org/W2094806969","https://openalex.org/W2114883263","https://openalex.org/W2116940133","https://openalex.org/W2122179278","https://openalex.org/W2148706674","https://openalex.org/W2152191782","https://openalex.org/W2160099956","https://openalex.org/W2160983447","https://openalex.org/W2162621793","https://openalex.org/W2163491591","https://openalex.org/W2170515491","https://openalex.org/W2174672995","https://openalex.org/W2183013940","https://openalex.org/W2646887492","https://openalex.org/W2899410584","https://openalex.org/W4254357460","https://openalex.org/W6631453627"],"related_works":["https://openalex.org/W2378213774","https://openalex.org/W2357522326","https://openalex.org/W1988774479","https://openalex.org/W2363019959","https://openalex.org/W6138692","https://openalex.org/W1535822977","https://openalex.org/W23190051","https://openalex.org/W2367419170","https://openalex.org/W2377387014","https://openalex.org/W2381646725"],"abstract_inverted_index":{"It":[0],"is":[1],"now":[2],"common":[3],"for":[4],"databases":[5,125],"to":[6,47,58],"contain":[7],"many":[8,12,70],"gigabytes,":[9],"or":[10],"even":[11],"terabytes,":[13],"of":[14,28,38,52,102],"data.":[15,53],"Scientific":[16],"experiments":[17],"in":[18,32,82,99],"areas":[19],"such":[20,63,107],"as":[21,108],"high":[22],"energy":[23],"physics":[24],"produce":[25],"data":[26,42,71,83,117],"sets":[27],"enormous":[29],"size,":[30],"while":[31,73],"the":[33,36],"business":[34],"sector":[35],"emergence":[37],"decision-support":[39],"systems":[40,114],"and":[41,123],"warehouses":[43],"has":[44],"led":[45],"organizations":[46],"build":[48],"up":[49],"gigantic":[50],"collections":[51],"Aggregate":[54,93],"queries":[55,94],"allow":[56],"one":[57],"retrieve":[59],"concise":[60],"information":[61,113],"from":[62],"a":[64,75,100],"database,":[65],"since":[66],"they":[67],"can":[68],"cover":[69],"items":[72],"returning":[74],"small":[76],"result.":[77],"OLAP":[78],"queries,":[79],"used":[80],"extensively":[81],"warehousing,":[84],"are":[85],"based":[86],"almost":[87],"entirely":[88],"on":[89],"aggregation":[90],"[4,":[91],"16].":[92],"have":[95],"also":[96],"been":[97],"studied":[98],"variety":[101],"settings":[103],"beyond":[104],"relational":[105],"databases,":[106],"mobile":[109],"computing":[110],"[1],":[111],"global":[112],"[21],":[115],"stream":[116],"analysis":[118],"[12],":[119],"sensor":[120],"networks":[121],"[22]":[122],"constraint":[124],"[2].":[126]},"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":5},{"year":2016,"cited_by_count":1},{"year":2012,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}