Channels ▼


In-database Analytics for SQL Server

Fuzzy Logix has ported its DB Lytix in-database analytics library to SQL Server 2008 using the Common Language Runtime (CLR) option. This library contains functions for mathematical and statistical analysis, data mining, and Monte Carlo simulations.

In-database analytics has become mainstream, as enterprises are either using this technology, or are demonstrating the inclination to use it for solving business problems. In traditional methods of data analysis, users are required to transport data out of the database for processing. The conventional approach is to move the data to analytics. Even though the conventional methods seem logical, the movement of data imposes severe limitations on delivery of results. In-database analytics relies on moving analytics to the database wherein advanced quantitative functions are embedded inside the database as scalar functions or aggregates. Analysts can simply write SQL queries to perform complex analysis of data and get the desired results with blazing speed -- exploiting the inherent parallel processing capability of the SQL Server query processor.

According to Fuzzy Logix's Partha Sen, "the availability of in-database analytics in SQL Server marks the beginning of a new era -- the era of the democratization of analytics. It's our goal to make analytics pervasive in all walks of life. We feel confident that the availability of in-database analytics in SQL Server will enable us to serve a large base of customers who are seeking to use easily accessible analytics to help them gain competitive advantage."

Eric Hanson, Principal Program Manager Lead and Data Warehouse scenario owner in the SQL Server team at Microsoft, adds that "in-database analytics can provide dramatic benefits for our customers. The functions that are available in DB Lytix will enable our customers to rapidly do predictive analysis directly with the familiar T-SQL language within SQL Server. This allows analytic results to be displayed easily in any report based on SQL queries. It also eliminates the need to move data to a separate system for analysis, avoiding the cost of moving data and of implementing redundant security controls."

Related Reading

More Insights

Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

Dr. Dobb's encourages readers to engage in spirited, healthy debate, including taking us to task. However, Dr. Dobb's moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing or spam. Dr. Dobb's further reserves the right to disable the profile of any commenter participating in said activities.

Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.