JP2009271716A - Information processing system, information terminal device, information processing method, and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To solve the problem of being unable to reduce the influence of corrections to a master table and distribute load. <P>SOLUTION: It is possible to reduce the influence of corrections to a master table and distribute load by means of an information terminal device which comprises: a data area information transmission instruction sending unit for sending data area information transmission instructions to a main server device if first predetermined instructions are received; a data area information receiving unit for receiving one or more pieces of data area information from the main server device correspondingly to the transmission instructions; a master table acquisition unit for accessing using the data area information a master management server device identified by a master management server device identifier that the data area information has, if second instructions are received, and acquiring the master table stored in a database identified by a database identifier that the data area information has; and a master table output unit for outputting the master table acquired. <P>COPYRIGHT: (C)2010,JPO&INPIT

Description

  The present invention relates to an information processing system that realizes a desired function using a master table.

Conventionally, in a system that distributes business processing requests sent from business clients to a plurality of servers, there has been a load balancing system in which a load balancer appropriately loads a server to which a plurality of business tasks are assigned. (For example, refer to Patent Document 1). The distributed algorithm determination means in the monitoring and control device recognizes a specific server to which a plurality of business operations are assigned from among a plurality of servers, and the processing request for each business operation assigned to the specific server A distribution algorithm is generated that makes the allocation rate to be less than the allocation rate to the server to which only one of the plurality of tasks is assigned. Further, the distribution means in the load distribution apparatus distributes processing requests according to the distribution algorithm generated by the distribution algorithm determination means.
Japanese Patent Laid-Open No. 2008-9800 (first page, FIG. 1 etc.)

  However, in the conventional system, the influence of the correction of the master table is reduced and the load cannot be distributed. Specifically, in the conventional system, it is not assumed that the server device in which the master table exists changes, and when the server device in which the master table exists changes, for example, the setting of each terminal is changed. There was a need to do.

  Further, in the conventional system, it is impossible to access a master table that exists in a different device for each user, and as a result, load distribution cannot be achieved.

  An information processing system of the first invention is an information processing system comprising a main server device, one or more master management server devices, and one or more information terminal devices, wherein the main server device is a master table. Data area information storage unit capable of storing one or more data area information having a master management server apparatus identifier for identifying a master management server apparatus storing a database and a database identifier for identifying a database that is a set of one or more master tables And a data region information transmission instruction receiving unit that receives the data region information transmission instruction, and a data region information transmission unit that transmits the data region information in response to the transmission instruction, and the master management server device Receives a database capable of storing one or more master tables and a master table transmission instruction from the information terminal device A master table transmission instruction receiving unit, and a master table transmission unit that transmits a master table in response to a transmission instruction from the information terminal device, the information terminal device accepting an input from a user, When the receiving unit receives a predetermined first instruction, a data region information transmission instruction transmitting unit that transmits a data region information transmission instruction to the main server device; and transmission of the data region information transmission instruction Correspondingly, when the data area information receiving unit that receives one or more data area information from the main server device and the accepting unit accepts a predetermined second instruction, the data region information receiving unit receives Using the data area information thus obtained, the master management server apparatus identified by the master management server apparatus identifier included in the data area information is accessed, and the data A master table acquisition unit that acquires a master table stored in a database identified by a database identifier included in the area information, a master table output unit that outputs the master table acquired by the master table acquisition unit, and the master table; An information processing system including an application execution unit that executes an application that realizes a predetermined function using an instruction received by the reception unit.

  With this configuration, it is possible to reduce the influence of the correction of the master table and to distribute the load.

  Further, in the information processing system of the second invention, the data area information storage unit stores two or more data area information, and the master table acquisition unit has two or more data area information. The data area information is used to access the master management server apparatus identified by the master management server apparatus identifier included in the data area information, and is identified by the database identifier included in the data area information. An information processing system that acquires a master table stored in a database.

  With this configuration, it is possible to access a master table that exists in a different device for each user, and as a result, load distribution can be achieved.

  The information processing system according to the third aspect of the invention is the information received by the receiving unit with respect to the second aspect, and is one of two or more pieces of data area information using information for identifying a user. The data table information is selected, and the master table acquisition unit uses the selected data area information to access the master management server device identified by the master management server device identifier included in the data region information. An information processing system for acquiring a master table stored in a database identified by a database identifier included in the data area information.

  With this configuration, a different master table can be used for each user, and by accessing a different master management server device for each user, a master table suitable for the user can be used, and load distribution can be achieved. .

  The information processing system according to the fourth aspect of the present invention is an information processing system in which the first instruction is an application activation instruction with respect to any one of the first to third aspects.

  With this configuration, data area information can be acquired at an appropriate timing, and the user can use the application comfortably.

  According to the information processing system of the present invention, load distribution can be achieved.

  Hereinafter, embodiments of an information processing system and the like will be described with reference to the drawings. In addition, since the component which attached | subjected the same code | symbol in embodiment performs the same operation | movement, description may be abbreviate | omitted again.

