Sql server - Explain how to work with the data mining algorithms included in SQL Server data mining

Explain how to work with the data mining algorithms included in SQL Server data mining.

- A data mining algorithm is a set of heuristics and calculations that creates a data mining model from data.

- SQL Server data mining offers Data Mining Add-ins for office 2007 that allows discovering the patterns and relationships of the data. This also helps in an enhanced analysis.

- The Add-in called as Data Mining client for Excel is used to first prepare data, build, evaluate, manage and predict results.

- Microsoft SQL Server Analysis Services provides multiple algorithms for use in your data mining solutions.

- These algorithms are implementations of some of the most popular methodologies used in data mining.

- All of the Microsoft data mining algorithms can be customized and are fully programmable using the provided APIs, or by using the data mining components in SQL Server Integration Services.

- Third-party algorithms can also be used to comply with the OLE DB for Data Mining specification, or develop custom algorithms that can be registered as services and then used within the SQL Server Data Mining framework.
Sql server - Explain how to use DMX-the data mining query language
Data mining extension is based on the syntax of SQL. It is based on relational concepts and mainly used to create and manage the data mining models......
Sql server - Explain how to mine an OLAP cube
A data mining extension can be used to slice the data the source cube in the order as discovered by data mining......
What is SQL Server 2005 Analysis Services (SSAS)?
SSAS gives the business data an integrated view. This integrated view is provided by combining online analytical processing (OLAP).....
Post your comment