FLTableMD: Constructor function for FLTableMD.

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

Description

FLTableMD constructs an object of class FLTableMD.

Usage

FLTableMD(table, group_id_colname, obs_id_colname,
  var_id_colnames = character(0), cell_val_colname = character(0),
  whereconditions = character(0), connection = getFLConnection(),
  dims = list(0, 0, 0), sparse = TRUE, dimnames = list(list(NULL),
  list(NULL), list(NULL)), ...)

Arguments

table	name of the table
group_id_colname	column name identifying the datasets
obs_id_colname	column name set as primary key
cell_val_colname	column name where cell values are stored if FLTableMD is deep
database	name of the database
var_id_colname	column name where variable id's are stored if FLTableMD is deep
group_id	vector of dataset IDs'to be considered. Default is all those contained in the table

Details

FLTableMD refers to an in-database table with multiple data sets. This object is commonly used as input for some data mining functions which operate parallelly on all the datasets

Value

FLTableMD returns an object of class FLTableMD mapped to a table in database

Examples

widetableMD <- FLTableMD(table="tblAutoMPGMD",
                      group_id_colname="GroupID",
                      obs_id_colname="ObsID")
deeptableMD <- FLTableMD(table="LinRegrMultiMD",
                      group_id_colname="DatasetID",
                      obs_id_colname="ObsID",
                      var_id_colname="VarID",
                      cell_val_colname="Num_Val")
head(widetableMD)
head(deeptableMD)

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