Что я считаю очень важным в MS SQL 2003 (OLAP).
- Улучшенный Real-Time. Его можно будет гораждо проще запустить поверх любой БД
- Большиство Calculated Member переходят на сервер и попдают под кеширование. Надо ли говорить, что это убыстрит многие вычисления в разы.
- Write-back из чистого маркетинга превращается в иструмент. Производительность становится на нормальном уровне.

Ваши комментарии?


Microsoft touts business intelligence for the masses
http://www.infoworld.com/article/02/11/21/021121hnyukonbi_1.html

Yukon will feature OLAP and data mining engines, a development workbench, and data extraction, transformation, and loading. Baker also spoke of an unrevealed feature dubbed "Act III," which is expected to be a followup to OLAP and data mining.

The OLAP engine in Yukon will scale better, and calculations and analysis on the OLAP engine will be centralized to cut down on network traffic. Calculations will be cached as well. Write-back data performance will be improved tenfold, according to the company.

http://www.eweek.com/article2/0,3959,302468,00.asp
Microsoft plans to add to its next release of SQL Server, code-named Yukon, the ability to do OLAP (online analytical processing) and data mining on real-time streams of data.

http://www.eweek.com/article2/0,3959,716625,00.asp
Another trend I expect to see is a shift toward closer-to-real-time and more scalable data analytics, especially on the OLAP (online analytical processing) and data mining fronts. The volumes of data being collected and the push to speed business processes are requiring faster data analysis turnaround, and that implies a shift toward relational OLAP (which can be performed directly on source data in a relational database) and away from multidimensional OLAP (where data is copied and analyzed offline).


http://www.microsoft.com/sql/evaluation/yukon.asp
http://www.microsoft.com/sql/evaluation/bi/reportingservices.asp