RC
RC child
RDBMS
record
Record Complex
record identifier
record number
Record Specific
record specific ID cross reference
redefineable row IDs
Referential Integrity
relational operator
relative record number
repeating key
replacement step
retrieval intrinsics
right outer join
RMS
ROLAP
root file
row
row ID
RS
RS child
run-time options
Appendix
|
A
B C
D E
F G
H I
J K
L M
N O
P Q
R S
T U
V W
X Y
Z
RC child
- a child table which is indexed with only primary keys
(from parent table). See Record Complex.
RDBMS
- Relational Database Management System; a database approach
involving two-dimensional tables to define data relationships.
record
- A set of field, or column, values in a data file or database
table; (2) a structured collection of information or data
treated as a unit; also known as a row or tuple.
Record Complex
- when a child table is prejoined (linked) to a parent table,
- an affiliation of records in an SI domain that all contain
the same OMNIDEX SI value; for example, qualifying from
child or parent returns parent rows;
- keys that qualify record complexes (MDK Indexes in parent
tables or master data sets, and MDK Indexes installed with
the Record Complex option).
- When Record Complex is installed on a keyword index in
a child table, the index is treated as if it belonged to
the parent table. See SI
domain, Record Specific,
RC child, RS child.
record identifier
- A value that uniquely identifies a record in a table;
- A search item (SI) for a parent table and a row ID for
all other tables.
record number
- an internally maintained value associated with the position
in a detail file of individual detail records.
Record Specific
- table,
- an affiliation of records in an SI domain that are indexed
in reference to their own table; for example, if qualifying
records from a child table, query will return child rows
with the ability to access the parent rows, else if qualifying
from the parent table, query will return parent rows;
- refers to MDK Index or keyword retrievals that qualify
individual detail records. Non-Record Complex keys in detail
records are Record Specific. See Record Complex and SI domain.
record specific ID cross
reference
- a portion of an OMNIDEX index that correlates each parent
constraint with the corresponding child row IDs. This portion
of the index is used for performing qualifications, as well
as several types of joins.
redefineable row IDs
- row IDs subject to OMNIDEX manipulation to insure sequential
nature. See well-behaved row IDs.
Referential Integrity
- A method of ensuring that the relationship between records
in related tables is maintained. Specifically, referential
integrity checks to make sure that a parent record exists
for every child record.
relational operator
- the greater than (>), greater than or equal to (>=),
less than (<), less than or equal to (<=), and equal
(=) operators used to specify a relational retrieval.
relative record number
repeating key
replacement step
- the process of replacing ID values in the kernel aggregate
results with the column specified in the group by the statement.
The ID value is used to read into the dimension or snowflake
table where the Group By column resides.
retrieval intrinsics
- intrinsics that are used to search for or retrieve records.
right
outer join
- An outer join in which all rows from the right table in
the JOIN clause are included, only rows from the left table
with matching rows in the right table are included, and
right table rows with no matching left table rows are matched
with nulls.
- When Omnidex encounters a right outer join, it will attempt
to convert it to a left outer join by switching the tables.
If unable to do this, the query will fail.
RMS
- Record Management Services; the VAX-based database management
system software from Digital Equipment Company (DEC).
ROLAP
- Relational On-line Analytical Processing; on-line analytical
processing using summary tables in a relational database.
See OLAP. MDD, and MOLAP.
root file
- a file that contains information about the database structure.
In OMNIDEX, the OMNIDEX root file contains information about
where keys are installed.
row
row ID
- a unique representation of a single record in a set of
data. See record number.
RS child
- a child table indexed with both the primary keys (from
parent) and its own row IDs. See Record Specific.
run-time options
- configurable options that control certain features of
a program, like DBINSTAL, for the duration of a session.
Top
|