Index

A B C D E F G I L M N O P R S T U V

A

abort() - Static method in class DBMS: Attempts to immediately shut down the database and exit.
addColumn(Column) - Method in class SQLStatement: Adds a column to the list of columns for this statement.
addColumn(Column) - Method in class Table: Adds a column to the list of columns for this table.
addColumnVal(Object) - Method in class SQLStatement: Adds a column value to the list of column values for this statement.
addTable(Table) - Method in class SQLStatement: Adds a table to the list of tables for this statement.
adjustValue(Object) - Method in class Column: Returns an adjusted value for this column, based on its type and length.
applyOpts(ColumnOptions) - Method in class Column: Applies the specified column options to this column.

B

BeginStatement - Class in <Unnamed>: A class that represents a BEGIN WORK statement, which begins a transaction.
BeginStatement() - Constructor for class BeginStatement: Constructs a BeginStatement object

C

cacheClose() - Static method in class Table: Closes the in-memory cache of open tables, which closes all the BDB database handles for the open tables.
cacheInit() - Static method in class Table: Initializes the in-memory cache of open tables.
Catalog - Class in <Unnamed>: A class representing the catalog of a simple relational database.
Catalog() - Constructor for class Catalog
CATALOG_NAME - Static variable in class Catalog: The name of the catalog's underlying BDB database.
CHAR - Static variable in class Column: A column of type CHAR
CLIKE - Static variable in class Comparison: A comparison involving CLIKE
close() - Static method in class Catalog: Closes the catalog and ensures all changes have been written to disk.
close() - Method in class Table: Closes the table and ensures all changes have been written to disk.
close() - Method in class TableIterator: Closes the iterator, which closes any BDB handles that it is using.
Column - Class in <Unnamed>: A class that represents a column in a table.
Column(String) - Constructor for class Column: Constructs a Column object with the specified name.
Column(String, Table) - Constructor for class Column: Constructs a Column object with the specified name from the specified table.
Column(Column) - Constructor for class Column: Constructs a Column object that has the same initial field values as the specified column.
ColumnOptions - Class in <Unnamed>: A class that represents options for a column in a table -- namely, whether it is not allowed to include null values, and whether it is the primary key of its table.
ColumnOptions(boolean, boolean) - Constructor for class ColumnOptions: Constructs a ColumnOptions object with the specified options.
CommitStatement - Class in <Unnamed>: A class that represents a COMMIT statement in SQL, which commits the current transaction.
CommitStatement() - Constructor for class CommitStatement: Constructs a CommitStatement object
CompareTerm - Class in <Unnamed>: A class that represents an operand in a comparison found in the WHERE clause of a SQL statement.
CompareTerm() - Constructor for class CompareTerm: Default constructor used when constructing a Column object
CompareTerm(Integer) - Constructor for class CompareTerm: Constructs a CompareTerm that represents an integer operand with a fixed value.
CompareTerm(Double) - Constructor for class CompareTerm: Constructs a CompareTerm that represents a floating-point operand with a fixed value.
CompareTerm(String) - Constructor for class CompareTerm: Constructs a CompareTerm that represents a String operand with a fixed value.
Comparison - Class in <Unnamed>: A class that represents a comparison appearing in a WHERE clause.
Comparison(int, CompareTerm, CompareTerm) - Constructor for class Comparison: Constructs a Comparison object that represents a comparison involving the specified operator and operands.
ConditionalExpression - Class in <Unnamed>: An abstract class that represents a conditional expression like those found in the WHERE clause of a SQL statement.
ConditionalExpression() - Constructor for class ConditionalExpression: Default constructor used when constructing an object of a subclass that has no subexpressions (e.g., a TrueExpression) or that has subexpressions that are not ConditionalExpressions (e.g., a Comparison).
ConditionalExpression(ConditionalExpression, ConditionalExpression) - Constructor for class ConditionalExpression: Constructor used when constructing an object of a subclass that has one or two subexpressions.
CreateStatement - Class in <Unnamed>: A class that represents a CREATE TABLE statement.
CreateStatement(Table, ArrayList<Column>) - Constructor for class CreateStatement: Constructs a CreateStatement object that will create the specified table with the specified column information.

D

