Data Mining, Management, and Migration

Sometimes moving millions of data fields from ten different databases to another seems like trying to get a thousand birds to leave the branches of one tree and land on just the right branches of another.

Data mining, management, and migration

Data Migrator facilitates a data mining work process for:

  • Setting up asset specific electronic data files including U-1 forms and/or fabrication drawings. In other words, a methodology for expeditiously converting your asset information from a docu-centric environment to a data-centric environment allows you to look at your asset data from anywhere in the world.
  • Once the scanning process is completed, the electronic files are organized by equipment type (columns, towers, air coolers, heat exchangers, etc) and piping equipment files, including the systemized and circuitized P&IDs as well as specific files for each piping circuit. An example of the electronic data files include but are not limited to:

    • As-built drawing
    • P&IDs
    • Manufacturer's drawings
    • Installation drawings
    • Arrangement, tube layout, and logic drawings
    • Basic equipment design information
    • Original specification sheet
    • Calculations for sizing the relief device
    • Shop testing or calibration record (for relief valves and conservation vents)
    • Fabrication data
    • Acceptance test results
    • Manufacturer's operating and maintenance instructions
    • Parts list
    • Operating information
    • Operating certificate when required

A facility with, say, 400 pieces of fixed equipment, 800 piping circuits and 400 PRDs takes less than three months to complete.

In many cases, owners are initially happy to have their asset data available electronically; however, converting this data to knowledge is a much easier next step as can be seen from the following case study. A southern California refiner was transitioning from one IDMS (inspection data management system) to a corporate RBI program. Over twenty million data fields had to be moved from one data base to another. The total number of assets being converted was as follows:

Process Units22015
Relief Valves38715387
Inspection History1448600
Piping - Systemized15206 -
Piping - NOt Systemized4022 -
Piping Out of Service1303 -
Piping Inactive - 2669

Another major concern of the owner was the cost of renewing the older IDMS license which was considerable and in excess of several million USD. Given a time frame of less than six months to complete the transition and successfully complete UAT (User Acceptance Testing) of the target RBI database, AOC consultants utilized the data migrator tool from StarThrower Software, to expedite the data mining process and cleanse the data prior to exporting to the target IDMS SQL database. The project was completed in five months saving the owner millions in renewed licensing costs. For additional information on this case study please contact us.

AOC Data Collection Work Process and Import Utility

Case Study Inquiry

Related Services

Risk Based Inspection (RBI) Implementation and Planning

AOC has delivered thousands of sustainable Risk Based Inspection (RBI) programs earning the trust of owner operators.

Operational Readiness and Maintenance Strategy Development

Development of maintenance strategies, recommendations, and plans to implement best practices and increase asset life

Related Training

Meridium Mechanical Integrity Work Process Training

How do I use Meridium to perform MI/RBI tasks?

Risk Analyst Training for Meridium RBI

How does Meridium RBI software estimate risk?

RBI Work Process Using RBMI

How do I use RBMI to perform MI/RBI tasks?

Risk Analyst Training for RBMI

How does RBMI software estimate risk?

Related Knowledge

Risk Analysis: Good In, Good Out - A Risk Analyst's View

Reflections on the importance of ensuring your data is accurate and on the impact that having poor data can have on your risk analysis.

Risk Based Inspection Yields Big Savings for Gulf Coast Plant

A 26-Year-Old Gulf Coast Chemical Plant Saves over $15 Million in Related Inspection Activities.

RBMI Implementation Saves Refinery $63 Million

130,000 BPD Refinery Implements RBMI Program and projects a $63 Million savings over 10 years.

Corrosion Under Insulation (CUI) in Plant Equipment and Piping

Implementation of a managed CUI program yields prioritized inspection plans and identifies imminent failures.

Safe Operation of Aging Hydrogen Generation Plants

Integrating DMR, RBI, and IOWs to manage aging plant reliability

The MI Assessment - Understanding Your Mechanical Integrity Goals

Compliance? | Best Practice? | Risk Reduction? | One Step at a Time? | Capture Personnel Knowledge? | All Of The Above?

Operational Readiness: Construction, Startup, Operations and Maint.

Design basis RBI? Why not optimize all your asset families prior to RFSU?

Production Loss Accounting - Heat Exchanger Bad Actor Analysis

Heat exchanger failures contribute to over $146M in losses for a large refining enterprise.

Time to Value - Asset Integrity Management

Delivering knowledge based asset files from the true sources of data - confidently, accurately, electronically, and in half the time.

Implementing RBI in Remote Locations

The importance of understanding risk and the significant value attainable through the implementation of risk based inspection (RBI)