JP2018049375A - Information processing program, information processing apparatus, and information processing method - Google Patents

Abstract

A database search process is reduced. When a screen display request is received, information indicating a configuration of the screen including a plurality of master types and information specifying a record is acquired, and one search request including the plurality of master types is transmitted. In response to the one search request, a plurality of master data corresponding to each of the plurality of master types is received, and the records included in each of the plurality of master types and each of the plurality of master data are received. Screen information corresponding to the display request is created based on a set including data designated by the designated information, and the created screen information is transmitted to the request source of the display request. [Selection] Figure 2

Description

  The present invention relates to an information processing program, an information processing apparatus, and an information processing method.

  A conventional database engine, such as an XML (Extensible Markup Language) database engine, is known that does not have a function of combining transaction data and master data in data retrieval.

  In such a database engine, when acquiring master data based on transaction data, the transaction database is searched, the master database is searched again with a value included in the transaction data of the search result, and the master data is acquired.

JP 2012-181696 A Japanese Patent Laid-Open No. 10-40146

  In the conventional database engine described above, the processing time for one transaction data becomes longer as the types of master data to be acquired increase, and as a result, the search time becomes longer.

  In one aspect, an object of the present invention is to provide an information processing program, an information processing apparatus, and an information processing method capable of reducing a search process to a database.

  According to one aspect, when a screen display request is received, information indicating a configuration of the screen including a plurality of master types and information specifying a record is acquired, and one search request including the plurality of master types is obtained. Transmitting and receiving a plurality of master data corresponding to each of the plurality of master types as a response to the one search request, and included in each of the plurality of master types and each of the plurality of master data Screen information corresponding to the display request is created based on a set including data designated by information designating a record, and the created screen information is transmitted to the request source of the display request.

  Each of the above processes may be a functional unit realized by each of the above processes, a method of causing the above units to be executed by a computer as a procedure, or a computer-readable storage medium storing a program.

  Database search processing can be reduced.

It is a figure explaining the information processing system of a first embodiment. It is a figure explaining the process of the information processing apparatus of 1st embodiment. It is a figure which shows an example of the hardware constitutions of the information processing apparatus of 1st embodiment. It is a figure which shows an example of the transaction database of 1st embodiment. It is a figure which shows an example of the master database of 1st embodiment. It is a figure explaining the function of the information processing part of 1st embodiment. It is a figure which shows an example of the setting file of 1st embodiment. It is a flowchart explaining the process of the information processing part of 1st embodiment. It is a 1st figure explaining the example of the screen displayed on a terminal device. It is a 2nd figure explaining the example of the screen displayed on a terminal device. It is a 3rd figure explaining the example of the screen displayed on a terminal device. It is the 4th figure explaining the example of the screen displayed on a terminal device. It is a figure explaining the modification of a master database. It is a figure explaining the modification of a setting file. It is a figure explaining the function of the information processing part of 2nd embodiment. It is a flowchart explaining the process of the information processing part of 2nd embodiment.

(First embodiment)
The first embodiment will be described below with reference to the drawings. FIG. 1 is a diagram illustrating an information processing system according to the first embodiment.

  The information processing system 100 according to the present embodiment includes a storage device 200 and an information processing device 300. In the information processing system 100 of this embodiment, the storage device 200 and the information processing device 300 are connected via a network or the like. In addition, the information processing system 100 according to the present embodiment is also connected to the terminal device 400 via a network or the like.

  The storage device 200 of this embodiment includes a transaction database 210 and a master database 220. Each database included in the storage device 200 of this embodiment is, for example, an XML (Extensible Markup Language) database.

  The transaction database 210 stores transaction data accumulated by operating the information processing system 100. The transaction data is, for example, data that records details of events that have occurred along with business.

  The master database 220 stores master data in advance before operating the information processing system 100. The master data is data that summarizes basic attribute information such as customers, employees, and products.

  The information processing apparatus 300 according to the present embodiment includes an information processing unit 310. The information processing unit 310 includes a search request unit 320 and an integrated information output unit 330.

  In the information processing system 100 according to the present embodiment, when the information processing apparatus 300 receives a screen display request from the terminal device 400, the information processing apparatus 300 generates a search request by the search request unit 320 of the information processing unit 310 and transmits the search request to the storage device 200. To do.

  Specifically, the search request unit 320 receives the display request, generates a search request for transaction data corresponding to the screen that has received the display request, and transmits it to the storage device 200.

  Here, the transaction data of the present embodiment includes items included in the screen that has received the display request. Further, the master database 220 of the present embodiment includes master data of a type corresponding to items included in the transaction data.

  In the present embodiment, information including items included in the screen can be restated as information indicating the configuration of the screen. Therefore, it can be said that the transaction data of the present embodiment is information indicating the configuration of the screen that has received the display request.

  Further, when acquiring the transaction data, the search request unit 320 generates a master data search request of the type indicated by the item included in the transaction data, transmits the request to the storage device 200, and acquires the corresponding master data.

  At this time, the search request unit 320 of the present embodiment requests the search request so that all types of master data are acquired in a batch regardless of the number of types of master data indicated in the items included in the transaction data. Is generated.

  Therefore, according to this embodiment, even when transaction data includes a plurality of items indicating the type of master data, it is possible to acquire all master data to be searched with a single search request.

  The information processing unit 310 uses the integrated information output unit 330 to generate integrated information (screen information) that combines transaction data and master data, and transmits the integrated information to the terminal device 400. When receiving the integrated information, the terminal device 400 displays a designated screen based on the integrated information.

  In the example of FIG. 1, the information processing system 100 includes the storage device 200 and the information processing device 300, but is not limited thereto. The storage device 200 and the information processing device 300 may be included in one device. In other words, the information processing apparatus 300 may include the transaction database 210 and the master database 220. Further, the transaction database 210 and the master database 220 may be stored in different storage devices.

  Below, with reference to FIG. 2, the process of the information processing apparatus 300 of this embodiment is further demonstrated. FIG. 2 is a diagram illustrating processing of the information processing apparatus according to the first embodiment.

  FIG. 2 shows a case where the information processing system 100 is applied to management of employee personnel.

  In FIG. 2, it is assumed that the information processing apparatus 300 has acquired the transaction data 21 from the transaction database 210 based on the screen display request received from the terminal apparatus 400. In FIG. 2, the screen that receives the display request is, for example, a screen that displays personnel information including the affiliation and title of the name “AA aa”.

  Here, the transaction data and master data of this embodiment will be described.

