JP5320637B2 - Data search system, system, program, and data search method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To simplify system configurations, and to increase the processing efficiency of data retrieval processing in a data retrieval system. <P>SOLUTION: This data retrieval system is configured to retrieve data to be used for a service from a database, and provided with: a service identification information acquisition part for acquiring service identification information for identifying a service transmitted from the request source of data; a configuration information specification part for specifying the configuration information of a retrieval inquiry sentence associated with the service identification information; a retrieval inquiry sentence generation part for generating a retrieval inquiry sentence by using the predetermined configuration information; a data acquisition part for acquiring data on the basis of the generated retrieval inquiry sentence; and a data transmission part for transmitting the acquired data to the request source. <P>COPYRIGHT: (C)2010,JPO&amp;INPIT

Description

  The present invention relates to a data search system, a data search method, and a program. The present invention particularly relates to a data search system, a data search method, and a program for searching for data used in a service.

A technology for virtually integrating a plurality of databases distributed in the system has been devised (see, for example, Patent Document 1 and Patent Document 2). By using such a technique, the data requesting system can acquire the data stored in the database without being aware of the data storage destination.
JP 2005-208757 A JP 2007-257083 A

  However, since the above technique is premised on database connection, it is difficult to integrate data included in a system that does not have a database connection interface and a system that persists data using a method other than a database.

  Further, in the above technique, since the query request statement is directly generated and issued by the data request source, it is not possible to prevent a query statement that puts a load on the database. In this case, there is a possibility that not only the response to this query but also the response to other queries targeting this database will be reduced.

  In addition, since the database integrated reference device does not restrict the query results, the data requester can acquire a large amount of data unnecessarily, or it must be disclosed only to a specific data requester. Other systems can acquire high data.

  In order to solve the above-described problem, in the first embodiment of the present invention, a data search system for searching data used in a service from a database, for identifying the service transmitted from the data request source. A service inquiry information acquisition unit that acquires service identification information, a structure information specifying unit that specifies configuration information of a search query sentence associated with the service identification information, and a search inquiry sentence using the specified configuration information A search query statement generation unit that generates the data, a data acquisition unit that acquires data using the generated search query statement, and a data transmission unit that transmits the acquired data to the request source.

  The above summary of the invention does not enumerate all the necessary features of the present invention, and sub-combinations of these feature groups can also be the invention.

  Hereinafter, the present invention will be described through embodiments of the invention, but the following embodiments do not limit the invention according to the claims. In addition, not all the combinations of features described in the embodiments are essential for the solving means of the invention.

  FIG. 1 shows an example of an administrative system 10 according to the embodiment. The administrative system 10 includes a data search system 100. The administrative system 10 also includes a receipt ledger system 110 as an example of a data request source of data used in the service. In addition, the administrative system 10 includes an elderly support system 121, a welfare system 122, and a common database 123 as an example of an acquisition destination of data used in the service.

  The elderly person support system 121 is a system that provides elderly person support services, and holds data of elderly person support services. The welfare system 122 is a system that provides a welfare service, and holds data on the welfare service. The common database 123 stores data shared by a plurality of systems. The common database 123 stores resident information service data and resident income information service data.

  In response to a request from the receipt ledger system 110, the data search system 100 acquires service data to be provided to the user from at least one of the elderly support system 121, the welfare system 122, and the common database 123. To do. Then, the data search system 100 transmits the acquired data to the receipt ledger system 110.

  The data search system 100 has an elderly support information search service function, a welfare information search service function, a resident information search service function, and a resident income information search service function. The elderly person support information retrieval service function acquires elderly person support service data from the elderly person support system 121. The life protection information search service function acquires data of a life protection service from the life protection system 122. The resident information search service function acquires resident information service data from the common database 123. The resident income information search service function acquires data of the resident income information service from the common database 123.

  The receipt ledger system 110 requests the data search system 100 for data to be provided to the service user. Then, the receipt ledger system 110 acquires data corresponding to the request from the data search system 100. Furthermore, the receipt ledger system 110 provides the acquired data to the user.

  For example, when the elderly support service is selected from the terminal device included in the receipt ledger system 110, the receipt ledger system 110 requests the data search system 100 for data of the elderly support service. In response to this, the data search system 100 acquires the data for the elderly support service from the elderly support system 121. Then, the receipt ledger system 110 acquires the data for the elderly support service from the data search system 100. Furthermore, the receipt ledger system 110 displays the acquired elderly support service data on the screen of the terminal device.

  The receipt ledger system 110 can acquire the data held by the elderly support system 121, the welfare system 122, and the common database 123 from the data search system 100 by requesting the data search system 100. For this reason, the receiving ledger system 110 does not need to provide a communication interface for each of the elderly support system 121, the welfare protection system 122, and the common database 123, and only needs to provide a communication interface for the data search system 100.

  In particular, the receipt ledger system 110 may have different communication connection methods for the elderly support system 121, the welfare system 122, and the common database 123, respectively. For example, a Web service connection is used as a communication connection method with the elderly person support system 121, a DB2 (registered trademark) database connection is used as a communication connection method with the life protection system 122, and a communication connection with the common database 123 is established. Assume that a database connection for Oracle (registered trademark) is used. Even in such a case, the receiving ledger system 110 only needs to provide a communication interface of a communication connection method with the data search system 100.

  When any system included in the administrative system 10 is changed or deleted, only the communication interface between the system to be changed or deleted and the data search system 100 may be changed or deleted. Further, when a system is added to the administrative system 10, the system to be added only needs to provide a communication interface for the data search system 100. Thus, the system to be added can be acquired from the data search system 100 by requesting the data search system 100 for data held by the elderly support system 121, the welfare system 122, or the common database 123.

  As described above, according to the administrative system 10 of the present embodiment, the system can be added / changed / deleted without affecting the existing data requesting system and the data providing system. And management costs can be reduced. In addition, since each system included in the administrative system 10 does not need to open a plurality of types of communication ports, the security effect of each system included in the administrative system 10 can be improved.

  FIG. 2 shows a functional configuration example of the data search system 100 according to the embodiment. The data search system 100 includes a service interface unit 210, an authority determination processing unit 220, a search processing unit 230, a filter processing unit 240, and a storage unit 250.

  The storage unit 250 stores in advance various definition files referenced by the service interface unit 210, the authority determination processing unit 220, the search processing unit 230, or the filter processing unit 240. For example, the storage unit 250 stores an authority determination rule definition file in which an association of authority determination rules with each of a plurality of service identification information is defined in advance. In addition, the storage unit 250 stores a service definition file in which association of data search processing with each of a plurality of service identification information is defined in advance. The storage unit 250 stores in advance a filtering condition definition file that defines a plurality of filtering conditions.

  The service interface unit 210 acquires a request message from the receipt ledger system 110. The request message includes service identification information, user information, search parameters, and the like. The service interface unit 210 generates ValueObject indicating the acquired service identification information, user information, search parameters, and the like. Then, the service interface unit 210 transmits the generated ValueObject to the authority determination processing unit 220. As a result, the service interface unit 210 requests the authority determination processing unit 220 for authority determination processing by the authority determination processing unit 220 and data search processing by the search processing unit 230.

  The authority determination processing unit 220 acquires the value object transmitted from the service interface unit 210. The authority determination processing unit 220 identifies a service and a user by referring to the acquired ValueObject. The authority determination processing unit 220 identifies the authority determination rule associated with the identified service by referring to the authority determination rule definition file stored in the storage unit 250. And the authority determination process part 220 determines the authority of the specified user using the specified authority determination rule.

  The authority determination processing unit 220 may specify the department name to which the user belongs by referring to the acquired ValueObject. Then, the authority determination processing unit 220 may determine the authority of the user with the specified department name. Further, the authority determination processing unit 220 may specify the title of the user by referring to the acquired ValueObject. Then, the authority determination processing unit 220 may determine the authority of the user with the specified position name.

  When it is determined that the specified user has authority for the service specified by the authority determination process, the authority determination processing unit 220 hands over the ValueObject indicating the service identification information and the search parameter to the search processing unit 230. As a result, the authority determination processing unit 220 requests the search processing unit 230 to perform a data search process. On the other hand, when it is determined that there is no authority of the specified user for the service specified by the authority determination process, the authority determination processing unit 220 does not request the data search process to the search processing unit 230, and the result of the authority determination process Is sent to the service interface unit 210.

  The search processing unit 230 acquires the ValueObject transmitted from the authority determination processing unit 220. The search processing unit 230 specifies a service and a search parameter by referring to the acquired ValueObject. In addition, the search processing unit 230 specifies a data search process associated with the specified service by referring to the service definition file stored in the storage unit 250.

  And the search process part 230 performs the data search process according to the specified service by the specified data search process. For example, the search processing unit 230 transmits a search inquiry sentence corresponding to the specified service to a destination corresponding to the specified service.

  Thereby, the search processing unit 230 acquires search result data corresponding to the specified service. For example, the search processing unit 230 acquires search result data corresponding to the specified service from the elderly support system 121, the welfare system 122, or the common database 123. The search processing unit 230 generates ValueObject indicating the acquired search result data. The search processing unit 230 transmits the generated ValueObject to the authority determination processing unit 220.

  The filter processing unit 240 performs a filtering process in units of data items on the search result data acquired by the search processing unit 230. For example, the search processing unit 230 transmits ValueObject indicating service identification information, user information, and search result data to the filter processing unit 240.

  The filter processing unit 240 acquires the ValueObject transmitted from the search processing unit 230. The filter processing unit 240 identifies a service and a user by referring to the acquired ValueObject. Further, the filter processing unit 240 identifies the filtering condition associated with the identified service by referring to the service definition file stored in the storage unit 250.

  By referring to the filtering condition definition file stored in the storage unit 250, the filter processing unit 240 specifies an authority determination rule for each data item of the acquired search result data from the specified filtering conditions. And the filter process part 240 determines the authority of the specified user using the specified authority determination rule for every data item of the acquired search result data.

  The filter processing unit 240 may specify a department name to which the user belongs. Then, the filter processing unit 240 may determine the authority of the user for each data item of the acquired search result data with the specified department name. Further, the filter processing unit 240 may specify the job title name of the user. And the filter process part 240 may determine the authority of the user for every data item of the acquired search result data with the specified position name.

  The filter processing unit 240 extracts, from the acquired search result data, data of data items determined to have the user authority by the authority determination process. Then, the filter processing unit 240 transmits the extracted data, that is, the ValueObject indicating the search result data after the filtering process, to the search processing unit 230. The search processing unit 230 acquires ValueObject in which search result data after filtering processing is indicated. Note that the filter processing unit 240 may transmit the ValueObject indicating the search result data after the filtering process to the authority determination processing unit 220 or the service interface unit 210.

  The authority determination processing unit 220 acquires the value object indicating the search result data from the search processing unit 230. Then, the authority determination processing unit 220 transmits the acquired ValueObject to the service interface unit 210.

  The service interface unit 210 acquires the value object in which the search result data is indicated from the authority determination processing unit 220. Then, the service interface unit 210 generates a response message indicating the search result data. Further, the service interface unit 210 transmits the generated response message to the receipt ledger system 110.

  FIG. 3 shows a functional configuration example of the search processing unit 230. The search processing unit 230 includes a search unit 310. The search processing unit 230 further includes a pre-unique process execution unit 322, a column value generation unit 324, and a post-unique process execution unit 328.

  The search unit 310 acquires the value object transmitted from the authority determination processing unit 220. The search unit 310 identifies a service and a search parameter by referring to the acquired ValueObject. In addition, the search unit 310 specifies a data search process associated with the specified service by referring to the service definition file stored in the storage unit 250.

  And the search part 310 performs the data search process according to the specified service using the specified data search process. For example, the search unit 310 transmits a search query sentence such as an SQL sentence or an XML sentence corresponding to the specified service to a destination corresponding to the specified service.

  Thereby, the search unit 310 acquires search result data corresponding to the specified service. For example, the search unit 310 acquires search result data corresponding to the specified service from the elderly support system 121, the welfare system 122, or the common database 123.

  And the search part 310 produces | generates ValueObject which shows the acquired search result data. Further, the search unit 310 transmits the generated ValueObject to the authority determination processing unit 220.

  The pre-unique processing execution unit 322 performs pre-unique processing that is service-specific processing that should be performed before the data search processing by the search processing unit 230 is executed. For example, the pre-unique process execution unit 322 acquires service identification information from the search unit 310. Then, the pre-unique process execution unit 322 refers to the service definition file stored in the storage unit 250 so that the pre-unique process associated with the acquired service identification information is set as the pre-unique process to be executed. Identify. By defining the pre-unique process in the service definition file, the pre-unique process such as the validation check process can be easily managed.

  The column value generation unit 324 executes a column value generation logic that generates a service-specific data item value. For example, the column value generation unit 324 acquires service identification information from the search unit 310. Then, the column value generation unit 324 refers to the service definition file stored in the storage unit 250, thereby executing the column value generation logic associated with the acquired service identification information to be executed. As specified.

  The requester may request a data item that does not exist in any database. Even in such a case, the column value generation unit 324 can generate data of data items that do not exist in the database from the data of other data items acquired by the search unit 310. For example, it is assumed that the data source “birth date” exists in the database, but the requester requests a data item “age” that does not exist in any database. In this case, the column value generation unit 324 can generate data of the data item “age” based on the data item “birth date” acquired by the search unit 310.

  The post-specific processing execution unit 328 performs post-specific processing, which is service-specific processing that should be performed after the data search processing by the search processing unit 230 is executed. For example, the post-unique process execution unit 328 acquires service identification information from the search unit 310. Then, the post-specific process execution unit 328 refers to the service definition file stored in the storage unit 250, and performs the post-specific process associated with the acquired service identification information as the post-specific process to be executed. Identify. By defining the pre-specific processing in the service definition file, post-specific processing such as data processing can be easily managed.

  FIG. 4 shows a functional configuration example of the search unit 310. The search unit 310 includes a data search processing specification unit 400 and a service identification information acquisition unit 402. The search unit 310 includes a search parameter acquisition unit 412, a search query statement generation unit 414, a communication connection unit 416, a data acquisition unit 418, a first acquisition number identification unit 420, a second acquisition number identification unit 422, and a transmission number identification unit. 423, a transmission start position specifying unit 424, and a data transmitting unit 426.

  The service identification information acquisition unit 402 acquires service identification information for identifying a service transmitted from a data request source of data used in the service. For example, the service identification information acquisition unit 402 acquires the service identification information from the ValueObject acquired from the authority determination processing unit 220 via the communication connection unit 430.

  The data search process specifying unit 400 specifies a data search process associated with the service identification information acquired by the service identification information acquisition unit 402 from among a plurality of data search processes stored in the storage unit 250. The data search process specifying unit 400 includes a configuration information specifying unit 404, a processing program specifying unit 406, and a communication connection method specifying unit 410.

  The configuration information specifying unit 404 specifies the configuration information of the search query sentence that is associated with the service identification information acquired by the service identification information acquiring unit 402. For example, the configuration information specifying unit 404 specifies the configuration information of the SQL sentence. The configuration information of the search query statement includes a table name, a data item name, and a narrowing condition. The configuration information specifying unit 404 specifies the configuration information of the search query sentence associated with the service identification information acquired by the service identification information acquiring unit 402 by referring to the service definition file stored in the storage unit 250. May be.

  The processing program specifying unit 406 specifies a processing program associated with the service identification information acquired by the service identification information acquisition unit 402 from among a plurality of processing programs stored in the storage unit 250. The processing program specifying unit 406 may specify the processing program associated with the service identification information acquired by the service identification information acquiring unit 402 by referring to the service definition file stored in the storage unit 250. .

  For example, the processing program specifying unit 406 specifies a processing program for performing data search processing by database connection. In another example, the processing program specifying unit 406 specifies a processing program for performing a data search process through a Web service connection or an HTTP connection.

  When the processing program is DAO (Data Access Object) and is defined in the DAO definition file, the processing program specifying unit 406 refers to the service definition file stored in the storage unit 250 to thereby obtain service identification information. The DAO definition file that is associated with the URL may be specified. Then, the processing program specifying unit 406 may specify the DAO by referring to the specified DAO definition file.

  The communication connection method specifying unit 410 specifies a communication connection method associated with the service identification information acquired by the service identification information acquisition unit 402 from among a plurality of communication connection methods stored in the storage unit 250. The communication connection method specifying unit 410 may specify the communication connection method associated with the service identification information by referring to the service definition file stored in the storage unit 250.

  For example, the communication connection method specifying unit 410 specifies a database connection as the communication connection method. In another example, the communication connection method specifying unit 410 specifies a Web service connection or an HTTP connection as the communication connection method.

  When the communication connection method is defined in the system connection definition file, the communication connection method specifying unit 410 is associated with the service identification information by referring to the service definition file stored in the storage unit 250. A system connection definition file may be specified. Then, the communication connection method specifying unit 410 may specify the communication connection method by referring to the specified system connection definition file.

  The search parameter acquisition unit 412 acquires a search parameter transmitted from a data request source of data used in the service. For example, the search parameter acquisition unit 412 acquires the search parameter from the ValueObject acquired from the authority determination processing unit 220 via the communication connection unit 430. The search parameter acquisition unit 412 may further acquire identification information of unnecessary data items transmitted from the data request source. The search parameter acquisition unit 412 may further acquire the narrowing-down conditions transmitted from the data request source. The search parameter acquisition unit 412 may further acquire the sort condition transmitted from the data request source.

  The search query statement generation unit 414 generates a search query statement using the configuration information specified by the configuration information specification unit 404 and the search parameters acquired by the search parameter acquisition unit 412. For example, the search query statement generation unit 414 generates an SQL statement using the configuration information specified by the configuration information specification unit 404 and the search parameter acquired by the search parameter acquisition unit 412.

  When the search parameter acquisition unit 412 acquires identification information of unnecessary data items, the search query statement generation unit 414 may generate an SQL statement for acquiring data other than the unnecessary data items. When the search parameter acquisition unit 412 acquires the narrowing condition, the search query sentence generation unit 414 may generate an SQL sentence for acquiring data that matches the narrowing condition. When the search parameter acquisition unit 412 acquires a sort condition, the search query statement generation unit 414 may generate a search query statement in which search result data is sorted according to the acquired sort condition.

  The communication connection unit 416 establishes communication connection to the data acquisition destination of the data used in the service by the communication connection method specified by the communication connection method specifying unit 410. For example, the communication connection unit 416 communicates with a data acquisition destination by a communication connection method such as a database connection by a JDBC driver, a Web service connection, or an HTTP connection.

  The data acquisition unit 418 acquires data used in the service by the data search process specified by the data search process specifying unit 400. Specifically, the data acquisition unit 418 acquires data used in the service by the processing program specified by the processing program specifying unit 406. Further, the data acquisition unit 418 acquires data used in the service by the communication connection method specified by the communication connection method specifying unit 410.

  Further, the data acquisition unit 418 acquires, from the database, the number of acquisition data specified by the first acquisition number specification unit 420 among the data searched from the database by the search inquiry sentence generated by the search inquiry sentence generation unit 414. May be.

  If the number of data items corresponding to the search query statement is greater than the number of acquisition items specified by the first acquisition number specification unit 420, the data acquisition unit 418 specifies the number of acquisition items specified by the first acquisition number specification unit 420. May be obtained from a database. The data acquisition unit 418 may perform a predetermined error process when the number of data items corresponding to the search query statement is greater than the acquisition number specified by the first acquisition number specification unit 420.

  Both the first acquisition number specifying unit 420 and the second acquisition number specifying unit 422 may specify the number of acquisitions. At this time, when the number of acquisitions specified by the second acquisition number specifying unit 422 is smaller than the number of acquisitions acquired by the first acquisition number specifying unit, the data acquisition unit 418 is specified by the second acquisition number specifying unit 422. The number of acquisition data may be acquired from the database. On the other hand, when the number of acquisitions specified by the second acquisition number specifying unit 422 is larger than the number of acquisitions specified by the first acquisition number specifying unit 420, the data acquisition unit 418 acquires the acquisition specified by the first acquisition number specifying unit 420. The number of data items may be acquired from the database.

  When the search query statement generation unit 414 generates a search query statement, the data acquisition unit 418 may acquire data used in the service based on the generated search query statement. For example, when the search query statement generation unit 414 generates an SQL statement, the data acquisition unit 418 may acquire data used in the service from the generated SQL statement.

  The first acquisition number specifying unit 420 specifies the number of acquisitions associated with the service identification information acquired by the service identification information acquisition unit 402. For example, the first acquisition number specifying unit 420 specifies the number of acquisitions associated with the service identification information by referring to the service definition file stored in the storage unit 250.

  The second acquisition number specifying unit 422 specifies the number of acquisitions requested by the data request source of data used in the service. For example, the second acquisition number specifying unit 422 specifies the number of acquisitions requested by the data request source by referring to the ValueObject acquired from the authority determination processing unit 220 via the communication connection unit 430.

  The transmission number specifying unit 423 specifies the number of transmissions requested by the data request source of data used in the service. For example, the transmission number specifying unit 423 specifies the number of transmissions requested by the data request source by referring to the ValueObject acquired from the authority determination processing unit 220 via the communication connection unit 430.

  The transmission start position specifying unit 424 specifies the data transmission start position requested by the data request source. For example, the transmission start position specifying unit 424 specifies the transmission start position by referring to the ValueObject acquired from the authority determination processing unit 220 via the communication connection unit 430.

  The data transmission unit 426 transmits the data acquired by the data acquisition unit 418 to the data request source. For example, the data transmission unit 426 generates a value object indicating the data acquired by the data acquisition unit 418 and then transmits the generated value object to the authority determination processing unit 220 via the communication connection unit 430.

  When the transmission number specifying unit 423 specifies the number of transmissions, the data acquisition unit 418 specifies the transmission number specifying unit 423 out of the data searched from the database by the search inquiry sentence generated by the search inquiry sentence generation unit 414. Data on the number of transmissions may be acquired from a database. In addition, when the transmission start position specifying unit 424 specifies the transmission start position, the data acquisition unit 418 specifies the transmission start position among the data searched from the database by the search query sentence generated by the search query sentence generation unit 414. Data from the transmission start position specified by the unit 424 may be acquired from the database.

  FIG. 5 shows an example of a request message received by the data search system 100. The request message includes a header portion 510 indicated by a “header” tag and a body portion 520 indicated by a “body” tag.

  In header section 510, user information used for authority determination processing by authority determination processing section 220 and filtering processing by filter processing section 240 is shown in the “auth” tag. In the “auth” tag, identification information of a user who uses the service at the data request source is set in the “userid” tag. In the “auth” tag, a user information group related to the user is set in the “params” tag.

  In the “params” tag, a parameter value of user information is set in “param”. In addition, a user information name is set in the “name” attribute of the “param” tag. For example, the request message shown in FIG. 5 indicates that the data requesting user is the “section manager” of “XX section” having the personal ID “0000000001”.

  In the body part 520, service identification information is set in the “serviceName” attribute of the “request” tag. For example, in the request message shown in FIG. 5, “Jumin” is set as the service identification information. That is, the request message shown in FIG. 5 indicates that the request message is a request message for requesting the “Jumin” service.

  In the body part 520, a search parameter group used for data search processing is set in the “params” tag. Within the “params” tag, the parameter value of the search parameter is set in the “param” tag. In addition, a logical name of a data item used as a search parameter is set in the “itemName” attribute of the “param” tag. The logical name indicates the name of a data item that is disclosed to the data requesting system. For example, the request message shown in FIG. 5 indicates that the data search system 100 is requested to perform data search processing for searching only data in which the data item “gender” is set to “male”.

  In the body part 520, a “condition” tag is set with a narrowing condition used for data search processing. In the body part 520, an unnecessary data item group is set in the “unnecessaries” tag in the data request source. In the “unnecessaries” tag, the logical name of the unnecessary data item is set in the “name” attribute of the “item” tag. For example, in the request message shown in FIG. 5, “address” and “telephone number” are set as logical names of unnecessary data items.

  In the body part 520, a sort condition for search result data is set in the “order” tag. Within the “order” tag, the “name” attribute of the “item” tag is set with the logical name of the data item as the key item for sorting. In addition, “asc (ascending order)” or “desc (descending order)” is set in the “order” attribute of the “item” tag. For example, the request message shown in FIG. 5 indicates that the data search system 100 is requested to sort the data item “personal number” in ascending order.

  In the body part 520, the transmission start position of the search result data is set in the “startRecord” tag. In the “requestCount” tag, the number of transmissions of search result data is set. For example, the request message shown in FIG. 5 indicates that the data search system 100 is requested to transmit “3” records from the “1” -th record of the search result data.

  In the body part 520, the number of data acquisitions from the database is set in the “maxCount” tag. For example, the request message shown in FIG. 5 indicates that the data retrieval system 100 is requested to retrieve “10” data from the database.

  In the body part 520, the “expired” tag is set with a timeout time during DB access. For example, the request message shown in FIG. 5 indicates that the data search system 100 is requested to time out when “3” seconds or more have elapsed.

  FIG. 6 shows an example of a service definition file stored in the storage unit 250. In the service definition file, service definition information, which is information for specifying a data search process depending on the service, is set in a “service” tag. In the service definition file, service definition information of a plurality of services can be set in a “services” tag.

  In the service definition file, service identification information is set in the “name” tag. For example, “Jumin” is set as service identification information in the service definition file shown in FIG. That is, the service definition shown in FIG. 6 indicates that the service definition is service definition information for specifying data search processing depending on the “Jumin” service.

  In the service definition file, a filtering condition name used for the filtering process by the filter processing unit 240 is set in the “filteringName” tag. In the service definition file, a “daoName” tag is set with a DAO name for identifying a DAO class for performing data search processing. In the “daoServiceName” tag, a DAO service name for specifying a system connection definition file in which a method for performing data search processing and a communication connection method are defined is set.

  In the service definition file, a processing program name used for the pre-unique process by the pre-unique process execution unit 322 is set in the “preLogicalName” tag. In the “postLogicName” tag, a processing program name used for the post-specific processing by the post-specific processing execution unit 328 is set. In addition, a name of a processing program that generates a narrowing-down condition that constitutes a search query statement is set in the “conditionLogic” tag. In addition, the number of data acquisitions from the database is set in the “maxCount” tag.

  In the service definition file, configuration information for generating a search query sentence used for data search processing is set in the “sql” tag. Within the “sql” tag, a plurality of data items to be acquired are set in the “select” tag.

  Within the “select” tag, the “name” attribute of the “item” tag is set to the logical name of the data item to be acquired. The “hide” attribute of the “item” tag is set to “true” when the data item is transmitted to the data request source, and when the data item is acquired from the database but not transmitted to the data request source. “False” is set.

  Within the “select” tag, the “value” attribute of the “column” tag is set to the column name of the data item to be acquired. In the “from” tag, the table name of the data acquisition destination is set. In the “where” tag, a narrowing condition is set. A sort condition is set in the “order” tag.

  For example, the search processing unit 230 can generate the following search query sentence from the configuration information shown in FIG. “Select kojin_no, name, name_kana, address, tel, first, blood, sex from JuminTbl where blood = A and sex =? Order by name”.

  FIG. 7 shows an example of data search processing by the search unit 310. In FIG. 7, an example of data search processing by database connection to the common database 123 will be described. Note that the data search process by database connection to the welfare system 122 is the same as the data search process by database connection to the common database 123, and thus the description thereof is omitted.

  First, the search unit 310 acquires a ValueObject from the authority determination processing unit 220 (S701). In ValueObject, service identification information, unnecessary data items, sort conditions, and search parameters transmitted from the data request source are shown. Next, the search unit 310 acquires a service definition file associated with the service identification information acquired in S701 from a plurality of service definition files stored in the storage unit 250 (S702).

  Next, the search unit 310 refers to the acquired service definition file to identify the configuration information of the search query statement used for the data search process (S703). And the search part 310 produces | generates a search inquiry sentence using the structure information specified by S703, and the search parameter acquired by S701 (S704).

  Here, the search unit 310 generates a search query statement for acquiring all data items including the unnecessary data item acquired in S701. In another example, the search unit 310 may generate a search query statement for acquiring a data item other than the unnecessary data item acquired in S701. For example, the search unit 310 may generate a search query statement that acquires data items other than the data item “address” and the data item “tel”. In addition, the search unit 310 generates a search query statement in which the search result data is sorted according to the sort condition acquired in S701. For example, in the example illustrated in FIG. 7, the search unit 310 generates a search query sentence that is sorted in ascending order by the data item “konjin_no”. When the sort condition is indicated in both the service definition file and the request message, the search unit 310 may generate the search query message by using the sort condition indicated in the request message with priority.

  Next, the search unit 310 refers to the DAO definition file stored in the storage unit 250 (S705), and specifies the processing program associated with the service identification information acquired in S701 (S706). For example, in the example illustrated in FIG. 7, first, the search unit 310 refers to the service definition file acquired in S <b> 702 to identify “Jumin_dao” as the DAO name associated with the service identification information “Jumin”. . In addition, “Select” is specified as the DAO service name associated with the service identification information “Jumin”. Then, the search unit 310 refers to the DAO definition file stored in the storage unit 250 to identify the DAO class “RdbmsSelectDAO” associated with the DAO name “Jumin_dao”. Also, the method “select” associated with the DAO service name “Select” is specified.

  Next, the search unit 310 connects to the database by executing the processing program specified in S706 (S707), and transmits the search query generated in S704 to the connection destination database (S708). Thereby, the search unit 310 acquires search result data from the connection destination database (S709). Then, the search unit 310 transmits ValueObject indicating the acquired search result data to the authority determination processing unit 220 (S710). When performing the filtering process by the filter processing unit 240, the search unit 310 may transmit the ValueObject indicating the acquired search result data to the filter processing unit 240. When all data items including unnecessary data items are acquired in S709, in S710, data items other than unnecessary data items are transmitted to the authority determination processing unit 220 as search result data in the acquired search result data. May be.

  FIG. 8 shows another example of data search processing by the search unit 310. In FIG. 8, an example of data search processing by web service connection to the elderly support system 121 will be described.

  First, the search unit 310 acquires a value object from the authority determination processing unit 220 (S801). In ValueObject, service identification information, unnecessary data items, sort conditions, and search parameters transmitted from the data request source are shown. Next, the search unit 310 acquires a service definition file associated with the service identification information acquired in S801 from a plurality of service definition files stored in the storage unit 250 (S802).

  Next, the search unit 310 refers to the acquired service definition file to identify the configuration information of the search query statement used for the data search process (S803). Then, the search unit 310 generates a search query sentence using the configuration information specified in S803 and the search parameters acquired in S801 (S804).

  Here, the search unit 310 generates a search query statement for acquiring all data items including the unnecessary data item acquired in S801. In another example, a search query statement for acquiring a data item other than the unnecessary data item acquired in S801 may be generated. For example, the search unit 310 may generate a search query statement that acquires data items other than the data item “address” and the data item “tel”. In addition, the search unit 310 generates a search query statement in which the search result data is sorted according to the sort condition acquired in S801. For example, in the example illustrated in FIG. 8, the search unit 310 generates a search query sentence that is sorted in ascending order by the data item “konjin_no”.

  Next, the search unit 310 refers to the DAO definition file stored in the storage unit 250 (S805), and identifies the processing program associated with the service identification information acquired in S801 (S806). For example, in the example illustrated in FIG. 8, first, the search unit 310 refers to the service definition file acquired in S <b> 802 to identify “Kouriseya_dao” as the DAO name associated with the service identification information “Kouriseya”. . In addition, “Kouriseya_Web_Connect” is specified as the DAO service name associated with the service identification information “Kouriseya”. Then, the search unit 310 refers to the DAO definition file stored in the storage unit 250 to identify the DAO class “SystemCoopDAO” associated with the DAO name “Kouriseya_dao”. In addition, the method “execute” associated with the DAO service name “Kouriseya_Web_Connect” is specified.

  Next, the search unit 310 refers to the system connection definition file stored in the storage unit 250 (S807), and specifies the communication connection method associated with the service identification information acquired in S801 (S808). ). For example, in the example illustrated in FIG. 8, first, the search unit 310 refers to the service definition file acquired in S802 to identify “Kouriseya_Web_Connect” as the DAO service name associated with the service identification information “Kouriseya”. To do. Then, the search unit 310 refers to the system connection definition file stored in the storage unit 250, so that the GW (gateway) associated with the system connection service “Kouriseya_Web_Connect” having the same name as the DAO service name “Kouresia_Web_Connect” is obtained. The connection information such as the implementation class “Kouriseya WebConnect”, the connection method (Web service connection), and uri is specified.

  Next, the search unit 310 executes communication processing using the communication connection method specified in S808 by executing the processing program specified in S806 (S809). Specifically, the search unit 310 executes the method “execute” of the DAO class “SystemCoopDAO”. The method “execute” performs communication connection to the connection destination system by calling the GW implementation class “KouriseyaWebConnect” as a system connection service. Then, the search unit 310 transmits the search query generated in S804 to the connection destination system in a format requested by the connection destination system (S810). For example, in the example illustrated in FIG. 8, the search unit 310 transmits the search query sentence generated in S804 in XML format. Accordingly, the search unit 310 acquires search result data from the connection destination system (S811). Then, the search unit 310 transmits ValueObject indicating the acquired search result data to the authority determination processing unit 220 (S812). When performing the filtering process by the filter processing unit 240, the search unit 310 may transmit the ValueObject indicating the acquired search result data to the filter processing unit 240. When all data items including unnecessary data items are acquired in S811, in S812, data items other than unnecessary data items are transmitted as search result data to the authority determination processing unit 220 in the acquired search result data. May be.

  Thus, according to the data search system 100 of this embodiment, the data search process can be defined in advance for each of a plurality of services. As a result, it is possible to perform appropriate data search processing corresponding to the service for each of the plurality of services.

  Further, according to the data search system 100 of the present embodiment, the data request source can cause the data search system 100 to perform the data search process simply by transmitting the service identification information to the data search system 100. For this reason, it is not necessary to implement data search processing at the data request source, and the system configuration of the data request source can be simplified.

  Further, according to the data search system 100 of the present embodiment, the service interface unit 210 has a common interface for receiving a request for data search processing. For this reason, when a data request source is added, the added data request source can reuse the interface implemented in the existing data request source.

  Further, according to the data search system 100 of the present embodiment, settings for data search processing can be collectively managed by the service definition file. Therefore, even when a service is added, it is possible to easily set data search processing for the added service.

  Further, according to the data search system 100 of the present embodiment, a processing program and a communication connection method used for data search processing can be shared by a plurality of services. Therefore, even when a service is added, there is no need to provide a processing program and a communication connection method for the added service. The added service can use the processing program and communication connection method used by the existing service.

  Further, according to the data search system 100 of the present embodiment, the data search process can be shared by a plurality of services by sharing the service definition file by a plurality of services. As a result, the cached data search process can be used effectively, so that the processing efficiency of the data search process can be improved. Specifically, for example, even when a plurality of data requesters perform the same search, if each data requester executes a different SQL statement from the other data requesters, the cache effect of RDMS Can't get. According to the data search system 100 of the present embodiment, a search service for performing a similar search is defined and defined, and a plurality of data use sources share the same, so that each of a plurality of data request sources has the same SQL. Since the statement can be executed, the cache effect of RDMS can be obtained, and the processing efficiency of the data search process can be improved.

  FIG. 9 shows an example of data acquisition processing by the data acquisition unit 418 and data transmission processing by the data transmission unit 426. FIG. 9 shows an example of acquiring data from the common database 123.

  First, the data acquisition unit 418 acquires the number of acquisitions associated with the service identification information from the first acquisition number identification unit 420 (S901). For example, the data acquisition unit 418 acquires “50” as the number of acquisitions associated with the service identification information.

  Next, the data acquisition unit 418 acquires the number of acquisitions requested by the data requester from the second acquisition number identification unit 422 (S902). For example, the data acquisition unit 418 acquires “100” as the number of acquisitions requested by the data request source.

  The number of acquisitions acquired from the second acquisition number identification unit 422 is greater than the number of acquisitions acquired from the first acquisition number identification unit 420. For this reason, the data acquisition unit 418 permits the search result data for “50”, which is the number of acquisitions acquired from the first acquisition number specifying unit 420, to be acquired from the common database 123. Therefore, even if “50” or more hits are found as search result data, the data acquisition unit 418 permits acquisition of “50” search result data from the common database 123 (S903).

  Next, the data transmission unit 426 acquires the number of transmissions requested by the data requester from the transmission number identification unit 423 (S904). For example, the data transmission unit 426 acquires “5” as the number of transmissions requested by the data request source. Next, the data transmission unit 426 acquires the transmission start position requested by the data requester from the transmission start position specifying unit 424 (S905). For example, the data transmission unit 426 acquires “1” as the transmission start position requested by the data request source.

  Then, the data transmission unit 426 acquires “5” records from the “1” -th record in the search result data permitted to be acquired by the data acquisition unit 418 (S906). For example, the data transmission unit 426 fetches “5” records from the “1” -th record among the “50” search result data permitted to be acquired from the common database 123 and stores them in the memory. Get expanded above. Then, the data transmission unit 426 transmits the acquired record and information indicating that the next record exists to the authority determination processing unit 220 (S907).

  Subsequently, for example, the data transmission unit 426 acquires “10” as the number of transmissions requested by the data requester (S908). Further, the data transmission unit 426 acquires “6” as the transmission start position requested by the data request source (S909).

  In this case, the data transmission unit 426 acquires “10” records from the “6” th record in the search result data permitted to be acquired by the data acquisition unit 418 (S910). For example, the data transmission unit 426 fetches “10” records from the “6” -th record among the “50” search result data permitted to be acquired from the common database 123 and stores them in the memory. Get expanded above. Then, the data transmission unit 426 transmits the acquired record and information indicating that the next record exists to the authority determination processing unit 220 (S911).

  Subsequently, the transmission start position acquired from the transmission start position specifying unit 424 may be “51” or later. In addition, the sum of the transmission start position acquired from the transmission start position specifying unit 424 and the number of transmissions acquired from the transmission number specifying unit 423 may be “51” or more. In these cases, the data acquisition unit 418 may allow the search result data for the “51” th and subsequent items to be further acquired from the common database 123, or may perform predetermined error processing.

  Thus, according to the present embodiment, the number of acquisition cases can be defined for each of a plurality of services. Thereby, in each of the plurality of services, the optimum number of data unique to the service can be acquired from the database.

  Further, according to the present embodiment, the number of acquisitions requested by the data request source can be acquired from the data request source. Thereby, in each of the plurality of services, the optimum number of data corresponding to the data requesting system can be acquired from the database.

  Further, according to the present embodiment, the number of transmissions requested by the data request source can be acquired from the data request source. Thereby, in each of the plurality of services, the optimum number of data corresponding to the data requesting system can be transmitted to the data requesting source.

  Further, according to the present embodiment, when the number of acquisitions acquired from the data request source exceeds the number of acquisitions previously associated with the service, the data on the number of acquisitions previously associated with the service is stored in the database. Get from. Thereby, in the data search system 100, it is possible to prevent a large amount of resources from being occupied in the data search process of one service.

  FIG. 10 shows an example of authority determination processing by the authority determination processing unit 220. First, the authority determination processing unit 220 acquires a value object from the service interface unit 210 (S1001). In the acquired ValueObject, service identification information, user information, and search parameters are shown.

  In the example shown in FIG. 10, “Basic Resident Information Acquisition Service” is shown as service identification information in the acquired ValueObject. In addition, “XX section” is shown as the department name of the user information. In addition, “section manager” is shown as the title of the user information.

  Next, the authority determination processing unit 220 refers to the authority determination rule definition file stored in the storage unit (S1002), and specifies the authority determination rule associated with the acquired service identification information (S1003). ). In the example illustrated in FIG. 10, the authority determination processing unit 220 identifies “REF” as the “required authority level” of the authority determination rule associated with the service identification information “resident basic information acquisition service”. Also, “A” is specified as the “rule class” of the authority determination rule associated with the service identification information “resident basic information acquisition service”.

  In this embodiment, “UPD”, “REF”, and “NON” are used as authority level parameters. “UPD” indicates that there is an update authority. “REF” indicates that there is no update authority, but there is a reference authority. “NON” indicates that neither update authority nor reference authority exists.

  Next, the authority determination processing unit 220 acquires the specified rule class “A” from the plurality of rule classes stored in the storage unit 250 (S1004). Then, the authority determination processing unit 220 identifies an “authority level” given to the user based on the user information acquired from the service interface unit 210 and the rule class acquired from the storage unit 250 (S1005). In the example illustrated in FIG. 10, the authority determination processing unit 220 identifies “UPD” as the “authority level” given to the “section manager” of “XXX section”.

  Next, the authority determination processing unit 220 determines the authority by comparing the specified “required authority level” with the specified “authority level” (S1006). Here, the authority determination processing unit 220 may determine that there is an authority when the specified “authority level” is equal to or higher than the specified “required authority level”. The authority determination processing unit 220 may determine that there is no authority when the specified “authority level” is less than the specified “required authority level”. In the example illustrated in FIG. 10, the authority determination processing unit 220 has authority because “UPD” that is the specified “authority level” is equal to or higher than “REF” that is the specified “required authority level”. The “section manager” of “XX section” determines that he / she has the authority to use “basic information acquisition service”.

  When the authority determination processing unit 220 determines that there is an authority, the authority determination processing unit 220 transmits value object indicating service identification information and search parameters to the search processing unit 230 (S1007). As a result, the authority determination processing unit 220 requests the search processing unit 230 to perform a data search process. The authority determination processing unit 220 may transmit the ValueObject acquired from the service interface unit 210 to the search processing unit 230.

  FIG. 11 shows another example of authority determination processing by the authority determination processing unit 220. First, the authority determination processing unit 220 acquires a value object from the service interface unit 210 (S1101). In the acquired ValueObject, service identification information, user information, and search parameters are shown.

  In the example shown in FIG. 11, “Resident Income Information Acquisition Service” is shown as service identification information in the acquired ValueObject. In addition, “△△ section” is shown as the department name of the user information. In addition, “Deputy Director” is shown as the title of the user information.

  Next, the authority determination processing unit 220 refers to the authority determination rule definition file stored in the storage unit (S1102), and specifies the authority determination rule associated with the acquired service identification information (S1103). ). In the example illustrated in FIG. 11, the authority determination processing unit 220 identifies “REF” as the “required authority level” of the authority determination rule associated with the service identification information “resident income information acquisition service”. Also, “B” is specified as the “rule class” of the authority determination rule associated with the service identification information “resident basic information acquisition service”.

  Next, the authority determination processing unit 220 acquires the specified rule class “B” from the plurality of rule classes stored in the storage unit 250 (S1104). Then, the authority determination processing unit 220 identifies the “authority level” given to the user based on the user information acquired from the service interface unit 210 and the rule class acquired from the storage unit 250 (S1105). In the example illustrated in FIG. 11, the authority determination processing unit 220 identifies “NON” as the “authority level” given to the “next length” of “ΔΔ section”.

  Next, the authority determination processing unit 220 determines the authority by comparing the specified “required authority level” with the specified “authority level” (S1106). In the example illustrated in FIG. 11, the authority determination processing unit 220 has no authority because the identified “authority level” “NON” is less than the identified “required authority level” “REF”. The “deputy manager” of “△△ section” determines that he does not have the authority to use the “resident income information acquisition service”. When determining that there is no authority, the authority determination processing unit 220 transmits a ValueObject indicating the result of the authority determination process to the service interface unit 210 (S1107).

  Thus, according to the data search system 100 of this embodiment, the authority determination rule is defined for each of a plurality of services. For this reason, it is possible to perform a service-specific authority determination process for each of a plurality of services.

  Further, according to the data search system 100 of the present embodiment, the authority determination process is performed at the user attribute level such as a department name and job title. For this reason, it is possible to collectively set and change authority determination rules for a plurality of user IDs.

  Further, according to the data search system 100 of the present embodiment, the authority determination rules are collectively managed by the authority determination rule definition file. For this reason, even when a service is added, the authority determination rule for the added service can be easily set.

  FIG. 12 shows an example of filtering processing by the filter processing unit 240. First, the filter processing unit 240 acquires a ValueObject from the search processing unit 230 (S1201). In the acquired ValueObject, service identification information, user information, and search result data are shown.

  In the example shown in FIG. 12, “Resident Income Information Acquisition Service” is shown as service identification information in the acquired ValueObject. In addition, “△△ section” is shown as the department name of the user information. In addition, “Deputy Director” is shown as the title of the user information. In addition, search result data including three data items “sex”, “age”, and “name” is shown.

  Next, the filter processing unit 240 identifies the filtering condition associated with the acquired service identification information by referring to the service definition file stored in the storage unit (S1202). In the example illustrated in FIG. 12, the filter processing unit 240 identifies “condition A” as the filtering condition associated with the service identification information “resident income information acquisition service”.

  Next, the filter processing unit 240 refers to the filtering condition definition file stored in the storage unit 250 (S1203), and determines the authority determination rule from the specified filtering condition for each data item of the acquired search result data. (S1204). In the example illustrated in FIG. 12, the filter processing unit 240 identifies “UPD” as the “required authority level” of the data item “sex” from the filtering condition “condition A”. In addition, “A” is specified as the “rule class” of the data item “sex”.

  Further, “UPD” is specified as the “required authority level” of the data item “age”. Further, “B” is specified as the “rule class” of the data item “age”. In addition, “REF” is specified as the “required authority level” of the data item “name”. Further, “B” is specified as the “rule class” of the data item “name”.

  Next, the filter processing unit 240 acquires the specified rule classes “A” and “B” from the plurality of rule classes stored in the storage unit 250 (S1205). Then, the filter processing unit 240 identifies the “authority level” given to the user for each data item based on the user information acquired from the service interface unit 210 and the rule class acquired from the storage unit 250. (S1206).

  In the example illustrated in FIG. 12, the filter processing unit 240 identifies “UPD” as the “authority level” for the data item “sex” given to the “next length” of “ΔΔ section”. In addition, the filter processing unit 240 specifies “REF” as the “authority level” for the data item “age” given to the “next length” of “△△ section”. Further, the filter processing unit 240 specifies “REF” as the “authority level” for the data item “name” given to the “next manager” of “△△ section”.

  Next, the filter processing unit 240 determines the authority for each data item by comparing the specified “required authority level” with the specified “authority level” (S1207). In the example illustrated in FIG. 12, the filter processing unit 240 uses the “required authority level” specified for the data item “sex” as “UPD”, which is the “authority level” specified for the data item “sex”. Since it is equal to or higher than a certain “UPD”, it is determined that there is an authority, that is, the “next length” of “△△ section” has the authority to refer to the data item “sex”.

  Further, the filter processing unit 240 has “REF”, which is the “authority level” specified for the data item “age”, less than “UPD”, which is the “necessary authority level” specified for the data item “age”. Therefore, it is determined that there is no authority, that is, the “next manager” of “△△ section” has no authority to refer to the data item “age”. Further, the filter processing unit 240 determines that “REF”, which is the “authority level” specified for the data item “name”, is equal to or higher than “REF”, which is the “necessary authority level” specified for the data item “name”. Therefore, it is determined that there is an authority, that is, the “next manager” of “△△ section” has the authority to refer to the data item “name”.

  The filter processing unit 240 extracts, from the acquired search result data, data of “sex” and “name” which are data items determined to have the user authority by the authority determination process. Then, the filter processing unit 240 transmits the extracted data, that is, the ValueObject indicating the search result data after the filtering process, to the search processing unit 230 (S1208). The filter processing unit 240 may transmit the ValueObject indicating the search result data after the filtering process to the authority determination processing unit 220 or the service interface unit 210.

  Thus, according to the data search system 100 of this embodiment, the authority determination rule is set at the data item level for each of a plurality of services. Therefore, service-specific filtering processing can be performed on each of a plurality of services at the data item level.

  Further, according to the data search system 100 of this embodiment, the filtering condition and the authority determination rule at the data item level are collectively managed by the filtering condition definition file. For this reason, even if a data item is added, the authority determination rule for the added data item can be easily set.

  Further, according to the data search system 100 of the present embodiment, the filtering process at the data item level is performed at the user attribute level such as the department name and the job title. For this reason, it is possible to collectively set and change filtering conditions for a plurality of user IDs.

  Further, according to the data search system 100 of the present embodiment, the filtering process is concentrated on the data search system 100. For this reason, the data request source and data acquisition destination systems do not need to implement filtering processing.

  Further, according to the data search system 100 of the present embodiment, the filtering process by the filter processing unit 240 is performed independently of the data search process by the search processing unit 230. Therefore, the search processing unit 230 can perform the filtering process with a common mechanism that does not depend on the communication connection method of the data acquisition destination.

  FIG. 13 shows an example of the hardware configuration of the data search system 100. The data search system 100 includes a CPU peripheral unit having a CPU 1505, a RAM 1520, a graphic controller 1575, and a display device 1580 that are connected to each other by a host controller 1582. The data search system 100 also includes an input / output unit having a communication I / F 1530, a hard disk drive 1540, and a CD-ROM drive 1560 that are connected to a host controller 1582 by an I / O (input / output) controller 1584. The data search system 100 further includes a legacy input / output unit having a ROM 1510, an FD (flexible disk) drive 1550, and an I / O (input / output) chip 1570 connected to the I / O controller 1584.

  The host controller 1582 connects the RAM 1520 to the CPU 1505 and the graphic controller 1575 that access the RAM 1520 at a high transfer rate. The CPU 1505 operates based on programs stored in the ROM 1510 and the RAM 1520 to control each unit. The graphic controller 1575 acquires image data generated by the CPU 1505 or the like on a frame buffer provided in the RAM 1520 and displays the image data on the display device 1580. Alternatively, the graphic controller 1575 may include a frame buffer that stores image data generated by the CPU 1505 or the like.

  The I / O controller 1584 connects the host controller 1582 to the communication I / F 1530, the hard disk drive 1540, and the CD-ROM drive 1560, which are relatively high-speed input / output devices. The communication I / F 1530 communicates with an external 1598 via a network. The hard disk drive 1540 stores programs and data used by the CPU 1505. The CD-ROM drive 1560 reads a program or data from the CD-ROM 1595 and provides it to the hard disk drive 1540 via the RAM 1520.

  The I / O controller 1584 is connected to the ROM 1510, the FD drive 1550, and the relatively low-speed input / output device of the I / O chip 1570. The ROM 1510 stores a boot program executed by the CPU 1505 when the data retrieval system 100 is activated, a program depending on the hardware of the data retrieval system 100, and the like. The FD drive 1550 reads a program or data from the flexible disk 1590 and provides it to the hard disk drive 1540 via the RAM 1520. The I / O chip 1570 connects various input / output devices via the FD drive 1550, for example, a parallel port, a serial port, a keyboard port, a mouse port, and the like.

  A program provided to the hard disk drive 1540 via the RAM 1520 is stored in a recording medium such as the flexible disk 1590, the CD-ROM 1595, or an IC card and provided by the user. The program is read from the recording medium, installed in the hard disk drive 1540 in the data search system 100 via the RAM 1520, and executed by the CPU 1505. The program installed and executed in the data search system 100 works on the CPU 1505 or the like to cause the computer to function as each functional unit included in the data search system 100 described with reference to FIGS.

  As mentioned above, although this invention was demonstrated using embodiment, the technical scope of this invention is not limited to the range as described in the said embodiment. It will be apparent to those skilled in the art that various modifications or improvements can be added to the above-described embodiment. It is apparent from the scope of the claims that the embodiments added with such changes or improvements can be included in the technical scope of the present invention.

