db-engines.com : selecting your data storage layer
Data is the essence of most applications and this is particularly true for PLM. How you store the data is a key aspect of your PLM application. It will define how much data you...
Filter by Category
Filter by Author
Data is the essence of most applications and this is particularly true for PLM. How you store the data is a key aspect of your PLM application. It will define how much data you...
Posted by Yoann Maingon
Looking at the picture you can tell that I am in the NYC area to attend GraphConnect 2018. GraphConnect is a major conference organized by Neo4J, the graph database. During a bit...
Posted by Yoann Maingon
The lock mechanism is a key element in all collaboration software. It’s the little button that allows to make sure you are the only one editing an item. usually locking an...
Posted by Yoann Maingon
I’m always surprised to see how low the PLM adoption is. I have been in this industry for almost 10 years and I’m still entering meetings when most people are not...
Posted by Yoann Maingon
Welcome to this new blog about PLM. This is not my first PLM blog and this is definitely not the first blog about PLM. So why do I think it adds value to launch this blog? I think...
Posted by Yoann Maingon
Data is the essence of most applications and this is particularly true for PLM. How you store the data is a key aspect of your PLM application. It will define how much data you can store, how it will scale, how fast you will be able to retrieve complex nested data, are you even able to find the information that might be of interest,… The selection of a single database engine comes with trade-offs. The selection of a single database prevent you from getting the best of multiple technologies and architecture,… unless… you do not just select a single database system.
Sometimes you may not know it but, whenever you have an advanced search engine, you are very likely to use a data store which will contain an index. Then multi data store technologies exists but is usually not much advertised with the selling point that different databases may server different use-cases within the same PLM context.
You may have only work with relational database. SQL server or Oracle are the only engines you have worked with? Why would you use anything else? Well because we haven’t found one single architecture that excels in every context. Here is a list of all the database categories that exist out there:
[eckosc_column_container count=”two”]
[eckosc_column_item]
[/eckosc_column_item]
[eckosc_column_item]
[/eckosc_column_item]
[/eckosc_column_container]
This is one of the main information you can take from db-engines.com, the popularity of a database will give you some good information about how much people believe an engine is good and how much people could work and maintain the solution ecosystem.
After focusing on different database types and their best domain of expertise. Let’s focus on SQL and Graph champions
So now you know you may have document index and SQL supporting your very inter-connected PLM environment, and you may be wondering how you could get value from a graph database. From what I have seen at Graphconnect, most of the usage of graph databases is more a BI and analysis usage. Companies have their data in a few systems that are usually storing data in SQL or document db and they create a big graph from this in Neo4j. By using the correct pipeline they can live update the data in the graph from the other system and enjoy the graph queries on fresh data. So this would be the first way to do it. I will detail in a future post the pros and cons of most database technologies to help you evaluate what tech might be of interest for storing your data.
Anyway, for now I just wanted to share with you this great website https://db-engines.com which allows you to stay in touch with the latest trends in database technologies.
There is a debate on cloud PLM stack. Some would argue that cloud PLM = SaaS PLM = Multi-tenant. Any discussion on this topic becomes quickly technical and looses 80% of the...
One of the characteristics of PLM is the need for flexible data models. You can argue that and tell me that everyone should follow standards so you don’t have to build your...
Don’t miss any post by subscribing