{"id":"https://openalex.org/W2026303066","doi":"https://doi.org/10.1016/s0306-4379(01)00025-4","title":"Detecting redundant materialized views in data warehouse evolution","display_name":"Detecting redundant materialized views in data warehouse evolution","publication_year":2001,"publication_date":"2001-07-01","ids":{"openalex":"https://openalex.org/W2026303066","doi":"https://doi.org/10.1016/s0306-4379(01)00025-4","mag":"2026303066"},"language":"en","primary_location":{"id":"doi:10.1016/s0306-4379(01)00025-4","is_oa":false,"landing_page_url":"https://doi.org/10.1016/s0306-4379(01)00025-4","pdf_url":null,"source":{"id":"https://openalex.org/S193006928","display_name":"Information Systems","issn_l":"0306-4379","issn":["0306-4379","1873-6076"],"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":"Information Systems","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://doi.org/10.1016/S0306-4379(01)00025-4","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5043809604","display_name":"Dimitri Theodoratos","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":"Dimitri Theodoratos","raw_affiliation_strings":["Department of Electrical and Computer Engineering, National Technical University of Athens, Zographou 157 73, Athens, Greece"],"affiliations":[{"raw_affiliation_string":"Department of Electrical and Computer Engineering, National Technical University of Athens, Zographou 157 73, Athens, Greece","institution_ids":["https://openalex.org/I174458059"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5043809604"],"corresponding_institution_ids":["https://openalex.org/I174458059"],"apc_list":{"value":2970,"currency":"USD","value_usd":2970},"apc_paid":null,"fwci":1.0052,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.83654224,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"26","issue":"5","first_page":"363","last_page":"381"},"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.9991999864578247,"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.9991999864578247,"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.9980000257492065,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9919000267982483,"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/materialized-view","display_name":"Materialized view","score":0.9712370038032532},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.8911992311477661},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8298211097717285},{"id":"https://openalex.org/keywords/warehouse","display_name":"Warehouse","score":0.6318314671516418},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6232767701148987},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3858484625816345},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3259028196334839},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.11874234676361084},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.09281522035598755},{"id":"https://openalex.org/keywords/business","display_name":"Business","score":0.06357195973396301}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.9712370038032532},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8911992311477661},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8298211097717285},{"id":"https://openalex.org/C50416739","wikidata":"https://www.wikidata.org/wiki/Q181623","display_name":"Warehouse","level":2,"score":0.6318314671516418},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6232767701148987},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3858484625816345},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3259028196334839},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.11874234676361084},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.09281522035598755},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.06357195973396301},{"id":"https://openalex.org/C162853370","wikidata":"https://www.wikidata.org/wiki/Q39809","display_name":"Marketing","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1016/s0306-4379(01)00025-4","is_oa":false,"landing_page_url":"https://doi.org/10.1016/s0306-4379(01)00025-4","pdf_url":null,"source":{"id":"https://openalex.org/S193006928","display_name":"Information Systems","issn_l":"0306-4379","issn":["0306-4379","1873-6076"],"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":"Information Systems","raw_type":"journal-article"},{"id":"pmh:oai:dspace.lib.ntua.gr:123456789/14020","is_oa":true,"landing_page_url":"http://doi.org/10.1016/S0306-4379(01)00025-4","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":"Information Systems","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"pmh:oai:dspace.lib.ntua.gr:123456789/14020","is_oa":true,"landing_page_url":"http://doi.org/10.1016/S0306-4379(01)00025-4","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":"Information Systems","raw_type":"info:eu-repo/semantics/article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":55,"referenced_works":["https://openalex.org/W128824620","https://openalex.org/W187851124","https://openalex.org/W253264081","https://openalex.org/W1482520531","https://openalex.org/W1483342375","https://openalex.org/W1488870204","https://openalex.org/W1515943552","https://openalex.org/W1520432709","https://openalex.org/W1523728030","https://openalex.org/W1527733826","https://openalex.org/W1540277706","https://openalex.org/W1558617513","https://openalex.org/W1581805425","https://openalex.org/W1594502603","https://openalex.org/W1606751452","https://openalex.org/W1812691494","https://openalex.org/W1943411325","https://openalex.org/W1968210840","https://openalex.org/W1969450725","https://openalex.org/W1973382888","https://openalex.org/W1975733288","https://openalex.org/W1995999642","https://openalex.org/W2006426459","https://openalex.org/W2008907861","https://openalex.org/W2012670464","https://openalex.org/W2030148067","https://openalex.org/W2047809518","https://openalex.org/W2055343463","https://openalex.org/W2058978608","https://openalex.org/W2069811933","https://openalex.org/W2108971776","https://openalex.org/W2114712170","https://openalex.org/W2116476518","https://openalex.org/W2117242988","https://openalex.org/W2122265344","https://openalex.org/W2131165411","https://openalex.org/W2136195851","https://openalex.org/W2143401113","https://openalex.org/W2160770337","https://openalex.org/W2160825121","https://openalex.org/W2163764339","https://openalex.org/W2164049396","https://openalex.org/W2164923618","https://openalex.org/W2165456041","https://openalex.org/W2170515491","https://openalex.org/W3124865645","https://openalex.org/W4205167958","https://openalex.org/W4255826646","https://openalex.org/W6600648412","https://openalex.org/W6602704705","https://openalex.org/W6604208927","https://openalex.org/W6631175622","https://openalex.org/W6632266593","https://openalex.org/W6635400699","https://openalex.org/W6640690195"],"related_works":["https://openalex.org/W2162280381","https://openalex.org/W2185691065","https://openalex.org/W2363712075","https://openalex.org/W2383931363","https://openalex.org/W2348265434","https://openalex.org/W2108498730","https://openalex.org/W2142569422","https://openalex.org/W2087983779","https://openalex.org/W152305489","https://openalex.org/W1635132392"],"abstract_inverted_index":null,"counts_by_year":[{"year":2018,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-03-20T23:20:44.827607","created_date":"2025-10-10T00:00:00"}