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

PLM, RDBMS and Future Data Management Challenges

PLM, RDBMS and Future Data Management Challenges
Oleg
Oleg
4 January, 2012 | 3 min for reading

It is not unusual to hear about problems with PLM systems. It is costly, complicated, hard to implement and non-intuitive. However, I want to raise a voice and speak about data management (yes, data management). Most of PDM/PLM software is running on top of data-management technologies developed and invented 30-40 years ago. The RDBM history is going back to the invention made by Edgar Codd at IBM back in 1970.

I was reading Design News article – Top automotive trends to watch in 2012. Have a read and make your opinion. One of trends was about growing complexity of electrical control units. Here is the quote:

As consumers demand more features and engineers comply, automakers face a dilemma: The number of electronic control units is reaching the point of unmanageability. Vehicles now employ 35 to 80 microcontrollers and 45 to 70 pounds of onboard wiring. And there’s more on the horizon as cameras, vision sensors, radar systems, lanekeeping, and collision avoidance systems creep into the vehicle.

It made me think about potential alternatives. Even if I cannot see any technology these days that can compete on the level of cost, maturity and availability with RDBMS, in my view, now it is a right time to think about future challenges and possible options.

Key-Value Store

These types of stores became popular over the past few years. Navigate to the following article by Read Write Enterprise – Is the Relational Database Doomed? Have a read. The article (even if it a bit dated) provides a good review of key-value stores as a technological alternative to RDBMS. It obviously includes pros and cons. One of the biggest “pro” to use key-value store is scalability. Obvious bad is an absence of a good integrity control.

NoSQL (Graph databases)

Another interesting example of RDBMS alternative is so-called noSQL databases. The definition and classification of noSQL databases is not stable. Before jumping into noSQL bandwagon, analyze the potential impact of immaturity, complexity and absence of standards. However, over the last 1-2 year, I can see a growing interest into this type of technology. Neo4j is a good example you can experiment with in case you are interested.

Semantic Web

Semantic web (or web of data) is not a database technology. Opposite to RDBMS, Key-value stores and graph databases, semantic web is more about how to provide a logical and scalable way to represent data (I wanted to say in “semantic way”, but understand the potential of tautology  :)). Semantic web relies on a set of W3C standard and combines set of specification describing ways to represent and model data such as RDF and OWL. You can read more by navigating to the following link.

What is my conclusion? I think, the weak point of existing RDBMS technologies in the context of PLM is a growing complexity of data – both from structural and unstructured aspects. The amount of data will raise lots of questions in front of enterprise IT in manufacturing companies and PLM vendors. Just my thoughts…

Best, Oleg

Recent Posts

Also on BeyondPLM

4 6
28 May, 2021

Part Numbers. There is no topic that drives more attention when it comes to discussion about how to organize the...

27 July, 2013

Web as a platform. You can hear many conversations about that nowadays. Started as cloud talks, it comes more to...

18 June, 2019

Unless you’ve been living under the rock for the last decade, you’ve heard about open source software, hardware or anything...

15 November, 2012

Integration is a tough job. Especially when it comes to the enterprise software. The typical manufacturing company landscape is siloed...

14 July, 2011

I want to talk today about data sharing. The interest of engineers and other people in manufacturing organization in data...

17 August, 2009

I’d like to follow few very interesting discussions that happened last week. Few blog posts you probably want to read...

6 September, 2010

I decided to make an unusual post today. Because of holiday (Labor Day in USA), I spent most of the...

17 May, 2016

Few weeks ago I posted a story about cloud CAD and Dropbox Infinite Project. Apparently it was not only me...

22 August, 2011

Cloud and Security. I hope I’ve got your attention a bit :). In 99% of my talks about PLM and...

Blogroll

To the top