Integrating data mining with SQL databases: OLE DB for data mining

Author

Netz, Amir ; Chaudhuri, Surajit ; Fayyad, Usama ; Bernhardt, Jeff

Author_Institution

Microsoft Corp., Redmond, WA, USA

fYear

2001

fDate

2001

Firstpage

379

Lastpage

387

Abstract

The integration of data mining with traditional database systems is key to making it convenient, easy to deploy in real applications, and to growing its user base. We describe the new API for data mining proposed by Microsoft as extensions to the OLE DB standard. We illustrate the basic notions that motivated the API´s design and describe the key components of an OLE DB for the data mining provider. We also include examples of the usage and treat the problems of data representation and integration with the SQL framework. We believe this new API will go a long way in enabling deployment of data mining in enterprise data warehouses. A reference implementation of a provider is available with the recent release of Microsoft SQL Server 2000 database system

Keywords

SQL; application program interfaces; data mining; data structures; data warehouses; relational databases; API; Microsoft SQL Server 2000; OLE DB; SQL databases; data mining; data representation; enterprise data warehouses; relational database; standard; Business; Data mining; Data warehouses; Database systems; Delta modulation; File systems; Pattern recognition; Predictive models; Relational databases; Space technology;

fLanguage

English

Publisher

ieee

Conference_Titel

Data Engineering, 2001. Proceedings. 17th International Conference on

Conference_Location

Heidelberg

ISSN

1063-6382

Print_ISBN

0-7695-1001-9

Type

conf

DOI

10.1109/ICDE.2001.914850

Filename

914850