Senturus recommends to our clients that they implement in-memory capabilities in the relational databases they are using for their data warehouses. By doing so, they can see some serious improvements in reporting response time. It takes less than a few hours to do and, in our experience, requires no changes to existing models or reports.
Among our clients, SQL Server is the most common relational database and its in-memory capability is called Columnstore Indexes. We implemented them in various situations and saw some report execution times drop from 6 minutes to an impressive 2 seconds. Recently, we executed them for an outdoor apparel retailer client and are seeing sub-second response times with relational DMR package queries.
Columnstore Indexes are available in SQL Server 2012, 2014 and 2016. They are only available in the Enterprise Edition. You can check the version and edition with these SQL statements:
SERVERPROPERTY(‘ProductVersion’) AS ProductVersion,
SERVERPROPERTY(‘Edition’) AS Edition,
|Version Pattern||SQL Product|
|12.0. x . x||SQL Server 2014|
|11.0. x . x||SQL Server 2012|
|10.50. x . x||SQL Server 2008 R2|
|10.00. x . x||SQL Server 2008|
In DB2, the edition you’ll want is DB2 with BLU Acceleration.
In Oracle it’s an Enterprise Edition option called (surprisingly) Oracle Database In-Memory.
Happy Speeding! To learn more on the subject, check out our webinar: Demystifying In-Memory Technologies.