Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

SQLDistributions by TotallySQL

URLs: sqldistributions, totallysql

Evaluation of PDF, CDF and their inverses; summary statistics; parameter estimation; high-volume random variate generation and much more. SQLDistributions extends and enhances your T-SQL programming environment by adding full-featured and highly accurate SQL implementations of 28 probability distributions. For each of these distributions the following functions are available: probability density function (pdf) and its inverse; cumulative density function (cdf) & its complement; quantile (inverse cdf) and its complement; hazard function; cumulative hazard function (chf), mean; median; mode; variance; standard deviation; skewness; kurtosis; percentile; percentilerank, flags: symmetric; unimodal; discontinuous (on left or right); strictly increasing / decreasing; inverted, minimum & maximum defined values for x; minimum & maximum supported values for x; minimum & maximum values of pdf, high-performance scalar and table-valued random variate generators (to generate random numbers that are distributed as per the distribution).

Easy to Use

All TotallySQL Transact-SQL extensions are implemented using familiar programming objects within SQL (scalar and table-valued functions, aggregate functions, user-defined types, stored procedures) , keeping the syntax clean and making them as fast and easy to use as the built-in native statistics functions. The distributions in SQLDistributions are all implemented as Types within SQL, so distributions can be instantiated and stored as single objects in tables and local variables.

Outstanding Performance and Numerical Accuracy

The algorithms behind the SQLDistributions use industry-proven, best-in-class techniques devised by some of the world's leading numerical computing experts to maximise performance and accuracy even for fairly extreme input values. Careful heuristics and edge-case checks through the code ensure that problems caused by the limitations of floating-point arithmetic on digital computers (such as cancellation errors) are kept to an absolute mininum, and a broad range of special-purpose, high-performance numerical computing approaches are used in place of the slow, expensive computations that would result from 'naive' implementations of the underlying mathematics. The random variate generators are blisteringly fast.

Supported Distributions

Continuous:

Beta

Cauchy

Chi-squared

Exponential

F

Gamma

Gumbel

Inverse chi-squared

Inverse gamma

Laplace

Logistic

Log-normal

Non-central beta

Non-central chi-squared

Non-central F

Non-central T

Normal

Pareto

Rayleigh

T

Triangular

Uniform

Weibull

Discrete

Bernouilli

Binomial

Hypergeometric

Negative binomial

Poisson

Functions Available (for all distributions)

Probability density function pdf(x)

Inverse probability density function - finds possible values of x for a given value of pdf(x)

Cumulative density function cdf(x) & its complement (for greater precision when cdf(x) is near 1)

Quantile (inverse of cdf) & its complement (for greater precision when input value p is near 1)

Hazard function & cumulative hazard function

Mean, mode, median, variance, standard deviation, skewness, kurtosis & kurtosis excess

Percentile & percentile rank

Flags: symmetric, unimodal, discontinuous (left & right), strictly increasing / decreasing, inverted

Minimum & maximum defined & supported values of x

Minimum & maximum values of pdf(x)

Scalar & table-valued random variate generator functions

Parameter accessors (allows distribution parameters to be read for stored distributions)

Distributions are implemented as types within SQL - they can be instantiated & stored in tables etc.

Constructor functions are provided for each distribution

Distributions can also be initialized / reset by assigning comma-separated parameter strings.

All functions exist as instance methods (object.method() syntax) and as static methods (type::method() syntax)

Evaluation of PDF, CDF and their inverses; summary statistics; parameter estimation; high-volume random variate generation and much more.