DB_HOME - Static variable in class DBMS: The home directory of the BDB environment.
DBMS - Class in <Unnamed>: The main class of a simple relational database.
DBMS() - Constructor for class DBMS
dbName() - Method in class Table: Returns the name of the table's BDB database file.
DEBUG - Static variable in class DBMS: Set this to true to print debugging messages, and false to omit them.
DeleteStatement - Class in <Unnamed>: A class that represents a DELETE statement.
DeleteStatement(Table, ConditionalExpression) - Constructor for class DeleteStatement: Constructs a DeleteStatement object involving the specified table and conditional expression.
distinctSpecified() - Method in class SelectStatement: Returns a boolean value indicating whether duplicates should be eliminated in the result of this statement -- i.e., whether the user specified SELECT DISTINCT.
DropStatement - Class in <Unnamed>: A class that represents a DROP TABLE statement.
DropStatement(Table) - Constructor for class DropStatement: Constructs a DropStatement object involving the specified table.

E

EQ - Static variable in class Comparison: A comparison involving = or ==
execute() - Method in class BeginStatement
execute() - Method in class CommitStatement
execute() - Method in class CreateStatement
execute() - Method in class DeleteStatement
execute() - Method in class DropStatement
execute() - Method in class InsertStatement
execute() - Method in class RollbackStatement
execute() - Method in class SelectStatement
execute() - Method in class SQLStatement: Executes this SQL statement.
execute() - Method in class UpdateStatement

F

first() - Method in class TableIterator: Positions the iterator on the first tuple in the relation, without taking the a WHERE clause (if any) into effect.

G

getBufferBytes() - Method in class RowOutput: Returns a byte array containing the bytes written to this RowOutput
getBufferLength() - Method in class RowOutput: Returns the number of bytes written to this RowOutput
getColumn(int) - Method in class SQLStatement: Returns the column with the specified index in this statement.
getColumn(int) - Method in class Table: Returns the column with the specified index in this table.
getColumn(int) - Method in class TableIterator: Gets the column at the specified index in the relation that this iterator iterates over.
getColumnVal(int) - Method in class SQLStatement: Returns the column value with the specified index in this statement.
getColumnVal(int) - Method in class TableIterator: Gets the value of the column at the specified index in the row on which this iterator is currently positioned.
getDB() - Method in class Table: Returns the database handle for this table's underlying database.
getEnv() - Static method in class DBMS: Returns the handle for the underlying BDB environment.
getIndex() - Method in class Column: Returns the index of the column in the table to which it belongs.
getKeyBuffer() - Method in class InsertRow: Returns the RowOutput used for the key portion of the marshalled row.
getLeft() - Method in class ConditionalExpression: Returns the left (i.e., the first) subexpression of the expression represented by the called object.
getLeftTerm() - Method in class Comparison: Returns the left operand of the comparison represented by the called object.
getLength() - Method in class Column: Returns the length of the column -- i.e., the number of bytes used to represent its values.
getMax() - Method in class Limit: Returns the max value of this Limit object, indicating the maximum number of rows to be displayed.
getMetadata(Table) - Static method in class Catalog: Reads the entry for the specified table from the catalog of metadata and adds the column information to the Table object.
getName() - Method in class Column: Returns the name of the column.
getName() - Method in class Table: Returns the name of the table.
getOffset() - Method in class Limit: Returns the offset value of this Limit object, indicating the index of the first row to be displayed.
getRangeVar() - Method in class Table: Returns the range variable (if any) associated with this table.
getRight() - Method in class ConditionalExpression: Returns the right (i.e., the second) subexpression of the expression represented by the called object.
getRightTerm() - Method in class Comparison: Returns the right operand of the comparison represented by the called object.
getTable() - Method in class Column: Returns the table to which this column belongs.
getTable(int) - Method in class SQLStatement: Returns the table with the specified index in this statement.
getTableIterator() - Method in class Column: Returns the table iterator used to obtain values of this column IMPORTANT: if you invoke this method on a Column from a Table object's array of column information, it will return null.
getType() - Method in class Column: Returns the type of the column
getType() - Method in class Comparison: Returns the type of the comparison represented by the called object.
getUpdateVal() - Method in class Column: Returns the update value associated with this column -- i.e., the value it should be assigned by an update command.
getValType() - Method in class CompareTerm: Gets the type of the operand's value.
getValue() - Method in class Column: Returns the current value of this column, based on the row on which the corresponding table iterator is currently positioned.
getValue() - Method in class CompareTerm: Gets the operand's value.
getValueBuffer() - Method in class InsertRow: Returns the RowOutput used for the value portion of the marshalled row.
getWhere() - Method in class SQLStatement
getWhereColumn(int) - Method in class SQLStatement: Returns the column with the specified index from the WHERE clause of this statement.
GT - Static variable in class Comparison: A comparison involving >
GTEQ - Static variable in class Comparison: A comparison involving >

