Call for Paper - January 2023 Edition
IJCA solicits original research papers for the January 2023 Edition. Last date of manuscript submission is December 20, 2022. Read More

Data Warehouse Performance: Optimization by Double Partitioning of Materialized Views

Print
PDF
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
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 and Emany Sidi. Data Warehouse Performance: Optimization by Double Partitioning of Materialized Views. International Journal of Computer Applications 174(14):17-19, January 2021. BibTeX

@article{10.5120/ijca2021921029,
	author = {Mohamed El Emine Abdel Wedoud and Mohamed Larbi Benmaati and Emany Sidi},
	title = {Data Warehouse Performance: Optimization by Double Partitioning of Materialized Views},
	journal = {International Journal of Computer Applications},
	issue_date = {January 2021},
	volume = {174},
	number = {14},
	month = {Jan},
	year = {2021},
	issn = {0975-8887},
	pages = {17-19},
	numpages = {3},
	url = {http://www.ijcaonline.org/archives/volume174/number14/31745-2021921029},
	doi = {10.5120/ijca2021921029},
	publisher = {Foundation of Computer Science (FCS), NY, USA},
	address = {New York, 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.

Keywords

Data Warehouse, optimization, Partitioning, materialized views, performance.