Approaches of Data Warehousing and Their Applications: A Review
Journal Title: International Journal of Innovative Research in Computer Science and Technology - Year 2022, Vol 10, Issue 1
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
- EP ID EP746987
- DOI 10.55524/ijircst.2022.10.1.21
- Views 50
- Downloads 0
A Review Study on 4G Security
The introduction of the Long Term Evolution (LTE) technology in recent technologies has revolutionized Fourth Generation, 4G Network communication, allowing users to receive high-speed data up to 100 MHz. The problem of...
Major Challenges of Recommender System and Related Solutions
Recommender system is a very young area of machine learning & Deep Learning research. The basic goal of the recommender system is to create a relationship between items and consumers. The relationship provides recommenda...
Stablisation of Expansive Soils by Fly-ash & Wool Waste
In the current study, an effort has been made to stabilise the local expansionary soils using the appropriate mix of locally accessible industrial waste with or without lime. In this study, a sample of high expansive soi...
GIS Based Route Optimization for Effective Traffic Management: A Case Study of Srinagar City
One of the most crucial requirements for effective traffic management in cities is route optimization. Geographical information system (GIS) spatial analysis technique is important for route optimization. Route optimizat...
Gamification in the Classroom
Technology Enhanced Language Learning (TELL) is the buzzword of new learning strategies in the classroom. Game-based applications used in the classroom can investigate the interest generated and performance in learning....