Near Real-Time Analytics with xVelocity (without DirectQuery) [BIA-312]

Speaker: Marco Russo

Duration: 75 minutes

Track: BI Platform Architecture, Development & Administration

Real-time analytical systems are challenging, but interesting. The classic solution for real-time systems is to build ROLAP partitions, so you have a MOLAP cache with consolidated data and a ROLAP partition for fresh information. However, with the Tabular model in Analysis Services 2012, there's no option for this solution. You must go either in-memory or with DirectQuery, making DirectQuery the only available choice for real-time analytics.

But is DirectQuery really the only option? By using partitions in a clever way and pushing the process time to its limits, it is possible to obtain good performance for near real-time systems. This session will show you the techniques for this solution and analyze how close we can get to real-time analysis by using in-memory databases.


cage-aids
cage-aids
cage-aids
cage-aids