TotallySQL / .NET Components and .NET Controls

• 1. SQLDistributions

  

  Zoom [+]

  Publisher: TotallySQL  Primary Category: Maths and Stats  Product Type: Component / .NET Class / 100% Managed Code

  Evaluation of PDF, CDF and their inverses; summary statistics; parameter estimation; high-volume random variate generation and much more. SQLDistributions extends and enhances your T-SQL programming environment by adding full-featured and highly accurate SQL implementations of 28 probability distributions. For each of these distributions the following functions are available: probability density function (pdf) and its inverse; cumulative density function (cdf) & its complement; quantile (inverse cdf) and its complement; hazard function; cumulative hazard function (chf), mean; median; mode; variance; standard deviation; skewness; kurtosis; percentile; percentilerank, flags: symmetric; unimodal; discontinuous (on left or right); strictly increasing / decreasing; inverted, minimum & maximum defined values for x; minimum & maximum supported values for x; minimum & maximum values of pdf, high-performance scalar and table-valued random variate generators (to generate random numbers that are distributed as per the distribution).

    View More

• 2. SQLEngineering

  

  Zoom [+]

  Publisher: TotallySQL  Primary Category: Maths and Stats  Product Type: Component / .NET Class / 100% Managed Code

  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.

    View More

• 3. SQLFile

  

  Zoom [+]

  Publisher: TotallySQL  Primary Category: File Handling  Product Type: Component / .NET Class / 100% Managed Code

  External file and directory access with data import/export and compression. SQLFile extends and enhances your T-SQL programming environment by exposing the full range of .NET Framework file & directory management functions - and adds the ability to directly import and export data, and to compress both binary and text data stored internally in the database. SQLFile functions include: read & write binary, text & delimited files (e.g. CSV); check for, create, move, copy & delete files & directories; encrypt & decrypt files; compress & decompress file images in the database; manage file access & audit rules; check & alter file attributes; get disk information.

    View More

• 4. SQLFinancials

  

  Zoom [+]

  Publisher: TotallySQL  Primary Category: Financial  Product Type: Component / .NET Class / 100% Managed Code

  The analytical capability of Excel with the raw data-crunching power of SQL Server. SQLFinancials extends and enhances your T-SQL programming environment by adding 50+ powerful new financial functions and aggregates that faithfully replicate and extend all the financial analysis features available in Microsoft Excel. SQLFinancials includes: 29 functions for calculating yields, rates, coupon periods etc. for corporate and government bonds, 7 functions for calculating depreciation on various bases, 15 functions for calculating interest payments, rates, principal payments, durations, present and future values etc. for loans or investments, 3 functions for calculating internal rates of return for a series of cashflows and 2 functions for converting between dollar fractions and decimal values.

    View More

• 5. SQLMath

  

  Zoom [+]

  Publisher: TotallySQL  Primary Category: Maths and Stats  Product Type: Component / .NET Class / 100% Managed Code

  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.

    View More

• 6. SQLRollingStats

  

  Zoom [+]

  Publisher: TotallySQL  Primary Category: Maths and Stats  Product Type: Component / .NET Class / 100% Managed Code

  Compute running totals, moving averages, and many other statistics that need relative row references, within T-SQL queries. SQLRollingStats is a solution for SQL Server that extends and enhances your T-SQL programming environment by adding 30+ statistical window functions - allowing the computation of results per row that depend on values in other rows. All functions are capable of taking into account all rows so far processed, or just the last n rows where n is the specified window size. Functions include: sum, product, maximum, minimum, range, mid-range, first (in sequence), nth previous, average (mean), variance (sample & population), standard deviation (sample & population), geometric mean, harmonic mean, quadratic mean, median, quartile, inter-quartile range, tri-mean, percentile, percentile rank, exponential average (mean), exponential variance, exponential standard deviation, weighted average, weighted variance (sample & population), weighted standard deviation (sample & population), weighted power mean.

    View More

• 7. SQLStatistics

  

  Zoom [+]

  Publisher: TotallySQL  Primary Category: Maths and Stats  Product Type: Component / .NET Class / 100% Managed Code

  Every kind of statistical test and metric built right into the database layer. SQLStatistics extends and enhances your Transact-SQL programming environment by adding 80+ powerful new functions and aggregates. Functions include a portfolio of tests and metrics of correlation, similarity or dependence between datasets, including chi-squared tests of independence and goodness of fit; covariance metrics; F-tests to compare variances; paired and unpaired Student's-T tests to compare means; Pearson's product moment correlation coefficient and its square; the Fisher transformation; and the Z-test. SQLStatistics also includes a broad range of descriptive statistics including geometric, harmonic and quadratic means; truncated and inter-quartile means and the tri-mean; modes of both continuous and discrete data; medians, quartiles, percentiles, percentile rank and absolute rank; skewness and kurtosis; weighted averages, variances, standard deviations and power means; range, mid-range, inter-quartile range, nth largest, nth smallest and more.

    View More

• 8. SQLUtilities

  

  Zoom [+]

  Publisher: TotallySQL  Primary Category: SQL  Product Type: Component / .NET Class / 100% Managed Code

  Powerful functions for string, date and time manipulation. SQLUtilities extends and enhances your T-SQL programming environment by adding: 21 date and time related functions, including a table-valued date and time sequence generator; random date and time generators; working days calculations; date and time arithmetic; formatting, parsing and type conversion, 37 string and text processing functions including string concatenation functions and aggregates; scalar and table-valued tokenized string parsing; advanced formatting, searching and substitution; regular expressions processing; collation-free comparisons; type conversions., 3 useful numeric functions - including a table-valued numberline sequence generator - allowing you to generate any required set of incremental numeric values of any size on the fly without having to create and maintain lookup tables, and two excel-like random number generators that are easier to use than the built-in T-SQL RAND() function and 3 relative column reference aggregate functions, allowing you to select values from multiple columns in an aggregation from the row that contains the maximum, minimum or a matching value of one column.

    View More

• 9. TotallySQL Universal Bundle

  

  Zoom [+]

  Publisher: TotallySQL  Primary Category: Product Suites  Product Type: Component / Application / .NET Class / 100% Managed Code

  A comprehensive range of CLR function libraries and management tools to extend the T-SQL language. TotallySQL Universal Bundle includes all products available from TotallySQL. It includes the Assembly Manager application and all 8 function libraries (SQLDistributions, SQLEngineering, SQLFile, SQLFinancials, SQLMath, SQLRollingStats, SQLStatistics and SQLUtilities). The libraries enable advanced processing to be carried out within the database itself.

    View More

Buy Online or Call : (888)_ 850 9911  

Help | Logon | Register | Japanese Site