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:

Asset Active Inactive
Process Units 220 15
Equipment 3753 3293
Systems 2763 111
Relief Valves 3871 5387
Inspection History 144860 0
Piping - Systemized 15206 -
Piping - NOt Systemized 4022 -
Piping Out of Service 1303 -
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

Related Knowledge

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 - Ensuring the Transition from Construction to Startup to Operations and Maintenance

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 Delivered, Confidently, Comprehensively and Quickly. An AOC & Intergraph RBI Solution

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)

From Fitness for Service to a Reliability-Based Mechanical Integrity Program - A Journey from the Ashes to Sustained Reliability (RMC-10-30)

An upgrader is brought safely back into production a year ahead of expectations, avoiding an opportunity cost exceeding $300 million.

Risk Based Asset Management - Delivering and Sustaining Value Across a Mid-Sized Refining Enterprise (RMC-09-45)

The business case developed for an RBI program - realized benefits and how the on-going value of the program is measured

Related Services

Mechanical Integrity Assessments

An interdependent assessment of your people, process, and technologies for a confident path forward

Operational Readiness and Maintenance Strategy Development

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

Master Data Management and Data Conversion

Innovative technology that allows quick, efficient extraction of data into a knowledge-centric world

RBI Implementation and Inspection Planning

AOC has delivered thousands of sustainable RBI programs earning the trust of owner operators.

Reliability Based Asset Management - AIM for all asset families

Asset Integrity Management for all asset families - Rotating, Electrical, Instrumentation, and Fixed Assets

Related Training

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?

Managing and Sustaining an RBI program using RBMI

How do I manage and sustain my MI/RBI program using RBMI software?

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 Concepts - Return on Net Assets (RONA)

Asset Integrity Management – how you perform at the plant level affects those goals set at the board room

Value Proposition

Developing the value proposition and business case for an RBI program

The Meridium MI Suite

How to achieve an end to end RBI program in less than six months

Calculating the Value Contribution

How does your AI program meet your RONA goals?