Data Migration and Translation – Part 1

Data Migration and Translation – Part 1

What is data migration and translation? Here is a definition that will help:

  • Information exists in different formats and representations. For example, Egyptian hieroglyphics are a pictorial language (representation) inscribed on stone (format)
  • However, information is only useful to a consumer in a specific format and representation. So, Roman letters printed on paper may mean the same as an equivalent hieroglyphic text, but the latter could not be understood by a English reader.
  • Migration moves data between formats – such as stone to paper
  • Translation moves data between representations – hieroglyphics to roman letters

What must a migration and translation achieve?

  • The process preserves the accuracy of the information
  • The process is consistent

In the PLM world, the requirement for data translation and migration arises as the result of multiple conditions. Examples of these include changes in technology (one CAD system to another CAD system), upgrades to software (from one level of a PLM system to later version), combination of data from two different sources (CAD files on a directory system with files in a PDM), acquisitions and mergers between companies (combine product data) and integration between systems (connect PLM to ERP).

However, migrations and translations can be fraught with problems and require considerable effort. Here are some reasons:

  • Systems and formats are completely incompatible and have no common basis. This is normally the case when dealing with technology from two different vendors
  • Organizations have no experience with translations and migrations and are unsure of the optimum way of solving the problem
  • Data quantities can be extremely large, especially for companies and organizations with long histories
  • Data quality can be questionable. Common problems include duplicate parts, incorrectly labeled and named properties
  • Effort and cost to effectively complete a migration can be beyond ordinary operating budgets
  • Ongoing business activity and production deadlines consume all resources who then cannot spare the time to complete the task
  • Potentially, a botched migration or translation can result in the loss of company IP and vital data
  • Because some level of translation is always required, organizations put together “Band-aid” or purely manual solutions

Thankfully, there are solutions to these problems and a structured and systematic approach will allow for a complete solution. Part 2 of this series is coming soon.

Kevin Power

Business Development Manager at Tata Technologies
Kevin has worked as a solution architect, account executive and electrical engineer with Tata Technologies over the last fifteen years. During this time, he was involved with the implementation of various CATIA v5 deployments for customers in the automotive and aerospace industries. He has taught CATIA and PLM topics to a wide range of students and authored many methodologies and best practices for clients. Kevin currently manages the business development team.

Leave a Reply

Your email address will not be published. Required fields are marked *

© Tata Technologies 2009-2015. All rights reserved.

Kevin Power

Business Development Manager at Tata Technologies
Kevin has worked as a solution architect, account executive and electrical engineer with Tata Technologies over the last fifteen years. During this time, he was involved with the implementation of various CATIA v5 deployments for customers in the automotive and aerospace industries. He has taught CATIA and PLM topics to a wide range of students and authored many methodologies and best practices for clients. Kevin currently manages the business development team.