{"id":"https://openalex.org/W1604952717","doi":null,"title":"Generalized Projections: A Powerful Approach To Aggregation","display_name":"Generalized Projections: A Powerful Approach To Aggregation","alternate_titles":[],"publication_year":1995,"publication_date":"1995-01-01","ids":{"openalex":"https://openalex.org/W1604952717","mag":"1604952717"},"language":"en","primary_location":{"id":"mag:1604952717","doi":null,"is_oa":false,"landing_page_url":"http://ilpubs.stanford.edu:8090/100/","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W1604952717"],"child_works_count":0,"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/A5100769066","display_name":"Abhishek Gupta","orcid":"https://orcid.org/0000-0001-8559-0510","observed_orcids":["https://orcid.org/0000-0001-8559-0510"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Abhishek Gupta","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0001-8559-0510","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":4.8929,"has_fulltext":false,"cited_by_count":35,"citation_normalized_percentile":{"value":0.94278523,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":88,"max":97},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9984999895095825,"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.9984999895095825,"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.0003000000142492354,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":9.999999747378752e-05,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/generalized-projections","display_name":"generalized projections","score":1.0},{"id":"https://openalex.org/keywords/aggregate-queries","display_name":"aggregate queries","score":0.7739999890327454},{"id":"https://openalex.org/keywords/group-by","display_name":"GROUP BY","score":0.6079999804496765},{"id":"https://openalex.org/keywords/query-reformulation","display_name":"query rewriting","score":0.6370000243186951},{"id":"https://openalex.org/keywords/query-optimization","display_name":"query optimization","score":0.7670000195503235},{"id":"https://openalex.org/keywords/materialized-views","display_name":"materialized views","score":0.8500000238418579},{"id":"https://openalex.org/keywords/data-warehousing","display_name":"data warehousing","score":0.9440000057220459},{"id":"https://openalex.org/keywords/sql-queries","display_name":"SQL queries","score":0.5230000019073486}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7741730213165283},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.762180745601654},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.6629051566123962},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.6431108713150024},{"id":"https://openalex.org/C2778029271","wikidata":"https://www.wikidata.org/wiki/Q5421931","display_name":"Extension (predicate logic)","level":2,"score":0.606558084487915},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5588264465332031},{"id":"https://openalex.org/C57493831","wikidata":"https://www.wikidata.org/wiki/Q3134666","display_name":"Projection (relational algebra)","level":2,"score":0.551234245300293},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.5196807980537415},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5133258700370789},{"id":"https://openalex.org/C42058472","wikidata":"https://www.wikidata.org/wiki/Q810214","display_name":"Base (topology)","level":2,"score":0.4169473350048065},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3916045129299164},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3772469162940979},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3768329620361328},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3700762093067169},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.2618340253829956},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.24622845649719238},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.1372048258781433},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.12954190373420715},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.07168245315551758},{"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},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","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}],"mesh":[],"locations_count":2,"locations":[{"id":"mag:1604952717","doi":null,"is_oa":false,"landing_page_url":"http://ilpubs.stanford.edu:8090/100/","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.53.2923","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.53.2923","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www-db.stanford.edu/pub/papers/GP2.ps","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W1488870204","https://openalex.org/W52665958","https://openalex.org/W7097655104","https://openalex.org/W7097959485","https://openalex.org/W2092532991","https://openalex.org/W1527733826","https://openalex.org/W2899410584","https://openalex.org/W7095235160","https://openalex.org/W2353028187","https://openalex.org/W2114543211"],"abstract_inverted_index":{"In":[0],"this":[1],"paper":[2],"we":[3,33],"introduce":[4],"generalized":[5],"projections":[6,25,46],"(GPs),":[7],"an":[8,100],"extension":[9],"of":[10,83,126],"duplicate-eliminating":[11],"projections,":[12],"that":[13,43,67],"capture":[14],"aggregations,":[15],"groupbys,":[16],"conventional":[17],"projection":[18],"with":[19],"duplicate":[20],"elimination":[21],"(distinct),":[22],"and":[23,37,56,69,91],"duplicate-preserving":[24],"in":[26,75,94],"a":[27,88],"common":[28],"unified":[29],"framework.":[30],"Using":[31],"GPs":[32],"extend":[34,70],"well":[35],"known":[36,74],"simple":[38],"algorithms":[39,49],"for":[40,50,64,130],"SQL":[41],"queries":[42,51,66],"use":[44],"distinct":[45],"to":[47,98],"derive":[48],"using":[52,106],"aggregations":[53],"like":[54],"sum-max-min-count":[55],"avg.":[57],"We":[58,78],"develop":[59],"powerful":[60],"query":[61,102,118],"rewrite":[62,71],"rules":[63,72],"aggregate":[65,101,108],"unify":[68],"previously":[73],"the":[76,81,123],"literature.":[77],"then":[79],"illustrate":[80],"power":[82],"our":[84],"approach":[85],"by":[86],"solving":[87],"very":[89],"practical":[90],"important":[92],"problem":[93],"data":[95,114,128],"warehousing:":[96],"how":[97],"answer":[99],"about":[103],"base":[104],"tables":[105],"materialized":[107,116],"views":[109],"(summary":[110],"tables).":[111],"Keywords:":[112],"aggregation,":[113],"warehousing,":[115],"views,":[117],"optimization":[119],"1":[120],"Introduction":[121],"With":[122],"growing":[124],"number":[125],"large":[127],"warehouses":[129],"decision":[131],"support":[132],"applications,":[133],"effi...":[134]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W1604952717","counts_by_year":[{"year":2020,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":4}],"updated_date":"2026-11-17T12:49:18.490984","created_date":"2016-06-24T00:00:00"}
