T1, T2, T3 White Papers

T3 - Enterprise Scale Business Intelligence: an Enterprise Server and Storage Architecture for Scalability, Availability, and Manageability

• Tags:
• t1, t2, t3,
• emc,
• response,
• unisys

Overview Data warehousing and analytical tool technologies help determine the data presentation format. Users determine how to explore the data and discover patterns and trends that lead to better decisions. At the forefront of this effort, OLAP technologies allow users to pivot data, drill down to fine levels of granularity, and determine the data paths leading to meaningful answers at query time. Most important, these tools deliver flexibility at sub-second or single second response time. When compared to traditional static reports, OLAP technology moves reporting from the horse-and-buggy era to the space age.

With the T3 prototype, Microsoft, Unisys, Knosys and EMC proved their joint ability to support applications using extremely large data sets based upon SQL Server 2000 Analysis Services OLAP cubes. Using actual market data from a leading syndicated data publisher, the team constructed a system that supports a 1.2 terabyte (TB) SQL Server 2000 data warehouse within an Analysis Services OLAP cube. This single cube gives users access to over 700,000 products and 7.7 billion fact rows - even complex queries complete with sub-second response time. This amazing development occurs with the cube hosted on a 16-processor Unisys ES7000 server and with storage spread across three EMC Symmetrix storage systems.

This paper presents the server and storage infrastructure, based on Unisys and EMC technology, which serves as the platform to deliver these advanced capabilities.

• 
• Did you find this white paper useful? 2 out of 4 users found this white paper useful

• Subscribe to the IT White Papers Newsletter
• White Paper RSS