por TotallySQL - Tipo de produto: Componente / Classe .NET / Código 100% gerenciado
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.
Cylindrical and Spherical Bessel / Neumann functions
Laguerre, Legendre, Hermite polynomials and Spherical Harmonics
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)
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.
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.
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
Math Stats Mathematics Mathematical Statistic Statistical
SQL query language