WO2011143851A1

WO2011143851A1 - Database server operation control system, method and equipment

Info

Publication number: WO2011143851A1
Application number: PCT/CN2010/075964
Authority: WO
Inventors: 毛丰
Original assignee: 中兴通讯股份有限公司
Priority date: 2010-05-19
Filing date: 2010-08-13
Publication date: 2011-11-24
Also published as: CN101833585A

Abstract

A database server operation control system, method and equipment are provided. The database server operation control system includes a database server operation control device (11), a physical database server (12) and a memory database server (13). The database server operation control device (11) is used to acquire the operation type of the operation which needs to be performed by the database server when an intelligent network service is processed. According to the acquired operation type, the database server operation control device (11) indicates the memory database server (13) to perform the operation if the operation needs to be performed by the memory database server (13), and indicates the physical database server (12) to perform the operation if the operation needs to be performed by the physical database server (12). The physical database server (12) is used to perform the operation according to the indication of the database server operation control device (11). The memory database server (13) is used to perform the operation according to the indication of the database server operation control device (11). The database server operation control system solves the problem of less efficiency and the problem of wasting more system resources when the existing database server performs the related operation on the stored data.

Description

The present invention relates to the field of communications technologies, and in particular, to a database server operation control system, method, and device. BACKGROUND OF THE INVENTION With the gradual deepening of the degree of social informationization, database servers are widely used in various industries. In an intelligent network system, a service control point (SCP) will process an intelligent network service. The database server is required to perform certain operations. For example, in the process of processing a user-initiated virtual private mobile network (VPMN) call service, the SCP needs the database server to modify the stored fee data table of the user, then the SCP. The database server is instructed to write to the user's expense data table. In an existing intelligent network system, a physical database server is usually used to perform related operations, and each SCP corresponds to at least one physical database server, and each physical database server stores data related to at least one intelligent network service. Since the physical database server is a database server based on disk storage, and the read/write rate of the external interface of the disk is low, the rate at which the physical database server performs related operations on the stored data is very low, and the physical database server performs The operation is accompanied by data interaction between the memory and the disk. For example, the physical database server needs to perform a write operation, then the physical database server writes the data to be written into the memory first, and then writes the data to the memory. Write to disk, or the physical database server needs to perform a read operation, then the physical database server will read the data to be read into the memory first, and then read the data from the memory, thus costing more system resource. SUMMARY OF THE INVENTION Embodiments of the present invention provide a database server operation control system, method, and device, which are used to solve the problem that an existing database server performs low-cost operations on stored data, and wastes more system resources. . The technical solutions of the embodiments of the present invention are as follows: A database server operation control system, comprising: a database server operation control device, a physical database server, and an in-memory database server, wherein: the database server operation control device is configured to obtain an operation type that requires an operation performed by the database server when processing the intelligent network service If the operation is determined by the in-memory database server according to the obtained operation type, the in-memory database server is instructed to perform the above operation, and if it is determined that the operation needs to be performed by the physical database server according to the obtained operation type, the physical database server is indicated. Performing the above operations; a physical database server for performing the above operations according to an instruction of the database server operation control device; and an in-memory database server for performing the above operations according to an instruction of the database server operation control device. A database server operation control method, the method comprising the steps of: obtaining an operation type that requires an operation performed by a database server when processing an intelligent network service; and determining, according to the obtained operation type, that the operation needs to be performed by an in-memory database server And instructing the in-memory database server to perform the foregoing operations. If it is determined that the operation needs to be performed by the physical database server according to the obtained operation type, the physical database server is instructed to perform the foregoing operations. A database server operation control device, comprising: an obtaining unit, configured to: when processing an intelligent network service, obtain an operation type that requires an operation performed by a database server; and a determining unit, configured to determine, according to an operation type obtained by the obtaining unit, whether the operation is performed The instructing unit is configured to: when the determining result of the determining unit is YES, instructing the in-memory database server to perform the foregoing operation, and when the determining result of the determining unit is negative, instructing the physical database server to perform the foregoing operation . A service control point includes the above database server operation control device. An in-memory database server, comprising: a receiving unit, configured to receive an indication message sent by the database server operation control device for instructing the in-memory database server to perform a corresponding operation; and an operation execution unit, configured to receive the indication at the receiving unit After the message, the corresponding operation is performed. In the technical solution of the embodiment of the present invention, the database server operation control system includes a database server operation control device, a physical database server, and an in-memory database server. When the database server operation control device processes the intelligent network service, the operation of the operation required by the database server is first obtained. Type, if it is determined according to the obtained operation type that the above operation needs to be performed by the in-memory database server, the in-memory database server is instructed to perform the above operation, otherwise the physical database server is instructed to perform the above operations, and the physical database server and the in-memory database server respectively The instruction of the database server operation control device performs a corresponding operation, and thus, it can be seen that the technical party of the embodiment of the present invention The case is no longer only stored by the physical database server and performs related operations, but is performed by the in-memory database server and the physical database server. Each type of database server handles the corresponding type of operation, the database server. The operation control device determines which database server to use according to the operation type, and the rate of reading and writing data by the in-memory database server is much higher than the rate at which the physical database server reads and writes data, and the memory database is in memory. The stored database server does not have data interaction between the memory and the disk during the operation, thereby effectively improving the efficiency of the database server for performing related operations on the stored data, and saving more system resources. BRIEF DESCRIPTION OF DRAWINGS FIG. 1 is a structural block diagram of a database server operation control system according to an embodiment of the present invention; FIG. 2 is a flowchart of a database server operation control method according to an embodiment of the present invention; FIG. 3 is a schematic diagram of an SCP and a database server according to an embodiment of the present invention; FIG. 4 is a flowchart of a specific implementation of a database server operation control method according to an embodiment of the present invention; FIG. 5 is a block diagram of an SCP structure according to an embodiment of the present invention; FIG. 6 is a structural block diagram of an in-memory database server according to an embodiment of the present invention; . DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS The main implementation principles, specific implementation manners, and the corresponding beneficial effects that can be achieved by the embodiments of the present invention are described in detail below with reference to the accompanying drawings. The embodiment of the present invention provides a database server operation control system, which is applied to an intelligent network system. The structure thereof is as shown in FIG. 1 , and includes a database server operation control device 11 , a physical database server 12 , and an in-memory database server 13 . The database server operation control device 11 is configured to: when processing the intelligent network service, obtain an operation type that requires an operation performed by the database server, and if it is determined that the operation needs to be performed by the in-memory database server 13 according to the obtained operation type, indicating the memory The database server 13 performs the above operation, otherwise instructs the physical database server 12 to perform the above operations; the physical database server 12 and the in-memory database server 13 are configured to perform corresponding operations in accordance with the instructions of the database server operation control device 11, respectively. The database server operation control device 11 can be, but is not limited to, an SCP in an intelligent network, where the intelligent network system includes multiple SCPs, and each SCP is responsible for processing at least one type of service, and each SCP performs a control database according to the above manner. Server operation. As can be seen from the above, in the technical solution of the embodiment of the present invention, the database server operation control system includes a database server operation control device, a physical database server, and an in-memory database server. When the database server operation control device processes the intelligent network service, the database server is first obtained. The operation type of the executed operation. If it is determined according to the obtained operation type that the above operation needs to be performed by the in-memory database server, the in-memory database server is instructed to perform the above operation, otherwise the physical database server is instructed to perform the above operations, the physical database server and the in-memory database server. The corresponding operations are performed according to the instructions of the database server operation control device. It can be seen that the technical solution of the embodiment of the present invention no longer only stores data and performs related operations by the physical database server, but by the in-memory database server and the physical server. The database server is completed together, each type of database server handles the corresponding type of operation, and the database server operation control device according to the operation type Which database server is used, and the in-memory database server reads and writes data at a much higher rate than the physical database server reads and writes data, and the in-memory database is stored in the memory of the database server. There is no memory or disk in the operation. The data interaction between them effectively improves the efficiency of the database server in performing related operations on the stored data, and saves more system resources. Correspondingly, the embodiment of the present invention provides a database server operation control method, as shown in FIG. 2, the specific processing procedure is as follows: Step 21: When processing an intelligent network service, obtain an operation type that requires an operation performed by the database server; The database server operation control device is an SCP in the intelligent network. Since the intelligent network system includes multiple SCPs, each SCP is responsible for processing at least one type of intelligent network service, so the intelligent network system passes each type of service through a service processing request. Routed to the corresponding SCP processing. After receiving the service processing request, each SCP triggers the service logic corresponding to the service type of the service. Each type of service corresponds to different service logic. If the business logic contains the required database. The operation performed by the server, the SCP obtains an operation type that requires an operation performed by the database server, where the operation type specifically refers to the data table for the operation and the operation mode to be performed on the data table, for example, the operation type may be "modify the user. Expense data sheet, or "Modify user's configuration data table" Step 22, obtained according to the type of operation, it is determined whether the above-described operation performed by the database server memory, if yes, go to step 23, if no, go to step 24; The embodiment of the invention provides that the in-memory database server is added to perform related operations in the intelligent network system, and the operation types respectively responsible for the in-memory database server and the physical database server are preset, for example, the in-memory database server is responsible for performing the operation type as "modifying the user fee data table". "The operation, and the physical database server is responsible for performing the operation type "modify the user's configuration data table" operation, the SCP stores the correspondence between the operation type and the server type, and the server type includes the monthly response of the in-memory database server The type of the server and the server type corresponding to the physical database server. At this time, the SCP determines whether the above operation needs to be performed by the in-memory database server according to the obtained operation type, but is not limited to the following process: First, the SCP is based on the obtained operation. Type, in the correspondence between the stored operation type and the server type, find the server type corresponding to the obtained operation type, and determine whether the found server type is the server type corresponding to the in-memory database server, if the result is judged Yes, it is determined that the above-described operation needs to be performed by the database server memory, if the judgment result is NO, it is determined that the above-described operation needs to be performed by the physical database server. In the embodiment of the present invention, the operation of the same data table may be performed by a database server or by two database servers. For example, for the "user fee data table, it may be set to be executed by the in-memory database server". The operation of updating the user expense data table ", the physical database server performs the operation of adding or deleting the user fee data table," can also be set to the in-memory database server to separately complete the "modification (including update, add, and delete) user fee data table, If the two database servers perform related operations together for a certain data table, in order to ensure the consistency of the data stored in the two database servers, it is necessary to synchronize the data stored in the two database servers to call For example, if the "User Expense Data Table" of the business is set to perform the "Update User Expense Data Table" operation, the physical database server performs the "Add or Delete User Expense Data Table," operation, where "Update User Fees" data sheet,, The operation is performed during the user's call, and the operation of adding or deleting the user fee data table is performed when the user opens an account or cancels the account, so the "update user fee data table" is executed in the in-memory database server. After the operation, the in-memory database server synchronizes the data with the physical database server. In this case, the full-scale synchronization method can be used, that is, the "user expense data table" stored in the in-memory database is synchronized to the physical database, but due to the in-memory database month There are more data transmitted between the server and the physical database server, so you can use the incremental synchronization method (also called "thing-level" synchronization mode) to tamper with the "user fee data table" during the call. Data and 4 tampering methods are sent to the physical database server, physical database server for "user fee data" Table 4 is the same as the in-memory database server, which is equivalent to the physical database server and the in-memory database server perform the same operation; when the user accounts, the physical database server will target the "user expense data table" The operation of adding or deleting, at this time, the physical database server should synchronize data with the in-memory database server, and the method of full-synchronization or incremental synchronization can be used. The specific synchronization process is not mentioned here. Data synchronization is performed between the database server and the in-memory database server by incremental synchronization. Since the traffic in the intelligent network system is very large, the database server operates more, in order to ensure the data stored in the physical database server and the in-memory database server. Consistency, it is also possible to perform a full amount of synchronization at a specified point in time, for example, synchronizing the "user expense data table" in the physical database server to the in-memory database at the beginning of each month. Step 23, instructing the in-memory database server to perform the above operations; In the embodiment of the invention One or more in-memory database servers may be set. If multiple settings are provided, each in-memory database server is responsible for performing operations on at least one type of service, for example, an intelligent network service that can be processed by an SCP in an intelligent network system. Service 1, Service 2, Service 3, and Service 4, in which 40 pairs of the same type of operation are executed by the in-memory database server, and the in-memory database server A is responsible for executing the service 1 With operation a of service 2, the in-memory database server B is responsible for performing operation a for service 3, and the in-memory database server C is responsible for performing operation a for service 4, which stores the service type of the intelligent network service and the in-memory database server. Correspondence of the server identifier, as shown in Table 1: Schematic diagram of the correspondence between the service type and the server identifier

