TWI574168B - Database system - Google Patents

Description

Database system

The present invention relates to a database system, and more particularly to a database system that can store data to a remote server.

The development of information technology is inseparable from the continuous development of database technology. From dbase, Foxbase, Foxpro, Access, to Microsoft SQL Server, Sybase SQL Server, Oracle, the database is getting bigger and bigger, and its functions are getting stronger and stronger. . Due to the increasing size of the data stored in the modern database system, multiple servers and databases are set up in different locations, and each other is connected through a computer network to form a logically unified database system. In this way, how to make the server and database distributed everywhere access the correct data has formed an important issue. In view of this, it is necessary to provide a database system to solve the above problems.

The primary object of the present invention is to provide a database system that has the effect of storing data to a remote server.

Another main object of the present invention is to provide a An application server that provides a foreign network selling system, which has the effect of storing data to a remote server.

In order to achieve the above objective, according to an embodiment of the present invention, a database system of the present invention includes a database, an application server, and a remote server, and the remote server is respectively connected to the database and the application server through the network. The application server includes a transmission module and a processing module. The transmission module is configured to take relevant data from the data repository according to a preset event when the database has a preset event, and transmit it to the remote server for storage through the network. The processing module is configured to receive the query instruction transmitted by the remote server through the network, and perform data query in the database according to the query instruction.

According to an embodiment of the invention, the preset event includes a new item shelf event or an item status update event.

According to an embodiment of the present invention, the related material includes a product classification, a product name, a commodity price, and a commodity attribute.

According to an embodiment of the invention, the query instruction comprises an inventory query, a price query or a blacklist query.

1‧‧‧Database System

10‧‧‧Database

20‧‧‧Application Server

21‧‧‧Transmission module

22‧‧‧Processing module

30‧‧‧Remote Server

31‧‧‧ receiving module

32‧‧‧Remote processing module

40‧‧‧Network

1 is a system architecture diagram of a database system in accordance with an embodiment of the present invention.

2 is a flow chart showing the steps of a method of operating a database system in accordance with an embodiment of the present invention.

The above and other objects and features of the present invention are provided. The advantages and advantages of the invention will be apparent from the following description.

Please refer to FIG. 1 below, which is a system architecture diagram of a database system according to an embodiment of the present invention. As shown in FIG. 1, a database system 1 of the present invention includes a database 10, an application server 20, and a remote server 30, in accordance with an embodiment of the present invention. The application server 20 includes a transmission module 2 and a processing module 2. The remote server 30 includes a receiving module 31 and a remote processing module 32. The database 10, the application server 20, and the remote server 30 are connected to each other through a network 40 to transmit or receive data.

According to an embodiment of the present invention, each of the modules may be configured as a hardware device, a software program, a firmware, or a combination thereof, or may be configured by a circuit loop or other suitable type; and each module may be separately provided. In addition to the type configuration, it can also be combined with the type configuration. In addition, the present embodiment is merely illustrative of preferred embodiments of the present invention, and in order to avoid redundancy, all possible combinations of variations are not described in detail. However, those of ordinary skill in the art will appreciate that the various modules or components described above are not necessarily required. In order to implement the invention, other well-known modules or elements of more detail may also be included. Each module or component may be omitted or modified as needed, and no other modules or components may exist between any two modules.

According to an embodiment of the invention, the database 10, the application server 20 and the remote server 30 can be provided, maintained or controlled by a shopping service provider. The database 10, the application server 20, and the remote server 30 can be deployed at different locations, such as the database 10 and the application server 20. Built in Taiwan, the remote server 30 is located in the United States, and the three are transmitted through the network.

In accordance with an embodiment of the present invention, the database 10, the application server 20, and the remote server 30 can be based on various cellular communication standards and/or proprietary communication protocols (eg, 1G, 2G, 3G, 4G, CDMA) , WCDMA, PDC, TDMA, GSM/GPRS/EDGE, etc.) communication. For example, the network 40 can be a computer network or a variety of features including a computer communication network. For example, in the arrangement, the network 40 can be any type of computer communication network (eg, the Internet, a wide area network (WAN), a local area network (LAN), a personal area network (PAN), Metro network (MAN), terrestrial computer communication network, satellite computer communication network, etc., or include any of the characteristics of a computer communication network. Also, in the arrangement, the database 10, the application server 20, and the remote server 30 can use various standard and/or proprietary lower level protocols (eg, IEEE 802.3, IEEE 802.4, IEEE). 802.5, IEEE 802.11, IEEE 802.15, IEEE 802.16, IEEE 802.20, etc.) communicate with the network.

