Visual Studio 2010!

Read now >

View Now
DevSource RSS FEEDS
XML Want an easy way to keep up with breaking tech news? And the Get DevSource headlines delivered to your desktop with RSS.
ADVERTISEMENT
ADVERTISEMENT

 

DevSource.com: Your Source for Visual Studio on Facebook
ADVERTISEMENT
Microsoft's Madison Data Warehouse Appliance Coming Soon
By Brian Prince

Rate This Article: Add This Article To:

Microsoft is preparing to release a community technology preview for Project Madison, its new data warehousing technology, later in 2009. Madison uses massively parallel processing to offer high-performance queries, Microsoft says.

Microsoft plans to release its first community technology preview for "Project Madison" in early July.

Project Madison is the code name for Microsoft's new data warehousing technology for SQL Server. Madison builds off technology Microsoft acquired when it purchased DATAllegro in 2008.

The goal of Madison is to use MPP (massively parallel processing) to deliver high performance and scalability on SQL Server 2008, Windows Server 2008 and industry-standard hardware. The appliance partitions large tables across multiple physical nodes, with each node having dedicated CPU, memory and storage and running its own instance of SQL Server.

The query processing takes place within one physical instance of a database. A Control Node routes queries from applications to all Compute Nodes and then collects and returns the result. Since the data is evenly distributed across multiple nodes and processing occurs in parallel, queries can be performed faster than on single SMP (symmetric multiprocessing) database servers, according to Microsoft.

Microsoft has dubbed the product's parallel design "Ultra Shared Nothing."

Microsoft has made a number of announcements around its database and data warehousing business of late. The company recently announced that it was opening up "Project Huron" for early adopters. In addition, Microsoft announced plans May 11 at its TechEd North America conference in Los Angeles to release a CTP of Microsoft SQL Server 2008 R2, aka "Kilimanjaro," in the second half of the year.

The upcoming version of the database will feature new business intelligence, multiserver management and master data management capabilities, Microsoft officials said.




Discuss Microsoft's Madison Data Warehouse Appliance Coming Soon
 
NCR's TeraData functions exactly the same way. Wal-Mart uses Teradata due to the...
>>> Post your comment now!
 

 
 
>>> More Microsoft Architecture Articles          >>> More By Brian Prince