{"id":"https://openalex.org/W1993369204","doi":"https://doi.org/10.4018/jdm.2007070101","title":"View Materialization in a Data Cube","display_name":"View Materialization in a Data Cube","publication_year":2007,"publication_date":"2007-07-01","ids":{"openalex":"https://openalex.org/W1993369204","doi":"https://doi.org/10.4018/jdm.2007070101","mag":"1993369204"},"language":"en","primary_location":{"id":"doi:10.4018/jdm.2007070101","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdm.2007070101","pdf_url":null,"source":{"id":"https://openalex.org/S73024538","display_name":"Journal of Database Management","issn_l":"1063-8016","issn":["1063-8016","1533-8010"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Database Management","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"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/A5102798429","display_name":"Vikas Agrawal","orcid":"https://orcid.org/0000-0003-1184-7330"},"institutions":[{"id":"https://openalex.org/I184654094","display_name":"Fayetteville State University","ror":"https://ror.org/03rj92e31","country_code":"US","type":"education","lineage":["https://openalex.org/I184654094"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Vikas Agrawal","raw_affiliation_strings":["Fayetteville State University, USA","[Fayetteville State University, USA]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Fayetteville State University, USA","institution_ids":["https://openalex.org/I184654094"]},{"raw_affiliation_string":"[Fayetteville State University, USA]","institution_ids":["https://openalex.org/I184654094"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5003560469","display_name":"P. S. Sundararaghavan","orcid":null},"institutions":[{"id":"https://openalex.org/I90871651","display_name":"University of Toledo","ror":"https://ror.org/01pbdzh19","country_code":"US","type":"education","lineage":["https://openalex.org/I90871651"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"P. S. Sundararaghavan","raw_affiliation_strings":["The University of Toledo, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"The University of Toledo, USA","institution_ids":["https://openalex.org/I90871651"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103408565","display_name":"Mesbah Uddin Ahmed","orcid":null},"institutions":[{"id":"https://openalex.org/I90871651","display_name":"University of Toledo","ror":"https://ror.org/01pbdzh19","country_code":"US","type":"education","lineage":["https://openalex.org/I90871651"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mesbah U. Ahmed","raw_affiliation_strings":["The University of Toledo, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"The University of Toledo, USA","institution_ids":["https://openalex.org/I90871651"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5005532023","display_name":"Udayan Nandkeolyar","orcid":null},"institutions":[{"id":"https://openalex.org/I90871651","display_name":"University of Toledo","ror":"https://ror.org/01pbdzh19","country_code":"US","type":"education","lineage":["https://openalex.org/I90871651"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Udayan Nandkeolyar","raw_affiliation_strings":["The University of Toledo, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"The University of Toledo, USA","institution_ids":["https://openalex.org/I90871651"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.10935146,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"18","issue":"3","first_page":"1","last_page":"20"},"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.9991000294685364,"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.9991000294685364,"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.9990000128746033,"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/T10799","display_name":"Data Visualization and Analytics","score":0.991100013256073,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/heuristics","display_name":"Heuristics","score":0.9052301049232483},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.779603123664856},{"id":"https://openalex.org/keywords/bottleneck","display_name":"Bottleneck","score":0.7510821223258972},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.7068400382995605},{"id":"https://openalex.org/keywords/cube","display_name":"Cube (algebra)","score":0.6801660060882568},{"id":"https://openalex.org/keywords/scheme","display_name":"Scheme (mathematics)","score":0.517493486404419},{"id":"https://openalex.org/keywords/integer-programming","display_name":"Integer programming","score":0.510330855846405},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.508749783039093},{"id":"https://openalex.org/keywords/data-cube","display_name":"Data cube","score":0.5004909038543701},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.47294971346855164},{"id":"https://openalex.org/keywords/linear-programming","display_name":"Linear programming","score":0.4269979000091553},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.35366666316986084},{"id":"https://openalex.org/keywords/operations-research","display_name":"Operations research","score":0.3308815360069275},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.29452282190322876},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.24838298559188843},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.1393103003501892},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.13913419842720032},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.09942930936813354},{"id":"https://openalex.org/keywords/computer-security","display_name":"Computer security","score":0.07657131552696228}],"concepts":[{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.9052301049232483},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.779603123664856},{"id":"https://openalex.org/C2780513914","wikidata":"https://www.wikidata.org/wiki/Q18210350","display_name":"Bottleneck","level":2,"score":0.7510821223258972},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.7068400382995605},{"id":"https://openalex.org/C53051483","wikidata":"https://www.wikidata.org/wiki/Q861555","display_name":"Cube (algebra)","level":2,"score":0.6801660060882568},{"id":"https://openalex.org/C77618280","wikidata":"https://www.wikidata.org/wiki/Q1155772","display_name":"Scheme (mathematics)","level":2,"score":0.517493486404419},{"id":"https://openalex.org/C56086750","wikidata":"https://www.wikidata.org/wiki/Q6042592","display_name":"Integer programming","level":2,"score":0.510330855846405},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.508749783039093},{"id":"https://openalex.org/C78168278","wikidata":"https://www.wikidata.org/wiki/Q5227269","display_name":"Data cube","level":2,"score":0.5004909038543701},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.47294971346855164},{"id":"https://openalex.org/C41045048","wikidata":"https://www.wikidata.org/wiki/Q202843","display_name":"Linear programming","level":2,"score":0.4269979000091553},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.35366666316986084},{"id":"https://openalex.org/C42475967","wikidata":"https://www.wikidata.org/wiki/Q194292","display_name":"Operations research","level":1,"score":0.3308815360069275},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.29452282190322876},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.24838298559188843},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.1393103003501892},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.13913419842720032},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.09942930936813354},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.07657131552696228},{"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/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.4018/jdm.2007070101","is_oa":false,"landing_page_url":"https://doi.org/10.4018/jdm.2007070101","pdf_url":null,"source":{"id":"https://openalex.org/S73024538","display_name":"Journal of Database Management","issn_l":"1063-8016","issn":["1063-8016","1533-8010"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Database Management","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:igg:jdm000:v:18:y:2007:i:3:p:1-20","is_oa":false,"landing_page_url":"http://services.igi-global.com/resolvedoi/resolve.aspx?doi=10.4018/jdm.2007070101","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":14,"referenced_works":["https://openalex.org/W1978522043","https://openalex.org/W1984675320","https://openalex.org/W1988774479","https://openalex.org/W2017782374","https://openalex.org/W2032232710","https://openalex.org/W2062644745","https://openalex.org/W2069523879","https://openalex.org/W2079229850","https://openalex.org/W2087869882","https://openalex.org/W2103201239","https://openalex.org/W2134600551","https://openalex.org/W2139885979","https://openalex.org/W2140646908","https://openalex.org/W2154944074"],"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/W2168477359","https://openalex.org/W2381646725","https://openalex.org/W2541662483"],"abstract_inverted_index":{"Data":[0],"warehouse":[1,27],"has":[2,67],"become":[3],"an":[4],"integral":[5],"part":[6],"in":[7,11,39,52,60,99],"developing":[8],"a":[9,25,57,63,72,108],"DSS":[10],"any":[12],"organization.":[13,54],"One":[14],"of":[15,24,34,70,75,91],"the":[16,21,31,43,49,53,68,89,100,103],"key":[17],"architectural":[18],"issues":[19],"concerning":[20],"efficient":[22],"design":[23],"data":[26],"is":[28],"to":[29,36,41],"determine":[30],"\u201cright\u201d":[32],"number":[33],"views":[35],"be":[37],"materialized":[38],"order":[40],"minimize":[42],"query":[44],"response":[45],"time":[46],"experienced":[47],"by":[48],"decision":[50],"makers":[51],"We":[55,77,94],"consider":[56],"bottleneck":[58],"objective":[59],"designing":[61],"such":[62],"materialization":[64,105],"scheme":[65],"which":[66],"effect":[69],"guaranteeing":[71],"certain":[73],"level":[74],"performance.":[76],"examine":[78],"linear":[79],"integer":[80],"programming":[81],"formulations,":[82],"and":[83,86],"develop":[84],"heuristics":[85,97],"report":[87],"on":[88],"performance":[90],"these":[92],"heuristics.":[93],"also":[95],"evaluate":[96],"reported":[98],"literature":[101],"for":[102],"view":[104],"problem":[106],"with":[107],"simpler":[109],"objective.":[110]},"counts_by_year":[{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":1},{"year":2013,"cited_by_count":1}],"updated_date":"2026-06-11T06:19:23.411458","created_date":"2025-10-10T00:00:00"}