Database Glossary – R
Useful Terms For Working With Data
RDBMS also known as a Relational Database Management System
This is an integrated collection of programs that is designed to enable people to construct relational databases, allowing people to enter data then to maintain that data, and to perform manipulations upon that data; frequently queries to return subsets of information.
See: Lock, Read.
This is a coded locking mechanism that provides users to performs manipulations of data, such as queries, on various parts of a database, but prevents modifications of the data itself. Sophisticated database systems allow for multiple users to access the database simultaneously.
Synonymous with row and tuple. An instance of data in a table, a record is a collection of all the facts related to one physical or conceptual entity; often referring to a single object or person, usually represented as a row of data in a table, and sometimes referred to as a tuple in some, particularly older, database management systems.
A view or browse table row that includes fields from more than one linked table; typically a combination of parent and child table fields.
See: Query, Recursive.
1) A series of rules that defines and manages the link between parent and child records.
2) A state in which all the tables in the database are consistent with each other.
3) The facility of any DBMS that ensures the validity of predefined relationships.
Synonymous with table. Mostly used in large DBMS terminology, a relation is the basic collection of data in a relational database, usually represented as a two-dimensional array of rows and columns (records and fields), containing single value entries, and no duplicate rows.
See also: Table.
Relational Database Management System
One or more records in one table may be related to one or more records in a second table by a common value or linking (join) field. This implies that each value of the linking field may appear any number of times in either or both tables.
Exactly one record in one table is related by a common linking field to one or more records in another table, implying that each value of the linking field is unique in the first table, but not necessarily so in the second.
Exactly one record in one table is related by a common linking field to exactly one record in another table, implying that each value of the linking field appears no more than once in each of the tables.
To alter the basic architecture of a table including: number of fields, their names, order, data types and sizes.
Right Outer Join
See: Join, Right Outer.
See: Summary, Rolling.
Synonymous with record and tuple.
See also: Record.
Running A Query
More commonly used term for query resolution.