Microsoft sees data warehousing as the future of the database and is targeting version 7.0 of its SQL Server database at the mass market.
It will add a raft of new decision support features to the database, codenamed Sphinx, to try to appeal to the mass data warehousing sector.
The aim is to make the offering as easy to install, deploy and use as possible in order to woo small and medium-sized companies. Microsoft also plans to move deeper into the enterprise by making the technology available to many more knowledge workers than at present.
As a result, another important goal is to make the database easy to manage, so that administrators, always in short supply, can spend more of their time on challenging rather than routine tasks.
William Baker, Microsoft?s product unit manager for the decision support product unit, explained: ?The data warehouse is the future of the database and the market is growing at 40 per cent each year compared to the database?s four per cent. The needs and requirements of the data warehouse will be the same as those driving the database forward, but these have so far been very esoteric. Our aim is to make it easy to design, build, manage and use cost effective data warehouse solutions using SQL Server and Windows.?
A key plank to this strategy of proliferating the data warehouse is Microsoft?s Zero Administration Server initiative, which involves trying to automate all routine operations in the database, or when this is not possible, to provide 25 wizards to make writing routines easier.
New features of Sphinx, which is a complete rewrite, include dynamic memory and disk space management, and an improved Enterprise Manager for multiserver installations. This comes as a Microsoft Management Console snap-in, so it has the same look-and-feel as the rest of the Back Office family of products. Agent technology has also been added, which can report back to a central server on whether a job has been a success or failure.
But, to ensure the technology can be used by as many people as possible, a mobile version of the database for sales staff will also be incorporated in the current line-up, which includes a Standard and Enterprise Edition.
In a bid to make SQL Server even more ubiquitous, however, the next version of the Access development environment will support OLEDB, which means users can choose whether they want Jet as the back end database to their applications, or SQL Server. Jet will continue to be the default database, but SQL Server is expected to become the default offerings for applications such as Exchange over time.
Meanwhile, similar ease of use features will also be added to Microsoft?s new Plato online transaction processing offering, which will be called Decision Support Services (DSS) and come only with the Standard and Enterprise versions of SQL Server.
Plato will be completely integrated into SQL Server and the Back Office family of products, and will not be sold as a standalone server, which means existing users from the offering?s former days with Panorama Software will be forced to move to SQL Server.
Another important product to help optimise SQL Server for data warehousing is version 2.0 of the Microsoft repository. This will also be integrated into the database and enable uses to share metadata between their different data warehouse products and components to enable reuse.
The repository supports not only Microsoft tools, but also offerings from up to 32 third party vendors, and makes it easier to coordinate team development.
For the full version of this story see analysis section.
Ceres, located in the asteroid belt, has a carbonaceous-rich upper crust, SwRI study claims
The spacecraft found traces of hydrogen and oxygen molecules, known as hydroxyls, embedded in the rocky surface of the asteroid
The skeleton was unearthed more than 20 years ago in South Africa
Moon's dark side is mountainous, rugged and never visible from the Earth