21 relations: Change data capture, Check constraint, Create, read, update and delete, Data control language, Data definition language, Data manipulation language, Database trigger, Foreign key, From (SQL), Halloween Problem, Log trigger, Merge (SQL), Microsoft Access, Null (SQL), Oracle TopLink, PostgreSQL, Selection (relational algebra), SQL syntax, Transact-SQL, Update, View (SQL).
In databases, change data capture (CDC) is a set of software design patterns used to determine (and track) the data that has changed so that action can be taken using the changed data.
A check constraint is a type of integrity constraint in SQL which specifies a requirement that must be met by each row in a database table.
In computer programming, create, read, update, and delete (as an acronym CRUD) are the four basic functions of persistent storage.
A data control language (DCL) is a syntax similar to a computer programming language used to control access to data stored in a database (Authorization).
A data definition language or data description language (DDL) is a syntax similar to a computer programming language for defining data structures, especially database schemas.
A data manipulation language (DML) is a computer programming language used for adding (inserting), deleting, and modifying (updating) data in a database.
A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database.
In the context of relational databases, a foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table or the same table.
The SQL From clause is the source of a rowset to be operated upon in a Data Manipulation Language (DML) statement.
In computing, the Halloween Problem refers to a phenomenon in databases in which an update operation causes a change in the physical location of a row, potentially allowing the row to be visited more than once during the operation.
In relational databases, the Log trigger or History trigger is a mechanism for automatic recording of information about changes inserting or/and updating or/and deleting rows in a database table.
A relational database management system uses SQL MERGE (also called upsert) statements to INSERT new records or UPDATE existing records depending on whether condition matches.
Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.
Null (or NULL) is a special marker used in Structured Query Language to indicate that a data value does not exist in the database.
Oracle TopLink is mapping and persistence framework for Java (programming language) developers.
PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance.
In relational algebra, a selection (sometimes called a restriction in reference to E.F. Codd's 1970 paper and not, contrary to a popular belief, to avoid confusion with SQL's use of SELECT, since Codd's article predates the existence of SQL) is a unary operation that denotes a subset of a relation.
The syntax of the SQL programming language is defined and maintained by ISO/IEC SC 32 as part of ISO/IEC 9075.
Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to the SQL (Structured Query Language) used to interact with relational databases.
Update may refer to: Technology.
In a database, a view is the result set of a stored query on the data, which the database users can query just as they would in a persistent database collection object.