scalation
API
Generated with
scalation/scalation/scalation.database/scalation.database.table

scalation.database.table

package scalation.database.table

Members list

Type members

Classlikes

case class Edge(from: Vertex, to: Vertex, tuple: Tuple)

The Edge class includes three parts: The edge attributes in the form of a tuple of values, the source (from) vertex and target (to) vertex.

The Edge class includes three parts: The edge attributes in the form of a tuple of values, the source (from) vertex and target (to) vertex.

Value parameters

from

the source vertex

to

the target vertex

tuple

the tuple part of the edge (for edge attributes)

Attributes

Supertypes
trait Serializable
trait Product
trait Equals
class Object
trait Matchable
class Any
Show all
object GTable

The GTable companion object provides factory methods for creating graph-tables. Supported domains/data-types are 'D'ouble, 'I'nt, 'L'ong, 'S'tring, and 'T'imeNum.

The GTable companion object provides factory methods for creating graph-tables. Supported domains/data-types are 'D'ouble, 'I'nt, 'L'ong, 'S'tring, and 'T'imeNum.

Attributes

Companion
class
Supertypes
class Object
trait Matchable
class Any
Self type
GTable.type
class GTable(name_: String, schema_: Schema, domain_: Domain, key_: Schema) extends Table, Serializable

The GTable class (graph-table) stores graph-table data and implements graph algebra operators. Supported domains/data-types are 'D'ouble, 'I'nt, 'L'ong, 'S'tring, and 'T'imeNum.

The GTable class (graph-table) stores graph-table data and implements graph algebra operators. Supported domains/data-types are 'D'ouble, 'I'nt, 'L'ong, 'S'tring, and 'T'imeNum.

Value parameters

domain_

the domains/data-types for attributes ('D', 'I', 'L', 'S', 'X', 'T')

key_

the attributes forming the primary key

name_

the name of the graph-table

schema_

the attributes for the graph-table

Attributes

Companion
object
Supertypes
class Table
trait Tabular[Table]
trait Serializable
class Object
trait Matchable
class Any
Show all
Known subtypes
class KGTable
object KGTable

The KGTable companion object provides factory methods for creating knowledge-graph-tables. Supported domains/data-types are 'D'ouble, 'I'nt, 'L'ong, 'S'tring, and 'T'imeNum.

The KGTable companion object provides factory methods for creating knowledge-graph-tables. Supported domains/data-types are 'D'ouble, 'I'nt, 'L'ong, 'S'tring, and 'T'imeNum.

Attributes

Companion
class
Supertypes
class Object
trait Matchable
class Any
Self type
KGTable.type
class KGTable(name_: String, schema_: Schema, domain_: Domain, key_: Schema, val parent: KGTable) extends GTable, TNode, Serializable

The KGTable class (knowledge-graph-table) stores graph-relational data and implements knowledge graph algebra operators. Supported domains/data-types are 'D'ouble, 'I'nt, 'L'ong, 'S'tring, and 'T'imeNum.

The KGTable class (knowledge-graph-table) stores graph-relational data and implements knowledge graph algebra operators. Supported domains/data-types are 'D'ouble, 'I'nt, 'L'ong, 'S'tring, and 'T'imeNum.

Value parameters

domain_

the domains/data-types for attributes ('D', 'I', 'L', 'S', 'X', 'T')

key_

the attributes forming the primary key

name_

the name of the graph-table

parent

the parent (super-type) table

schema_

the attributes for the graph-table

Attributes

Companion
object
Supertypes
trait TNode
class GTable
class Table
trait Tabular[Table]
trait Serializable
class Object
trait Matchable
class Any
Show all
object LTable

The LTable companion object provides factory methods for creating linkable-tables. Supported domains/data-types are 'D'ouble, 'I'nt, 'L'ong, 'S'tring, and 'T'imeNum.

The LTable companion object provides factory methods for creating linkable-tables. Supported domains/data-types are 'D'ouble, 'I'nt, 'L'ong, 'S'tring, and 'T'imeNum.

Attributes

Companion
class
Supertypes
trait Product
trait Mirror
class Object
trait Matchable
class Any
Self type
LTable.type
case class LTable(name_: String, schema_: Schema, domain_: Domain, key_: Schema) extends Table, Serializable

The LTable class (linkable-table) stores linkable-relational data and implements linkable-relational algebra operators. Supported domains/data-types are 'D'ouble, 'I'nt, 'L'ong, 'S'tring, and 'T'imeNum.

