Accession Number:

ADA361583

Title:

A Relational Database Model and Data Migration Plan for the Student Services Department at the Marine Corps Institute

Descriptive Note:

Corporate Author:

NAVAL POSTGRADUATE SCHOOL MONTEREY CA

Personal Author(s):

• Slaughter, Aaron T.

Report Date:

1997-09-01

Pagination or Media Count:

282.0

Abstract:

Todays business environment in the Depattment of Defense DoD demands that managers possess a clear understanding of the design, implementation, and maintenance of the databases used to store, organize, manipulate and return data. In response to shoncomings identified in their current legacy information system, the Marine Corps Institute MCI initiated a project to migrate from a file processing database system to a relational database using a clientserver system based on an open hardware and software architecture. This research provides a relational data model and migration plan in response to MCIs request. It investigates data modeling and database design using the Integration Definition for Information Modeling IDEFiX methodology and the relational model. It also addresses the migration of data and databases from legacy to open systems. The application of the IDEFiX model, supported by CASE tools to facilitate data modeling and database maintenance, reveals strategies for dealing with the complex issues of database design, migration, and maintenance in DoD.

Descriptors:

• *DATA PROCESSING
• *MODELS
• *MIGRATION
• *MARINE CORPS FACILITIES
• *RELATIONAL DATA BASES
• FILES(RECORDS)
• MAINTENANCE
• COMMERCE
• ENVIRONMENTS
• INFORMATION SYSTEMS
• STUDENTS
• TOOLS
• PROCESSING
• COMPUTER ARCHITECTURE

Subject Categories:

• Computer Systems

Distribution Statement:

APPROVED FOR PUBLIC RELEASE