Maths and Stats / SQL Server Tools & SQL Server Utilities

• 1. SQLDistributions

  

  Zoom [+]

  Publisher: TotallySQL  Primary Category: Maths and Stats  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).

    View More

• 2. SQLEngineering

  

  Zoom [+]

  Publisher: TotallySQL  Primary Category: Maths and Stats  Product Type: Component / .NET Class / 100% Managed Code

  Over 100 specialized functions & features for technical & engineering use. SQLEngineering extends and enhances your T-SQL programming environment by adding a suite of 110+ advanced mathematical functions for scientific and engineering use, including: complex numbers with full math library; unit & number base conversions; Bessel functions; elliptical integrals; Legendre, Laguerre & Hermite polynomials; spherical harmonics; error functions and more.

    View More

• 3. SQLMath

  

  Zoom [+]

  Publisher: TotallySQL  Primary Category: Maths and Stats  Product Type: Component / .NET Class / 100% Managed Code

  A complete toolkit of over 80 functions & features for mathematical computing. SQLMath extends and enhances your T-SQL programming environment by adding sequence generators; matrices; matrix arithmetic; trigonometric & hyperbolic functions; prime numbers; factorials; GCD/LCM; logs, powers exponents & roots; rounding, truncation & modular arithmetic and more.

    View More

• 4. SQLRollingStats

  

  Zoom [+]

  Publisher: TotallySQL  Primary Category: Maths and Stats  Product Type: Component / .NET Class / 100% Managed Code

  Compute running totals, moving averages, and many other statistics that need relative row references, within T-SQL queries. SQLRollingStats is a solution for SQL Server that extends and enhances your T-SQL programming environment by adding 30+ statistical window functions - allowing the computation of results per row that depend on values in other rows. All functions are capable of taking into account all rows so far processed, or just the last n rows where n is the specified window size. Functions include: sum, product, maximum, minimum, range, mid-range, first (in sequence), nth previous, average (mean), variance (sample & population), standard deviation (sample & population), geometric mean, harmonic mean, quadratic mean, median, quartile, inter-quartile range, tri-mean, percentile, percentile rank, exponential average (mean), exponential variance, exponential standard deviation, weighted average, weighted variance (sample & population), weighted standard deviation (sample & population), weighted power mean.

    View More

• 5. SQLStatistics

  

  Zoom [+]

  Publisher: TotallySQL  Primary Category: Maths and Stats  Product Type: Component / .NET Class / 100% Managed Code

  Every kind of statistical test and metric built right into the database layer. SQLStatistics extends and enhances your Transact-SQL programming environment by adding 80+ powerful new functions and aggregates. Functions include a portfolio of tests and metrics of correlation, similarity or dependence between datasets, including chi-squared tests of independence and goodness of fit; covariance metrics; F-tests to compare variances; paired and unpaired Student's-T tests to compare means; Pearson's product moment correlation coefficient and its square; the Fisher transformation; and the Z-test. SQLStatistics also includes a broad range of descriptive statistics including geometric, harmonic and quadratic means; truncated and inter-quartile means and the tri-mean; modes of both continuous and discrete data; medians, quartiles, percentiles, percentile rank and absolute rank; skewness and kurtosis; weighted averages, variances, standard deviations and power means; range, mid-range, inter-quartile range, nth largest, nth smallest and more.

    View More

• 6. SQLFinancials

  

  Zoom [+]

  Publisher: TotallySQL  Primary Category: Financial  Product Type: Component / .NET Class / 100% Managed Code

  The analytical capability of Excel with the raw data-crunching power of SQL Server. SQLFinancials extends and enhances your T-SQL programming environment by adding 50+ powerful new financial functions and aggregates that faithfully replicate and extend all the financial analysis features available in Microsoft Excel. SQLFinancials includes: 29 functions for calculating yields, rates, coupon periods etc. for corporate and government bonds, 7 functions for calculating depreciation on various bases, 15 functions for calculating interest payments, rates, principal payments, durations, present and future values etc. for loans or investments, 3 functions for calculating internal rates of return for a series of cashflows and 2 functions for converting between dollar fractions and decimal values.

    View More

• 7. TotallySQL Universal Bundle

  

  Zoom [+]

  Publisher: TotallySQL  Primary Category: Product Suites  Product Type: Component / Application / .NET Class / 100% Managed Code

  A comprehensive range of CLR function libraries and management tools to extend the T-SQL language. TotallySQL Universal Bundle includes all products available from TotallySQL. It includes the Assembly Manager application and all 8 function libraries (SQLDistributions, SQLEngineering, SQLFile, SQLFinancials, SQLMath, SQLRollingStats, SQLStatistics and SQLUtilities). The libraries enable advanced processing to be carried out within the database itself.

    View More

Buy Online or Call : (888)_ 850 9911  

Help | Logon | Register | Japanese Site