An example of the administrative system 10 which concerns on embodiment is shown. 1 illustrates an example functional configuration of a data search system 100 according to an embodiment. An example of a functional configuration of the search processing unit 230 is shown. An example of a functional configuration of the search unit 310 is shown. An example of a request message received by the data search system 100 is shown. An example of a service definition file stored in the storage unit 250 is shown. An example of the data search process by the search part 310 is shown. Another example of data search processing by the search unit 310 is shown. An example of the data transmission process by the data transmission part 426 is shown. An example of authority determination processing by the authority determination processing unit 220 will be described. Another example of authority determination processing by the authority determination processing unit 220 is shown. An example of the filtering process by the filter process part 240 is shown. 2 shows an example of a hardware configuration of a data search system 100.

Explanation of symbols

DESCRIPTION OF SYMBOLS 10 Administration system 100 Data search system 110 Receiving ledger system 121 Elderly person support system 122 Life protection system 123 Common database 210 Service interface part 220 Authority determination process part 230 Search process part 240 Filter process part 250 Storage part 310 Search part 322 Pre-specific process Execution unit 324 Column value generation unit 328 Post-specific processing execution unit 400 Data search processing specification unit 402 Service identification information acquisition unit 404 Configuration information specification unit 406 Processing program specification unit 410 Communication connection method specification unit 412 Search parameter acquisition unit 414 Search query statement Generation unit 416 Communication connection unit 418 Data acquisition unit 420 First acquisition number specifying unit 422 Second acquisition number specifying unit 423 Transmission number specifying unit 424 Transmission start position specifying unit 426 Data transmission 430 communication connection unit 510 the header portion 520 the body part 1505 CPU
1510 ROM
1520 RAM
1530 Communication I / F
1540 Hard disk drive 1550 FD drive 1560 CD-ROM drive 1570 I / O chip 1575 Graphic controller 1580 Display device 1582 Host controller 1584 I / O controller 1590 Flexible disk 1595 CD-ROM
1598 External