In the example of FIG. 2, the transaction data 21 is information indicating the affiliation and job title of each employee, and the master data is information indicating the name of the department to which the employee belongs and the job title.
In the transaction data 21, the department or title to which the employee belongs indicates items included in the transaction data 21. This item is included in the screen that has received the display request, and corresponds to the type of master data included in the master database 220.

  In addition, the transaction data 21 includes values corresponding to the item “department” and the item “position”. The value of the item included in the transaction data 21 is information for designating a specific record in the type of master data corresponding to the item.

  In the transaction data 21, it can be seen that items included in the screen include name, affiliation, title, and the like. Further, in the transaction data 21, it can be seen that the information corresponding to the item “affiliation” is “02” and the information corresponding to the item “position” is “03”.

  The item included in the transaction data 21 indicates the type of master data stored in the master database 220. In the example of FIG. 2, the types of master data indicated by the transaction data 21 are a department master 221 indicated by the item “affiliation” and a title master 222 indicated by the item “position”.

  Therefore, the search request unit 320 of the present embodiment generates a search request for acquiring both the department master 221 and the post master 222 in a lump, and transmits it to the storage device 200 (step S1). Then, the search request unit 320 acquires both the department master 221 and the post master 222 from the master database 220 (step S2).

  Next, the information processing unit 310 of the present embodiment specifies a specific record in the acquired master based on the value of the item included in the transaction data 21 by the integrated information output unit 330.

  In the transaction data 21, the value of the item “affiliation” is “02”. Therefore, the integrated information output unit 330 searches the department master 221 indicated by the item “affiliation” using “02” as a key, and designates a record including “02”.

  Further, in the transaction data 21, the value of the item “title” is “03”. Therefore, the integrated information output unit 330 searches the post master 222 indicated by the item “post” using “03” as a key, and designates a record including “03”.

  Then, the integrated information output unit 330 generates the integrated information 22 based on the set of the item included in the transaction data 21 and the value of the record specified by the value of the item acquired from the master database 220 (step S3) and output.

  In other words, the integrated information output unit 330 generates the integrated information 22 based on a set including information indicating the type of the master and a specific record specified in the master.

