final def !=(arg0: Any): Boolean

Definition Classes: AnyRef → Any

final def ##(): Int

Definition Classes: AnyRef → Any

def -(r2: Table): Table

Take the difference of 'this' table and 'r2' ('this - r2').

Take the difference of 'this' table and 'r2' ('this - r2'). Check that the two tables are compatible.

r2: the other table

Definition Classes: Table

final def ==(arg0: Any): Boolean

Definition Classes: AnyRef → Any

def add(tuple: Row): Unit

Add 'tuple to 'this' relation as a new row.

Add 'tuple to 'this' relation as a new row. FIX: want an efficient, covariant, mutable data structure, but Array is invariant.

tuple: an aggregation of columns values (new row)

Definition Classes: MM_Relation → Table

def add_2(tuple: Row): Unit

Add 'tuple' to 'this' relation as a new row.

Add 'tuple' to 'this' relation as a new row. Type is determined by sampling values for columns

tuple: an aggregation of columns values (new row)

final def asInstanceOf[T0]: T0

Definition Classes: Any

def clone(): AnyRef

Attributes: protected[java.lang]
Definition Classes: AnyRef
Annotations: @native() @throws( ... )

var col: Vector[Vec]

val colName: Seq[String]

def colNames: Seq[String]

Return the names of columns in the relation.

Definition Classes: MM_Relation → Table

def cols: Int

Return the size in terms of number of columns in the relation.

Definition Classes: MM_Relation → Table

def colsMap: Map[String, Int]

Return the mapping from column names to column positions.

Definition Classes: MM_Relation → Table

def column(cName: String): Vec

Return the column in the relation with column name 'cName'.

cName: column name used to retrieve the column vector

Definition Classes: MM_Relation → Table

def columns: Vector[Vec]

Return all of the columns in the table.

Definition Classes: MM_Relation → Table

def compress(cName: String*): Unit

Compress the selected columns 'cName' in 'this' table.

cName: the names of the columns to be compressed

Definition Classes: MM_Relation → Table

def contains(tuple: Row): Boolean

Determine whether 'this' relation contains a row matching the given 'tuple'.

tuple: an aggregation of columns values (potential row)

Definition Classes: MM_Relation → Table

def delete[T](p: Predicate[T]*): MM_Relation

Delete the rows from 'this' table that satisfy the predicates.

T: the predicate type
p: tuple(1): column name, tuple(2): predicate (T => Boolean)

Definition Classes: MM_Relation → Table

def disambiguate(cn1: Seq[String], cn2: Seq[String]): Seq[String]

Combine two sequences of column names and disambiguate any repeated names by appending "2".

cn1: the first sequence of column names
cn2: the second sequence of column names

Attributes: protected
Definition Classes: Table

val domain: String

def domains: String

Return the domains for the columns in the relation.

Definition Classes: MM_Relation → Table

def epi(aggCol: AggColumn*)(cName: String*): Table

Aggregate/project on the given columns (an extended projection operator that applies aggregate operators to aggregation columns and regular projection to projection columns).

aggCol: the columns to aggregate on: (aggregate function, new column name, old column name)*
cName: the other columns to project on

Definition Classes: Table
See also: en.wikipedia.org/wiki/Relational_algebra

def eproject(aggCol: AggColumn*)(cName: String*): Relation

Aggregate/project on the given columns (an extended projection operator that applies aggregate operators to aggregation columns and regular projection to projection columns).

aggCol: the columns to aggregate on: (aggregate function, new column name, old column name)*
cName: the other columns to project on

Definition Classes: MM_Relation → Table
See also: en.wikipedia.org/wiki/Relational_algebra

final def eq(arg0: AnyRef): Boolean

Definition Classes: AnyRef

def equals(arg0: Any): Boolean

Definition Classes: AnyRef → Any

var fKeys: Seq[(String, String, Int)]

def finalize(): Unit

Attributes: protected[java.lang]
Definition Classes: AnyRef
Annotations: @throws( classOf[java.lang.Throwable] )

final def flaw(method: String, message: String): Unit

Definition Classes: Error

