Database In-Memory is a class leading inmemory technology delivering orders of magnitude faster Analytics as well as significantly faster hybrid OLTP workloads.
Die Mobiliar made excellent use of this technology for real-time risk analysis.
However, to be fair, inmemory speed and efficiency aren’t for everyone, so we tried to come up with ..
Top 5 Reasons Some People Might Not Want Database In-Memory
#5: They like taking coffee breaks while running reports, so reports need to run slowly.
#4: They think that data is like wine and gets better with age, and they prefer reports on old data (current data is too harsh!).
#3: They believe in “No Rows Left Behind” and must retrieve and examine every row while running reports.
#2. They enjoy “Index Roulette”: Randomly creating analytic indexes while never knowing whether a future ad-hoc report will take seconds or hours depending on whether it has the indexes it needs.
#1. They like slowing down transactions and batch workloads with many indexes since it helps them take even longer coffee and lunch breaks and perhaps even vacation days!
Original publish date: April 3, 2017