After determining that the operation for the intelligent network has been performed by the in-memory database server, the SCP first obtains the service type of the intelligent network service, and then according to the obtained service type, the correspondence between the service type and the server identifier of each in-memory database server. In the relationship, the server identifier of the in-memory database server that processes the intelligent network service is searched, and the in-memory database server corresponding to the found server identifier performs operation a. Step 24: Instruct the physical database server to perform the foregoing operations. In the embodiment of the present invention, one or more physical database servers may be set. If multiple settings are provided, each physical database server is responsible for performing operations on at least one type of service, for example, one of the intelligent network systems. The intelligent network service that the SCP can process includes Service 1, Service 2, Service 3, and Service 4. In processing each type of service, forty pairs of the same type of operations are performed by the physical database server, and the physical database service is performed. The D is responsible for performing the operations b for the service 1 and the service 2, the physical database server E is responsible for performing the operation b for the service 3, and the physical database server F is responsible for performing the operation b for the service 4, in which the intelligent network service is stored The correspondence between the service type and the server ID of the physical database server, as shown in Table 2: Schematic diagram of the correspondence between the service type and the server identifier

After determining that the operation b for the intelligent network has been performed by the physical database server, the SCP first obtains the service type of the intelligent network service, and then according to the obtained service type, the correspondence between the service type and the server identifier of each physical database server. In the relationship, the server identifier of the physical database server that processes the intelligent network service is searched, and the physical database server corresponding to the found server identifier is instructed to perform operation b. As shown in FIG. 3, it is a schematic diagram of the relationship between the SCP and the database server in the embodiment of the present invention, which includes multiple SCPs, multiple in-memory database servers, and multiple physical database servers, each of which is respectively Connected to one or more in-memory database servers and physical database servers, each SCP-processed intelligent network service performs corresponding operations when the database server is required to operate.

