Relational Algebra

Selection, Projection, Summation, OrderBy

Implementation of simple relational operations like Selection, Projection, Summation, etc.

class stampdb.relational.simple.OrderBy(columns: List[str], data: ndarray)

Sorts the data by specified columns using numpy’s sort.

class stampdb.relational.simple.Projection(columns: List[str], data: ndarray)

Selects specific columns from the data.

class stampdb.relational.simple.Selection(condition: str, data: ndarray)

Selects rows based on a condition.

class stampdb.relational.simple.Summation(column: str, data: ndarray)

Calculates the sum of a column.

Joins

class stampdb.relational.joins.InnerJoin(left: ndarray, right: ndarray, left_key: str, right_key: str)

Inner Join

class stampdb.relational.joins.LeftOuterJoin(left: ndarray, right: ndarray, left_key: str, right_key: str)

Left Outer Join

class stampdb.relational.joins.OuterJoin(left: ndarray, right: ndarray, left_key: str, right_key: str)

Outer Join