Juracek, Marek

English

Daytona State College\u27s 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

Beadle Scholar at Dakota State University

Dakota State UniversityBeadle ScholarMasters ThesesSpring 4-1-2012Major Revision to Document Imaging System toImprove Efficiency and Reporting CapabilitiesMarek JuracekDakota State UniversityFollow this and additional works at: https://scholar.dsu.edu/thesesThis Thesis is brought to you for free and open access by Beadle Scholar. It has been accepted for inclusion in Masters Theses by an authorizedadministrator of Beadle Scholar. For more information, please contact repository@dsu.edu.Recommended CitationJuracek, Marek, "Major Revision to Document Imaging System to Improve Efficiency and Reporting Capabilities" (2012). MastersTheses. 202.https://scholar.dsu.edu/theses/202

Major Revision to Document Imaging System to Improve Efficiency and Reporting Capabilities

https://scholar.dsu.edu/cgi/viewcontent.cgi?article=1201&amp;context=theses

Major Revision to Document Imaging System to Improve Efficiency and Reporting Capabilities

Abstract

Similar works

Full text

Available Versions

Beadle Scholar at Dakota State University