O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Tabular Models and SSAS

Tabular models are in-memory databases in Analysis Services. They use state-of-the-art compression algorithms and multithreaded query processor and leverage the xVelocity in-memory analytics engine to deliver fast access to tabular model objects and data by many client reporting applications such as Microsoft Excel and Microsoft Power View. Tabular models support data access through two modes: cached mode and DirectQuery mode. In cached mode, you can integrate data from multiple sources, including relational databases, data feeds, and flat files. In DirectQuery mode, you can bypass the in-memory model, allowing client applications to query data directly at the (SQL Server relational) source.

Tabular models are created ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required