The development process for Katmai was structured differently from previous SQL Server releases. Instead of each team building their own feature in isolation, development was structured around "themes"[1] and within each theme there are scenarios, where each scenario encompasses a group of features. Also, a single feature can help complete multiple scenarios.
The theme that is most relevant to business intelligence developers is the "Pervasive insight" theme. This theme has three scenarios, with quite a few features included. Here's the deal:
Scenario: Integrate all data into enterprise data warehouse
- Enterprise partitioning parallelism
- Enhanced DW query optimizations
- Data compression
- Resource governor
- Persistent lookups
- Change data capture - find those changed records since last point
- MERGE (UPSERT!!) SQL Statement (how will this affect SCDs?)
- Data profiling
Scenario: Reach all users with a scalable BI platform
- Scalable report engine
- Scale out analysis
- Subspace computations
- Streamlined analysis tools
- Scalable backup tools
- New cube design tools
- Best practice design alerts
- IIS agnostic report deployment - Host SSRS w/o IIS
Scenario: Empower every user with actionable insight
- New Word rendering
- Improved Excel rendering
- Report builder enhancements
- Rich formatted data
- Enhanced data visualization
- MOPLAP enhanced writeback
- And there was one more feature bullet here, but they moved on too quickly before I could write it down.
[1] I've heard other product groups use the term "pillar" to describe similar high-level meta-feature groupings.
No comments:
Post a Comment