JP5973237B2 - Database management apparatus and database management method - Google Patents

Description

  The present invention relates to a database management apparatus and a database management method for controlling switching of a database apparatus that stores master data among a plurality of database apparatuses constituting a distributed database.

  Conventionally, a distributed database that can handle a plurality of database devices connected to a network as if they were a single database device has been used. Generally, in an existing distributed database, a data storage location is specified by a hash function or a management node. At this time, the distributed database distributes and stores data in a plurality of database devices, and manages master data (write access data entity) and its copy. For example, the distributed database system described in Patent Document 1 includes a master database that is a replication source of all databases and a distributed database that is a replica of the master database.

JP-A-6-290098

  Here, generally, a database device (master data storage device) that stores master data in a distributed database does not move unless an additional device or a failure occurs. Here, for example, in a mobile communication system, when managing mobile communication terminal information for data writing associated with a mobile communication terminal in a distributed database, an input / output device that inputs and outputs data to the master data storage device, Even if the mobile communication terminal is changed physically and geographically as the mobile communication terminal moves, the master data storage device is not changed. Therefore, it takes a long time to input and output data between the input / output device and the distributed database, and as a result, there is a risk that the performance of the entire mobile communication system is lowered.

  The present invention has been made in view of the above problems, and provides a database management apparatus and a database management method capable of improving performance by reducing the delay of data input / output in a distributed database in a mobile communication system. The purpose is to provide.

In order to achieve the above object, a database management apparatus according to the present invention is a distributed database including a plurality of call processing apparatuses that perform call processing related to a mobile communication terminal and a plurality of call processing management database apparatuses. State information indicating the state of call processing associated with the mobile communication terminal, which is accessed for data writing when the call processing device performs call processing related to the mobile communication terminal, and relates to the area where the mobile communication terminal is located the state information including the information, a database management system in a mobile communication system comprising a distributed database that stores at one of the call processing management database unit, the one of plurality of call processing management database device, the call processing unit and a call delay information on the data input and output between the processing management database device identification information and the call processing of the call processor A delay information storage means for storing in association with the identification information of the management database apparatus, and identification information of the call processor, an acquisition unit that the call processing unit acquires the identification information of the mobile communication terminals performing call processing When the identification information of the call processing device and the identification information of the mobile communication terminal are acquired by the acquisition means, based on the delay information associated with the acquired identification information of the call processing device stored by the delay information storage means Including a means for identifying a call processing management database device that stores state information of the mobile communication terminal indicated by the acquired identification information of the mobile communication terminal, and a case where the area of the mobile communication terminal is changed, If the change or acquisition state information occurs, the call processing management database unit specified by the specifying means, the identification of the mobile communication terminal obtained by the obtaining means And a control means for switching to store the state information of the mobile communication terminal indicated broadcast.

In the database management apparatus according to the present invention, the identification information and the call processor of the call processing apparatus and identification information of the mobile communication terminals performing call processing it is acquired by the acquisition means, the identification information of the call processor based on the delay information with associated with identification information of the mobile communication terminal is the call processing management database device specific for storing state information of the mobile communication terminal shown, the state information is stored in the call processing management database unit To switch to the master data storage device. As a result, for example, even if the call processing device is physically or geographically changed, the call processing device can perform data input / output with a master data storage device having a small data input / output delay, that is, a fast data input / output. it can. That is, the performance can be improved by reducing the data input / output delay in the distributed database in the mobile communication system.

Specifying means based on the delay information, the call processing management database delay in data input and output is minimized between the call processor and the call processing management database device indicated by the identification information acquired call processor by acquiring means The device may be specified. According to this configuration, the call processing device can perform data input / output with the master data storage device with the minimum data input / output delay. That is, it is possible to shorten the data input / output delay in the distributed database in the mobile communication system, thereby improving the performance of the mobile communication system.

The delay information may be a turnaround time between the call processing device and the call processing management database device. According to this configuration, the call processing device can perform data input / output with the master data storage device switched based on the data input / output turnaround time with the call processing management database device. Thus, for example, also call processor is physically and geographically changed, the call processing unit is smaller turnaround time data input and output, i.e. the response is faster master data storage device and the data input and output of data input It can be performed. That is, it is possible to shorten the data input / output delay in the distributed database in the mobile communication system, thereby improving the performance of the mobile communication system.
The mobile communication system may have a redundant configuration by server virtualization, and the call processing device may be implemented as a virtual server.
The specifying means may specify the call processing management database device based further on the load status of the call processing device or the call processing management database device.
The call processing management database device may separately manage records of items that are both read and written and items that are read only.

  By the way, the present invention can be described as the invention of the database management apparatus as described above, and can also be described as the invention of the database management method as follows. This is substantially the same invention only in different categories, and has the same operations and effects.

That is, the database management method according to the present invention includes a plurality of call processor for performing call processing according to the mobile communication terminal, a distributed database consisting of a plurality of call processing management database device, call processor mobile communication State information indicating the state of call processing associated with the mobile communication terminal, which is accessed for data writing when performing call processing related to the terminal, and including information related to the area where the mobile communication terminal is located , a database management apparatus in a mobile communication system including a distributed database that stores at one of the call processing management database unit, the one of plurality of call processing management database unit, between the call processor and the call processing management database unit the delay information on the data input and output, the identification information and the call processing management database unit of the call processor A database management method according to the database management device comprising a delay information storage means for storing in association with the identification information, including when the existing area of the mobile communication terminal becomes a change, the change or acquisition state information is generated If the identification information of the call processor, the call processor is an acquisition step of acquiring identification information of the mobile communication terminals performing call processing, call processing apparatus in acquiring step identification information of the mobile communication terminal When the identification information is acquired, the mobile communication indicated by the acquired identification information of the mobile communication terminal based on the delay information associated with the acquired identification information of the call processing device stored by the delay information storage means specific steps and, the call processing management database specified in the specifying step of specifying a call processing management database unit for storing state information of the terminal A scan device, and a control step of switching to store state information of the mobile communication terminal indicated by the identification information acquired mobile communication terminal by the acquisition step.

  ADVANTAGE OF THE INVENTION According to this invention, performance can be improved by shortening the delay of data input / output in the distributed database in a mobile communication system.

It is a figure which shows the outline | summary of the process of the distributed database in the mobile communication system which concerns on embodiment of this invention. It is a figure which shows the mobile communication system which concerns on embodiment of this invention. It is a figure which shows the data hold | maintained at the database for call processing management. It is a figure which shows the outline | summary of a process of the mobile communication system which concerns on embodiment of this invention. It is a figure which shows the function structure of the apparatus which comprises the mobile communication system which concerns on embodiment of this invention. It is a figure which shows the table data hold | maintained at a delay information storage part. It is a figure which shows the hardware constitutions of the apparatus which comprises the mobile communication system which concerns on embodiment of this invention. It is a sequence diagram which shows the process (database management method) performed with the mobile communication system which concerns on embodiment of this invention.

  Hereinafter, embodiments of a database management apparatus and a database management method according to the present invention will be described in detail with reference to the drawings. In the description of the drawings, the same elements are denoted by the same reference numerals, and redundant description is omitted.

  FIG. 1 is a diagram showing an overview of distributed database processing in the mobile communication system according to the present embodiment. An outline of distributed database processing applicable to a general distributed database system, which is not limited to application in a mobile communication system, will be described with reference to FIG. The distributed database 2 shown in FIG. 1 is a general distributed database, and includes a plurality of database devices 20a, 20b, and 20c connected to a network (hereinafter collectively referred to as the database device 20). The The distributed database 2 can handle a plurality of database devices 20 as if they are a single virtual database device. The database device 20 is a general database device, and is physically and geographically distributed as shown in FIG. In the distributed database 2, data is distributed to the plurality of database devices 20 with redundancy. Here, in the distributed database 2, master data that is a write access data entity is stored in one of the database devices 20 included in the distributed database 2, and a copy of the master data is stored in the remaining database devices. Is done. The database device that stores the master data is called a master data storage device. When writing data to the distributed database 2, it is necessary to write the data to the master data storage device.

  In FIG. 1, input / output devices 30 a and 30 b (hereinafter collectively referred to as “input / output device 30”) are general server devices that input / output write data to / from the distributed database 2. As shown in FIG. 1, the input / output devices 30 are physically and geographically distributed. Here, among the input / output devices 30, the input / output device 30 that is currently inputting / outputting write data is referred to as a main input / output device.

  In FIG. 1A, the database device 20a is set as a master data storage device, and the input / output device 30a is the main input / output device. Here, as shown in FIG. 1B, when the main input / output device is changed from the input / output device 30a to the input / output device 30b, the master data storage device is not changed in the prior art, so the input / output device 30b is the master. It is necessary to input / output write data to / from the database device 20a which is a data storage device. In this case, as shown in FIG. 1, the input / output device 30b and the database device 20a are geographically separated from each other, and a data input / output delay occurs correspondingly, and the performance of the entire system of the distributed database 2 decreases.

  In the distributed database 2 according to the present embodiment, when the main input / output device is changed from the input / output device 30a to the input / output device 30b as shown in FIG. The master data storage device is changed based on the delay information related to the data input / output. For example, in the distributed database 2 according to the present embodiment, as shown in FIG. 1B, the master data storage device is switched to the database device 20b with less delay in data input / output with the input / output device 30b. Thereby, in the distributed database 2 according to the present embodiment, the data input / output delay can be shortened, thereby improving the performance of the distributed database 2. The above is the description of the outline of the processing in the distributed database 2 applicable to the general distributed database system, which is the distributed database in the mobile communication system according to the present embodiment and is not limited to the application in the mobile communication system. is there.

  In the following description of the present embodiment, an embodiment in which the database management apparatus and the database management method according to the present invention are applied to a mobile communication system will be described.

  FIG. 2 shows a configuration of the mobile communication system 1 according to the present embodiment. The mobile communication system 1 is a system that provides a mobile communication terminal (mobile device) 60 with a mobile communication function. The mobile communication terminal 60 is a device used by a user to connect to a mobile communication system (mobile communication network) by wireless communication and perform mobile communication. Specifically, the mobile communication terminal 60 corresponds to a mobile phone or the like. For example, the mobile communication terminal 60 establishes a call connection with the opposite node 70 via the mobile communication system 1 and performs communication. The opposite node 70 is, for example, another mobile communication terminal, a server device that provides various services to the mobile communication terminal 60, or a device for connecting to another communication network (for example, a GGSN (Gateway GPRS Support Node)). It corresponds to. The mobile communication terminal 60 can perform mobile communication when the user of the mobile communication terminal 60 makes a contract with a communication carrier of the mobile communication system 1. The mobile communication terminal 60 may be the same as a conventional mobile communication terminal.

  As shown in FIG. 2, the mobile communication system 1 includes a database management device 10 (database management device), a plurality of call processing management databases 20 (database devices), and a plurality of call processing servers 30 (control devices). The open flow network 4 and the network manager 50 are included. These configurations 10, 20, 30, and 4 constitute a core network of the mobile communication system 1 (mobile communication network).

  The database management device 10 is a database management that controls switching of a master data storage device that is a call processing management database 20 for storing master data among a plurality of call processing management databases 20 constituting a distributed database 2 described later. Device. More specifically, the database management device 10 controls switching of the master data storage device linked with the location information of the mobile communication terminal 60. The database management apparatus 10 is configured by a general server as hardware. Details of the database management apparatus 10 will be described later.

  The call processing management database 20 is a database that holds data necessary for call processing. The call processing management database 20 holds this data for each mobile communication terminal 60 in association with information for specifying the mobile communication terminal 60, for example. As data necessary for call processing, specifically, state information indicating the state of call processing and a subscriber profile related to the mobile communication terminal 60 are held. The state information includes information on the area where the mobile communication terminal 60 is located and whether the mobile communication terminal 60 is communicating or is on standby. This information is read and updated (written) by the call processing server 30 as described later. In the present embodiment, among the data necessary for the call processing described above, the write access data entity (master data) is referred to as mobile communication terminal information.

  The subscriber profile data includes information such as the telephone number of the mobile communication terminal 60, authentication information, and contract speed. These pieces of information are newly stored (generated) as a subscriber profile in the call processing management database 20 when the user of the mobile communication terminal 60 makes a contract with a communication carrier of the mobile communication system 1. These pieces of information are read by the call processing server 30 but are not updated (written) by the call processing server 30. The data stored for each mobile communication terminal 60 includes items that both read and write occur and items that only read. By managing the records of these items separately in the call processing management database 20, it is possible to devise so as to prevent the Read from being delayed while waiting for the write synchronization.

  The call processing management database 20 is connected to each of the plurality of call processing servers 30, and the call processing server 30 refers to, registers, and updates data held in the call processing management database 20. Although the call processing management database 20 can have any configuration as a database, in consideration of holding data necessary for call processing, in this embodiment, as shown in FIG. The distributed database 2 is composed of the management database 20 and is configured so as not to have a single point of failure (SPOF). In the distributed database 2, data necessary for the above-described call processing is distributed and stored with redundancy in the plurality of call processing management databases 20, and mobile communication terminal information is stored in the plurality of call processing management databases 20. One of them is stored in the call processing management database 20.

  Here, the call processing is processing related to call connection between the mobile communication terminal 60 and the opposite node 70 via the mobile communication system 1. For example, a process of establishing a call connection (also called a communication session connection) between the mobile communication terminal 60 and the opposite node 70 or a process of disconnecting. Further, the processing for being in the mobile communication system 1, that is, the location registration processing may be included in the call processing in this embodiment.

  The call processing server 30 is a general server as hardware, and is a call processing node that performs call processing in the mobile communication system 1. As shown in FIG. 2, the call processing server 30 is connected to the mobile communication terminal 60 and the opposite node 70 via the OpenFlow network 4, and performs call processing in response to a request from the mobile communication terminal 60. As shown in FIG. 3, the call processing server 30 is realized by functions of a HW (hardware) layer, an OS (operating system) layer, and an APL (application) layer. Further, the call processing server 30 may be implemented as a virtual server in order to facilitate processing at the time of failure or scale-out.

  As shown in FIG. 3, in the APL layer, call information, temporary information, and a program are stored on the memory. The call information is data necessary for call processing, and is state information (for example, information such as during communication and standby) and a subscriber profile that holds call state transition. In this embodiment, call information is stored and managed in the distributed database 2. Call information is retained only during call processing, for example, by acquiring information from the call processing management database 20. Note that the call information may be held in the call processing server 30 as a cache even after the call processing for efficient processing, but the call processing server 30 is not responsible for the call information. In this way, the call processing server 30 leaves the call information (stored in the distributed database 2), so the call processing server 30 can be replaced at any time. Temporary information is temporary information (information in the middle of a sequence such as location registration and transmission) used in the middle of call processing (signal sequence). For example, temporary information used in a transitional state that changes from standby to communication. The program is an execution code itself (execution binary information) for realizing the function of the call processing server 30.

  The mobile communication system 1 includes a plurality of call processing servers 30. As shown in FIG. 2, in consideration of a case where one of the call processing servers 30 breaks down due to a disaster, a plurality of bases (locations such as data centers) 3 are provided, and each base 3 has one or more calls. It is desirable to provide the processing server 30. The call processing server 30 is preferably realized as a virtualized virtual server using a virtual machine technology in the server device. In this embodiment, the call processing node is described as a virtual machine, but may be realized as a call processing server that is not a virtual machine by individual server devices. In the conventional mobile communication system, the call processing server 30 corresponds to a node such as SGSN (Serving GPRS Support Node), CSCF (Call Session Control Function), AS (Application Server), MME (Mobility Management Entity), or the like.

  The OpenFlow network 4 is a flow control network that is connected to the call processing server 30, the mobile communication terminal 60, and the opposite node 70, and constitutes a communication path between these devices. Normally, the OpenFlow network 4 and the mobile communication terminal 60 are connected via a base station (BTS) or a radio network controller (RNC). The OpenFlow network 4 includes a plurality of nodes that are OpenFlow switches connected to each other. The node corresponds to a device normally used as an open flow switch of an open flow network. As will be described later, the OpenFlow network 4 transmits and receives information under the control of the OpenFlow controller of the network manager 50. Specifically, each node of the OpenFlow network 4 receives from the network manager 50 a flow entry indicating to which node the information received by itself is transmitted, and transmits / receives information according to the flow entry. . In this description, an open flow network will be described. However, a network called SDN (Software defined network) that performs similar flow control and flow transfer processing according to the control may be used.

  The network manager 50 is a control node that controls transmission / reception of information in the OpenFlow network 4. The control is performed by, for example, an OpenFlow controller that is provided in the network manager 50 and performs load distribution control. The network manager 50 is connected to each of the call processing servers 30 and can send and receive information. For example, the network manager 50 performs assignment of the call processing server 30 and path control of the OpenFlow network 4 corresponding thereto. In addition, the network manager 50 performs failure monitoring, virtualization server provisioning, and the like.

  As described above, the mobile communication system 1 is a distributed database 2 including a plurality of call processing servers 30 that perform communication processing related to the mobile communication terminal 60 and a plurality of call processing management databases 20. The mobile communication terminal information associated with the mobile communication terminal 60 that is accessed for data writing when the server 30 performs communication processing related to the mobile communication terminal 60 is stored in one call processing database 20. And a distributed database 2 stored in the process management database 20.

  Next, based on the configuration shown in FIG. 2, an overall processing flow in the mobile communication system 1 will be briefly described. A signal from the mobile communication terminal 60 that is an end user reaches the call processing server 30 that accommodates the user through the OpenFlow network 4. The call processing server 30 writes the state information in the distributed database 2 when a change in state information such as a service area state, standby or communication occurs during the call processing. Here, when the call processing server 30 is stopped due to a failure or maintenance work, a signal from the mobile communication terminal 60 or the opposite node 70 is transmitted to another call processing server 30 by the OpenFlow network 4. If there is no state information of the corresponding signal, the state information is acquired from the distributed database 2 and the call processing is continued. The above is the overall processing flow.

  Next, the role of the database management apparatus 10 will be briefly described based on the configuration shown in FIG. FIG. 4 is a diagram showing the configuration of the mobile communication system 1 as in FIG. As an initial state, the mobile communication terminal 60 is located in the area 6a. In this state, the signal from the mobile communication terminal 60 reaches the call processing server 30a assigned by the OpenFlow network 4 via the OpenFlow network 4. When the state information of the mobile communication terminal 60 is changed, the call processing server 30a is set in the master data storage device by the database management device 10 (the master data M is stored). State information is written to 20a.

  As the next state, it is assumed that the mobile communication terminal 60 has moved geographically and is located in the area 6b. In this state, the signal from the mobile communication terminal 60 is sent via the OpenFlow network 4 to the call processing server 30b assigned by the OpenFlow network 4 (the call processing server 30 is transferred from the call processing server 30a by the OpenFlow network 4). Change to the call processing server 30b). When the state information of the mobile communication terminal 60 is changed, the call processing server 30b first inquires the database management device 10 about the location information of the master data storage device. Here, the database management device 10 uses the geographical information between each call processing management database 20 and the call processing server 30 which is the main physical device for inputting / outputting state information, so that the data input / output time is the longest. The shortened call processing management database 20 is switched (changed) to the master data storage device. Here, the database management device 10 switches the call processing management database 20b to the master data storage device (moves the master data M from the call processing management database 20a to the call processing management database 20b). The above is the description of the role of the database management apparatus 10.

  Subsequently, functions according to the present embodiment of the database management apparatus 10 and the call processing server 30 will be described in more detail. FIG. 5 is a functional block diagram showing configurations of the database management apparatus 10 and the call processing server 30 according to the present embodiment.

  First, the function of the database management apparatus 10 will be described. As shown in FIG. 5, the database management apparatus 10 includes a delay information storage unit 11 (delay information storage unit), an acquisition request reception unit 12 (acquisition unit), a specification unit 13 (specification unit), a control unit 14 (control unit), And a position information transmission unit 15.

  The delay information storage unit 11 stores delay information related to data input / output between the call processing server 30 that inputs / outputs data to / from the distributed database 2 and the call processing management database 20. Specifically, the delay information is a turnaround time of data input / output processing between the call processing server 30 and the call processing management database 20.

  FIG. 6 is a table showing an example of delay information stored in the delay information storage unit 11. As shown in FIG. 6, the delay information storage unit 11 includes, as delay information, a call processing server ID that is identification information of the call processing server 30, and a call processing management database ID that is identification information of the call processing management database 20. The input / output delay (milliseconds) that is the turnaround time of data input / output between the call processing server 30 and the call processing management database 20 is stored in advance. For example, in FIG. 6, the data input / output turnaround between the call processing server 30 whose call processing server ID is “1” and the call processing management database 20 whose call processing management database ID is “DB3”. The time is “20 milliseconds”. The delay information storage unit 11 updates the delay information to be stored as needed in accordance with the change timing such as addition or deletion of the call processing server 30 and the addition of a database or a network. The delay information storage unit 11 measures and stores in advance delay information related to data input / output between all call processing servers 30 included in the mobile communication system 1 and all call processing management databases 20. Alternatively, some of them may be measured and stored.

  The acquisition request receiving unit 12 receives an acquisition request for the location information of the master data storage device from the call processing server 30, and at the same time, the mobile communication terminal 60 with which the call processing server 30 performs communication processing with the identification information of the call processing server 30. The identification information is received (acquired). Here, the acquisition request receiving unit 12 may acquire the identification information of the call processing server 30 and the identification information of the mobile communication terminal 60 from the call processing server 30 or may be acquired from different devices. Then, the identification information stored in the database management apparatus 10 itself may be acquired. The acquisition request receiving unit 12 outputs the acquired identification information of the call processing server 30 and the identification information of the mobile communication terminal 60 to the specifying unit 13.

  When the acquisition request receiving unit 12 acquires the identification information of the call processing server 30 and the identification information of the mobile communication terminal 60, the specifying unit 13 acquires the acquired call processing server 30 stored by the delay information storage unit 11. The call processing management database 20 that stores the mobile communication terminal information of the mobile communication terminal 60 indicated by the acquired identification information of the mobile communication terminal 60 is specified based on the delay information associated with the identification information. Specifically, the specifying unit 13 minimizes the data input / output delay between the call processing server 30 and the call processing management database 20 indicated by the identification information of the call processing server 30 acquired by the acquisition request receiving unit 12. The call processing management database 20 is specified.

  Here, details of the specifying method by the specifying unit 13 will be described based on the delay information shown in FIG. When the call processing server ID input from the acquisition request receiving unit 12 is “1”, the specifying unit 13 determines the input / output delay of the row where the call processing server ID is “1” in the delay information illustrated in FIG. The call processing management database ID “DB1” corresponding to the minimum value “5” is extracted. That is, the call processing management database 20 whose call processing management database ID is “DB1” is specified. Then, the specifying unit 13 outputs the extracted call processing management database ID “DB1” to the control unit 14.

  The control unit 14 stores the mobile communication terminal information of the mobile communication terminal 60 indicated by the identification information of the mobile communication terminal 60 acquired by the acquisition request receiving unit 12 in the call processing management database 20 specified by the specifying unit 13. Switch as follows. That is, the control unit 14 switches the call processing management database 20 specified by the specifying unit 13 to the master data storage device. Here, the control unit 14 stores a call processing management database ID (pre-switching ID) of the call processing management database 20 which is a master data storage device before switching. Specifically, when the call processing management database ID (ID after switching) of the call processing management database 20 specified by the specifying unit 13 is input from the specifying unit 13, the control unit 14 indicates the ID before switching. The master data stored in the call processing management database 20 (mobile communication terminal information of the mobile communication terminal 60) is transferred to the call processing management database 20 indicated by the post-switching ID (master data is set). Thereafter, the specifying unit 13 cancels the master data setting for the call processing management database 20 indicated by the pre-switching ID. The control unit 14 does not perform the switching process when the call processing management database 20 specified by the specifying unit 13 is already a master data storage device. Finally, the specifying unit 13 outputs the post-switch ID to the position information transmitting unit 15.

  Note that when the master data storage device is switched, the control unit 14 may update a flag related to permission to read and write stored data in the master data storage device before switching and the master data storage device after switching. For example, when setting the master data, the control unit 14 sets the data write flag of the call processing management database 20 indicated by the post-switch ID to “permitted”. Further, when canceling the master data setting, the control unit 14 sets the data write flag of the call processing management database 20 indicated by the pre-switching ID to be prohibited.

  The location information transmission unit 15 transmits the location information of the master data storage device switched by the control unit 14 to the call processing server 30 that is the transmission source of the acquisition request received by the acquisition request reception unit 12. Specifically, the location information transmission unit 15 transmits the post-switch ID input from the specifying unit 13 or the location information (IP address or the like) of the call processing management database 20 indicated by the post-switch ID to the call processing server 30. To do. This completes the description of the functions of the database management apparatus 10.

  Next, functions of the call processing server 30 will be described. As shown in FIG. 5, the call processing server 30 includes an acquisition request transmission unit 31, a position information reception unit 32, and an input / output unit 33.

  The acquisition request transmission unit 31 transmits an acquisition request for position information of the master data storage device to the database management device 10. When the acquisition request transmission unit 31 transmits the acquisition request, the identification information of the call processing server 30 (self) and the identification information of the mobile communication terminal 60 in which the call processing server 30 (self) performs communication processing are simultaneously transmitted. You may send it.

  The location information receiving unit 32 receives location information of the master data storage device from the database management device 10. Specifically, the location information receiving unit 32 receives location information of the call processing management database 20 indicated by the above-described post-switch ID or post-switch ID.

  The input / output unit 33 controls data input / output with respect to the distributed database 2. Specifically, the input / output unit 33 inputs / outputs data to / from the master data storage device indicated by the position information received by the position information receiving unit 32. For example, when the input / output unit 33 writes the mobile communication terminal information associated with the mobile communication terminal 60 in the call processing management database 20, first, the acquisition request transmission unit 31 is requested to acquire the location information of the master data storage device. And the input / output unit 33 writes the mobile communication terminal information to the call processing management database 20 based on the location information of the call processing management database 20 received by the location information receiving unit 32 as a response. I do. This completes the description of the functions of the call processing server 30.

  Subsequently, FIG. 7 shows a hardware configuration of a server device constituting the database management device 10, the call processing management database 20, the call processing server 30, and the network manager 50 according to the present embodiment. As shown in FIG. 7, the server device includes a CPU 101, a RAM (Random Access Memory) 102 and a ROM (Read Only Memory) 103, which are main storage devices, a communication module 104 for performing communication, and an auxiliary storage device such as a hard disk. The computer is configured to include a computer having hardware such as 105. The functions of these database management devices 10, the call processing management database 20, the call processing server 30, and the network manager 50 are performed by operating these components by a program or the like. The above is the configuration of the mobile communication system 1.

  Subsequently, a database management method, which is a process executed in the mobile communication system 1 according to the present embodiment, will be described using the sequence diagram of FIG. This process is the same as the process described with reference to FIG.

  First, the mobile communication terminal 60 is accommodated in the call processing server 30a in the area 6a. When acquisition or change of mobile communication terminal information (state information) occurs in the call processing server 30a, the acquisition request transmission unit 31 of the call processing server 30a inquires the database management device 10 about the location information of the master data storage device. Is performed (S1). Next, the inquiry is received by the acquisition request receiving unit 12 of the database management apparatus 10, and the identification information of the call processing server 30a and the identification information of the mobile communication terminal 60 in which the call processing server 30a is performing communication processing are acquired. Then (acquisition step), the call processing management which is the call processing management database 20 having the smallest input / output delay in the call processing server 30a by the specifying unit 13 based on the delay information stored in the delay information storage unit 11. The database 20a for use is identified (S2, identification step).

  Next, the call processing management database 20a specified in S2 is set by the control unit 14 as a master data storage device (S3, control step). Next, the location information transmission unit 15 makes a response to the location information in the call processing management database 20a to the call processing server 30a (S4). Next, the location information receiving unit 32 of the call processing server 30a receives the location information of the call processing management database 20a. Then, the call processing server 30a can access the designated call processing management database 20a when user data is accessed in the call processing, and the call processing server 30a acquires or changes the mobile communication terminal information of the mobile communication terminal 60. (S5).

  Here, it is assumed that as the user moves, the mobile communication terminal 60 moves from the area 6a to the area 6b, and the accommodation node is changed to the call processing server 30b (S6). When acquisition or change of mobile communication terminal information occurs in the call processing server 30b, the acquisition request transmission unit 31 of the call processing server 30b inquires the database management device 10 about the location information of the master data storage device ( S7). Next, the inquiry is received by the acquisition request receiving unit 12 of the database management apparatus 10, and the identification information of the call processing server 30b and the identification information of the mobile communication terminal 60 with which the call processing server 30b is performing communication processing are acquired. Then (acquisition step), the call processing management which is the call processing management database 20 having the smallest input / output delay in the call processing server 30b based on the delay information stored in the delay information storage unit 11 by the specifying unit 13. The database for use 20b is specified (S8, specifying step).

  Next, the call processing management database 20b specified in S8 is set by the control unit 14 as a master data storage device (S9, control step). Subsequently, the setting of the master data storage device is canceled by the control unit 14 with respect to the call processing management database 20a which is the previous master data storage device (S10, control step). Next, the location information transmission unit 15 makes a response to the location information in the call processing management database 20b to the call processing server 30b (S11). Next, the location information receiving unit 32 of the call processing server 30b receives the location information of the call processing management database 20b. When the user data is accessed in the call processing, the call processing server 30b can access the designated call processing management database 20b, and the call processing server 30b acquires or changes the mobile communication terminal information of the mobile communication terminal 60. (S12).

  If the call processing management database 20 specified in S8 is the call processing management database 20a, that is, the call processing management database 20 specified by the specifying unit 13 is already a master data storage device. In this case, S9 and S10 are skipped (the switching process is not performed). Following S8, at S11, the location information transmission unit 15 responds to the call processing server 30b with the location information of the call processing management database 20a. At S12, the call processing server 30b The process management database 20a can be accessed. The above is the database management method that is the process executed in the mobile communication system 1 according to the present embodiment.

  As described above, in the database management apparatus 10 according to the present embodiment, the identification information of the call processing server 30 and the identification information of the mobile communication terminal 60 with which the call processing server 30 is performing communication processing are obtained by the acquisition request receiving unit 12. When acquired, the call processing management database stores the mobile communication terminal information of the mobile communication terminal 60 indicated by the identification information of the mobile communication terminal 60 based on the delay information associated with the identification information of the call processing server 30 20 is specified, and the mobile communication terminal information is stored in the call processing management database 20, whereby the master data storage device is switched. Thereby, for example, even if the call processing server 30 is physically or geographically changed, the call processing server 30 performs data input / output with a master data storage device with a small data input / output delay, that is, with a fast data input / output. be able to. That is, the performance can be improved by reducing the data input / output delay in the distributed database 2 in the mobile communication system 1.

  Based on the delay information, the specifying unit 13 determines the data input / output delay between the call processing server 30 and the call processing management database 20 indicated by the identification information of the call processing server 30 acquired by the acquisition request receiving unit 12. The minimum call processing management database 20 may be specified. According to this configuration, the call processing server 30 can perform data input / output with a master data storage device having a minimum data input / output delay. In other words, the data input / output delay in the distributed database 2 in the mobile communication system 1 can be shortened, whereby the performance of the mobile communication system 1 can be improved. The specifying unit 13 may specify the call processing management database 20 further based on the load status of the call processing server 30 and the call processing management database 20.

  The delay information may be a turnaround time between the call processing server 30 and the call processing management database 20. According to this configuration, the call processing server 30 can perform data input / output with the master data storage device switched based on the data input / output turnaround time with the call processing management database 20. Thus, for example, even if the call processing server 30 is physically or geographically changed, the call processing server 30 has a short data input / output turnaround time, that is, a master data storage device and data that have a fast data input / output response. I / O can be performed. In other words, the data input / output delay in the distributed database 2 in the mobile communication system 1 can be shortened, whereby the performance of the mobile communication system 1 can be improved.

  As described above, conventionally, even if the control device (MME, SGSN, etc.) is physically and geographically changed with the movement of the mobile terminal, the physical device that holds the master data of the distributed database is not changed. The data input / output time between the device and the distributed database takes a long time, and as a result, there is a risk that the system performance is lowered. On the other hand, in the mobile communication system 1 according to the present embodiment, a redundant configuration by server virtualization is used, and information on state transitions is held in the distributed database 2. Thus, the call processing server 30 that is a control device of the mobile communication terminal 60 is physically and geographically changed. Therefore, a call that is a physical device that holds data of the distributed database 2 that has the shortest data input / output time by using geographical information with the call processing server 30 that is the main physical device that inputs and outputs the corresponding data. The write access data entity is changed to the process management database 20. By minimizing the input / output delay of the corresponding data, the turnaround time of the distributed database 2 is minimized and the system performance is improved.

  Although the present embodiment has been described for a mobile communication system, the database management apparatus and database management method according to the present invention can be similarly applied to a distributed database and a distributed file system.

  DESCRIPTION OF SYMBOLS 1 ... Mobile communication system, 2 ... Distributed database, 3 ... Base, 4 ... Open flow network, 6 ... Base, 10 ... Database management apparatus, 11 ... Delay information storage part, 12 ... Acquisition request receiving part, 13 ... Identification part , 14 ... control unit, 15 ... location information transmission unit, 20 ... call processing management database, 30 ... call processing server, 31 ... acquisition request transmission unit, 32 ... location information reception unit, 33 ... input / output unit, 50 ... network Manager, 60 ... mobile communication terminal, 70 ... opposite node, 101 ... CPU, 102 ... RAM, 103 ... ROM, 104 ... communication module, 105 ... auxiliary storage device.

Claims (7)

A distributed database composed of a plurality of call processing devices that perform call processing related to a mobile communication terminal and a plurality of call processing management database devices, when the call processing device performs call processing related to the mobile communication terminal State information indicating the state of call processing associated with the mobile communication terminal, which is accessed for data writing, and including state information relating to the area where the mobile communication terminal is located, the plurality of call processing management database devices A database management device in a mobile communication system including the distributed database stored in one of the call processing management database devices,
Delay information storage means for the delay information on the data input and output, and stores in association with the identification information of the identification information and the call processing management database unit of the call processor between said call processing unit wherein the call processing management database unit When,
Obtaining means for obtaining identification information of the call processing device and identification information of the mobile communication terminal in which the call processing device is performing call processing;
When the identification information of the call processing device and the identification information of the mobile communication terminal are acquired by the acquisition unit, the identification information of the call processing device stored by the delay information storage unit is associated with the acquired identification information. Identifying means for identifying the call processing management database device that stores the state information of the mobile communication terminal indicated by the acquired identification information of the mobile communication terminal based on delay information;
When the state information is changed or acquired, including when the mobile communication terminal's coverage area is changed, the call processing management database device specified by the specifying means has been acquired by the acquiring means. Control means for switching to store the state information of the mobile communication terminal indicated by the identification information of the mobile communication terminal;
A database management device comprising: The specifying means has a minimum delay in data input / output between the call processing apparatus and the call processing management database apparatus indicated by the identification information of the call processing apparatus acquired by the acquiring means based on the delay information. The database management device according to claim 1, wherein the call processing management database device is specified. The database management apparatus according to claim 1 or 2, wherein the delay information is a turnaround time between the call processing apparatus and the call processing management database apparatus. The database management apparatus according to claim 1, wherein the mobile communication system has a redundant configuration by server virtualization, and the call processing apparatus is implemented as a virtual server. The database management device according to any one of claims 1 to 4, wherein the specifying unit specifies the call processing management database device based further on a load status of the call processing device or the call processing management database device. The database management device according to any one of claims 1 to 5, wherein the call processing management database device separately manages records of items in which both reading and writing occur and items in which reading only occurs. A distributed database composed of a plurality of call processing devices that perform call processing related to a mobile communication terminal and a plurality of call processing management database devices, when the call processing device performs call processing related to the mobile communication terminal State information indicating the state of call processing associated with the mobile communication terminal, which is accessed for data writing, and including state information relating to the area where the mobile communication terminal is located, the plurality of call processing management database devices A database management apparatus in a mobile communication system including the distributed database stored in one of the call processing management database apparatuses, wherein data input between the call processing apparatus and the call processing management database apparatus delay information about the output, identification information and identification information of the call processing management database unit of the call processor A database management method according to the database management apparatus comprising a delay information storage means for storing in association with,
Including where current area of the mobile communication terminal becomes changed, if the change or acquisition state information occurs, the identification information of the call processor, wherein the call processor is performing the call processing mobile An acquisition step of acquiring identification information of the communication terminal;
Wherein the identification information and the identification information of the mobile communication terminal of the call processing unit and are acquired in said acquisition step, stored by the delay information storage unit, with associated identification information of the acquired said call processor A specifying step of specifying the call processing management database device that stores state information of the mobile communication terminal indicated by the acquired identification information of the mobile communication terminal based on delay information;
A control step of switching to store the state information of the mobile communication terminal indicated by the identification information of the mobile communication terminal acquired in the acquisition step in the call processing management database device specified in the specifying step;
Database management method including.

Images