A methodology for handling data errors and inconsistencies in database conversions
Hendrickson, Mark Robert
Lum, Vincent Y.
Wu, C. Thomas
MetadataShow full item record
A database management system (DBMS) can have numerous errors and inconsistencies in its data. Examples of errors and inconsistencies that may be contained in a DBMS are: Referential integrity violations, logical inconsistencies, redundancies and out-of-range values. During a conversion of database management systems, the errors and inconsistencies in the source system must be corrected so the data entered into the new target DBMS will be accurate. The goal of this thesis is to examine a source database management system to determine what errors and inconsistencies are possible, to propose a methodology to detect them, and to correct such errors and inconsistencies prior to entering the data into the target DBMS. In applying my proposals, the thesis will examine the specific systems utilized by the United States Military Academy (USMA) at West Point, New York. The Academy uses a UNISYS 110072 mainframe computer in support of its existing network model DBMS. West Point proposes to convert network model to a relational model system. The thesis will also address the general applicability of this methodology to other database management system conversions.
Approved for public release; distribution is unlimited.
Showing items related by title, author, creator and subject.
Web-based information management system for the investigation, reporting, and analysis of human error in Naval Aviation maintenance Boex, Anthony R. (Monterey, California. Naval Postgraduate School, 2001-09);The purpose of this thesis is to examine the development of a Web application to display, analyze, and produce reports of human error involvement and patterns in aviation maintenance mishaps. The Human Factors Analysis and ...
Brickey, Jonalan (2001-06);The Housing Welcome Center (HWC) in Monterey, CA manages more than 2, 200 military family houses and provides services to approximately 4,500 service members. The current housing information system consists of a proprietary ...
Smith, Sheila A. (Monterey, California. Naval Postgraduate School, 2000-06);In the development of large distributed systems, both the detection and resolution of inconsistency in policy, requirements, and specifications pose major challenges. The purpose of this thesis is to examine the inconsistencies ...