Madison - High end scale out for data warehousing
As with my other TechEd 09 notes, this will be a list of notes that I made during the presentation. These will give a start point to find out further information. Project Madision: 100's of terabytes FastTrack reference architecture - guarantees consistent throughput for high scale data warehouses Massive scale out to 100's TB Developed by DatAllegro, MS bought them a year ago and are now incorporating their software into Kilimanjaro Large tables are hash distributed Small tables and dimension tables are replicated Create DB is now a simple script for DBAs. This script triggers a system script that will set up an optimally created database. Create table/partition is now combined in one statement