The Data Migration project was set up in order to migrate the ODP legacy data from its current diverse format files into the new Oracle JANUS database. Obviously, the data migration work depends on successful completion of the JANUS data model. The data model for User Group 1 (Corelog, Sample, Drilling, and basic Leg, Site, Hole) was completed by Tracor in July 1996. Since then the Corelog and Sample S1032 data attributes have been mapped into the JANUS data model, SQL scripts have been written to migrate those data, and some data migration to a TEST database has been accomplished.
The actual migration of these data will proceed after the JANUS system becomes operational on the ship (planned for Leg 171B). The data model for User Group 2a (MST), User Group 3 (physical properties), and User Group 4a (chemical properties) data is being worked on by Tracor and is likely to be completed before the JANUS system becomes operational. The Information Services Department plans to prepare a Request For Proposals (RFP) and select subcontractor(s) to migrate those data to the JANUS database.
[ Contents of the Semiannual Report, No. 2, June-November 1996 |
| Program Updates | New Initiatives | Project Summaries | Laboratory Working Groups |
| Panel Recommendations | Appendixes |
| Semiannual Report, No. 1, December-May 1996 ]