Using Data Mining for Business Intelligence - Is Microsoft SQL Server helpful for data mining?
(Page 4 of 4 )
Yes, of course. SQL Server 2000 includes Analysis Services with data mining technology which examines data, in relational data warehouse or data mart star schemas, as well as SQL Server 2000 Analysis Services OLAP cubes to uncover areas of interest to business decision makers and other analysts. Housed within this new segment of Analysis Services are data mining algorithms which enable the creation and analysis of data mining models.
OLAP Data Mining with SQL Server allows architects to reuse the results from data mining and incorporate the information into an OLAP Cube dimension for further analysis. Users can now browse and investigate data while finding the answers to questions that only data mining can answer. PivotTable Services support data mining through emulating a similar interface to that of OLAP pivot tables. In essence, users can utilize a specially designed Excel spreadsheet to interface with data mining services and run prediction queries against a data mining model, just as they do for multidimensional analysis of OLAP data cubes.
In addition, the Decision Support Objects (DSO) library has been extended in order to accommodate direct programmatic access to the data mining functionality present within OLAP services, as well as continued programmatic access to the OLAP cube resources. DSO now includes the MiningModel object as well as other extended support objects. Coupled with the new OLE DB for Data Mining provider, organizations wishing to implement custom applications which provide predictive data mining data to meet business processes, or those organizations that wish to access data mining data for the purpose of creating an operational data mining application, can now do so using the DSO library.
To learn how business intelligence can be injected into our applications using Microsoft platform, I suggest you point your browser to this link: http://www.microsoft.com/sql/evaluation/bi/default.asp
Not only Microsoft SQL Server 2000, but other great database products such as Oracle, Sybase, etc. also have special tools and add-ons to meet the requirements of data mining.
Any comments are welcome at jag_chat@yahoo.com
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
