JP2008299450A - Database system and data management method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a database system and a data management method for reducing a transmission load to a communication network by dispensing with data matching among a plurality of data servers while maintaining the backup of data by the data servers. <P>SOLUTION: For managing data records having a plurality of fields while making into a database, data servers are installed corresponding to the field values of at least two fields so that a data server group can be configured. In the case of registering data records from a client terminal, the data records are registered in all the data servers in the data server group corresponding to the field values of the data records, and one data server is selected as the object of retrieval based on a predetermined priority order from among the data servers, and retrieval is performed in the case of retrieval. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

  The present invention relates to a database system and a data management method, and more particularly, to a database system and a data management method using a plurality of data servers and client terminals commonly connected to these data servers.

  A database system in which a data server and a client terminal are connected to each other by a communication network, and data according to a specific theme is structurally stored and managed in the data server to facilitate the reuse and retrieval from the client terminal. Became widely used. Conventionally, this type of system is often configured to register and search data by a plurality of client terminals while storing and managing the entire data with one data server.

  On the other hand, when using a plurality of data servers, for example, when using two data servers to increase availability, one is for the master and the other is for backup, and the master data server is If it becomes unusable, the backup server can continuously take over its functions, and all data is copied from the master data server, for example. It is. For this reason, the entire communication network including the connection between the data servers needs to secure a sufficient capacity to withstand the instantaneous transmission load.

  In some cases, a plurality of data servers are used in order to distribute the processing load of the data server and the concentration of traffic especially around the data server in the communication network. In this case, for example, as the entire system becomes larger with an increase in the number of data servers and client terminals, it becomes difficult to match the contents of all the data servers from the viewpoint of processing load. There is also a high probability of matching. For this reason, a method of distributing data to a plurality of data servers and managing different data for each is also adopted.

  For example, in the DNS (Domain Name System) that manages the association between domain names and IP addresses on the Internet, for example, kaisha. co. For a domain name such as jp, a server that manages the route, a server that manages jp, co. jp managing server, and kaisha. co. Data is distributed in a hierarchical server configuration such as a server that manages jp. When searching for a DNS to obtain an IP address from a domain name, if the domain name (for example, kaisha.co.jp) is specified as a search key, the target data can be obtained even if the data is distributed to a plurality of servers. Can be identified.

