{"id":"https://openalex.org/W1488870204","doi":null,"title":"Aggregate-Query Processing in Data Warehousing Environments","display_name":"Aggregate-Query Processing in Data Warehousing Environments","publication_year":1995,"publication_date":"1995-09-11","ids":{"openalex":"https://openalex.org/W1488870204","mag":"1488870204"},"language":"en","primary_location":{"id":"pmh:oai:CiteSeerX.psu:10.1.1.41.8228","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.41.8228","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cise.ufl.edu/~jgreenbe/research/../papers/32.pdf","raw_type":"text"},"volume":null,"type":"article","is_traditional":true,"indexed_in":[],"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/A5007994419","display_name":"Ashish Gupta","orcid":"https://orcid.org/0000-0002-1844-7834","observed_orcids":["https://orcid.org/0000-0002-1844-7834","https://orcid.org/0000-0002-0614-3542","https://orcid.org/0009-0003-1127-6272"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ashish Gupta","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0002-1844-7834","affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5061800788","display_name":"Venky Harinarayan","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Venky Harinarayan","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5057412835","display_name":"Dallan Quass","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Dallan Quass","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":28.4301,"has_fulltext":false,"cited_by_count":295,"citation_normalized_percentile":{"value":0.99724429,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":87,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"358","last_page":"369"},"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.9980000257492065,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.9980000257492065,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.00019999999494757503,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T11891","display_name":"Big Data and Business Intelligence","score":0.00019999999494757503,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/generalized-projections","display_name":"generalized projections","score":0.9629999995231628},{"id":"https://openalex.org/keywords/group-by","display_name":"GROUP BY","score":0.43700000643730164},{"id":"https://openalex.org/keywords/data-warehousing","display_name":"data warehousing","score":0.8709999918937683},{"id":"https://openalex.org/keywords/summary-tables","display_name":"summary tables","score":0.503000020980835}],"concepts":[{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.8267126083374023},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7875578999519348},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.7346127033233643},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.613277018070221},{"id":"https://openalex.org/C2778029271","wikidata":"https://www.wikidata.org/wiki/Q5421931","display_name":"Extension (predicate logic)","level":2,"score":0.5956553816795349},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5877718925476074},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.5503222942352295},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.48916199803352356},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4801177978515625},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.44450777769088745},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.4416273832321167},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.43087005615234375},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.4213537275791168},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4152938723564148},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.4113161563873291},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.40651726722717285},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3435215353965759},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.3047405481338501},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.29306650161743164},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.15013986825942993},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.14515772461891174},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.08969318866729736},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"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/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","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}],"mesh":[],"locations_count":4,"locations":[{"id":"pmh:oai:CiteSeerX.psu:10.1.1.41.8228","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.41.8228","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cise.ufl.edu/~jgreenbe/research/../papers/32.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.45.9692","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.45.9692","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"ftp://ftp.dblab.ntua.gr/pub/dwq/vldb.ps.gz","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.62.3583","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.62.3583","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://arbor.ee.ntu.edu.tw/~chyun/dmpaper/guptaq95.pdf","raw_type":"text"},{"id":"mag:1488870204","doi":null,"is_oa":false,"landing_page_url":"http://ilpubs.stanford.edu:8090/101/","pdf_url":null,"source":{"id":"https://openalex.org/S4306421142","display_name":"Very Large Data Bases","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Very Large Data Bases","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":12,"referenced_works":["https://openalex.org/W27547836","https://openalex.org/W52665958","https://openalex.org/W99733817","https://openalex.org/W187851124","https://openalex.org/W1485145428","https://openalex.org/W1538786304","https://openalex.org/W1539088309","https://openalex.org/W1825341804","https://openalex.org/W1988504473","https://openalex.org/W2122265344","https://openalex.org/W2158237121","https://openalex.org/W2160770337"],"related_works":["https://openalex.org/W1604952717","https://openalex.org/W7097655104","https://openalex.org/W52665958","https://openalex.org/W2899410584","https://openalex.org/W7097959485","https://openalex.org/W2092532991","https://openalex.org/W1527733826","https://openalex.org/W2079590017","https://openalex.org/W2353028187","https://openalex.org/W2127403264"],"abstract_inverted_index":{"In":[0],"this":[1],"paper":[2],"we":[3,30],"introduce":[4],"generalized":[5],"pro-jections":[6,18],"(GPs),":[7],"an":[8,100],"extension":[9],"of":[10,83],"duplicate-eliminating":[11,17],"projections,":[12],"that":[13,40,67],"capture":[14],"aggre-gations,":[15],"groupbys,":[16],"(distinct),":[19],"and":[20,34,56,69,91],"duplicate-preserving":[21],"projections":[22,43],"in":[23,75,94],"a":[24,88],"common":[25],"unified":[26],"framework.":[27],"Using":[28],"GPs":[29],"extend":[31],"well":[32],"known":[33,74],"simple":[35],"algorithms":[36,46],"for":[37,47,64],"SQL":[38],"queries":[39,48,66],"use":[41],"distinct":[42],"to":[44,98],"derive":[45],"us-ing":[49],"aggregations":[50],"like":[51],"sum,":[52],"max,":[53],"min,":[54],"count,":[55],"avg.":[57],"We":[58,78],"develop":[59],"powerful":[60],"query":[61,102],"rewrite":[62,71],"rules":[63,72],"aggregate":[65,101,108],"unify":[68],"ex-tend":[70],"previously":[73],"the":[76,81],"lit-erature.":[77],"then":[79],"illustrate":[80],"power":[82],"our":[84],"approach":[85],"by":[86],"solving":[87],"very":[89],"practical":[90],"im-portant":[92],"problem":[93],"data":[95],"warehousing:":[96],"how":[97],"answer":[99],"on":[103],"base":[104],"tables":[105],"using":[106],"materialized":[107],"views":[109],"(summary":[110],"tables).":[111],"1":[112]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":5},{"year":2018,"cited_by_count":5},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":5},{"year":2014,"cited_by_count":5},{"year":2013,"cited_by_count":12},{"year":2012,"cited_by_count":7}],"updated_date":"2026-11-12T12:28:57.059296","created_date":"2016-06-24T00:00:00"}