final def getClass(): Class[_]

Definition Classes: AnyRef → Any
Annotations: @native()

def groupBy(cName: String*): MM_Relation

Group 'this' table by specified column names, returning 'this' table.

cName: group columns

Definition Classes: MM_Relation → Table

def hashCode(): Int

Definition Classes: AnyRef → Any
Annotations: @native()

def incompatible(_r2: Table): Boolean

Determine whether 'this' relation and 'r2' are incompatible by having differing numbers of columns or differing domain strings.

Definition Classes: MM_Relation → Table

def indices: Range

Return the range of index values for the table.

Definition Classes: Table

def intersect(_r2: Table): MM_Relation

Intersect 'this' relation and 'r2'.

Intersect 'this' relation and 'r2'. Check that the two relations are compatible.

Definition Classes: MM_Relation → Table

final def isInstanceOf[T0]: Boolean

Definition Classes: Any

def join[T](r2: Table, p0: Predicate2[T], p: Predicate2[T]*): MM_Relation

The theta join, handle the predicates in where are connect by "and" (where a....and b....).

r2: the second table
p0: the first theta join predicate (r1 cName, r2 cName, predicate to compare these two column)
p: the rest of theta join predicates (r1 cName, r2 cName, predicates to compare these two column)

Definition Classes: MM_Relation → Table

def join(cName: Seq[String], _r2: Table): MM_Relation

Join 'this' relation and 'r2 by performing a "natural-join".

Join 'this' relation and 'r2 by performing a "natural-join". Rows from both relations are compared requiring 'cName' values to be equal.

cName: the common join column names for both relation

Definition Classes: MM_Relation → Table

def join(cName1: Seq[String], cName2: Seq[String], _r2: Table): MM_Relation

Join 'this' relation and 'r2 by performing an "equi-join".

Join 'this' relation and 'r2 by performing an "equi-join". Rows from both relations are compared requiring 'cName1' values to equal 'cName2' values. Disambiguate column names by appending "2" to the end of any duplicate column name.

cName1: the join column names of this relation (e.g., the Foreign Key)
cName2: the join column names of relation r2 (e.g., the Primary Key)

Definition Classes: MM_Relation → Table

def join(cName1: String, cName2: String, r2: Table): Table

Join 'this' table and 'r2' by performing an "equi-join".

Join 'this' table and 'r2' by performing an "equi-join". Rows from both tables are compared requiring 'cName1' values to equal 'cName2' values. Disambiguate column names by appending "2" to the end of any duplicate column name.

cName1: the join column name of this table (e.g., the Foreign Key)
cName2: the join column name of table r2 (e.g., the Primary Key)
r2: the rhs table in the join operation

Definition Classes: Table

def join(cName: String, r2: Table): Table

Join 'this' table and 'r2' by performing a "natural-join".

Join 'this' table and 'r2' by performing a "natural-join". Rows from both tables are compared requiring 'cName' values to be equal.

cName: the common join column name for both table
r2: the rhs table in the join operation

Definition Classes: Table

def join(r2: Table): Table

Join 'this' table and 'r2' by performing a "natural-join".

Join 'this' table and 'r2' by performing a "natural-join". Rows from both tables are compared requiring agreement on common attributes (column names).

r2: the rhs table in the join operation

Definition Classes: Table

val key: Int

def leftJoin(thres: Double = 0.001)(cName1: String, cName2: String, r2: Table): MM_Relation

Join 'this' table and 'r2' by performing an "apprimate left-join".

Join 'this' table and 'r2' by performing an "apprimate left-join". Rows from both tables are compared requiring 'cName1' values to apprximately equal 'cName2' values. Disambiguate column names by appending "2" to the end of any duplicate column name. All rows from the left table are maintained with missing values indicators used where needed.

thres: the approximate equality threshold
cName1: the join column names of this table (e.g., the Foreign Key)
cName2: the join column names of table r2 (e.g., the Primary Key)
r2: the rhs table in the join operation

Definition Classes: MM_Relation → Table

def leftJoin(cName1: String, cName2: String, r2: Table): MM_Relation