How the SCP instructs the database server to perform the corresponding operations and how the database server performs the corresponding operations is not mentioned here. In addition, the data in the in-memory database server and the physical database server can be periodically backed up to other storage devices to ensure that data is not lost in the event of an exception. More specific embodiments are given below. If the SCPW processes the VPMN call service, the operation of updating the user fee data table is performed by the in-memory database server A, that is, the in-memory database server A stores the "user fee data table", as shown in FIG. A specific implementation process of the database server operation control method in the embodiment of the present invention is as follows: Step 41: The SCPW receives the VPMN call service request sent by the user A. Step 42: The SCPW determines that the VPMN service is being processed. The database server is required to perform the operation of "updating the user fee data table"; Step 43: The SCPW searches and executes the "update user fee data table" according to the operation type of the "update user fee data table" in the correspondence between the operation type and the server type. "The server type of the operating database server; Step 44, SCPW determines that the discovered server type is the server type corresponding to the in-memory database server; Step 45, SCPW indicates the service type according to the VPMN call service, the service type and the in-memory database. In the corresponding relationship of the server's server identifier, check The server identifier corresponding to the service type of the VPMN call service is found; Step 46, the SCPW determines that the found server identifier is the server identifier of the in-memory database server A; Step 47, the SCPW instructs the in-memory database server A to execute the "update user fee data table" Correspondingly, the embodiment of the present invention provides a database server operation control apparatus, and the structure thereof is as shown in FIG. 5, and includes an obtaining unit 51, a determining unit 52, and an indicating unit 53, wherein: the obtaining unit 51 is configured to process In the case of the intelligent network service, the operation type of the operation required by the database server is obtained; the determining unit 52 is configured to determine, according to the operation type obtained by the obtaining unit 51, whether the operation needs to be performed by the in-memory database server; and the indicating unit 53 is configured to determine When the determination result of the unit 52 is YES, the memory database server is instructed to perform the above operation, and when the determination result of the determination unit 52 is negative, the physical number is indicated. The above operation is performed according to the library server. Preferably, the determining unit 52 specifically includes a first lookup subunit, a judging subunit, and a determining subunit, where: the first lookup subunit is configured to correspond to the operation type and the server type according to the operation type obtained by the obtaining unit 51. In the relationship, the server type corresponding to the obtained operation type is searched; the determining subunit is configured to determine whether the server type found by the first search subunit is a server type corresponding to the in-memory database server; determining the subunit, for determining the subunit When the judgment result is YES, it is determined that the above operation needs to be performed by the in-memory database server, and when the judgment result is NO, it is determined that the above operation needs to be performed by the physical database server. Preferably, if the database server determined by the determining unit 52 is an in-memory server, the indicating unit 53 specifically includes an obtaining subunit, a second searching subunit, and an indicating subunit, wherein: obtaining the subunit, a service type for obtaining the foregoing intelligent network service; a second search subunit, configured to obtain a correspondence between the service type and the server identifier of each memory database server according to the service type obtained by the obtained subunit The server identifier of the in-memory database server that processes the foregoing intelligent network service is searched; the indication sub-unit is configured to instruct the in-memory database server corresponding to the server identifier found by the second search sub-unit to perform the operation. Preferably, if the intelligent network service is a VPMN call service, and the operation type of the operation is the update user fee data table, the database server determined by the determining unit 52 is an in-memory database server. The embodiment of the invention further provides an SCP, which can be, but is not limited to, the above-mentioned database server operation control device. The embodiment of the present invention further provides an in-memory database server, and the structure thereof is as shown in FIG. 6 , and includes a receiving unit 61 and an operation executing unit 62. The receiving unit 61 is configured to receive, by the database server operation control device, the An indication message that the in-memory database server performs corresponding operations; The operation execution unit 62 is configured to perform the foregoing corresponding operation after the receiving unit 61 receives the indication message. It is apparent that those skilled in the art can make various modifications and variations to the invention without departing from the spirit and scope of the invention. Thus, it is intended that the present invention cover the modifications and the modifications of the invention

