materialized view
An Improved Approach for Materialized View Selection Based on Genetic Algorithm
... This paper presents the genetic algorithm representation for materialized view selection problem. For a given VSCG, convert it to binary code in genetic algorithm, given the generation of initialization ...
8
Materialized View Selection for a Data Warehouse Using Frequent Itemset Mining
... Proposed materialized view selection methods often have used a special framework which had considered some or all these ...a materialized view selection frameworks: in the first step, the ...
9
Assortment of Materialized View: A Comparative Survey in Data Warehouse Environment
... as materialized views (MV), these views are generated as per user requirement specified in queries ...A materialized view is a database object that stores the result of a query and makes them ...
8
Acceleration Of Query Response In Distributed System Using Materialized View Approach
... --------------------------------------------------------------------------------------------------------------------------------------------------------------- Abstract—A data warehousing technology is nothing but ...
6
Materialized View Selection and Preservation on Data centric Environment: A Survey
... called materialized views. Appropriate Materialized views selection is one of the fragile and important decisions in designing a data warehouse for better efficiency and plays a vital role for successful ...
6
Design and Implementation of Algorithms for Materialized View Selection and Maintenance in Data Warehousing Environment
... the materialized view storage space and maintenance cost constraint thus proper materialized views selection is one of the intelligent decisions in designing a data warehouse to get optimal ...best ...
7
1. Fsvmrt: materialized view selection algorithm in data warehouse using ‘r’
... multiple view processing plan (MVPP), to present the problem formally and they proposed a heuristic algorithm based on individual optimum query ...of materialized view selection under a disk space ...
8
Materialized View Selection Approach Using Tree Based Methodology
... in materialized view. Then the materialized view is created for each leaf node, indirectly each leaf represents materialized view that has to be created and ...The ...
11
An Improved Algorithm for Materialized View Selection
... In this paper, first the query cost view selection problem model is proposed. Second, the methods for selecting materialized views are presented. The genetic algorithm is applied to the materialized ...
9
An Association Rule Mining for Materialized View Selection and View Maintanance
... In this approach the set of SQL statements considered as workload which is selected to configure materialized views for partial materialization. This approach of ARMMVVM has two parts materialized ...
6
Application of Clustering Algorithm CLOPE to the Query Grouping Problem in the Field of Materialized View Maintenance
... years, materialized views (MVs) are widely used to enhance the database performance by storing pre-calculated results of resource-intensive queries in the physical ...potentially materialized, database ...
12
The Two-stage Stochastic View Selection Problem in OLAP Systems: Models and Algorithms.
... the materialized view V1 no longer distinguishes between individual items or sales ...of materialized views has to be addressed in the context of the objectives and lim- itations of each ...the ...
131
LANGUAGE MODEL FOR DIGITAL RECOURSE OBJECTS RETRIEVAL
... the materialized view. Then the materialized view is created for each leaf node, indirectly each leaf representing a materialized view that must be created and ...The ...
15
Content-Based Image Retrieval (CBIR) System Based on the materialized views and Genetic Algorithm
... images. Materialized view selection includes two costs, query processing cost and view maintenance ...high view maintenance cost but we will doing Offline to get fast response ...
16
Repetitive querying of large random heterogeneous datasets in RDBMS using materialized views
... Li et al discuss P2P databases, data provenance, and data space management, declarative networking, and materialized views. The authors claim that in their approach they use a rule for the parameter k, which ...
106
A role-based access control schema for materialized views
... of materialized views. Materialized views can be used for performance reasons in very large systems such as data warehouses or distributed systems, or for providing a filtered selection of data from a more ...
69
The design of an adaptive column-store system
... (index, materialized view, partitions, allocation), Oracle Advisor [24, 25] (index, materialized view, partitioning support), various advisors for Microsoft’s products [26–30] (vari- ety of ...
21
Data Cube Approximation and Mining using Probabilistic Modeling
... modeling, materialized view selection, efficient cube computation, query optimization, discovery-driven exploration of cubes, cube reorganization, data mining in cubes, and so ...
20
Optimization of Query Processing Time Base on Materialized Sample View
... small. Materialized views defined over distributed data sources are critical for many applications to ensure efficient access, reliable performance, and high ...of materialized view over the ...
7
Algorithms for Selecting Views and Indexes to Answer Queries
... that can be treated as tasks. Incorporation of any classes of tasks, including indexes, in our stage-one algorithms is orthogonal to the query/view/rewriting languages to which the algorithms are applicable. Note ...
132