Research article · 2009
Research articlePublished 2014
An efficient materialized view selection approach for data cube utilizing evolutionary optimization
Abstract
Select any words in the title or abstract, or press this and choose a sentence.
In this paper, we focus on the problem of materialized view selection for data cube, which is an important in the research field of database management. In the data warehouse, multi-dimension data can be represented as a data cube, which is a basic element in data warehouse. Particularly, each sub-cube is corresponding to an aggregation view in a specific the data cube. As the objective of materialized view selection for data cube is to minimize the sum of query cost and maintenance cost, in this paper, we converted data cube materialized view selection problem to an evolutionary multi-objective optimization problem. Afterwards, we propose a materialized view selection algorithm for data cube using evolutionary multi-objective optimization. When the stopping condition is satisfied, output of the proposed algorithm can be utilized as the data cube materialized view selection results. To testify the effectiveness of the proposed algorithm, we conduct experiments to make performance evaluation. Compared with other materialized view selection methods, the proposed algorithm performs better in the evaluation criteria “Time cost”, “Average response time”, and “Maintaining and updating time”.
Subjects
Biochemistry & BiotechnologyAsk about this article
Answers come only from this article's title, abstract and keywords, each sentence pointing to where it comes from. Your question is sent to OpenAI to write the answer. Scholars Central does not store it.
Similar by topic
Research article · Nov 2014
Data Cube Materialization Using Map Reduce
Conference abstract · 8 Apr 2013
Comparison of two metabolomics data processing approaches using a standard metabolomics reference material
Commentary · 5 Oct 2022
Evolutionary Change in Meristematic Cell Lineages via Intra Organismal Selection
Short communication · 19 Jan 2024
The Phylogenetic Power of Genomic Data: From DNA Sequences to Evolutionary Trees.
More from this journal
The newest in BioTechnology: An Indian Journal.
Editorial · 27 Dec 2025
Nucleic Acids: Structure, Function, and Significance in Biological Systems
Editorial · 27 Dec 2025
Biosensors: Principles, Design, and Applications in Modern Biotechnology
Editorial · 27 Dec 2025
Molecular Biology: Understanding Life the Molecular Level
Conferences in this field
Upcoming conferences in this field.
Follow
New articles from what you follow go into your email digest, once you agree to alert emails.
- JournalBioTechnology: An Indian Journal
- SubjectBiochemistry & Biotechnology
- BylineArticles whose byline prints “Gang Li”