Claims (11)

According to the information retrieval service selected by the data requesting system, which is a data requesting system among the plurality of information retrieving services, having a function of providing a plurality of information retrieving services that retrieve and provide data from a database data a data retrieval system for retrieving from said database Te,
Said data request sent from the source system, service identification information acquisition unit that acquires service identification information for the data requesting system to identify the selected information retrieval services,
A search parameter acquisition unit for acquiring identification information of unnecessary data items transmitted from the data request source system;
A storage unit that stores definition information in which a plurality of pieces of service identification information for identifying the plurality of information search services are associated with search query sentence configuration information;
A configuration information specifying unit that specifies the configuration information associated with the service identification information acquired by the service identification information acquisition unit by referring to the definition information stored in the storage unit;
A search query statement generating unit that generates a search query statement using the configuration information specified by the configuration information specifying unit;
A data acquisition unit that acquires the data by the search query statement generated by the search query statement generation unit;
A data transmission unit that transmits the data acquired by the data acquisition unit to the data requesting system ;
The configuration information includes information indicating a data item to be acquired from which data is to be acquired from the database, and whether to transmit data of the data item to be acquired to the request source.
The search query generator generates data items of data items including the unnecessary data items that are the data items to be acquired indicated by the information included in the configuration information specified by the configuration information specifying unit. Generate a search query to search from
The data acquisition unit acquires the data from the database by transmitting the search query statement generated by the search query statement generation unit to the database,
The data item indicating that the data transmitting unit transmits to the request source by information included in the configuration information specified by the configuration information specifying unit among the data acquired by the data acquiring unit from the database And a data search system for transmitting data of data items other than the unnecessary data items to the data requesting system.   A first acquisition number specifying unit for specifying the number of acquisitions of data associated with the service identification information acquired by the service identification information acquisition unit;
  A second acquisition number specifying part for specifying the number of data acquisitions requested by the data requesting system;
