JP2011100233A - Master maintenance support system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To efficiently provide a master maintenance support system having a master maintenance function which is excellent in information security without depending on the skill of a business application system manager. <P>SOLUTION: The master maintenance support system includes: a screen definition information management means for storing, for each maintenance object master, master table ID, master table name, reading range, update range, master item ID, master item name, screen display presence/absence, data update possibility/impossibility, input format, and default value; a screen template storage means for storing a screen template defining the display configurations of a master maintenance screen; and a master maintenance screen generation means for mapping the screen template stored in the screen template storage means and data obtained by a database management means based on the information defined by the screen definition information management means, and for generating a master maintenance screen on which the mapping result is displayed. <P>COPYRIGHT: (C)2011,JPO&INPIT

Description

  The present invention relates to a system that supports maintenance of a master table, which is performed in daily operations of business application systems in corporations, local governments, public offices, and the like.

  Conventionally, a tool for automatically generating a master maintenance function program with simple settings has been proposed. For example, Japanese Patent Application Laid-Open No. 2005-190178 discloses a tool that automatically creates a maintenance screen that can be displayed by replacing it with arbitrary information that is easy for an operator to understand without programming each system individually. Has been.

  However, all of the known cases related to master maintenance are tools that automatically generate programs. The automatically generated program must be compiled into an executable file.

  In addition, an operation verification work for confirming whether or not the program is correctly compiled is also necessary. Preparation and maintenance of the compilation environment, compilation, and operation verification of the executable file after compilation were a heavy burden and problem for business application users and administrators who are not familiar with program development.

  Further, in the conventional technique for automatically generating a master maintenance function program as disclosed in Japanese Patent Application Laid-Open No. 2005-190178, reference restriction / update restriction of master data has not been considered.

  However, master data in business applications often has data that must be restricted so that only a limited person in charge can view or update it.

JP 2005-190178 A

  In the prior art, the master maintenance function can be generated without a program operation, but it is necessary to compile and verify the compiled executable file. In general, the person in charge who uses the master maintenance function often belongs to the department in which the business application system is used. The person in charge of the user department is often not familiar with information technology, and compiling and verifying the executable file after compilation were a heavy burden. For this reason, the range of utilization of the automatic generation function of the master maintenance function according to the prior art has been narrow.

  In addition, in general, the master maintenance work can be used only by a limited number of users and must be restricted so that only the target user can use it. This is a requirement considering information leakage countermeasures and compliance countermeasures, and is necessary for most business application systems. Therefore, in the master maintenance function of the present invention, it is necessary to be able to set the user's restrictions finely.

  In order to solve the above problems, the present invention provides a master table ID, master table name, reading range, update range, master item ID, master item name, presence / absence of screen display, data update availability, input format, for each maintenance target master. Based on the information defined by the screen definition information management means for storing the default value, the screen template storage means for storing the screen template for defining the display form of the master maintenance screen, and the screen definition information management means, the screen template storage A master maintenance screen generating unit configured to map the screen template stored in the unit and the data acquired by the database management unit and generate a master maintenance screen displaying the mapping result;

  According to the present invention, a master maintenance support system having a master maintenance function excellent in information security can be obtained efficiently without depending on the skill of a business application system administrator.

