SQX Class

Structured Query Matrix for SQL Server

Inheritance Hierarchy

SystemObject
sqxSQX

Namespace: sqx
Assembly: SQX (in SQX.dll) Version: 1.0.2.6 (1.0.2.6)

Syntax

Copy

public class SQX

The SQX type exposes the following members.

Methods

	Name	Description
	AllOnesMatrix	Function [Matrix] AllOnesMatrix([int] m, [int] n)
	AUCFromGini	Function [float] AUCFromGini([float] Gini)
	Bin	Function [float] Bin([bigint] N, [bigint] K) (Mathematics)
	Bin_D	Function [float] Bin_D([bigint] N, [bigint] K) (Mathematics)
	BinSign	Function [int] BinSign([bigint] N, [bigint] K) (Mathematics)
	Copysign	Function [float] Copysign([float] Value1, [float] Value2)
	CorrelationMatrix	Procedure CorrelationMatrix [nvarchar](max) @Query, [bit] @Population, [bit] @SnapShot, [Matrix] @CorrelationMatrix OUTPUT
	CovarianceMatrix	Procedure CovarianceMatrix [nvarchar](max) @Query, [bit] @Population, [bit] @SnapShot, [Matrix] @CoVarianceMatrix OUTPUT
	EmpiricalTable	Function [table] EmpiricalTable([EmpiricalData] Summary) (Transformation) (Statistics)
	Expm1	Function [float] Expm1([float] X) (Mathematics)
	Factorial	Function [float] Factorial([int] n) (Mathematics)
	FindRound	Function [int] FindRound([float] X)
	FiveNumbersSummaryFencesTable	Function [table] FiveNumbersSummaryFencesTable([Vector] Summary, [float] InnerScale, [float] OuterScale) (Statistics)
	FiveNumbersSummaryTable	Function [table] FiveNumbersSummaryTable([Vector] Summary) (Statistics)
	GiniFromAUC	Function [float] GiniFromAUC([float] AUC)
	Hypot	Function [float] Hypot([float] X, [float] Y)
	IdentityMatrix	Function [Matrix] IdentityMatrix([int] n)
	IsEven	Function [bit] IsEven([sql_variant] Value)
	IsInt	Function [bit] IsInt([sql_variant] Value)
	IsOdd	Function [bit] IsOdd([sql_variant] Value)
	Lerp	Function Lerp([float] V0, [float] V1, [float] t)
	Log1p	Function [float] Log1p([float] X) (Mathematics)
	LogAdd	Function [float] LogAdd([float] X, [float] Y) (Mathematics)
	LogBin	Function [float] LogBin([bigint] N, [bigint] K) (Mathematics)
	LogBinTable	Function [table] LogBinTable([bigint] N, [bigint] K) (Mathematics)
	LogFactorial	Function [float] LogFactorial([int] n) (Mathematics)
	LogIf	Function [float] LogIf([float] X, [bit] Truth)
	Logit	Function [float] Logit([float] X) (Mathematics)
	LogSub	Function [float] LogSub([float] X, [float] Y) (Mathematics)
	MakeStep	Function [float] MakeStep([float] UnitStep, [int] Round)
	MatrixFromQuery	Procedure MatrixFromQuery [nvarchar](max) @Query, [bit] @Population, [Matrix] @A OUTPUT
	MatrixFromVector	Function [Matrix] MatrixFromVector([Vector] V, [bit] RowVector)
	MatrixToTable	Procedure MatrixToTable [Matrix] @A
	MeansDevsMatrix	Procedure MeansDevsMatrix [nvarchar](max) @Query, [bit] @Population, [bit] @SnapShot, [Matrix] @MeansDevsMatrix OUTPUT
	MeansDevsTable	Function [table] MeansDevsTable([Matrix] MeansDevsMatrix)
	MeanVarCorMatrix	Procedure MeanVarCorMatrix [nvarchar](max) @Query, [bit] @Population, [bit] @SnapShot, [Vector] Means, [Vector] Vars, [Matrix] @Cor OUTPUT
	MeanVarVectors	Procedure MeanVarVectors [nvarchar](max) @Query, [bit] @Population, [bit] @SnapShot, [Vector] Means, [Vector] Vars
	MinMaxMatrix	Procedure MinMaxMatrix [nvarchar](max) @Query, [bit] @SnapShot, [Matrix] @MinMaxMatrix OUTPUT
	MinMaxNormalizeTable	Function [table] MinMaxNormalizeTable([float] Value, [Vector] MinMax, [float] TargetMin, [float] TargetMax) (Transformation)
	MinMaxTable	Function [table] MinMaxTable([Matrix] MinMaxMatrix)
	MomentsTable	Function [table] MomentsTable([Vector] Summary) (Statistics)
	MutualInformationMatrix	Procedure MutualInformationMatrix [nvarchar](max) @Query, [bit] @SnapShot, [Matrix] @MIMatrix OUTPUT
	NRoot	Function [float] NRoot([int] Root, [float] X) (Mathematics)
	NTable	Function [table] NTable([int] StartValue, [int] EndValue)
	Permutation	Function [bigint] Permutation([int] n, [int] r) (Mathematics)
	PrincipalComponentAnalysisTable	Function [table] PrincipalComponentAnalysisTable([Matrix] A)
	RandomMatrix	Function [Matrix] RandomMatrix([int] m, [int] n, [int] Seed)
	RandomVector	Function [Vector] RandomVector([int] n, [int] Seed)
	RecFactorial	Function [float] RecFactorial([int] n) (Mathematics)
	RowMax	Function [float] RowMax([float] Value1, [float] Value2)
	RowMin	Function [float] RowMin([float] Value1, [float] Value2)
	SafeDiv	Function [float] SafeDiv([float] Numerator, [float] Denominator)
	SoftMax	Function [float] SoftMax([float] Value, [float] SoftMaxSum, [float] MaxValue) (Transformation)
	SoftMaxParametersTable	Function [table] SoftMaxParametersTable([Vector] SoftMaxSummary) (Transformation)
	SoftMaxTable	Function [table] SoftMaxTable([float] Value, [float] SoftMaxSum, [float] MaxValue) (Transformation)
	SoftMaxVectorTable	Function [table] SoftMaxVectorTable([float] Value, [Vector] SoftMaxSummary) (Transformation)
	StandardizeTable	Function [table] StandardizeTable([float] Value, [Vector] MeanDev) (Transformation)
	UTable	Function [table] UTable([int] N, [int] Seed)
	VectorFromQuery	Procedure VectorFromQuery [nvarchar](max) @Query, [bit] @Population, [Vector] @V OUTPUT
	VectorTable	Function [table] VectorTable([Vector] V)
	VectorToTable	Procedure VectorToTable [sql_variant] @ID, [Vector] @V
	VisualizeMatrixTableFromQuery	Procedure VisualizeMatrixTableFromQuery [nvarchar](max) @Query, [bit] @OrderByMax
	XTable	Function [table] XTable([float] StartValue, [float] EndValue, [float] StepValue)
	ZeroMatrix	Function [Matrix] ZeroMatrix([int] m, [int] n)
	ZeroVector	Function [Vector] ZeroVector([int] n)

Top

Remarks

Math References

https://dlmf.nist.gov/ NIST Digital Library of Mathematical Functions
https://en.wikipedia.org/wiki/Mathematics Wikipedia
https://encyclopediaofmath.org/ Encyclopedia Of Mathematics

Reference

sqx Namespace