In-Memory OLTP usage scenarios
The upcoming sections are going to show you some useful scenarios for In-Memory OLTP usage. The sections are designated as walk through examples. We will work with a large amount of data into In-Memory, then we will change the scope to heavily updated data, and in the next exercise we will add a system versioning feature. In the last example we will divide OLTP and OLAP workloads to cooperate in separate areas on top of quickly incoming data.
Assignment of the user story sample
To provide a consistent use case, we will use an imaginary water management company. Such companies have geographically spread tube networks delivering water across a whole region. The network has to be monitored constantly because the company has to be informed about every abnormality or disorder as soon as possible.
That's why there's approximately 100,000 sensors measuring the amount of water flowing through the network. Every sensor sends records with it's own identification and measures...