(Embodiment)
In the present embodiment, the application executed on the information terminal device 13 acquires the data area information existing in the main server apparatus 11, acquires the master data according to the data area information, and realizes the function of the application. The information processing system 1 to be described will be described. Further, in the information processing system 1, there may be a plurality of data area information and selection is possible. In the information processing system 1, the data area information may be automatically selected according to the user attribute. In the information processing system 1, data area information may be acquired from the main server device 11 when the application is activated.

  FIG. 1 is a conceptual diagram of an information processing system 1 in the present embodiment. The information processing system 1 includes a main server device 11, one or more master management server devices 12, and one or more information terminal devices 13. There are usually two or more master management server devices 12 and information terminal devices 13. Further, the main server device 11, the master management server device 12, and the information terminal device 13 can communicate via a network such as the Internet.

  FIG. 2 is a block diagram of the information processing system 1 in the present embodiment. The information processing system 1 includes a main server device 11, a master management server device 12, and an information terminal device 13.

  The main server device 11 includes a data area information storage unit 111, a data area information transmission instruction reception unit 112, and a data area information transmission unit 113.

  The master management server device 12 includes a database 121, a master table transmission instruction reception unit 122, and a master table transmission unit 123.

  The information terminal device 13 includes a reception unit 131, an application execution unit 132, a data region information transmission instruction transmission unit 133, a data region information reception unit 134, a data region information selection unit 135, a master table acquisition unit 136, and a master table output unit 137. It has.

  The data area information storage unit 111 can store one or more data area information. The data area information is information for specifying a location (area) where the master table exists. The data area information is preferably information for specifying a location (area) where a master table group that is a set of one or more master tables exists. The data area information includes, for example, a master management server device identifier and a database identifier. Further, the data area information includes, for example, a master management server device identifier, a database identifier, and authority information. A master table is a table that an application refers to. The data in the master table is, for example, data candidates to be input to the field. The master management server device identifier is information for identifying the master management server device 12 storing the master table, and is, for example, a device name, an IP address, a MAC address, or the like. The database identifier is, for example, a database name, database ID, master table name, master table table ID, or the like. The database may include two or more master tables, or one master table. That is, the database may be a set of two or more tables, or the database may have a one-to-one correspondence with the tables. The data area information storage unit 111 may store two or more data area information. The data area information storage unit 111 is preferably a nonvolatile recording medium, but can also be realized by a volatile recording medium. The process in which the data area information is stored in the data area information storage unit 111 does not matter. For example, data area information may be stored in the data area information storage unit 111 via a recording medium, and data area information transmitted via a communication line or the like is stored in the data area information storage unit 111. Alternatively, the data area information input via the input device may be stored in the data area information storage unit 111.

  The data area information transmission instruction receiving unit 112 receives a data area information transmission instruction. The transmission instruction may be an instruction to transmit all data area information or an instruction to transmit one specific data area information. The data structure of the transmission instruction does not matter. The data area information transmission instruction receiving unit 112 is usually realized by a wireless or wired communication means, but may be realized by a means for receiving a broadcast.

  The data area information transmission unit 113 acquires data area information from the data area information storage unit 111 according to the transmission instruction received by the data area information transmission instruction reception unit 112, and transmits the data area information. When the transmission instruction includes information for selecting specific data area information, the data area information transmission unit 113 selects data area information from the data area information storage unit 111 using the transmission instruction. The information for selecting specific data area information is, for example, user ID, information for identifying data area information, and the like. When the information for selecting specific data area information is a user ID, the data area information transmission unit 113 acquires the authority information of the user identified by the user ID from a user management table (not shown), and Data area information corresponding to the information is selected. The authority information is information relating to the user's authority, and may be user's department identification information, information for identifying the user's job title, or the like. The data area information transmission unit 113 is usually realized by a wireless or wired communication means, but may be realized by a broadcasting means.

  The master management server device 12 is a device that stores a master table.

  Database 121 may store one or more master tables. The database 121 may store only one master table. In such a case, the database and the master table are equivalent. Further, the master management server device 12 may hold two or more databases 121. The database 121 is preferably a non-volatile recording medium, but can also be realized by a volatile recording medium. The process of storing the master table in the database 121 does not matter. For example, the master table may be stored in the database 121 via a recording medium, or the master table transmitted via a communication line or the like may be stored in the database 121. Alternatively, a master table input via an input device may be stored in the database 121.

  The master table transmission instruction receiving unit 122 receives a master table transmission instruction from the information terminal device 13. The master table transmission instruction usually has master table identification information for identifying the master table. The master table identification information is, for example, a master table name, a master table identifier, and the like. The master table transmission instruction receiving unit 122 is usually realized by a wireless or wired communication means, but may be realized by a means for receiving a broadcast.

  The master table transmission unit 123 reads the master table from the database 121 and transmits the master table to the information terminal device 13 in accordance with the master table transmission instruction received by the master table transmission instruction reception unit 122. The master table transmission unit 123 normally transmits all data (for example, records) in the master table, but may transmit some data in the master table. The master table transmission unit 123 is usually realized by a wireless or wired communication unit, but may be realized by a broadcasting unit.

  The information terminal device 13 is a user terminal that performs work using an application. The application may be any software such as business support software for accounting, payroll, sales management, etc., internal control support software, office software for banks, and ERP package software.

  The accepting unit 131 accepts input from the user. Input is various instructions and data. The various instructions include a first instruction and a second instruction described later. Further, it is preferable that the first instruction and the second instruction are input from a user for performing an application (software) function. The input means may be anything such as a numeric keypad, keyboard, mouse or menu screen. The accepting unit 131 can be realized by a device driver for input means such as a numeric keypad and a keyboard, control software for a menu screen, and the like.

  The application execution unit 132 uses the master table and the input received by the reception unit 131 to execute an application that realizes a predetermined function. Further, the application execution unit 132 executes a predetermined function corresponding to the instruction. The predetermined function is a function of the above-described software, and can be various, for example, accounting, salary calculation, sales management, internal control support and the like. Needless to say, the function implemented by the application execution unit 132 is not limited. The application execution unit 132 can be usually realized by an MPU, a memory, or the like. The processing procedure of the application execution unit 132 is usually realized by software, and the software is recorded in a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  The data area information transmission instruction transmission unit 133 transmits a data area information transmission instruction to the main server device 11 when the reception unit 131 receives a predetermined first instruction. The first instruction is, for example, an application activation instruction, a specific panel output instruction, or the like. “When the first instruction is received” means that either before or after the specific panel is output in time. The data area information transmission instruction transmission unit 133 is normally realized by a wireless or wired communication unit, but may be realized by a broadcast unit.

  The data area information receiving unit 134 receives one or more data area information from the main server device 11 in response to transmission of a data area information transmission instruction. The data area information receiving unit 134 may receive all data area information held by the main server apparatus 11 from the main server apparatus 11, or may receive one or more data area information selected by the main server apparatus 11. You may receive it. The data area information receiving unit 134 is usually realized by a wireless or wired communication means, but may be realized by a means for receiving a broadcast.

  The data area information selection unit 135 selects one data area information from the two or more data area information received by the data area information reception unit 134 using the information received by the reception unit 131. Further, the data area information selection unit 135 is information received by the receiving unit 131. Information for identifying the user (user ID, information for identifying the organization to which the user belongs, information for identifying the user's job title, and user authority) One data area information of two or more data area information may be selected using a user attribute value such as information). The data area information selection unit 135 may select one data area information in accordance with the instruction received by the receiving unit 131 (data area information selection instruction). The data area information selection unit 135 can usually be realized by an MPU, a memory, or the like. The processing procedure of the data area information selection unit 135 is usually realized by software, and the software is recorded on a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  When the receiving unit 131 receives a predetermined second instruction, the master table acquisition unit 136 uses the data area information received by the data area information receiving unit 134 to use the master management server device included in the data area information. The master management server device 12 identified by the identifier is accessed, and the master table stored in the database 121 identified by the database identifier included in the data area information is acquired. The second instruction is, for example, an instruction to jump to a predetermined panel, an instruction to move the cursor to a field that uses the master table, or the possibility of using the master table. In some cases, this is an instruction (or information) input by the user. Needless to say, the data area information received by the data area information receiving unit 134 may be the data area information selected by the data area information selecting unit 135. The master management server device identifier is information for identifying the master management server device. The master table acquisition unit 136 normally acquires one master table, but two or more master tables may be acquired. The master table acquisition unit 136 normally acquires a master table also using master table identification information for identifying the master table to be acquired. That is, the master table acquisition unit 136 accesses the master management server device 12 identified by the master management server device identifier, and stores information on the table identified by the master table identification information in the database 121 identified by the database identifier. , Received from the master management server device 12. The master table identification information is stored in association with the operation target panel and the field for inputting data. “Store in association” also includes being embedded in the program. The master table obtaining unit 136 usually obtains master table identification information associated with a panel to be operated or a field for inputting data, and uses the master table identification information and data area information to obtain a master table. To get. In such a case, the master table acquisition unit 136 detects that a jump has been made to the operation target panel and that the cursor has moved to a field for inputting data.

  The master table acquisition unit 136 uses one data area information of two or more data area information to access the master management server apparatus 12 identified by the master management server apparatus identifier included in the data area information, and The master table stored in the database 121 identified by the database identifier included in the area information is acquired.

  The master table acquisition unit 136 accesses the master management server device 12 identified by the master management server device identifier included in the data region information using the selected one data region information, and the database identifier included in the data region information. The master table stored in the database 121 identified by (1) is acquired.

  The master table acquisition unit 136 can usually be realized by an MPU, a memory, or the like. The processing procedure of the master table acquisition unit 136 is usually realized by software, and the software is recorded on a recording medium such as a ROM. However, it may be realized by hardware (dedicated circuit).

  The master table output unit 137 outputs the master table acquired by the master table acquisition unit 136. Here, the output mode is not limited. The output may be to configure and output the menu items of the application using the master table, or to simply display the table. The output is a concept including display on a display, projection using a projector, transmission to an external device, delivery of a processing result to another processing device or another program, and the like. The master table output unit 137 may or may not include an output device such as a display. The master table output unit 137 can be implemented by output device driver software, or output device driver software and an output device.

  Next, the operation of the information processing system 1 will be described. First, the operation of the main server device 11 will be described. The data area information transmission instruction receiving unit 112 of the main server apparatus 11 receives the data area information transmission instruction from the information terminal apparatus 13. Next, the data area information transmission unit 113 reads one or more data area information from the data area information storage unit 111 and transmits the data area information to the information terminal device 13.

  Next, the operation of the master management server device 12 will be described. The master table transmission instruction receiving unit 122 of the master management server apparatus 12 receives a master table transmission instruction from the information terminal apparatus 13. Next, the master table transmission unit 123 reads from the database 121 the master table identified by the database identifier and the master table identification information included in the master table transmission instruction. Next, the master table transmission unit 123 transmits the read master table to the information terminal device 13.

  Next, operation | movement of the information terminal device 13 is demonstrated using the flowchart of FIG.

  (Step S301) The receiving unit 131 determines whether an input from the user has been received. If an input is accepted, the process goes to step S302, and if no input is accepted, the process returns to step S301.

  (Step S302) The application execution unit 132 determines whether or not the input received in step S301 is a first instruction. If it is the first instruction, go to step S303, and if it is not the first instruction, go to step S305. Here, it is assumed that the first instruction is an application activation instruction.

  (Step S303) The application execution part 132 starts an application and displays a main menu.

  (Step S304) The data area information receiving unit 134 and the like perform data area information acquisition processing. Data area information acquisition processing will be described with reference to the flowchart of FIG. The process returns to step S301.

  (Step S305) The master table acquisition unit 136 determines whether or not the input received in step S301 is an instruction (second instruction) corresponding to a process that requires acquisition of the master table. If it is the second instruction, the process proceeds to step S306, and if it is not the second instruction, the process proceeds to step S313. For example, the master table identification information is stored in association with the output target panel (panel identifier or panel definition information constituting the panel), or a field (field identifier or field definition information defining the field). Are stored in association with each other or embedded in the program.

  (Step S306) The application execution unit 132 performs an operation corresponding to the input received in step S301. The operation corresponding to the input corresponds to the display of the input data, the input and display of the data selected from the master table, the execution of the execution module corresponding to the pressed button, and the pressed menu item. Anything is acceptable, such as a menu or panel (screen) display.

  (Step S307) The master table acquisition unit 136 acquires master table identification information corresponding to the second instruction. The master table identification information is stored in association with, for example, user interface components (panels, fields, etc.) corresponding to the second instruction.

  (Step S308) The master table acquisition unit 136 reads data area information stored in a storage medium (may be a memory or the like).

  (Step S309) The master table acquisition unit 136 uses the master table identification information acquired in step S307 and the data area information read in step S308 to construct a search formula for acquiring the master table. The search expression is usually an expression using a database identifier included in the master table identification information and the data area information, and is expressed in, for example, SQL.

  (Step S310) The master table acquisition unit 136 uses the search formula configured in step S309 for the master management server device 12 identified by the master management server device identifier included in the data area information read in step S308. , Make an inquiry.

  (Step S311) The master table acquisition unit 136 determines whether or not the master table has been received from the master management server device 12 in response to the inquiry made in step S310. If the master table is received, the process goes to step S312, and if the master table is not received, the process returns to step S311.

  (Step S312) The master table output unit 137 outputs the master table acquired in step S311. The process returns to step S301.

  (Step S313) The application execution unit 132 performs an operation corresponding to the input received in Step S301. The process returns to step S301.

  In the flowchart of FIG. 3, the data area information acquisition process and the master table acquisition process are executed according to different instructions, but both the data area information acquisition process and the master table acquisition process may be performed according to the second instruction. .

  In the flowchart of FIG. 3, the master table is acquired from the master management server device 12 by the information terminal device 13. However, the master table may be acquired by the main server device 11 and transmitted to the information terminal device 13.

  Further, in the flowchart of FIG. 3, the process is ended by power-off or a process end interrupt.

  Next, the data area information acquisition processing in step S304 will be described using the flowchart of FIG.

  (Step S401) The data area information transmission instruction transmission unit 133 constitutes a data area information transmission instruction. That is, the data area information transmission instruction transmission unit 133 transmits, for example, information (for example, an IP address or a MAC address of the main server apparatus 11) that is held in advance and data area information transmission. Read the instruction string.

  (Step S <b> 402) The data area information transmission instruction transmission unit 133 transmits a data area information transmission instruction to the main server device 11.

  (Step S403) The data area information receiving unit 134 determines whether or not data area information has been received in response to the transmission of the data area information transmission instruction in step S402. If data area information is received, the process proceeds to step S404, and if data area information is not received, the process returns to step S403. In this step, the data area information receiving unit 134 receives the data area information.

  (Step S404) The data area information selection unit 135 determines whether two or more data area information has been received in step S403. If two or more data area information has been received, the process goes to step S405, and if only one data area information has been received, the process goes to step S409.

  (Step S405) The data area information selection unit 135 configures a panel (menu) for selecting data area information using the received two or more data area information.

  (Step S406) The data area information selection unit 135 outputs the panel (menu) configured in step S405.

  (Step S407) The receiving unit 131 determines whether or not a data area information selection instruction has been received. If a selection instruction is accepted, the process goes to step S408, and if no selection instruction is accepted, the process returns to step S407.

  (Step S408) The data area information selection unit 135 acquires the selected data area information.

  (Step S409) The data area information selection unit 135 accumulates the received one data area information or the data area information acquired in step S408. The storage area of the data area information may be a non-volatile recording medium or a volatile recording medium. Return to upper process.

  In the flowchart of FIG. 4, two or more data area information may be acquired. In such a case, for example, the accumulated master management server device 12 is different for each master table.

  Hereinafter, a specific operation of the information processing system 1 in the present embodiment will be described. A conceptual diagram of the information processing system 1 is shown in FIG.

  Now, the data area information storage unit 111 of the main server apparatus 11 holds the data area information management table shown in FIG. The data area information management table holds one or more records having attribute values such as “ID”, “master management server device identifier”, “master management server device name”, “database identifier”, “database name”, and “authorization information”. Yes. “ID” is an attribute for identifying a record. The “master management server apparatus identifier” is information for identifying the master management server apparatus 12 and is an attribute that holds an attribute value used for accessing the master management server apparatus 12. The “master management server device name” is the name of the master management server device 12 and can be used when the user selects it. The “database identifier” is information for identifying the database, and is used when accessing the database. The “database name” is the name of the database and can be used when the user selects it. “Authority information” is information about user authority to access the database.

  Further, means (user management unit) (not shown) of the main server device 11 holds the user management table shown in FIG. The user management table holds one or more records having attribute values such as “ID”, “user ID”, “password”, and “authorization information”. The “user ID” is information for identifying the user, and a means (authentication unit) (not shown) of the main server device 11 performs user authentication based on the password and the user ID. Allow access from.

  The database 121 of each of the two or more master management server devices 12 holds, for example, a set of master tables (hereinafter referred to as a master table group) used in the business support software, including the code list table shown in FIG. . The code list table shown in FIG. 7 holds one or more records having attribute values of “ID”, “code”, and “meaning”. “Code” is data input by the user, and “Meaning” is an attribute in which an attribute value indicating the meaning of “Code” is stored.

  FIG. 8 is a master table management table held by the business support software (application) stored in the application execution unit 132 of the information terminal device 13. The master table management table is a table that manages conditions for acquiring and outputting a master table, and records having “ID”, “panel ID”, “field ID”, and “master table identification information”. Hold one or more. “Panel ID” is information for identifying a panel (screen) constituting the business support software. “Field ID” is information for identifying a field in the panel. A field is one of user interface parts on the screen, and is a user interface part in which a user inputs data. The panel may also be considered as a user interface part. There are various user interface parts such as buttons and check boxes in addition to the fields. The record of “ID = 1” in FIG. 8 indicates that the master table “code list table” is output when the cursor moves to the field “code” of the “Account Item Registration” panel.

  In this situation, it is assumed that a user of the information terminal device 13 tries to log in to the main server device 11 by inputting the user ID “2234” and the password “obcx”. It is assumed that this input is an input of a work support software activation instruction (an example of the “first instruction” described above).

  Then, the main server device 11 authorizes the authentication by using the user ID “2234” and the password “obcx” by referring to the table of FIG. Then, the main server device 11 transmits an authentication permission message to the information terminal device 13. Here, the authentication permission may be accompanied by transmission of business support software. Further, the business support software may be held in advance by the application execution unit 132 of the information terminal device 13.

  Next, the application execution unit 132 of the information terminal device 13 activates the business support software. Then, the application execution unit 132 outputs the main menu of the business support software shown in FIG. 9 on the display. The business support software may be held in advance by the application execution unit 132 or may be an application transmitted from the main server device 11.

  Next, the data area information transmission instruction transmission unit 133 transmits a data area information transmission instruction to the main server device 11. The data area information transmission instruction may be the same as the above-described operation support software activation instruction.

  Next, the data area information transmission instruction receiving unit 112 of the main server apparatus 11 receives the data area information transmission instruction.

  Then, the data area information transmission unit 113 acquires authority information “8” corresponding to the user ID “2234” from the user management table.

  Next, the data area information transmission unit 113 acquires data area information (records of “ID = 1” and “ID = 3” in FIG. 5) paired with the authority information “8” from the data area information management table. . Then, the data area information transmitting unit 113 transmits the acquired data area information (records with “ID = 1” and “ID = 3” in FIG. 5) to the information terminal device 13. Here, the main server apparatus 11 selects the data area information using information input by the user (information for identifying the user here), but transmits all the data area information to the information terminal apparatus 13. You may do it.

  Next, the data area information receiving unit 134 of the information terminal device 13 receives the data area information (records of “ID = 1” and “ID = 3” in FIG. 5).

  Next, the data area information selection unit 135 configures a panel (menu) for selecting data area information using the received two data area information. Then, the data area information selection unit 135 outputs the configured panel (menu) as shown in FIG.

  Next, it is assumed that the user selects, for example, the records “server 1” and “DB1” (see FIG. 10).

  Next, the data area information selection unit 135 acquires the selected data area information (first record in FIG. 10) and at least temporarily accumulates it.

  Next, the user selects an item “introduction process” in the main menu and inputs an item “subject system” in the introduction process menu as shown in FIG. 11 in order to input desired data using the business support software. It is assumed that “Register” is selected. Then, the application execution unit 132 displays the menu “subject system registration” as shown in FIG.

  Further, the user switches the screen output mode of the business support software, for example, performs input for displaying the screen shown in FIG. 12 (panel ID “account item registration” panel), and the application execution unit 132 displays the screen shown in FIG. Suppose that the screen shown in Fig. 2

  Next, it is assumed that the user has input an instruction to move the current cursor to the field identified by the field ID “code”. That is, it is assumed that the user has input an example of the second instruction described above.

  The application execution unit 132 is an operation corresponding to an instruction to move the current cursor, and displays the cursor (131 in FIG. 13) in the field identified by the field D “code”.

  Next, the master table acquisition unit 136 acquires master table identification information corresponding to the second instruction as follows. That is, the master table acquisition unit 136 acquires the master table identification information “code list table” paired with the panel ID “account item registration” and the field ID “code” from the master table information management table of FIG.

  Next, the master table acquisition unit 136 reads out data area information “master management server device identifier: ccf15c47..., Database identifier 466703ef...” Stored in the storage medium.

  Next, the master table acquisition unit 136 acquires the acquired master table identification information “code list table”, the data area information read in step S308 “master management server device identifier: ccf15c47..., Database identifier 466703ef. .. ”Is used to construct a search expression for acquiring the master table (for example,“ Select all from 466703ef...: Code list table ”).

  Next, the master table acquisition unit 136 searches the master management server device 12 identified by the master management server device identifier “ccf15c47...” Included in the read data area information with respect to the configured search expression (for example, “ "Select all from 466703ef ...: code list table").

  Next, the master table transmission instruction receiving unit 122 of the master management server apparatus 12 identified by the master management server apparatus identifier “ccf15c47...” Receives the inquiry and reads the code list table from the database 121. Then, the master table transmission unit 123 transmits the read code list table to the information terminal device 13.

  The master table acquisition unit 136 of the information terminal device 13 receives the code list table. Then, the master table output unit 137 outputs the master table 132 as shown in FIG. The master table 132 is a menu using only the “meaning” attribute value of the code list table of FIG. Needless to say, when the user selects an item of one menu in the master table 132, a code corresponding to the selected item is input to the field “code”.

  As described above, according to the present embodiment, it is possible to reduce the influence of correction of the master table and achieve load distribution. That is, for example, in the present embodiment, a master table group is held in one or more master management server devices. Therefore, when only the master table used by one or more users is modified, there is no need to modify the master table used by other users. In this embodiment, when a master table group is held in two or more master management server devices, the master table group held by each master management server device is a table group having the same name. Is preferred. This is because the application execution unit 132 in the information terminal device 13 can be realized by the same program or the like.

  Further, according to the present embodiment, when a change occurs in the master management server device 12 in which the master table exists, the software of the information terminal device 13 does not need to be changed at all, and the data area of the main server device 11 Since only the information needs to be changed, it is highly customizable.

  In addition, the system configuration according to the present embodiment is extremely effective for business software having tens or hundreds of master tables. Also, it is extremely effective for business software that uses different master tables depending on user attributes (such as authority and department).

  Further, according to the present embodiment, it is possible to access a master table that exists in a different device for each user, and as a result, load distribution can be achieved.

  Furthermore, according to the present embodiment, by acquiring data area information after an application activation instruction, the data area information can be acquired at an appropriate timing, and the user can use the application comfortably.

  Note that the processing in the present embodiment may be realized by software. Then, this software may be distributed by software download or the like. Further, this software may be recorded and distributed on a recording medium such as a CD-ROM. This also applies to other embodiments in this specification. Note that the software that implements the information processing apparatus according to the present embodiment is the following program. In other words, this program is a data that transmits a transmission instruction for data area information to the main server device when the computer receives an input from a user and the reception unit receives a predetermined first instruction. An area information transmission instruction transmission unit, a data area information reception unit that receives one or more data area information from the main server device, and the reception unit are determined in advance in response to transmission of the data area information transmission instruction. When the second instruction is received, the data area information received by the data area information receiving unit is used to access the master management server apparatus identified by the master management server apparatus identifier included in the data area information, Master table that acquires the master table stored in the database identified by the database identifier of the data area information An execution unit that executes an application that realizes a predetermined function by using an acquisition unit, a master table output unit that outputs a master table acquired by the master table acquisition unit, and an input received by the master table and the reception unit A program for functioning as a section.

  In the above program, the master table acquisition unit uses one data area information of two or more data area information to access the master management server apparatus identified by the master management server apparatus identifier included in the data area information. It is preferable to acquire a master table stored in a database identified by a database identifier included in the data area information.

  Further, in the above program, the information received by the receiving unit, one data region information of two or more data region information is selected using information for identifying a user, and the master table acquisition unit is Using the selected one data area information, the master management server apparatus identified by the master management server apparatus identifier included in the data area information is accessed, and the database identified by the database identifier included in the data area information is stored. It is preferable to obtain the stored master table.

  FIG. 14 shows the external appearance of a computer that executes the program described in this specification to realize the information terminal device or the like of the above-described embodiment. The above-described embodiments can be realized by computer hardware and a computer program executed thereon. FIG. 14 is an overview diagram of the computer system 340, and FIG. 15 is a block diagram of the computer system 340.

  In FIG. 14, the computer system 340 includes a computer 341 including an FD drive and a CD-ROM drive, a keyboard 342, a mouse 343, and a monitor 344.

  In FIG. 11, in addition to the FD drive 3411 and the CD-ROM drive 3412, the computer 341 stores a bus 3414 connected to the MPU 3413, the CD-ROM drive 3412 and the FD drive 3411, and a program such as a bootup program. ROM 3415, connected to CPU 3413, RAM 3416 for temporarily storing application program instructions and providing a temporary storage space, and hard disk 3417 for storing application programs, system programs, and data. Although not shown here, the computer 341 may further include a network card that provides connection to the LAN.

  A program that causes the computer system 340 to execute the functions of the information terminal device or the like of the above-described embodiment is stored in the CD-ROM 3501 or the FD 3502, inserted into the CD-ROM drive 3412 or the FD drive 3411, and further the hard disk 3417. May be transferred to. Alternatively, the program may be transmitted to the computer 341 via a network (not shown) and stored in the hard disk 3417. The program is loaded into the RAM 3416 at the time of execution. The program may be loaded directly from the CD-ROM 3501, the FD 3502, or the network.

  The program does not necessarily include an operating system (OS) or a third-party program that causes the computer 341 to execute the functions of the information terminal device according to the above-described embodiment. The program only needs to include an instruction portion that calls an appropriate function (module) in a controlled manner and obtains a desired result. How the computer system 340 operates is well known and will not be described in detail.

  In the above program, in the step of transmitting information, the step of receiving information, etc., processing performed by hardware, for example, processing performed by a modem or an interface card in the transmitting step (only performed by hardware). Not included).

  Further, the computer that executes the program may be singular or plural. That is, centralized processing may be performed, or distributed processing may be performed.

  Further, in each of the above embodiments, it goes without saying that two or more communication units existing in one apparatus may be physically realized by one medium.

  In each of the above embodiments, each process (each function) may be realized by centralized processing by a single device (system), or by distributed processing by a plurality of devices. May be.

  The present invention is not limited to the above-described embodiments, and various modifications are possible, and it goes without saying that these are also included in the scope of the present invention.

  As described above, the information processing system according to the present invention has an effect that load distribution can be achieved, and is useful as an information processing system or the like.

