Glossary - O to R
Data Migration Glossary This data migration glossary has been split into sections for faster loading. You can access the complete glossary by following the link, or use the search engine below to find specific terms. |
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
ODBC - Open DataBase Connectivity
- A standard API for accessing a database. Most of the major databases support ODBC which is used by embedding SQL statements into a program and making requests of the database using defined ODBC procedures.
OLTP - On-Line Transaction Processing
- OLTP is a class of program that facilitates and manages transaction-orientated applications, typically for data entry and retrieval transactions in a number of industries.
OOP - Object Orientated Programming
- A revolutionary concept that changed the rules in computer program development, object-orientated programming is organised around "objects" rather than "actions". The aim is produce code which is more robust and more re-usable than is possible with sequential programming techniques. C++ and Java are the most popular object-orientated languages today.
A - B - C - D - f - F - G - H - I - J - K - L - M - N - O - P - Q - R - S - T - U - V - W - X - Y - Z
PAF - Postcode Address File
- A database file enabling address to be determined from a post code.
Pump
- A data pump extracts data from a source system, may perform some filtering and transformation, and loads into a target system(s).
A - B - C - D - E - E - G - H - I - J - K - L - M - N - O - P - Q - R - S - T - U - V - W - X - Y - Z
Quality Assurance - See also Data Cleansing
- A planned and systematic set of actions to provide adequate confidence that work products and the processes used to produce them conform to established requirements.
A - B - C - D - E - E - G - H - I - J - K - L - M - N - O - P - Q - R - S - T - U - V - W - X - Y - Z
RDBMS - Relational DataBase Management System
- See relational database.
Record
- Records are composed of fields, each of which contains one item of information. A set of records constitutes a file, or in a relational database, a table.
Relational Database
- A database that stores data in the form of related tables. Relational databases are powerful because they require few assumptions about how data is related or how it will be extracted from the database. An important feature of relational systems is that a single database record can be spread across several tables
Replication
- The copying of data from one database to another. In data warehousing replication takes place as data is moved from the on-line transaction processing system into the data warehouse. Replication also takes place if a data mart is being populated with data from the data warehouse.
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
The following websites were useful when compiling this page.