Microsoft Puts Data Mining Specification into Beta

Microsoft Corp. opened the beta testing phase today for its OLE DB for Data Mining specification, a key precursor to the release of SQL Server 2000 with its built-in data mining functionality.

OLE DB for Data Mining is an interface for integrating data mining tools and capabilities into line-of-business and e-commerce applications. The new protocol based on the Structured Query Language (SQL) common to relational databases is designed to make it easier for business users to leverage the power of data mining – previously the exclusive domain of statistically sophisticated analysts.

The specification is similar in concept to the OLE DB for OLAP specification released in advance of SQL Server 7.0’s release. Just as Microsoft ( built an OLAP server into SQL Server 7.0, the company is building data mining capabilities and interfaces code-named “Aurum,” which is Latin for gold, into SQL Server 2000.

Industry analysts and Microsoft itself aren’t expecting inclusion of data mining to generate as much industry buzz as OLAP did. Data mining tools tend to be much more difficult to understand and use effectively than OLAP tools.

Primarily the data mining functionality is expected to be used in two ways with SQL Server 2000. Data mining tools vendors may prefer to use a relational database to store and prepare data before running it through data mining algorithms. Vertical ISVs may want to use the specification to build a specific data mining algorithm into an application, such as running a customer through an algorithm that would calculate whether the person is a good or bad credit risk.

Vendors lining up to support the specification included ANGOSS Software Corp., Appsource Corp., Comshare Inc., DB Miner Technology Inc., Knosys Inc., Magnify Inc., Megaputer Intelligence Inc., Maximal Innovative Intelligence Ltd., NCR Corp., PolyVista Inc. and SPSS Inc.

OLE DB for Data Mining was introduced in May at Tech*Ed ’99, and has been under vendor review and modification since then under non-disclosure agreements.

The new specification includes Predictive Model Markup Language (PMML) standards from the Data Mining Group ( ).

The beta specification for OLE DB for Data Mining is available at It will be open for public review until May 15. – Scott Bekker

About the Author

Scott Bekker is editor in chief of Redmond Channel Partner magazine.


  • Microsoft Clarifies Project Cortex's Scope, IT Controls and Product Delivery in Q&A

    Microsoft recently offered a Q&A session on Project Cortex, its emerging "knowledge network" solution for Microsoft 365 users.

  • How To Use .CSV Files with PowerShell, Part 2

    In the second part of this series, Brien shows how to import a .CSV file into a PowerShell array, including two methods for zooming in on just the specific data you need and filtering out the rest.

  • Windows 10 Preview Adds Ability To Display Linux Distro Files

    Microsoft on Wednesday announced Windows 10 preview build 19603, which adds easier access to installed Linux distro files using Windows File Explorer.

  • Microsoft 365 Business To Get Azure Active Directory Premium P1 Perks

    Subscribers to Microsoft 365 Business (which is being renamed this month to "Microsoft 365 Business Premium") will be getting Azure Active Directory Premium P1 licensing at no additional cost.

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.