What Is Database Administration?

Database Management System (Database Management System) is a large-scale software for manipulating and managing databases, used to establish, use and maintain databases, referred to as DBMS. It performs unified management and control of the database to ensure the security and integrity of the database. Users access data in the database through the DBMS, and database administrators also perform database maintenance through the DBMS. It can support multiple applications and users to set up, modify and query the database at the same time or at different times in different ways. Most DBMSs provide a data definition language DDL (Data Definition Language) and a data manipulation language DML (Data Manipulation Language), which allow users to define the schema structure and permission constraints of the database, and implement operations such as adding and deleting data. ^[1]

Database management system is a large-scale software for manipulating and managing databases. It is used to establish, use and maintain databases, referred to as DBMS. It performs unified management and control of the database to ensure the security and integrity of the database. ^[2]

1.

The database management system mainly includes: procedures for data definition language and translation. With the help of this part, users of the database can make their own choices, and can also get translations to form an internal form; procedures for controlling data operations Because of the work of this program, the resources in the database can be fully managed and a control over the data can be achieved; the utility of the database can make the database build on a relatively complete basis, and on a relatively complete basis The database system allows the database to be maintained. ^[4]

The working mode of the DBMS is as follows: ^[5]

(1) Use complex

1.Improve the security of data encryption systems

The computer database management system itself can encrypt data, and combining it with a simple data encryption system can improve data security.

(1) Control data is redundant. Database management should eliminate redundancy as much as possible, but it does not completely eliminate it, but controls the inherent redundancy of a large number of databases. For example, in order to show the relationship between data, data item duplication is generally necessary, and sometimes to improve performance, some data items are also repeated. ^[8]

At present, the more popular database management system products on the market are the products of Oracle, IBM, Microsoft, Sybase, Mysql and other companies. ^[9]

Oracle Database Management System Oracle Database

Oracle database is considered to be the most successful relational database management system in the industry. Oracle's database products are considered to be stable, full-featured, and superior performance aristocratic products. For enterprises with large data volumes, busy transaction processing, and high security requirements. Oracle is undoubtedly the ideal choice. With the popularity of Internete, Oracle timely combined its products with network computing in a timely manner to become a leader in database applications in the Internette field. ^[9]

The Oracle database can run on mainstream operating system platforms such as Unix, Windows, etc., fully supports all industry standards, and obtains the highest level of ISO standard security certification. Oracle's completely open strategy allows customers to choose the most suitable solution, while providing full support to developers. ^[9]

DB2 Database Management System DB2

DB2 is a product of IBM. It is a multimedia, Web relational database management system. Its functions are sufficient to meet the needs of large and medium-sized companies, and it can flexibly serve small and medium-sized e-commerce solutions. The IMS (Information Management System) introduced by IBM in 1968 is a typical representative of a hierarchical database system and is the first large-scale commercial database management system. In 1970, researchers at IBM proposed the relational model of database systems for the first time, pioneering the research on database relational methods and relational data theory, laying the foundation for database technology. Currently, 100% of Fortune 100 companies and 80010 of Fortune 500 companies use IBM's DB2 database products. Another very important advantage of DB2 is that mature applications based on DB2 are very rich. In 2001, IBM merged Informix, the world's fourth-ranked database company, and incorporated its advanced features into DB2, which further improved the performance and functionality of the DB2 system. ^[9]

Sybase Database Management System Sybase Series

Sybase was founded in November 1984. Its product research and development includes enterprise-level databases, data replication, and data access. The main products are: Sybase's flagship database product Adaptive Server Enterprise, Adaptive Server Repli-cation, Adaptive Server Connect and heterogeneous database interconnection options. SybaseASE is its main database product and can run on Unix and Windows platforms. Sybase Warehouse Studio provides specialized analysis solutions in customer analysis, market segmentation and financial planning. Warehouse Studio's core product is Adaptive Server IQ. Its patented data storage technology designed from the bottom can quickly query large amounts of data. There is a complete set of tools around Adaptive Server IQ, including the design of data warehouses or data marts, the integration and transformation of various data sources, the visual analysis of information, and the management of key customer data (metadata). ^[9]