6.2. Geoscience Use-Cases
In the Geoscience sector, TM has been used by a number of companies to address a wide variety of industry data models, OpenWorks™, Finder™, Seabed™, REM, WITSML™. Significantly, TM is now incorporated as an embedded product in Schlumberger’s ProSource™ Transformation Manager product and has been chosen as a transformation technology by two major oil companies.
In a recent project, TM has been used to transfer data to a Seabed Data Warehouse from legacy data stored in a Microsoft Foxpro REM database. This data related to the borehole activities when installing and maintaining well equipment: pumps, sensors, protectors, valves etc. The transfer of data was initially populated (bulk load)and thereafter maintained in synchronism (incremental update) as data changed in REM.
The REM Foxpro database has 36 tables and Seabed 650 tables and the data migration requirement consisted of both fairly sizeable movements of data and quite complex transforms writing to a highly normalised and sophisticated cooperate data store. The migration was split into a number of phases and in total over 50 tables containing various complex relationships in Seabed were populated. In phase 1 over 8000 records were written, in phase 2 over 700,000 records, and in the final phase over 3,500,000 records were written. During the data migration a reference table is populated containing over 5,500,000 records maintain ing the relationship between REM records and Seabed records. During this project, the performance and scalability of transforms created using Transformation Manager proved of significant value.
In order to manage petroleum production and discovery at a strategic level it is essential to have an integrated view of the systems design information with the associated current and historical technical data. The example use-case above is one example of bringing data together from sources such as Well Logs, Telemetry and pipeline engineering, which all have data in of various formats. At the process level it is necessary to make data available to those involved with day to day control, and typically, some of this data will be derived from multiple sources and will be sent to a suitable presentation platform. These requirements demand a flexible approach to building transforms and TM is designed for maximum flexibility, with support for most relational databases, XML and Java as standard. In addition, TM has an extension mechanism by which other structured file formats can be handled. Additionally, applying TM to projects such as these, where transfer of well logs and seismic data require greater volumes of transfer, ensures that TM provides significantly enhanced performance and scalability features.
