Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X
Hi all,
I know that ThingWorx provides 3 options DB. (H2/HANA/PostgreSQL)
What are the differences? What is the most scalable?
Please let me know your any think. Thanks in advanced.
Solved! Go to Solution.
Hi Jeongeun
Here's quick info for you :
1. H2 is a Java based embedded RDBMS system as ThingWorx's Persistence provider, it's largely for maintaining lower disk foot print, you probably wouldn't want to go for it if you are looking for larger data sets to handle with, in the future. It's an open source RDBMS. No additional installation steps would be needed.
2. SAP Hana is an in-memory RDBMS system allowing you to perform very high speed parallel transactions as most of the data is stored in-memory (RAM), (bypassing the need to hit the HDD to larger extent) would recommend you to go through the documentation for this for more detail. Require additional installation step
3. PostgreSQL is another RDBMS system capable of handling ~500G of data, will require additional installation step
As to the scalability and high availability, in my opinion both SAP HANA and PostgreSQL would fall in this category. With PostgreSQL you have the option to setup High Availability on the database Layer, please check this documentation
Hope this would help.
Hi Jeongeun
Here's quick info for you :
1. H2 is a Java based embedded RDBMS system as ThingWorx's Persistence provider, it's largely for maintaining lower disk foot print, you probably wouldn't want to go for it if you are looking for larger data sets to handle with, in the future. It's an open source RDBMS. No additional installation steps would be needed.
2. SAP Hana is an in-memory RDBMS system allowing you to perform very high speed parallel transactions as most of the data is stored in-memory (RAM), (bypassing the need to hit the HDD to larger extent) would recommend you to go through the documentation for this for more detail. Require additional installation step
3. PostgreSQL is another RDBMS system capable of handling ~500G of data, will require additional installation step
As to the scalability and high availability, in my opinion both SAP HANA and PostgreSQL would fall in this category. With PostgreSQL you have the option to setup High Availability on the database Layer, please check this documentation
Hope this would help.
Just to add for even higher Data volume we have option for DSE with postgresql too.