package relalgebra
The relalgebra
package contains classes, traits and objects for
columnar relational algebra, where columns are vectors from
the linalgebra
package.
- Alphabetic
- By Inheritance
- relalgebra
- AnyRef
- Any
- Hide All
- Show All
- Public
- All
Type Members
-
case class
MM_Relation
(name: String, colName: Seq[String], col: Vector[Vec], key: Int = 0, domain: String = null) extends Table with Error with Product with Serializable
The
MM_Relation
class stores and operates on vectors.The
MM_Relation
class stores and operates on vectors. The vectors form the columns of the columnar relational datastore. Columns may have any of the following types:C -
Complex
-VectorC
- 128 bit complex number a + bi D -Double
-VectorD
- 64 bit double precision floating point number I -Int
-VectorI
- 32 bit integer L -Long
-VectorL
- 64 bit long integer Q -Rational
-VectorQ
- 128 bit ratio of two long integers R -Real
-VectorR
- 128 bit quad precision floating point number S -StrNum
-VectorS
- variable length numeric string- name
the name of the relation
- colName
the names of columns
- col
the Scala Vector of columns making up the columnar relation
- key
the column number for the primary key (< 0 => no primary key)
- domain
an optional string indicating domains for columns (e.g., 'SD' =
StrNum
,Double
)
-
case class
Relation
(name: String, colName: Seq[String], col: Vector[Vec], key: Int = 0, domain: String = null, fKeys: Seq[(String, String, Int)] = null) extends Table with Error with Product with Serializable
The
Relation
class stores and operates on vectors.The
Relation
class stores and operates on vectors. The vectors form the columns of the columnar relational datastore. Columns may have any of the following types:C -
Complex
-VectorC
- 128 bit complex number a + bi D -Double
-VectorD
- 64 bit double precision floating point number I -Int
-VectorI
- 32 bit integer L -Long
-VectorL
- 64 bit long integer Q -Rational
-VectorQ
- 128 bit ratio of two long integers R -Real
-VectorR
- 128 bit quad precision floating point number S -StrNum
-VectorS
- variable length numeric string- name
the name of the relation
- colName
the names of columns
- col
the Scala Vector of columns making up the columnar relation
- key
the column number for the primary key (< 0 => no primary key)
- domain
an optional string indicating domains for columns (e.g., 'SD' = 'StrNum', 'Double')
- fKeys
an optional sequence of foreign keys - Seq (column name, ref table name, ref column position)
-
trait
Table
extends AnyRef
The
Table
trait stores and operates on vectors.The
Table
trait stores and operates on vectors. The vectors form the columns of the columnar relational datastore. Columns may have any of the following types:C -
Complex
-VectorC
- 128 bit complex number a + bi D -Double
-VectorD
- 64 bit double precision floating point number I -Int
-VectorI
- 32 bit integer L -Long
-VectorL
- 64 bit long integer Q -Rational
-VectorQ
- 128 bit ratio of two long integers R -Real
-VectorR
- 128 bit quad precision floating point number S -StrNum
-VectorS
- variable length numeric string
Value Members
-
object
Catalog
The
Catalog
object keeps track of relations in the database. -
object
CatalogTest
extends App
The
CatalogTest
object is used to test theCatalog
object.The
CatalogTest
object is used to test theCatalog
object. > run-main scalation.relalgebra.CatalogTest -
object
MM_Relation
extends Serializable
The
MM_Relation
companion object provides additional functions for theMM_Relation
class. -
object
MM_RelationEx
The
MM_RelationEx
object provides and example relation for testing.The
MM_RelationEx
object provides and example relation for testing.- See also
www.codeproject.com/Articles/652108/Create-First-Data-WareHouse
-
object
MM_RelationTest
extends App
The
MM_RelationTest
object tests the operations provided byMM_Relation
.The
MM_RelationTest
object tests the operations provided byMM_Relation
. > run-main scalation.relalgebra.MM_RelationTest -
object
MM_RelationTest2
extends App
The
MM_RelationTest2
object tests the operations provided byMM_Relation
.The
MM_RelationTest2
object tests the operations provided byMM_Relation
. The relational algebra operators are given using Unicode.- See also
en.wikipedia.org/wiki/List_of_Unicode_characters > run-main scalation.relalgebra.MM_RelationTest2
-
object
MM_RelationTest3
extends App
The
MM_RelationTest3
object tests the operations provided byMM_Relation
.The
MM_RelationTest3
object tests the operations provided byMM_Relation
. It test various aggregate/OLAP operations on a simple data warehouse fact table.- See also
www.codeproject.com/Articles/652108/Create-First-Data-WareHouse FIX - allow entering doubles as "13" rather than "13.0" > run-main scalation.relalgebra.MM_RelationTest3
-
object
MM_RelationTest4
extends App
The
MM_RelationTest4
object tests conversionMM_Relation
to a matrix.The
MM_RelationTest4
object tests conversionMM_Relation
to a matrix. > run-main scalation.relalgebra.MM_RelationTest4 -
object
MakeSchema
The
MakeSchema
object attempts to infers the domain of a relation without a domain specification and creates a new relation with the inferred domains by examining the data.The
MakeSchema
object attempts to infers the domain of a relation without a domain specification and creates a new relation with the inferred domains by examining the data. Should be checked and overridden when inaccurate. -
object
MakeSchemaTest
extends App
The
MakeSchemaTest
object is used to test theMakeSchema
object.The
MakeSchemaTest
object is used to test theMakeSchema
object. > run-main scalation.relalgebra.MakeSchemaTest -
object
MakeSchemaTest2
extends App
The
MakeSchemaTest2
object is used to test theMakeSchema
object.The
MakeSchemaTest2
object is used to test theMakeSchema
object. > run-main scalation.relalgebra.MakeSchemaTest2 -
object
MissingValues
The
MissingValues
object is used to replace missing values in a dataset.The
MissingValues
object is used to replace missing values in a dataset.- See also
www.utexas.edu/cola/prc/_files/cs/Missing-Data.pdf
-
object
MissingValuesTest
extends App
The
MissingValuesTest
object is used to test theMissingValues
object.The
MissingValuesTest
object is used to test theMissingValues
object. > run-main scalation.relalgebra.MissingValuesTest -
object
Relation
extends Serializable
The
Relation
companion object provides additional functions for theRelation
class. -
object
RelationEx
The
RelationEx
object provides and example relation for testing.The
RelationEx
object provides and example relation for testing.- See also
www.codeproject.com/Articles/652108/Create-First-Data-WareHouse
-
object
RelationTest
extends App
The
RelationTest
object tests the operations provided byRelation
.The
RelationTest
object tests the operations provided byRelation
. > run-main scalation.relalgebra.RelationTest -
object
RelationTest2
extends App
The
RelationTest2
object tests the operations provided byRelation
.The
RelationTest2
object tests the operations provided byRelation
. The relational algebra operators are given using Unicode.- See also
en.wikipedia.org/wiki/List_of_Unicode_characters > run-main scalation.relalgebra.RelationTest2
-
object
RelationTest3
extends App
The
RelationTest3
object tests the operations provided byRelation
.The
RelationTest3
object tests the operations provided byRelation
. It test various aggregate/OLAP operations on a simple data warehouse fact table.- See also
www.codeproject.com/Articles/652108/Create-First-Data-WareHouse FIX - allow entering doubles as "13" rather than "13.0" > run-main scalation.relalgebra.RelationTest3
-
object
RelationTest4
extends App
The
RelationTest4
object tests conversionRelation
to a matrix.The
RelationTest4
object tests conversionRelation
to a matrix. > run-main scalation.relalgebra.RelationTest4 -
object
RelationTest5
extends App
The
RelationTest5
object tests the interoperability between Relations and Matrices.The
RelationTest5
object tests the interoperability between Relations and Matrices. > run-main scalation.relalgebra.RelationTest5 -
object
TableGen
extends Error
The
TableGen
object generates data forTable
classes (e.g.,Relation
). -
object
TableGenTest
extends App
The
TableGenTest
is used to test theTableGen
object.The
TableGenTest
is used to test theTableGen
object. Create unpopulated tables and use the table generator to populate their columns. > run-main scalation.relalgebra.TableGenTest -
object
TableObj
The
Table
object provides functions for theTable
companion objects.