Home > BI Solutions > Data Warehouse Glossary About Aexis Contact Us Careers
Data Warehouse Glossary

 

If you do not see a particular word or phrase that you would like to know the definition of, please let us know by email and indicate the term you would like to be added to the Glossary.
 
 
  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
 
 
 
Record
 
In a non-relational database system, a record is an entry in a file, consisting of individual elements of information, which together provide full details about an aspect of the information needed by the system. Individual elements are held in fields and all records are held in files. An example of a record might be an employee. Every detail of the employee, for example, date of birth, department code, or full names will be found in a number of fields. In a relational system, record is an alternate word for row.
 
Referential Integrity Constraint
  Rules that specify the correspondence of a foreign key to the primary key of its related table. For example, what should happen to the foreign key when the referenced primary key row is deleted.
 
Refresh
 
The process for updating the data warehouse database objects with new data. The refresh process occurs after initial load on a scheduled basis and is monitored via warehouse management procedures.
 
Relational Database Management System (RDBMS)
 
A database management system in which data can be viewed and manipulated in tabular form. Data can be sorted in any order and tables of information are easily related or joined to each other.
 
Relationship
 

1. What one entity has to do with another.

2. Any significant way in which two things of the same or different type may be associated.

 
Reporting Database
 
A database used by reporting applications. Reporting databases are often duplicates of transaction databases used to off-load report processing from transaction databases.
 
Repository
 
A mechanism for storing any information about the definition of a system at any point in its life-cycle. Repository services would typically be provided for extensibility, recovery, integrity, naming standards, and a wide variety of other management functions.
 
Request for Proposal
 
The formal mechanism by which a company conveys its business requirements during the search for a new application system. Known as the RFP, this document drives the Pre-sales cycle and provides valuable information into the business requirements definition process of the implementation.
 
Resource
 
Any persons, equipment, or material needed to perform a task(s).
 
Reverse Engineering
 
The automatic creation of system specifications from existing code and data definitions.
 
Risk
 
The potential of an adverse condition occurring on a project which will cause the project to not meet expectations. A risk requires management assessment and a strategy for its mitigation.
 
Row
 
An entry in a table that typically corresponds to an instance of some real thing, consisting of a set of values for all mandatory columns and relevant optional columns. A row is often an implementation of an instance of an entity.
 
ROLAP
 
Relational OLAP. ROLAP systems store data in the relational database.