Join 'this' table and 'r2' by performing an "left-join".

Join 'this' table and 'r2' by performing an "left-join". Rows from both tables are compared requiring 'cName1' values to equal 'cName2' values. Disambiguate column names by appending "2" to the end of any duplicate column name. All rows from the left table are maintained with missing values indicators used where needed.

cName1: the join column names of this table (e.g., the Foreign Key)
cName2: the join column names of table r2 (e.g., the Primary Key)
r2: the rhs table in the join operation

Definition Classes: MM_Relation → Table

def minus(_r2: Table): MM_Relation

Take the difference of 'this' relation and 'r2' ('this - r2').

Take the difference of 'this' relation and 'r2' ('this - r2'). Check that the two relations are compatible.

Definition Classes: MM_Relation → Table

val name: String

final def ne(arg0: AnyRef): Boolean

Definition Classes: AnyRef

final def notify(): Unit

Definition Classes: AnyRef
Annotations: @native()

final def notifyAll(): Unit

Definition Classes: AnyRef
Annotations: @native()

def orderBy(_cName: String*): MM_Relation

Order (ascending) the rows in the table by the selected columns 'cName'.

Order (ascending) the rows in the table by the selected columns 'cName'. A stable sorting is used to allow sorting on multiple columns.

Definition Classes: MM_Relation → Table

def pi(cPos: Seq[Int], cName: Seq[String] = null): Table

Project onto the columns with the given column positions.

cPos: the column positions to project onto
cName: the optional new names for the columns to project onto

Definition Classes: Table

def pi(cName: String*): Table

Project onto the columns with the given column names.

cName: the names of the columns to project onto

Definition Classes: Table

def pisigmaC(cName: String, p: (Complex) ⇒ Boolean): MM_Relation

Select elements from column 'cName' in 'this' relation that satisfy the predicate 'p' and project onto that column.

cName: the name of the column used for selection
p: the predicate (Boolean function) to be satisfied

Definition Classes: MM_Relation → Table

def pisigmaD(cName: String, p: (Double) ⇒ Boolean): MM_Relation

Definition Classes: MM_Relation → Table

def pisigmaI(cName: String, p: (Int) ⇒ Boolean): MM_Relation

Definition Classes: MM_Relation → Table

def pisigmaL(cName: String, p: (Long) ⇒ Boolean): MM_Relation

Definition Classes: MM_Relation → Table

def pisigmaQ(cName: String, p: (Rational) ⇒ Boolean): MM_Relation

Definition Classes: MM_Relation → Table

def pisigmaR(cName: String, p: (Real) ⇒ Boolean): MM_Relation

Definition Classes: MM_Relation → Table

def pisigmaS(cName: String, p: (StrNum) ⇒ Boolean): MM_Relation

Definition Classes: MM_Relation → Table

def product(r2: Table): MM_Relation

Compute the Cartesian product of 'this' table and 'r2' ('this × r2').

r2: the second table

Definition Classes: MM_Relation → Table

def project(cPos: Seq[Int], cName: Seq[String] = null): MM_Relation

Project onto the columns with the given column positions.

cPos: the column positions to project onto
cName: the optional new names for the columns to project onto

Definition Classes: MM_Relation → Table

def project(cName: String*): MM_Relation

Project onto the columns with the given column names.

cName: the names of the columns to project onto

Definition Classes: MM_Relation → Table

def rename(newName: String): MM_Relation

Rename 'this' table, returning a shallow copy of 'this' table.

newName: the new name for the table.

Definition Classes: MM_Relation → Table

def reverseOrderBy(_cName: String*): MM_Relation

Order (descending) the rows in the table by the selected columns 'cName'.

Order (descending) the rows in the table by the selected columns 'cName'. A stable sorting is used to allow sorting on multiple columns.

Definition Classes: MM_Relation → Table

def rightJoin(cName1: String, cName2: String, r2: Table): Table

Join 'this' table and 'r2' by performing an "right-join".

Join 'this' table and 'r2' by performing an "right-join". Rows from both tables are compared requiring 'cName1' values to equal 'cName2' values. Disambiguate column names by appending "2" to the end of any duplicate column name. All rows from the right table are maintained with missing values indicators used where needed.

