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.

RELATED NEWS AND ANALYSIS

• Ethics and Artificial Intelligence: Driving Greater Equality

  FEATURE |  By James Maguire,
  December 16, 2020

• AI vs. Machine Learning vs. Deep Learning

  FEATURE |  By Cynthia Harvey,
  December 11, 2020

• Huawei’s AI Update: Things Are Moving Faster Than We Think

  FEATURE |  By Rob Enderle,
  December 04, 2020

• Keeping Machine Learning Algorithms Honest in the ‘Ethics-First’ Era

  ARTIFICIAL INTELLIGENCE |  By Guest Author,
  November 18, 2020

• Key Trends in Chatbots and RPA

  FEATURE |  By Guest Author,
  November 10, 2020

• Top 10 AIOps Companies

  FEATURE |  By Samuel Greengard,
  November 05, 2020

• What is Text Analysis?

  ARTIFICIAL INTELLIGENCE |  By Guest Author,
  November 02, 2020

• How Intel’s Work With Autonomous Cars Could Redefine General Purpose AI

  ARTIFICIAL INTELLIGENCE |  By Rob Enderle,
  October 29, 2020

• Dell Technologies World: Weaving Together Human And Machine Interaction For AI And Robotics

  ARTIFICIAL INTELLIGENCE |  By Rob Enderle,
  October 23, 2020

• The Super Moderator, or How IBM Project Debater Could Save Social Media

  FEATURE |  By Rob Enderle,
  October 16, 2020

• Top 10 Chatbot Platforms

  FEATURE |  By Cynthia Harvey,
  October 07, 2020

• Finding a Career Path in AI

  ARTIFICIAL INTELLIGENCE |  By Guest Author,
  October 05, 2020

• CIOs Discuss the Promise of AI and Data Science

  FEATURE |  By Guest Author,
  September 25, 2020

• Microsoft Is Building An AI Product That Could Predict The Future

  FEATURE |  By Rob Enderle,
  September 25, 2020

• Top 10 Machine Learning Companies 2021

  FEATURE |  By Cynthia Harvey,
  September 22, 2020

• NVIDIA and ARM: Massively Changing The AI Landscape

  ARTIFICIAL INTELLIGENCE |  By Rob Enderle,
  September 18, 2020

• Continuous Intelligence: Expert Discussion [Video and Podcast]

  ARTIFICIAL INTELLIGENCE |  By James Maguire,
  September 14, 2020

• Artificial Intelligence: Governance and Ethics [Video]

  ARTIFICIAL INTELLIGENCE |  By James Maguire,
  September 13, 2020

• IBM Watson At The US Open: Showcasing The Power Of A Mature Enterprise-Class AI

  FEATURE |  By Rob Enderle,
  September 11, 2020

• Artificial Intelligence: Perception vs. Reality

  FEATURE |  By James Maguire,
  September 09, 2020