I've previously had dataminer training (nearly 2 years ago) and I recall the chap running the class mentioned that using Cassandra was preferable over MSSQL as the backend database.
I've asked a contact from Dataminer about this and was told the following:
"The main difference between MSSQL and Cassandra, is that one is a relational-Database, and the other is a big-data-database.
With MSSQL, along the way the DB will become slower, as more data gets stored in it.
For Cassandra this will not be an issue. Also Cassandra allows us to retrieve information in better and faster way.
Therefore some features in DataMiner will only be available if you have a Cassandra Database."
I would like to know what features of DataMiner will not be available if I used MSSQL - I was asked to post this question here by the DataMiner contact I emailed... Is anyone able to provide me a full list of said features?
The following features are Cassandra/Elastic only:
- Analytics features in the Alarm console
- The query data input inside DataMiner Dashboards (GQI)
- DataMiner Job Manager
- Service & Resource Management (SRM)
- DataMiner Ticketing
Another large feature on the roadmap is "Element Swarming", which will allow elements to load balance between different agents of a DataMiner cluster. This will also require Cassandra (cluster).