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.
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.
Relational Online Analytical Processing (ROLAP):
OLAP software that employs a relational strategy to organize and store the data in its database
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.
A database used by reporting applications. Reporting databases are often duplicates of transaction databases used to off-load report processing from transaction databases.
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.
The process of copying data from one database table to another.
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.
Any persons, equipment, or material needed to perform a task(s).
The automatic creation of system specifications from existing code and data definitions.
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.
A skill set for resources assigned to a project.
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.