SQLEngineering extends the T-SQL scripting environment to add direct support for technical, engineering and scientific applications at the database layer.
Performing data analysis from within the database tends to be much faster and more efficient than transporting the data across the network to a client application, and also allows simpler and cleaner application architectures.
The functions can be used within your T-SQL scripts and stored procedures in exactly the same way as built-in T-SQL functions such as EXP, SQRT, POW etc, and are equally as fast even across large datasets.
Included in SQLEngineering is a comprehensive implementation of complex number arithmetic including a full set of 53 trigonometric, hyperbolic, logarithmic, exponential and arithmetic functions that support complex, imaginary or real numbers as inputs and outputs.
Also included are:
- Number base conversions between decimal, hexadecimal, binary, octal and base64.
- Unit conversions for over 196 different units of measure (including distance, velocity, acceleration, area, volume, mass, density, pressure, flow, energy, power, time, temperature, flux, angle etc). Includes full support for all metric prefixes.
- Cylindrical and Spherical Bessel / Neumann functions.
- Laguerre, Legendre, Hermite polynomials and Spherical Harmonics.
- Elliptical integrals.
- Error functions.