The integrated information 22 shown in FIG. 2 includes a set of “affiliation” which is information 23 indicating the type of master and the value “HR” of the record 221-1 designated in the department master 221 corresponding to “affiliation”. Including.
The integrated information 22 includes a set of “position”, which is information 25 indicating the master type, and the value “section chief” of the record 222-1 designated in the position master 222 corresponding to “position”.

  The integrated information output unit 330 of the present embodiment transmits the integrated information 22 to the terminal device 400 that is the request source of the display request.

  Upon receiving the integrated information 22, the terminal device 400 displays a screen that displays personnel information including the affiliation and title of the name “AA aa”.

  As described above, in the present embodiment, even when the information acquired from the transaction database 210 includes items associated with a plurality of types of master data, the search processing for the master database 220 can be performed collectively. it can.

  Therefore, according to the present embodiment, the database search process can be reduced.

  Next, a hardware configuration of the information processing apparatus 300 according to the present embodiment will be described with reference to FIG. FIG. 3 is a diagram illustrating an example of a hardware configuration of the information processing apparatus according to the first embodiment.

  The information processing apparatus 300 according to the present embodiment includes an input device 31, an output device 32, a drive device 33, an auxiliary storage device 34, a memory device 35, an arithmetic processing device 36, and an interface device 37 that are mutually connected by a bus B. Including.

  The input device 31 is for inputting various types of information, and is realized by, for example, a keyboard or a mouse. The output device 32 is for outputting various types of information, and is realized by, for example, a display. The interface device 37 includes a modem, a LAN card, and the like, and is used for connecting to a network.

  The information processing program is at least a part of various programs that control the information processing apparatus 300. The information processing program is provided, for example, by distributing the storage medium 38 or downloading from the network. The storage medium 38 on which the information processing program is recorded is a storage medium that records information optically, electrically, or magnetically, such as a CD-ROM, flexible disk, or magneto-optical disk, or information such as a ROM or flash memory. Various types of storage media, such as a semiconductor memory that electrically records data, can be used.

  The information processing program is installed from the storage medium 38 to the auxiliary storage device 34 via the drive device 33 when the storage medium 38 on which the information processing program is recorded is set in the drive device 33. The information processing program downloaded from the network is installed in the auxiliary storage device 34 via the interface device 37.

  The auxiliary storage device 34 stores the installed information processing program and stores necessary files, data, and the like. The memory device 35 reads and stores the information processing program from the auxiliary storage device 34 when the computer is activated. The arithmetic processing unit 36 implements various processes as described later in accordance with the information processing program stored in the memory device 35.

  Next, the transaction database 210 and the master database 220 will be described with reference to FIGS.

  FIG. 4 is a diagram illustrating an example of the transaction database according to the first embodiment. The transaction database 210 shown in FIG. 4 stores personnel information of employees such as companies.

  In the example of FIG. 4, the information items include name, affiliation, and title. In other words, in the example of FIG. 4, a description in which the name, affiliation, and post for each employee are associated is stored as one record as personnel information.

  For example, the transaction data 211 includes the value “02” of the item “affiliation” and the value “03” of the item “position” in the name “AA aa”. Further, the transaction data 212 includes the value “01” of the item “affiliation” and the value “02” of the item “position” in the name “BB bb”.

  In FIG. 4, although two items are included in one record, the present invention is not limited to this. An arbitrary number of items may be included in one record.

  In FIG. 4, the transaction database 210 stores personnel information, but the present invention is not limited to this. The transaction database 210 may store any information as long as the information is accumulated or updated as the information processing system 100 operates. Further, the storage device 200 may store a plurality of transaction databases 210.

  FIG. 5 is a diagram illustrating an example of a master database according to the first embodiment. The master database 220 shown in FIG. 5 includes <code> and <value>. <Code> is a value associated with the master data, and corresponds to the value of the item included in the transaction data. <Value> indicates a type of master data corresponding to an item included in each record of the transaction database 210.

  In the example of FIG. 5, the master database 220 includes a department master 221 of a type corresponding to the item “affiliation” and a department master 221 of a type corresponding to the item “position”.

  In the department master 221, the value of the item “affiliation” is associated with the department name. For example, for the item “affiliation”, the value of the code including the value “01” is “General Affairs Department”, the value of the record including the value “02” is “HR”, and the value of the record including the value “03” It can be seen that the value is “Accounting Department”.

  In the post master 222, the value of the item “post” is associated with the title of the post. For example, for the item “title”, the value of the record including the value “01” is “manager”, the value of the record including the value “02” is “section manager”, and the value of the record including the value “03” is It turns out that it is a "person in charge".

  Note that the transaction database 210 and the master database 220 of this embodiment are databases written in an XML (Extensible Markup Language) language.

  Next, functions of the information processing unit 310 of the information processing apparatus 300 according to the present embodiment will be described with reference to FIG.

  FIG. 6 is a diagram illustrating functions of the information processing unit according to the first embodiment. The information processing unit 310 according to the present embodiment is realized when the arithmetic processing device 36 of the information processing device 300 reads and executes an information processing program stored in the auxiliary storage device 34 or the memory device 35.

  The information processing unit 310 of this embodiment includes a setting file specifying unit 315, a search request unit 320, and an integrated information output unit 330.

  The setting file specifying unit 315 has a setting file 316 created in advance for each screen displayed on the terminal device 400, and specifies a setting file to be referred to from a screen display request received from the terminal device 400. .

  The setting file 316 is a file created for each screen displayed on the terminal device 400, and describes information for specifying the transaction database 210 to be referred to, a search expression used when generating a search request, and the like. Has been. Details of the setting file 316 will be described later.

  The search request unit 320 of this embodiment includes an input reception unit 321, a first search request unit 322, a search request generation unit 323, and a second search request unit 324.

  The input receiving unit 321 receives a display request from the terminal device 400. When the first search request unit 322 receives the display request, the first search request unit 322 specifies the transaction database 210 serving as a reference destination based on the setting file 316 specified by the setting file specifying unit 315. Then, the first search request unit 322 transmits a search request to the identified transaction database 210 based on the setting file 316.

  The search request generation unit 323 generates a search request from items included in the transaction data obtained as a search result by the first search request unit 322. At this time, the search request generation unit 323 generates one search request regardless of the number of items included in the transaction data.

  The second search request unit 324 transmits the search request generated by the search request generation unit 323 to the storage device 200 as a search request for the master database 220, and acquires the search result master.

  The integrated information output unit 330 of this embodiment includes a master search unit 331, an integrated information generation unit 332, and an output unit 333.

  The master search unit 331 searches the master acquired by the search request made by the second search request unit 324 with the value of the item included in the transaction data, and specifies the corresponding record.

  The integrated information generation unit 332 generates integrated information that integrates the master record specified by the master search unit 331 and items included in the transaction data.

  The output unit 333 transmits the integrated information generated by the integrated information generation unit 332 to the terminal device 400.

  Next, the setting file will be described with reference to FIG. FIG. 7 is a diagram illustrating an example of a setting file according to the first embodiment.

  In the setting file 316 illustrated in FIG. 7, the description 71 indicates an identifier of the transaction database 210. The description 72 indicates the identifier of the master database 220. The database identifier in this embodiment is, for example, a database port number.

  The description 73 defines items included in the transaction database 210. In the description 73, it is defined in the transaction database 210 that “/ chain / name” is the employee's name and “/ chain / shozoku” is the employee's affiliation. In the description 73, it is defined that “/ chain / yakushoku” is the position of the employee.

  A description 74 shows the definition of items in the master database 220. Specifically, in the description 74, in the master database 220, “bush / code” indicates a department code, and “bush / value” indicates a department name. In the description 74, “yakushoku / code” indicates a job title code, and “yakshoku / value” indicates a job title.

  The description 75 defines items to be extracted from the transaction database 210. In the description 75, items “name”, “affiliation”, and “position” are defined as items extracted from the transaction database 210.

  The description 76 defines how to integrate items extracted from the transaction database 210 and items in the master database 220.

  The description “FSI_JOINVIE01” of the description 76 is an identifier for specifying the screen that has received the display request.

  The description “FSI — 02: FSI — 21: FSI 22” of the description 76 includes the item “affiliation” of the transaction database 210 corresponding to FSI — 02, the department code of the master database 220 corresponding to FSI — 21, and the department of the master database 220 corresponding to FSI —22. It is defined that the name is integrated.

  Similarly, the description “FSI — 03: FSI — 21: FSI 32” of the description 76 may integrate the item “Position” corresponding to FSI — 03, the post code of the master database 220 corresponding to FSI — 31, and the post name corresponding to FSI — 32. Is defined.

  As can be seen from the description 76, in this embodiment, even when there are a plurality of types of master data corresponding to items included in the transaction data, the description defining the integration is one record.

  Therefore, if the search request generation unit 323 of the present embodiment generates a search request based on this description 76, the number of search requests to the master database 220 can be made regardless of the number of types of master data included in the transaction data. Once.

  Next, processing of the information processing unit 310 of this embodiment will be described with reference to FIG. FIG. 8 is a flowchart for explaining processing of the information processing unit of the first embodiment.

  In the search request unit 320 of the information processing unit 310 of the present embodiment, the input reception unit 321 determines whether a screen display request has been received from the terminal device 400 (step S801). In other words, the input receiving unit 321 determines whether an integrated information display request has been received from the terminal device 400. In the present embodiment, for example, when information serving as a search key is input in the terminal device 400, the terminal device 400 transmits information indicating the search key to the information processing device 300 together with a display request.

  If no input is accepted in step S801, the search request unit 320 waits until an input is accepted. In step S801, when the input is accepted, the information processing unit 310 uses the setting file specifying unit 315 to specify the setting file 316 to be referred to (step S802). Specifically, the setting file specifying unit 315 according to the present embodiment acquires the identifier of the screen included in the display request received by the input receiving unit 321 and specifies the setting file 316 corresponding to the identifier.

  Subsequently, the search request unit 320 uses the first search request unit 322 to transmit information indicating the search key to the storage device 200, and makes a search request for the transaction database 210 using the information indicating the search key (step S803). Subsequently, the search request unit 320 acquires transaction data corresponding to information indicating the search key from the storage device 200 (step S804).

  Next, the search request unit 320 uses the search request generation unit 323 to generate a search request for acquiring master data corresponding to the item from the items included in the acquired transaction data and the setting file 316. The search request unit 324 transmits the information to the storage device 200 (step S805). Subsequently, the search request unit 320 acquires master data corresponding to the item (step S806).

  Next, the integrated information output unit 330 uses the master search unit 331 to search the acquired master data with the value of the item included in the transaction data (step S807). Subsequently, the integrated information output unit 330 uses the integrated information generation unit 332 to generate integrated information in which items included in the transaction data are associated with master data obtained as a search result by the master search unit 331 (step S31). S808).

  Subsequently, the integrated information output unit 330 causes the output unit 333 to transmit the generated integrated information to the terminal device 400 that has requested display (step S809), and ends the process.

  Below, the screen transition of the terminal device 400 after the information processing apparatus 300 receives a display request from the terminal device 400 until the integrated information is displayed will be described.

  FIG. 9 is a first diagram illustrating an example of a screen displayed on the terminal device. A screen 91 illustrated in FIG. 9 illustrates an example of a login screen when the user of the terminal device 400 logs in to the information processing system 100.

  On the login screen 91, for example, an input field 92 for inputting the employee's name, a password input field 93, and a button 94 are displayed.

  In the present embodiment, for example, in the terminal device 400, when a name is input in the input field 92 and a password is input in the input field 93 and then a button 94 for instructing execution of the login process is operated, the login screen 91. Transitions to a home screen 101 to be described later.

  FIG. 10 is a second diagram illustrating an example of a screen displayed on the terminal device. A screen 101 illustrated in FIG. 10 illustrates an example of a home screen displayed on the terminal device 400 after the user of the terminal device 400 logs in to the information processing system 100.

  On the home screen 101, for example, a button 102 for displaying information related to the employee who has logged in and a button 103 for displaying a list of information regarding other employees are displayed.

  In the present embodiment, for example, when the button 102 is operated on the home screen 101, a display request using the name input on the login screen 91 as a search key is transmitted to the information processing apparatus 300. Then, the home screen 101 transitions to a My Page screen described later.

  Further, when the button 103 is operated on the home screen 101, a display request using a search key in which the names of all employees stored in the transaction database 210 are collected is transmitted to the information processing apparatus 300. Then, the home screen 101 transitions to a list screen described later.

  FIG. 11 is a third diagram illustrating an example of a screen displayed on the terminal device. A screen 111 shown in FIG. 11 shows an example of a My Page screen.

  A my page screen 111 in FIG. 11 shows a my page screen when the name of the logged-in employee is “AA aa”.

  In this case, the terminal device 400 transmits “AA aa” to the information processing device 300 together with the display request as information indicating the search key.

  The information processing device 300 receives a display request from the information processing unit 310, transmits a search request with the search key “AA aa” to the storage device 200, and obtains transaction data 211 from the transaction database 210 (FIG. 4).

  Subsequently, the information processing unit 310 acquires a department master and post master corresponding to the items “affiliation” and “post” of the transaction data 211 based on the description 76 of the setting file 316 and the transaction data 211. Next, the information processing section 310 records the record “personnel department” designated by the value “02” of the item “affiliation” from the department master, and the record “person in charge” designated by the value “03” of the item “position” from the title master. get.

  Then, the information processing unit 310 transmits to the terminal device 400 integrated information obtained by integrating the item “affiliation” and the record “HR”, and the item “position” and the record “person in charge”.

  In the terminal device 400, on the my page screen 111, a display field 112 that displays the item “affiliation” and the record “HR” in association with each other, and a display field that displays the item “position” and the record “person in charge” in association with each other. 113 is displayed.

  In addition, an input field 114 for inputting a schedule, a memo field 115, and the like may be displayed on the my page screen 111.

  FIG. 12 is a fourth diagram illustrating an example of a screen displayed on the terminal device. A screen 121 shown in FIG. 12 shows an example of an employee list screen.

  A list screen 121 illustrated in FIG. 12 is an example of a screen displayed on the terminal device 400 when the button 103 is operated on the home screen 101, for example.

  When the button 103 is operated on the home screen 101, the terminal device 400 transmits “list” to the information processing device 300 together with a display request as information indicating a search key.

  The information processing apparatus 300 receives a display request from the information processing unit 310 and transmits a search request based on information “list” indicating a search key to the storage device 200. Then, the information processing unit 310 acquires transaction data for all employees included in the transaction database 210.

  When acquiring the transaction data, the information processing unit 310 acquires a department master and a post master corresponding to the items included in the transaction data.

  The information processing unit 310 acquires, for each employee, the value of the record designated by the value of the item “affiliation” and the value of the record designated by the value of the item “position” from each acquired master. Then, the information processing unit 310 generates integrated information that combines the acquired transaction data item and the master record for each employee, and transmits the integrated information to the terminal device 400.

  In the list screen 121 of FIG. 12, the display column 122 displays employee names acquired from each transaction data, and the display column 123 displays the affiliation for each employee name. The column 124 displays the title of each employee.

  As described above, in this embodiment, even when a plurality of transaction data is acquired by a display request, master data of a type corresponding to an item included in the transaction data is acquired in a lump, so that the search process for the master database 220 is performed. Can be combined at once.

  Therefore, according to the present embodiment, the search process by the information processing apparatus 300 can be reduced, and the time required for the search process can be shortened.

  Next, a modification of the master database 220 of this embodiment will be described with reference to FIG. FIG. 13 is a diagram illustrating a modification of the master database.

  The master database 220A illustrated in FIG. 13 includes <mst>, <code>, and <value>, and represents a type of each record in the master data by adding a “type” element indicating the type. .

  Next, a modified example of the setting file 316 of the present embodiment will be described with reference to FIG. FIG. 14 is a diagram illustrating a modification of the setting file.

  A setting file 316A shown in FIG. 14 corresponds to the master database 220A. In the setting file 316A shown in FIG. 14, a search request for the master database 220 is shown as a description 141.

  In the description 141, the record in the master data is identified by the interpretation that “the record in FSI_02 has the code in FSI_21 and satisfies the conditions in parentheses”, and the value of FSI_22 of the identified record is displayed.