The system whole figure of the business application system which applies a general-purpose master maintenance function. FIG. 2 is a hardware configuration diagram of 10 WEB / application server in FIG. 1. The hardware block diagram of 11 DB servers of FIG. The block diagram of the user terminal which a user uses. The figure which shows the structural example of the screen definition information management table 313. 4 is a configuration example of a security information management table 314. The figure which shows the structural example of the extraction condition management table 315. FIG. The figure which shows the structural example of the screen template 215. FIG. A flow diagram from when the business application administrator performs settings related to the master maintenance screen until the settings are saved and actually used by the user. FIG. 10 is a flowchart from when the master maintenance screen is activated by the master maintenance function 214 of FIG. 9 to when the screen opens. FIG. 10 is a detailed flowchart of security control information setting 1002. FIG. 11 is a flowchart detailing the template-acquired item mapping 1004 of FIG. The figure which shows the example of a master maintenance screen. The figure which shows the example of the screen which designates a maintenance object master.

  Embodiments of the present invention will be described below with reference to the drawings.

  FIG. 1 is an overall system diagram of a business application system to which the general-purpose master maintenance function of the present invention is applied, and corresponds to claims 1, 2, 3, and 4. In FIG. 1, 10 is a WEB / application server, 11 is a database (DB) server managed by RDBMS, and 12 is a user terminal, each connected to a network.

  FIG. 2 is a hardware configuration diagram of the WEB / application server 10 in FIG. Reference numeral 200 denotes a control unit, and 203 denotes a network interface unit. Reference numeral 211 denotes a business application, which provides functions necessary for daily work of the user. A master maintenance function 213 provides a general-purpose master maintenance function. Reference numeral 214 denotes a master maintenance screen definition setting function, which is a screen for inputting setting values of the master maintenance function 213. The screen template 215 defines the screen layout (color, font, table format) of the master maintenance function 213.

  FIG. 3 is a hardware configuration diagram of the DB server 11 in FIG. Reference numeral 300 denotes a control unit, and 303 denotes a network interface unit. 311 is a commercially available database management system (RDBMS), which manages a database (DB). A table 312 has a business application system. Reference numeral 313 denotes a screen definition information management table in which main setting values of the master maintenance function are stored. Reference numeral 314 denotes a security information management table, which defines groups for grouping users of business application systems from the viewpoint of data reference / update. Reference numeral 315 denotes an extraction condition management table, which defines extraction conditions for extracting the contents of the business application table by the master maintenance function. The screen definition information management table 313, the security information management table 314, and the extraction condition management table 315 are input from the screen definition information setting function 213 described later.

  FIG. 4 is a configuration diagram of a user terminal used by the user. Reference numeral 400 denotes a control unit, 402 denotes an input unit such as a keyboard / mouse, 403 denotes a display unit such as a display device, and 404 denotes a network interface unit. Reference numeral 401 denotes a storage unit. When a business application is used from a user terminal, it is used via a 411 web browser. For this reason, the user terminal program for the present invention is not installed in the user terminal.

  FIG. 5 is a diagram illustrating a configuration example of the screen definition information management table 313. In the screen definition information management table 313, the ID of the master table that is the target of the master maintenance function, whether or not it can be updated, the presence or absence of display for each master table item, and the input format are set. The general-purpose master maintenance function displays a master maintenance screen for each master table based on the setting information.

  The items of the screen definition information management table 313 are described below. A master ID 501 that is a unique ID of the target master table is a primary key of the screen definition information management table 313. The master name 502 is the name of the master displayed on the screen when displaying the master maintenance screen of the target master. The use template 503 is an item for designating which of a plurality of types of screen templates 215 is used. A reading range 504 designates a user range that can be referred to for the target master. The range is defined in the security information management table 313. The update range 505 designates a user range that can be updated for the target master. The range is defined in the security information management table 313 similarly to the reading range 504. Items from item name 1 506 to default 1 512 are repeated for the number of items. Item name 1 506 is an item that defines the name of an item on the master maintenance screen. An item ID 1 507 is an item for setting an item ID on the master table and associating the master table item with the screen. Key item 1 508 indicates whether the item is the main key on the master maintenance screen. Use 1 509 sets whether to display the item on the master maintenance screen. Data update presence / absence 1 510 defines whether or not update of the item is permitted. However, even if the data update presence / absence 1510 is set to be updateable, a user whose update range 505 is out of range cannot be updated. Input format 1 511 indicates an input method on the master maintenance screen. TEXT, checkbox, radio, etc. can be used according to the HTML INPUT attribute format. Default 1 512 sets a value to be initially displayed on the screen. Display length 1 513 sets the display length of the item on the screen in units such as cm.

  FIG. 6 is a diagram showing a configuration example of the security information management table 314. A range 61 is an ID of a group in which users are grouped from the aspect of access security to the master table such as reference availability / update availability. The name 62 is a name that clearly indicates the range 61. The check determination character string 63 is used in comparison with the execution result of the check script 64. The check script 64 written in SQL, which is the RDBMS operation language, returns information that can be used to determine what attribute the logged-in user has in terms of security requirements when executed by substituting the ID of the logged-in user in the conditional phrase. Set.

  The security information management table will be described with reference to the example of FIG. There are three groups from the viewpoint of security 61, that is, A, B, and C. “System department only” formed only by the system management department of the business application system, and management of the system utilization department in addition to A "System department + user department administrator" added by the administrator and "All" representing all users who use the system are assigned. Assign the check script 64SELECT emp_type from emp where emp_id = LOGIN_ID to the user ID (eg '1111') to LOGIN_ID and execute "SELECT emp_type from emp where emp_id = '1111'" in the DB The user's employee classification (emp_type) is returned. In the business application system shown in the example, the employee divisions “1” and “2” are users in the system department with a wide authority. Therefore, the check target character string 63 for A in the range 61 is “1” and “2”. If the result of the check script 64 is either “1” or “2”, the user “1111” can specify that the range 61 is A.

  The storage location on the database of employee categories and the character strings used as employee categories differ from system to system. However, most business application systems have such a division. Therefore, if the security information management table 314 is set according to the target business application system, the general-purpose master maintenance function can specify the range 61.

  FIG. 7 is a diagram illustrating a configuration example of the extraction condition management table 315. The extraction condition management table 315 is a table that defines extraction conditions for each master table. Master ID 71 defines the ID of the master table to be extracted. The deletion flag 72 defines the item ID of the deletion flag in the target master table. The deletion flag is an item for setting a flag, which is a mark of deletion when a record is logically deleted. In business application systems, in order to leave an audit trail and to repair when data inconsistency occurs, it is often possible only to enter a value in the deletion flag without deleting the record. This is called logical deletion. The deletion flag unused 73 defines whether the item of the deletion flag 72 is added as a condition at the time of extraction. If Y, delete flag is used. If N, do not use. The extraction condition 74 is an SQL that describes the extraction condition for displaying master data on the master maintenance screen. The example of “LOGIN_ID” in the extraction condition 74 indicates that the user ID is substituted for this character string.

  FIG. 8 is a diagram illustrating a configuration example of the screen template 215. The screen template is described in the HTML format, and the part that changes depending on the target master table and the part that changes depending on the extracted data are variables, and are replaced when the master maintenance screen is generated. Name1 81 is a portion into which the item name is substituted. An input method on the screen is substituted for inputtype1 52. In code1 53, the item ID is substituted. In length1 54, the width of the input field is substituted. Default1 55 is assigned an initial input value. Each is substituted from the value set in the screen definition information management table 313.

  The screen template will be described with a specific example. The case where the master ID 501 of the screen definition information management table 313 is A_TAB is used. The screen definition information management table is set on the screen for entering the screen definition information management table of the general-purpose master maintenance function. If this setting is made, when the user opens the master maintenance screen, the master maintenance screen of A_TAB can be opened. The movement when the user opens the master maintenance screen of A_TAB will be described. The general-purpose master maintenance function opens the screen template and analyzes the portion to be substituted with the value of the screen definition information management table 313. First, Name 181 in the example of FIG. 8 is replaced with the component ID of the item name 1506. Next, inputtype 82 is replaced with TEXT of input format 511, code1 83 is replaced with parts_id of item ID1, and length1 84 is replaced with 15 of display length 513. For default1 85, the value extracted from the master table is substituted. However, the value of default 1 512 is replaced only when a new record is input.

  FIG. 9 is a diagram for explaining the outline from the present invention to the business application administrator using the general-purpose master maintenance function to perform settings related to the master maintenance screen, storing these settings, and actually using them by the user. . The general-purpose master maintenance function is installed in the WEB / application server 10 and the DB server 11.

  Thereafter, the business application system administrator uses the screen definition information setting function 213 to set the setting information for the master maintenance screen. The setting information is stored in the screen definition information management table 313, the security information management table 314, and the setting information is stored in the extraction condition management table 315. The settings related to the master maintenance screen are completed with the saved dictionary, and after this time, if the user opens the master maintenance function 214, the master maintenance screen of the master table can be used.

  FIG. 10 is a flowchart from when the master maintenance function 213 installed in the WEB / application server is activated by the user until the master maintenance screen is displayed. When the master maintenance screen is set by the business application system administrator, the screen definition information management table 313, the security information management table 314, and the setting information are stored in the extraction condition management table 315, and the user starts the master maintenance function 213, the master maintenance function The screen definition information management 313 table and the security information management table 314 extraction condition management table 315 are read 1001.

  A specific example of the process 1001 will be described. When the user activates the master maintenance function 213, the target master for performing the master maintenance is designated on a screen for selecting a maintenance target master such as the screen 216 in FIG. Assume that the part master maintenance screen 1401 is selected on the screen 216. The screen 216 stores the master ID = A_TAB information in the HTML session. Since the master maintenance function 213 is linked from the screen 216, the master maintenance function 213 is activated. The master maintenance function 213 takes out information of master ID = A_TAB from the session and searches the screen definition information management table 313 using this information as a key. As a result, in the example of FIG. 5, a record stored in the screen definition information management table 313 and having the master ID 501 of A_TAB is searched.

  Subsequently, security control information is set 1002. Details of the processing 1002 will be described later with reference to FIG.

  Next, based on the information in the extraction condition management table 315, data of the target master table which is one of the business application tables is extracted 1003.

  A specific example of the process 1003 will be described. The master maintenance function 213 takes out information of master ID = A_TAB from the session and searches the extraction condition management table 315 using this information as a key. As a result, in the example of FIG. 7, the record with the master ID 71 of A_TAB can be acquired. In this record, the extraction condition 74 is “where check_flg =“ 2 ””, the deletion flag unused / unused is Y, and the deletion flag 72 is del_flg. From this information, the master maintenance function 213 generates a SQL “SELECT parts_id, parts_name,... From A_TAB where check_flg =“ 2 ”and del_flg =“ Y ”” and executes it. The execution result is stored in the storage area for each user in the storage area in the form of a table.

  The master maintenance function 213 maps the search result of the SQL, the search result of the screen template 215 and the screen definition information management table 313 to generate HTML 1004. The master maintenance function 213 displays the generated HTML on the user terminal 13 with the function of the WEB server.

  FIG. 11 is a detailed flowchart of the security control information setting 1002 in FIG. A case where the range 61 is “A”, “B”, and “C” as in the security information management table 314 of FIG. 6 will be described as an example. The user performs login processing by a mechanism unique to the business application system before opening the master maintenance selection screen 216. User-specific information is stored in the HTML session by the login process. The master maintenance function 213 acquires 1103 the user's login ID among the user-specific information. In this example, it is assumed that 1111 can be acquired as the login ID. FIG. 6 Substitute 1111 for LOGIN_ID of the check script 64 and execute SQL 1104. Assume that the return value of this SQL is 3, for example. It is confirmed 65 whether this 3 is included in the check determination character string 64 of FIG. In this case, since the check determination character string 64 in the range 61 A is 1 and 2 and 3 is not included, it is determined that the user ID 1111 is not included in the range A. This process (1102 to 1105) is repeated for the range 61 minutes, and the determination is made for all the ranges. In this example, the process is repeated for A, B, and C in the range 61. The determination result is stored 1106 in the user storage area of the storage unit.

  FIG. 12 is a detailed flow of the template 1004 mapping 1004 of FIG. Description will be made by taking as an example a record in which the master ID 501 of the screen definition information management table 313 in FIG. 5 is A_TAB.

  In the process 1203, since the item setting information is stored in the A_TAB record by the number of screen items, the master maintenance function 213 performs a process of extracting setting information regarding the first screen item. The first screen item is a component ID column 133 in the component master maintenance screen 800 of FIG. 13 which is an example of the displayed master maintenance screen. This item is defined by item ID 1 507, key item 1 508, usage 1 509, data update 1 510, input format 1 511, default 1 512, display length of the screen definition information management table 313 in FIG. 1 513. Therefore, in the process 1203, these items are cut out.

  In the process 1204, the range 61 stored in FIG. 11 is compared with the reading range 504 to determine whether it is within the reading range. In the example, the reading range 504 is C. The user ID 1111 that is the login user is out of the range 61 A in the description of FIG. Further, as a result of further processing in FIG. 11, it is assumed that the range 61 is B for the user ID 1111. The reading range 504 is C, and the user range 61 is B. When the reading range 504 is C, all users belonging to the upper range 61 (A, B, C) can be read. Accordingly, the process proceeds to processing 1205. If it is outside the reading range, in step 1214, the item is deleted together with the HTML tag.

