JP2007026389A - Data input device - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To input, delete and update all pieces of data required for data over a plurality of pictures or a plurality of tables of a data base in block by a single operation not by inputting update data at each table but by uploading a sheet in which all pieces of input data are preliminarily described to a system in the data update of the data base. <P>SOLUTION: A correspondence table between update activity menus and item names of an input table required for the update activity menus and a correspondence table between the item names of the input table and item names of the table are stored in a setting file storage device, a table update instruction creation device creates table update instructions for substituting item values inputted in a data sheet input/output device in the item values of each table corresponding to the input table by referring at each table by referring to the correspondence table of the setting file storage device and updates item values of each table in block by the execution of the table update instructions. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to a technique for improving a man-machine interface for efficiently inputting data into a database in a WEB system in which data is stored in a database and necessary data can be searched.

  The WEB system is a technique for inputting / outputting data for an application using an Internet browser from the viewpoint of saving the cost of creating a program and unifying a user interface.

  In many cases, the screen of the WEB system is the same as the screen for data update input and the screen for data inquiry, and input, update, deletion, inquiry, and the like are performed by using buttons provided on the screen.

  However, this method is inconvenient when there are many types of screens, and it is necessary to repeat screen operations many times when inputting or updating a large number of cases at once.

  When the input data of one screen is limited to one table of the database on a single screen, the data of one table is converted to Excel (registered trademark) by the function of the database application Access (registered trademark) of Microsoft, for example. It is possible to fill in the target database via the Access database by filling in the spreadsheet software sheet, etc., but if the data entered at once is spread over multiple tables, input data items It was inconvenient because it was necessary to repeat the batch input operation for each table several times.

