Systems Design and Implementation a new paradigm of an Enterprise Data Warehouse Prototype for Business Intelligence Platforms

August 2021
Vol-6, Issue-5
Paper ID: 15168
ISSN: 2395-4396
Downloads: 72
Download PDF

Abstract & Details

Research Area
Computer Science & Application
Keywords
ETL Warehouse Data environment & architecture etc.
Abstract
In this paper also includes a technical piece discussing database requirements and technologies used to build and refresh the data warehouse. In this paper discusses how one can integrate data from databases and other data warehouses. In addition, there is a discussion of specific data warts within the warehouse to meet a specific requirement. Finally, there are explanations for how users will consume data in the enterprise data warehouse, such as through reporting and other business intelligence. This discussion also includes topics in system architecture on how data from different departments' databases and other data warehouses can integrate. An enterprise data warehouse prototype will be developed that will show how a pair of different databases undergo the Extract, Transform and Load (ETL) process and load into the actual set of star schemas and then make reporting easier. Separately, an important piece of this paper takes a real example of data and compares performance between them by running similar queries against different databases, a transaction, and a data warehouse. As queries increase in difficulty, the difference between the actual recorded time of running the same query in a larger environment increases.

Author Information

# Name Institute / Affiliation
1 Bachchu Singh Bhagwant University
2 Dr. Pushpneel Verma Bhagwant University

How to Cite

Use the following formats to cite this article in your research.

APA Style
Singh, Bachchu & Verma, Dr. Pushpneel (2021). Systems Design and Implementation a new paradigm of an Enterprise Data Warehouse Prototype for Business Intelligence Platforms. International Journal of Advance Research and Innovative Ideas In Education, 6(5), 2306-2311.
MLA Style
Singh, Bachchu, and Dr. Pushpneel Verma. "Systems Design and Implementation a new paradigm of an Enterprise Data Warehouse Prototype for Business Intelligence Platforms." International Journal of Advance Research and Innovative Ideas In Education, vol. 6, no. 5, 2021, pp. 2306-2311.
IEEE Style
Bachchu Singh and Dr. Pushpneel Verma, "Systems Design and Implementation a new paradigm of an Enterprise Data Warehouse Prototype for Business Intelligence Platforms," International Journal of Advance Research and Innovative Ideas In Education, vol. 6, no. 5, pp. 2306-2311, 2021.
Vancouver Style
Singh Bachchu, Verma Dr. Pushpneel. Systems Design and Implementation a new paradigm of an Enterprise Data Warehouse Prototype for Business Intelligence Platforms. International Journal of Advance Research and Innovative Ideas In Education. 2021;6(5):2306-2311.
Harvard Style
Singh, Bachchu & Verma, Dr. Pushpneel (2021) 'Systems Design and Implementation a new paradigm of an Enterprise Data Warehouse Prototype for Business Intelligence Platforms', International Journal of Advance Research and Innovative Ideas In Education, 6(5), pp. 2306-2311.
Chicago Style
Singh, Bachchu and Dr. Pushpneel Verma. "Systems Design and Implementation a new paradigm of an Enterprise Data Warehouse Prototype for Business Intelligence Platforms." International Journal of Advance Research and Innovative Ideas In Education 6, no. 5 (2021): 2306-2311.
Turabian Style
Singh, Bachchu and Dr. Pushpneel Verma. "Systems Design and Implementation a new paradigm of an Enterprise Data Warehouse Prototype for Business Intelligence Platforms." International Journal of Advance Research and Innovative Ideas In Education 6, no. 5 (2021): 2306-2311.

Export Citation

Related Research

PReFace : AI -Assisted Plausible Facial Restoration and Damage Reconstruction System
Syeda Arbeena Kausar et al. 2026 Computer Science and Engineering (Computer Vision, Deep Learning and Image Processing)
Download PDF
Customer Churn Prediction Using Machine Learning
Dr. Roshni Khlhe et al. 2026 Machine Learning, Artificial Intelligence, Data Analytics, and Customer Churn Prediction.
Download PDF
Automated web vulnerability scanner
Jitendra Sahu et al. 2026 Computer science
Download PDF
BLOOD BANK DEMAND PREDICTION SYSTEM: MACHINE LEARNINGBASED BLOOD DEMAND FORECASTING
Uday Dharmapal Wankhede et al. 2026 Computer Science & Engineering
Download PDF