Microsoft’s Data Warehousing Solution Reaches CTP

Barb Mosher writes:

Code named “Madison”, Microsoft’s new data warehousing solution for SQL Server 2008 R2 (news, site) is now available as a CTP.

A Brand New SQL Server

Microsoft’s release of SQL Server 2008 R2 has sparked a bit of interest. There have been a number of changes to the database platform to make it more robust, scale and secure. Along with virtualization improvements, enhanced data encryption, compliance and an increase in support for the number of logical processors, a new data warehouse solution is available.

Data Warehousing with Madison

Code named Madison, Microsoft’s new data warehouse solution is designed to support enterprises with data in the petabyte range. The appliance was built by DATAllegro, a company Microsoft acquired last year.

Madison is an appliance that uses massively parallel processing (MPP). It runs on SQL Server 2008 and Windows Server 2008 and industry standard hardware.

SQLServer2008_Madison.jpg
SQL Server 2008 Madison

Massively parallel processing provides the ability to partition large tables across physical nodes, each with its own dedicated CPU, memory and storage. Each node runs in a separate instance of SQL Server. This parallel design is called “Ultra Shared Nothing” and results in faster running queries.

Madison operates a hub and spoke architecture that lets you easily add additional Madison appliances or SQL Server data marts to support individual department needs (Madison acts as the hub and publishes data out to various business units, or spokes).

Madison_HubandSpokeModel.jpg
Madison Hub and Spoke Architecture
 

Madison is the ultimate in data warehousing for SQL Server. It starts with SQL Server Enterprise, moves up to SQL Server Fast Track Data Warehouse and then to Madison.

Interested in learning more? Watch a video of SQL Server 2008 R2, including a look at Madison.

Full integration with SQL Server 2008 and Madison is expected sometime early 2010.

Advertisements

About Andy Painter

A passionate Information and Data Architect with experience of the financial services industry, Andy’s background spans pharmaceuticals, publishing, e-commerce, retail banking and insurance, but always with a focus on data. One of Andy’s principle philosophies is that data is a key business asset.
This entry was posted in Business Intelligence, Data Warehousing, Information Management, Intelligent Enterprise, Software and tagged , , , , , , , , , . Bookmark the permalink.

One Response to Microsoft’s Data Warehousing Solution Reaches CTP

  1. Andy Painter says:

    Find out more at:

    http://www.microsoft.com/sqlserver/2008/en/us/madison.aspx

    I’m going to be watching progress with interest!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s