JP2010011157A - Method of controlling and sorting access to database - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To reduce processing load by partitioning and improve processing speed concerning even processing different from processing of an object for partitioning in an environment accessing to the partitioned database. <P>SOLUTION: The method of controlling sorting of access to database includes: a step to determine a memory area in a database on the basis of features of registration information when receiving an information registration request from a client node and to register the memory area in the database together with a specific sorting control management information; a step to transmit the sorting control management information including a response to the information registration request to the client node; and a step to specify the memory area of the database on the basis of the sorting control management information accompanied with an information update request when receiving the information update request from the client node and to update the registration information. <P>COPYRIGHT: (C)2010,JPO&INPIT

Description

  The present invention relates to a database access control technique in a system that provides services to client nodes such as a presence service system.

  The presence service is a service for notifying other users (clients) in real time of the status of users (clients) on the network, for example, “online”, “away from seat”, “meeting”. Generally, a SIMPLE (SIP (Session Initiation Protocol) for Instant Messaging and Presence Leveraging Extensions) protocol is used. In a presence service system that provides such a presence service, presence information for each user is registered and updated in the database, and whether or not an expire time has been reached for the registration information in the database. Expire management is regularly conducted.

  FIG. 1 is a diagram showing an outline of expire management and presence update in a conventional presence service system. For example, assuming that the expire management process is started at the current time “10:15:12”, the expire time of each registration information on the database is compared with the current time, and the expired registration information is specified. Also, presence information is registered and updated asynchronously with the expire management process. The figure shows a state in which presence update is performed for the user “FFF@example.co.jp”, and the “user (SIP-URI)” portion on the database changes to “FFF@example.co.jp”. A match is identified and its “presence information” is updated.

  According to such a processing method, the entire search of the database occurs periodically due to the processing of the expire management, and a large processing time may be required when there are many registered users. Concerned. In addition, when access to the database is performed by a process separate from the expire management process, such as presence update processing, a conflict occurs in the database access with the expire management process. May cause a waiting time due to interruption, which may affect performance.

  On the other hand, there is a technique called partitioning as one of the functions of the database (see Patent Document 1). This is because the storage area on the database is divided, the storage area is made different according to the characteristics of the registered information, the search range is limited, and the processing speed is increased, and the database is used in a system using a plurality of processors. The processing is speeded up by executing the processes in parallel.

FIG. 2 is a diagram showing an outline of expire management and presence update in a conventional presence service system in which database partitioning is performed. Here, as a feature of the registration information, focusing on the “minute” portion of the expire time used for expire management, the minute value is used as split key information (distribution control management information), and each minute value is stored on the database. Information is registered in tables T1 to T6, which are different storage areas. Therefore, for example, if the expire management process is started at the current time “10:15:12”, the portion “15 minutes” of the current time “10:15:12” is used as the division key information, and the same division is performed. The table T1, which is a storage area on the database having the key information value, is specified, and the expire time and the current time of each registration information in the registration information are compared and checked, and the expired registration information is specified. Although the figure shows a case where there are two pieces of registration information in the table T1 corresponding to the divided key information “15 minutes”, the registration information is distributed to any one of 0 to 59 minutes, so even if the number of users is large. Registration information to be searched is reduced, and the concentration of periodic processing and competition with presence update processing are alleviated.
Japanese Unexamined Patent Publication No. 7-319923

  In the processing method shown in FIG. 2, although the concentration of the periodic processing by the expire management and the conflict with the presence update processing are alleviated, there is a problem in that the effect of partitioning cannot be exhibited for the presence update processing. was there.

  That is, in FIG. 2, the portion of the expire time used for expire management is used as the split key information, so that the expiration management process has the effect of partitioning. However, partition key information is required to effectively access the data stored in the database partitioned by partitioning, and knowing the partition key information in the presence update process separate from the expire management. As a result, all the divided storage areas must be accessed. FIG. 2 shows a state in which presence update is performed for the user “FFF@example.co.jp”, but since the division key information cannot be obtained from the user information, all the divisions on the database are performed. Access to the stored storage area, specify the one that matches "FFF@example.co.jp" from the "user (SIP-URI)" portion of the registration information, and update the "presence information" Must. Therefore, the effect of partitioning cannot be expected.