The LTable class (linkable-table) stores linkable-relational data and implements linkable-relational algebra operators. Supported domains/data-types are 'D'ouble, 'I'nt, 'L'ong, 'S'tring, and 'T'imeNum.

Value parameters

domain_

the domains/data-types for attributes ('D', 'I', 'L', 'S', 'X', 'T')

key_

the attributes forming the primary key

name_

the name of the linkable-table

schema_

the attributes for the linkable-table

Attributes

Companion
object
Supertypes
trait Product
trait Equals
class Table
trait Tabular[Table]
trait Serializable
class Object
trait Matchable
class Any
Show all
final class PurchaseOrderDB

Attributes

Supertypes
class Object
trait Matchable
class Any
object TA_AssignmentDB

The TA_AssignmentDB object contains table definitions for making TA Assignments.

The TA_AssignmentDB object contains table definitions for making TA Assignments.

Attributes

Supertypes
class Object
trait Matchable
class Any
Self type
object Table

The Table companion object provides factory methods for creating tables. Supported domains/data-types are 'D'ouble, 'I'nt, 'L'ong, 'S'tring, and 'T'imeNum. Note 'X' is for Long String (a formatting issue).

The Table companion object provides factory methods for creating tables. Supported domains/data-types are 'D'ouble, 'I'nt, 'L'ong, 'S'tring, and 'T'imeNum. Note 'X' is for Long String (a formatting issue).

Attributes

Companion
class
Supertypes
class Object
trait Matchable
class Any
Self type
Table.type
class Table(name: String, schema: Schema, domain: Domain, key: Schema) extends Tabular[Table], Serializable

The Table class stores relational data and implements relational algebra operators. Supported domains/data-types are 'D'ouble, 'I'nt, 'L'ong, 'S'tring, and 'T'imeNum.

The Table class stores relational data and implements relational algebra operators. Supported domains/data-types are 'D'ouble, 'I'nt, 'L'ong, 'S'tring, and 'T'imeNum.

Value parameters

domain

the domains/data-types for the attributes ('D', 'I', 'L', 'S', 'X', 'T')

key

the attributes forming the primary key

name

the name of the table

schema

the attributes for the table

Attributes

Companion
object
Supertypes
trait Tabular[Table]
trait Serializable
class Object
trait Matchable
class Any
Known subtypes
class GTable
class KGTable
class LTable
class VTable
object TableGen

The TableGen object generates data for instances of the Table class.

The TableGen object generates data for instances of the Table class.

Attributes

Supertypes
class Object
trait Matchable
class Any
Self type
TableGen.type
object VTable

The VTable companion object provides factory methods for creating vertex-tables. Supported domains/data-types are 'D'ouble, 'I'nt, 'L'ong, 'S'tring, and 'T'imeNum.

The VTable companion object provides factory methods for creating vertex-tables. Supported domains/data-types are 'D'ouble, 'I'nt, 'L'ong, 'S'tring, and 'T'imeNum.

Attributes

Companion
class
Supertypes
trait Product
trait Mirror
class Object
trait Matchable
class Any
Self type
VTable.type
case class VTable(name_: String, schema_: Schema, domain_: Domain, key_: Schema) extends Table, Serializable

The VTable class (vertex-table) stores graph-relational data and implements graph-relational algebra operators. Supported domains/data-types are 'D'ouble, 'I'nt, 'L'ong, 'S'tring, and 'T'imeNum.

The VTable class (vertex-table) stores graph-relational data and implements graph-relational algebra operators. Supported domains/data-types are 'D'ouble, 'I'nt, 'L'ong, 'S'tring, and 'T'imeNum.

Value parameters

domain_

the domains/data-types for attributes ('D', 'I', 'L', 'S', 'X', 'T')

key_

the attributes forming the primary key

name_

the name of the vertex-table

schema_

the attributes for the vertex-table

Attributes

Companion
object
Supertypes
trait Product
trait Equals
class Table
trait Tabular[Table]
trait Serializable
class Object
trait Matchable
class Any
Show all
case class Vertex(tuple: Tuple)

The Vertex class extends the notion of Tuple into values stored in the tuple part, along with foreign keys links captured as outgoing edges.

The Vertex class extends the notion of Tuple into values stored in the tuple part, along with foreign keys links captured as outgoing edges.

Value parameters

tuple

the tuple part of the vertex

Attributes

Supertypes
trait Serializable
trait Product
trait Equals
class Object
trait Matchable
class Any
Show all
case class Vertex_(tuple: Tuple)

The Vertex_ class extends the notion of Tuple into values stored in the tuple part, along with foreign keys links captured as outgoing edges.