I

init() - Static method in class DBMS: Initializes the DBMS -- initializing the underlying BDB environment, the catalog, and the in-memory cache of open tables.
InsertRow - Class in <Unnamed>: A class that represents a row that will be inserted in a table in a relational database.
InsertRow(Table, Object[]) - Constructor for class InsertRow: Constructs an InsertRow object for a row containing the specified values that is to be inserted in the specified table.
InsertStatement - Class in <Unnamed>: A class that represents an INSERT statement.
InsertStatement(Table, ArrayList<Column>, ArrayList<Object>) - Constructor for class InsertStatement: Constructs an InsertStatement object involving the specified table, list of columns (if any), and list of values.
INTEGER - Static variable in class Column: A column of type INTEGER
INTEGER - Static variable in class CompareTerm: An integer operand
InvalidSyntaxException - Exception in <Unnamed>: A special exception class that allows us to distinguish parser syntax errors from other exceptions.
InvalidSyntaxException() - Constructor for exception InvalidSyntaxException
IS_NOT_NULL - Static variable in class Comparison: A comparison involving IS NOT NULL
IS_NULL - Static variable in class Comparison: A comparison involving IS NULL
IS_NULL - Static variable in class InsertRow: The field with this offset has a null value.
IS_PKEY - Static variable in class InsertRow: The field with this offset is a primary key.
isNotNull() - Method in class Column: Returns a boolean value indicating whether this column is prevented from taking on null values.
isNotNull() - Method in class ColumnOptions: Returns a boolean value indicating whether the column with these column options is not allowed to store null values.
isPrimaryKey() - Method in class Column: Returns a boolean value indicating whether this column is the primary key of its table
isPrimaryKey() - Method in class ColumnOptions: Returns a boolean value indicating whether the column with these column options is the primary key.
isTrue() - Method in class Comparison: Evaluates the comparison represented by the called object, based on the current values of the operands
isTrue() - Method in class ConditionalExpression: Evaluates the expression represented by the called object, based on the current truth values of the subexpressions.
isTrue() - Method in class NotExpression: Evaluates the expression represented by the called object, based on the current truth value of the subexpression.
isTrue() - Method in class OrExpression: Evaluates the expression represented by the called object, based on the current truth values of the subexpressions.
isTrue() - Method in class TrueExpression: Evaluates the expression represented by the called object, which is always true.

L

LIKE - Static variable in class Comparison: A comparison involving LIKE
Limit - Class in <Unnamed>: A class that encapsulated information from a LIMIT clause in a SELECT statement.
Limit(Integer, Integer) - Constructor for class Limit: Constructs a Limit object that encapsulates the specified offset and maximum number of rows for a LIMIT clause of the form
LT - Static variable in class Comparison: A comparison involving <
LTEQ - Static variable in class Comparison: A comparison involving <=

M

main(String[]) - Static method in class DBMS: The main method for the DBMS application.
marshall() - Method in class InsertRow: Takes the collection of values for this InsertRow and marshalls them into a key/value pair.
MAX_WIDTH_INTEGER - Static variable in class Column: The print width of an INTEGER column.
MAX_WIDTH_REAL - Static variable in class Column: The print width of a REAL column.

N

