What Is a Web Database?

The two technologies of data and resource sharing combine to become a widely used network database (WEB database), which is based on a background (remote) database, plus a certain foreground (local computer) program, through a browser or A client system that performs data storage and query operations. ^[1]

The two technologies of data and resource sharing combine to become a widely used network database (WEB database), which is based on a background (remote) database, plus a certain foreground (local computer) program, through a browser or A client system that performs data storage and query operations. ^[1]

Chinese name

Network database

Foreign name

Network database

Features

Browser completion data

Solid

Plus a certain front desk

Network database definition

Network database refers to the introduction of database technology into computer network systems, and the timely release of a large amount of information stored in the database by means of network technology; and the computer network effectively manages various data in the network by means of mature database technologies And real-time dynamic data interaction between users and databases in the network. ^[2]

Network databases currently have a large number of applications, from the original website guestbook, free forum, etc. to today's distance education and complex e-commerce, etc., these systems are almost always implemented using network databases. The components of a network database system are: the client, the server, and the network connecting the client and the server. These elements are the foundation of a network database system.

The biggest advantage of using a network database is that users only need to use a Web browser to complete common operations on database data. This advantage makes it unnecessary for users to learn complicated database knowledge and use of database software. They only need to master basic network operations, such as filling in and submitting forms, to access the database from any computer connected to the Internet. The network database system operates as shown in Figure 1.

Figure 1 Network database system operation

Network Database Features

Compared with traditional databases, network databases have the following characteristics:

1. Expanded the scope of data resource sharing. Because the scope of computer networks can range from local to global, the scope of data resource sharing in network databases has also expanded.

2. Easy for distributed processing. In the computer network, each user can reasonably select the resources in the network according to the situation, so that the nearest and fast processing is possible. For large jobs and large batches of data processing, it can be decomposed to different computers for processing by a certain algorithm, so as to achieve a balanced use of network resources, achieve the purpose of distributed processing, and greatly improve the processing speed of data resources.

3 The use of data resources is flexible. Web-based database application system development can use either C / S structure (Client / Server, client / server) or B / S structure (Browser / Server, browser / server). Flexible use.

4 Facilitate data transmission and communication. Through the computer network, the data in the network database can be easily transferred to any area covered by the network.

5. Reduced system usage costs and increased computer availability. Because the network database can be shared by users on the entire network, users who use data resources do not necessarily own the database. This greatly reduces the requirements on the computer system and improves the availability of each computer.

6. Data confidentiality and security are reduced. Due to the expansion of the database sharing scope, it is more difficult to manage database users, and the probability of network databases being damaged or stolen increases, which reduces the confidentiality and security of data.

Network Database Network and Network Database

Network is to use communication equipment and lines to connect multiple computers in different geographical locations and relatively independent operations, and then configure certain system software and application software to achieve software and hardware resource sharing and information transfer on these computers , Thus forming a computer network.

The Internet is an ultra-large-scale network system composed of many computer LANs in the world interconnected with each other. In this system, a variety of application systems are running, such as the web browsing system for the Internet-WWW (the World Wide Web Internet), uploading and downloading File transfer system-FTP, email system used to send and receive email-Email, etc. Each application system running in the Internet is composed of the corresponding server system and client system in the Internet. That is to say, the Internet is composed of a large number of computers from a physical connection point of view, and logically consists of multiple functions. Subnet composition.

The network can also access the database in a variety of ways, such as CGI, API, and ODBC technologies. The principle of network and database connection is shown in the figure.

Figure 2 Principle of network and database connection

A typical database query process includes the following steps.

1. The user sends a query request to the web server through the browser.

2. The server starts the corresponding CGI (Common Gateway Interface) or API (Application Programming Interface) program (ie, the gateway) according to the parameters.

3 CGI or API programs log in to the database and query based on conditions.

4 The database returns the query results.

5. The CGI or API program translates the query results into a standard HTML format and sends it to the web server.

6. The web server passes the HTML page containing the results to the browser.