A Comparison Between Relational and Dimensional Model Techniques in a Business Intelligence Setting
Average rating
Cast your vote
You can rate an item by clicking the amount of stars they wish to award to this item.
When enough users have cast their vote on this item, the average rating will also be shown.
Star rating
Your vote was cast
Thank you for your feedback
Thank you for your feedback
Author
Vacaflores, ThaisReaders/Advisors
Reale, MichaelJofre, Ana
Sarner, Ronald
Spetka, Scott
Term and Year
Fall 2022Date Published
2022-12
Metadata
Show full item recordAbstract
Data modeling is the process of analyzing and defining the different data a business collects and produces and the relationships between that data. [8] Today there are two prevalent database models; relational modeling and dimensional modeling. These models are used to connect the various tables in a database to be used for data analysis. Most traditional businesses use a relational database to store all of their information, and when attempting to analyze data, the relational database is turned into a dimensional one. Dimensional models are considered to be simpler and better to execute queries against. Dimensional modeling is the current industry standard when analyzing data using a business intelligence tool, but are there cases when the transformation step can be skipped and a developer work with a relational model with minimal impacts on the development and user experience? This project will evaluate various aspects, such as the complexity of each model, query execution time, and time to update report elements on business intelligence tools as a result of user interaction. As well as determine if there are cases where the conversion step from a relational to a dimensional model can be skipped and queries created against the relational model instead.