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.
plans to release its first community technology preview for "Project
Madison" in early July.
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
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.
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.
has dubbed the product's parallel design "Ultra Shared Nothing."
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
upcoming version of the database will feature new business
intelligence, multiserver management and master data management
capabilities, Microsoft officials said.