There are two types of databases that you can choose from when you create a device. Select the type based on the expected function as described below:
1. Device Optimized Data [Immutable database]
By selecting the immutable bucket, you can store up to 36 million data points per device. This bucket is highly optimized for short and long retention periods; the query responses are faster, which means less latency for the devices and a cost reduction when running an analysis. Also, as the data is immutable, no one can change or delete individual sets of data – this being ideal for compliances.
Data stored in the 'optimized device data' can only be removed by the data retention policy.
2. Managed Data Optimized [Mutable database]
By using the mutable bucket, you can easily edit or delete data.
Some notes about this mutable bucket:
it doesn’t have data retention,
each bucket size is limited to 50k data registers,
it is optimized to be used for the storage and manipulation of configurable variables coming from devices, web services and forms.