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 34
- Downloads 0
Blockchain for Enhancing IoT Privacy and Security
The technological advancements in the network technologies that deal with interconnected computing devices has led to the dramatic increase in the number of Internet of Things (IoT) devices. It promises to improve the...
Enhanced Churn Prediction in the Telecommunication Industry
Prediction models are usually built by applying a supervised learning algorithm to historical data. This involves the use of data analytics system that uses real-time integration and dynamic real time responses data to d...
Using AI for Dynamic Resource Allocation and Performance Optimization in Software Systems
This research work aims at evaluating the possibilities of using artificial intelligence in dynamic resource management and optimization of software system performance. In today’s complex world of application usage, norm...
Deep Web Crawler: A Review
In today’s scenario, there is an ample amount of data on the internet that can be accessed by everyone. This is the data that can be indexed by search engines. There are softwares named Web Crawlers that explore the WWW...
Classification of High Frequency Impact Signal in Vibrational Analysis of Spur Gears by using Convolutional Neural Networks
Spur gears are one of the widely used gears in a gearbox assembly. They often require lubrication and replacement of pinion and gears as prone to damage in high speed shafts with heavy loads and adverse working condition...