MS SQL SERVER: Programming sql server data mining

MS SQL SERVER: Programming sql server data mining

• 1.
  Programming SQL ServerData Mining
• 2.
  overviewData Mining APIsProgrammingAMO Data Mining ObjectsStored ProceduresCreating Stored ProceduresExecuting Stored ProceduresDeploying and Debugging Stored Procedure AssembliesSummary
• 3.
  Data Mining APIsThemajor APIs used in Analysis Services programming.
• 4.
  Data Mining APIsThemajor APIs used in Analysis Services programming.
• 5.
  Data Mining APIs
• 6.
  Programming AMO DataMining Objects steps in programming data mining objects by using AMO create the data structure model.
• 7.
  create the datamining model that supports the mining algorithm you want to use in order to predict or to find the relationships underlying your data.
• 8.
  process the miningmodels to obtain the trained models that you will use later when querying and predicting from the client application.Note: AMO is not for querying; AMO is for managing and administering your mining structures and models. To query your data, use ADOMD.NET
• 9.
  Mining Structure Objects A mining structure contains a binding to a data source view that is defined in the database, and contains definitions for all columns participating in the mining models Steps followed to Creating a MiningStructure object are:Create the MiningStructure object and populate the basic attributes
• 10.
  Create columns forthe model. Each column needs a name and internal ID, a type, a content definition, and a binding.
• 11.
  Update the MiningStructure object tothe server, by using the Update method of the object.MiningModel ObjectsSteps to create a MiningModel object :Create the MiningModel object and populate the basic attributes. (object name, object ID, and mining algorithm specification)
• 12.
  Add the columnsof the mining model. One of the columns must be defined as the case key.Update the MiningModel object to the server, by using the Update method of the object.MiningModel objects can be processed independently of other models in the parent MiningStructure.Stored ProceduresStored procedures can be used to call external routines from Microsoft SQL Server Analysis Services
• 13.
  You canwrite an external routines called by a stored procedure in any common language runtime (CLR) language, such as C, C++, C#, Visual Basic, or Visual Basic .NET.
• 14.
  Stored procedures canbe used to add business functionality to your applications that is not provided by the native functionality of MDXCreating Stored ProceduresAll stored procedures must be associated with a common language runtime (CLR) or Component Object Model (COM) class in order to be used. The class must be installed on the server — usually in the form of a Microsoft ActiveX® dynamic link library (DLL) — and registered as an assembly on the server or in an Analysis Services database.Server stored procedures can be called from any query context. Database stored procedures can only be accessed if the database context is the database under which the stored procedure is defined. For a server or a deployed Microsoft SQL Server Analysis Services database on a server, you can use SQL Server Management Studio to register an assembly. For an Analysis Services project, you can use Analysis Services Designer to register an assembly in the project.
• 15.
  Executing Stored ProceduresServerADOMD.NET allows you to execute DMX queries using the same objects that you would use with ADOMD.NET.The only exception is that you do not have to specify a connection, because you are already connected. You can copy the results from the query into a DataTable, or you can simply return the DataReader returned by ExecuteReader.