cName1: the join column names of this table (e.g., the Foreign Key)
cName2: the join column names of table r2 (e.g., the Primary Key)
r2: the rhs table in the join operation

Definition Classes: Table

def row(i: Int): Row

Create a row by pulling values from all columns at position 'i'.

i: the 'i'th position

Definition Classes: MM_Relation → Table

def row(sos: Seq[String], _typ: String): Row

Create a row by pulling values from an array of strings and converting elements to their appropriate types.

sos: the sequence of strings holding the values
_typ: the string of corresponding types, e.g., 'SDI'

Definition Classes: Table
Annotations: @throws( classOf [Exception] )

def rows: Int

Return the size in terms of number of rows in the relation.

Definition Classes: MM_Relation → Table

def save(): Unit

Save 'this' relation in a file using serialization.

Definition Classes: MM_Relation → Table

def select[T](cName: String, p: (T) ⇒ Boolean)(implicit arg0: ClassTag[T]): MM_Relation

Select elements from columns in 'cName' in 'this' table that satisfy the predicate 'p'.

cName: the name of the column used for selection
p: the predicate (Boolean function) to be satisfied

Definition Classes: MM_Relation → Table

def selectAt(pos: Seq[Int]): MM_Relation

Select across all columns at the specified column positions.

pos: the specified column positions

Definition Classes: MM_Relation → Table

def selectC(cName: String, p: (Complex) ⇒ Boolean): Seq[Int]

Select the positions of elements from columns in 'cName' in 'this' relation that satisfy the predicate 'p'.

cName: the name of the column used for selection
p: the predicate (Boolean function) to be satisfied

Definition Classes: MM_Relation → Table

def selectD(cName: String, p: (Double) ⇒ Boolean): Seq[Int]

Definition Classes: MM_Relation → Table

def selectI(cName: String, p: (Int) ⇒ Boolean): Seq[Int]

Definition Classes: MM_Relation → Table

def selectL(cName: String, p: (Long) ⇒ Boolean): Seq[Int]

Definition Classes: MM_Relation → Table

def selectQ(cName: String, p: (Rational) ⇒ Boolean): Seq[Int]

Definition Classes: MM_Relation → Table

def selectR(cName: String, p: (Real) ⇒ Boolean): Seq[Int]

Definition Classes: MM_Relation → Table

def selectS(cName: String, p: (StrNum) ⇒ Boolean): Seq[Int]

Definition Classes: MM_Relation → Table

def show(limit: Int = Int.MaxValue): Unit

Show 'this' relation row by row.

limit: the limit on the number of rows to display

Definition Classes: MM_Relation → Tabular

def sigma[T](cName: String, p: (T) ⇒ Boolean): MM_Relation

Select elements from columns in 'cName' in 'this' relation that satisfy the predicate 'p'.

cName: the name of the column used for selection
p: the predicate (Boolean function) to be satisfied

def sigma[T](cName: String, p: (T) ⇒ Boolean)(implicit arg0: ClassTag[T]): Table

Select elements from columns in 'cName' in 'this' table that satisfy the predicate 'p'.

cName: the name of the column used for selection
p: the predicate (Boolean function) to be satisfied

Definition Classes: Table

def sigmaC(cName: String, p: (Complex) ⇒ Boolean): MM_Relation

Select elements from columns in 'cName' in 'this' relation that satisfy the predicate 'p'.

cName: the name of the column used for selection
p: the predicate (Boolean function) to be satisfied

Definition Classes: MM_Relation → Table

def sigmaD(cName: String, p: (Double) ⇒ Boolean): MM_Relation

Definition Classes: MM_Relation → Table

def sigmaI(cName: String, p: (Int) ⇒ Boolean): MM_Relation

Definition Classes: MM_Relation → Table

def sigmaL(cName: String, p: (Long) ⇒ Boolean): MM_Relation

Definition Classes: MM_Relation → Table

def sigmaQ(cName: String, p: (Rational) ⇒ Boolean): MM_Relation

