JP2004139443A - Data table display method, database device, computer program and recording medium - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To clearly display a data table with simple operation. <P>SOLUTION: The displays of cells are combined by inputting "the action of force", which is the same data as a record 1, to the "learning item" cell of a record 2, and only the outside frame obtained by removing the overlapped part of the two cell frames is displayed, and then one of common data "the action of force" 302 is displayed at the center of the combined cell 301. Even when the displays of the cells are combined, the data "the action of force" are individually registered with the record 1 and record 2 in the actual data table. <P>COPYRIGHT: (C)2004,JPO

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to a data table display method and the like, and more particularly, to a data table display method, a database device, a computer program, and a recording medium capable of easily displaying a data table by a simple operation.
[0002]
[Prior art]
Databases are widely used for data management and aggregation. Recently, in the field of education, a database for managing a learning guidance plan, a teaching record, a student's learning evaluation, and the like has begun to be used.
[0003]
A database for managing the learning instruction plan (hereinafter referred to as a learning management database) is managed by dedicated database software installed on a computer, and is operated by operating a computer to register necessary data in the database. Management and tallying are performed.
[0004]
FIG. 5 is a diagram showing an example of a display screen of a data table registered in a conventional learning management database.
[0005]
As shown in FIG. 5, in this data table, as items necessary for learning management, for example, “scheduled class date” 202, “class lesson date” 203, “learning item” 204, “learning purpose” 205, An item such as “learning contents” 206 is provided, and by registering data in each cell, management of a learning guidance plan can be performed.
[0006]
[Problems to be solved by the invention]
In the learning instruction plan described above, a plurality of learning aims may be provided for one learning item, or a plurality of learning contents may be provided for one learning aim. In this case, since the “learning item” 204 is a higher attribute than the “learning target” 205, the “learning target” 205 differs between adjacent records, but the “learning item” 204 may be common. is there. Also, since the “Learning Aim” 205 is an attribute higher than the “Learning Content” 206, the “Learning Aim” 205 may be common between adjacent records although the “Learning Content” 206 is different.
[0007]
However, in the conventional display screen described above, since the contents registered in the data table are directly reflected on the display, each of the items belonging to the items such as “learning item” 204, “learning purpose” 205 or “learning content” 206 Even though the contents of cells are common between adjacent upper and lower records, the contents of each cell are displayed individually. For example, as shown in FIG. 5, data “work of power” is registered in a cell 208 of a “learning item” 204 of a record of class number 1 (hereinafter, a record of class number n is referred to as “record n”). In this case, even if the same content is input to the cell below it, that is, the cell 209 in the same row of the record 2, it is registered in the data table as it is and displayed on the screen as it is, so it is redundant and very difficult to see. .
[0008]
[Means for Solving the Problems]
Therefore, an object of the present invention is to provide a data table display method, a database device, a computer program, and a recording medium on which the program can be displayed, in which the data table can be easily displayed by a simple operation.
[0009]
[Means for Solving the Problems]
An object of the present invention is a method for displaying a data table managed by a computer with a graphical user interface, comprising at least data in at least two adjacent cells belonging to the same row or column of said data table. And the step of combining the displays of the at least two cells when the data in the at least two cells match, is achieved.
[0010]
According to the present invention, even when the same data exists in at least two adjacent cells in the data table, the contents can be displayed in a legible manner by a simple operation.
[0011]
In a preferred embodiment of the present invention, prior to the step of comparing the data in the at least two cells, at least a step of displaying a data table on a screen, and a step of inputting data into an arbitrary cell of the data table. Registering the data in the data table, and determining whether the cell into which the data is input is a target of merging, and comparing the data in the at least two cells. Is a step of comparing the data in the cell with the data in the adjacent cell belonging to the same row or column as the cell and in the case where the cell into which the data is input is the target of merging. .
[0012]
According to the preferred embodiment of the present invention, the combined display of cells can be started without requiring the user to perform any special operation.
[0013]
The object of the present invention is at least a means for managing a data table, a display means for displaying the data table on a screen, a data input means constituting a graphical user interface together with the display means, and the same as the data table. Means for comparing data in at least two cells belonging to adjacent rows or columns, and means for combining the representations of the at least two cells if the data in the at least two cells match. The present invention is also achieved by a database device characterized in that:
[0014]
The object of the present invention also provides a computer having a graphical user interface and managing a data table, at least comparing data in at least two adjacent cells belonging to the same row or column of the data table. The invention is also achieved by a computer program for performing the step of combining the representations of the at least two cells when the data in the at least two cells match.
[0015]
The above object of the present invention is also achieved by a computer-readable recording medium on which the computer program is recorded.
[0016]
BEST MODE FOR CARRYING OUT THE INVENTION
Hereinafter, preferred embodiments of the present invention will be described in detail with reference to the accompanying drawings.
[0017]
FIG. 1 is a block diagram showing a configuration of a database device according to a preferred embodiment of the present invention.
[0018]
As shown in FIG. 1, the database device 100 is a personal computer on which predetermined software is installed, and includes a computer main body 101, display means such as a display 102, and data input means such as a keyboard 103 and a mouse 104. It has. These display means and data input means together with predetermined software constitute a graphical user interface.
[0019]
The computer main body 101 has a general computer configuration, and includes a CPU 105, a memory 106, a hard disk drive (HDD) 107, a removable media drive (RMD) 108 for recording / reproducing a recording medium such as a magnetic recording medium or an optical disk, and an input / output unit. An output interface (I / O) 109 is provided.
[0020]
An OS, various device drivers, learning management database software, and the like are installed in the database device 100. Various functions such as a data table management function and a display function are realized by cooperation of these software and the above-described hardware. Is achieved. Such software may be provided by a recording medium such as an optical disk. In this case, the program is read and installed by a removable media drive. Alternatively, it may be provided online from the Internet. The installed program is read from the hard disk into the memory and executed according to an instruction from the user or automatically at the time of starting the computer.
[0021]
The learning management database in the database display device 100 has a relational database function, and a plurality of data tables are registered. In addition, a data table can be displayed on the display 102 in response to a request from the user. By operating the keyboard 103 or the mouse 104, data can be registered in each cell of the data table displayed on the display 102.
[0022]
FIG. 2 is a diagram showing an example of a display window of the data table, and shows a state before cell displays are combined.
[0023]
As shown in FIG. 2, the data table 201 displayed in this window 200 corresponds to the subject “science” of the class “one year and two sets”, and the data is classified by class or subject by the screen operation. The display of the table 201 can be changed. In the data table 201, column items such as “Scheduled Date” 202, “Schedule Date” 203, “Learning Item” 204, “Learning Aim” 205, and “Learning Content” 206 are necessary items for learning management. Is provided. Further, in the items of “Schedule Date” 202 and “Schedule Date” 203, “Start Date” 202a, 203a and “End Date” 202b, 203b are provided, respectively. Each record has a “class number” 207 as a key.
[0024]
By inputting data on each screen of each record on the screen, the data is actually registered. For example, as shown in the figure, in each cell of the record 1, "02/10/01", "02/10/03", and "02/01" Data such as "October 01,""October 02, 04,""Work of Power,""Know the Work of Power," and "Understanding What is Power and How to Balance Power." By inputting on the screen, these are actually registered as data of record 1.
[0025]
As described above, since the “learning item” 204 has a higher attribute than the “learning purpose” 205, the data registered in the “learning purpose” 205 differs between adjacent records. Data registered in the "learning item" 204 may be common. Also, since the “Learning Aim” 205 is an attribute higher than the “Learning Content” 206, the data registered in the “Learning Content” 206 differs between adjacent records, but is registered in the “Learning Aim” 205. Data may be common.
[0026]
For example, as shown in FIG. 5, the same data as in record 1, “work of power”, may be input to the cell 209 of “learning item” of record 2. In this case, the input data is actually registered as the data of the record 2, but since the data is the same as the data in the cell 208 of the same row in the record 1, the display of the two cells is combined.
[0027]
FIG. 3 shows a state in which the display of the cells is combined by inputting the same data as that of the record 1 “function of force” to the cell 209 of the “learning item” of the record 2 in the data table of FIG. FIG.
[0028]
As shown in FIG. 3, in this data table display, only the outer frame from which the overlapping portion of the two cell frames has been removed is displayed, and the common data "function of force" 302 is provided at the center of the merged cell 301. Is displayed. Even when the cell display is combined, since the data "work of force" is registered in the actual data table for both record 1 and record 2, the data table must be used as a database. There is no problem such as the absence of data.
[0029]
Regarding the items of “Scheduled Class Date” 202 and “Schedule Date” 203, it is preferable that the cell display is not combined even if the contents of the upper and lower cells are the same from the viewpoint of legibility. I do not care. Therefore, it is necessary to set in advance for each item whether or not the item is to be combined with the cell display.
[0030]
As shown in FIG. 3, when the data table in which the same data is registered in the adjacent upper and lower cells is read out again and displayed on the screen, when the data table is displayed on the screen, each cell registered with the data is displayed. May be compared with adjacent cells, and the result may be reflected in the drawing of the ruled line. Further, together with the data table, data relating to drawing of ruled lines used for displaying the data table may be registered in advance. In this way, when displaying the data table, it is possible to display the data table in which the cell displays are combined without performing the comparison process for each cell.
[0031]
FIG. 4 is a flowchart showing the procedure for displaying the data table.
[0032]
As shown in FIG. 4, first, the data table that is actually registered is read out (S401). If the same data exists in two adjacent cells belonging to the column to be merged, the second The data table is displayed on the screen with the display of the two cells combined (step S402).
[0033]
When data is input to an arbitrary cell of the data table (S403), the data is registered (S404), and it is determined whether or not the cell is to be merged (S405). Here, the case where the data is input is a case where the data input is determined. If it is not the target of merging (N in S405), even if the same data belongs to the same column and exists in adjacent cells, the data registered in the data table is displayed on the screen without merging the cells. (S409).
[0034]
If the cell is to be merged (S405Y), the data input to the cell is compared with data in a cell belonging to the same column as the cell and adjacent to the cell (step S406). That is, the cell is compared with the cell adjacent above and below the cell.
[0035]
As a result of the comparison, if the data does not match the data in the upper or lower cell (S407N), the data registered in the data table is displayed on the screen without merging the cells (S409).
[0036]
If the data matches the data in the upper or lower cell (S407Y), the display of the two cells is combined (step S408). That is, only the outer frame from which the overlapping portion of the two cell frames is removed is displayed, and one piece of data having common contents is displayed at the center of the combined cells (in this case, at least the center in the vertical direction). Therefore, the size of the combined cells is equivalent to two cells. Note that the data adopted for the display may be adopted from either cell since the contents of the two cells are the same. Even if the cell displays are combined, the contents of the data table do not change, and data is individually registered in each cell.
[0037]
If the same data is further input to an adjacent cell above or below the already merged cell, the display of the merged cell and the cell display in which the new data is input are further merged, The size is equivalent to three cells.
[0038]
As described above, according to the embodiment, when the contents of the upper and lower cells are common, by combining the cell display, the data table can be easily viewed. In addition, since data is input to a cell and the cell is immediately merged when the input is confirmed, an easy-to-read data table can be easily created and displayed without any troublesome operation.
[0039]
The present invention is not limited to the above embodiments, and various changes can be made within the scope described in the claims, and these are also included in the present invention. Needless to say.
[0040]
For example, in the above-described embodiment, a case where data is compared between a cell to which data is input and upper and lower adjacent cells is described as an example. However, the present invention is not limited to this. The data may be compared between the input cell and the adjacent left and right cells.
[0041]
【The invention's effect】
As described above, according to the present invention, it is possible to provide a data table display method, a database device, a computer program, and a recording medium on which the program can be displayed so that the data table can be displayed easily and easily by a simple operation. it can.
[Brief description of the drawings]
FIG. 1 is a block diagram showing a configuration of a database device according to a preferred embodiment of the present invention.
FIG. 2 is a diagram showing an example of a display screen of a data table registered in a learning management database, showing a state before cell displays are combined.
FIG. 3 is a diagram showing a state in which cell displays are combined in the data table of FIG. 2;
FIG. 4 is a flowchart illustrating a procedure for displaying a data table;
FIG. 5 is a diagram showing an example of a display screen of a data table registered in a conventional learning management database.
[Explanation of symbols]
REFERENCE SIGNS LIST 100 database device 101 computer main body 102 display 103 keyboard 104 mouse 105 CPU
106 Memory 107 Hard disk drive (HDD)
108 Removable Media Drive (RMD)
109 input / output interface (I / O)
200 Data table display window 201 Data table 202 "Schedule date" column item 203 "Class lesson date" column item 202a, 203a "Start date" column item 202b, 203b "End date" column item 204 "Learning" Column item 205 of "item" Column item 206 of "Aim of learning" 206 Column item of "learning content" 207 Column item of "class number" 208 Cell of "learning item" of record 1 209 Cell of "learning item" of record 2 301 Combined cell 302 Common data "Work of power"

