Difference between revisions of "AVA SQL"

Revision as of 13:37, 14 May 2013

AVA Database follows SQL '92 standard. In addition, AVA's unique SQL adds new features that facilitate high speed analytics and data mining.

Analytics Functions

Mathematical Functions ID_MODULUS  % ID_XOR || ID_POW ^ ID_FACTORIAL  ! ID_ABS ABS() ID_EXP EXP() ID_SIGN SIGN() ID_SQRT SQRT() ID_LOG LOG() ID_LOG10 LOG10() ID_SIN SIN() ID_COS COS() ID_TAN TAN() ID_ASIN ASIN() ID_ACOS ACOS() ID_ATAN ATAN() ID_FFACTORIAL FACTORIAL()

Statistical Functions

ID_SUM ID_AVG ID_SDV ID_MIN ID_MAX

Other Functions ID_COUNT ID_FIRST ID_LAST ID_WSUM ID_WAVG ID_WSTD ID_WMIN ID_WMAX ID_WCOUNT ID_CUMSUM ID_CUMPROD ID_EMA ID_RANK ID_XRANK

Table Join Functions

Data Conversion Functions