Feeds

The four pillars of Katmai

Dispatches from the front

Reducing security risks from open source software

Microsoft BI conference The keynote on the second day of Microsoft's BI conference was given by Ted Kummert – corporate vice president of the data storage and platform division at Microsoft.

As Jeff Raikes before him, he devoted considerable time to Katmai, the next version of SQL Server. He too stressed that the release date will be 2008 (so perhaps Microsoft is just a little sensitive about this after all). As Microsoft people are wont to do when discussing products, he talked a great deal about pillars. Not of society, but Katmai, which has four.

Enterprise Data Platform

Microsoft's belief is that any database engine that underpins a complete BI strategy must be capable of running at every level from the data warehouse, via the desktop, to the PDA in your hand. SQL Server can, of course.

Beyond Relational

The engine must be capable of storing and manipulating the wide variety of data types that businesses now collect. We have already seen XML capabilities in SQL Server and Katmai will introduce spatial. We saw a demo of storing location data of 12 million restaurants in the US and then displaying the data using Microsoft maps. Cool.

Dynamic development

Ted talked about a fascinating development in Katmai, the introduction of an ER modelling layer. This provides a logical layer which sits between application developers and the relational tables – allowing them to interact with the data more easily.

Fans of ER modelling will want to know that this is not (at least in Katmai) a design tool – you cannot develop an ER model and then generate the schema. However, Microsoft sees this as a first step and there is a strong possibility that design capabilities will appear in later versions. Database engines in general have been crying out for this kind of functionality for years so this first tentative step is very welcome.

Pervasive insight

Essentially, the adding of BI capabilities into Office. The audience was delighted when the amiable and hirsute Donald Farmer appeared on stage to demo this by using the data mining capabilities of Analysis Services from within Excel against data held in Excel. Delighted because Donald is an intelligent, articulate, and amusing techie whose presentations are guaranteed to leaven any keynote.

All in all, if you are a BI freak (and why attend the conference if you aren't?) the conference is excellent. Talking to the attendees suggests that by far the majority are very happy, the sessions are well presented and well attended. In our own sad way, we are all having fun (at least it keeps us all of the streets). ®

The Power of One eBook: Top reasons to choose HP BladeSystem

More from The Register

next story
NO MORE ALL CAPS and other pleasures of Visual Studio 14
Unpicking a packed preview that breaks down ASP.NET
Cheer up, Nokia fans. It can start making mobes again in 18 months
The real winner of the Nokia sale is *drumroll* ... Nokia
Mozilla fixes CRITICAL security holes in Firefox, urges v31 upgrade
Misc memory hazards 'could be exploited' - and guess what, one's a Javascript vuln
Put down that Oracle database patch: It could cost $23,000 per CPU
On-by-default INMEMORY tech a boon for developers ... as long as they can afford it
Google shows off new Chrome OS look
Athena springs full-grown from Chromium project's head
Apple: We'll unleash OS X Yosemite beta on the MASSES on 24 July
Starting today, regular fanbois will be guinea pigs, it tells Reg
HIDDEN packet sniffer spy tech in MILLIONS of iPhones, iPads – expert
Don't panic though – Apple's backdoor is not wide open to all, guru tells us
prev story

Whitepapers

Top three mobile application threats
Prevent sensitive data leakage over insecure channels or stolen mobile devices.
Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Boost IT visibility and business value
How building a great service catalog relieves pressure points and demonstrates the value of IT service management.
Designing a Defense for Mobile Applications
Learn about the various considerations for defending mobile applications - from the application architecture itself to the myriad testing technologies.
Build a business case: developing custom apps
Learn how to maximize the value of custom applications by accelerating and simplifying their development.