Thursday, April 15, 2021

Much Ado About Microsoft’s New SQL Server

When Microsoft unveils its SQL Server 2005, Visual Studio 2005, and BizTalk Server 2006 products next week, it shouldn’t be seen so much as the release of three separate products but as the fruit of constant collaboration between Microsoft’s research team and the product specialists.

The company said that a so-called ”technology-transfer team” helped bridge the research and product development functions within Microsoft to make the products a reality.

SQL Server 2005 is a classic example of a product buoyed by Microsoft Research.

For example, the Machine Learning and Applied Statistics Group within Microsoft Research has created graphical models for data analysis and visualization. The group is behind the Decision Trees, Clustering, Sequential Clustering and Time Series features that will appear in SQL Server 2005.

David Heckerman, research area manager at Microsoft, said some of the technologies in SQL Server 2005 began in 1992 as pure research. Certain SQL Server 2005 utilities are based on graphical modeling and Bayesian statistical methods.

”There’s a predictive component with using Time Series,” Heckerman said in a statement. ”You can look at business data, at sales data, and extend the patterns into the future. Database tools traditionally have been used to store and look at data, but with SQL Server 2005, users can look into the future.”

Microsoft Research also supplied indexed view-matching technology for SQL Server 2005.

Indexed viewing improves database query processing by storing previous requests and analyzing the stored queries when a new query is issued to see if a stored one can supply some or all of the requested data. That process is significantly faster than if each query is treated as completely new.

This article was first published on internetnews.com. To read the full article, click here.

Similar articles

Latest Articles

NVIDIA’s New Grace ARM/GPU...

This week is NVIDIA’s GTC, or GPU Technology Conference, and they likely should have changed the name to ATC because this year – it...

What is Data Segmentation?

Definition of Data Segmentation Data segmentation is the process of grouping your data into at least two subsets, although more separations may be necessary on...

The Conversational AI Revolution:...

One of the things I’m looking forward to seeing at next week’s NVIDIA GTC event is an update on their Conversational AI efforts. I’m fascinated...

Edge Computing

Edge computing is a broad term that refers to a highly distributed computing framework that moves compute and storage resources closer to the exact...