Further comprising
  When the number of acquisitions specified by the second acquisition number specifying unit is smaller than the number of acquisitions specified by the first acquisition number specifying unit, the data acquisition unit specifies the number of acquisitions specified by the second acquisition number specifying unit. The search query statement generated by the search query statement generation unit is retrieved from the database with the upper limit of
The data search system according to claim 1.   According to the information retrieval service selected by the data requesting system, which is a data requesting system among the plurality of information retrieving services, having a function of providing a plurality of information retrieving services that retrieve and provide data from a database A data retrieval system for retrieving data from the database,
  A service identification information acquisition unit for acquiring service identification information transmitted from the data request source system for identifying the information search service selected by the data request source system;
  A first acquisition number specifying unit for specifying the number of acquisitions of data associated with the service identification information acquired by the service identification information acquisition unit;
  A second acquisition number specifying unit for specifying the number of data acquisitions requested by the data requesting system;
  A storage unit that stores definition information in which a plurality of pieces of service identification information for identifying the plurality of information search services are associated with search query sentence configuration information;
  A configuration information specifying unit that specifies the configuration information associated with the service identification information acquired by the service identification information acquisition unit by referring to the definition information stored in the storage unit;
  A search query statement generating unit that generates a search query statement using the configuration information specified by the configuration information specifying unit;
  A data acquisition unit that acquires the data by the search query statement generated by the search query statement generation unit;
  A data transmission unit that transmits the data acquired by the data acquisition unit to the data requesting system;
