JP5982135B2 - Data management device - Google Patents

Description

  The present invention relates to a data management apparatus that manages data using a table.

  For example, when performing data management processing to manage data related to employment of employees of companies, etc., it is necessary to perform processing for each employee for multiple employees, and work classification, work start time, work end time, etc. There are multiple items required for processing. Therefore, in the data management process related to employment, for example, a table (or table) is prepared, a plurality of employees are assigned to a plurality of rows of the table, a plurality of items are respectively assigned to a plurality of columns of the table, It is preferable to use a method of inputting data to each cell of the table, that is, each cell. Such a method can be realized, for example, by operating spreadsheet application software on a personal computer.

  Further, depending on the spreadsheet application software, various methods such as a text box, a check box, and a combo box are prepared as methods for inputting data into the cells of the table. The text box is a method for directly inputting a numerical value, a character string, or the like into a cell. The check box is a method for determining whether or not to select a preset option depending on whether or not the check box is checked. The combo box is a method of displaying a plurality of preset options and selecting a desired option from the displayed options (see Patent Documents 1 and 2).

  Also, in the data management process related to employment, some typical data to be entered such as employee affiliation, work classification, etc. can be determined in advance. There is an item in which it is desirable to select one of the data. For example, the affiliation of employees is typically the general affairs department, human resources department, accounting department, sales department, technical department, public relations department, planning department, sales promotion department, etc. If the employee belongs, each of these parts is determined in advance as selectable data (options), and when actually inputting, one data is selected from these selectable data. This is convenient and efficient for data entry. For cells to which such items are assigned, it is more convenient to apply check boxes and combo boxes as input methods than text boxes.

JP 07-49774 A JP 2005-115774 A

  By the way, in a computer network system constructed by connecting a plurality of computers via a computer network, application software can be shared by a plurality of computers, and data can be shared by a plurality of computers. In recent years, a comprehensive service including the use of application software is provided from the service provider to the customer via the Internet using an environment in which the computer on the service provider side and the computer on the customer side are connected via the Internet. Cloud computing is becoming popular.

  There are the following problems when using a computer network system to realize the above-described data management processing related to work in the form of cloud computing, for example.

  In other words, when realizing data management processing related to employment in such a form, the service provider side develops and maintains codes necessary for data management processing, and performs long-term storage of data necessary for data management processing. When the customer actually performs data management processing, the code and data for data management processing are transmitted from the service provider computer to the customer computer over the Internet, and the customer computer receives the data. Data management processing is executed using the code and data. During the execution of the data management process, data may be transmitted and received between the service provider computer and the customer computer. Further, when the data management process is completed on the customer side computer, the data that needs to be updated is transmitted from the customer side computer to the service provider side computer. For this reason, if the size of the code or data required for the data management process is large, the operation speed of the data management process becomes slow and the responsiveness may deteriorate.

  Such a decrease in operation speed or deterioration of responsiveness of data management processing should be improved by improving the performance of the computer on the service provider side, the performance of the computer on the customer side, the performance of communication between the two computers, etc. Is possible. However, depending on the environment in which the customer side performs the data management process, it may be difficult to improve the decrease in the operation speed or the deterioration of the responsiveness of the data management process by such a method. For example, when a customer computer is connected to the Internet wirelessly, it is difficult to increase the communication speed as in the case of a wired connection. Further, when the customer computer is, for example, a tablet computer or a smartphone, it is difficult to increase the performance of the customer computer to the same level as a desktop large computer.

  Therefore, in order to improve the decrease in the operation speed or the responsiveness of the data management process, it is desired to reduce the size of the code or data necessary for the data management process. However, in the conventional data management process, any input method of attribute setting (for example, setting of cell size, character size, data type, etc.) and assignment of input method (for example, text box, check box, combo box, etc.) Setting for determining whether to assign), setting for the assigned input method (for example, setting of a plurality of options when a combo box is assigned) is performed for each individual cell arranged in a matrix in the table. When data management processing is realized by a web application, a code (or program) for realizing an input method such as a text box, a check box, and a combo box is conventionally provided for each cell. For this reason, it is difficult to reduce the size of code or data required for data management processing.

  On the other hand, as described above, in the data management processing related to employment, for example, regarding the input method of employee affiliation, work classification, etc., a combo box is used to select a desired option from a plurality of options. Is convenient. However, when there are many options that can be selected by the combo box, it is difficult for the user to find a desired option from a large number of options, and it may take time to find the desired option.

  The above problems may occur not only in the data management processing related to employment but also in the data management processing for managing data related to various matters such as finance, inventory, statistics, experiment, inspection and the like.

  The present invention has been made in view of the above-described problems, for example. The first object of the present invention is to improve the operation speed or responsiveness of data management processing when performing data management processing in a computer network system. An object of the present invention is to provide a data management device that can be implemented.

  A second object of the present invention is to provide a data management device capable of improving the ease or speed of a data input method of selecting a desired option from a plurality of options.

In order to solve the above problems, a first data management apparatus according to the present invention is a data management apparatus that manages data using a table, and forms a table composed of a plurality of cells arranged in a matrix. If the table forming unit that performs the process to perform and the data input to each of the plurality of cells is referred to as element data, the process of inputting the element data to the cell specified by the user according to the user's operation And a plurality of element data input units having different element data input methods and a group of a plurality of cells arranged in one column or one row in the table are referred to as a cell group. one element data input section one of the data input unit, rows assign to process common to a plurality of cells belonging to a cell group Comprising respectively an input method assignment unit that allows input of element data for the corresponding element data input section a plurality of cells belonging to the cell group in accordance with the input method according to, a storage unit for code / data set is stored, the The code / data group includes a table forming code that defines the processing contents of the table forming section, a plurality of element data input codes that respectively define the processing contents of the plurality of element data input sections, and the input method allocation. Input method assignment code that defines the content of processing of a part, table formation data that is data necessary for forming the table, and group data that is data commonly set for a plurality of cells belonging to the one cell group And the element data, each of the plurality of element data input units is assigned an identification number, and the group data Includes an identification number of any one of the plurality of element data input units, and the input method allocating unit according to the identification number of the element data input unit included in the group data, An element data input unit to be commonly allocated to a plurality of cells belonging to the one cell group corresponding to the group data is selected from the plurality of element data input units .

According to the first data management device of the present invention, the data set in common to a plurality of cells belonging to one cell group is not duplicated or distributed for each cell, but the duplication is eliminated. and by storing one Summary serial as a group data憶部, it is possible to reduce the size of data necessary for the data management process.

  Also, by assigning a common element data input section to a plurality of cells belonging to one cell group, a plurality of element data can be input for each cell to a plurality of cells arranged in one column or one row in the table. Compared with the case of assigning a copy, the size of code or data required for data management processing can be reduced.

  Therefore, even when data management processing is performed in a computer network system, the operation speed or responsiveness of the data management processing can be improved.

