1 / 9

Extending SQL Server Data Mining

Extending SQL Server Data Mining. Ryan Ebert Richard Rogers Nick Crampton. Plugins. Use store procedures to add functions past basic data mining Use visual studio to enhance data mining Develop plug in algorithms Develop new viewers to visualize data. Plug-in algorithms.

claire-odom
Download Presentation

Extending SQL Server Data Mining

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Extending SQL Server Data Mining Ryan Ebert Richard Rogers Nick Crampton

  2. Plugins • Use store procedures to add functions past basic data mining • Use visual studio to enhance data mining • Develop plug in algorithms • Develop new viewers to visualize data

  3. Plug-in algorithms • SQL server 2005 allows third parties to develop their own algorithms for Analysis services • You can add or disable algorithms • Add on algorithms appear to end user the same as built in algorithms

  4. How plug-in algorithm works • Receives stream of data and extracts and stores patterns • Receives requests to describe patterns and apply them to new data and make predictions

  5. Managed Plug-ins • Plug-in is a COM object • Possible to use COM interfaces with .net • Usable with languages such as C# and VB • Memory is not managed by Analysis services

  6. Installing Plug-in Algorithms • Register COM • Update server’s INI file • Instructions are listed in sample plug-in

  7. Use Data Mining Viewers • Add viewers to algorithms • Add viewers to display your own algorithms • Included controls are .NET Winform controls • You can create your own viewing library

  8. Conclusion • SQL server 2005 is very extendable • Depends on your ability to program • Works with plug-ins • Create models, predictions, content navigation, data mining viewers

More Related