In addition, it is possible to create a new management table for managing partitioning partition key information on the database.
(1) Retrieval of split key information of data to be updated using management table (2) Update process based on acquired split key information is a two-step process, and a one-step process is added.

  Further, since the process (1) is performed every time presence update is requested by all users, there is a possibility that access is concentrated on the management table and waiting for access to the database.

  Although the expiration management and presence update processing in the presence service system has been described as an example, problems that may occur similarly in other service providing systems in an environment where different processing accesses the partitioned database. It is.

  In view of the conventional problems described above, in an environment in which access is made to a database that has been partitioned, processing that is different from the processing targeted for partitioning can be reduced and processing speed can be improved by partitioning. It aims to plan.

  In one embodiment of the database access distribution control method, when an information registration request is received from a client node, a storage area on the database is determined based on the characteristics of the registration information, and the distribution control management information for specifying the storage area Including the step of registering in the database, the step of transmitting the distribution control management information to the client node in a response to the information registration request, and the case of receiving an information update request from the client node, And a step of identifying the storage area of the database based on the distribution control management information accompanying the information update request and updating the registration information.

  Preferably, when the registration information is updated, a storage area on the database is determined based on characteristics of the updated registration information, and is registered in the database with new distribution control management information for specifying the storage area. And a step of transmitting the new distribution control management information to the client node in a response to the information update request.

  In the disclosed database access distribution control method, distribution control management information is transmitted to the client node in response to the information registration request from the client node, and the client node uses the distribution control management information to send an information update request. By performing the above, it is possible to reduce the processing load and improve the processing speed of the processing different from the processing subject to partitioning.

  Hereinafter, preferred embodiments of the present invention will be described.

<Configuration>
FIG. 3 is a diagram showing a configuration example of a presence service system according to an embodiment of the present invention.

  In FIG. 3, the presence service system includes a client node group 1, an application server node group 2, and a database node 3. The client node group 1 includes client nodes 11, 12,..., The application server node group 2 includes application server nodes 21, 22, 23,. Disk (shared disk) 32.

  In providing the presence service, communication according to the SIP / SIMPLE protocol is performed between the client nodes 11, 12,... Of the client node group 1 and the application server nodes 21, 22, 23,. The application server nodes 21, 22, 23,... Of the application server node group 2 access the disk 32 via the database management system 31 of the database node 3.

  FIG. 4 is a diagram showing another configuration example of the presence service system according to the embodiment of the present invention. In the application server node group 2, the load is distributed before the application server nodes 21, 22, 23,. A load balancer 20 is provided. In this case, the client nodes 11, 12,... Of the client node group 1 once access the load balancer 20 of the application server node group 2, and the application server nodes 21, 22, 23,.・ ・ Processing is distributed to.

  FIG. 5 is a diagram showing a configuration example of the application server nodes 21, 22, 23,... Of the application server node group 2 in FIGS. 5, the application server nodes 21, 22, 23,... Include a signal receiving unit 201 that receives a signal from the client node side, a received signal analyzing unit 202 that analyzes the received signal, and an analysis result of the received signal. In response, the database access unit 203 that accesses the database node 3, a response signal generation unit 204 that generates a response signal based on the access result to the database node 3, and a signal that transmits the generated response signal to the client node side A transmission unit 205.

