CFP last date
22 April 2024
Reseach Article

Data Warehouse Performance: Optimization by Double Partitioning of Materialized Views

by Mohamed El Emine Abdel Wedoud, Mohamed Larbi Benmaati, Emany Sidi
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 174 - Number 14
Year of Publication: 2021
Authors: Mohamed El Emine Abdel Wedoud, Mohamed Larbi Benmaati, Emany Sidi
10.5120/ijca2021921029

Mohamed El Emine Abdel Wedoud, Mohamed Larbi Benmaati, Emany Sidi . Data Warehouse Performance: Optimization by Double Partitioning of Materialized Views. International Journal of Computer Applications. 174, 14 ( Jan 2021), 17-19. DOI=10.5120/ijca2021921029

@article{ 10.5120/ijca2021921029,
author = { Mohamed El Emine Abdel Wedoud, Mohamed Larbi Benmaati, Emany Sidi },
title = { Data Warehouse Performance: Optimization by Double Partitioning of Materialized Views },
journal = { International Journal of Computer Applications },
issue_date = { Jan 2021 },
volume = { 174 },
number = { 14 },
month = { Jan },
year = { 2021 },
issn = { 0975-8887 },
pages = { 17-19 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume174/number14/31745-2021921029/ },
doi = { 10.5120/ijca2021921029 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-07T00:22:05.085730+05:30
%A Mohamed El Emine Abdel Wedoud
%A Mohamed Larbi Benmaati
%A Emany Sidi
%T Data Warehouse Performance: Optimization by Double Partitioning of Materialized Views
%J International Journal of Computer Applications
%@ 0975-8887
%V 174
%N 14
%P 17-19
%D 2021
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Given the evolving volume of data storage in a data warehouse, partitioning is a very useful optimization option during the design phase of data warehouse. Materialized views also improve the execution time of data warehouse queries. The primary concern of designers and end users of data warehouses is always the performance that ensures the production of the best results in the shortest time. In this work, we will demonstrate that if we end up with the partitioning of materialized views, we can optimize the functioning of data warehouses.

References
  1. Double Partitioning with global and local Indexing: Effect on Data Warehouse Performance" (Volume 180/Number 44 (ISBN: 973-93-80898-72-9) Authors: Mohamed El Emine Abdel Wedoud, Mohamed Larbi Benmaati, Emany Sidi.
  2. R. Kimball, L. Reeves, M. Ross, The Data Warehouse Toolkit. John Wiley Sons, NEW YORK, 2nd edition, 2002.
  3. Selection Of Materialized View Using Query Optimization In Database Management : An Efficient Methodology., International Journal of Database Management Systems 2(4). 2010 . Authors : V. M. Thakare, KArde.
  4. W. Inmon, Building the Data Warehouse., John Wiley Sons, fourth edition, 2005.
  5. Patrick and Quass, Dallan O'Neil, "Improved Query Performance with Variant Indexes," vol. 26, no. 2, 1997.
  6. Impact of using Snowflake Schema and Bitmap Index on Data Warehouse Querying (Volume 180/Number 15 (ISBN: 973-93-80898-08-9)) Authors: Mohammed Benjelloun, Mohamed El Merouani, El Amin A. Abdelouarit.
  7. Using Snowflake Schema and Bitmap Index for Big Data Warehouse Volume (Volume 180/Number 8 (ISBN: 973- 93-80897-91-9)) Authors: Mohammed Benjelloun, Mohamed El Merouani, El Amin A. Abdelouarit.
  8. The Impact of Partitioned Fact Tables and Bitmap Index on Data Warehouse Performance (Volume 135/Number 13 (ISBN: 973-93-80891-16-1)) Authors: Emany Sidi, Mohamed El Merouani, El Amin A. Abdelouarit.
  9. Star Schema Advantages on Data Warehouse: Using Bitmap Index and Partitioned Fact Tables (Volume 134/Number 13 (ISBN: 973-93-80890-95-3)) Authors: Emany Sidi, Mohamed El Merouani, El Amin A. Abdelouarit.
Index Terms

Computer Science
Information Sciences

Keywords

Data Warehouse optimization Partitioning materialized views performance.