FLMatrix: Constructor function for FLMatrix.

In Fuzzy-Logix/AdapteR: Converts R syntax to SQL to provide fast analytics using in-database C++ library DB Lytix.

Description

FLMatrix constructs an object of class FLMatrix.

Usage

FLMatrix(table_name, matrix_id_value = "", matrix_id_colname = "",
  row_id_colname = "rowIdColumn", col_id_colname = "colIdColumn",
  cell_val_colname = "valueColumn", dims = 0, dimnames = NULL,
  conditionDims = c(FALSE, FALSE), whereconditions = c(""),
  map_table = NULL, connection = getFLConnection(), type = "double",
  sparse = TRUE)

Arguments

table_name	name of the matrix table
matrix_id_value	identifier for the input matrix
matrix_id_colname	matrix id value in table_name
row_id_colname	column name in table_name where row numbers are stored
col_id_colname	column name in table_name where column numbers are stored
cell_val_colname	column name in table_name where matrix elements are stored
dimnames	list of dimension names to assign to the matrix
conditionDims	logical vector of length two representing if there are any conditions on dimensions
whereconditions	where conditions if any to reference the in-database matrix
map_table	in-database table name which stores the dimnames of the matrix. Not required if dimnames are already specified using dimnames
connection	ODBC/JDBC connection handle to the database.
database	name of the database
dim	vector representing the dimensions of the matrix

Details

FLMatrix object is an in-database equivalent to matrix object. This object is used as input for matrix operation functions.

Value

FLMatrix returns an object of class FLMatrix mapped to an in-database matrix.

Examples

flmatrix <- FLMatrix("tblMatrixMulti",
                     5, "Matrix_id","ROW_ID","COL_ID","CELL_VAL")
flmatrix

Fuzzy-Logix/AdapteR documentation built on May 6, 2019, 5:07 p.m.