Enterprise Essay

20484 Words Mar 14th, 2014 82 Pages
Marquette University

e-Publications@Marquette
Master's Theses (2009 -) Dissertations, Theses, and Professional Projects

Design and Implementation of an Enterprise Data Warehouse
Edward M. Leonard
Marquette University

Recommended Citation
Leonard, Edward M., "Design and Implementation of an Enterprise Data Warehouse" (2011). Master's Theses (2009 -). Paper 119. http://epublications.marquette.edu/theses_open/119

DESIGN AND IMPLEMENTATION OF AN ENTERPRISE DATA WAREHOUSE

By Edward M. Leonard, B.S.

A Thesis submitted to the Faculty of the Graduate School, Marquette University, in Partial Fulfillment of the Requirements for the Degree of Master of Science

Milwaukee, Wisconsin December 2011

ABSTRACT DESIGN AND
…show more content…
In addition, there is discussion of specific data marts within the warehouse to satisfy a specific need. Finally, there are explanations for how users will consume the data in the enterprise data warehouse, such as through reporting and other business intelligence. This discussion also includes the topics of system architecture of how data from databases and other data warehouses from different departments could integrate. An Enterprise Data Warehouse prototype developed will show how a pair of different databases undergoes the Extract, Transform and Load (ETL) process and loaded into an actual set of star schemas then makes the reporting easier. Separately, an important piece of this thesis takes an actual example of data and compares the performance between them by running the same queries against separate databases, one transactional and one data warehouse. As the queries expand in difficulty, larger grows the gap between the actual recorded times of running that same query in the different environments.

i

ACKNOWLEDGMENTS

Edward M. Leonard, B.S.

I would like to thank my family for their love and support during my work on this master’s thesis. I would especially like to thank my sister, Jamie Ousterout for her time and skills to help me edit this thesis. I would like to thank Marquette University for my employment for the chance to work daily with the technologies in data warehousing and business intelligence. Finally, I would like to thank the members

Related Documents