Railroad

MAJOR U.S. RAILROAD COMPANY

THE BUSINESS NEED

Database administration and support services

THE SPI SOLUTION

Data modeling, logical design, mapping to the physical model, physical design & implementation, backup recovery and disaster recovery.

OVERVIEW OF THE PROJECT

SPI's database administrators were involved in the activities of the clients' DBA group which was responsible for all the data activities of the company related to existing and future Database Management System (DBMS). These activities included the following:

  • Data modeling and logical design.
  • Mapping to the physical model.
  • Physical design and implementation.
  • Back up and recovery.
  • Disaster recovery.
    • Database object maintenance.
    • Database tuning.
    • Database monitoring.

All these activities were supported by DB2 and DL/I on the Mainframe, Oracle and UDB on the Mid tier.

SPI participated in the development of standards for these environments which needed to be adhered to by all the database developers.

SPI was also assigned to support specific application development groups that in turn supported specific business functions. The data model was maintained using the Erwin software package.