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

noSQL Use Case for PLM

noSQL Use Case for PLM
olegshilovitsky
olegshilovitsky
15 September, 2010 | 2 min for reading

I had a chance to read SQL vs. noSQL article in Linux Journal yesterday on the plane. I found it interesting and despite a bit up-level of a technical terms, beneficial for our PLM discussion. Navigate your browser on the following link and read this paper. The noSQL story is probably one of the most dramatic in the modern history and present of data management. It considered as a heretic in the early beginning. Now noSQL comes to the point when we can talk about real advantages and disadvantages of both usage – traditional SQL and noSQL databases. So, what is the noSQL story is about?

SQL and RDBMS predictability

The story of SQL databases is very tight connected to two definitions: RDBMS and ACID. ACID means Atomicity, Consistency, Isolation, Durability. RDBMS – Relational Database Management Systems. The story about RDBMS, SQL and ACID is a story about development of transactional systems. If you develop a financial system, you want your system be predictable. You cannot take a guess about what is going on in your financial records. The same is when you schedule your manufacturing shopfloor operations. ERP leveraged RDBMS systems heabvily in their history. A vast majority of ERP systems today based on SQL /RDBMS systems.

noSQL Case

The noSQL came to us from the internet examples of the past decade such as Google, Amazon S3 and others. The fact, modern internet kids are using it added additional flavor of importance. However, what is the real case behind? Instead of using relational tables and keys, the modern noSQL databases are using simple "key-value" stores. Each piece of data going to the database is given a key and key be easy retrieved back using the same key. This portion of simplicity provides a significant value. The step beyond key-value is to have "document stores" that can access documents according to the specific key values.

PLM Use Case

Product Lifecycle Management has traditional roots in SQL databases. Started as pure data management discipline, PDM and PLM systems came to compete with other enterprise systems. It was an obvious decision back in late 1980s and beginning of 1990s that to establish a full data control you need to manage your data using RDBMS. However, this decision was taken time ago. Since then, PLM developed lots of use cases. These use cases can bring an importance of predictability down and importance of flexibility and simplicity up.

What is my conclusion? Development of PDM and PLM systems is not a simple case. The complexity of systems is high. However, some fundamental decisions and architectures of PDM/PLM were laid about twenty years ago. The urgency of reducing complexity and flexibility in PLM architectures can raise a noSQL case for PLM. Just my opinion…

Best, Oleg

Recent Posts

Also on BeyondPLM

4 6
17 May, 2016

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

14 February, 2014

Product Data Management (PDM) is not a new buzz. Lots of things where written and spoken about how to manage...

25 November, 2013

Collaboration is still one of the hot topics in PLM space. I was watching PLM TV report about Dassault’s 3DEXPERIENCE...

11 June, 2023

Simplicity and simplification is one of my favorite topics. When it comes to product lifecycle management (PLM), product data management,...

19 May, 2009

Look on announcement of Wolfram Alpha: Today’s Wolfram Alpha is the first step in an ambitious, long-term project to make...

15 July, 2009

Short prompt this morning. What do you think about Information Visualization in 3D? Do you see future in this way...

26 March, 2010

COFES 2010 is just around the corner, and I had chance to discuss with Brad Holtz of Cyon Research the...

19 August, 2011

Google-Moto deal created a lot of fuss and speculation. At the same time, it created an example of cross-domain innovation,...

13 July, 2016

Historically, a business model of CAD, PDM and PLM vendors was to sell “seats”.  To sell CAD seats was a core...

Blogroll

To the top