Login     Register

        Contact Us     Search

XLeratorDB - Math Functions for SQL Server

 

XLeratorDB / math lets you realize the full power of SQL Server with in-database processing. Invoke dozens of standard mathematical functions within the database – curve fitting, random and series number generators, a product and matrix math functions. And run them without having to export data to another application, without having to use Reporting Services, and without having to write complicated T-SQL statements or stored procedures.

If you know T-SQL and have used Excel, you will find these familiar functions so easy to use that you could be getting results within minutes after installing them. SQL Server can hold more than a terabyte of critical information; XLeratorDB/math gives you the key to unlocking its full value.

XLeratorDB/math includes over 180 SQL Server functions for:

  • Arithmetic/Algebra - PRODUCT, MROUND, WAVG, GCD, QUOTIENT, PRODUCT38, DISTANCE, etc.
  • Trigonometry - ACOSH, SEC, CSC, TANH, etc.
  • Number Generators - RANDBETWEEN, SERIESINT, RANDNORMAL, etc.
  • Interpolations - INTERP, SPLINE, POLYFIT, POLYINTERP, etc.
  • Numerical Integration - QUAD, QUADTS, QUADOSC, etc.
  • Matrix Functions - MMULT, MINVERSE, QRdecomp, LUdecomp, BKSUB, FWDSUB, TRANSPOSE, etc.

XLeratorDB / math adds dozens of new mathematical tools (that are precisely matched to Excel) to the two dozen native functions built into SQL Server. Plus, there are additional functions for the kind of large dataset analytics you wouldn’t dream of doing in a spreadsheet application.

XLeratorDB lets you apply the same sophisticated tools found in high-end analytic applications, but at a fraction of the cost and network overheads.

 


 

Testimonials

Copyright 2008-2024 Westclintech LLC         Privacy Policy        Terms of Service