The Vertex_ class extends the notion of Tuple into values stored in the tuple part, along with foreign keys links captured as outgoing edges.

Value parameters

tuple

the tuple part of a vertex

Attributes

Supertypes
trait Serializable
trait Product
trait Equals
class Object
trait Matchable
class Any
Show all
final class bankDB

Attributes

Supertypes
class Object
trait Matchable
class Any
final class bankDB2

Attributes

Supertypes
class Object
trait Matchable
class Any
final class gTableTest

Attributes

Supertypes
class Object
trait Matchable
class Any
final class gTableTest2

Attributes

Supertypes
class Object
trait Matchable
class Any
final class gTableTest3

Attributes

Supertypes
class Object
trait Matchable
class Any
final class kGTableTest

Attributes

Supertypes
class Object
trait Matchable
class Any
final class kGTableTest2

Attributes

Supertypes
class Object
trait Matchable
class Any
final class lTableTest

Attributes

Supertypes
class Object
trait Matchable
class Any
final class lTableTest2

Attributes

Supertypes
class Object
trait Matchable
class Any
final class lTableTest3

Attributes

Supertypes
class Object
trait Matchable
class Any
final class lTableTest4

Attributes

Supertypes
class Object
trait Matchable
class Any
final class movieDB

Attributes

Supertypes
class Object
trait Matchable
class Any
final class showTabs

Attributes

Supertypes
class Object
trait Matchable
class Any
final class tableGenTest

Attributes

Supertypes
class Object
trait Matchable
class Any
final class tableTest

Attributes

Supertypes
class Object
trait Matchable
class Any
final class tableTest2

Attributes

Supertypes
class Object
trait Matchable
class Any
final class tableTest3

Attributes

Supertypes
class Object
trait Matchable
class Any
final class timer_function

Attributes

Supertypes
class Object
trait Matchable
class Any
final class vTableTest

Attributes

Supertypes
class Object
trait Matchable
class Any
final class vTableTest2

Attributes

Supertypes
class Object
trait Matchable
class Any

Value members

Concrete methods

def PurchaseOrderDB(): Unit

The PurchaseOrderDB main function uses the Table class for simple database application. Note: purchase_order is abreviated to purchase.

The PurchaseOrderDB main function uses the Table class for simple database application. Note: purchase_order is abreviated to purchase.

Attributes

See also

https://www.pdbmbook.com/lecturers/slides/access - Chapter%20SQL.pdf

runMain scalation.database.table.PurchaseOrderDB

def bankDB(): Unit

The bankDB main function uses the Table class for simple database application.

The bankDB main function uses the Table class for simple database application.

runMain scalation.database.table.bankDB

Attributes

def bankDB2(): Unit

The bankDB2 main function uses the Table class for simple database application.

The bankDB2 main function uses the Table class for simple database application.

runMain scalation.database.table.bankDB2

Attributes

def gTableTest(): Unit

The gTableTest main function tests the GTable class with queries on the Bank database.

The gTableTest main function tests the GTable class with queries on the Bank database.

runMain scalation.database.table.gTableTest

Attributes

def gTableTest2(): Unit

The gTableTest2 main function tests the GTable class with queries on the Student-Course-Professor database.

The gTableTest2 main function tests the GTable class with queries on the Student-Course-Professor database.

runMain scalation.database.table.gTableTest2

Attributes

def gTableTest3(): Unit

The gTableTest3 main function tests the GTable object and class by loading a dataset from a file. It loads the ScalaTion "covid_19" dataset/CSV file.

The gTableTest3 main function tests the GTable object and class by loading a dataset from a file. It loads the ScalaTion "covid_19" dataset/CSV file.

  • RELATIVE PATHS are from ScalaTion's DATA-DIR (@see Util.scala)
  • FULL PATHS are from the OS's root directory Defaults to RELATIVE PATHS; use setFullPath method to change.

runMain scalation.database.table.gTableTest3

Attributes

def kGTableTest(): Unit

The kGTableTest main function tests the KGTable class with queries on the Bank database.

The kGTableTest main function tests the KGTable class with queries on the Bank database.

runMain scalation.database.table.kGTableTest

Attributes

def kGTableTest2(): Unit

The kGTableTest2 main function tests the KGTable class with queries on the Student-Course-Professor database.

The kGTableTest2 main function tests the KGTable class with queries on the Student-Course-Professor database.

runMain scalation.database.table.kGTableTest2

Attributes

def lTableTest(): Unit

The lTableTest main function tests the LTable class with queries on the Bank database.

The lTableTest main function tests the LTable class with queries on the Bank database.

