Multimedia Database Management System

(C. Asiala, J Wood)

As part of this project, a system based on CD-ROM technology was developed to track and report progress and to serve as a data repository. After evaluating the pros and cons of using commercially available software versus "home grown" it was decided to use the commercial software package Toolbook from Asymetrix. In this document, we refer to this as the ToolBook Database Management system or TDM. Some advantages of using commercially available software include superior data handling and archiving, as well as attractive visual displays. In addition, documentation, tutorials, software support, and upgrades will all be taken care of by a commercial vendor.

Maps of the southern San Joaquin Valley oil fields and the Pioneer area are in the database, as well as core photos, core data, thin section photomicrographs, and SEM photomicrographs. Regional location maps of southern San Joaquin Valley oil fields and structure contour maps of the Pioneer Anticline were also scanned into the ToolBook Database Management (TDM) as well as structural cross sections through Pioneer Anticline, an atlas of photomicrographs illustrating typical diagenetic features observed in San Joaquin Valley petroleum reservoirs, elemental and spectral data collected on Fourier Transform Infrared Spectroscopy (FTIR) standards, and all quarterly and annual reports submitted to DOE for this project. All data and information are accessible through drop- down menus and hotlinks in a Table of Contents. A tutorial is presented up front to guide users through the TDM and instruct them on the various ways in which data can be viewed and retrieved. The TDM will be written to a CD ROM at the end of the project.

All measured log curves for all the project wells on Pioneer Anticline are in the TDM in LAS (Log ASCII Standard) fonnat, and are stored in a Microsoft Access file on the CD ROM. These data can be exported to log evaluation programs for manipulation and analysis. Computed log curves (curves representing parameters such as porosity, water saturation, and clay content, calculated from the measured log traces using specially developed algorithms) were translated from LBS (Log Binary Standard) format before being input to the TDM.

Special queries were developed in Microsoft Access that enable the user to easily retrieve these logs from the CD ROM. Any desired log curve can be located using queries and then exported from the CD ROM to Access tables created on the computer's hard drive. Once in the Access tables, log curves can be manipulated or transferred to log evaluation packages such as GeoGraphix's QLA2 or Crocker's Petrolog program for analysis and plotting. Access provides a log database which is independent of all of specific well-log evaluation programs (Crocker Petrolog, GeoGraphix QLA2, and TerraSciences TerraStation), but is capable of exporting data to any one of them.

A preliminary CD ROM (Version 1.0) is included in the workshop notes and contains the TDM as well as all the log files in LAS format. In Version 2.0, which will be completed by the end of 1996, additional data will be added and explanatory text will be written for each topic and data set. Version 2.0 will also contain the project Geographix files. Appendices 1 and 2 provide more detailed information on how to use the TDM system and the Mcrosoft Access log database.