ADM 1370 Study Guide - Quiz Guide: Relational Database Management System, Online Transaction Processing, Data Warehouse
30 Nov 2017
School
Department
Course
Professor
Document Summary
Extract, transformation, load (etl) a process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse. Database management system (dbms) a system software for creating and managing databases. The dbms provides users and programmers with a systematic way to create, retrieve, update and manage data. Relational database management system (rdbms) is a program that lets you create, update, and administer a relational database. Query language (sql) to access the database, although sql was invented after the development of the relational model and is not necessary for its use. Data archiving the process of moving data that is no longer actively used to a separate storage device for long-term retention. Archive data consists of older data that is still important to the organization and may be needed for future reference, as well as data that must be retained for regulatory compliance.