(Second embodiment)
The second embodiment will be described below with reference to the drawings. In the second embodiment, when the number of records of transaction data acquired by the display request is equal to or less than a predetermined number, the value of the record specified by the value of the item of transaction data is acquired from the master database 220. However, this is different from the first embodiment. Therefore, in the following description of the second embodiment, the same reference numerals as those used in the description of the first embodiment are given to those having the same functional configuration as the first embodiment, and the description thereof Is omitted.

  FIG. 15 is a diagram illustrating functions of the information processing unit according to the second embodiment. The information processing unit 310A of this embodiment includes a setting file specifying unit 315, a search request unit 320A, and an integrated information output unit 330.

  The search request unit 320A of this embodiment includes an input reception unit 321, a first search request unit 322, a search request generation unit 323A, a second search request unit 324, and a record number determination unit 325.

  The record number determination unit 325 determines whether the number of records of transaction data acquired from the transaction database 210 by the first search request unit 322 is equal to or less than a predetermined number. The predetermined number is a value set in advance by an administrator of the information processing system 100, for example.

  When the record number determination unit 325 determines that the number of records is equal to or less than the predetermined number, the second search request unit 324A includes the item included in the transaction data, the item value, and the search request in the storage device 200. Send.

  Then, the search request generation unit 323A acquires the value of the record designated by the item value from the master database 220.

  That is, in the present embodiment, when the transaction data acquired by the first search request unit 322 is a predetermined number or less, the master data of the type corresponding to the item included in the transaction data is not acquired collectively, Gets the value of the record specified by the value.

  Therefore, according to the present embodiment, it is possible to omit processing for searching for a record specified by an item value from master data acquired in a batch. In other words, in the present embodiment, when the transaction data acquired by the first search request unit 322 is a predetermined number or less, the processing of the master search unit 331 in the integrated information output unit 330 can be omitted.

  Next, with reference to FIG. 16, the processing of the information processing unit 310A of the present embodiment will be described. FIG. 16 is a flowchart for explaining processing of the information processing unit of the second embodiment.

  The processing from step S1601 to step S1604 in FIG. 16 is the same as the processing from step S801 to step S804 in FIG.

  Subsequent to step S1604, the information processing unit 310A causes the record number determination unit 325 to determine whether or not the number of records of the transaction data acquired in step S1604 is equal to or less than a predetermined number (step S1605). If the number of records is not less than or equal to the predetermined number in step S1605, that is, if the number is greater than the predetermined number, the information processing section 310A proceeds to step S1606.

  The processing from step S1606 to step S1610 is the same as the processing from step S805 to step S809 in FIG.

  In step S1605, when the number of records is equal to or less than the predetermined number, the information processing unit 310A generates a search request including the item included in the transaction data and the value of the item by the search request generating unit 323A, and the second search request The data is transmitted to the storage device 200 by the unit 324 (step S1611).

  Subsequently, the information processing unit 310A uses the second search request unit 324 to acquire the value of the master data record corresponding to the item value from the type of master data corresponding to the item (step S1612).

  Subsequently, the information processing unit 310A uses the integrated information output unit 330 to generate integrated information in which the items included in the transaction data and the master data record value acquired in step S1612 are integrated (step S1613). The process proceeds to S1610.

  In the present embodiment, for example, the present invention may be applied when the button 102 is operated on the home screen 101 illustrated in FIG. When the button 102 is operated, a display request using the name “AA aa” input on the login screen 91 as a search key is transmitted to the information processing apparatus 300. That is, the record acquired from the transaction database 210 is only the transaction data 211 including the name “AA aa” input on the login screen 91 (see FIG. 4).

  Therefore, in this case, the search request generation unit 323A generates a search request including the item “affiliation” and its value “02”, the item “title” and its value “03” included in the transaction data, and the second The search request unit 324 transmits this search request to the storage device 200.

  Then, instead of obtaining the department master 221, the second search request part 324 obtains the value “HR” of the record in which “code” of the master data in the department master 221 is “02”. In addition, instead of acquiring the post master 222, the second search request unit 324 acquires the value “person in charge” of the record in which “code” of the master data in the post master 222 is “03”.

  As described above, according to the present embodiment, according to the determination result of the record number determination unit 325, the value of the record corresponding to the item value is individually acquired from the master data of the type corresponding to the item of the transaction data. There is a case. Therefore, according to this embodiment, when applicable, the process of the master search unit 331 of the information processing unit 310A can be omitted, and the search process can be reduced.

  In the present embodiment, for example, in the home screen 101 of FIG. 10, when a predetermined number or less of the number of employees is selected and a display request for a list of information regarding the selected employee is received, etc. Good to be applied.

  Furthermore, the present embodiment is applied, for example, when the number of records of transaction data is a predetermined number or less, but is not limited to this. The information processing unit 310A may include an item included in transaction data, an item value, and a search request regardless of the number of records of the transaction data.

