{"id":"https://openalex.org/W1506636467","doi":"https://doi.org/10.1007/11408079_48","title":"Designing and Using Views to Improve Performance of Aggregate Queries (Extended Abstract)","display_name":"Designing and Using Views to Improve Performance of Aggregate Queries (Extended Abstract)","publication_year":2005,"publication_date":"2005-01-01","ids":{"openalex":"https://openalex.org/W1506636467","doi":"https://doi.org/10.1007/11408079_48","mag":"1506636467"},"language":"en","primary_location":{"id":"doi:10.1007/11408079_48","is_oa":false,"landing_page_url":"https://doi.org/10.1007/11408079_48","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},"type":"book-chapter","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://doi.org/10.1007/11408079_48","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5088568415","display_name":"Foto Afrati","orcid":null},"institutions":[{"id":"https://openalex.org/I174458059","display_name":"National Technical University of Athens","ror":"https://ror.org/03cx6bg69","country_code":"GR","type":"education","lineage":["https://openalex.org/I174458059"]}],"countries":["GR"],"is_corresponding":true,"raw_author_name":"Foto Afrati","raw_affiliation_strings":["Computer Science Division, National Technical University of Athens, Athens, Greece"],"affiliations":[{"raw_affiliation_string":"Computer Science Division, National Technical University of Athens, Athens, Greece","institution_ids":["https://openalex.org/I174458059"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5078910758","display_name":"Rada Chirkova","orcid":"https://orcid.org/0000-0003-4249-9690"},"institutions":[{"id":"https://openalex.org/I137902535","display_name":"North Carolina State University","ror":"https://ror.org/04tj63d06","country_code":"US","type":"education","lineage":["https://openalex.org/I137902535"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Rada Chirkova","raw_affiliation_strings":["Computer Science Department, North Carolina State University, Raleigh, USA","Comput. Sci. Dept., North Carolina State Univ., Raleigh, NC"],"affiliations":[{"raw_affiliation_string":"Computer Science Department, North Carolina State University, Raleigh, USA","institution_ids":["https://openalex.org/I137902535"]},{"raw_affiliation_string":"Comput. Sci. Dept., North Carolina State Univ., Raleigh, NC","institution_ids":["https://openalex.org/I137902535"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5019737946","display_name":"Shalu Gupta","orcid":null},"institutions":[{"id":"https://openalex.org/I137902535","display_name":"North Carolina State University","ror":"https://ror.org/04tj63d06","country_code":"US","type":"education","lineage":["https://openalex.org/I137902535"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Shalu Gupta","raw_affiliation_strings":["Computer Science Department, North Carolina State University, Raleigh, USA","Comput. Sci. Dept., North Carolina State Univ., Raleigh, NC"],"affiliations":[{"raw_affiliation_string":"Computer Science Department, North Carolina State University, Raleigh, USA","institution_ids":["https://openalex.org/I137902535"]},{"raw_affiliation_string":"Comput. Sci. Dept., North Carolina State Univ., Raleigh, NC","institution_ids":["https://openalex.org/I137902535"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5057692965","display_name":"Charles Loftis","orcid":"https://orcid.org/0000-0002-9678-1539"},"institutions":[{"id":"https://openalex.org/I137902535","display_name":"North Carolina State University","ror":"https://ror.org/04tj63d06","country_code":"US","type":"education","lineage":["https://openalex.org/I137902535"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Charles Loftis","raw_affiliation_strings":["Computer Science Department, North Carolina State University, Raleigh, USA","Comput. Sci. Dept., North Carolina State Univ., Raleigh, NC"],"affiliations":[{"raw_affiliation_string":"Computer Science Department, North Carolina State University, Raleigh, USA","institution_ids":["https://openalex.org/I137902535"]},{"raw_affiliation_string":"Comput. Sci. Dept., North Carolina State Univ., Raleigh, NC","institution_ids":["https://openalex.org/I137902535"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5088568415"],"corresponding_institution_ids":["https://openalex.org/I174458059"],"apc_list":{"value":5000,"currency":"EUR","value_usd":5392},"apc_paid":null,"fwci":0.3296,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.5508348,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"548","last_page":"554"},"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.9995999932289124,"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.9952999949455261,"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.9177911281585693},{"id":"https://openalex.org/keywords/novelty","display_name":"Novelty","score":0.740256667137146},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.6588351726531982},{"id":"https://openalex.org/keywords/rewriting","display_name":"Rewriting","score":0.6059163212776184},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6056589484214783},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.554378092288971},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.5369792580604553},{"id":"https://openalex.org/keywords/focus","display_name":"Focus (optics)","score":0.5298739671707153},{"id":"https://openalex.org/keywords/architecture","display_name":"Architecture","score":0.5028192400932312},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.48351767659187317},{"id":"https://openalex.org/keywords/point","display_name":"Point (geometry)","score":0.4650856852531433},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.44680750370025635},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.4118180274963379},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4094647467136383},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.39731642603874207},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.3476855158805847},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.1276470422744751},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.098971426486969}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9177911281585693},{"id":"https://openalex.org/C2778738651","wikidata":"https://www.wikidata.org/wiki/Q16546687","display_name":"Novelty","level":2,"score":0.740256667137146},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.6588351726531982},{"id":"https://openalex.org/C154690210","wikidata":"https://www.wikidata.org/wiki/Q1668499","display_name":"Rewriting","level":2,"score":0.6059163212776184},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6056589484214783},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.554378092288971},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.5369792580604553},{"id":"https://openalex.org/C192209626","wikidata":"https://www.wikidata.org/wiki/Q190909","display_name":"Focus (optics)","level":2,"score":0.5298739671707153},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.5028192400932312},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.48351767659187317},{"id":"https://openalex.org/C28719098","wikidata":"https://www.wikidata.org/wiki/Q44946","display_name":"Point (geometry)","level":2,"score":0.4650856852531433},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.44680750370025635},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.4118180274963379},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4094647467136383},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.39731642603874207},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.3476855158805847},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.1276470422744751},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.098971426486969},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0},{"id":"https://openalex.org/C27206212","wikidata":"https://www.wikidata.org/wiki/Q34178","display_name":"Theology","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","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},{"id":"https://openalex.org/C120665830","wikidata":"https://www.wikidata.org/wiki/Q14620","display_name":"Optics","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/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1007/11408079_48","is_oa":false,"landing_page_url":"https://doi.org/10.1007/11408079_48","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},{"id":"pmh:oai:dspace.lib.ntua.gr:123456789/31293","is_oa":true,"landing_page_url":"http://doi.org/10.1007/11408079_48","pdf_url":null,"source":{"id":"https://openalex.org/S4377196837","display_name":"DSpace - NTUA (National Technical University of Athens)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I174458059","host_organization_name":"National Technical University of Athens","host_organization_lineage":["https://openalex.org/I174458059"],"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":"Lecture Notes in Computer Science","raw_type":"info:eu-repo/semantics/conferenceObject"}],"best_oa_location":{"id":"pmh:oai:dspace.lib.ntua.gr:123456789/31293","is_oa":true,"landing_page_url":"http://doi.org/10.1007/11408079_48","pdf_url":null,"source":{"id":"https://openalex.org/S4377196837","display_name":"DSpace - NTUA (National Technical University of Athens)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I174458059","host_organization_name":"National Technical University of Athens","host_organization_lineage":["https://openalex.org/I174458059"],"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":"Lecture Notes in Computer Science","raw_type":"info:eu-repo/semantics/conferenceObject"},"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","score":0.4300000071525574,"id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":19,"referenced_works":["https://openalex.org/W38346608","https://openalex.org/W39577230","https://openalex.org/W1488870204","https://openalex.org/W1527733826","https://openalex.org/W1562988957","https://openalex.org/W1977786400","https://openalex.org/W1995999642","https://openalex.org/W2072764742","https://openalex.org/W2079590017","https://openalex.org/W2103201239","https://openalex.org/W2113888164","https://openalex.org/W2122816893","https://openalex.org/W2143401113","https://openalex.org/W2150950420","https://openalex.org/W2152191782","https://openalex.org/W2160770337","https://openalex.org/W2251484078","https://openalex.org/W2470894962","https://openalex.org/W2896340204"],"related_works":["https://openalex.org/W1988774479","https://openalex.org/W2123931473","https://openalex.org/W1799555191","https://openalex.org/W3012397820","https://openalex.org/W2406556739","https://openalex.org/W2186703450","https://openalex.org/W175663584","https://openalex.org/W3125756434","https://openalex.org/W2970853428","https://openalex.org/W4381740310"],"abstract_inverted_index":null,"counts_by_year":[],"updated_date":"2026-03-20T23:20:44.827607","created_date":"2025-10-10T00:00:00"}