In order to solve the above-mentioned problem, the second data management device of the present invention is the above-described first data management device of the present invention, wherein element data is input to the plurality of element data input units by a user operation. When an input cell is selected, a plurality of options are displayed. When one of the options is selected by a user operation, the selected option is selected as element data. A selection type element data input unit for inputting to the selected cell, and the group type data of one cell group included in the code / data group includes the selection type commonly assigned to a plurality of cells belonging to the cell group. the identification number of the element data input unit, characterized in that the assigned selective element data input section contains selection data indicating a plurality of options to be displayed

According to the second data management device of the present invention, by assigning one common selection type element data input unit to a plurality of cells belonging to one cell group, the cells are arranged in one column or one row in the table. Compared with the case where a plurality of selection type element data input units are assigned to a plurality of cells, the size of code or data required for the data management process can be reduced. In particular, the input method setting data and option data for one selection type element data input unit commonly assigned to a plurality of cells belonging to one cell group are combined into one cell, excluding duplication. by storing the serial憶部as a corresponding group data, it is possible to reduce the size of data necessary for the data management process. Therefore, even when data management processing is performed in a computer network system, the operation speed or responsiveness of the data management processing can be improved.

  In order to solve the above problem, a third data management device of the present invention is characterized in that, in the above-described second data management device of the present invention, the selection type element data input unit is a combo box.

According to the third data management apparatus of the present invention, a plurality of cells arranged in one column or one row in a table by assigning one common combo box to a plurality of cells belonging to one cell group. Compared with the case where a plurality of combo boxes are assigned to each cell, the size of code or data required for data management processing can be reduced. In particular, the input method setting data and option data for one combo box that is commonly assigned to a plurality of cells belonging to one cell group are grouped into one by eliminating duplication and corresponding to the cell group. by storing the serial憶部as a, it is possible to reduce the size of data necessary for the data management process. Therefore, even when data management processing is performed in a computer network system, the operation speed or responsiveness of the data management processing can be improved.

  In order to solve the above-described problem, the fourth data management device of the present invention is the above-described third data management device of the present invention, wherein the combo box arranges a character color representing the option or the option. A background color can be arbitrarily set for each of the options.

  According to the fourth data management apparatus of the present invention, a plurality of options that can be selected by the combo box can be displayed in different colors. Therefore, the user can clearly identify the options based on the difference in color, and can easily and accurately select the options.

  In order to solve the above problem, a fifth data management device of the present invention is characterized in that, in the above-described second data management device of the present invention, the selection type element data input unit is a check box.

According to the fifth data management apparatus of the present invention, a plurality of cells arranged in one column or one row in a table by assigning one common check box to a plurality of cells belonging to one cell group Compared with the case where a plurality of check boxes are assigned to each cell, the size of code or data required for the data management process can be reduced. In particular, the input method setting data and option data for one check box commonly assigned to a plurality of cells belonging to one cell group are grouped into one by eliminating duplication and corresponding to the cell group. by storing the serial憶部as a, it is possible to reduce the size of data necessary for the data management process. Therefore, even when data management processing is performed in a computer network system, the operation speed or responsiveness of the data management processing can be improved.

In order to solve the above-described problem, a sixth data management apparatus according to the present invention is the data management apparatus according to any one of the first to fifth aspects of the present invention described above, wherein the plurality of element data input units include a user. When a cell to which element data is input is selected by the operation of, a plurality of upper options are displayed, and when one upper option of the plurality of upper options is selected by a user operation, the selection is performed. A plurality of lower options belonging to the selected upper option are displayed, and when one lower option of the plurality of lower options is selected by a user operation, the selected lower option is selected as element data. includes multistage selective element data input unit for inputting a cell that is, the group data of one cell group included in the code / data group belonging to the cell group The multi-stage selective element data and the identification number of the input unit, the upper selection data and the respective upper showing a plurality of upper choices the the allocated multi-selective element data input unit displays assigned in common to the number of cells And subordinate option data indicating a plurality of subordinate options belonging to the option.

According to the sixth data management device of the present invention, by assigning a common multi-stage selection type element data input unit to a plurality of cells belonging to one cell group, the data is arranged in one column or one row in the table. Compared with the case where a plurality of multi-stage selection type element data input units are assigned to each of the plurality of cells, the size of code or data required for the data management processing can be reduced. In particular, the input method setting data, the upper option data, and the lower option data for one multi-stage selection type element data input unit commonly assigned to a plurality of cells belonging to one cell group are combined into one by eliminating duplication. Te, by storing as a group data corresponding to the cell group in serial憶部, it is possible to reduce the size of data necessary for the data management process. Therefore, even when data management processing is performed in a computer network system, the operation speed or responsiveness of the data management processing can be improved.

  In addition, since the user can input element data using the multi-stage selection type element data input unit, even when the number of options is enormous, the options can be narrowed down easily and in a short time. That is, since a plurality of options are grouped in stages into upper options and lower options, a desired option can be finally obtained by simply repeating the operation of selecting one option from a relatively small number of options. Can be selected easily and quickly.

In order to solve the above problems, a seventh data management apparatus according to the present invention is the data management apparatus according to any one of the first to sixth aspects of the present invention described above, wherein the plurality of element data input units include a user. When a cell in which element data is input by the operation is selected, a code input unit is displayed. When a selection code is input to the code input unit by a user operation, it corresponds to the input selection code. A code input type element data input unit for selecting an option and inputting the selected option as element data into the selected cell is included, and group data of one cell group included in the code / data group includes : the identification number of the code input type element data input unit assigned in common to a plurality of cells belonging to the cell group, the assigned code input type element It characterized in that it contains a selection code data indicating the selection code correspond to the selection data and the plurality of options indicating a plurality of options that are set in over data input unit.

According to the seventh data management device of the present invention, a common code input type element data input unit is assigned to a plurality of cells belonging to one cell group, thereby arranging the data in one column or one row in the table. Compared to the case where a plurality of code input type element data input units are assigned to a plurality of cells for each cell, the size of code or data required for data management processing can be reduced. In particular, the input method setting data, the selection code, and the option data for one code input type element data input unit commonly assigned to a plurality of cells belonging to one cell group are combined into one, excluding duplication, by storing in the group data to the serial憶部corresponding to the cell group, it is possible to reduce the size of data necessary for the data management process. Therefore, even when data management processing is performed in a computer network system, the operation speed or responsiveness of the data management processing can be improved.

  In addition, since the user can input the element data by the code input type element data input unit, even if the option is not stored, if the selection code that is relatively easy to store is stored, A selection code can be input to identify an option, and the option can be easily selected.

  In order to solve the above problems, an eighth data management apparatus according to the present invention is the above-described first to seventh data management apparatus according to the present invention, wherein each group data corresponds to a cell group to which the group data corresponds. Common attribute data is included in each cell belonging to, and the attribute data includes the size of each cell, the initial value of element data input to each cell, or the data of element data input to each cell The type is included.

