A blog by Oleg Shilovitsky
Information & Comments about Engineering and Manufacturing Software

Product Data Cleanup Importance

Product Data Cleanup Importance
Oleg
Oleg
18 July, 2013 | 2 min for reading

There is one project in data management everybody tries to avoid: legacy data import. It’s one of the most complicated, time consuming, and painful aspects of any PDM and PLM deployment. Importing data usually lead to lots of problems – how to clean data, how to important data, how to map data to existing systems. Enterprise system developers are spending tons of money implementing different import tools.At the end, service provider and/or VAR is taking “legacy data import” project to implementations.  Unfortunately, it costs money and time. Company in data management and content processing tool are paying attention to this problem too.

My attention was caught my ITProPortal – “HP Autonomy Launches Legacy Data Cleanup Software for Improved Info Governance.”  Autonomy is a software outfit developing content processing, search and other data-related applications. Pay attention to software called Legacy Data Cleanup. It helps to arrange, classify and clean data. Here is an interesting passage:

“Legacy data is sometimes called ‘dark data,’ as it is effectively wasted space on limited storage, forcing organizations to buy more storage and hindering the modernizing of infrastructure and the transition to the cloud. This data includes obsolete SharePoint sites, old email stores, and a variety of other files that no longer serve any function. “The Legacy Data Cleanup solution helps businesses identify this unnecessary data and remove it responsibly, leaving an audit trail behind to meet company data retention policies. It can also help with the establishment of a records management system, which offers improved access to and more efficient legal holds on old data.”

Product data has lots of diseases – bad classification, broken references, mistyped fields, missed files and many others. Existing import tools are not very efficient and require to clean data before it can be imported. I can see an emergent trend of data tools that can help to bring data into new enterprise systems without cleaning and later to provide service that will make data available and cleaned. Some of the operations can be automated and some of them will require additional user work. However, I believe the last one can be minimized within time.

What is my conclusion? Most of manufacturing companies have data problem. Legacy data lives in many places – customer hard drives, old enterprise data management systems, Excel spreadsheets and Access databases. To be able to extract this data and move on with a new system, new data management components need to be development. First, they will scrap all data, then classify and prearrange this data for customer use. The result – lower cost, faster implementation. Just my thoughts…

Best, Oleg

Recent Posts

Also on BeyondPLM

4 6
6 September, 2023

For the first time after COVID, I’m coming to the City By The Bay to attend Autodesk DevCon 2023. For...

28 January, 2024

3DEXPERIENCE World, formerly known as SolidWorks World, doesn’t require much introduction among the design and manufacturing communities. It is the place to...

23 March, 2014

The world around us is very disruptive these days. Nothing stands still. You cannot stop innovation and progress. Engineering and...

13 July, 2015

The number of hardware companies is growing and products are getting more complex.The nature of every hardware project is very...

1 July, 2023

In the fast-paced world of manufacturing business, staying ahead of the competition requires efficient management of product development, manufacturing, and...

17 February, 2019

I’m continuing to digest and share information about what I’ve seen last week at Solidworks World 2019 in Dallas. Today...

7 August, 2012

Cloud PLM, Social Collaboration, 3D Experience, Consumerization… If you are breathing the air of design, engineering and manufacturing technologies and...

2 June, 2019

I’m on my way to attend IDE 2019 Summer School at Southern Italy. The theme of the IDE 2019 is...

10 September, 2018

I’m coming to ConX18 conference next week organized by Institute of Process Excellence.  Here is what you can learn about...

Blogroll

To the top