nameMatches(Column, Table) - Method in class Column: Determines if the column represented by the called object has the same name as the column represented by the two parameters.
next() - Method in class TableIterator: Advances the iterator to the next tuple in the relation.
NOTEQ - Static variable in class Comparison: A comparison involving != or <>
NotExpression - Class in <Unnamed>: A class that represents a conditional expression involving a NOT operator.
NotExpression(ConditionalExpression) - Constructor for class NotExpression: Constructs a NotExpression object that represents the conditional expression NOT expr.
numColumns() - Method in class SQLStatement: Returns the number of columns specified in this statement.
numColumns() - Method in class Table: Returns the number of columns in this table.
numColumns() - Method in class TableIterator: Gets the number of columns in the table being iterated over
numColumnVals() - Method in class SQLStatement: Returns the number of column values specified in this statement.
numTables() - Method in class SQLStatement: Returns the number of tables specified in this statement.
numTuples() - Method in class TableIterator: Gets the number of tuples that the iterator has visited.
numWhereColumns() - Method in class SQLStatement: Returns the number of columns in the WHERE clause of this statement, or 0 if there is no WHERE clause.

O

open() - Static method in class Catalog: Opens the catalog so that it can be used to store and retrieve metadata.
open() - Method in class Table: Opens the table so that it can be accessed by SQL commands.
OrExpression - Class in <Unnamed>: A class that represents a conditional expression involving an OR operator.
OrExpression(ConditionalExpression, ConditionalExpression) - Constructor for class OrExpression: Constructs an OrExpression object that represents the conditional expression left OR right.

P

primaryKeyColumn() - Method in class Table: Returns the column (if any) that is the primary key of this table.
printAll(PrintStream) - Method in class TableIterator: Iterates over all rows in the relation and prints them to the specified PrintStream (e.g., System.out).
printWidth() - Method in class Column: Returns the maximum print width for values from this column.
putMetadata(Table) - Static method in class Catalog: Adds an entry to the catalog for the specified table.

R

readBooleanAtOffset(int) - Method in class RowInput: reads a boolean at the specified offset in this RowInput's byte array
readByteAtOffset(int) - Method in class RowInput: reads one byte at the specified offset in this RowInput's byte array
readBytesAtOffset(int, int) - Method in class RowInput: returns a String constructed by reading numBytes bytes at the specified offset in this RowInput's byte array
readDoubleAtOffset(int) - Method in class RowInput: reads a value of type double at the specified offset in this RowInput's byte array
readIntAtOffset(int) - Method in class RowInput: reads an int (a four-byte integer) at the specified offset in this RowInput's byte array
readNextBoolean() - Method in class RowInput: reads a boolean at the current offset in this RowInput's byte array
readNextByte() - Method in class RowInput: reads one byte at the current offset in this RowInput's byte array
readNextBytes(int) - Method in class RowInput: returns a String constructed by reading numBytes bytes at the current offset in this RowInput's byte array
readNextDouble() - Method in class RowInput: reads a value of type double at the current offset in this RowInput's byte array
readNextInt() - Method in class RowInput: reads an int (a four-byte integer) at the current offset in this RowInput's byte array
readNextShort() - Method in class RowInput: reads a short (a two-byte integer) at the current offset in this RowInput's byte array
readShortAtOffset(int) - Method in class RowInput: reads a short (a two-byte integer) at the specified offset in this RowInput's byte array
REAL - Static variable in class Column: A column of type REAL
REAL - Static variable in class CompareTerm: A real (i.e., floating-point) operand
removeMetadata(Table) - Static method in class Catalog: Removes the entry for the specified table from the catalog of metadata.
resetUpdateVal() - Method in class Column: Removes any update value associated with this column, which means that an update command will not try to update it unless a new update value is specified using setUpdateVal.
RollbackStatement - Class in <Unnamed>: A class that represents a ROLLBACK statement in SQL, which rolls back the current transaction.
RollbackStatement() - Constructor for class RollbackStatement
RowInput - Class in <Unnamed>: An input stream with methods that read values from a byte array.
RowInput(byte[]) - Constructor for class RowInput: Constructs a RowInput object
RowOutput - Class in <Unnamed>: An output stream with methods that write values into a byte array.
RowOutput() - Constructor for class RowOutput: Constructs a RowOutput object

S