Claims

Claim

A database server operation control system, comprising: a database server operation control device, a physical database server, and an in-memory database server, wherein:

a database server operation control device, configured to: when processing the intelligent network service, obtain an operation type that requires an operation performed by the database server; if it is determined that the operation needs to be performed by the in-memory database server according to the obtained operation type, indicating the memory The database server performs the operation, if it is determined that the operation needs to be performed by a physical database server according to the obtained operation type, instructing the physical database server to perform the operation; Performing the operation according to an instruction of the database server operation control device;

An in-memory database server for performing the operation in accordance with an indication of the database server operation control device.

2. A database server operation control method, comprising:

When processing an intelligent network service, obtain an operation type that requires an operation performed by the database server;

If the operation is determined to be performed by the in-memory database server according to the obtained operation type, instructing the in-memory database server to perform the operation; otherwise

If it is determined that the operation needs to be performed by a physical database server according to the obtained operation type, the physical database server is instructed to perform the operation.

The database server operation control method according to claim 2, wherein, according to the obtained operation type, it is determined that the operation needs to be performed by an in-memory database server, including:

Determining, according to the obtained operation type, a server type corresponding to the obtained operation type in a correspondence between the operation type and the server type;

When it is determined that the server type found is the server type corresponding to the in-memory database server, it is determined that the operation needs to be performed by the in-memory database server.

