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

What is the right data model for PLM?

What is the right data model for PLM?
Oleg
Oleg
17 August, 2012 | 3 min for reading

I think the agreement about importance of the data model among all implementers of PDM / PLM is almost absolute. Data drives everything PDM / PLM system is doing. Therefore, to define the data model is the first step in many implementations. It sounds as something simple. However, there is implied complexity. In most cases, you will be limited by the data model capabilities of PLM system you have. This is a time, I want to take you back in history.

Spreadsheet Data Model

Historically, it became the most commonly used data model. And the reason is not only because Excel is available to everybody. In my view, it happened also, because tables (aka spreadsheets) is a simple way to think about your data. You can think about table of drawings, parts, ECOs. Since almost everything in engineering starts from Bill of Material, to think about BOM table is also very simple. The key reason why in many cases spreadsheet model became so wide-accepted are simplicity and absolute flexibility. Engineers love flexibility, and this data model became widely popular.

Relational Data Model

This data model was developed by Edgar Codd back more than 50 years ago. Database software runs on top of this model, and we got what known today as RDBMS. Until second half of the last decade, it was the solution all PDM /PLM developers were relying. First PDM systems were developed based on RDBMS. However, they had low flexibility. Because of rigorous rules of this model, making changes was considered as not a simple task. One of the innovations of late 1990s was to develop a flexible data model as an abstraction on top of RDBS. Almost all PDM/PLM systems in production today are using object abstractions developed on top of the relational data model.

The challenges of Spreadsheets and Relational Databases

Despite these technologies are proven and used by many mainstream applications, it is far from perfection. One of the product development demands is flexibility. Spreadsheet model can deliver that, but gets very costly within the time. Relational data model can combine flexibility and support manageability of data. However, it becomes to make a change in these models is costly. Identification, openness and expandability is problematic in relational data models opposite to some other web-based solutions.

Future data models – NoSQL, RDF, etc.

Thinking about what comes in the future, I want to spell to buzzwords – NoSQL and Semantic Web. I can see a growing amount of solutions trying to adopt a variety of new data platforms. NoSQL comes to the place as an alternative solution to Relational Database. If this is a first time you’re hearing this buzzword, navigate to the following Wikipedia link. NoSQL is not all the same. It combined the whole group of solutions such a key-value stores, object databases, graph databases, triple store. Semantic web is collaborative movement led by W3C. The collection of Semantic Web technologies (RDF, OWL, SKOS, SPARQL, etc.) provides an environment where application can query that data, draw inferences using vocabularies, etc. Part of these standards something called Linked Data – a collection of data set in open formats (RDF) that shared on the web.

What is my conclusion? Many of the technologies used by PLM companies these days are outdated and came from the past 20-25 years. There is nothing wrong in these technologies. They are proven and successfully used for many applications. However, in order to achieve the next level of efficiency and embrace future of PLM, new horizons need to be explored. Data flexibility, openness and interoperability – these elements are absolutely important in the future of PLM. Options to use future data models coming from past 10 years of web experience need to be explored. Important. Just my thoughts…

Best, Oleg

Image: FreeDigitalPhotos.net

Recent Posts

Also on BeyondPLM

4 6
26 July, 2024

Recently, I had a growing number of discussions about what future holds for PLM-ERP integrations. Here are a few article...

26 April, 2017

Manufacturing is under going tremendous transformation process. Build to order, speed and engagement with consumer are most important competitive factors....

26 October, 2009

Do you know how companies are making decisions about their PLM related strategies? I don’t… Each time I see this...

25 February, 2014

Metadata is “data about data”. If you stay long with PDM industry, you probably remember how earlier EDM/PDM software defined...

29 December, 2014

Mobile is one of the strongest trends in technology and business these days. I keep following technology and business events...

15 September, 2009

In the past, I already discussed many cloud-related topics. Today, I want to get “down to the earth” and ask...

26 June, 2017

Five Ways Product Design Teams Fail at Data Management article by Engineering.com brings results of survey Engineering.com did to learn about...

18 June, 2009

Short note following Devon Sowel blog about SolidWorks on Cloud/SaaS plans. This is good continutation to thoughts and discussion started...

23 September, 2009

I’d like to discuss RIA today. RIA – Rich Internet Applications are web applications that have most of the characteristics...

Blogroll

To the top