Definition Classes: MM_Relation → Table

def sigmaR(cName: String, p: (Real) ⇒ Boolean): MM_Relation

Definition Classes: MM_Relation → Table

def sigmaS(cName: String, p: (StrNum) ⇒ Boolean): MM_Relation

Definition Classes: MM_Relation → Table

final def synchronized[T0](arg0: ⇒ T0): T0

Definition Classes: AnyRef

def toMatriD(colPos: Seq[Int], kind: MatrixKind = DENSE): MatriD

Convert 'this' relation into a matrix of doubles, e.g.,

in the regression equation: 'xb = y' create matrix 'xy'

colPos: the column positions to use for the matrix
kind: the kind of matrix to create

def toMatriDD(colPos: Seq[Int], colPosV: Int, kind: MatrixKind = DENSE): (MatriD, VectorD)

Convert 'this' relation into a matrix of doubles and a vector of doubles.

in the regression equation: 'xb = y' create matrix 'x' and vector 'y'

colPos: the column positions to use for the matrix
colPosV: the column position to use for the vector
kind: the kind of matrix to create

def toMatriDI(colPos: Seq[Int], colPosV: Int, kind: MatrixKind = DENSE): (MatriD, VectorI)

Convert 'this' relation into a matrix of doubles and a vector of integers.

in the regression equation: 'xb = y' create matrix 'x' and vector 'y'

colPos: the column positions to use for the matrix
colPosV: the column position to use for the vector
kind: the kind of matrix to create

def toMatriI(colPos: Seq[Int], kind: MatrixKind = DENSE): MatriI

Convert 'this' relation into a matrix of integers.

in the regression equation: 'xb = y' create matrix 'xy'

colPos: the column positions to use for the matrix
kind: the kind of matrix to create

def toMatriII(colPos: Seq[Int], colPosV: Int, kind: MatrixKind = DENSE): (MatriI, VectorI)

Convert 'this' relation into a matrix of integers and a vector of integers.

in the regression equation: 'xb = y' create matrix 'x' and vector 'y'

colPos: the column positions to use for the matrix
colPosV: the column position to use for the vector
kind: the kind of matrix to create

def toString(): String

Convert 'this' relation into a string column by column.

Definition Classes: MM_Relation → AnyRef → Any

def uncompress(cName: String*): Unit

Uncompress the selected columns 'cName' in 'this' table.

cName: the names of the columns to be uncompressed

Definition Classes: MM_Relation → Table

def union(_r2: Table): MM_Relation

Union 'this' relation and 'r2'.

Union 'this' relation and 'r2'. Check that the two relations are compatible.

Definition Classes: MM_Relation → Table

def uniq_union(cn1: Seq[String], cn2: Seq[String]): Seq[String]

Combine two sequences of column names, keeping all names from 'cn1' and only those in 'cn2' that are not repeats (i.e., not already in 'cn1').

cn1: the first sequence of column names
cn2: the second sequence of column names

Attributes: protected
Definition Classes: Table

def update[T](cName: String, newVal: T, matchVal: T): Unit

Update the column named 'cName' using function 'func' for elements with value 'matchStr'.

T: type of the column
cName: the name of the column to be updated
newVal: the value used to assign updated values
matchVal: the value to be matched to elements

Definition Classes: MM_Relation → Table

def update[T](cName: String, func: (T) ⇒ T, matchVal: T): Unit

Update the column named 'cName' using function 'func' for elements with value 'matchStr'.

T: type of the column
cName: the name of the column to be updated
func: the function used to assign updated values
matchVal: the value to be matched to elements

Definition Classes: MM_Relation → Table

def update[T](cName: String, func: (T) ⇒ T, pred: (T) ⇒ Boolean): Unit

Update the column named 'cName' using function 'func' for elements where the predicate 'pred' evaluates to true.

T: type of the column
cName: the name of the column to be updated
func: the function used to assign updated values // FIX - generalize type
pred: the predicated used to select elements for update

Definition Classes: MM_Relation → Table

final def wait(): Unit

Definition Classes: AnyRef
Annotations: @throws( ... )