Conceptual diagram of the information processing system 1 Block diagram of the information processing system A flowchart for explaining the operation of the information terminal device Flow chart for explaining the operation of the data area information acquisition process Figure showing the same data area information management table Figure showing the same user management table The figure which shows the code list table which is an example of the same master table Figure showing the same master table management table Figure showing the top menu of the business support software Figure showing an example of the panel The figure which shows the example of the same screen display The figure which shows the example of the same screen display The figure which shows the example of the same screen display Overview of the computer system Block diagram of the computer system

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Information processing system 11 Main server apparatus 12 Master management server apparatus 13 Information terminal apparatus 111 Data area information storage part 112 Data area information transmission instruction reception part 113 Data area information transmission part 121 Database 122 Master table transmission instruction reception part 123 Master table transmission Unit 131 Reception unit 132 Application execution unit 132 Master table 133 Data region information transmission instruction transmission unit 134 Data region information reception unit 135 Data region information selection unit 136 Master table acquisition unit 137 Master table output unit

Claims (10)

An information processing system comprising a main server device, one or more master management server devices, and one or more information terminal devices,
The main server device is
Data area information capable of storing one or more data area information having a master management server apparatus identifier for identifying a master management server apparatus storing the master table and a database identifier for identifying a database which is a set of one or more master tables A storage unit;
A data area information transmission instruction receiving unit for receiving an instruction to transmit the data area information;
A data area information transmitting unit that transmits the data area information in response to the transmission instruction;
The master management server device
A database capable of storing one or more master tables;
A master table transmission instruction receiving unit for receiving a master table transmission instruction from the information terminal device;
In response to a transmission instruction from the information terminal device, comprising a master table transmission unit for transmitting a master table,
The information terminal device
A reception unit that receives input from the user;
A data region information transmission instruction transmission unit for transmitting a data region information transmission instruction to the main server device when the reception unit receives a predetermined first instruction;
In response to the transmission of the data area information transmission instruction, a data area information receiving unit that receives one or more data area information from the main server device;
When the receiving unit receives a predetermined second instruction, the master management server identified by the master management server device identifier included in the data region information using the data region information received by the data region information receiving unit A master table acquisition unit that accesses a server device and acquires a master table stored in a database identified by a database identifier included in the data area information;
A master table output unit for outputting the master table acquired by the master table acquisition unit;
An information processing system comprising: the master table and an application execution unit that executes an application that realizes a predetermined function using the input received by the reception unit. The data area information storage unit
2 or more data area information is stored,
The master table acquisition unit
Using one data area information of two or more data area information, the master management server apparatus identified by the master management server apparatus identifier included in the data area information is accessed, and the database identifier included in the data area information is used. The information processing system according to claim 1, wherein a master table stored in a database to be identified is acquired. The information received by the receiving unit, and using the information for identifying the user, one data area information of two or more data area information is selected,
The master table acquisition unit
Using the selected one data area information, the master management server apparatus identified by the master management server apparatus identifier included in the data area information is accessed, and the database identified by the database identifier included in the data area information is stored. The information processing system according to claim 2, wherein a stored master table is acquired. The information processing system according to claim 1, wherein the first instruction is an application activation instruction. A reception unit that receives input from the user;
A data region information transmission instruction transmission unit for transmitting a data region information transmission instruction to the main server device when the reception unit receives a predetermined first instruction;
In response to the transmission of the data area information transmission instruction, a data area information receiving unit that receives one or more data area information from the main server device;
When the receiving unit receives a predetermined second instruction, the master management server identified by the master management server device identifier included in the data region information using the data region information received by the data region information receiving unit A master table acquisition unit that accesses a server device and acquires a master table stored in a database identified by a database identifier included in the data area information;
A master table output unit for outputting the master table acquired by the master table acquisition unit;
An information terminal device comprising: an application execution unit that executes an application that realizes a predetermined function using the master table and the input received by the reception unit. The main server apparatus which comprises the information processing system in any one of Claims 1-4. The master management server apparatus which comprises the information processing system in any one of Claims 1-4. The information terminal device which comprises the information processing system in any one of Claims 1-4. An information processing method realized by a reception unit, a data region information transmission instruction transmission unit, a data region information reception unit, a master table acquisition unit, a master table output unit, and an application execution unit,
A receiving unit that receives input from a user by the receiving unit;
A data region information transmission instruction transmission step for transmitting a data region information transmission instruction to the main server device when the data region information transmission instruction transmission unit has received a first instruction predetermined in the reception step;
A data area information receiving step for receiving at least one data area information from the main server device in response to transmission of the data area information transmission instruction by the data area information receiving unit;
When the master table acquisition unit receives the second instruction predetermined in the receiving step, the master management server device included in the data area information using the data area information received in the data area information receiving step A master table acquisition step of accessing a master management server device identified by an identifier and obtaining a master table stored in a database identified by a database identifier included in the data area information;
A master table output step for outputting the master table acquired in the master table acquisition step by the master table output unit;
An information processing method comprising: an application execution step of executing an application that realizes a predetermined function using the master table and the input received in the reception step by the application execution unit. Computer
A reception unit that receives input from the user;
A data region information transmission instruction transmission unit for transmitting a data region information transmission instruction to the main server device when the reception unit receives a predetermined first instruction;
In response to the transmission of the data area information transmission instruction, a data area information receiving unit that receives one or more data area information from the main server device;
When the receiving unit receives a predetermined second instruction, the master management server identified by the master management server device identifier included in the data region information using the data region information received by the data region information receiving unit A master table acquisition unit that accesses a server device and acquires a master table stored in a database identified by a database identifier included in the data area information;
A master table output unit for outputting the master table acquired by the master table acquisition unit;
The program for functioning as an application execution part which performs the application which implement | achieves a predetermined function using the master table and the input which the said reception part received.