plm and data management in 21st century
DESCRIPTION
My presentation at TechSoft3D Tech Talk event in Boston.TRANSCRIPT
![Page 1: PLM and Data Management in 21st Century](https://reader034.vdocuments.us/reader034/viewer/2022051816/54572a70b1af9fc15d8b47f4/html5/thumbnails/1.jpg)
PLM and Data Management in 21st Century
Oleg Shilovitsky
![Page 2: PLM and Data Management in 21st Century](https://reader034.vdocuments.us/reader034/viewer/2022051816/54572a70b1af9fc15d8b47f4/html5/thumbnails/2.jpg)
Database selection back in 1990s…
Start Looks like Document?
Use Microsoft Office
Use RDBMS
End
Yes
No
![Page 3: PLM and Data Management in 21st Century](https://reader034.vdocuments.us/reader034/viewer/2022051816/54572a70b1af9fc15d8b47f4/html5/thumbnails/3.jpg)
2010s….
Big Data
Concurrency
Data connectivity
Cloud scale
Solution diversity
Network of data
![Page 4: PLM and Data Management in 21st Century](https://reader034.vdocuments.us/reader034/viewer/2022051816/54572a70b1af9fc15d8b47f4/html5/thumbnails/4.jpg)
New buzz is coming - NoSQL
![Page 5: PLM and Data Management in 21st Century](https://reader034.vdocuments.us/reader034/viewer/2022051816/54572a70b1af9fc15d8b47f4/html5/thumbnails/5.jpg)
Data management eras..
RDBMS
Data warehouse
RDBMS RDBMS
Data warehouse
NoSQL
Transactions 1990s
Transactions + Analytics 2000s
Transactions + Analytics + ? 2010s
![Page 6: PLM and Data Management in 21st Century](https://reader034.vdocuments.us/reader034/viewer/2022051816/54572a70b1af9fc15d8b47f4/html5/thumbnails/6.jpg)
Single Node RDBMS problem
• Large data sets
• Social networks
• Schema free
• Linked data
• Document data
• Reliability
• BI / OLAP
size
transaction
response time
![Page 7: PLM and Data Management in 21st Century](https://reader034.vdocuments.us/reader034/viewer/2022051816/54572a70b1af9fc15d8b47f4/html5/thumbnails/7.jpg)
What is behind “NoSQL” buzzword? Relational Key-value Columnar / Table
Document Graph
![Page 8: PLM and Data Management in 21st Century](https://reader034.vdocuments.us/reader034/viewer/2022051816/54572a70b1af9fc15d8b47f4/html5/thumbnails/8.jpg)
Data model: size vs. complexity
complexity
size
Graph
Document
Columnar
Key-value
● Cambrian explosion of DM options
● Database moved from solution to tools
● Next dominance is problematic
● Specialized databases (tools)
● Focus on specific problem space
![Page 9: PLM and Data Management in 21st Century](https://reader034.vdocuments.us/reader034/viewer/2022051816/54572a70b1af9fc15d8b47f4/html5/thumbnails/9.jpg)
PLM and Database genres specialty Good For... Not Good For... PLM use idea...
Relational Known data layout Variable and hierarchical data
Transactional data. Specific models
Key-value Little or no need for indexes
CRUD and other queries Vaulting, Media
Columnar Horizontal scale, cluster Undefined data usage pattern
Suppliers access, Design collaboration
Document Unknow data layout Joins Vaulting, Media
Graph Flexible typed relationships
Limited scale, query-ability Configurations, Product structure
![Page 10: PLM and Data Management in 21st Century](https://reader034.vdocuments.us/reader034/viewer/2022051816/54572a70b1af9fc15d8b47f4/html5/thumbnails/10.jpg)
The evolution of web as a database web 1.0 > web 2.0 > web 3.0 Evolution of web Web as set of structured data Linked Data Graph model RDF / OWL / SPARQL Lots of data published in RDF Size of ~30B entities for 2011 Lots of open sources tools Example: DBPedia is
Wikipedia converted to Web database
![Page 11: PLM and Data Management in 21st Century](https://reader034.vdocuments.us/reader034/viewer/2022051816/54572a70b1af9fc15d8b47f4/html5/thumbnails/11.jpg)
Example: All luxury cars
![Page 12: PLM and Data Management in 21st Century](https://reader034.vdocuments.us/reader034/viewer/2022051816/54572a70b1af9fc15d8b47f4/html5/thumbnails/12.jpg)
Example: Audi A8 DBPedia
![Page 13: PLM and Data Management in 21st Century](https://reader034.vdocuments.us/reader034/viewer/2022051816/54572a70b1af9fc15d8b47f4/html5/thumbnails/13.jpg)
Example: All people born in Boston before 1700
![Page 14: PLM and Data Management in 21st Century](https://reader034.vdocuments.us/reader034/viewer/2022051816/54572a70b1af9fc15d8b47f4/html5/thumbnails/14.jpg)
Thank you!