The database server operation control method according to claim 2, wherein the instructing the in-memory database server to perform the operation comprises:

Obtaining a service type of the intelligent network service; And searching, according to the obtained service type, a server identifier of an in-memory database server that processes the intelligent network service, in a correspondence between the service type and the server identifier of each in-memory database server;

Indicates that the memory database server corresponding to the found server identifier performs the operation.

The database server operation control method according to claim 2, wherein, if the intelligent network service is a virtual private mobile network VPMN call service, and the operation type of the operation is an update user fee data table, determining The database server is the in-memory database server.

6. A database server operation control device, comprising:

An obtaining unit, configured to obtain an operation type that requires an operation performed by the database server when processing the intelligent network service;

a determining unit, configured to determine, according to the type of operation obtained by the obtaining unit, whether the operation needs to be performed by an in-memory database server;

And an indicating unit, configured to: when the determining result of the determining unit is YES, instructing the in-memory database server to perform the operation, and when the determining result of the determining unit is negative, instructing the physical database server to execute The operation.

7. The database server operation control apparatus according to claim 6, wherein the determining unit comprises:

And a first search subunit, configured to search, according to the operation type obtained by the obtaining unit, a server type corresponding to the obtained operation type in a correspondence between the operation type and a server type;

a determining subunit, configured to determine whether the server type found by the first search subunit is a server type corresponding to the in-memory database server;

Determining a subunit, configured to determine, when the judgment result of the judging subunit is YES, that the operation needs to be performed by the in-memory database server, and when the judgment result is no, determine that the operation needs to be performed by a physical database Server execution.

8. The database server operation control apparatus according to claim 6, wherein, if the database server determined by the determining unit is an in-memory database server, the indicating unit comprises: obtaining a subunit, Obtaining a service type of the intelligent network service;

a second search subunit, configured to obtain, according to the type of service obtained by the obtained subunit, In the correspondence between the service type and the server identifier of each in-memory database server, searching for a server identifier of an in-memory database server that processes the intelligent network service;

And an indication subunit, configured to instruct the inode database server corresponding to the server identifier found by the second lookup subunit to perform the operation.

A service control point, comprising the database server operation control device according to any one of claims 6 to 8.

10. An in-memory database server, characterized in that it comprises:

a receiving unit, configured to receive an indication message sent by the database server operation control apparatus for instructing the in-memory database server to perform a corresponding operation;

And an operation execution unit, configured to perform the corresponding operation after the receiving unit receives the indication message.