Date of Award
Master of Science in Information Systems (MSIS)
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 TSQL 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).
Pillamari, Sanketh, "Maintain Reporting Integrity in SQL Server Reporting Services" (2015). Masters Theses & Doctoral Dissertations. 216.