In-Memory OLTP usage scenarios
The upcoming sections are going to show you some useful scenarios for In-Memory OLTP usage. The following sections are intended as walkthrough examples. We will work with a large amount of data in In-Memory OLTP, 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 merge OLTP and Online Analytical Processing (OLAP) workloads, two highly different areas of data manipulation, using In-Memory OLTP to make them work together efficiently.
Assignment of the user story sample
To provide a consistent use case, we will use an imaginary water management company. Such companies have geographically distributed 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...