final def wait(arg0: Long, arg1: Int): Unit

Definition Classes: AnyRef
Annotations: @throws( ... )

final def wait(arg0: Long): Unit

Definition Classes: AnyRef
Annotations: @native() @throws( ... )

def writeCSV(fileName: String): Unit

Write 'this' relation into a CSV file with each row written to a line.

fileName: the file name of the data file

Definition Classes: MM_Relation → Table

def writeJSON(fileName: String): Unit

Write 'this' relation into a JSON file.

fileName: the file name of the data file

Definition Classes: MM_Relation → Table

def ×(r2: Table): Table

Compute the Cartesian product of 'this' table and 'r2' ('this × r2').

r2: the second table

Definition Classes: Table

def Π(aggCol: AggColumn*)(cName: String*): Table

Aggregate/project on the given columns (an extended projection operator that applies aggregate operators to aggregation columns and regular projection to projection columns).

aggCol: the columns to aggregate on: (aggregate function, new column name, old column name)*
cName: the other columns to project on

Definition Classes: Table
See also: en.wikipedia.org/wiki/Relational_algebra

def γ(cName: String*): Table

Group 'this' table by specified column names, returning 'this' table.

cName: group columns

Definition Classes: Table

def ζ(cName: String*): Unit

Compress the selected columns 'cName' in 'this' table.

cName: the names of the columns to be compressed

Definition Classes: Table

def ζζ(cName: String*): Unit

Uncompress the selected columns 'cName' in 'this' table.

cName: the names of the columns to be uncompressed

Definition Classes: Table

def π(cPos: Seq[Int], cName: Seq[String] = null): Table

Project onto the columns with the given column positions.

cPos: the column positions to project onto
cName: the optional new names for the columns to project onto

Definition Classes: Table

def π(cName: String*): Table

Project onto the columns with the given column names.

cName: the names of the columns to project onto

Definition Classes: Table

def σ[T](cName: String, p: (T) ⇒ Boolean): MM_Relation

Select elements from columns in 'cName' in 'this' relation that satisfy the predicate 'p'.

cName: the name of the column used for selection
p: the predicate (Boolean function) to be satisfied

def σ[T](cName: String, p: (T) ⇒ Boolean)(implicit arg0: ClassTag[T]): Table

Select elements from columns in 'cName' in 'this' table that satisfy the predicate 'p'.

cName: the name of the column used for selection
p: the predicate (Boolean function) to be satisfied

Definition Classes: Table

def ω(cName: String*): Table

Order (ascending) the rows in the table by the selected columns 'cName'.

Order (ascending) the rows in the table by the selected columns 'cName'. A stable sorting is used to allow sorting on multiple columns.

cName: the column names that are to be sorted

Definition Classes: Table

def ωω(cName: String*): Table

Order (descending) the rows in the table by the selected columns 'cName'.

Order (descending) the rows in the table by the selected columns 'cName'. A stable sorting is used to allow sorting on multiple columns.

cName: the column names that are to be sorted

Definition Classes: Table

def ⋂(r2: Table): Table

Intersect 'this' table and 'r2'.

Intersect 'this' table and 'r2'. Check that the two tables are compatible.

r2: the other table

Definition Classes: Table

def ⋃(r2: Table): Table

Union 'this' table and 'r2'.

Union 'this' table and 'r2'. Check that the two tables are compatible.

r2: the other table

Definition Classes: Table

def ⋈[T](r2: Table, p0: Predicate2[T], p: Predicate2[T]*): Table

The theta join, handle the predicates in where are connect by "and" (where a....and b....).

r2: the second table
p0: the first theta join predicate (r1 cName, r2 cName, predicate to compare these two column)
p: the rest of theta join predicates (r1 cName, r2 cName, predicates to compare these two column)

Definition Classes: Table

def ⋈(cNames1: Seq[String], cNames2: Seq[String], r2: Table): Table

Join 'this' table and 'r2' by performing an "equi-join".

Join 'this' table and 'r2' by performing an "equi-join". Rows from both tables are compared requiring 'cName1' values to equal 'cName2' values. Disambiguate column names by appending "2" to the end of any duplicate column name.