<Operation>
FIG. 6 is a diagram showing a processing example of the above embodiment, and FIG. 7 is a sequence diagram showing processing between the client node 11 and the application server nodes 22 and 23 at that time.

  6 and 7, first, an information registration request signal “PUBLISH (Initial) request” is transmitted from the client node 11 to an arbitrary application server node 22 (step S1). FIG. 8A shows an example of an information registration request signal “PUBLISH (Initial) request” transmitted from the client node 11 to the application server node 22.

  In the application server node 22, the signal reception unit 201 receives the information registration request signal “PUBLISH (Initial) request” from the client node 11, and the received signal analysis unit 202 analyzes the received signal to confirm that it is an information registration request. recognize. Then, the received signal analysis unit 202 calculates the expire time, and stores the data from the database access unit 203 through the database management system 31 of the database node 3 in the storage area of the table T2 in the partitioned disk 32. (Step S2). That is, paying attention to the “minute” portion of the expire time used for expire management, the minute value is used as split key information (distribution control management information), and information is registered in the table T2 on the database corresponding to the minute value. To do.

  Next, the response signal generation unit 204 of the application server node 22 includes partitioning split key information for specifying the table T2 in the SIP-ETag header of the response signal to the information registration request, and as a response signal “PUBLISH (Initial) response”. The signal transmission unit 205 returns it to the client node 11 (step S3). The SIP-ETag header is header information defined by the SIP / SIMPLE protocol and can be arbitrarily set by the server side. FIG. 8B shows an example of a response signal “PUBLISH (Initial) response” returned from the application server node 22 to the client node 11.

  Next, when the client node 11 wants to change the presence state, when transmitting the information update request signal “PUBLISH (Modify) request”, the SIP when the response signal “PUBLISH (Initial) response” is received first. The information of the -ETag header is replaced with the SIP-If-Match header and transmitted to any application server node 23 (step S4). The SIP-If-Match header is header information for specifying presence information to be updated, which is defined by the SIP / SIMPLE protocol. FIG. 8C shows an example of an information update request signal “PUBLISH (Modify) request” transmitted from the client node 11 to the application server node 23.

  In the application server node 23, the signal receiving unit 201 receives the information update request signal “PUBLISH (Modify) request” from the client node 11, and the received signal analyzing unit 202 analyzes the received signal to indicate that it is an information update request. recognize. Then, the received signal analysis unit 202 analyzes the SIP-If-Match header, extracts the split key information, and corresponds in the corresponding table T2 from the database access unit 203 via the database management system 31 of the database node 3. The user's presence is changed (step S5). Since the corresponding table can be easily specified by the split key information and the update process is performed in the table, the process can be performed at high speed.

  Next, the received signal analysis unit 202 of the application server node 23 recalculates the expire time, and stores the table T3 in the partitioned disk 32 from the database access unit 203 via the database management system 31 of the database node 3. Data is stored in the area (step S6).

  Next, the response signal generation unit 204 of the application server node 23 includes partitioning split key information for specifying the table T3 in the SIP-ETag header of the response signal for the information update request, and as a response signal “PUBLISH (Modify) response”. It returns to the client node 11 (step S7). FIG. 8D shows an example of a response signal “PUBLISH (Modify) response” returned from the application server node 23 to the client node 11.

  In parallel with the above processing (steps S1 to S7), processing for determining whether the expire time has been reached by the expire management periodically operates. For example, the processing is performed on the table corresponding to the current time. However, since the number of data to be searched is small, waiting time due to competition and the like is also shortened.

<Summary>
As described above, in the present embodiment, with respect to access to the database used in the presence service system, the split key information used when partitioning the database is the SIP-ETag header, SIP-If-, which is defined by the SIP / SIMPLE protocol. By storing it in the Match header, it is possible to perform processing such as reference and update of the partitioned data more quickly.

  In other words, when another process such as presence update is performed on a database that is effectively partitioned for a specific process, an event that causes a delay such that a full table search is required. It can be avoided. As a result, assuming that the user is uniformly registered in each partition, the processing speed can be improved by reducing the number of search objects by the number of partitions.

  In addition, the number of SQL statement executions can be reduced because the processing for obtaining the partition key information from the management table can be omitted even when compared with a method for newly creating a management table for managing partitioning partition key information on the database. Reduction of processing time can be expected by reducing access waiting time due to reduction of database access and concentration of database access.

