Iron-pumping Microsoft SQL Server due this summer
The next blocks in Microsoft's SQL Server and appliance-based data-warehouse strategy will be put in place starting this summer.
A Community Technology Preview edition of SQL Server 2008 R2, codenamed Kilimanjaro, will be made available in the second half of this year, Microsoft has said.
CTP is the first opportunity you'll get to test the code for a database Microsoft's promised will have a strong business-intelligence focus and see support for large systems.
Until now, Microsoft had only talked of CTP sometime this year. The company, meanwhile, said Kilimanjaro is on track to ship in the first-half of 2010. SQL Server 2008 shipped more than a year late.
Ahead of the CTP, though, you're going to get a taste of what a really large system running Kilimanjaro looks like: a technology preview of a version of Kilimanjaro for appliances, codenamed Madison, is due this August, Microsoft said.
Madison will use DATAllegro and Zoomix technology - acquired last year - for large scale and detailed analysis. The goal is for Madison to serve up petabytes of data using SMP on hardware architectures from server, big iron and storage specialists Bull, Dell, EMC, Hewlett-Packard, and Unisys.
Kilimanjaro and Madison are more than just the latest installments in an on-going strategy to make SQL Server run on bigger systems and support larger data sets than before. They are an attempt to improve the actual complex analysis of large volumes of data on systems that use SQL Server.
They come as Microsoft's database rival Oracle teamed with HP to last year deliver a massive, parallel, high-speed server and storage system running on Linux. Since then, Oracle's announced its intention to buy Sun Microsystems, and expressed its love for Sun's Sparc architecture, suggesting the company has even bigger data and information appliances in mind.
HP, meanwhile, is working with business-applications giant SAP on a server appliance. Demonstrated at SAP's SAPPHIRE conference, the XML Appliance is based on a quad-socket Xeon server ProLiant DL580 and runs Novell's SUSE Linux Enterprise Server 10. The appliance is designed to format data in SAP ERP systems into XML ready for use on the web, in reports or other documents.
Against this backdrop Microsoft has promised "new technology" in Kilimanjaro for low-latency complex-event processing, in addition to capabilities for master-data services, application and multi-user management, and a system that will go beyond 64 logical processors. ®
"Oracle RAC/Exadata - Rac not suited to DW implementations hence Exadata now on the scene"
we have 6 nodes RAC 10.2 with 100TB data.... works pretty dam good as DW (yes Exadata is better because of SQL aware Kernel, but still RAC in general is very good for DW)
problem with Oracle is that they aquired so many BI platforms that they cannot get a good grip around it. I wish Oracle OLAP would work at least half as good as ESSBASE
Interesting to see the database appliance history...
The appliance history has been moving fast...
2006-07 - Sun and Greenplum announced Postgress data warehouse appliance to be shipped on Sun hardware and OS some time back, where Sun would provide commercial support for Postgres.
2006-10- IBM responds with DB2 on IBM (third party linux OS) hardware integrated, as an end-to-end solution
2008-01 - Sun buys MySQL database
2008-04 - Sun and Kickfire announced MySQL data warehouse appliance with Sun stack
2008-09 - Oracle teamed with HP for integrated appliance solution.
2009-04 - Oracle, attempting to purchased Sun, for a complete end-to-end hardware, OS, database stack (and received 2 other database appliance stacks using alternate databases.)
It is nice to see Microsoft getting involved in database appliances!
Would have been nice...
Would have been nice for the author to mention some of the appliances built by/with Sun in the article.