With
  When the number of acquisitions specified by the second acquisition number specifying unit is smaller than the number of acquisitions specified by the first acquisition number specifying unit, the data acquisition unit specifies the number of acquisitions specified by the second acquisition number specifying unit. Is acquired from the database, the data searched by the search query sentence generated by the search query sentence generation unit,
  The configuration information includes information indicating a data item to be acquired from which data is to be acquired from the database, and whether to transmit data of the data item to be acquired to the request source.
  The search query statement generation unit generates a search query statement for searching the database for data of the data item to be acquired indicated by the information included in the configuration information specified by the configuration information specifying unit. ,
  The data acquisition unit acquires the data from the database by transmitting the search query statement generated by the search query statement generation unit to the database,
  The data item indicating that the data transmitting unit transmits to the request source by information included in the configuration information specified by the configuration information specifying unit among the data acquired by the data acquiring unit from the database Is sent to the data requesting system.
Data retrieval system.   A transmission number specifying unit for specifying the number of data transmissions requested by the data requesting system;
  A transmission start position specifying unit for specifying a data transmission start position requested by the data requesting system;
Further comprising
  The data acquisition unit permits the acquisition of data from the database, the number of acquisitions specified by the first acquisition number specifying unit and the acquisition number of the acquisitions having a smaller number of acquisitions specified by the second acquisition number specifying unit. ,
  In the data transmission unit, the position of data indicated by the transmission start position specified by the transmission start position specifying unit and the number of transmissions specified by the transmission number specifying unit does not exceed the range of the permitted number of acquisitions. In this case, the data acquisition unit transmits the transmission count data from the transmission start position acquired from the database to the data request source system.