Claims (5)

A method of displaying a data table managed by a computer having a graphical user interface,
at least,
Comparing data in at least two adjacent cells belonging to the same row or column of the data table;
A method of displaying a data table, comprising a step of combining display of the at least two cells when data in the at least two cells match. Prior to comparing the data in the at least two cells,
at least,
Displaying the data table on a screen;
When data is input into any cell of the data table, registering the data in the data table;
It has a step of determining whether the cell in which the data has been input is a target of merging,
Comparing the data in the at least two cells comprises:
When the cell into which the data is input is a target to be combined, the step of comparing data in the cell with data in an adjacent cell belonging to the same row or column as the cell and adjacent thereto. The method for displaying a data table according to claim 1. at least,
Means for managing a data table;
Display means for displaying the data table on a screen;
Data input means constituting a graphical user interface together with the display means,
Means for comparing data in at least two adjacent cells belonging to the same row or column of the data table;
A database apparatus comprising: means for combining display of the at least two cells when data in the at least two cells match. A computer that has a graphical user interface and manages data tables
at least,
Comparing data in at least two adjacent cells belonging to the same row or column of the data table;
A computer program for causing a display of the at least two cells to be combined if the data in the at least two cells match. A computer-readable recording medium on which the computer program according to claim 4 is recorded.

Images