According to the eighth data management apparatus of the present invention, to set the common attribute data for a plurality of cells belonging to a cell group, the attribute data, duplication is eliminated in collectively serial憶部one By storing the data, the size of data necessary for the data management process can be reduced. Therefore, even when data management processing is performed in a computer network system, the operation speed or responsiveness of the data management processing can be improved.

In order to solve the above-described problem, a ninth data management device of the present invention is the above-described sixth data management device of the present invention, comprising a communication unit that receives the code / data group from a server, and the storage unit Is stored with the code / data group received from the server by the communication unit, and after the upper option is selected from among the upper options by the user's operation, the selected upper Lower option data indicating a plurality of lower options belonging to an option is received from the server and stored in the storage unit .

According to the ninth data management device of the present invention, in the multistage selection type element data input unit, for example, when the number of lower options is enormous, it corresponds to the selected upper option when the upper option is selected. Only the lower option data to be received is received from the server. This eliminates the need to receive an enormous number of subordinate options at the start of the data management process. Accordingly, since the size of data received from the server can be reduced, the operation speed or responsiveness can be improved .

In order to solve the above problems, the program of the present invention causes a computer to function as any one of the first to ninth data management apparatuses of the present invention. According to the program of the present invention, the data management apparatus according to any one of the first to ninth aspects of the present invention described above can be realized .

In order to solve the above problems, a recording medium of the present invention is a computer-readable recording medium recording a program for causing a computer to function as any one of the first to ninth data management apparatuses of the present invention. According to the recording medium of the present invention, the data management apparatus according to any one of the first to ninth aspects of the present invention described above can be realized .

  According to the present invention, even when data management processing is performed in a computer network system, the operation speed or responsiveness of the data management processing can be improved. In addition, it is possible to improve the ease or speed of the data input method of selecting a desired option from a plurality of options.

1 is a block diagram illustrating a data management system including a data management apparatus according to an embodiment of the present invention. It is explanatory drawing which shows the table in the data management process which the data management apparatus by embodiment of this invention performs. It is explanatory drawing which shows the cell and column group of the table in the data management process which the data management apparatus by embodiment of this invention performs. It is explanatory drawing which shows the code | cord | chord and data which are required for the data management process which the data management apparatus by embodiment of this invention performs. It is explanatory drawing which shows the text box in the data management process which the data management apparatus by embodiment of this invention performs. It is explanatory drawing which shows the check box in the data management process which the data management apparatus by embodiment of this invention performs. It is explanatory drawing which shows the combo box in the data management process which the data management apparatus by embodiment of this invention performs. It is explanatory drawing which shows the multistage combo box in the data management process which the data management apparatus by embodiment of this invention performs. It is explanatory drawing which shows the code input type combo box in the data management process which the data management apparatus by embodiment of this invention performs. It is explanatory drawing which shows the button in the data management process which the data management apparatus by embodiment of this invention performs.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings.

(Data management system)
FIG. 1 shows a data management system including a terminal as a data management apparatus of the present invention. The data management system 1 includes a server 2 and a terminal 3, and the server 2 and the terminal 3 are connected to be able to communicate with each other via a computer network 4 such as the Internet or an intranet. The connection between the terminal 3 and the Internet or intranet may be wired or wireless.

  The server 2 is, for example, a server computer, and an interface for communicating via a computer network 4 with a control unit 11 including a CPU (Central Processing Unit), an input / output unit 12 including a keyboard, a mouse, a display, and the like. And a storage unit 14 which is a storage device capable of storing information for a long period of time, such as a hard disk drive device.

  On the other hand, the terminal 3 is a personal computer such as a desktop type, a notebook type, or a tablet type, and may be a small and light portable computer such as a smartphone, or a large computer for business use. The terminal 3 includes a control unit 21 including a CPU, an input / output unit 22 including a keyboard, a mouse, a display, a touch panel, etc., a communication unit 23 including an interface for performing communication via the computer network 4, a hard disk drive And a storage unit 24 including a storage device such as a flash memory. The storage unit 24 is a specific example of a group data storage unit and an element data storage unit.

  In the present embodiment, the data management system 1 employs cloud computing or a form close thereto. That is, the server 2 side performs long-term storage of data (including data to be managed) necessary for performing data management processing, and development / improvement / maintenance of codes necessary for performing data management processing. When performing the data management process, the terminal 3 receives the code and data (code / data group 27) necessary for the data management process from the server 2, and the browser program 28 installed in advance in the terminal 3 receives from the server 2. Operates by reading received code and data. As a result, the terminal 3 functions as a data management apparatus that performs data management processing. The terminal 3 performs data management processing in accordance with user operations. During the execution of the data management process, code or data is transmitted / received between the terminal 3 and the server 2 as necessary. Further, the terminal 3 transmits data that needs to be updated to the server 2 during the execution of the data management process or after the end of the data management process. The server 2 receives the data transmitted from the terminal 3 and updates the data stored in the storage unit 14 of the server 2.