The data search system according to claim 2 or 3. A filter processing unit that performs a filtering process in units of data items on the data transmitted to the data requesting system ,
The definition information further indicates an association of filtering conditions used for the filtering process by the filter processing unit with respect to each of the plurality of service identification information,
The filter processing unit refers to the definition information stored in the storage unit, and performs the filtering process with the filtering condition associated with the service identification information acquired by the service identification information acquisition unit. The data search system according to claim 1, wherein the data search system is performed. The search query statement generation unit uses the configuration information the configuration information identifying unit has identified, the data search system according to claim 1, any one of 5 to generate the SQL statement as the search query statement. Search parameter acquisition unit for acquiring narrowing-down conditions transmitted from the data request source system
Further comprising
The search query statement generation unit uses the narrowing condition acquired by the search parameter acquisition unit and the configuration information specified by the configuration information specifying unit to acquire the data that matches the narrowing condition from the database. The data search system according to any one of claims 2 to 4 , wherein the search query statement is generated. The search parameter acquisition unit further acquires a sort condition transmitted from the data request source system ,
The data search system according to claim 7 , wherein the search query statement generation unit generates the search query statement for acquiring the data sorted according to the sort condition from the database. The data search system according to any one of claims 1 to 8 ,
A terminal device provided in the data request source system ,
The terminal device transmits a request message including service identification information for identifying an information search service selected from the plurality of information search services;
The data search system is a system for transmitting data to be transmitted to the terminal device to the terminal device by a response message. The program for functioning a computer as a data search system as described in any one of Claims 1-8 . A data search system having a function of providing a plurality of information search services that search and provide data from a database selects an information search selected by a data request source system that is a data request source system among the plurality of information search services a data retrieval method for retrieving data from the database according to the service,
A storage stage in which the storage unit included in the data search system stores definition information indicating a correspondence of configuration information of a search query statement to each of a plurality of service identification information for identifying the plurality of information search services When,
Service identification information acquisition unit for acquiring service identification information for identifying the information search service selected by the data request source system , transmitted from the data request source system , by a service identification information acquisition unit included in the data search system Stages,
A search parameter acquisition unit provided in the data search system acquires a search parameter acquisition step of acquiring identification information of unnecessary data items transmitted from the data request source system,
The configuration associated with the service identification information acquired by the service identification information acquisition unit by referring to the definition information stored in the storage unit by a configuration information specifying unit included in the data search system A configuration information identification stage for identifying information;
A search query statement generating unit provided in the data search system uses the configuration information specified by the configuration information specifying unit to generate a search query statement, and
A data acquisition stage provided in the data search system, the data acquisition step of acquiring the data by the search query sentence generated by the search query sentence generation unit;
A data transmission unit included in the data search system includes a data transmission step of transmitting the data acquired by the data acquisition unit to the data request source system ;
The configuration information includes information indicating a data item to be acquired from which data is to be acquired from the database, and whether to transmit data of the data item to be acquired to the request source.
In the search query statement generation stage, the search query statement generation unit includes the unnecessary data item that is the data item to be acquired indicated by the information included in the configuration information specified by the configuration information specifying unit. Generating a search query for searching the data of the data item from the database;
In the data acquisition step, the data acquisition unit acquires data from the database by transmitting the search query statement generated by the search query statement generation unit to the database,
In the data transmission step, the data transmission unit may transmit to the request source by information included in the configuration information specified by the configuration information specifying unit among the data acquired by the data acquisition unit from the database. A data search method for transmitting data of a data item other than the unnecessary data item to the data request source system.

Images