Note that the maintenance of data consistency among a plurality of data servers is described in Patent Document 1, for example.
Japanese Patent Laid-Open No. 11-249943 (page 8, FIG. 1)

  By the way, one piece of data stored and managed in a database in the data server is called, for example, a data record and is generally composed of a plurality of fields. Each field has a specific attribute, and has various field values depending on the attribute. For example, in the case of managing the activity position information of a worker, one data record corresponds to one worker and consists of fields such as worker name, organization, activity area (prefecture name), and detailed information. Is done. When searching the database, these fields are used as search keys as search conditions, the field values are designated, and the search is executed. At this time, if the data is stored and managed by one data server or a plurality of matched data servers, the search may be executed for one predetermined data server.

  However, the following problems may occur when data is stored and managed in a plurality of data servers. That is, if the field as a search key is a single (domain name) as in the above-described DNS, the data server that stores and manages the target data can be specified, but there are a plurality of fields that can serve as the search key. In some cases, it is difficult to know which data is stored in which data server.

  For example, in the above example, when the activity location information of workers is stored and managed by a data server distributed and arranged corresponding to each prefecture, which is the field value, using the activity region field as a key, it is located in Tokyo In order to search for the detailed information of the worker, the search should be executed for the data server that manages the data in Tokyo. On the other hand, in order to search for detailed information on workers in a specific organization, workers in that organization are not necessarily active only in specific prefectures. It cannot be specified. In order to perform a reliable search, it is necessary to search all data servers, and the transmission load on the communication network also increases.

  The present invention has been made in consideration of the above-described circumstances, and maintains a data backup by a plurality of data servers, and does not require data matching between these data servers, thereby reducing a transmission load on a communication network. It is an object to provide a system and a data management method.

  In order to achieve the above object, a database system according to the present invention is a database system that manages a data record having a plurality of fields in a data server by managing the data record in at least two or more fields of the data record. A plurality of data servers provided corresponding to each of the field values, and a network connection to these data servers via a common communication path, registering the data records in the data server and registering the registered data records A client terminal for searching, and when registering the data record, the client terminal sends the data record to all data servers corresponding to field values of the data record to be registered among the plurality of data servers. And register the data When searching for a code, the client terminal performs a search for a data server selected based on a predetermined priority from the plurality of data servers corresponding to a field value specified in a search condition. Features.

  Further, the data management method of the present invention includes a plurality of data servers in which data records having a plurality of fields are provided corresponding to each of the field values for at least two or more fields of the data records, and A data management method in a database system, which is connected to a network via a communication path in common with a data server and includes a client terminal that registers the data record in the data server and retrieves the registered data record, When registering the data record in the data server, the client terminal registers the data record in all the data servers corresponding to the field values of the data record to be registered in the plurality of data servers, The data registered in the data server When searching for records, and executes a search target selected data server based on a predetermined priority from among the plurality data server corresponding to the field value specified in the search criteria.

  According to the present invention, a database system capable of maintaining data backup by a plurality of data servers, eliminating the need for data matching between the data servers, and reducing the transmission load on the communication network, and A data management method can be obtained.

  The best mode for carrying out the database system and the data management method according to the present invention will be described below with reference to FIGS.

  FIG. 1 is a block diagram showing an embodiment of a database system according to the present invention. FIG. 2 is a diagram showing an example of the configuration of data handled by the database system illustrated in FIG. First, data will be described with reference to FIG. In the case of FIG. 2, one data record corresponding to one data has five fields, field 1 to field 5. Each field represents a type of information. For example, in this case, each field corresponds to a worker name, a belonging organization, an activity area, a vehicle type, and detailed information. Each field can take a field value corresponding to the attribute. For example, the organization to which field 2 belongs has a field value such as A or B, the active region of field 3 has one of TK, KN, or CB, and the vehicle type of field 4 has a field value of T or N.

  FIG. 1 is a configuration diagram showing a configuration when a data server is provided corresponding to each of the field values for the three fields, field 2, field 3, and field 4 illustrated in FIG. 2 as an example. It is. The database system illustrated in FIG. 1 includes a field 2 data server group 10, a field 3 data server group 20, a field 4 data server group 30, n client terminals 41 to 4n, and communication for interconnecting them. The network 50 is configured.

  The field 2 data server group 10 is a data server group provided corresponding to the field value of the field 2 of the data illustrated in FIG. 2, and includes an A data server 11 and a B data server 12. The A data server 11 and the B data server 12 send data records whose field values corresponding to the respective data servers are sent from the client terminals 41 to 4n, which will be described later, via the communication network 50. Store and manage database. In other words, in the case of FIG. 2, the A data server 11 stores and manages data records whose organization is A. Also, the B data server 12 stores and manages data records whose organization is B.

  Similarly, the field 3 data server group 20 is a data server group provided corresponding to the field value of the field 3, and includes a TK data server 21, a KN data server 22, and a CB data server 23. The TK data server 21 has a field 3, that is, a data record in which the active region is TK, the KN data server 22 has a data record in which the active region is KN, and the CB data server 23 has an active region that is CB. Each data record is stored in a database and managed. The field 4 data server group 30 is also a data server group provided corresponding to the field value of the field 4, and includes a T data server 31 and an N data server 32. The T data server 31 stores and manages the data record of the field 4, that is, the data record whose vehicle type is T, and the N data server 32 stores the data record whose vehicle type is N as a database.

  The n client terminals 41 to 4n are connected to the above-described data server group and data server via the communication network 50, and send the data records illustrated in FIG. 2 to the corresponding data servers based on their field values, respectively. In addition to requesting registration, a search request for a data record is sent to a predetermined data server based on the search condition, and the result is received. The communication network 50 is a communication path that connects the above-described data server and client terminal, and is configured by, for example, a wired LAN or a wireless LAN.

  Next, the operation of the database system of the present embodiment configured as described above will be described with reference to the configuration diagrams and the explanatory diagrams of FIGS. 1 and 2 and FIGS. In order to simplify the description, as illustrated in FIG. 3, data corresponding to each of the field values for two fields, that is, the organization to which field 2 belongs and the active region of field 3 are illustrated. A model with a server and four client terminals will be described. FIG. 4 is an explanatory diagram for explaining the flow of information at the time of data record registration and search in the case of FIG.

  First, it is assumed that the client terminal 41 is operated by the worker 1 belonging to the organization A. When the client terminal 41 is active in the activity area TK and registers one data record exemplified in the data # 1 of FIG. 2, the A data server 11 that stores and manages the data record whose organization is A, The data record is sent to both the TK data server 21 that stores and manages the data record whose activity area is TK. At this time, for the address information for individually identifying the destination data server, for example, as shown in FIG. 5, each field value provided in advance in each client terminal and the corresponding data server are provided. By referring to the address information table. Each data server 11 and 21 receives and stores and manages this data record. (S401 and S402 in FIG. 4).

  Further, the client terminal 42 is operated by the worker 2 belonging to the organization B, and the data record illustrated in the data # 2 of FIG. 2 is registered while the client terminal 42 is active in the activity area KN. In this case, the transmission destination is both the B data server 12 that stores and manages data records whose organization is B, and the KN data server 22 that stores and manages data records whose activity area is KN. This data record is stored and managed by these two data servers 12 and 22 (S403 and S404 in FIG. 4).

  As described above, the data record from the client terminal is registered in the two data servers, that is, in the corresponding data servers in the two data server groups 10 and 20 provided corresponding to the field values. Thus, it is possible to eliminate the need for data matching between the data servers while maintaining the backup of the data record.

  On the other hand, the search operation is as follows. As the search key of the search condition, if one of the two fields provided with the data server group, that is, either the affiliated organization or the active region can be designated, for example, the worker 3 belonging to the affiliated organization A from the client terminal 43 However, when searching for data records having the same belonging organization A, the client terminal 43 uses the data server address information table illustrated in FIG. The data server 11 is searched for and a predetermined search result is obtained (S405 in FIG. 4).

  Similarly, when the worker 4 searches the client terminal 44 for a data record in which the active area is KN, the client terminal 44 determines that the active area is KN based on the address information table of the data server in the terminal. 2 is extracted, for example, the data record of data # 2 in FIG. 2 is extracted, and detailed information about the worker 2 of the organization B can be confirmed (FIG. 4). S406). As described above, since data records are distributed and stored and managed in a plurality of data servers, communication traffic can be distributed without being concentrated on a specific data server, and the transmission load on the communication network can be reduced. it can.

  The above is the case where the data server is provided corresponding to the field values of the two fields. Next, the case where the data server is provided corresponding to the field values of the three fields as shown in FIG. 1 will be described. To do. Note that the number of client terminals is four client terminals 41 to 44 as in the case of FIG. FIG. 6 is an explanatory diagram for explaining the flow of information during registration and retrieval of data records in this case.

  First, for example, the client terminal 41 is operated by the worker 1 who belongs to the organization A. When the client terminal 41 is active using the vehicle type T in the activity region TK and registers the data record illustrated in the data # 1 in FIG. 2 including the detailed information, the client terminal 41 A data server 11 that stores and manages data records whose organization is A, TK data server 21 that stores and manages data records whose activity region is TK, and T data that stores and manages data records whose vehicle type is T This data record is sent to the three data servers of the server 31 while obtaining the address information of each data server based on the address information table of the data server as illustrated in FIG. Each data server 11, 21, and 31 receives and stores and manages this data record (S601 to S603 in FIG. 6).

  2 is registered from the client terminal 42, the data record is sent to the B data server 12 which stores and manages the data record whose organization is B. The KN data server 22 stores and manages data records whose activity area is KN, and the N data server 32 stores and manages data records whose vehicle type is N. This data record is stored and managed in each of these three data servers 12, 22, 32 (S604 to S606).

  On the other hand, at the time of retrieval, one data record is stored and managed by the three data servers as described above, and the retrieval is performed after selecting one retrieval target data server from these. In this selection, in this embodiment, for each of the client terminals 41 to 44, for example, as shown in FIG. A priority table in which priorities for data server selection are set in advance is provided. In this example, all three fields are used as search keys, and their priorities are set in the order of activity area, organization belonging, and vehicle type.

  The search operation is as follows. For example, when searching for a data record in which the affiliated organization is A, the activity region is KN, and the vehicle type is N from the client terminal 43 operated by the worker 3, if the corresponding data record has been registered, It is stored and managed in any data server. That is, the A data server 11 for storing / managing data records whose organization is A, the KN data server 22 for storing / managing data records whose activity region is KN, and the data records whose vehicle type is N are stored / managed. N data servers 32 are three data servers. Here, the client terminal 43 refers to the priority order table illustrated in FIG. 7 provided in advance in its own terminal. In this table, since the first priority is the data server of the active area, the data server to be searched Is the KN data server 22. Then, the client terminal 43 grasps the address information based on the data server address information table illustrated in FIG. 5 and searches the remaining field values for the KN data server 22 using the search conditions specified as described above. To obtain a predetermined result (S607 in FIG. 6).

  Further, when only one field is designated as a search key as a search condition, for example, when searching for a data record whose vehicle type is T from the client terminal 44 operated by the worker 4, the client terminal 44 is shown in FIG. There is no particular need to refer to the exemplified priority order table, and the search is executed for the data server 32 whose vehicle type is T (S608 in FIG. 6).

  In this example, when selecting a data server to be searched from a plurality of data servers, priorities are set in advance as illustrated in FIG. It is also possible to apply a method of holding response times when communicating with each data server and dynamically setting priorities based on the response times.

  As described above, in these embodiments described above, when data records having a plurality of fields are managed in a database, a data server is provided corresponding to the field values for at least two or more fields, respectively. It constitutes a data server group. And when registering a data record from a client terminal, it registers with the data server in all the data server groups corresponding to the field value of the data record. As a result, since the data records are simultaneously registered in a plurality of data servers, it is possible to eliminate the need for data matching between the data servers in which the data records are registered while maintaining the backup of the data records.

  In addition, since data records are distributed and stored in multiple data servers, communication traffic is also identified by selecting one data server as a search target based on the priority order. Can be distributed without concentrating on the data server, and the transmission load on the communication network can be reduced. In addition, in this embodiment, for example, by arranging each data server of the data server group corresponding to the active area in the target area, the physical distance on the communication network with the client terminal in the active area Communication traffic can be further distributed by using the degree of freedom of mutual arrangement of a specific data server and a specific client terminal on the communication network, such as close to the network, so that the transmission capacity of the communication network is limited. Even in such a case, a good processing response can be maintained.

  Note that the present invention is not limited to the above-described embodiments as they are, and can be embodied by modifying the components without departing from the scope of the invention in the implementation stage. Further, various inventions can be formed by appropriately combining a plurality of constituent elements disclosed in the above embodiments. For example, some components may be deleted from all the components shown in the embodiments. Furthermore, the constituent elements in different embodiments may be appropriately combined.