Next, please refer to FIG. 2, which is a flow chart of steps of a method for operating a database system according to an embodiment of the present invention. The method of operating the database system of the present invention will be described below with reference to the database system shown in FIG. It should be noted, however, that the method of operating the database system of the present invention is not limited to use the database system shown in FIG. 1.

First, step S21 is performed: when the preset event occurs in the database 10, the related data is retrieved from the database 10 according to the preset event, and transmitted to the remote server 30 for storage via the network.

First, when the database 10 has a preset event, the transmitting module 21 of the application server 20 retrieves relevant data from the database 10 according to the preset event, and transmits the data to the remote server through the network 40. The device 30 stores. According to an embodiment of the present invention, the preset event includes a new item shelf event or a product status update event, and the related item includes a product category, a product name, a product price, and a product attribute, but the invention is not limited thereto. For example, a book "Encryption and Decryption" is about to be put on the shelves. Therefore, a new item in the database 10 is "Book (Classification), Encryption and Decryption (trade name), 350 yuan (commodity price) and computer. a book (commodity attribute) transmitted by the delivery module 21 to the remote server 30; or when the status of the data is changed to "book type (product classification), encryption and decryption (product name)" When 400 yuan (commodity price) and computer book (commodity attribute) are transmitted, the transmission module 21 transmits the result to the remote server 30 for storage.

Then proceed to step S22: receiving the related data and storing.

The transmitting module 21 of the application server 20 transmits the related data to the remote server 30 through the network 40. The remote server 30 is received by the receiving module 31 and stored.

Then, step S23 is performed: the remote server 30 receives the query instruction and transmits the query command to the application server 20.

On the remote server 30 side, when the query command for the database 10 is received, the remote processing module 32 transmits the query command to the application server 20. According to an embodiment of the invention, the query instruction includes an inventory query and a price query. Or blacklist query. For example, after receiving an order from the consumer "PETER" for the book "encryption and decryption", the query command can include whether there is inventory, the price, and whether the consumer is blacklisted.

Finally, step S24 is performed: the query command transmitted by the remote server 30 is received through the network 40, and the data query is performed in the database 10 according to the query command.

The application server 20 receives the query command transmitted by the remote server 30 through the network 40, and performs data query in the database 10 according to the query command. For example, in the database 10, the book "encryption and decryption" is still in stock, the price is 400 yuan, and the consumer "PETER" is not in the blacklist.

It should be noted that the operation method of the database system 1 of the present invention is not limited to the above-described sequence of steps, and the order of the above steps may be changed as long as the object of the present invention can be achieved.

To sum up, the present invention, regardless of its purpose, means and efficacy, shows its distinctive features of the prior art. You are requested to review the examination and express the patent as soon as possible. It should be noted that the various embodiments described above are merely illustrative for ease of explanation, and the scope of the invention is intended to be limited by the scope of the claims.

1‧‧‧Database System

10‧‧‧Database

20‧‧‧Application Server

21‧‧‧Transmission module

22‧‧‧Processing module

30‧‧‧Remote Server

31‧‧‧ receiving module

32‧‧‧Remote processing module

40‧‧‧Network

Claims (6)

A database system comprising: a database; an application server; and a remote server connected to the database and the application server via a network; wherein the application server comprises: a transfer mode a group, when a predetermined event occurs in the database, extracting a related data from the database according to the preset event, and transmitting the data to the remote server through the network, wherein the preset event includes a new a merchandise shelf event or a merchandise status update event; a processing module for receiving a query command transmitted by the remote server through the network, and performing data query in the database according to the query instruction. The database system of claim 1, wherein the related material comprises a product classification, a product name, a commodity price, and a commodity attribute. The database system of claim 2, wherein the query instruction comprises an inventory query, a price query or a blacklist query. An application server for providing a foreign network selling system, which is respectively connected to a database and a remote server through a network, the application server includes: a transmitting module, configured to: when the preset event occurs in the database, extract a related data from the database according to the preset event, and transmit the data to the remote server for storage through the network, wherein the preset event Include a new product shelf event or a product status update event; and a processing module for receiving a query command transmitted by the remote server through the network, and executing data in the database according to the query instruction Inquire. The application server of claim 4, wherein the related material comprises a product classification, a product name, a commodity price, and a commodity attribute. The application server of claim 5, wherein the query instruction comprises an inventory query, a price query or a blacklist query.