In the disclosed technology, forms such as the following supplementary notes are conceivable.
(Appendix 1)
When receiving a screen display request, obtain information indicating the configuration of the screen including a plurality of master types and information designating records,
Sending one search request including the plurality of master types;
In response to the one search request, a plurality of master data corresponding to each of the plurality of master types is received,
Screen information corresponding to the display request is generated based on a set including each of the plurality of master types and data specified by information specifying the record included in each of the plurality of master data. Send the created screen information to the requester of the display request;
An information processing program for causing a computer to execute processing.
(Appendix 2)
The process of acquiring information indicating the configuration of the screen includes a process of identifying information indicating the configuration of the screen corresponding to the identifier of the screen with reference to the identifier of the screen included in the display request,
The process of transmitting the search request generates the search request based on a search formula included in information indicating the identified configuration of the screen.
The information processing program according to appendix 1, characterized by causing the computer to execute processing.
(Appendix 3)
The data specified by the information specifying the record included in each of the plurality of master data is extracted by a search by information specifying the record for each of the received plurality of master data. The information processing program according to supplementary note 1 or 2.
(Appendix 4)
It is determined whether the number of pieces of information indicating the acquired configuration of the screen is a predetermined number or less,
When the number is equal to or less than a predetermined number, the process of transmitting to the computer a single search request and a generation in which the types of the plurality of masters and information specifying a specific record for each of the plurality of masters is integrated is executed. The information processing program according to any one of supplementary notes 1 to 3, wherein:
(Appendix 5)
The information processing program according to any one of appendices 1 to 4, wherein the information corresponding to the types of the plurality of masters indicates items of information displayed on the screen.
(Appendix 6)
Upon receiving a screen display request, obtain information indicating the configuration of the screen,
Based on information specifying a specific record for each of a plurality of masters included in the acquired information indicating the configuration of the screen, the type of the plurality of masters and the specific record for each of the plurality of masters are indicated Send it as a single search request that integrates information,
As a response to the search request, when receiving data corresponding to the specified record specified, it also receives information indicating the corresponding master type,
The screen information corresponding to the display request is created based on the set including the received master type information and the data corresponding to the specified specific record, and the created screen information is stored in the display request. Send to requestor,
An information processing program characterized in that processing is executed by a computer.
(Appendix 7)
When receiving a screen display request, obtain information indicating the configuration of the screen including a plurality of master types and information designating records,
Sending one search request including the plurality of master types;
In response to the one search request, a plurality of master data corresponding to each of the plurality of master types is received,
Screen information corresponding to the display request is generated based on a set including each of the plurality of master types and data specified by information specifying the record included in each of the plurality of master data. Send the created screen information to the requester of the display request;
An information processing apparatus having a control unit having a function of executing processing.
(Appendix 8)
Upon receiving a screen display request, obtain information indicating the configuration of the screen,
Based on information specifying a specific record for each of a plurality of masters included in the acquired information indicating the configuration of the screen, the type of the plurality of masters and the specific record for each of the plurality of masters are indicated Send it as a single search request that integrates information,
As a response to the search request, when receiving data corresponding to the specified record specified, it also receives information indicating the corresponding master type,
The screen information corresponding to the display request is created based on the set including the received master type information and the data corresponding to the specified specific record, and the created screen information is stored in the display request. Send to requestor,
An information processing apparatus having a control unit having a function of executing processing.
(Appendix 9)
When receiving a screen display request, obtain information indicating the configuration of the screen including a plurality of master types and information designating records,
Sending one search request including the plurality of master types;
In response to the one search request, a plurality of master data corresponding to each of the plurality of master types is received,
Screen information corresponding to the display request is generated based on a set including each of the plurality of master types and data specified by information specifying the record included in each of the plurality of master data. Send the created screen information to the requester of the display request;
An information processing method, wherein a computer executes a process.
(Appendix 10)
Upon receiving a screen display request, obtain information indicating the configuration of the screen,
Based on information specifying a specific record for each of a plurality of masters included in the acquired information indicating the configuration of the screen, the type of the plurality of masters and the specific record for each of the plurality of masters are indicated Send it as a single search request that integrates information,
As a response to the search request, when receiving data corresponding to the specified record specified, it also receives information indicating the corresponding master type,
The screen information corresponding to the display request is created based on the set including the received master type information and the data corresponding to the specified specific record, and the created screen information is stored in the display request. Send to requestor,
An information processing method, wherein a computer executes a process.

  The present invention is not limited to the specifically disclosed embodiments, and various modifications and changes can be made without departing from the scope of the claims.

