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

Why New Database Technology Won’t Solve PLM Problems?

Why New Database Technology Won’t Solve PLM Problems?
Oleg
Oleg
18 March, 2013 | 3 min for reading

Disruptive technologies and solutions. This is beloved topic by bloggers, analysts and vendors. We like to talk about how disruption will happen. For very long period of time, database technology was a stable element in the overall PDM/PLM technological architecture. The decision about usage of relational database was only about how to choose between Microsoft SQL, Oracle DB and IBM. However, recently, I started to hear voices about changes that might happen in the world of databases. I’m sure you’ve heard about noSQL. If not, you can catch up via this link – What PLM vendors need to know about noSQL databases? The question about the ability of noSQL or other alternative to SQL solution to disrupt PLM development and products is an interesting one. Yoann Maingon of Minerva is asking this question in his blog post – New database system for future of MDM. Yoann declares database as one of the inhibiting factors preventing users to move from one PLM solutions to another. Here is an interesting passage –

I hope the actual economy environnement will convince more people to invest time for helping the product development initiatives by solving Product Lifecycle Management related pending issues. Today’s article is about my thought on why it is always so complicated to move from a PLM solution to another, why are we changing tons of things and settings to in fact change a software cost or an interface. On of the reason is that all these elements are strictly related and the elements in a PLM solution can’t be dissociate. You can’t just keep you data and change the interface. From my previous experiences of migration, I’ve realized that I was moving data from a system to another with transformations but the data would still mean the same thing it is just that the software would handle it differently. Then speaking of standards would there be a standard for data management in PLM and should this define a technology or at least should it drive database system editors to push for one?

I’m in a bit disagreement with Yoann. In my view, all SQL, noSQL, XML and many other database flavors are providing an infrastructure that can be used in different ways. Yes, there are differences between noSQL and SQL databases. However, if we speak about building applications, the way application created will provide a much more significant factor on the efficiency and behavior of your application. Earlier this year, I’ve seen an interesting article, which focus on this specific question – NoSQL or Traditional Databases: Not Much Difference. Take you time and read it. You find it very educational. I absolutely liked the following passage –

I have spent considerable time tuning SQL statements and indexes, but in the end the best optimizations have always been those on the application and how the application uses the database. SQL Tuning almost always adds complexity and often is a workaround over bad application or data structure design. In the NoSQL world “SQL statement” tuning for the most part is a task of the past, but Data Structure Design has retained its importance! At the same time logic that traditionally resided in the database is now in the application layer, making application design even more important than before. So while some things have shifted, from an Application Performance Engineering Perspective I have to say: nothing really changed, it’s still about the application. Now more than ever!

What is my conclusion? No surprises. It is all about your application – logic, tuning, performance, mistakes and ability to create a reliable and efficient solution. Yes, different database techniques are requiring different technical skills. But if you have them, your ability to build PLM system on any of these platform will be almost identical. Just my thoughts…

Best, Oleg

Recent Posts

Also on BeyondPLM

4 6
27 January, 2017

Unless you lived under the rock for the last few years, you’ve heard words IaaS, PaaS and SaaS at least...

26 July, 2019

Standards are like toothbrushes, a good idea but no one wants to use anyone elses. The history of engineering and...

26 June, 2012

BAM. BAM. BAM. Social Enterprise. Do you think, it is about magic words? No, I don’t think so. If you...

28 April, 2015

The last decade changed  many things in our everyday life. It is hard to imagine, but just think about few...

22 March, 2018

I was invited to speak at Develop3D Live 2018 about Data Management. If you followed my blog earlier, you might...

5 November, 2019

A single version of the truth is one of the most powerful PLM paradigm development for the last two decades....

21 December, 2010

I found an interesting article in San-Francisco Gate about Dashboards- “Introducing Netvibes Dashboard Intelligence Solutions: Business Intelligence Reinvented for the...

14 July, 2010

My new website and blog is BeyondPLM. The original post is here. Social is trending these days. We can see...

24 November, 2014

The days of ugly UI are in the past. The trend that started from website design, mobile UI and intuitive...

Blogroll

To the top