Date of Award

Spring 4-1-2012

Document Type

Thesis

Degree Name

Master of Science in Information Systems (MSIS)

First Advisor

Ronghua Shan

Second Advisor

Stephen Krebsbach

Third Advisor

Christopher Olson

Abstract

Daytona State College's Document Imaging system has served well for nearly 10 years. Since 2002 the college has processed more than 2.4 million scans, handling about 50 million pages, storing about 1 TB of data. However, recently the users of the system started experiencing significant slowdowns during the operation of the system due to its growth. Another design drawback to the current Document Imaging system is that it only operates in the append mode, meaning document entities that already exist in the imaging system will get appended to the end of the existing entity. This makes the system to grow much more quickly than necessary, making our backup, especially our full-backup operations, very resource and time consuming. Additionally, the current append-only design does not and cannot provide functionality for maintaining different retention policies. This project is about redesigning the Document Imaging database structure and system functionality to speed up its operations while also taking into account the future growth of the system, as well as modifying the original design from append-only to no-append approach. Since the beginning of the project managers of this system had limited reporting capabilities. All the reporting needs have been performed against the live transactional database that is also serving for all the Document Imaging operations. To speed up some of the operations, the log table has been cleaned up periodically to remove non-critical records, which resulted in losing some of the reporting capabilities. This project will also handle the reporting needs by creating a simple data warehouse that will permanently store all the needed log entries as well as additional supporting data to give the managers the needed reporting flexibility.

Comments

dsu-th-020

Download

Share

COinS