The present invention has been described above by the preferred embodiments of the present invention. While the invention has been described with reference to specific embodiments, various modifications and changes may be made to the embodiments without departing from the broad spirit and scope of the invention as defined in the claims. Obviously you can. In other words, the present invention should not be construed as being limited by the details of the specific examples and the accompanying drawings.
(Appendix 1)
When receiving an information registration request from a client node, determining a storage area on the database based on the characteristics of the registration information, and registering in the database with distribution control management information identifying the storage area;
Including in a response to the information registration request, transmitting the distribution control management information to the client node;
A step of specifying a storage area of the database based on distribution control management information accompanying the information update request and updating registration information when an information update request is received from the client node. Database access distribution control method.
(Appendix 2)
When updating the registration information, determining a storage area on the database based on the characteristics of the updated registration information, and registering in the database with new distribution control management information for specifying the storage area;
The database access distribution control method according to claim 1, further comprising a step of transmitting the new distribution control management information to the client node in a response to the information update request.
(Appendix 3)
3. The database access distribution control method according to claim 1, wherein the distribution control management information in response to the information registration request is transmitted by including in header information that can be arbitrarily set by the server side.
(Appendix 4)
Means for determining a storage area on the database based on the characteristics of the registration information when receiving an information registration request from the client node, and registering it in the database with distribution control management information for specifying the storage area;
Means for transmitting the distribution control management information to the client node in a response to the information registration request;
When receiving an information update request from the client node, the storage node of the database is specified based on the distribution control management information accompanying the information update request, and the registration information is updated. A service providing server device.
(Appendix 5)
Upon updating the registration information, determining a storage area on the database based on the characteristics of the updated registration information, and registering in the database with new distribution control management information for specifying the storage area;
The service providing server device according to appendix 4, further comprising means for transmitting the new distribution control management information to the client node in a response to the information update request.
(Appendix 6)
6. The service providing server device according to any one of appendix 4 or 5, wherein the distribution control management information in response to the information registration request is transmitted by being included in header information that can be arbitrarily set by the server side.
(Appendix 7)
A computer constituting the service providing server device;
Means for determining a storage area on the database based on the characteristics of the registration information when receiving an information registration request from a client node, and registering it in the database with distribution control management information for identifying the storage area;
Means for transmitting the distribution control management information to the client node in a response to the information registration request;
Database access distribution control that, when an information update request is received from the client node, identifies a storage area of the database based on distribution control management information accompanying the information update request and functions as a means for updating registered information program.
(Appendix 8)
The computer,
Means for determining a storage area on the database based on the characteristics of the updated registration information upon updating the registration information, and registering the database with new distribution control management information for specifying the storage area;
The database access distribution control program according to appendix 7, which is further included in a response to the information update request and further functions as means for transmitting the new distribution control management information to the client node.
(Appendix 9)
The database access distribution control program according to any one of appendices 7 and 8, wherein the distribution control management information in response to the information registration request is included in header information that can be arbitrarily set by the server side and transmitted.

It is a figure which shows the outline | summary of the expire management and presence update in the conventional presence service system. It is a figure which shows the outline | summary of the expire management and presence update in the conventional presence service system which performed the partitioning of the database. It is a figure (the 1) which shows the structural example of the presence service system concerning one Embodiment of this invention. It is FIG. (2) which shows the structural example of the presence service system concerning one Embodiment of this invention. It is a figure which shows the structural example of an application server node. It is a figure which shows the process example of embodiment. It is a sequence diagram which shows the process example of embodiment. It is a figure which shows the example of the signal transmitted / received between a client node and an application server node.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Client node group 11, 12 Client node 2 Application server node group 20 Load balancer 21-23 Application server node 201 Signal receiving part 202 Received signal analysis part 203 Database access part 204 Response signal generation part 205 Signal transmission part 3 Database node 31 Database Management system 32 disks T1-T6 table

Claims (6)

When receiving an information registration request from a client node, determining a storage area on the database based on the characteristics of the registration information, and registering in the database with distribution control management information identifying the storage area;
Including in a response to the information registration request, transmitting the distribution control management information to the client node;
A step of specifying a storage area of the database based on distribution control management information accompanying the information update request and updating registration information when an information update request is received from the client node. Database access distribution control method. When updating the registration information, determining a storage area on the database based on the characteristics of the updated registration information, and registering in the database with new distribution control management information for specifying the storage area;
The database access distribution control method according to claim 1, further comprising a step of transmitting the new distribution control management information to the client node in a response to the information update request. Means for determining a storage area on the database based on the characteristics of the registration information when receiving an information registration request from the client node, and registering it in the database with distribution control management information for specifying the storage area;
Means for transmitting the distribution control management information to the client node in a response to the information registration request;
When receiving an information update request from the client node, the storage node of the database is specified based on the distribution control management information accompanying the information update request, and the registration information is updated. A service providing server device. Upon updating the registration information, determining a storage area on the database based on the characteristics of the updated registration information, and registering in the database with new distribution control management information for specifying the storage area;
4. The service providing server apparatus according to claim 3, further comprising means for transmitting the new distribution control management information to the client node in a response to the information update request. A computer constituting the service providing server device;
Means for determining a storage area on the database based on the characteristics of the registration information when receiving an information registration request from a client node, and registering it in the database with distribution control management information for identifying the storage area;
Means for transmitting the distribution control management information to the client node in a response to the information registration request;
Database access distribution control that, when an information update request is received from the client node, identifies a storage area of the database based on distribution control management information accompanying the information update request and functions as a means for updating registered information program. The computer,
Means for determining a storage area on the database based on the characteristics of the updated registration information upon updating the registration information, and registering the database with new distribution control management information for specifying the storage area;
6. The database access distribution control program according to claim 5, further comprising a function for transmitting the new distribution control management information to the client node in a response to the information update request.

Images