Alpha

These pages are built from main, turborel 0.0.0. Anything may change from one build to the next: SQL, API, protocol and files alike.

Glossary

Terms

assertion: a constraint of a schema, on no one table; its condition is checked after each statement that changes a table it reads. CREATE ASSERTION.

authorization identifier: the name a session acts as, and that owns schemas and holds privileges: a user's, of a server's client.

base table: a table that holds rows, as CREATE TABLE makes one; not a view.

catalog: the database's schemas together, named by CATALOG.NAME.

checkpoint: a point at which a database kept in a directory has written its changes to its data file, so recovery reads the log only from there.

column: a value of each row of a table, of a name and a data type.

constraint: a rule the rows of tables must keep: NOT NULL, UNIQUE, PRIMARY KEY, a foreign key, a CHECK, a domain's or an assertion.

correlation name: a name a FROM clause gives a table, STAFF S.

cursor: a query read one row at a time, in a program. DECLARE CURSOR.

deferred: of a constraint, checked at COMMIT rather than at the end of each statement.

diagnostics area: where a statement's outcome is kept, for GET DIAGNOSTICS.

direct SQL: statements run on their own, as the client runs them, not in a program's procedures.

domain: a data type with a default and constraints, that columns may be of. CREATE DOMAIN.

engine (extension): what keeps a table's rows: the row store, rowstore, the default; the column store, columnstore, named by CREATE TABLE ... USING; or one a plug-in registers. Table Options.

extension: what Turborel has that the standards do not, marked (extension) in this manual.

foreign key: a constraint that a row's values match those of a row of another table, or its own.

index (extension): a structure that finds rows from column values. The built-in methods use B-link trees and hash tables for comparisons. A plug-in may also find rows for a function used in a WHERE filter.

Information Schema: the schema INFORMATION_SCHEMA, of views that describe the database. The Information Schema.

isolation level: how much a transaction sees of others running at once. SET TRANSACTION.

log: the write-ahead log of a database kept in a directory: each change written there before it is made, so a crash loses no committed transaction.

null value: no value: of a column not given one, or a set function of no rows.

owner: of a schema, the authorization identifier it is of; of the database, the user who manages its users and settings.

plug-in (extension): code a program or the server registers with the database: a storage engine, an index method, a data type, a function, and more.

privilege: the right to do an action on an object: SELECT, INSERT, UPDATE, DELETE, REFERENCES or USAGE. GRANT.

schema: a named set of tables, views, domains and assertions, of one owner. CREATE SCHEMA.

session: a connection's, or a program's, run of statements, of an authorization identifier, a default schema, a time zone and settings of its own.

setting (extension): a named value that changes how the database or a session works. Settings.

SQLSTATE: the five characters of a statement's outcome. SQLSTATE and SQLCODE.

temporary table: a table of which each session has rows of its own, gone as the session ends; global, created local or declared local.

transaction: statements whose changes are made together, or not at all: begun by the first statement, ended by COMMIT or ROLLBACK.

unknown: the truth of a comparison with a null, neither true nor false.

user (extension): a name a server's client may prove it is, by a password the database keeps a verifier of. CREATE USER.

view: a table whose rows are those of its query, found each time it is read. CREATE VIEW.