SelectStatement - Class in <Unnamed>: A class that represents a SELECT statement.
SelectStatement(ArrayList<Object>, ArrayList<Table>, ConditionalExpression, Limit, Boolean) - Constructor for class SelectStatement: Constructs a SelectStatement object involving the specified columns and other objects from the SELECT clause, the specified tables from the FROM clause, the specified conditional expression from the WHERE clause (if any), the specified Limit object summarizing the LIMIT clause (if any), and the specified value indicating whether or not we should eliminate duplicates.
setDB(Database) - Method in class Table: Sets the database handle for this table's underlying database.
setIndex(int) - Method in class Column: Sets the index of this column -- i.e., its index in the table to which it belongs.
setLength(int) - Method in class Column: Sets the length of this column.
setLength(Integer) - Method in class Column: Sets the length of this column -- i.e., the number of bytes used to represent its values.
setRangeVariable(String) - Method in class Table: Sets a range variable (i.e., an alias) for this table.
setTableIterator(TableIterator) - Method in class Column: Sets the table iterator used to obtain the values of this column.
setType(int) - Method in class Column: Sets the type of this column -- which must be one of the constants specified in this class (INTEGER, REAL, CHAR, or VARCHAR).
setUpdateVal(Object) - Method in class Column: Sets the update value associated with this column, which means that any update commands will try to update it until the update value is removed using resetUpdateVal.
setValType(int) - Method in class CompareTerm: Sets the type of the operand's value.
shouldUpdate() - Method in class Column: Determines whether this column should be updated by an update command -- i.e., if it has an up-to-date update value.
shutdown() - Static method in class DBMS: Prepares the DBMS to shutdown -- closing all open tables, as well as the catalog and the underlying BDB environment.
SQLStatement - Class in <Unnamed>: An abstract class that represents a SQL statement.
SQLStatement() - Constructor for class SQLStatement: Default constructor, used in the constructors for subclasses that represent statements that don't have any associated state (i.e., begin, commit, and rollback).
SQLStatement(Table) - Constructor for class SQLStatement: Constructor used in the constructors for subclasses that represent statements that only specify a table (i.e., drop table statements).
SQLStatement(Table, ArrayList<Column>) - Constructor for class SQLStatement: Constructor used in the constructors for subclasses that represent statements that only specify a table and some column information (i.e., create table statements).
SQLStatement(ArrayList<Table>, ArrayList<Column>, ConditionalExpression) - Constructor for class SQLStatement: Constructor used in the constructors for subclasses that represent statements that specify table(s), column(s), and a conditional expression (i.e., select, update, and delete statements).
SQLStatement(Table, ArrayList<Column>, ConditionalExpression) - Constructor for class SQLStatement: Constructor used in the constructors for subclasses that represent statements that specify a single table, one or more column(s), and a conditional expression (i.e., update and delete statements).
SQLStatement(Table, ArrayList<Column>, ArrayList<Object>) - Constructor for class SQLStatement: Constructor used in the constructors for subclasses that represent statements that specify a single table, one or more column(s), and values for those columns (i.e., insert statements).
STAR - Static variable in class SelectStatement
STRING - Static variable in class CompareTerm: A string operand

T

Table - Class in <Unnamed>: A class that represents a table in a relational database.
Table(String) - Constructor for class Table: Constructs a Table object with the specified name.
TableIterator - Class in <Unnamed>: A class that serves as an iterator over some or all of the rows in a stored table.
TableIterator(SQLStatement, Table, boolean) - Constructor for class TableIterator: Constructs a TableIterator object for the subset of the specified table that is defined by the given SQLStatement.
toString() - Method in class Column
toString() - Method in class CompareTerm
toString() - Method in class InsertRow: Returns a String representation of this InsertRow object.
toString() - Method in class RowInput: Returns a String representation of this RowInput object that includes the underlying byte array and the current offset.
toString() - Method in class RowOutput: Returns a String representation of this RowOutput object that shows the current contents of the underlying byte array.
toString() - Method in class SQLStatement
toString() - Method in class Table
TrueExpression - Class in <Unnamed>: A class that represents a conditional expression that is always true.
TrueExpression() - Constructor for class TrueExpression

U

UpdateStatement - Class in <Unnamed>: A class that represents an UPDATE statement.
UpdateStatement(Table, ArrayList<Column>, ConditionalExpression) - Constructor for class UpdateStatement: Constructs an UpdateStatement object involving the specified table, list of columns, and conditional expression.
useColInfo(Column) - Method in class Column: Gives the column specified by the called object the same metadata (type, length, etc.) as the specified other column.

V

VARCHAR - Static variable in class Column: A column of type VARCHAR

A B C D E F G I L M N O P R S T U V