The process 1205 is not performed if the use / non-use 1 of the screen definition information management table 313 is used, and if it is not used, the item is deleted for each HTML tag in process 1214.
A process 1206 is a process for replacing the Name 181 of the screen template with the item name 1 506 of the screen definition information management table 313. As a result, the name of the item can be displayed in an easy-to-understand notation on the displayed master maintenance screen. In the example, the acquisition result of item name 1 is the component ID, so Name1 is replaced with the component ID.

  For the process 1207, a determination process similar to the process 1204 is performed. In the example, the user's range 61 is C and the update range is B, so the user cannot update. Therefore, the process proceeds to process 1211.

  In processing 1211, the master maintenance function 213 invalidates the INPUT attribute of the target item, and makes the target item a display-only item that cannot be updated. In the example, <input type = inputtype1 name = code1 size = length1 value = default1> in the screen template 215 in FIG. 8 is replaced with a character string “default1”.

  Regarding the processing 1208, the master maintenance function 213 makes a determination on data update available 1501 in the screen definition information management table 313. If data update available 1 510 is not updatable, the process advances to step 1211.

  The process 1209 will be described by way of example. The master maintenance function 213 acquires the input format 1 acquired in process 1203. Since it is TEXT in the example, inputtype1 82 of the screen template 215 is replaced with TEXT.

  In the case of the process 1210, as in the case of the process 1206, in the case of the example, the master maintenance function 213 acquires the value 15 from the display length 153 and replaces it with the length 1 84.

  The process 1212 will be described. A process 1212 is a process for inserting the extracted data from the master table acquired in the process 1003 of FIG. 10 into the template. As a result of the processing 1003 in FIG. 10, it is assumed that a value of A0001 can be acquired as parts_id 507. Replace A0001 with the string default1. With this replacement, A0001 is set as a display-only item if the processing 1207 is performed, and A0001 is set as the default value of the input item if the processing 1207 is not performed.

  A process 1213 is a key item setting process. When the acquisition result of the key item 1 508 of the screen definition information management table 313 is Y (key item setting is present), the font tag of the item is replaced, and the character is changed to red.

  These series of processes (processes 1202 to 1209) are repeated for the number of items. Therefore, if there are 10 items in one master table, the process is repeated 10 times for each item.

  In this way, the screen maintenance function 213 replaces the template with the acquired item of the screen definition information management table 313 and the item acquired in the process 1004 to create an HTML file. The created HTML file is transmitted to the user terminal 12 by the screen maintenance function 213, and is displayed on the WEB browser 411 of the user terminal 12 as shown in FIG.

  Although the embodiments of the present invention have been described above, according to the embodiments of the present invention, master maintenance having a master maintenance function excellent in information security efficiently without depending on the skills of business application system administrators. A support system can be provided.

  Further, according to the embodiment of the present invention, it is possible to reduce the number of program ram development man-hours by providing a master maintenance function without developing the program.

  Further, according to the embodiment of the present invention, by providing the master maintenance function without compiling the program, it is possible to reduce the operation load of the business administrator who generates the master maintenance function.

  Furthermore, according to the embodiment of the present invention, it is possible to set a user that can be referred to / updated for each master table, so that an information leakage countermeasure can be taken with a minimum number of man-hours.

  Further, according to the embodiment of the present invention, the function of changing the screen color, character color, character font, and table form by the screen template contributes to making the master maintenance function easier to use, and the productivity of the master maintenance work. It leads to improvement.

  DESCRIPTION OF SYMBOLS 10 ... WEB / application server, 11 ... DB server, 12 ... User terminal, 13 ... Network, 211 ... Business application, 213 ... Master maintenance function, 214 ... Master maintenance screen definition information setting function, 215 ... Screen template, 216 ... Master maintenance selection screen 311 ... Database management system (RDBMS), 312 ... Business application table, 313 ... Screen definition information management table, 314 ... Security information management table, 315 ... Extraction condition management table, 411 ... WEB browser.

Claims (3)

Screen definition information management means for storing master table ID, master table name, reading range, update range, master item ID, master item name, screen display presence / absence, data update availability, input format, default value for each maintenance target master ,
Screen template storage means for storing a screen template for defining a display form of the master maintenance screen;
Based on the information defined by the screen definition information management means, the screen template stored in the screen template storage means and the data related to the master maintenance screen acquired by the database management means are mapped, and the mapping result A master maintenance screen generating means for generating a master maintenance screen displaying
A master maintenance support system. Group information setting means for setting group information of users that can be referred to and updated for each master table; and means for restricting reference to and updating of the master table according to the contents set by the group information setting means Have
The master maintenance support system according to claim 1, wherein: In the screen template, the background color, the character color, the font of the character, and the form of the table in the master maintenance screen are specified,
The master maintenance screen generation means generates the master maintenance screen according to the designation information.
The master maintenance support system according to claim 1 or 2, wherein

Images