runMain scalation.database.table.lTableTest

Attributes

def lTableTest2(): Unit

The lTableTest2 main function tests the LTable class with queries on the Student-Course database.

The lTableTest2 main function tests the LTable class with queries on the Student-Course database.

runMain scalation.database.table.lTableTest2

Attributes

def lTableTest3(): Unit

The lTableTest3 main function tests the LTable class with queries on the University database. It does performance testing of EQUI-JOIN using large tables populated using TableGen. Tables: student, professor, course, section, transcript

The lTableTest3 main function tests the LTable class with queries on the University database. It does performance testing of EQUI-JOIN using large tables populated using TableGen. Tables: student, professor, course, section, transcript

runMain scalation.database.table.lTableTest3

Attributes

def lTableTest4(): Unit

The lTableTest4 main function tests the LTable class with queries on the University database. It does performance testing of NATURAL JOIN using large tables populated using TableGen. Tables: student, professor, course, section, transcript

The lTableTest4 main function tests the LTable class with queries on the University database. It does performance testing of NATURAL JOIN using large tables populated using TableGen. Tables: student, professor, course, section, transcript

runMain scalation.database.table.lTableTest3

Attributes

def movieDB(): Unit

The movieDB main function uses the Table class for simple database application.

The movieDB main function uses the Table class for simple database application.

runMain scalation.database.table.movieDB

Attributes

def sameTuples(ts1: ArrayBuffer[Tuple], ts2: ArrayBuffer[Tuple]): Boolean

Determine whether the bag of tuples ts1 is the same ts2.

Determine whether the bag of tuples ts1 is the same ts2.

Value parameters

ts1

the first bag of tuples

ts2

the second bag of tuples

Attributes

def showTabs(): Unit

The showTabs main function prints all the tables defined in the TA_AssignmentDB object.

The showTabs main function prints all the tables defined in the TA_AssignmentDB object.

runMain scalation.database.table.showTabs

Attributes

def tableGenTest(): Unit

The tableGenTest main function is used to test the TableGen object. Create unpopulated tables and use the table generator to populate their columns. Tables: student, professor, course, section, transcript

The tableGenTest main function is used to test the TableGen object. Create unpopulated tables and use the table generator to populate their columns. Tables: student, professor, course, section, transcript

runMain scalation.database.table.tableGenTest

Attributes

def tableTest(): Unit

The tableTest main function tests the Table class with queries on the Bank database.

The tableTest main function tests the Table class with queries on the Bank database.

runMain scalation.database.table.tableTest

Attributes

def tableTest2(): Unit

The tableTest2 main function tests the Table class with queries on the Student-Course-Professor database.

The tableTest2 main function tests the Table class with queries on the Student-Course-Professor database.

runMain scalation.database.table.tableTest2

Attributes

def tableTest3(): Unit

The tableTest3 main function tests the Table object and class by loading a dataset from a file. It loads the ScalaTion "covid_19" dataset/CSV file.

The tableTest3 main function tests the Table object and class by loading a dataset from a file. It loads the ScalaTion "covid_19" dataset/CSV file.

  • RELATIVE PATHS are from ScalaTion's DATA-DIR (@see Util.scala)
  • FULL PATHS are from the OS's root directory Defaults to RELATIVE PATHS; use setFullPath method to change.

runMain scalation.database.table.tableTest3

Attributes

def timer_function(): Unit

The timer_function main method is used to compare the speed of several join algorithms.

The timer_function main method is used to compare the speed of several join algorithms.

runMain scalation.database.table.timer_function

Attributes

def vTableTest(): Unit

The vTableTest main function tests the VTable class with queries on the Bank database.

The vTableTest main function tests the VTable class with queries on the Bank database.

runMain scalation.database.table.vTableTest

Attributes

def vTableTest2(): Unit

The vTableTest2 main function tests the VTable class with queries on the Student-Course-Professor database. Note, since VTable can handle many-to-many relationships, the 'takes' association table is no longer needed.

The vTableTest2 main function tests the VTable class with queries on the Student-Course-Professor database. Note, since VTable can handle many-to-many relationships, the 'takes' association table is no longer needed.

runMain scalation.database.table.vTableTest2

Attributes

Extensions

Extensions

extension (t: Tuple)
infix def eqElements(u: Tuple): Boolean

Determine whether two tuples have the same elements (in the same order). This extension mwethod serves as faster alternative to Scala's sameElements method.

Determine whether two tuples have the same elements (in the same order). This extension mwethod serves as faster alternative to Scala's sameElements method.

Value parameters

t

the main tuple

Attributes

Generated with