cNames1: the join column names of this table (e.g., the Foreign Key)
cNames2: the join column names of table r2 (e.g., the Primary Key)
r2: the rhs table in the join operation

Definition Classes: Table

def ⋈(cName1: String, cName2: String, r2: Table): Table

Join 'this' table and 'r2' by performing an "equi-join".

Join 'this' table and 'r2' by performing an "equi-join". Rows from both tables are compared requiring 'cName1' values to equal 'cName2' values. Disambiguate column names by appending "2" to the end of any duplicate column name.

cName1: the join column name of this table (e.g., the Foreign Key)
cName2: the join column name of table r2 (e.g., the Primary Key)
r2: the rhs table in the join operation

Definition Classes: Table

def ⋈(cNames: Seq[String], r2: Table): Table

Join 'this' table and 'r2' by performing a "natural-join".

Join 'this' table and 'r2' by performing a "natural-join". Rows from both tables are compared requiring 'cName' values to be equal.

cNames: the common join column names for both table
r2: the rhs table in the join operation

Definition Classes: Table

def ⋈(cName: String, r2: Table): Table

Join 'this' table and 'r2' by performing a "natural-join".

Join 'this' table and 'r2' by performing a "natural-join". Rows from both tables are compared requiring 'cName' values to be equal.

cName: the common join column name for both table
r2: the rhs table in the join operation

Definition Classes: Table

def ⋈(r2: Table): Table

Join 'this' table and 'r2' by performing a "natural-join".

Join 'this' table and 'r2' by performing a "natural-join". Rows from both tables are compared requiring agreement on common attributes (column names).

r2: the rhs table in the join operation

Definition Classes: Table

def ⋉(thres: Double = 0.01)(cName1: String, cName2: String, r2: Table): Table

Join 'this' table and 'r2' by performing an "apprimate left-join".

Join 'this' table and 'r2' by performing an "apprimate left-join". Rows from both tables are compared requiring 'cName1' values to apprximately equal 'cName2' values. Disambiguate column names by appending "2" to the end of any duplicate column name. All rows from the left table are maintained with missing values indicators used where needed.

cName1: the join column names of this table (e.g., the Foreign Key)
cName2: the join column names of table r2 (e.g., the Primary Key)
r2: the rhs table in the join operation

Definition Classes: Table

def ⋉(cName1: String, cName2: String, r2: Table): Table

Join 'this' table and 'r2' by performing an "left-join".

Join 'this' table and 'r2' by performing an "left-join". Rows from both tables are compared requiring 'cName1' values to equal 'cName2' values. Disambiguate column names by appending "2" to the end of any duplicate column name. All rows from the left table are maintained with missing values indicators used where needed. Note: although this is the semi-join symbol, due to Unicode limitations, it is used for left-join.

cName1: the join column names of this table (e.g., the Foreign Key)
cName2: the join column names of table r2 (e.g., the Primary Key)
r2: the rhs table in the join operation

Definition Classes: Table

def ⋊(cName1: String, cName2: String, r2: Table): Table

Join 'this' table and 'r2' by performing an "right-join".

Join 'this' table and 'r2' by performing an "right-join". Rows from both tables are compared requiring 'cName1' values to equal 'cName2' values. Disambiguate column names by appending "2" to the end of any duplicate column name. All rows from the right table are maintained with missing values indicators used where needed.

cName1: the join column names of this table (e.g., the Foreign Key)
cName2: the join column names of table r2 (e.g., the Primary Key)
r2: the rhs table in the join operation

Definition Classes: Table

Packages

MM_Relation

Companion object MM_Relation

class MM_Relation extends Table with Error

Instance Constructors

Value Members

Inherited from Error

Inherited from Table

Inherited from Tabular

Inherited from AnyRef

Inherited from Any

Ungrouped

Packages

MM_Relation 

Companion object MM_Relation

class MM_Relation extends Table with Error

Instance Constructors

Value Members

Inherited from Error

Inherited from Table

Inherited from Tabular

Inherited from AnyRef

Inherited from Any

Ungrouped

MM_Relation