The block diagram which shows one Example of the database system which concerns on this invention. Explanatory drawing which shows an example of a structure of the data handled with the database system illustrated in FIG. The block diagram which shows an example of the database system comprised by two data server groups and four client terminals. FIG. 4 is an explanatory diagram for explaining a flow of information at the time of data record registration and search in the database system illustrated in FIG. 3. Explanatory drawing which shows an example of the table of the address information of a data server. Explanatory drawing for demonstrating the flow of the information at the time of registration and search of the data record in the database system illustrated in FIG. Explanatory drawing which shows an example of a priority table.

Explanation of symbols

10 Field 2 Data Server Group 11 A Data Server 12 B Data Server 20 Field 3 Data Server Group 21 TK Data Server 22 KN Data Server 23 CB Data Server 30 Field 4 Data Server Group 31 T Data Server 32 N Data Servers 41 to 4n Client Terminal 50 communication network

Claims (4)

A database system for managing data records having a plurality of fields in a data server as a database,
A plurality of data servers provided corresponding to each of the field values for at least two or more fields of the data record;
These data servers are connected to a network through a communication path in common, and include a client terminal that registers the data records in the data server and searches for the registered data records.
When registering the data record, the client terminal registers the data record in all the data servers corresponding to the field values of the data record to be registered among the plurality of data servers,
When searching for the data record, the client terminal executes a search for a data server selected based on a predetermined priority from the plurality of data servers corresponding to the field value specified in the search condition. A database system characterized by that.   The predetermined priority order of the data server selected by the client terminal as the target at the time of the search is provided in the client terminal, and the field between these fields when the field is specified as a search condition. The database system according to claim 1, wherein the database system is based on a priority table in which priorities are set in advance. A plurality of data servers each provided with a data record having a plurality of fields corresponding to each of the field values for at least two or more fields of the data record;
A data management method in a database system that is connected to a network via a communication path in common with these data servers, and includes a client terminal that registers the data records in the data server and retrieves the registered data records,
When registering the data record in the data server, the client terminal registers the data record in all the data servers corresponding to the field values of the data record to be registered in the plurality of data servers,
When searching for the data record registered in the data server, the search is performed for the data server selected based on a predetermined priority from the plurality of data servers corresponding to the field value specified in the search condition. The data management method characterized by performing.   The predetermined priority order of the data server selected by the client terminal as the target at the time of the search is provided in the client terminal, and the field between these fields when the field is specified as a search condition. 4. The data management method according to claim 3, wherein the data management method is based on a priority table in which priorities are set in advance.

Images