Shulou(Shulou.com)06/03 Report--

Today, the editor to share with you is the introduction of the functions and characteristics of the database server, many people do not understand, today the editor in order to let you know more about the class names in css, so give you a summary of the following content, let's look down. I'm sure you'll get something.

A "client-server" model that is provided to a program or computer to connect to a database, and also refers to the computer on which the program is run. It is generally composed of computer and database management software.

The function of database server

The function of the database server depends on the database management system. Some database management systems, such as MySQL, rely entirely on the "client-server" model of the database server to access the database.

The database server has two ways to communicate between the user and the database. One is that the user can access the database server through the front-end software running on the computer, and the database server directly displays the data requested by the user. The second is that users complete the tasks such as data analysis and storage by sending requests and running on the back end of the server.

In the master-slave database server, the database master server is the core location of the data, while the database slave server acts as a master server agent or provides synchronous backup. Most database servers have their own response query language. each database converts the submitted query information into a server-readable form through the user's query language, executes and gives the retrieval results.

Currently common proprietary database servers include Oracle,DB2,Informix and Microsoft SQL Server. Freeware database servers include PostgreSQL; under the GNU General Public license, including Ingres and MySQL. Each server has its own query logic and structure. SQL (structured query language) query languages on all relational database servers have more or less in common.

Database server is generally based on database system and has the characteristics and functions of database system. It can provide system configuration and management, data access and update management, data integrity management and data security management. It can provide database maintenance functions, such as data import / export management, database structure maintenance, data recovery and performance monitoring. When there are many database access customers, the database server supports parallel operation mechanism, which can handle multiple events occurring at the same time.

Characteristics of database server

The database server helps build a bridge between the user and the database. The database server provides a standard interface API for data manipulation, which reduces the amount of programming, and provides a unified manageable database backup / recovery, start / stop database management tools.

The database server provides a guarantee for the database in terms of security. the performance monitoring and concurrency control tools it provides solves the worries of the database, and the database administrator is responsible for authorizing access to the database and network management.

The database server separates the data management and processing work from the client, which makes the configuration of computer resources in the network more flexible. It reduces the network cost, reduces the competition between resources, avoids deadlock, provides an online query optimization mechanism, and makes the allocation of database resources more reasonable.

The database server can also provide a variety of extension functions, such as horizontal expansion of multi-processors, horizontal or vertical expansion of multiple servers, and servers can be ported to more powerful computers without dealing with the redistribution of data.

In the era of big data, the database server is the bridge between the user and the database, the core of big data, and the key to data processing in big data's era.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.