Date of Award

Fall 12-1-2015

Document Type


Degree Name

Master of Science in Information Systems (MSIS)

First Advisor

Ronghua Shan

Second Advisor

Stephen Krebsbach

Third Advisor

Zixing Shen


This project involves implementing a database management system. This process interprets modifying existing stored procedures, identifying the component part of the procedure requiring modification writing a new SQL code. The interpretation process also includes mapping document for the new database, testing and displaying results on a GUI. As a result, there are a number of reports will cease to work properly through maintaining reporting integrity. Operational Data Source (ODS) vs Data Mart (DW) and Data Warehouse (DW) ODS - In this project most of the databases on Old Database are designed to be replicas, or near replicas, of the source data or systems behind them. These source systems are almost always transactional systems and are designed for getting information into a database. An ODS is meant to facilitate the integration of data from multiple sources which includes New Database for further operations. DM/DW - There is a single database that is being used for data warehousing purposes. Includes schemas corresponding to individual Data Marts. Designed for analytical reporting. Problem Specification This project develops a database management system. It uses the logic of the New Database to query the existing stored procedure from the old database. The reports are created using T­SQL code and stored procedures. The output is presented in the form of reports and dashboards. The data can be understood visually in form of graphs and charts for different reports. The project report Maintain Integrity to Support SQL Server Reporting Services will be implemented using Microsoft SQL Server Management Studio, Microsoft Visual Studio 2010 (SQL Server Data Tools) and Report Server (The Business Intelligence Suite).