(Data management process)
FIG. 2 shows a table used in the data management process, and FIG. 3 shows cells and column groups constituting the table. The data management apparatus of the present invention can perform data management processing for managing data related to various matters such as work, finance, inventory, statistics, experiment, inspection, etc. In this embodiment, the data management apparatus of the present invention As an example, a case of performing data management processing for managing data relating to employment of employees of a company or the like will be described.

  The data management process is performed using a table 31 as shown in FIG. The table 31 has a grid composed of a plurality of horizontal lines and a plurality of vertical lines, and is partitioned by a plurality of rows separated by a plurality of horizontal lines and a plurality of vertical lines. With multiple columns. Each grid, that is, each of the portions where each row and each column overlap each other is a cell 32, and the table 31 is composed of a plurality of cells 32 arranged in a matrix. The overall size, number of rows, number of columns, etc. of the table 31 can be arbitrarily set by the user.

  Further, in the table 31, each row is given a unique row number, for example, a sequential row number from top to bottom, and each column is given a unique column number, for example, from left to right. The column number is assigned. Accordingly, one row can be specified based on the row number, one column can be specified based on the column number, and one cell 32 can be specified using the row number and the column number. it can.

  A user can input data into each cell 32. Hereinafter, data input to each cell 32 is referred to as “element data”. The meaning of element data to be input to each cell 32 can be arbitrarily determined by the user. For example, in the table 31 in FIG. 2, the element data “9: 00-17: 00” input to the cells 32 in the first row and the fifth column is the February 10th, 2012 of the employee with the employee number 0101. It means that the day work division is 9: 00-17: 00.

  The user can arbitrarily set the attribute of each cell 32 for each column. The attributes of the cell 32 include background color, element data display size (character size), element data display color (character color), element data type (numerical value, date, time, character string, etc.) ), Initial values (default values before element data is input by the user), and the like.

  In addition, as an attribute of the cell 32, lock on / off can be set for each column. If the lock is set to ON for one column, it becomes impossible to input / change element data to the cells 32 belonging to that column. On the other hand, when the lock is set to OFF for one column, it becomes possible to input / change element data to the cells 32 belonging to that column.

  In addition, as an attribute of the cell 32, ON / OFF of hide can be set for each column. When Hide is set to ON for one column, unless the user operating the terminal 3 is a specific user, for example, all the element data characters of the cell 32 belonging to that column are changed to “*”, and the display is changed. Even if it sees, the content of element data cannot be read. On the other hand, if Hide is set to off for one column, even if the user operating the terminal 3 is not a specific user, the element data of the cell 32 belonging to that column can be read normally. It is possible to read the contents of the element data by viewing the display. Further, when the user operating the terminal 3 is a specific user, even if Hide is set to ON, the elements of the cell 32 belonging to the column are the same as when Hide is set to OFF. The data is displayed with normal readable characters indicating the contents, and the contents of the element data can be read by viewing the display. Whether or not the user operating the terminal 3 is a specific user is determined based on an ID or the like input on a user authentication page to be described later. The specific user is, for example, a higher-level personnel manager.

  In the data management process, a plurality of element data input methods for each cell 32 are prepared. Specifically, as an element data input method for each cell 32, a text box 41, a check box 42, a combo box 43, a multi-stage combo box 44, a code input type combo box 45, a button 46, etc. are prepared (FIG. 5-10). The user can select any one input method from the plurality of input methods and assign the selected input method for each column. Details of each input method will be described later.

  Here, in this embodiment, the setting of the attribute of each cell 32 and the assignment of the element data input method to each cell 32 are performed for each column. That is, in the table 31, when a group (cell group) of a plurality of cells 32 arranged in one column is referred to as a “column group”, attribute setting for each cell 32 and element data input method for each cell 32 Allocation is performed for each column group. For example, as shown in FIG. 3, attributes set in the column group 33 of “work classification” in the table 31 and assigned input methods are as follows.

Column number: 5
Cell size: (width) 150 points Background color: White Text size: 10 points Text color: Black Data type: Time Initial value: 9: 00-17: 00
Lock: Off Hide: Off Input assignment method: Multistage combo box (identification number 4)
Top choices: working group 1, working group 2, working group 3
Subordinate options: 9: 00-17: 00, 9: 00-12: 00, ...

  In the data management process related to employment, as shown in FIG. 2, a plurality of employees are often assigned to a plurality of rows of the table 31 and a plurality of items are respectively assigned to a plurality of columns of the table 31. Therefore, in many cases, common types of data are input to the plurality of cells 32 belonging to one column. Therefore, in this embodiment, a group of a plurality of cells 32 arranged in one column is defined as a column group, and attribute setting of each cell 32 and assignment of element data input methods to each cell 32 are performed for each column group. I decided to do it. However, the data management process can be widely applied in addition to data management related to employment. Depending on the management target, a group of a plurality of cells 32 arranged in one row is regarded as a row group, and the attribute of each cell 32 is determined. And the assignment of the element data input method to each cell 32 may be performed for each row group.

(Code data required for data management processing)
FIG. 4 shows a code / data group 27 transmitted from the server 2 to the terminal 3 in order to cause the terminal 3 to function as a data management device. As described above, when performing the data management process, the terminal 3 receives the code and data necessary for the data management process from the server 2, and the browser program 28 installed in the terminal 3 has received from the server 2. Operates with reference to code and data. Codes and data necessary for data management processing transmitted from the server 2 to the terminal 3 are a code / data group 27 shown in FIG. The code / data group 27 includes a code group and a data group, and the code group includes a table formation code 61, an element data input code 62, an attribute setting / input method assignment code 63, and other codes. . The data group includes table formation data 66, group data 67, individual data 68, and other data.

  The table formation code 61, the element data input code 62, the attribute setting / input method allocation code 63, and other codes are used to operate the terminal 3 in a data management process by operating the browser program 28 installed in the terminal 3 in advance. This is a code for functioning as a data management apparatus to be performed, and is described in a markup language such as HTML (Hyper Text Markup Language), a script language such as Javascript, and the like. A web application framework such as NET is used.

  The table formation code 61 is a code for forming the table 31. The browser program 28 of the terminal 3 draws a plurality of horizontal lines and a plurality of vertical lines on the display of the terminal 3 in accordance with the table formation code 61, and displays corresponding element data in each cell 32. The table forming code 61 causes the terminal 3 to function as a table forming unit.

  The element data input code 62 is a code for inputting element data to each cell 32 by a user operation. As described above, in the data management process, the element data input method for each cell 32 includes the text box 41, the check box 42, the combo box 43, the multistage combo box 44, the code input type combo box 45, the button 46, and the like. (See FIGS. 5 to 10). The element data input code 62 includes an element data input code (text box code 71) for realizing the text box 41 and an element data input code (check) for realizing the check box 42 so as to correspond to these input methods. Box code 72), element data input code for realizing the combo box 43 (combo box code 73), element data input code for realizing the multistage combo box 44 (multistage combo box code 74), code input type combo box 45 includes an element data input code (code input type combo box code 75), an element data input code (button code 76) for realizing the button 46, and the like. The browser program 28 of the terminal 3 inputs element data into the cell 32 in accordance with the element data input code 62. With the element data input code 62, the terminal 3 functions as an element data input unit. Further, the terminal 3 functions as a selection type element data input unit by the check box code 72, the combo box code 73, the multistage combo box code 74, or the code input type combo box code 75. Further, the multi-stage combo box code 74 causes the terminal 3 to function as a multi-stage selection type element data input unit. Further, the code input type combo box code 75 causes the terminal to function as a code input type element data input unit.

  The attribute setting / input method assignment code 63 is a code for setting an attribute and assigning an input method to each column group of the table 31 in accordance with a user operation. The attribute setting / input method allocation code 63 also sets options, upper options, lower options, and selection codes. The browser program 28 of the terminal 3 performs attribute setting and input method assignment in accordance with the attribute setting / input method assignment code 63. By the attribute setting / input method assignment code 63, the terminal 3 functions as an input method assignment unit.

  On the other hand, the table formation data 66 is data necessary to form the table 31. The table formation data 66 includes, for example, data indicating the number of rows and columns of the table 31. The browser program 28 of the terminal 3 is. When the table 31 is formed according to the table formation code 61, the table formation data 66 is referred to.

  The group data 67 is data set in common for a plurality of cells 32 belonging to one column group. The group data 67 exists for each of a plurality of columns that the table 31 has. Each group data 67 includes attribute data 81, input method setting data 82, and other data.

  The attribute data 81 is data indicating attributes commonly set for the cells 32 belonging to one column group. For example, the attribute data 81 is data indicating cell size, background color, character size, character color, data type, initial value, and the like. is there.

  The input method setting data 82 is data relating to an input method that is commonly assigned to the cells 32 belonging to one column group. The input method setting data 82 includes data for specifying an input method commonly assigned to the cells 32 belonging to one column group. For example, each input method, that is, the text box 41, the check box 42, the combo box 43, the multi-stage combo box 44, the code input type combo box 45, and the button 46 has a different identification number as shown in FIG. The input method setting data 82 includes this identification number as data for specifying an input method commonly assigned to each cell 32 belonging to one column group.

  When the input method commonly assigned to the cells 32 belonging to one column group is the check box 42, option data indicating options to be displayed in the check box 42 is added to the input method setting data 82. When the input method commonly assigned to the cells 32 belonging to one column group is the combo box 43, option data indicating options to be displayed in the combo box 43 is added to the input method setting data 82. When the input method commonly assigned to the cells 32 belonging to one column group is the multistage combo box 44, the input method setting data 82 includes upper option data indicating upper options displayed in the multistage combo box 44, and Lower option data indicating the lower option is added. When the input method commonly assigned to the cells 32 belonging to one column group is the code input type combo box 45, the input method setting data 82 includes options indicating options to be displayed in the code input type combo box 45. Selection code data indicating data and selection code is added. Options, higher options, lower options, selection codes, etc. will be described later.

  The individual data 68 is data set in one cell 32. The individual data 68 exists for each of the plurality of cells 32 included in the table 31. Each individual data 68 includes attribute data 85, element data 86, and other data. The attribute data 85 includes the row number of the row to which the cell 32 belongs and the column number of the column in the table 31. The attribute data common to the plurality of cells 32 arranged in one column is included in the group data 67 corresponding to the column as the attribute data 81 as described above, and is not included in the individual data 68. On the other hand, the element data 86 is data input to the cell 32 as described above, and the data type of the element data 86 is a data type that is a part of the attribute set in the column group to which the cell 32 belongs. It depends on.

