Scholars Central

Research articlePublished 2014

An efficient materialized view selection approach for data cube utilizing evolutionary optimization

Authors: Gang Li

Ask about this article

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”.

Ask 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.

Try:

Similar by topic

More from this journal

The newest in BioTechnology: An Indian Journal.

All its articles

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”

For authors and organisers

Publish, present and keep up with your field

Find the right journal for your paper and submit your manuscript.

Photo: Pexels