A Comparison Between Relational and Dimensional Model Techniques in a Business Intelligence Setting
dc.contributor.author | Vacaflores, Thais | |
dc.date.accessioned | 2023-05-03T00:00:24Z | |
dc.date.available | 2023-05-03T00:00:24Z | |
dc.date.issued | 2022-12 | |
dc.identifier.uri | http://hdl.handle.net/20.500.12648/8658 | |
dc.description.abstract | 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. | en_US |
dc.language.iso | en_US | en_US |
dc.subject | data modeling | en_US |
dc.subject | relational | en_US |
dc.subject | dimensional | en_US |
dc.title | A Comparison Between Relational and Dimensional Model Techniques in a Business Intelligence Setting | en_US |
dc.type | Masters Project | en_US |
dc.description.version | NA | en_US |
refterms.dateFOA | 2023-05-03T00:00:25Z | |
dc.description.institution | SUNY Polytechnic Institute | en_US |
dc.description.department | Department of Computer & Information Science | en_US |
dc.description.degreelevel | MS | en_US |
dc.description.advisor | Reale, Michael | |
dc.description.advisor | Jofre, Ana | |
dc.description.advisor | Sarner, Ronald | |
dc.description.advisor | Spetka, Scott | |
dc.date.semester | Fall 2022 | en_US |
Files in this item
This item appears in the following Collection(s)
-
SUNY Polytechnic Institute College of Engineering
This collection contains master's theses, capstone projects, and other student and faculty work from programs within the Department of Engineering, including computer science and network security.