SQLDistributions
by TotallySQL - Product Type: Component / .NET Class / 100% Managed Code
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).
Our regular prices are shown below. Please logon to see your discounted prices.
SQLDistributions - CAL (Client Access License) V1.0
| Add to Cart | $ 146.02 | 1 CAL License | Download (838 KB) | |
| Add to Cart | $ 489.02 | 5 CAL License | Download (838 KB) | |
| Add to Cart | $ 783.02 | 10 CAL License | Download (838 KB) | |
| Add to Cart | $ 1,469.02 | 25 CAL License | Download (838 KB) | |
| Add to Cart | $ 2,449.02 | 50 CAL License | Download (838 KB) |
SQLDistributions - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance
| Add to Cart | $ 175.22 | 1 CAL License | Download (838 KB) | |
| Add to Cart | $ 583.88 | 5 CAL License | Download (838 KB) | |
| Add to Cart | $ 939.62 | 10 CAL License | Download (838 KB) | |
| Add to Cart | $ 1,762.82 | 25 CAL License | Download (838 KB) | |
| Add to Cart | $ 2,938.82 | 50 CAL License | Download (838 KB) |
SQLDistributions - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance
| Add to Cart | $ 204.43 | 1 CAL License | Download (838 KB) | |
| Add to Cart | $ 684.63 | 5 CAL License | Download (838 KB) | |
| Add to Cart | $ 1,096.23 | 10 CAL License | Download (838 KB) | |
| Add to Cart | $ 2,056.63 | 25 CAL License | Download (838 KB) | |
| Add to Cart | $ 3,428.63 | 50 CAL License | Download (838 KB) |
SQLDistributions - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance
| Add to Cart | $ 233.63 | 1 CAL License | Download (838 KB) | |
| Add to Cart | $ 782.82 | 5 CAL License | Download (838 KB) | |
| Add to Cart | $ 1,252.83 | 10 CAL License | Download (838 KB) | |
| Add to Cart | $ 2,350.43 | 25 CAL License | Download (838 KB) | |
| Add to Cart | $ 3,918.43 | 50 CAL License | Download (838 KB) |
SQLDistributions CAL (Client Access License) - 1 Year Support & Maintenance Renewal
| Add to Cart | $ 29.20 | 1 CAL Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 97.80 | 5 CAL Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 156.60 | 10 CAL Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 293.80 | 25 CAL Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 489.80 | 50 CAL Support & Maintenance Renewal License | Verify | Download (838 KB) |
SQLDistributions CAL (Client Access License) - 3 Year Support & Maintenance Renewal
| Add to Cart | $ 58.41 | 1 CAL Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 195.61 | 5 CAL Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 313.21 | 10 CAL Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 587.61 | 25 CAL Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 979.61 | 50 CAL Support & Maintenance Renewal License | Verify | Download (838 KB) |
SQLDistributions CAL (Client Access License) - 5 Year Support & Maintenance Renewal
| Add to Cart | $ 87.61 | 1 CAL Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 293.41 | 5 CAL Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 469.81 | 10 CAL Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 881.41 | 25 CAL Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 1,469.41 | 50 CAL Support & Maintenance Renewal License | Verify | Download (838 KB) |
SQLDistributions - CPU License V1.0
| Add to Cart | $ 2,449.02 | 1 CPU License | Download (838 KB) | |
| Add to Cart | $ 3,919.02 | 2 CPU License | Download (838 KB) | |
| Add to Cart | $ 5,879.02 | 4 CPU License | Download (838 KB) | |
| Add to Cart | $ 9,795.10 | 8 CPU License | Download (838 KB) | |
| Add to Cart | $ 15,674.12 | Unlimited CPU License | Download (838 KB) |
SQLDistributions - CPU License V1.0 with - 1 Year Support & Maintenance
| Add to Cart | $ 2,938.82 | 1 CPU License | Download (838 KB) | |
| Add to Cart | $ 4,702.82 | 2 CPU License | Download (838 KB) | |
| Add to Cart | $ 7,054.82 | 4 CPU License | Download (838 KB) | |
| Add to Cart | $ 11,754.12 | 8 CPU License | Download (838 KB) | |
| Add to Cart | $ 18,808.94 | Unlimited CPU License | Download (838 KB) |
SQLDistributions - CPU License V1.0 with - 3 Year Support & Maintenance
| Add to Cart | $ 3,428.63 | 1 CPU License | Download (838 KB) | |
| Add to Cart | $ 5,486.63 | 2 CPU License | Download (838 KB) | |
| Add to Cart | $ 8,230.63 | 4 CPU License | Download (838 KB) | |
| Add to Cart | $ 13,713.14 | 8 CPU License | Download (838 KB) | |
| Add to Cart | $ 21,943.77 | Unlimited CPU License | Download (838 KB) |
SQLDistributions - CPU License V1.0 with - 5 Year Support & Maintenance
| Add to Cart | $ 3,918.43 | 1 CPU License | Download (838 KB) | |
| Add to Cart | $ 6,270.43 | 2 CPU License | Download (838 KB) | |
| Add to Cart | $ 9,406.43 | 4 CPU License | Download (838 KB) | |
| Add to Cart | $ 15,672.16 | 8 CPU License | Download (838 KB) | |
| Add to Cart | $ 25,078.59 | Unlimited CPU License | Download (838 KB) |
SQLDistributions CPU License - 1 Year Support & Maintenance Renewal
| Add to Cart | $ 489.80 | 1 CPU Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 783.80 | 2 CPU Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 1,175.80 | 4 CPU Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 1,959.02 | 8 CPU Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 3,134.82 | Unlimited CPU Support & Maintenance Renewal License | Verify | Download (838 KB) |
SQLDistributions CPU License - 3 Year Support & Maintenance Renewal
| Add to Cart | $ 979.61 | 1 CPU Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 1,567.61 | 2 CPU Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 2,351.61 | 4 CPU Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 3,918.04 | 8 CPU Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 6,269.65 | Unlimited CPU Support & Maintenance Renewal License | Verify | Download (838 KB) |
SQLDistributions CPU License - 5 Year Support & Maintenance Renewal
| Add to Cart | $ 1,469.41 | 1 CPU Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 2,351.41 | 2 CPU Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 3,527.41 | 4 CPU Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 5,877.06 | 8 CPU Support & Maintenance Renewal License | Verify | Download (838 KB) |
| Add to Cart | $ 9,404.47 | Unlimited CPU Support & Maintenance Renewal License | Verify | Download (838 KB) |
Our prices include ComponentSource technical support and, for most downloadable products, an online backup and a FREE upgrade to the new version if it is released within 30 days of your purchase. All sales are made on our standard Terms and Conditions and subject to our Return Policy. Please contact us if you require any licensing option not listed, including volume licensing and previous versions.
Our regular prices are shown above. Please logon to see your discounted prices.
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)
in association with
Select Business Solutions Catalog
The products shown in this catalog are specially selected for Select Business Solutions users.
Quick Links
Publisher
- TotallySQL (10)
Primary Category
- Maths and Stats (46)
Related Products
Related Categories
- SQL (140)