In Patent Document 1 (Japanese Patent Laid-Open No. 11-345234), there is a description of an invention in which information necessary for selecting a candidate for personnel change is downloaded from a database and stored in a CSV file in a personnel information system. An object of the present invention is to use a CSV format file so that a search function necessary for selection processing can be performed not by application development but by a function of spreadsheet application software. Neither the problem for improving the efficiency of data input, nor the solution, are shown. The download item selection method is also a method of selecting an organization chart and the like, and the item selection is less versatile than the menu method of the present invention.
Japanese Patent Laid-Open No. 11-345234

  In order to eliminate the disadvantages of the user interface, the present invention does not input a plurality of items for each of a plurality of screens or for each table of a database, but a system in which a sheet in which all input data is described in advance is used. Uploading all the necessary data for a plurality of screens or data spanning a plurality of tables in a database in a single operation.

  In order to solve the above-mentioned problem, the first one of the present invention is a database storage device for storing a database composed of a plurality of tables, preset in correspondence with a plurality of update operation menus for the database. A data sheet input / output device that is an input table and displays an input table including item names and item value input fields for all items to be input, and can input item values in each item value input field A comparison table between the update job menu and the item names of the input table necessary for the update job menu, and a setting file storage device for storing a comparison table between the item names of the input table and the item names of the table, To substitute the item value input to the data sheet input / output device into the item value of each table corresponding to the input table with reference to the comparison table of the setting file storage device A data input device comprising a table update command creation device that creates a table update command for each table, and a database management device that executes the table update command and updates the item values of each table collectively It is.

  According to a second aspect of the present invention, there is provided the data input device according to the first aspect, wherein the data sheet input / output device is a computer in which a spreadsheet application is installed.

  According to the third aspect of the present invention, in the database application system, a menu corresponding to various business events that require database update is prepared, and a menu item set in advance and corresponding to the menu are selected by selecting the menu. If you select a normal menu item by referring to the comparison table with the data item that needs to be added, updated, or deleted to the database, the data item name and update corresponding to the selected menu item In the case of deletion, the item value is output and displayed as the data item name and item value of the data sheet that can be operated with spreadsheet software, and the database can be updated if a special item is selected from the menu All data items are displayed and output as submenus, from which the user can In the case of updating and deleting selected item data item name, the item value is output and displayed as a data item of a data sheet that can be operated by spreadsheet software, and in each horizontal column of the data sheet, It is possible to input multiple data items that have been set, and for specific key items of the data items, the data input in the vertical direction is restricted so that only different values can be input. For all lines, the data items have processing category items that allow only three different values, and each column in the vertical direction is set so that data input for each column can be repeated. Data sheet, database consisting of multiple tables, data items in the database table corresponding to each item in the input data sheet A reference list to be linked, a mechanism for generating an instruction to add / update / delete data of the table of the database determined by the control list for all data items of the data sheet, and each item of the data sheet This is a data processing device consisting of a mechanism that creates a message according to the type of processing exception when a processing exception occurs when generating an instruction to add, update, or delete data in the table. By inputting the data into each cell, the corresponding data in the database can be obtained with the data in the corresponding row according to three different values of the processing category items of each line of the data sheet or the processing category determined by the selected menu. This is a data input device that can add, update, and delete records in each table.

  When updating the data with this input sheet, in the current database, download the data to be updated this time and the data that needs to be referenced in order to perform the data update from the database to the input sheet, Download data can be reused.

  At this time, since abundant functions of spreadsheet software such as Excel are used, there is an advantage that update data can be efficiently created.

  In addition, in the present invention, since data entry items for each case are set by menu setting, even if a data-related specification change occurs, it can be handled only by changing the menu setting, and the frequency of changing the originally developed program can be changed. This reduces the program maintenance efficiency.

  Further, even in the development of a new system, if all database update processing is performed by the “data input function” of the present invention, the screen design for data input becomes unnecessary, and the development man-hour can be greatly reduced.

  In addition, in the data sheet creation process that displays the required items using the menu, if the attribute is determined by the data item, the data entry efficiency can be improved by adopting the attribute of the cell in the data sheet. It is.

  FIG. 1 is a block diagram showing an example of the data input device of the present invention. In FIG. 1, the data sheet output device 1 has a function of outputting a data item of input data corresponding to a selected menu item to a data sheet S with reference to the setting file A.

  In the setting file A, the data item name of the data sheet S corresponding to the menu item name is linked, and in the case of update and deletion, the setting file B is also referred to and stored in the database. The data value corresponding to the data item is also output to the data sheet. The setting files A and B are stored in the setting file storage device 5.

  The classification device 2 has a function of reading a data sheet S in which input data is described, and classifying each input data item described (described) on the sheet in units of tables.

  The table update command creation device 3 (3-1 to 3-3) has a function of creating a command for updating a table using data for adding, updating, and deleting the same table. There are as many table update instruction creation devices 3 as the number of tables to be updated (3 tables in the example of this figure).

  The database management device 4 reads data from the database DB in the DB storage device 6 in response to an instruction from the data sheet output device 1, or executes commands created by the table update command devices 3-1 to 3-3. Execute to actually manipulate the database table data. This database management device 4 can divert the function of an existing commercial DBMS.

  The processing exception execution device 7 is executed when a processing exception is detected in the processing in the data sheet output device 1, the classification device 2, and the table update instruction creation devices 3-1 to 3-3. Has a function of creating and outputting a message M according to the type of message.

  Hereinafter, the present invention will be described with reference to an example of a personnel information system. 2 and 3 are explanatory diagrams for comparing and explaining the conventional personnel information system and the one according to the present invention, respectively.

  As shown in FIG. 2, in the conventional personnel information system, for example, basic personnel data such as an employee's address, data relating to commuting information, and data relating to educational background information are provided for input / search, and new employees are provided. In the case of inputting the data, it is necessary to input data from the screen by repeating the number of new employees for each screen of the basic personnel data screen, the commuting information screen, and the educational information screen.

  On the other hand, in the personnel information system according to the present invention, as shown in FIG. 3, basic personnel data, commuting information data, and educational information data for all new employees are entered in one data sheet and uploaded. Can be entered. For this reason, it is possible to greatly reduce the labor of the input operation as compared with the conventional case.

  An input example according to the present invention will be described in which data of three new employees are input. When the data input device of the present invention is activated, a main menu screen shown in FIG. 4 is displayed. In this case, since new employee data is input, when (1) New employee input is selected from the main menu a, the screen of the data sheet b (FIG. 5) is output. .

  The setting file B of the setting file storage device 5 includes a comparison table c between the data items of the data sheet and the data items of the database table as shown in FIG. The table update command creation device 3 is activated according to the classification.

  The table update command creation device 3 creates and executes commands for the basic personnel table, the commuting information table, and the educational history information table as shown in FIGS. 7, 8, and 9 corresponding to each classification. The This command statement is delivered to the database management device 4 and executed, and the data to be added is as shown in FIG. 10, FIG. 11, and FIG.

  Here, only the employee number 2000, “Suzuki” and the employee number 2001, “Yamada” are added, and the employee number 2002, “Yoshida” are not added. However, the data of “Yoshida” is essential for the personnel basic table. This is because the date of birth, which is an input item, is missing. In this case, the process exception message shown in FIG. 13 is output.

  Hereinafter, the above-mentioned “Yoshida” data is additionally input by the following exception processing. When (4) Other is selected in the main menu a of FIG. 4, all items of the database are displayed as submenus as shown in FIG. Select all items in this submenu. As a result, a data sheet as shown in FIG. 15 is output. Since the category is addition, enter “Add”. The following processing is the same as that for new employee input.

  When the address of “Yamada” is changed, when (2) Change of address is selected in the main menu “a” in FIG. 4, the display output items on the data sheet are displayed as “ Employee number ”,“ address ”,“ commuting means ”,“ commuting time ”, and the corresponding data items in the database are bangou and jyuusyo in the personnel basic table, bangou, syudan, and jikan in the commuting information table, Since the address change is a data update, the SQL statement of FIG. 16 is issued to the personnel basic table and the commuting information table to read the data from the database, and as shown in FIG. Output data values to datasheet.

