Scenarios for analytics
Being able to glean insights from your data is just as important as choosing the right type of data store. Many options exist for harvesting and reporting on that data. Online Analytics Processing (OLAP) is one method that can be used to capture and transform transactional data into a structure more suited for reporting and analytics. There are several options available for compiling and reporting on OLTP data, which we will look at now.
Transactional querying
While this may be the least efficient way to compile analytics from an OLTP data store, it is possible to directly query your OLTP database. There will be performance implications, however, as you will be querying the database while also allowing writes as a natural occurrence from application or platform usage. You may wish to address the performance issues by processing transactional writes through the database infrastructure and processing reads and aggregations through in-memory temporal tables...
