Processing Aggregate Queries with Materialized Views in Data Warehouse Environment(Database)
スポンサーリンク
概要
- 論文の詳細を見る
Materialized views, which are derived from base relations and stored in the database, offer opportunities for significant performance gain in query evaluation by providing quick access to the pre-computed data. A materialized view can be utilized in evaluating a query if it has pre-computed result of some part of the query plan. Although many approaches to utilizing materialized views in evaluating a query have been proposed, there exist several restrictions in selecting such views. This paper proposes new ways of utilizing materialized views in answering an aggregate query. Views including relations that are not referred to in the given query are utilized. Attributes missing from a view can be recovered under certain conditions. We identify the conditions where a view may be used in evaluating a query and present the algorithm to search for the most efficient query among the equivalent ones. We also report on a simulation based on the TPC-H and GRID databases. Simulation results show that our approach provides impressive performance improvements to the data warehousing environment where aggregate views are often pre-computed and materialized.
- 社団法人電子情報通信学会の論文
- 2005-04-01
著者
-
Kim Han
Department of Orthodontics, Osaka Dental University
-
Kim Han
Department Of Electrical And Computer Engineering University Of Seoul
-
CHANG Jae
School of Computer Engineering, Hansung University
-
Chang Jae
School Of Computer Engineering Hansung University
-
Kim Han
Department Of Biochemistry College Of Life Science And Biotechnology Yonsei University
関連論文
- Evaluation of 3D-CT stereotaxic images for lateral cephalometric analysis
- Importance of head positioning in cephalometric analysis of 3 D-CT stereotaxic images
- Evaluation of 3D-CT stereotaxic imaging for frontal cephalometric analysis
- Development and Industry of Health Functional Food in Korea
- Endoprosthetic Reconstruction after Resection of Primary Bone Tumors
- NK/T-Cell Lymphoma Associated with Epstein-Barr Virus in a Patient Infected with Human Immunodeficiency Virus : An Autopsy Case
- The Detection of Epstein-Barr Virus in the Lesions of Salivary Glands
- Epstein-Barr Virus and CD21 Expression in Gastrointestinal Tumors
- Sauchinone Attenuates Oxidative Stress-Induced Skeletal Muscle Myoblast Damage through the Down-Regulation of Ceramide
- Modulation of HSP70 and HSP90 Expression by Sodium Salicylate and Aspirin in Fish Cell Line CHSE-214 : Biochemistry
- Identification of Heat Shock Protein 90-Associated 84-kDa Phosphoprotein
- Processing Aggregate Queries with Materialized Views in Data Warehouse Environment(Database)
- Oncogenic Functions of PTK6 are Enhanced by Its Targeting to Plasma Membrane But Abolished by Its Targeting to Nucleus
- IF-1 The usefulness of sputum cytology in screening of lung cancer(Current status of respiratory cytology in Asian countries)
- Precipitation and Growth of Non-metallic Inclusions during Solidification of Steels
- Reappraisal of MMR vaccines currently used in Korea
- A Method for Evaluating Composition of Complex Inclusions Comprising Oxides and MnS in Si/Mn/Ti Deoxidized Steels
- Three New Orcinol-Conjugated Hydrolysable Tannins from the Leaves of Cleyera japonica
- Identification of Heat Shock Protein 90-Associated 84-kDa Phosphoprotein.