(Data management process flow)
The flow of data management processing by the data management system 1 is as follows. The storage unit 14 of the server 2 stores a code group necessary for the data management process and a data group necessary for the data management process. On the other hand, the user operates the terminal 3 using the keyboard, mouse, touch panel, etc. of the terminal 3 in a state where the terminal 3 and the server 2 are communicably connected via the computer network 4, and the browser program 28 An instruction to start is input to the terminal 3. In response to this, the control unit 21 of the terminal 3 activates the browser program 28 stored in the storage unit 24 of the terminal 3. Next, the user operates the terminal 3 and inputs a predetermined URL (Uniform Resource Locator) to the terminal 3. In response to this, the control unit 21 of the terminal 3 accesses the URL input by the user. Thereby, a web page (user authentication page) requesting input of the user ID and password is displayed on the display of the terminal 3. Subsequently, when the user inputs the ID and password, the server 2 authenticates the user. If the ID and password entered by the user are appropriate, the server 2 reads out the code group necessary for the data management process and the data group necessary for the data management process stored in the storage unit 14, and stores them. The code / data group 27 shown in FIG. Then, the terminal 3 receives this code / data group 27 and stores the received code / data group 27 in the storage unit 24 of the terminal 3 as shown in FIG.

  Subsequently, in the terminal 3, the browser program 28 refers to the table formation code 61, table formation data 66, each group data 67, each individual data 68, etc. included in the code / data group 27 to form the table 31. The formed table 31 is displayed on the display of the terminal 3 as shown in FIG. As a result, the terminal 3 functions as a data management device, and the data management process is started in the terminal 3.

  After the table 31 is displayed on the display of the terminal 3, the user operates the terminal 3 to set / change the attribute for each column of the table 31, assign / change the input method to each column, and add a column or row・ Can be deleted. When an attribute is set or changed for a certain column of the table 31, the control unit 21 of the terminal 3 stores the group data 67 corresponding to the column group of the column stored in the storage unit 24 of the terminal 3. The included attribute data 81 is set or changed. When the input method is assigned or changed for a certain column, the control unit 21 of the terminal 3 stores the group data 67 corresponding to the column group of the column stored in the storage unit 24 of the terminal 3. The input method setting data 82 included is set or changed. When a column or row is added or deleted, the control unit 21 of the terminal 3 changes the table formation data 66 stored in the storage unit 24 of the terminal 3 and, if necessary, the group data 67 Are added or changed, and individual data 68 is added or changed.

  When the user assigns a check box 42 to a certain column, the user can set / change options displayed on the check box 42 by operating the terminal 3. When a combo box is assigned to a certain column, the user can set / change options to be displayed in the combo box 43 by operating the terminal 3. Further, when the multistage combo box 44 is assigned to a certain column, the user can set / change the upper and lower options displayed on the multistage combo box 44 by operating the terminal 3. Further, when the code input type combo box 45 is assigned to a certain column, the user can set / change options and selection codes to be displayed on the code input type combo box 45 by operating the terminal 3. When an option, a higher option, a lower option, or a selection code is set or changed for an input method assigned to a certain column, the control unit 21 of the terminal 3 stores the storage unit 24 of the terminal 3, The input method setting data 82 included in the group data 67 corresponding to the column group of the column is set or changed.

  Furthermore, the user can input element data into each cell 32 in the table 31, and can change element data already input. That is, when the user designates one cell 32 with, for example, a mouse pointer, the user inputs element data into the cell 32 according to the input method assigned to the cell 32 (column group to which the cell 32 belongs). Or changes can be made. When element data is input or changed for a certain cell 32, the control unit 21 of the terminal 3 includes the element included in the individual data 68 corresponding to the cell 32 stored in the storage unit 24 of the terminal 3. Data 86 is set or changed.

  When the user finishes inputting / changing the element data, etc., operates the terminal 3 and inputs an instruction to end the data management process to the terminal 3, the control unit 21 of the terminal 3 responds accordingly. Data changed in the data management process is transmitted to the server 2, and the data management process ends. The server 2 that has received the data transmitted from the terminal 3 stores the received data or the like in the storage unit 14 of the server 2 and updates the data.

