數學和統計 / SQL Server

• 1. SQLDistributions

  

  放大 [+]

  發佈者: TotallySQL  首要類別: 數學和統計  產品類型: 構件 / .NET 類 / 100% 受控代碼

   * 

  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).

    查看更多

• 2. SQLEngineering

  

  放大 [+]

  發佈者: TotallySQL  首要類別: 數學和統計  產品類型: 構件 / .NET 類 / 100% 受控代碼

   * 

  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.

    查看更多

• 3. SQLMath

  

  放大 [+]

  發佈者: TotallySQL  首要類別: 數學和統計  產品類型: 構件 / .NET 類 / 100% 受控代碼

   * 

  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.

    查看更多

• 4. SQLRollingStats

  

  放大 [+]

  發佈者: TotallySQL  首要類別: 數學和統計  產品類型: 構件 / .NET 類 / 100% 受控代碼

   * 

  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.

    查看更多

• 5. SQLStatistics

  

  放大 [+]

  發佈者: TotallySQL  首要類別: 數學和統計  產品類型: 構件 / .NET 類 / 100% 受控代碼

   * 

  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.

    查看更多

• 6. SQLFinancials

  

  放大 [+]

  發佈者: TotallySQL  首要類別: 財務  產品類型: 構件 / .NET 類 / 100% 受控代碼

   * 

  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.

    查看更多

• 7. TotallySQL Universal Bundle

  

  放大 [+]

  發佈者: TotallySQL  首要類別: 產品套件  產品類型: 構件 / 應用程式 / .NET 類 / 100% 受控代碼

   * 

  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.

    查看更多

線上購買或致電 : (888)_ 850 9911  

幫助 | 登錄 | 註冊 | 日語網站