Database Glossary - R
database glossary, RDBMS, record, referential integrity, relational database management system . . . these are all important in data cleansing procedures
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.
Read Lock
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.
Record
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.
Record, Composite
A view or browse table row that includes fields from more than one linked table; typically a combination of parent and child table fields.
Recursive Query
See: Query, Recursive.
Referential Integrity
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.
Relation
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
See: RDBMS.
Relationship, Many-to-Many
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.
Relationship, One-to-Many
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.
Relationship, One-to-One
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.
Restructure
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.
Rolling Summary
See: Summary, Rolling.
Row
Synonymous with record and tuple.
See also: Record.
Running A Query
More commonly used term for query resolution.
Relationship, one-to-many, restructure and right out join - database glossary terms that are important for data cleansing procedures
Download the complete Data Glossary