preview

MIS 563 COURSE PROJECT Essay

Better Essays

Table of Contents

Findings…………………………………………………………… 2
Issues………………………………………………………………. 2
Opportunities………………………………………………….. 3
Recommendations………………………………………….. 3
Next Steps………………………………………………………. 3
Project Schedule…………………………………………….. 4
Database Design…………………………………………….. 4
Data Modeling & Data Marts…………………………. 4
Database Selection…………………………………………. 5
ETL Selection………………………………………………….. 5
Data Mining…………………………………………………… 6
Conclusions………….………………………………………… 8
References…………………………………………………….. 10

Findings:

ABC University has several departmental databases that perform specific functions for each department. Within these databases are several items that can be considered cross functional data among …show more content…

The reason why this is the way to go is that relational databases are limited in the number of relationships that can be dug down and analyzed. Using a dimensional model will allow the use of multi-dimensional cubes to be able to pull 3 or more dimensions back into a pivot table. An example would be Sales by customer service rep by assigned sales territory. This provides a deeper detail of data than you would be able to get out of a relational database. For each department of the university, I propose a Data mart for each one. The reason why this is the case is so that every department can manipulate their own data as they see fit with their own resources because it is on a different server than another data mart typically. The look and feel of the Data Mart is up to that department and does not bother the other departments Data Marts. Individual data marts can also increase response time because there are not as many people hitting them all at one time. If a new department were to pop up, data mart creation is very easy to do. Each record will be unique based on the primary or composite keys of the table, and those keys could be surrogate keys such as using AutoNumber like in Microsoft Access. Depending on the analysis of the data, it may be determined that the ID numbers between student and teacher are unique and this can be the way to link items together throughout the database. The

Get Access