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 59
- Downloads 0
Removal of Turbidity by Using Moringa Oliefera
Water that is clean and hygienic must be available for drinking. Most of the water that is currently available needs to be cleaned. When water is contaminated, it may be required to recycle it. Water must be treated to e...
Design and Implementation of Two Speed Multiplier Using FPGA
Multiplication has recently been given top priority in all applications of digital signal processing and machine learning. It is crucial to control the area, latency, power, and performance overall using parallel impleme...
An Overview on Vertical Farming
Vertical farming methods allow for the effective use of space by growing fresh food vertical in dissimilar layer piled atop each other’s. Vertical farming techniques do not require sunshine or soil since the atmosphere...
Combinations, Contradictions, And Cross Fertilization in Actor-Network Theory and Assemblage Thinking
This paper shows that assembling thought as well as actor-network theory (ANT) have such a great deal in common than the debate suggests. It proposes three cross-fertilizations depending on intersections as well as disju...
Secure Car Parking System Using VHDL
The usage of automobiles is rising nowadays days and people, resulting in more pollution, traffic jams, and parking space difficulties, with finding a free parking spot becoming increasingly challenging. A Verilog HDL-ba...