SQLEngineering - Sommario

SQLEngineering by TotallySQL

URLs: sqlengineering, totallysql

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.

SQLEngineering includes:

Cylindrical and Spherical Bessel / Neumann functions

Laguerre, Legendre, Hermite polynomials and Spherical Harmonics

Elliptical integrals

Error functions

Exponential integrals

Complex numbers implemented as a new SQL type including 53 different arithmetic, trigonometric and hyperbolic functions

Number base conversions between decimal, hexadecimal, binary, octal and base64

Unit conversions for 190+ different units of measure (including distance, velocity, acceleration, area, volume, mass, density, pressure, flow, energy, power, time, temperature, flux, angle etc)

Beyond Excel

A few of the functions available in SQLEngineering (e.g. some of the base and unit conversions) are numerically faithful equivalents of similar functions found in Microsoft Excel, but offer a much broader range of functionality. These - and the many additional functions that have no analogue in Excel - use the innate power and ability of SQL Server to rapidly crunch through huge volumes of data - giving 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 functions such as SUM, AVG etc.

Outstanding Performance and Numerical Accuracy

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

SQLEngineering Features

Cylindrical & spherical Bessel / Neumann functions

Elliptical integrals in Carlson symmetric and Legendre forms

Legendre, Laguerre & Hermite polynomials & spherical harmonics

Error function, its complement and their inverses

Exponential integrals Number base conversions between decimal, hexadecimal, octal, binary and base64

Unit conversions to / from 196 different units with support for metric prefixes kilo, mega etc

Complex number type that can be stored in tables & local variables

Complex number constructors for Cartesian (real, imag) & polar (magnitude, phase) inputs

Cartesian (real, imaginary) & polar (magnitude, phase) component accessor functions

Full set of trigonometric functions & inverses for complex numbers, returning complex results

Full set of hyperbolic functions & inverses for complex numbers, returning complex results

Addition, subtraction, multiplication & division for both complex / complex & complex / real

Logs of complex numbers to base e, base 10 & to any complex, real or imaginary base Exponents of complex numbers & powers to any complex, real or imaginary power

Conjugate, negation & comparison of complex numbers

Over 100 specialized functions & features for technical & engineering use.

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

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

totally sql

Math Stats Mathematics Mathematical Statistic Statistical

SQL query language

Part numbers: PC-541792-407456 541792-407456 PC-541792-407457 541792-407457 PC-541792-407458 541792-407458 PC-541792-407459 541792-407459 PC-541792-407460 541792-407460 PC-541792-407461 541792-407461 PC-541792-407462 541792-407462 PC-541792-407463 541792-407463 PC-541792-407464 541792-407464 PC-541792-407465 541792-407465 PC-541792-407466 541792-407466 PC-541792-407467 541792-407467 PC-541792-407468 541792-407468 PC-541792-407469 541792-407469 PC-541792-407470 541792-407470 PC-541792-407471 541792-407471 PC-541792-407472 541792-407472 PC-541792-407473 541792-407473 PC-541792-407474 541792-407474 PC-541792-407475 541792-407475 PC-541792-407476 541792-407476 PC-541792-407477 541792-407477 PC-541792-407478 541792-407478 PC-541792-407479 541792-407479 PC-541792-407480 541792-407480 PC-541792-407481 541792-407481 PC-541792-407482 541792-407482 PC-541792-407483 541792-407483 PC-541792-407484 541792-407484 PC-541792-407485 541792-407485 PC-541792-407486 541792-407486 PC-541792-407487 541792-407487 PC-541792-407488 541792-407488 PC-541792-407489 541792-407489 PC-541792-407490 541792-407490 PC-541792-407736 541792-407736 PC-541792-407737 541792-407737 PC-541792-407738 541792-407738 PC-541792-407739 541792-407739 PC-541792-407740 541792-407740 PC-541792-407741 541792-407741 PC-541792-407742 541792-407742 PC-541792-407743 541792-407743 PC-541792-407744 541792-407744 PC-541792-407745 541792-407745 PC-541792-407746 541792-407746 PC-541792-407747 541792-407747 PC-541792-407748 541792-407748 PC-541792-407749 541792-407749 PC-541792-407750 541792-407750 PC-541792-407751 541792-407751 PC-541792-407752 541792-407752 PC-541792-407753 541792-407753 PC-541792-407754 541792-407754 PC-541792-407755 541792-407755 PC-541792-407756 541792-407756 PC-541792-407757 541792-407757 PC-541792-407758 541792-407758 PC-541792-407759 541792-407759 PC-541792-407760 541792-407760 PC-541792-407761 541792-407761 PC-541792-407762 541792-407762 PC-541792-407763 541792-407763 PC-541792-407764 541792-407764 PC-541792-407765 541792-407765 PC-541792-407766 541792-407766 PC-541792-407767 541792-407767 PC-541792-407768 541792-407768 PC-541792-407769 541792-407769 PC-541792-407770 541792-407770