Since this menu is for updating only, the processing category is not output to the data sheet. (It is automatically updated.)
In the data sheet of FIG. 16, the address change, commuting means, and commuting time of “Yamada” are changed from Tokyo → Chiba, bus → train, 0.5h → 1h as shown in FIG. If you delete the unchanged rows in this data sheet and upload them in a batch, the SQL statement in Fig. 19 is issued, the tables in the database are updated, and the address, commuting means, and commuting time data for "Yamada" are updated. Is done.

It is a block diagram which shows an example of the data input device of this invention. It is explanatory drawing for demonstrating the conventional thing of a personnel information system. It is explanatory drawing for demonstrating what is based on this invention of a personnel information system. It is a main menu screen in the embodiment of the present invention. It is a screen of a data sheet displayed when new employee input is selected. It is a contrast table of the data item of a data sheet, and the data item of a table of a database. It is a command sentence to a personnel basic table in an example. It is the command sentence with respect to the commuting information table in an Example. It is the command sentence with respect to the educational history information table in an Example. It is a table | surface which shows the data added to a personnel basic table by a command sentence. It is a table | surface which shows the data added to a commuting information table by a command sentence. It is a table | surface which shows the data added to an educational history information table by a command sentence. This is an output processing exception message. This is a submenu that is displayed when Other is selected in the main menu. This is a data sheet that is output when all items are selected in the submenu. This is an SQL sentence for the basic personnel table and the commuting information table that are output when the address is changed. It is an example of the original data sheet output at the time of an address change. It is an example of what updated the data sheet output at the time of an address change. It is an example of the SQL sentence output at the time of an address change.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Data sheet output device 2 Classification device 3 Table update command creation device 4 Database management device 5 Setting file storage device 6 DB storage device 7 Processing exception execution device

Claims (3)

A database storage device for storing a database composed of a plurality of tables;
It is an input table set in advance corresponding to a plurality of update operation menus for the above database, and an input table including item names and item value input fields is displayed for all items to be input, and each item value is input. Data sheet input / output device that can input item values in the field,
A setting file storage device for storing a comparison table of the item names of the input table necessary for the update operation menu and the input table necessary for the update operation menu, and a comparison table of the item names of the input table and the item names of the table;
Referring to the comparison table of the setting file storage device, create a table update instruction for each table to substitute the item value input to the data sheet input / output device for the item value of each table corresponding to the input table. A table update instruction creation device, and
A data input device comprising a database management device that executes the table update instruction and updates the item values of each table at once. The data input device according to claim 1, wherein
The data input / output device is a computer in which a spreadsheet application is installed.   In the database application system, menus corresponding to various business events that need to be updated are prepared, and by selecting a menu, preset menu items and data addition, update, and update to the database corresponding to the menus are performed. Referring to the comparison table with the data item that needs to be deleted, if a normal menu item is selected, the data item name corresponding to the selected menu item and the item value in the case of update and deletion are displayed. Output and display as data item names and item values of data sheets that can be operated with calculation software, and when a special item is selected from the menu, display and output all data items that can be updated in the database as submenus The item data item name selected by the user from the submenu In addition, in the case of update and deletion, it has a function to output and display item values as data items of data sheets that can be operated with spreadsheet software, and a plurality of data set in advance in each horizontal column of the data sheet It is possible to input items, and for certain key items in the data items, the data input in the vertical direction is restricted so that only different values can be input. Furthermore, the data for all lines of the data sheet There are 3 types of processing items that allow only different values in the item, and in each vertical line, a data sheet and a plurality of tables set so that data input of each column can be repeated A reference list that associates each item of the input data sheet with the data item of the corresponding database table. A mechanism for generating an instruction to add / update / delete data of the table of the database determined by the comparison list for all data items of the data sheet, and adding data of the table of the database from each item of the data sheet A data processing device consisting of a mechanism that creates a message according to the type of processing exception when a processing exception occurs when generating an instruction to update / delete, and to input data to each cell of the data sheet According to the processing category determined by the three different values of the processing category items of each line of the data sheet or the selected menu, the record of each table corresponding to the database is added with the data of the row, A data input device that can be updated and deleted.

Images