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

Computer Science & Application

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.

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.