Materialized View Construction Based on Clustering Technique
Santanu Roy,Ranak Ghosh,Soumya Sen +2 more
- Vol. 8838, pp 254-265
Reads0
Chats0
TLDR
This paper has proposed materialized view construction methodology at first by analyzing the attribute similarity based on Jaccard Index then clustering methodology is applied using similarity based weighted connected graph and the clusters are validated to check the correctness of the materialized views.Abstract:
Materialized view is important to any data intensive system where answering queries at runtime is subject of interest. Users are not aware about the presence of materialized views in the system but the presence of these results in fast access to data and therefore optimized execution of queries. Many techniques have evolved over the period to construct materialized views. However the survey work reveals a few attempts to construct materialized views based on attribute similarity measure by statistical similarity function and thereafter applying the clustering techniques. In this paper we have proposed materialized view construction methodology at first by analyzing the attribute similarity based on Jaccard Index then clustering methodology is applied using similarity based weighted connected graph. Further the clusters are validated to check the correctness of the materialized views.read more
Figures
Citations
More filters
Parallel Simulated Annealing for MaterializedView Selection in Data WarehousingEnvironments
TL;DR: In this paper, a new approach for materialized view selection using Parallel Simulated Annealing (PSA) is introduced, which selects views from an input Multiple View Processing Plan (MVPP).
Information and automation : international symposium, ISIA 2010, Guangzhou, China, November 10-11, 2010
TL;DR: In this article, a new hobby for other people may inspire them to join with you, but many people are not interested in this hobby, why? Boring is the reason of why.
Book ChapterDOI
Association Based Multi-attribute Analysis to Construct Materialized View
TL;DR: An algorithm which generates a materialized view by considering the frequencies of the multiple attributes at a time taken from a database with the help of Apriori algorithm is proposed, which supports scalabilisalubrityty as well as flexibility.
PMC： Select Materialized Cells in Data Cubes
TL;DR: The future of MOLAP and PMC in China is in doubt.
Book ChapterDOI
A Mathematical Recommendation Model to Rank Reviewers Based on Weighted Score for Online Review System
TL;DR: A mathematical model is presented to rank the reviewers by assigning weighted scores based on certain parameters and a pre-processing technique is used before applying mathematical model to filter out the quality reviews.
References
More filters
Proceedings ArticleDOI
Big Data analytics
TL;DR: This analysis illustrates that the Big Data analytics is a fast-growing, influential practice and a key enabler for the social business and is critical for success in the age of social media.
Journal ArticleDOI
Speeding up materialized view selection in data warehouses using a randomized algorithm
Minsoo Lee,Joachim Hammer +1 more
TL;DR: This paper proposes an efficient solution to the maintenance-cost view selection problem using a genetic algorithm for computing a near-optimal set of views, and explores the Maintenance-costView selection problem in the context of OR view graphs.
Proceedings ArticleDOI
Multiple Materialized View Selection for XPath Query Rewriting
TL;DR: The problem of answering XPATH queries using multiple materialized views is studied, and an NFA-based approach to filter views that cannot be used to answer a given query is proposed and the criterion for multiple view/query answerability is presented.
Proceedings ArticleDOI
Dynamic Materialization of Query Views for Data Warehouse Workloads
Thomas Phan,Wen-Syan Li +1 more
TL;DR: An automated, dynamic MQT management scheme that materializes views and creates indexes in an on-demand fashion as a workload executes and manages them with an LRU cache to maximize the benefit of executing queries with MQTs.
Parallel Simulated Annealing for MaterializedView Selection in Data WarehousingEnvironments
TL;DR: In this paper, a new approach for materialized view selection using Parallel Simulated Annealing (PSA) is introduced, which selects views from an input Multiple View Processing Plan (MVPP).