Pricing: SQLDistributions - CAL (Client Access License) V1.0 1 CAL License, SQLDistributions - CAL (Client Access License) V1.0 5 CAL License, SQLDistributions - CAL (Client Access License) V1.0 10 CAL License, SQLDistributions - CAL (Client Access License) V1.0 25 CAL License, SQLDistributions - CAL (Client Access License) V1.0 50 CAL License, SQLDistributions - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 1 CAL License, SQLDistributions - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 5 CAL License, SQLDistributions - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 10 CAL License, SQLDistributions - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 25 CAL License, SQLDistributions - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 50 CAL License, SQLDistributions - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 1 CAL License, SQLDistributions - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 5 CAL License, SQLDistributions - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 10 CAL License, SQLDistributions - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 25 CAL License, SQLDistributions - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 50 CAL License, SQLDistributions - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 1 CAL License, SQLDistributions - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 5 CAL License, SQLDistributions - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 10 CAL License, SQLDistributions - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 25 CAL License, SQLDistributions - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 50 CAL License, SQLDistributions CAL (Client Access License) - 1 Year Support & Maintenance Renewal 1 CAL Support & Maintenance Renewal License, SQLDistributions CAL (Client Access License) - 1 Year Support & Maintenance Renewal 5 CAL Support & Maintenance Renewal License, SQLDistributions CAL (Client Access License) - 1 Year Support & Maintenance Renewal 10 CAL Support & Maintenance Renewal License, SQLDistributions CAL (Client Access License) - 1 Year Support & Maintenance Renewal 25 CAL Support & Maintenance Renewal License, SQLDistributions CAL (Client Access License) - 1 Year Support & Maintenance Renewal 50 CAL Support & Maintenance Renewal License, SQLDistributions CAL (Client Access License) - 3 Year Support & Maintenance Renewal 1 CAL Support & Maintenance Renewal License, SQLDistributions CAL (Client Access License) - 3 Year Support & Maintenance Renewal 5 CAL Support & Maintenance Renewal License, SQLDistributions CAL (Client Access License) - 3 Year Support & Maintenance Renewal 10 CAL Support & Maintenance Renewal License, SQLDistributions CAL (Client Access License) - 3 Year Support & Maintenance Renewal 25 CAL Support & Maintenance Renewal License, SQLDistributions CAL (Client Access License) - 3 Year Support & Maintenance Renewal 50 CAL Support & Maintenance Renewal License, SQLDistributions CAL (Client Access License) - 5 Year Support & Maintenance Renewal 1 CAL Support & Maintenance Renewal License, SQLDistributions CAL (Client Access License) - 5 Year Support & Maintenance Renewal 5 CAL Support & Maintenance Renewal License, SQLDistributions CAL (Client Access License) - 5 Year Support & Maintenance Renewal 10 CAL Support & Maintenance Renewal License, SQLDistributions CAL (Client Access License) - 5 Year Support & Maintenance Renewal 25 CAL Support & Maintenance Renewal License, SQLDistributions CAL (Client Access License) - 5 Year Support & Maintenance Renewal 50 CAL Support & Maintenance Renewal License, SQLDistributions - CPU License V1.0 1 CPU License, SQLDistributions - CPU License V1.0 2 CPU License, SQLDistributions - CPU License V1.0 4 CPU License, SQLDistri

Evals & Downloads: Read the SQLDistributions help file, Read the TotallySQL License Agreement, Download the SQLDistributions V1.0 evaluation on to your computer - Expires After 30 Days

Operating System for Deployment: Windows 7, Windows Server 2008, Windows Server 2003

Architecture of Product: 32Bit, 64Bit

Product Type: Component

Component Type: .NET Class, 100% Managed Code

Compatible Containers: Microsoft SQL Server 2008, Microsoft SQL Server 2005

Keywords: SQLDistributions

totally sql

Math Stats Mathematics Mathematical Statistic Statistical

SQL query language

Part numbers: PC-541752-407421 541752-407421 PC-541752-407422 541752-407422 PC-541752-407423 541752-407423 PC-541752-407424 541752-407424 PC-541752-407425 541752-407425 PC-541752-407426 541752-407426 PC-541752-407427 541752-407427 PC-541752-407428 541752-407428 PC-541752-407429 541752-407429 PC-541752-407430 541752-407430 PC-541752-407431 541752-407431 PC-541752-407432 541752-407432 PC-541752-407433 541752-407433 PC-541752-407434 541752-407434 PC-541752-407435 541752-407435 PC-541752-407436 541752-407436 PC-541752-407437 541752-407437 PC-541752-407438 541752-407438 PC-541752-407439 541752-407439 PC-541752-407440 541752-407440 PC-541752-407441 541752-407441 PC-541752-407442 541752-407442 PC-541752-407443 541752-407443 PC-541752-407444 541752-407444 PC-541752-407445 541752-407445 PC-541752-407446 541752-407446 PC-541752-407447 541752-407447 PC-541752-407448 541752-407448 PC-541752-407449 541752-407449 PC-541752-407450 541752-407450 PC-541752-407451 541752-407451 PC-541752-407452 541752-407452 PC-541752-407453 541752-407453 PC-541752-407454 541752-407454 PC-541752-407455 541752-407455 PC-541752-407701 541752-407701 PC-541752-407702 541752-407702 PC-541752-407703 541752-407703 PC-541752-407704 541752-407704 PC-541752-407705 541752-407705 PC-541752-407706 541752-407706 PC-541752-407707 541752-407707 PC-541752-407708 541752-407708 PC-541752-407709 541752-407709 PC-541752-407710 541752-407710 PC-541752-407711 541752-407711 PC-541752-407712 541752-407712 PC-541752-407713 541752-407713 PC-541752-407714 541752-407714 PC-541752-407715 541752-407715 PC-541752-407716 541752-407716 PC-541752-407717 541752-407717 PC-541752-407718 541752-407718 PC-541752-407719 541752-407719 PC-541752-407720 541752-407720 PC-541752-407721 541752-407721 PC-541752-407722 541752-407722 PC-541752-407723 541752-407723 PC-541752-407724 541752-407724 PC-541752-407725 541752-407725 PC-541752-407726 541752-407726 PC-541752-407727 541752-407727 PC-541752-407728 541752-407728 PC-541752-407729 541752-407729 PC-541752-407730 541752-407730 PC-541752-407731 541752-407731 PC-541752-407732 541752-407732 PC-541752-407733 541752-407733 PC-541752-407734 541752-407734 PC-541752-407735 541752-407735