(Specific examples of input methods)
5 to 10 show specific examples of input methods used in the data management process according to the present embodiment. The input method used in the data management process will be specifically described below.

  [Text Box] When data management processing is performed in the terminal 3, when the user designates (single click) one cell 32 with a mouse pointer, for example, the control unit 21 of the terminal 3 The input method assigned to the cell 32 (the column group to which the cell 32 belongs) is selected, and the code corresponding to the selected input method is operated. As shown in FIG. 5, when the input method assigned to the column group to which the cell 32 specified by the user belongs is a text box 41, the control unit 21 of the terminal 3 uses the element data input code stored in the storage unit 24. A text box code 71 is selected from 62. Selection of the input method by the control unit 21 is performed by referring to the input method identification number included in the input method setting data 82 in the group data 67 of the column group to which the cell 32 belongs. For example, an identification number “1” is set in advance in the text box code 71. Subsequently, the control unit 21 reads the attribute data 81 and the like included in the group data 67 of the column group to which the individual cell 68 and the column 32 to which the cell 32 belongs from the storage unit 24, and the read data is the text box code 71 The text box code 71 is executed. As a result, the text box 41 is displayed in the cell 32 designated by the user, and the user can directly input the element data into the cell 32 after double-clicking the text box 41 with the mouse. For example, when a user types a numerical value, a character, etc. using a keyboard, the typed numerical value, a character, etc. are inputted into the cell 32 as element data. The control unit 21 of the terminal 3 displays the element data input by the user on the display in a form arranged in the cell 32, and after the input is confirmed, the input element data is displayed in the cell 32. Is stored in the storage unit 24 as the element data 86 included in the individual data 68 corresponding to. If the element data 86 corresponding to the cell 32 has already been stored, the past element data 86 is rewritten with the new element data 86 input this time.

  [Check Box] As shown in FIG. 2, in the table 31, an image indicating the check box 42 is always displayed in each cell 32 arranged in the column to which the check box 42 is assigned. In the storage unit 24, option data is stored as part of the input method setting data 82 in the group data 67 corresponding to the column group to which the check box 42 is assigned. As shown in FIG. 6, when the user designates one cell 32 arranged in a column to which the check box 42 is assigned, the control unit 21 of the terminal 3 causes the group data 67 of the column group to which the cell 32 belongs. The check box code 72 is selected from the element data input code 62 in the storage unit 24 with reference to the input method identification number (the identification number “2” of the check box code 72) included in the input method setting data 82 in the storage unit 24. . Subsequently, the control unit 21 reads the individual data 68 of the cell 32 and the group data 67 of the column group to which the cell 32 belongs from the storage unit 24, gives the read data to the check box code 72, and the check box code 72 Execute.

  When the user designates one cell 32 arranged in the column to which the check box 42 is assigned, the control unit 21 displays the check box 42 corresponding to the cell 32 on the display when the check box 42 is not checked. On the other hand, if the check box 42 corresponding to the cell 32 is checked, the check is removed. When the check of the check box 42 corresponding to one cell 32 is changed in this way, the control unit 21 refers to option data in the group data 67 corresponding to the column group to which the cell 32 belongs. When the check box of the cell 32 is checked, the fact that the option indicated by the option data has been selected is stored in the storage unit 24 as element data corresponding to the cell 32. When the check box is cleared, the fact that the option indicated by the option data is not selected is stored in the storage unit 24 as element data 86 included in the individual data 68 corresponding to the cell 32. Specifically, the past element data 86 corresponding to the cell 32 is rewritten to the new element data 86 this time in the storage unit 24.

  [Combo Box] As shown in FIG. 7, when the input method assigned to the column group to which the cell 32 designated by the user belongs is the combo box 43, the control unit 21 of the terminal 3 causes the cell 32 to Referring to the identification number of the input method (identification number “3” of the combo box code 73) included in the input method setting data 82 in the group data 67 of the column group to which the column belongs, in the element data input code 62 of the storage unit 24 A combo box code 73 is selected. Subsequently, the control unit 21 reads the individual data 68 of the cell 32 and the group data 67 of the column group to which the cell 32 belongs from the storage unit 24, gives the read data to the combo box code 73, and the combo box code 73 Execute. Thereby, the user can input element data to the cell 32 by a method of selecting one option from a plurality of set options.

  That is, in the storage unit 24, option data is stored as part of the input method setting data 82 in the group data 67 corresponding to the column group to which the combo box 43 is assigned. When the user designates one cell 32, the control unit 21 displays a pull-down button 48 in the cell 32. When the user clicks the pull-down button 48, the control unit 21 refers to the option data in the group data 67 corresponding to the column group to which the cell 32 belongs, and arranges a plurality of options indicated by the option data. The generated pull-down list 49 is generated, and this pull-down list 49 is displayed immediately below the cell 32 designated by the user. Then, when the user operates the terminal 3 and selects one option from a plurality of options arranged in the pull-down list 49, the control unit 21 displays the selected option in the cell 32. At the same time, the data is stored in the storage unit 24 as element data 86 included in the individual data 68 corresponding to the cell 32. Specifically, the past element data 86 corresponding to the cell 32 is rewritten to the new element data 86 this time in the storage unit 24.

  In addition, the combo box 43 used in the data management process according to the present embodiment has a function of displaying a plurality of options in different colors. That is, the control unit 21 changes the character color or background color of a plurality of options arranged in the pull-down list 49 for each option. In this case, for example, red, blue, yellow, green, brown, etc., the character colors or background colors of all options may be different from each other, for example, red, blue, red, blue,. In this way, colors may be arranged so that the colors of the choice characters adjacent to each other or the background colors are different from each other. As described above, since the color of characters or background colors of a plurality of options are different for each option, the user can clearly distinguish the options, and can easily and accurately select the options. For example, when the user gets used to the data management process, the user can identify individual choices by looking at the colors without reading the characters.

  [Multi-stage combo box] As shown in FIG. 8, when the input method assigned to the column group to which the cell 32 designated by the user belongs is the multi-stage combo box 44, the control unit 21 of the terminal 3 With reference to the identification number of the input method (identification number “4” of the multistage combo box code 74) included in the input method setting data 82 in the group data 67 of the column group to which the cell 32 belongs, the element data input code of the storage unit 24 A multistage combo box code 74 is selected from 62. Subsequently, the control unit 21 reads out the individual data 68 of the cell 32 and the group data 67 of the column group to which the cell 32 belongs from the storage unit 24, gives the read data to the multistage combo box code 74, and multistage combo box Code 74 is executed. As a result, the user first selects one upper option from a plurality of upper options, and then selects one lower option from the plurality of lower options, that is, one option in multiple stages. It is possible to input element data to the cell 32 by a method of narrowing down.

  That is, in the storage unit 24, the upper option data and the lower option data are stored as part of the input method setting data 82 in the group data 67 corresponding to the column group to which the multistage combo box 44 is assigned. When the user designates one cell 32, the control unit 21 displays a pull-down button 50 in the cell 32. When the user clicks the pull-down button 50, the control unit 21 refers to the upper option data in the group data 67 corresponding to the column group to which the cell 32 belongs, and arranges a plurality of upper options indicated by the upper option data. The upper option pull-down list 51 arranged and arranged is generated, and the upper option pull-down list 51 is displayed immediately below the cell 32 designated by the user. Then, when the user operates the terminal 3 to select one higher option from a plurality of upper options arranged in the upper option pull-down list 51 (mouse hover or click), the control unit 21 causes the cell 32 to be displayed. With reference to the lower option data in the group data 67 corresponding to the column group to which the column group belongs, a plurality of lower options corresponding to the upper option selected by the user are arranged among the plurality of lower options indicated by the lower option data. The arranged lower option pull-down list 52 is generated, and this lower option pull-down list 52 is displayed beside the upper option pull-down list 51. Then, when the user operates the terminal 3 and selects one lower option from a plurality of lower options arranged in the lower option pull-down list 52, the control unit 21 selects the selected lower option from the cell. 32, and is stored in the storage unit 24 as element data 86 included in the individual data 68 corresponding to the cell 32. Specifically, the past element data 86 corresponding to the cell 32 is rewritten to the new element data 86 this time in the storage unit 24.

  Such a multistage combo box 44 classifies a large number of options into a plurality of groups and displays them for each group. Therefore, the user can narrow down the options from the upper group (coarse and large classification group) to the lower group (fine and small classification group) and finally select one desired option. Even when the number is enormous, one desired option can be easily and quickly selected. That is, when a huge number of options are displayed all at once, it may be difficult to find a desired option, or it may take a long time to find a desired option. If all the options cannot be displayed on the screen at once, the pull-down list can be scrolled. However, if the scrolling is configured, a scroll operation is performed to find a desired option. It must be repeated and the operation becomes complicated. According to the multistage combo box 44, such inconvenience can be eliminated. Note that the multi-stage combo box in this embodiment employs a method of performing one option from a plurality of options in two stages, but one option from a plurality of options is divided into three stages, four stages, or It is also possible to adopt a method that is performed in a larger number of stages. Also, in the multistage combo box 44, a plurality of upper options or a plurality of lower options may be displayed in different colors in the same manner as the combo box 43. As a result, the user can easily and accurately select an option.

  Further, when the number of lower-level options is enormous in the multistage combo box 44, if only the lower-level option data corresponding to the selected higher-level option is downloaded from the server 2 when the higher-level option is selected, Without having to download a huge number of sub-options. Therefore, since the size of data to be downloaded can be reduced, the operation speed or responsiveness can be improved.

  [Code Input Type Combo Box] As shown in FIG. 9, when the input method assigned to the column group to which the cell 32 designated by the user belongs is the code input type combo box 45, the control unit of the terminal 3. 21 refers to the input method identification number (the identification number “5” of the code input type combo box code 75) included in the input method setting data 82 in the group data 67 of the column group to which the cell 32 belongs, and the storage unit A code input type combo box code 75 is selected from 24 element data input codes 62. Subsequently, the control unit 21 reads the individual data 68 of the cell 32 and the group data 67 of the column group to which the cell 32 belongs from the storage unit 24, and gives the read data to the code input type combo box code 75. The input type combo box code 75 is executed. As a result, the user can input element data to the cell 32 by a method of selecting one option from a plurality of set options, like the combo box 43. In addition, according to the code input type combo box 45, the user can input element data by a method of inputting a selection code and specifying an option corresponding to the input selection code.

  In the code input type combo box 45, the operation of inputting element data by selecting one option from a plurality of set options is the same as the combo box 43 described above. That is, as shown in FIG. 9A, when the user clicks the pull-down button 53, the pull-down list 54 is displayed, and when the user selects one option from the pull-down list 54, the selected item is selected. The option is stored in the storage unit 24 as element data 86 included in the individual data 68 corresponding to the cell 32.

  The operation of inputting the element data in the code input type combo box 45 by inputting a selection code and specifying an option corresponding to the input selection code is as follows. That is, in the storage unit 24, group data 67 corresponding to the column group to which the code input type combo box 45 is assigned includes option data and a plurality of options indicated by the option data as part of the input method setting data 82. A plurality of unique selection codes corresponding to are stored. As shown in FIG. 9 (2), when the user designates one cell 32, a code input unit 55 is formed in the left area in the cell 32. When the user inputs a selection code to the code input unit 55, the control unit 21 is input by the user from among a plurality of selection data included in the group data 67 corresponding to the column group to which the cell 32 belongs. A selection code that matches the selection code is searched, and option data corresponding to one selection code found by the search is specified. Subsequently, the control unit 21 displays the specified option data in the cell 32 and stores it in the storage unit 24 as element data 86 included in the individual data 68 corresponding to the cell 32. Specifically, the past element data 86 corresponding to the cell 32 is rewritten to the new element data 86 this time in the storage unit 24. In the code input type combo box 45, a plurality of options may be displayed in different colors in the same manner as the combo box 43. As a result, the user can easily and accurately select an option.

  [Button] As shown in FIG. 10, when the input method assigned to the column group to which the cell 32 designated by the user belongs is the button 46, the control unit 21 of the terminal 3 belongs to the cell 32. By referring to the input method identification number (the identification number “6” of the button code 76) included in the input method setting data 82 in the group data 67 of the column group, the button code is selected from the element data input code 62 in the storage unit 24. 76 is selected. Subsequently, the control unit 21 executes the button code 76. When the button code 76 is executed, processing pre-assigned to the button 46 is executed. Further, the process assigned to the button 46 may be a common process for the column to which the button 46 is assigned. Thereby, the size of the program for realizing the processing can be reduced.

  Further, there is one code for realizing various input methods, such as a text box code 71, a check box code 72, a combo box code 73, a multi-stage combo box code 74, a code input type combo box code 75, a button code 76, etc. It is desirable that Even in such a configuration, when a user inputs element data into a cell 32, an input for realizing the input method is provided in one common code for realizing the input method assigned to the cell 32. By giving method setting data (option data or the like), it is possible to realize the same processing as when a dedicated code individually prepared for inputting element data into the cell 32 is executed. Then, by making each code for realizing various input methods one, once each code is downloaded from the server 2 to the terminal 3, the user designates a number of different cells 32 in the table 31 one after another. Even if element data is input by various input methods, it is not necessary to download a code for realizing these input methods from the server 2 to the terminal 3 again. Further, when data management processing is performed using a table different from the table 31, codes for realizing various input methods used for the data management processing related to the table 31 are used as data management processing related to the other table. It is not necessary to download the code for realizing the input method from the server 2 again for the data management processing related to another table. In addition, when performing data management processing different from the current data management processing, codes for realizing various input methods used in the current data management processing are also used. It can also be used for a data management process different from the process, and there is no need to download a code for realizing the input method from the server 2 for the separate data management process. Therefore, the frequency of downloading from the server 2 can be reduced, and the operation speed or responsiveness can be improved.

  As described above, according to the embodiment of the present invention, data common to a plurality of cells 32 belonging to one column group, that is, attribute data 81 and input method setting data 82 is eliminated. In addition, by storing them together as group data 67 in the storage unit 24, the size of data required for data management processing can be reduced. In addition, one of a plurality of input methods such as a text box 41, a check box 42, a combo box 43, a multi-stage combo box 44, a code input type combo box 45, and a button 46 is changed to a plurality of cells 32 belonging to one column group. By allocating them in common, it is possible to reduce the size of code and data required for data management processing. Therefore, the operation speed or responsiveness of the data management process in the terminal 3 can be improved.

  In the above-described embodiment, codes necessary for data management processing, that is, the table formation code 61, the element data input code 62, the attribute setting / input method allocation code 63, and the like are described in a markup language such as HTML or XML. As an example, the data management processing is performed by operating the browser program 28 using these codes. Thereby, data management processing independent of the operating system of the terminal 3 can be realized. However, the present invention is not limited to this. The code necessary for the data management process may be a program that can be directly executed on the operation system.

  In addition, the present invention can be appropriately changed without departing from the spirit or idea of the invention which can be read from the claims and the entire specification, and a data management apparatus accompanied with such a change is also a technical idea of the present invention. include. Further, a program for causing a computer to function as such a data management apparatus, and a recording medium on which such a program is recorded are also included in the technical idea of the present invention.

  INDUSTRIAL APPLICABILITY The present invention can be used for an apparatus and a system for performing calculation processing, data processing, etc. for managing data related to employment, finance, inventory, statistics, experiments, inspections, and the like.