DESCRIPTION OF SYMBOLS 100 Information processing system 200 Storage device 210 Transaction database 220, 220A Master database 300 Information processing device 310, 310A Information processing unit 320, 320A Search request unit 321 Input reception unit 322 First search request unit 323, 323A Search request generation unit 324 Second search request unit 325 Record number determination unit 330 Integrated information output unit 331 Master search unit 332 Integrated information generation unit 333 Output unit 400 Terminal device

Claims (8)

When receiving a screen display request, obtain information indicating the configuration of the screen including a plurality of master types and information designating records,
Sending one search request including the plurality of master types;
In response to the one search request, a plurality of master data corresponding to each of the plurality of master types is received,
Screen information corresponding to the display request is generated based on a set including each of the plurality of master types and data specified by information specifying the record included in each of the plurality of master data. Send the created screen information to the requester of the display request;
An information processing program for causing a computer to execute processing. The process of acquiring information indicating the configuration of the screen includes a process of identifying information indicating the configuration of the screen corresponding to the identifier of the screen with reference to the identifier of the screen included in the display request,
The process of transmitting the search request generates the search request based on a search formula included in information indicating the identified configuration of the screen.
The information processing program according to claim 1. The data specified by the information specifying the record included in each of the plurality of master data is extracted by a search by information specifying the record for each of the received plurality of master data.
The information processing program according to claim 1 or 2. Upon receiving a screen display request, obtain information indicating the configuration of the screen,
Based on information specifying a specific record for each of a plurality of masters included in the acquired information indicating the configuration of the screen, the type of the plurality of masters and the specific record for each of the plurality of masters are indicated Send it as a single search request that integrates information,
As a response to the search request, when receiving data corresponding to the specified record specified, it also receives information indicating the corresponding master type,
The screen information corresponding to the display request is created based on the set including the received master type information and the data corresponding to the specified specific record, and the created screen information is stored in the display request. Send to requestor,
An information processing program characterized in that processing is executed by a computer. When receiving a screen display request, obtain information indicating the configuration of the screen including a plurality of master types and information designating records,
Sending one search request including the plurality of master types;
In response to the one search request, a plurality of master data corresponding to each of the plurality of master types is received,
Screen information corresponding to the display request is generated based on a set including each of the plurality of master types and data specified by information specifying the record included in each of the plurality of master data. Send the created screen information to the requester of the display request;
An information processing apparatus having a control unit having a function of executing processing. Upon receiving a screen display request, obtain information indicating the configuration of the screen,
Based on information specifying a specific record for each of a plurality of masters included in the acquired information indicating the configuration of the screen, the type of the plurality of masters and the specific record for each of the plurality of masters are indicated Send it as a single search request that integrates information,
As a response to the search request, when receiving data corresponding to the specified record specified, it also receives information indicating the corresponding master type,
The screen information corresponding to the display request is created based on the set including the received master type information and the data corresponding to the specified specific record, and the created screen information is stored in the display request. Send to requestor,
An information processing apparatus having a control unit having a function of executing processing. When receiving a screen display request, obtain information indicating the configuration of the screen including a plurality of master types and information designating records,
Sending one search request including the plurality of master types;
In response to the one search request, a plurality of master data corresponding to each of the plurality of master types is received,
Screen information corresponding to the display request is generated based on a set including each of the plurality of master types and data specified by information specifying the record included in each of the plurality of master data. Send the created screen information to the requester of the display request;
An information processing method, wherein a computer executes a process. Upon receiving a screen display request, obtain information indicating the configuration of the screen,
Based on information specifying a specific record for each of a plurality of masters included in the acquired information indicating the configuration of the screen, the type of the plurality of masters and the specific record for each of the plurality of masters are indicated Send it as a single search request that integrates information,
As a response to the search request, when receiving data corresponding to the specified record specified, it also receives information indicating the corresponding master type,
The screen information corresponding to the display request is created based on the set including the received master type information and the data corresponding to the specified specific record, and the created screen information is stored in the display request. Send to requestor,
An information processing method, wherein a computer executes a process.

Images