The four pillars of Katmai

Dispatches from the front


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). ®


Other stories you might like

  • Firefox kills another tracking cookie workaround
    URL query parameters won't work in version 102 of Mozilla's browser

    Firefox has been fighting the war on browser cookies for years, but its latest privacy feature goes well beyond mere cookie tracking to stop URL query parameters.

    HTML query parameters are the jumbled characters that appear after question marks in web addresses, like website.com/homepage?fs34sa3aso12knm. Sites such as Facebook and HubSpot use them to track users when links are clicked, and other websites like YouTube use them to enable certain site features too.

    On June 28, Firefox 102 released a feature that enables the browser to "mitigate query parameter tracking when navigating sites in ETP strict mode." ETP, or enhanced tracking protection, encompasses a variety of Firefox components that block social media trackers, cross-site tracking cookies, fingerprinting and cryptominers "without breaking site functionality," says Mozilla's ETP support page.

    Continue reading
  • Old school editor Vim hits version 9 with faster scripting language
    All of the famed user-friendliness and ease of use, but 'drastically' better performance

    Old school editor fans, rejoice: some two and a half years after version 8.2, Vim 9 is here with a much faster scripting language.

    Vim 9 has only a single big new feature: a new scripting language, Vim9script. The goal is to "drastically" improve the performance of Vim scripts, while also bringing the scripting language more into line with widely used languages such as JavaScript, TypeScript, and Java.

    The existing scripting language, Vimscript, remains and will still work. Only scripts beginning with the line vim9script will be handled differently. The syntax changes are relatively modest; the important differences are in things like local versus global variables and functions, and that functions defined with :def will be compiled before they are run. This allows many errors to be caught in advance, but more significantly, compiled functions execute from 10× to 1000× faster.

    Continue reading
  • Iceotope: No need to switch servers to swap air-cooled for liquid-cooled
    Standard datacenter kit just needs a few tweaks, like pulling off the fans

    Liquid cooling specialist Iceotope claims its latest system allows customers to easily convert existing air-cooled servers to use its liquid cooling with just a few minor modifications.

    Iceotope’s Ku:l Data Center chassis-level cooling technology has been developed in partnership with Intel and HPE, the company said, when it debuted the tech this week at HPE’s Discover 2022 conference in Las Vegas. The companies claim it delivers energy savings and a boost in performance.

    According to Iceotope, the sealed liquid-cooled chassis enclosure used with Ku:l Data Center allows users to convert off-the-shelf air-cooled servers to liquid-cooled systems with a few small modifications, such as removing the fans.

    Continue reading
  • Gartner predicts 9.5% drop in PC shipments
    Stark contrast to 11 percent increase year-over-year in 2021 shipments

    The party is over for PC makers as figures from Gartner suggest the market is on course for a breathtaking decline this year.

    According to the analysts, worldwide PC shipments will decline by 9.5 percent, with consumer demand leading the way – a 13.5 percent drop is forecast, far greater than business PC demand, which is expected to drop by 7.2 percent year on year.

    The PC market in the EMEA region is forecast to fare even worse, with a 14 percent decline on the cards for 2022. Gartner pointed the finger of blame at uncertainty caused by conflicts, price increases and simple unavailability of products. Lockdowns in China were also blamed for an impact in consumer demand.

    Continue reading

Biting the hand that feeds IT © 1998–2022