Approaches of Data Warehousing and Their Applications: A Review

Abstract

A data warehouse, DW in short is a huge repository of corporate data that is employed to aid an organization's decision-making. The data warehouse idea has been around throughout eighties, while it was created to assist in the transformation of data from just enabling activities to fueling judgment assistance capabilities that disclose business insight. The huge volume of data in data stores originates from a variety of sources, including interior services like branding, selling, and treasury, customer-facing services, and outsourced systems, besides several. On a scientific basis, a DW gathers data from various apps and platforms on a regular basis; the data is then formatted and imported to match the data currently in the storehouse. This generated content is stored in the DW so that decision makers may access it. The frequency with which data pulls happen, how data is organized, and so on will vary relying on the needs of the company. The procedure of mining data from a basic system or excavating information from a huge quantity of data is known as data warehousing. It is generally known as ETL, which stands for extract, transform, and load. This paper discusses the following topics: an overview of Datawarehouses, different Datawarehouse design approaches and their benefits and drawbacks, different sorts of pulling out techniques in Datawarehouses, characteristics of Datawarehouses, dissimilar doles of data warehousing, unalike components used in DW, and data warehousing usages.

Authors and Affiliations

Mrinal Paliwal

Keywords

Related Articles

Performance Analysis of Image Segmentation Using Parallel Processing

This paper presents a study on Fuzzy C Means (FCM) based segmentation technique via different modes over a number of images. This research work includes development of simulation models in both sequential and parallel mo...

PIC18F452 Microcontroller Home Security System: A Review Paper

For we picked a PIC18F452 microchip for the design and simulation of their home automation designs. Built also on PIC18F452, our sensor measures a home's glass doors and transmit an alert and then a warmer signals to a l...

Effects of Basketball Shooting Distance on Release Angle

Basketball, as one of the most popular sports worldwide, has attracted approximately 450 million participants. Studies show that nearly half of the points scored in a game come from jump shots, making it an indispensable...

A New Residual Convolutional Neural Network-Based Speech Improvement

Among the most crucial methods for denoising a noisy voice signal and enhancing its quality is speech enhancement. This study makes use of Adaptive Residual Neural Network technique to reduces maximum off background nois...

Lossless Speech Compression Techniques: A Literature Review

Nowadays, computer technology mostly focusing on storage space and speed. With the rapid growing of important data and increased numbers of applications, devising new approach for efficient compression and encryption met...

Download PDF file
  • EP ID EP746987
  • DOI 10.55524/ijircst.2022.10.1.21
  • Views 56
  • Downloads 0

How To Cite

Mrinal Paliwal (2022). Approaches of Data Warehousing and Their Applications: A Review. International Journal of Innovative Research in Computer Science and Technology, 10(1), -. https://europub.co.uk/articles/-A-746987