DESCRIPTION OF SYMBOLS 1 Data management system 2 Server 3 Terminal 4 Computer network 21 Control part 22 Input / output part 23 Communication part 24 Storage part 27 Code / data group 28 Browser program 31 Table 32 Cell 33 Column group 41 Text box 42 Check box 43 Combo box 44 Multistage Combo box 45 Code input type combo box 46 Button 61 Table formation code 62 Element data input code 63 Attribute setting / input method assignment code 66 Table formation data 67 Group data 68 Individual data 71 Text box code 72 Check box code 73 Combo box code 74 Multistage combo box code 75 Code input type combo box code 76 Button code 81 Attribute data 82 Input method setting data 6 element data

Claims (11)

A data management device that manages data using a table,
A table forming unit that performs a process of forming a table composed of a plurality of cells arranged in a matrix;
If the data input to each of the plurality of cells is referred to as element data, the element data is input into the cell designated by the user according to the user's operation, and the element data input method is A plurality of different element data input sections;
When a group of a plurality of cells arranged in one column or one row in the table is referred to as a cell group , any one of the plurality of element data input units is defined as one cell group. an input method assignment unit performs assign to process common to a plurality of cells, to allow input of element data for each of a plurality of cells belonging to the cell group in accordance with the input method according to the element data input unit belonging to,
A storage unit for storing a code / data group,
The code / data group includes a table forming code that defines the processing contents of the table forming section, a plurality of element data input codes that respectively define the processing contents of the plurality of element data input sections, and the input method. An input method allocation code that defines the processing contents of the allocation unit, table formation data that is data necessary for the formation of the table, and a group that is set in common for a plurality of cells belonging to the one cell group Data and the element data,
Each of the plurality of element data input units is given an identification number,
The group data includes an identification number of any one of the plurality of element data input units,
The input method assigning unit assigns the plurality of element data input units to be commonly assigned to a plurality of cells belonging to the one cell group corresponding to the group data according to an identification number of the element data input unit included in the group data. A data management apparatus that selects from among the element data input units. The plurality of element data input units display a plurality of options when a cell in which element data is input by the user's operation is selected, and one option of the plurality of options is selected by the user's operation. A selection type element data input unit for inputting the selected option into the selected cell as element data when is selected,
The group data of one cell group included in the code / data group includes an identification number of the selection type element data input unit assigned in common to a plurality of cells belonging to the cell group, and the assigned selection type. The data management apparatus according to claim 1, further comprising option data indicating a plurality of options displayed by the element data input unit.   The data management apparatus according to claim 2, wherein the selection type element data input unit is a combo box.   The data management apparatus according to claim 3, wherein the combo box can arbitrarily set a character color representing the option or a background color for arranging the option for each option.   The data management apparatus according to claim 2, wherein the selection type element data input unit is a check box. The plurality of element data input units display a plurality of upper options when a cell in which element data is input by a user's operation is displayed, and one of the plurality of upper options is selected by a user's operation. When one upper option is selected, a plurality of lower options belonging to the selected upper option are displayed, and when one lower option of the plurality of lower options is selected by a user operation, A multi-stage selection type element data input unit for inputting the selected subordinate option as element data into the selected cell is included,
The group data of one cell group included in the code / data group includes an identification number of the multi-stage selection type element data input unit assigned in common to a plurality of cells belonging to the cell group, and the assigned The high-order option data indicating a plurality of high-order options displayed by the multi-stage selection type element data input unit and the low-level option data indicating a plurality of low-level options belonging to each of the high-order options are included. The data management device according to any one of 5. The plurality of element data input units display a code input unit when a cell to which element data is input is selected by a user operation, and a selection code is input to the code input unit by a user operation. A code input type element data input unit for selecting an option corresponding to the input selection code and inputting the selected option as element data into the selected cell,
The group data of one cell group included in the code / data group includes an identification number of the code input type element data input unit commonly assigned to a plurality of cells belonging to the cell group, and the assigned code. 7. Selection data indicating a plurality of options set in the input type element data input section and selection code data indicating a selection code respectively corresponding to the plurality of options are included. A data management device according to any of the above.   Each group data includes attribute data common to each cell belonging to the cell group to which the group data corresponds, and the attribute data includes the size of each cell and the element data input to each cell. 8. The data management apparatus according to claim 1, wherein the data management apparatus includes an initial value or a data type of element data input to each cell. A communication unit for receiving the code / data group from a server;
In the storage unit, the code / data group received from the server by the communication unit is stored,
After one upper option of the plurality of upper options is selected by a user operation, lower option data indicating a plurality of lower options belonging to the selected upper option is received from the server, and the storage unit The data management apparatus according to claim 6, wherein the data management apparatus is stored in a storage area . The program for functioning a computer as a data management apparatus in any one of Claims 1 thru | or 9 . It claims 1 to A computer-readable recording medium storing a program for causing a computer to function as a data management apparatus according to any one of 9.

Images