The past life of data warehouse: DBMS database management system (OLTP) 1~3 will describe the DBMS database management system from three perspectives: what, why, and how. These three parts are more theoretical, so it will be a little boring to read. If you are a practical group, you can directly read 4 Common Application (oracle, mysql, sql server). 1. What is DBMS: Definition Before the birth of data warehouse, DBMS was widely used. DBMS is the database management system database management system. DBMS is a large-scale software for manipulating and managing databases, and is used to create, use and maintain databases. It manages and controls the database uniformly to ensure the security and integrity of the database. DBMS is mainly used to manage the Database database.
We generally call this mobile number list processing OLTP (on-line transaction processing), that is, online transaction processing. OLTP is the main application of traditional relational databases, mainly for basic and daily transaction processing. such as bank transactions. 2. Why you need a DBMS: Significance Data Definition : DBMS provides Data Definition Language (DDL) for users to define, create and modify the structure of the database. The database structure described by DDL only gives the framework of the database, and the framework information of the database is stored in the system catalog. Data manipulation : DBMS provides data manipulation language (Data Manipulation Language, DML) to realize user's manipulation of data, including operations such as inserting, deleting, and updating database data. Database operation management.
DBMS provides database operation control and management functions, including transaction management and automatic recovery in multi-user environment, concurrency control and deadlock detection, security check and access control, integrity check and execution, and operation log organization management, etc. These make the database system work properly. Database maintenance : The maintenance of the database includes data loading, conversion, dumping, and recovery of the database, reorganization and reconstruction of the database, and performance monitoring and analysis functions. These functions are completed by each application program. Data transfer : The DBMS has an interface responsible for handling the transfer of data. These interfaces are related to on-line processing of the operating system as well as time-sharing systems and remote job input.