{"id":"https://openalex.org/W2397572704","doi":"https://doi.org/10.1016/s0022-0000(02)00033-8","title":"On the content of materialized aggregate views","display_name":"On the content of materialized aggregate views","publication_year":2003,"publication_date":"2003-02-01","ids":{"openalex":"https://openalex.org/W2397572704","doi":"https://doi.org/10.1016/s0022-0000(02)00033-8","mag":"2397572704"},"language":"en","primary_location":{"id":"doi:10.1016/s0022-0000(02)00033-8","is_oa":false,"landing_page_url":"https://doi.org/10.1016/s0022-0000(02)00033-8","pdf_url":null,"source":{"id":"https://openalex.org/S141020589","display_name":"Journal of Computer and System Sciences","issn_l":"0022-0000","issn":["0022-0000","1090-2724"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Computer and System Sciences","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://inria.hal.science/inria-00115471","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5065309966","display_name":"St\u00e9phane Grumbach","orcid":"https://orcid.org/0000-0003-2093-2262"},"institutions":[{"id":"https://openalex.org/I1326498283","display_name":"Institut national de recherche en sciences et technologies du num\u00e9rique","ror":"https://ror.org/02kvxyf05","country_code":"FR","type":"government","lineage":["https://openalex.org/I1326498283"]}],"countries":["FR"],"is_corresponding":true,"raw_author_name":"St\u00e9phane Grumbach","raw_affiliation_strings":["INRIA, Rocquencourt BP 105, 78153 Le Chesnay, France","INRIA Rocquencourt - BP 105, 78153 Le Chesnay (France)"],"affiliations":[{"raw_affiliation_string":"INRIA, Rocquencourt BP 105, 78153 Le Chesnay, France","institution_ids":["https://openalex.org/I1326498283"]},{"raw_affiliation_string":"INRIA Rocquencourt - BP 105, 78153 Le Chesnay (France)","institution_ids":["https://openalex.org/I1326498283"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5029243007","display_name":"Leonardo Tininini","orcid":null},"institutions":[{"id":"https://openalex.org/I1341049462","display_name":"Istituto Nazionale di Statistica","ror":"https://ror.org/05a5k9h08","country_code":"IT","type":"facility","lineage":["https://openalex.org/I1341049462"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Leonardo Tininini","raw_affiliation_strings":["CNR-IASI, viale Manzoni 30, 00185 Roma, Italy and ISTAT, via Adolfo Rav\u00e0 150, 00142 Roma, Italy"],"affiliations":[{"raw_affiliation_string":"CNR-IASI, viale Manzoni 30, 00185 Roma, Italy and ISTAT, via Adolfo Rav\u00e0 150, 00142 Roma, Italy","institution_ids":["https://openalex.org/I1341049462"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5065309966"],"corresponding_institution_ids":["https://openalex.org/I1326498283"],"apc_list":{"value":2520,"currency":"USD","value_usd":2520},"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.38344758,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"66","issue":"1","first_page":"133","last_page":"168"},"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.9973999857902527,"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.9973999857902527,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9879000186920166,"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/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.9843000173568726,"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/materialized-view","display_name":"Materialized view","score":0.9030418395996094},{"id":"https://openalex.org/keywords/rewriting","display_name":"Rewriting","score":0.7838109731674194},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7643607258796692},{"id":"https://openalex.org/keywords/completeness","display_name":"Completeness (order theory)","score":0.719878077507019},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.6133105158805847},{"id":"https://openalex.org/keywords/focus","display_name":"Focus (optics)","score":0.5764017701148987},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.5193684697151184},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5137637853622437},{"id":"https://openalex.org/keywords/simple","display_name":"Simple (philosophy)","score":0.5060474276542664},{"id":"https://openalex.org/keywords/relation","display_name":"Relation (database)","score":0.48483121395111084},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4675523042678833},{"id":"https://openalex.org/keywords/point","display_name":"Point (geometry)","score":0.44210106134414673},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.43741580843925476},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.38792240619659424},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3336403965950012},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.29634374380111694},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2493901252746582},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.19622144103050232},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.16444477438926697},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.11313354969024658}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.9030418395996094},{"id":"https://openalex.org/C154690210","wikidata":"https://www.wikidata.org/wiki/Q1668499","display_name":"Rewriting","level":2,"score":0.7838109731674194},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7643607258796692},{"id":"https://openalex.org/C17231256","wikidata":"https://www.wikidata.org/wiki/Q5156540","display_name":"Completeness (order theory)","level":2,"score":0.719878077507019},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.6133105158805847},{"id":"https://openalex.org/C192209626","wikidata":"https://www.wikidata.org/wiki/Q190909","display_name":"Focus (optics)","level":2,"score":0.5764017701148987},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.5193684697151184},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5137637853622437},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.5060474276542664},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.48483121395111084},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4675523042678833},{"id":"https://openalex.org/C28719098","wikidata":"https://www.wikidata.org/wiki/Q44946","display_name":"Point (geometry)","level":2,"score":0.44210106134414673},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.43741580843925476},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.38792240619659424},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3336403965950012},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.29634374380111694},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2493901252746582},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.19622144103050232},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.16444477438926697},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.11313354969024658},{"id":"https://openalex.org/C120665830","wikidata":"https://www.wikidata.org/wiki/Q14620","display_name":"Optics","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/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","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/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/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.0}],"mesh":[],"locations_count":6,"locations":[{"id":"doi:10.1016/s0022-0000(02)00033-8","is_oa":false,"landing_page_url":"https://doi.org/10.1016/s0022-0000(02)00033-8","pdf_url":null,"source":{"id":"https://openalex.org/S141020589","display_name":"Journal of Computer and System Sciences","issn_l":"0022-0000","issn":["0022-0000","1090-2724"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Computer and System Sciences","raw_type":"journal-article"},{"id":"pmh:hdl:10068/314548","is_oa":false,"landing_page_url":"http://hdl.handle.net/10068/314548","pdf_url":null,"source":{"id":"https://openalex.org/S4377196900","display_name":"OpenGrey (Institut de l'Information Scientifique et Technique)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1295345811","host_organization_name":"Institut de l'Information Scientifique et Technique","host_organization_lineage":["https://openalex.org/I1295345811"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Y - Progress report"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.32.6017","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.32.6017","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"ftp://ftp.inria.fr/INRIA/Projects/verso/VersoReport-178.ps.gz","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.95.9340","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.95.9340","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.sigmod.org/pods/proc00/papers/grumbach.pdf","raw_type":"text"},{"id":"pmh:oai:HAL:inria-00115471v1","is_oa":true,"landing_page_url":"https://inria.hal.science/inria-00115471","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":"Journal of Computer and System Sciences, 2003, 66 (1), pp.133-168","raw_type":"Journal articles"},{"id":"mag:2397572704","is_oa":false,"landing_page_url":"https://dblp.uni-trier.de/db/conf/sebd/sebd2000.html#GrumbachT00","pdf_url":null,"source":{"id":"https://openalex.org/S4306529400","display_name":"SEBD","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":"SEBD","raw_type":null}],"best_oa_location":{"id":"pmh:oai:HAL:inria-00115471v1","is_oa":true,"landing_page_url":"https://inria.hal.science/inria-00115471","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":"Journal of Computer and System Sciences, 2003, 66 (1), pp.133-168","raw_type":"Journal articles"},"sustainable_development_goals":[{"display_name":"Decent work and economic growth","id":"https://metadata.un.org/sdg/8","score":0.5}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":44,"referenced_works":["https://openalex.org/W170467795","https://openalex.org/W1480292905","https://openalex.org/W1520432709","https://openalex.org/W1684286378","https://openalex.org/W1952678003","https://openalex.org/W1970607865","https://openalex.org/W1982945449","https://openalex.org/W1995332844","https://openalex.org/W1995999642","https://openalex.org/W2004405116","https://openalex.org/W2005992727","https://openalex.org/W2017740323","https://openalex.org/W2019016644","https://openalex.org/W2027763082","https://openalex.org/W2059894732","https://openalex.org/W2072764742","https://openalex.org/W2079590017","https://openalex.org/W2081348961","https://openalex.org/W2091243445","https://openalex.org/W2093480367","https://openalex.org/W2094394144","https://openalex.org/W2095263945","https://openalex.org/W2110463644","https://openalex.org/W2111967617","https://openalex.org/W2113888164","https://openalex.org/W2114712170","https://openalex.org/W2133978845","https://openalex.org/W2134217480","https://openalex.org/W2134791164","https://openalex.org/W2143401113","https://openalex.org/W2155813815","https://openalex.org/W2160133521","https://openalex.org/W2160770337","https://openalex.org/W2160983447","https://openalex.org/W2162587626","https://openalex.org/W2171492933","https://openalex.org/W2950416404","https://openalex.org/W4230230708","https://openalex.org/W6600506127","https://openalex.org/W6601519247","https://openalex.org/W6603056600","https://openalex.org/W6604208927","https://openalex.org/W6631175622","https://openalex.org/W6634150208"],"related_works":["https://openalex.org/W2646887492","https://openalex.org/W2021777732","https://openalex.org/W2020300116","https://openalex.org/W393999317","https://openalex.org/W1541621396","https://openalex.org/W1767135503","https://openalex.org/W2167445567","https://openalex.org/W1964202341","https://openalex.org/W2062062112","https://openalex.org/W2361457163","https://openalex.org/W3031902751","https://openalex.org/W2136658073","https://openalex.org/W2293571614","https://openalex.org/W2045141511","https://openalex.org/W189428209","https://openalex.org/W2016071357","https://openalex.org/W1994840586","https://openalex.org/W1013370155","https://openalex.org/W1998152264","https://openalex.org/W1995332844"],"abstract_inverted_index":null,"counts_by_year":[],"updated_date":"2026-03-10T14:07:55.174380","created_date":"2025-10-10T00:00:00"}