{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,6,19]],"date-time":"2025-06-19T04:42:04Z","timestamp":1750308124950,"version":"3.41.0"},"reference-count":5,"publisher":"Association for Computing Machinery (ACM)","issue":"2","license":[{"start":{"date-parts":[[2005,6,1]],"date-time":"2005-06-01T00:00:00Z","timestamp":1117584000000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["SIGMOD Rec."],"published-print":{"date-parts":[[2005,6]]},"abstract":"<jats:p>A data mining component is included in Microsoft SQL Server 2000 and SQL Server 2005, one of the most popular DBMSs. This gives a push for data mining technologies to move from a niche towards the mainstream. Apart from a few algorithms, the main contribution of SQL Server Data Mining is the implementation of OLE DB for Data Mining. OLE DB for Data mining is an industrial standard led by Microsoft and supported by a number of ISVs. It leverages two existing relational technologies: SQL and OLE DB. It defines a SQL language for data mining based on a relational concept. More recently, Microsoft, Hyperion, SAS and a few other BI vendors formed the XML for Analysis Council. XML for Analysis covers both OLAP and Data Mining. The goal is to allow consumer applications to query various BI packages from different platforms. This paper gives an overview of OLE DB for Data Mining and XML for Analysis. It also shows how to build data mining application using these APIs.<\/jats:p>","DOI":"10.1145\/1083784.1083805","type":"journal-article","created":{"date-parts":[[2005,11,9]],"date-time":"2005-11-09T22:23:27Z","timestamp":1131575007000},"page":"80-85","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":11,"title":["Building data mining solutions with OLE DB for DM and XML for analysis"],"prefix":"10.1145","volume":"34","author":[{"given":"Zhaohui","family":"Tang","sequence":"first","affiliation":[{"name":"Microsoft SQL Server Data Mining, Redmond, WA"}]},{"given":"Jamie","family":"Maclennan","sequence":"additional","affiliation":[{"name":"Microsoft SQL Server Data Mining, Redmond, WA"}]},{"given":"Peter Pyungchul","family":"Kim","sequence":"additional","affiliation":[{"name":"Microsoft SQL Server Data Mining, Redmond, WA"}]}],"member":"320","published-online":{"date-parts":[[2005,6]]},"reference":[{"key":"e_1_2_1_1_1","volume-title":"Report MSR-TR-98-35","author":"Bradley Paul","year":"1998","unstructured":"Paul Bradley , Usama Fayyad , Cory Reina , Scaling EM ( Expectation Maximization) Clustering to Large Databases , Microsoft Tech . Report MSR-TR-98-35 , Microsoft , 1998 . Paul Bradley, Usama Fayyad, Cory Reina, Scaling EM (Expectation Maximization) Clustering to Large Databases, Microsoft Tech. Report MSR-TR-98-35, Microsoft, 1998."},{"key":"e_1_2_1_2_1","first-page":"470","volume-title":"SQL Databases. ICDE","author":"Chaudhuri Surajit","year":"1999","unstructured":"Surajit Chaudhuri , Usama Fayyad , Jeff Bernhardt , Scalable Classification over SQL Databases. ICDE 1999 , pp. 470 -- 479 . Surajit Chaudhuri, Usama Fayyad, Jeff Bernhardt, Scalable Classification over SQL Databases. ICDE 1999, pp. 470--479."},{"key":"e_1_2_1_3_1","volume-title":"Feature Extraction, Construction and Selection: A Data Mining Perspective","author":"Liu Huan","year":"1998","unstructured":"Huan Liu , Hiroshi Motoda (ed.), Feature Extraction, Construction and Selection: A Data Mining Perspective , Kluwer Academic Publishers , 1998 . Huan Liu, Hiroshi Motoda (ed.), Feature Extraction, Construction and Selection: A Data Mining Perspective, Kluwer Academic Publishers, 1998."},{"key":"e_1_2_1_4_1","volume-title":"July","author":"Microsoft","year":"2000","unstructured":"Microsoft , OLE DB for Data Mining Specifications , July 2000 , www.microsoft.com\/data\/oledb\/dm. Microsoft, OLE DB for Data Mining Specifications, July 2000, www.microsoft.com\/data\/oledb\/dm."},{"volume-title":"November","year":"2002","key":"e_1_2_1_5_1","unstructured":"XML\/A.org , XML for Analysis Specification v1.1 , November 2002 , http:\/\/xmla.org\/docs_pub.asp XML\/A.org, XML for Analysis Specification v1.1, November 2002, http:\/\/xmla.org\/docs_pub.asp"}],"container-title":["ACM SIGMOD Record"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/1083784.1083805","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/1083784.1083805","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T16:08:24Z","timestamp":1750262904000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/1083784.1083805"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2005,6]]},"references-count":5,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2005,6]]}},"alternative-id":["10.1145\/1083784.1083805"],"URL":"https:\/\/doi.org\/10.1145\/1083784.1083805","relation":{},"ISSN":["0163-5808"],"issn-type":[{"type":"print","value":"0163-5808"}],"subject":[],"published":{"date-parts":[[2005,6]]},"assertion":[{"value":"2005-06-01","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}