cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X

db choice

jkim-61
1-Newbie

db choice

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.

1 ACCEPTED SOLUTION

Accepted Solutions
supandey
19-Tanzanite
(To:jkim-61)

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.

View solution in original post

2 REPLIES 2
supandey
19-Tanzanite
(To:jkim-61)

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.

ankigupta
5-Regular Member
(To:supandey)

Just to add for even higher Data volume we have option for DSE with postgresql too.

Top Tags