SQLMath - Summary

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

Summary

SQLMath by TotallySQL

URLs: sqlmath, totallysql

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.

SQLMath Includes

17 additional trigonometric and hyperbolic functions that complement the 8 built-in trigonometric functions in T-SQL.

12 advanced rounding, truncation and modular arithmetic functions.

A comprehensive implementation of matrices as SQL types and of matrix (and vector) arithmetic including 20 matrix-based functions and operations.

7 table-valued numerical series generators including arithmetic, geometric and harmonic series, alternating harmonic series, the p-series, prime numbers up to 263, and the Fibonacci sequence.

28 other general functions covering areas such as prime numbers, factorials, greatest common divisors, least common multiples, summation of series, and logs, powers, exponents and roots.

Beyond Excel

Among these functions are numerically faithful equivalents of mathematical functions found in Microsoft Excel and similar packages, but also many others which - combined with the innate power and ability of SQL Server to rapidly crunch through huge volumes of data - gives you an analytical capability that completely blows away anything you could do with spreadsheets.

Native Look and Feel

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 such as SIN, LOG etc.

Outstanding Performance and Numerical Accuracy

The algorithms behind the SQLMath functions 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.

Multi-Valued Aggregates - even in SQL2005

Several of the SQLMath functions (for example most of the summations) are in the form of aggregate functions that take multiple input values. This works fine for SQL2008 but is commonly supposed to be impossible in SQL2005 - since you can supply only one input parameter to an aggregate function. TotallySQL have, however, devised a very simple but smart way of doing this in SQL2005 using SQLTuples: you simply combine the input parameters (of any type) into a SQLTuples object on-the-fly as part of the function call. Only a very minor syntax change is needed and there is no measurable performance penalty even when used with truly enormous data sets.

SQLMath Features

Number sequences: arithmetic, geometric, harmonic, alternating harmonic, p-series & Fibonacci

Modular multiplication and modular powers of very large integers, quotients

Rounding to specified multiples, decimal places & significant figures

Factorial, double factorial, rising & falling factorials, log of factorial, binomial / multinomial coefficients

Return nth prime, next prime, nth next prime, table of prime numbers, test of primeness

Summations: sum (x.y), sum(x2), sum (x2-y2), sum((x-y)2), sum(x2+y2), sum(aix(n+im))

Greatest common divisor & least common multiple of 2 numbers or of an entire dataset

Cube root & hypotenuse (suitable for difficult values of x)

Accurate computation of ex-1, ln(x+1) & sqrt(x+1) for small x, and of xy-1 for x near 1 or small y

Trigonometric functions SEC & CSC and inverse functions ACOT, ACSC, ASEC

Hyperbolic functions COSH, SINH, TANH, SECH, CSCH, COTH and inverses ACOSH, ASINH etc

Conversion of numbers up to 9,999,999 into Roman numerals

Matrix type: n x m matrices that can be stored in tables & local variables

Aggregate constructor (table to matrix) & table-valued serializer (matrix to table) for matrices

Add, subtract, multiply & compare matrices.Swap rows & columns, scale matrix, scale row, scale column, transpose, clone matrix

Read and set individual matrix elements, return row & column counts

Find determinant, inverse and reduced-row echelon form for matrices

A complete toolkit of over 80 functions & features for mathematical computing.

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

Evals & Downloads: Read the SQLMath help file, Read the TotallySQL License Agreement, Download the SQLMath 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: SQLMath

totally sql

Math Stats Mathematics Mathematical Statistic Statistical

SQL query language

Part numbers: PC-541782-407561 541782-407561 PC-541782-407562 541782-407562 PC-541782-407563 541782-407563 PC-541782-407564 541782-407564 PC-541782-407565 541782-407565 PC-541782-407566 541782-407566 PC-541782-407567 541782-407567 PC-541782-407568 541782-407568 PC-541782-407569 541782-407569 PC-541782-407570 541782-407570 PC-541782-407571 541782-407571 PC-541782-407572 541782-407572 PC-541782-407573 541782-407573 PC-541782-407574 541782-407574 PC-541782-407575 541782-407575 PC-541782-407576 541782-407576 PC-541782-407577 541782-407577 PC-541782-407578 541782-407578 PC-541782-407579 541782-407579 PC-541782-407580 541782-407580 PC-541782-407581 541782-407581 PC-541782-407582 541782-407582 PC-541782-407583 541782-407583 PC-541782-407584 541782-407584 PC-541782-407585 541782-407585 PC-541782-407586 541782-407586 PC-541782-407587 541782-407587 PC-541782-407588 541782-407588 PC-541782-407589 541782-407589 PC-541782-407590 541782-407590 PC-541782-407591 541782-407591 PC-541782-407592 541782-407592 PC-541782-407593 541782-407593 PC-541782-407594 541782-407594 PC-541782-407595 541782-407595 PC-541782-407841 541782-407841 PC-541782-407842 541782-407842 PC-541782-407843 541782-407843 PC-541782-407844 541782-407844 PC-541782-407845 541782-407845 PC-541782-407846 541782-407846 PC-541782-407847 541782-407847 PC-541782-407848 541782-407848 PC-541782-407849 541782-407849 PC-541782-407850 541782-407850 PC-541782-407851 541782-407851 PC-541782-407852 541782-407852 PC-541782-407853 541782-407853 PC-541782-407854 541782-407854 PC-541782-407855 541782-407855 PC-541782-407856 541782-407856 PC-541782-407857 541782-407857 PC-541782-407858 541782-407858 PC-541782-407859 541782-407859 PC-541782-407860 541782-407860 PC-541782-407861 541782-407861 PC-541782-407862 541782-407862 PC-541782-407863 541782-407863 PC-541782-407864 541782-407864 PC-541782-407865 541782-407865 PC-541782-407866 541782-407866 PC-541782-407867 541782-407867 PC-541782-407868 541782-407868 PC-541782-407869 541782-407869 PC-541782-407870 541782-407870 PC-541782-407871 541782-407871 PC-541782-407872 541782-407872 PC-541782-407873 541782-407873 PC-541782-407874 541782-407874 PC-541782-407875 541782-407875