New in BI / DW Microsoft
Microsoft announced last week the news that will bring the new version of SQL Server whose release is planned for late 2011. Tuesday, November 23, 2010
Turn Off Sound On Catch Phrase
The new release is named "Denali" and is marked mainly by improvements for development projects Datawarehouse and Business Intelligence. Columnar Motor
It is a fact that many manufacturers database are adopting the technology more columnar database designed for analytical applications geared more to the consultation that the handling of transactions.
Microsoft is doing its thing with the engine Vertipaq columnar in memory that is already part of PowerPivot, the new ad-in for Excel 2010, which is capable of handling millions of transactions. Currently this technology is closely linked to the Excel book, in fact the data is stored as part of the latter, and the only way to share is through publication in Sharepoint. This latest addition limitande imposes a 2GB file size.
While it may be enough to share dashboards and some analysis not for a BI platform that supports robust security at such elements of its dimensions. For example to separate data from two areas / user groups to which a data can not see the other 2 books you have to build what is obviously a problem.
The good news is that the new engine Vertipaq or columnar (project name "Apollo") shall become part of the core of SSAS (Analysis Services) where another will handle large volumes and safety.
New Semantic Model
What also needed is a unified model for SSAS and SSRS (reporting services and analysis services). This unified model will Bism which contain the semantic model (future) to SSRS and SSAS. This will be a single model for reporting on relational sources (tables) and Multidimensional not forcing those who only want to issue general reports to a dimensional model.
does not mean that the UDM is left out (at least not for quite some time). Both models will coexist. The DAX Bism joined to Analysis Services, query language and expressions used PowerPivot today, which will make the models can be accessed through a simple language for users. DAX may consult dimensional and relational models and unrelated tables and will build more intuitive consultations. Excel
Excel BI remain the ultimate customer and support both as Bism UDM. Crescent
is the name of the project of a new ad hoc reporting tool and display promises to be more interactive, visual and modern. Reporting Services
addition to all the improved graphics thanks to the acquisition of Dundas technology, you should consult natively by the Bism MDX and probably also by DAX but will have to wait Microsoft to clarify a little more the roadmap.
As we can see, the BI platform market will be each day more fun and competitive.
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment