JP3776278B2 - Database processing system - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a database processing system for an information communication processing system that stores a database on a primary storage device, and in particular, in an advanced intelligent network (IN), a service control node (SCP) or the like realizes services such as toll-free or mobile communication. As a medium for holding a database (DB) for the purpose, a main storage device (MM) that is a primary storage device is generally used to enable high-speed access, and the database (DB) Is a technology that is effective when applied to a database processing system (distributed database processing system) in which a database (DB) is distributed and deployed in a plurality of modules. is there.
[0002]
[Prior art]
FIG. 6 is a schematic diagram showing a schematic configuration of a conventional distributed database processing system. NW is a network, DB is a database, M1 to Mn are modules, and SCP is a service control node. A DB surrounded by ◎ indicates that the database is a target database DB.
[0003]
The conventional method (1) is a system that targets a database DB having target data from the network NW side, as shown in FIG. In order to realize aiming from the network NW side, it is necessary to manage which database DB stores the target data on the network NW side. In the mobile communication service, when the database DB is constructed, the contractor's data is sequentially arranged and stored in the order of the contractor's identification number, so that the network NW side determines the database DB having the target data from the identification number and strikes it. Etc. are taken.
[0004]
As shown in FIG. 6B, the conventional method (2) is a system in which a network access request is notified to a module arbitrarily selected by the network NW, and each module M1 to Mn targets a database DB having target data. is there. In this system, all the modules M1 to Mn need to know in which database DB the target data is stored, and have the database internal information that allows the module number to be indexed from the identification number of the contractor.
[0005]
[Problems to be solved by the invention]
However, in the system of the conventional method (1), it is applicable to a service when it is possible to assign a subscriber's identification number in order as in a mobile communication service, but a basic telephone subscriber such as number portability. When considering the corresponding service, the identification numbers of the contractors are discrete, so the database DB cannot be deployed in the order of the identification numbers, and the realization of the service is extremely difficult.
[0006]
In the system of the conventional method (2), since each module M1 to Mn knows the location of all the databases DB, it can be applied to the case where the identification numbers of service contractors are dispersed. However, as the number of contractors increases, the capacity of the database internal information stored in the database DB of each module M1 to Mn increases, and the data storage area of the contractors is compressed. There is a problem that the number of required modules becomes too large to realize a large-scale database DB.
[0007]
An object of the present invention is to provide a technique that can be applied to a service in which the identification numbers of contractors are dispersed and can efficiently construct a large-scale database.
The above and other objects and novel features of the present invention will become apparent from the description of this specification and the accompanying drawings.
[0008]
[Means for Solving the Problems]
Of the inventions disclosed in this application, the outline of typical ones will be briefly described as follows.
The present invention relates to a database processing system in which a database is distributed and deployed in a plurality of modules in an information communication processing system, wherein a database access request is randomly selected from a network and notified to a desired module, and the database access request The module that received the request transmits the database access request to the module in the system using inter-module coupling and uses broadcast communication, and each module determines whether the received database access request relates to its own database. Then, processing related to the access request addressed to itself is performed, and desired data is returned to the network side.
[0009]
In addition, a database access request is randomly selected from the network and notified to a desired module, and after receiving the database access request in each module, it is determined whether the target data is in its own database, If it is in its own database, it accesses its own database, returns the result to the network, and if it is not in its own database, it uses broadcast communication to all modules except for itself A database processing system that transmits an access request, determines whether the received database access request is related to its own database in each module, processes the access request addressed to itself, and returns desired data to the network A.
[0010]
The point of the present invention is that the above-mentioned conventional method (2) has been developed and broadcast communication is used to access the target database, thereby reducing the capacity occupied by the database internal information in the main memory.
[0011]
By using the database processing system of the present invention, it is possible to realize a service corresponding to a basic telephone contractor, in which the contractor identification numbers are discrete and a large-scale database is required.
[0012]
Hereinafter, the present invention will be described in detail with reference to the drawings together with embodiments (examples) according to the present invention.
[0013]
DETAILED DESCRIPTION OF THE INVENTION
One embodiment (example) according to the present invention is a database processing system related to an information communication processing system that stores a database on a primary storage device.
FIG. 1 is a schematic diagram showing a schematic configuration of an advanced intelligent network according to an embodiment (example) of the present invention.
[0014]
As shown in FIG. 1, the advanced intelligent network (IN) of this embodiment (example) includes a service management node (SMS) 1, an information transfer network 2, a service control node (SCP) 3, a common line signal network (network). ) (NW) 4, an exchange 5, and a terminal 6.
[0015]
In the advanced intelligent network (IN) shown in FIG. 1, the database processing system according to this embodiment (example) is configured such that the service control node (SCP) 3 or the like is a database (DB) for realizing services such as toll-free or mobile communication. ) And a medium for holding this database, a primary storage device (MM) is generally used to enable high-speed access (DB), and the scale of the database exceeds the capacity of the primary storage device (MM). In this case, it is a database processing system (distributed database processing system) in which databases are distributed and deployed in a plurality of modules.
[0016]
FIG. 2 is a block diagram showing a configuration example of a part of the information communication processing system according to the present invention.
In FIG. 2, 11 is a central processing unit (CPU) of the information processing system, which mainly executes programs for realizing services.
[0017]
A main storage device (MM) 12 holds a program and data referred to by the program, and also holds a DB composed of service contractor information.
A network interface (SS7 • I / F) 13 is connected to the central processing unit (CPU) 11 via the system bus 10 and has an interface function with the network (NW) 4.
A peripheral device 14 is connected to the central processing unit (CPU) 11 and the network interface (SS7 / I / F) 13 via the system bus 10. An ATM interface (ATM / I / F) 15 is connected to the central processing unit (CPU) 11 and communicates with other central processing units (CPU) through an ATM line. It also supports broadcast communication at the hardware level.
[0018]
Other devices such as a central processing unit (CPU) 11, a main storage unit (MM) 12, a network interface (SS7 / I / F) 13, an ATM interface (ATM / I / F) 15 and a peripheral device 14 shown in FIG. Is shown as a single configuration, but a redundant configuration is taken according to the reliability requirement required for the system. However, it is not shown because it is not directly related to the present invention.
[0019]
There are various items constituting the database on the main memory (MM) 12 depending on the service to be realized. However, since detailed configuration items are not necessary in describing the present invention, it is assumed here that the database internal information and the contractor data necessary for realizing the service are stored.
[0020]
FIG. 3 is a schematic diagram showing the configuration of the service control node (SCP) in the database processing system of the present embodiment (example). In FIG. 3, M1 to Mn represent modules, and each module M1 to Mn has the apparatus shown in FIG. 2, is connected to a network (NW) 4, and the modules are coupled by an ATM line.
[0021]
FIG. 4 is a flowchart showing a processing flow of the service control node (SCP) in the database processing system of the present embodiment (example), and a broken-line arrow indicates a case where the broadcast is realized so as not to include itself.
[0022]
As shown in FIG. 4, a database access request from the network (NW) 4 in the database processing system of this embodiment (example) is received by an arbitrarily selected module Mx (1 ≦ x ≦ n) ( Mx broadcasts to all modules M1 to Mn via inter-M coupling (inter-module communication). Each of the modules M1 to Mn receives a database access request transmitted by broadcasting (inter-module communication), determines whether it is an access request addressed to its own database based on the internal information of the database (data existence determination), If it is addressed, the corresponding data is accessed and the database processing necessary to realize the service is performed (database access). Finally, the database processing result is returned to the network (NW) (to NW communication).
[0023]
In the above description, the case where the data presence / absence determination block in FIG. 4 is a solid line has been described. In this case, even if the target data exists in its own database, it is broadcast out of the module via the M-M coupling. However, it is also possible to realize that the broadcast does not include the one addressed to itself, and this processing method is indicated by a broken-line arrow in FIG. That is, after receiving the database access request received from the network (NW) via network communication, the data presence / absence determination block determines whether the target data is in its own database. Immediately access your database (DB) and return the result to the network (NW) via network communication, and if not, for all modules (excluding you) To broadcast. In this case, there is no particular difference in the processing after receiving from the M-M coupling.
In the following, the database processing system of the present embodiment is evaluated from the viewpoint of main memory (MM) capacity.
[0024]
Here, the capacity of the main storage device 12 that can be used for the database is 4 GBytes, the database internal information indicating in which database the contractor data is stored is 20 bytes per contractor, and the contractor data necessary for realizing the service. The capacity is evaluated as 400 bytes per contractor.
[0025]
As pointed out in the problems of the conventional method described above, the conventional method (1) is not evaluated because it is difficult to realize a service compatible with a basic telephone.
In the conventional method (2), since the capacity of the main storage device 12 possessed by one module is 4 GBytes, the total capacity (D) of the main storage device 12 possessed by the entire service control node (SCP) can be expressed by the following equation (1).
[0026]
[Expression 1]
D = 4 × 10 ⁹ × number of modules (n) [Bytes]
All the modules M1 to Mn need to have database internal information on all contractors, and the total capacity (D1) of the database internal information that must be stored in the main storage device 12 of the service control node (SCP) 3 is as follows: Equation 2 is obtained.
[0027]
[Expression 2]
D1 = 20 × the number of subscribers (S) × n [Bytes]
The total capacity (D2) of the contractor data necessary for realizing the service is determined from the number of contractors, and is expressed by the following formula 3.
[0028]
[Equation 3]
D2 = 400 × S [Bytes]
Further, since it is not possible to have a database exceeding the total main storage capacity of the service control node (SCP) 3, the following relational expression 4 is established.
[0029]
[Expression 4]
D ≧ D1 + D2
From the relational expression (4), the following relational expression (5) holds for the number of contractors (S) and the required number of modules (n) required to accommodate them.
[0030]
[Equation 5]
n ≧ 20 × S / (2 × 10 ⁸ −S)
In the database processing system according to the present embodiment, the total capacity (D) of the main storage device 12 and the total capacity (D2) of the contractor data necessary for realizing the service of the entire service control node (SCP) 3 are as described above. This is the same as method (2). However, by using broadcast for inter-module communication, the service can be realized if only the database internal information of the own module is possessed. Therefore, the total capacity (D1 ′) of the database internal information is expressed by the following equation (6). It becomes like this.
[0031]
[Formula 6]
D1 ′ = 20 × Number of subscribers (S) [Bytes]
Therefore, the following relational expression 7 holds for the number of contractors (S) and the number of required modules (n) required to accommodate them.
[0032]
[Expression 7]
n ≧ 20 × S / 2 × 10 ⁸
FIG. 5 shows a graph of the number of contractors and the number of required modules necessary to accommodate them in the conventional method (2) and the database processing system of the present invention. As the graph shows, it can be seen that the database processing system of the present invention can construct a large-scale database with a smaller number of modules than the conventional system.
[0033]
Further, in the conventional method, as the number of contractors increases, the capacity occupied by the database internal information increases and approaches the upper limit of the capacity of the main storage device 12, so that the number of contractors is limited. On the other hand, in the database processing system of the present invention, the capacity of the database internal information stored in one database is constant regardless of the increase in the number of contractors, so that it does not depend on the capacity of the main storage device 12. Large-scale database construction is possible.
[0034]
(Example variation)
Although the invention made by the present inventor has been specifically described based on the embodiment (example), the invention is not limited to the embodiment (example), and departs from the gist thereof. Of course, various changes can be made without departing from the scope. For example,
1) In the above embodiment (example), the database processing system has been described using a system that provides an advanced intelligent network (IN) service. However, the type of service and the system configuration to be realized are only described in the above embodiment. It goes without saying that it is not limited. The same effect can be obtained with respect to a system in which any database is distributed and held for service realization.
[0035]
2) The system configuration of FIG. 2 is only an example. The device that holds the database may be any of a semiconductor memory device, a hard magnetic disk device, a magneto-optical disk device, and the like. The inter-module coupling may be any system that can realize broadcast communication such as ATM coupling, LAN coupling, etc., and in the above description, the ATM interface (ATM / I / F) 15 is directly connected to the central processing unit (CPU) 11. However, even if this is a device on the system bus, the effect of the present invention is not changed.
[0036]
3) Even if the database internal information and the contractor data, which are database configuration items, are placed on different storage devices, the application of the present invention is not particularly hindered.
[0037]
4) In the above description, the case where the processing described in FIG. 4 is executed by a program on the central processing unit (CPU) 11 has been described. However, a part of the processing is executed by hardware for processing efficiency. Even if it does, it will not inhibit application of the present invention.
[0038]
【The invention's effect】
As described above, according to the present invention, the broadcast communication is used to access the target database, and the capacity occupied by the database internal information in the main storage device is reduced. And a database processing system capable of efficiently constructing a large-scale database can be obtained.
[Brief description of the drawings]
FIG. 1 is a schematic diagram showing a schematic configuration of an advanced intelligent network according to an embodiment (example) of the present invention.
FIG. 2 is a block diagram showing a configuration example of a part of the information communication processing system according to the embodiment (example) of the present invention.
FIG. 3 is a schematic diagram showing a configuration of a service control node according to an embodiment (example) according to the present invention.
FIG. 4 is a flowchart showing a processing flow of a service control node according to the present embodiment.
FIG. 5 is a graph showing the number of contractors and the number of required modules necessary to accommodate them in the conventional method (2) and the database processing system of the present invention.
FIG. 6 is a schematic diagram showing a schematic configuration of a conventional distributed database processing system.
[Explanation of symbols]
DESCRIPTION OF SYMBOLS 1 ... Service management node (SMS), 2 ... Information transfer network, 3 ... Service control node (SCP), 4 ... Common line signal network (network: NW), 5 ... Switch,
6 ... Terminal, 11 ... Central processing unit (CPU), 12 ... Main memory (MM),
13 ... Common line signal network (network) interface (SS7 I / F),
14 ... Peripheral devices, 15 ... ATM interface (ATM / I / F),
M1 to Mn ... module, DB ... database.

Claims (2)

Is connected via a switch and a network, a database processing system in the service control node that includes a inter-module coupling the database connecting the dispersion deployed plurality of modules and the plurality of modules, the database from the network an access request received by any module in the service control point, module receiving the database access request from the network, via the coupling between the modules, by using the broadcast communication, all modules f internal system transmitting the database access request, the database access requests received in each module receiving the database access request via the coupling between the module whether related database held by their Sectional, and database processing system characterized in that to return the desired data to the network side performs processing for those related to the access request addressed to. Is connected via a switch and a network, a database processing system in the service control node that includes a inter-module coupling the database connecting the dispersion deployed plurality of modules and the plurality of modules, the database from the network an access request received by any module in the service control point, module receiving the database access request from the network, purpose of the data it is determined whether the own database, in its database In the case of access to its own database, the result is returned to the network, and if it is not in its own database, all modules except for itself are connected to each other through the inter-module coupling , using broadcast communication, The day Sends the base access request, the database access requests received in each module receiving the database access request via the inter-module coupling is determined whether or not related to the database with the own, any components related to the access request addressed to A database processing system that performs processing and returns desired data to the network.

Images