CFP last date
20 December 2024
Call for Paper
January Edition
IJCA solicits high quality original research papers for the upcoming January edition of the journal. The last date of research paper submission is 20 December 2024

Submit your paper
Know more
The week's pick
Responsive image
Improved Shuffled Frog Leaping Algorithm with Self-Adaptive Shuffling for Fuzzy Logic PD+G Controller Optimization in Robotic Manipulators

Duc Hoang Nguyen
Random Articles
Reseach Article

Double Partitioning with global and local Indexing: Effect on Data Warehouse Performance

by Mohamed El Emine Abdel Wedoud, Mohamed Larbi Benmaati, Emany Sidi
journal cover thumbnail

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 180 - Number 44
Year of Publication: 2018
Authors: Mohamed El Emine Abdel Wedoud, Mohamed Larbi Benmaati, Emany Sidi
10.5120/ijca2018917148

Mohamed El Emine Abdel Wedoud, Mohamed Larbi Benmaati, Emany Sidi . Double Partitioning with global and local Indexing: Effect on Data Warehouse Performance. International Journal of Computer Applications. 180, 44 ( May 2018), 18-20. DOI=10.5120/ijca2018917148

@article{ 10.5120/ijca2018917148,
author = { Mohamed El Emine Abdel Wedoud, Mohamed Larbi Benmaati, Emany Sidi },
title = { Double Partitioning with global and local Indexing: Effect on Data Warehouse Performance },
journal = { International Journal of Computer Applications },
issue_date = { May 2018 },
volume = { 180 },
number = { 44 },
month = { May },
year = { 2018 },
issn = { 0975-8887 },
pages = { 18-20 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume180/number44/29441-2018917148/ },
doi = { 10.5120/ijca2018917148 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-07T01:03:36.402062+05:30
%A Mohamed El Emine Abdel Wedoud
%A Mohamed Larbi Benmaati
%A Emany Sidi
%T Double Partitioning with global and local Indexing: Effect on Data Warehouse Performance
%J International Journal of Computer Applications
%@ 0975-8887
%V 180
%N 44
%P 18-20
%D 2018
%I Foundation of Computer Science (FCS), NY, USA
Abstract

The design of data warehouses is the most important step in their life cycle and is due to its permanent impact on its condition and operation. Strategic decision-making in a timely manner is an objective and a need for decision makers, especially in a production environment with a high frequency of updating. Designers of data warehouses always try to minimize the execution time of the analysis requests and optimize the performance of the warehouse in order to present the reports in the best time and condition. This article shows that during the design phase a double vertical and horizontal partitioning of the fact table and dimension tables with global and local indexing can optimize the logical and physical performance of the data warehouse.

References
  1. Surajit and Narasayya, Vivek Chaudhuri, "Partitioning strategies in distributed object-oriented database systems," 1997.
  2. R. Kimball, L. Reeves, M. Ross, The Data Warehouse Toolkit. John Wiley Sons, NEW YORK, 2nd edition, 2002.
  3. S. Chaudhuri, U. Dayal,An Overview of Data Warehousing and OLAP Technology., ACM SIGMOD RECORD. 1997
  4. E. Omiecinski, and S. Navathe. M. Frank, Adaptive and automated index selection in rdbms. Vienna, Austria: International Conference onExtending Database Technology, 1992.
  5. W. Inmon, Building the Data Warehouse., John Wiley Sons, fourth edition, 2005.
  6. K. Wu and P. Yu, Range-based bitmap Indexing for high cardinality attributes with skew. Washington, DC, USA: the 22nd International Computer Software and Applications Conference. IEEE Computer Society, 1998.
  7. Patrick and Quass, Dallan O'Neil, "Improved Query Performance with Variant Indexes," vol. 26, no. 2, 1997.
  8. 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
  9. 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
  10. 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
  11. Star Schema Advantages on Data Warehouse: Using Bitmap Index and Partitioned Fact Tables (Volume 134/Number 13 (ISBN: 973-93-80890-95-3)): Emany Sidi, Mohamed El Merouani, El Amin A. Abdelouarit
  12. Data Warehouse Tuning: The Supremacy of Bitmap Index (Volume 79/Number 7 (ISBN: 973-93-80878-07-5)) 2013 Authors: El Amin Aoulad Abdelouarit, Mohamed El Merouani, Abdelatif
Index Terms

Computer Science
Information Sciences

Keywords

Data Warehouse optimization BI Indexes performance

Powered by PhDFocusTM