JP2689869B2 - Graph creating apparatus and method - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a graph creating apparatus, and in particular, it performs a totalizing process on data extracted from a database, draws a graph showing the result, and performs CR processing.
The present invention relates to a graph creating apparatus and a creating method for outputting to a T or a printer.

[0002]

2. Description of the Related Art FIG. 3 is a block diagram showing an example of a conventional graph creating apparatus. When a user wants a graph, as shown in FIG.
Since the processing control unit 22 issues the totalization processing command 24 to the graph definition file group 23b by referring to the graph menu file 26 by an instruction from the keyboard 31 of the graph totalization apparatus 2b, the database retrieval formula 2311b from the totalization processing definition file group 231b. To the data extraction unit 12 of the graph tallying apparatus 1b, and the data extraction unit 12 searches the database 11 to create the extracted data file 13.

Next, the data tabulation formula 2312 from the tabulation processing definition file group 231b is given to the tabulation section 14 of the graph tabulation apparatus 1b, and the tabulation section 14 extracts the extracted data file 1
The contents of No. 3 are totaled and the totalized file 15 is created.
Therefore, the drawing unit 16 of the graph tallying apparatus 1b uses the contents of the tallying file 15 to draw the graph definition file group 2
The graph format definition file 232 of 3b is referenced to output the graph, and the graph output unit 41 of the graph output device 4 displays the graph on the CRT 42.

Therefore, when a user wants a graph, the conventional graph creating apparatus performs a data input process, creates a file defining a data processing process, performs a data totaling process, and displays a graph. There is.

[0005]

The above-described conventional graph creating apparatus requires time for performing the tabulation processing,
It has the drawback that the graph cannot be seen instantly when one wants to see it.

Further, when it is desired to see the transition of data or the tendency of data in a graph, the conventional graph creating apparatus is
Since the data processing process must be changed each time and the totalizing process must be executed, there is a disadvantage that it takes a lot of time and labor.

It is an object of the present invention to provide a graph creating apparatus and method by which the graph creating process order is registered in advance and the automatic tabulation process is performed so that the graph can be viewed instantly when desired. .

[0008]

A graph creating apparatus according to a first aspect of the present invention defines (A) a set of expressions for searching data from a database as a database search expression group, and sets the database search expression group from the database. An expression that aggregates the data extracted using is defined as a data aggregation expression, and a file that defines the aggregation processing of the graph including the database search expression group and the data aggregation expression is defined as the aggregation processing definition file group, and the graph A file defining a format is defined as a graph format definition file, a file including the aggregation processing definition file group and the graph format definition file is defined as a graph definition file group, and the graph definition file group and the graph definition file group. Startup time setting file that manages the startup time of And graphs rollup processor having a processing control unit for transmitting the counting processing instruction to the constant file according to control processes the chart definition file group, (B)
A data extraction unit that extracts data from the database according to the database search formula group indicated by the contents of the startup time setting file to create an extracted data file, and the extracted data according to the data aggregation formula indicated by the contents of the startup time setting file The contents of the aggregated file are drawn according to the graph format defined by the graph format definition file indicated by the contents of the startup time setting file and the aggregation unit that aggregates and stores the contents of the file in the aggregated file. And a graph tallying device having a drawing unit for storing in an image file, (C)
A graph output unit for outputting the contents of the image file as a graph and a CR for displaying the output graph
A graph output device having an output device unit such as T or a printer for printing, and (D) a graph drawing print command device having an input device unit such as a keyboard for transmitting a graph drawing print command to the graph output device, It is configured with.

The graph creating apparatus of the second invention is
(A) A graph definition file group, a start time setting file that manages the start time of the graph definition file group, and a process control that controls processing according to the start time setting file and transmits an aggregate processing command to the graph definition file group (B) Data extraction unit for extracting data from a database according to a database search formula group indicated by the contents of the startup time setting file to create an extracted data file, and the startup time setting file According to the graph format defined by the graph format definition file instructed by the contents of the start time setting file and the aggregation unit that aggregates the contents of the extracted data file according to the data aggregation formula indicated by Draw the contents of the totalized file And a graph drawing print command device for transmitting a graph drawing print command that the user has input as necessary from an input device unit such as a keyboard (C). (D) A graph output unit for outputting the contents of the image file to a graph by receiving a graph drawing print command from the graph drawing print command device, a CRT for displaying the output graph, a printer for printing, etc. And a graph output device having an output device section including.

The graph creating method of the present invention is (A)
Control the processing according to the contents of the startup time setting file that manages the startup time of the graph definition file group, and transmit the aggregation processing command for using the contents of the graph definition file group, and (B) set the startup time from the database. Data is extracted according to the database search formula group indicated by the contents of the file to create an extracted data file, and (C) the contents of the extracted data file are summed according to the data summation formula indicated by the contents of the startup time setting file. Stored in a totalized file, (D) drawing the contents of the totalized file according to the graph format defined in the graph format definition file indicated by the contents of the startup time setting file, and storing them in an image file, (E) keyboard, etc. Graph drawing printing that the user has input as necessary from the input device section of Decree to transfer, or print to (F) printer or displayed on a CRT to output the contents of the image file in the graph by receiving the graph drawing print command.

[0011]

Next, embodiments of the present invention will be described with reference to the drawings. FIG. 1 is a block diagram showing an embodiment of a graph creating apparatus of the present invention. Further, FIG. 2 is a diagram showing an example of the start-up time setting of the aggregation processing of each graph, which is the content of the start-up time setting file of the present embodiment.

As shown in FIG. 1, the graph creating apparatus of this embodiment includes a graph tallying apparatus 1 and a graph automatic tallying processing apparatus 2.
And a graph drawing print command device 3 and a graph output device 4.

Then, the graph automatic totalization processing device 2 extracts the data from the database 11 of the graph totalization device 1 by using the database search formula group 2311 which is a set of formulas for searching data from the database 11 and the database search formula group 2311 from the database 11. The graph definition file group 23 having the graph format definition file 232 is a collection processing definition file group 231 that defines the graph aggregation processing including the data aggregation expression 2312 that is an expression that aggregates the created data, and a file that defines the graph format. have.

Further, the graph automatic totalization processing device 2 has a startup time setting file 21 for managing the startup time of the graph definition file group 23, and the processing control unit 22 controls the processing in accordance with the startup time setting file 21. The totalization processing command 24 is transmitted to the definition file group 23.

Therefore, in the graph tallying apparatus 1, the data extraction unit 12 from the database 11 uses the startup time setting file 2
The extracted data file 13 is created by extracting data according to the database search formula group 2311 designated by the contents of 1.

Then, the graph compiling device 1 includes a compiling unit 14
Then, the contents of the extracted data file 13 are totaled and stored in the totalized file 15 according to the data totaling formula 2312 indicated by the contents of the startup time setting file 21.

Further, the graph tallying apparatus 1 includes a drawing unit 16
The contents of the totalized file 15 are drawn according to the graph format defined by the graph format definition file 232 and stored in the image file 17.

On the other hand, the graph drawing print command device 3 transmits the graph drawing print command 32 from the keyboard 31 to the graph output device 4.

Further, the graph output device 4 receives the graph drawing print command 32 from the graph drawing print command device 3, and
The graph output unit 41 outputs the contents of the image file 17 as a graph to the CRT 42 for display. Of course, the graph output device 4 can print the contents of the image file 17 as a graph by using a printer instead of the CRT 42.

Then, when the time defined in the startup time setting file 21 comes, the processing control unit 22 transmits the totalization processing command 24 to the graph definition file group 23. Therefore, the totalization processing command 24 is received and the totalization processing definition file group is received. 231
Transmits the contents of the database search formula group 2311 designated by the startup time setting file 21 to the data extracting unit 12, and the data extracting unit 12 extracts the data of the database 11 into the extracted data file 13.

Next, the data totalizing formula 2312 defined in the startup time setting file 21 is transmitted to the totaling unit 14, and the totaling unit 14 totalizes the contents of the extracted data file 13,
The totalized file 15 is created. Then, the graph format definition file 232 defined in the startup time setting file 21 is transmitted to the drawing unit 16, and the drawing unit 16 draws a graph from the contents of the tabulated file 15 to create the image file 17.

Therefore, the graph output section 41 which receives the graph drawing print command 32 from the keyboard 32 outputs the contents of the image file 17 to the CRT 42 for display.

Next, an example of the description format of the startup time setting file 21 of this embodiment will be described with reference to FIG. As shown in FIG. 2, the start-up time setting file 21 includes an aggregation start time, which is a time at which the data extracting unit 12 starts extraction processing for extracting data from the database 11 into the extraction data file 13, and a database search formula group. It is composed of a file name showing the contents of 2311, a file name showing the data aggregation formula 2312, and a file name showing the graph format definition file 232.

For example, the third line is minute, hour, day, month, year,
"00 08", which is the aggregation start time described in order of the day of the week
"01 * *" is the database search formula "kita2-1.expr", and the data aggregation formula "kita2.qal".
”, Graph format definition file“ kita2.qgr
Means to start by using the file

[0025]

As described above, the graph creating apparatus of the present invention registers necessary graphs and their database search formulas in the startup time setting file and starts them at the time registered in the startup time setting file. By automatically performing total drawing and printing processing, and saving and storing the totalized file and graph image data, you can instantly see the graph when you want to see it, and you can save waiting time during total processing. Further, it has an effect that the transition of data or the tendency of data can be seen by utilizing the function of periodically changing the aggregation processing parameter.

Further, the graph creating apparatus of the present invention uses the startup time setting file to periodically change the database retrieval formula and perform the automatic total drawing process for a graph that requires regular total processing. , CR as needed
There is an effect that a graph can be displayed on a display device such as T or a graph can be printed on a printing device such as a printer.

[Brief description of the drawings]

FIG. 1 is a block diagram showing an embodiment of a graph creating apparatus of the present invention.

FIG. 2 is a diagram showing an example of a start-up time setting of the aggregation processing of each graph, which is the content of the start-up time setting file of the present embodiment.

FIG. 3 is a block diagram showing an example of a conventional graph creating apparatus.

[Explanation of symbols]

 1, 1b, 2b Graph aggregation device 2 Automatic graph aggregation processing device 3 Graph drawing print command device 4 Graph output device 11 Database 12 Data extraction unit 13 Extracted data file 14 Aggregation unit 15 Aggregated file 16 Drawing unit 17 Image file 21 Startup time Setting file 22 Processing control section 23, 23b Graph definition file group 24 Aggregation processing instruction 31 Keyboard 32 Graph drawing print instruction 41 Graph output section 42 CRT 231,231b Aggregation processing definition file group 232 Graph format definition file 2311, 2311b Database search expression group 2312 Data aggregation formula

Claims (3)

(57) [Claims] 1. (A) A set of expressions for searching data from a database is defined as a database search expression group, and an expression for totalizing data extracted from the database using the database search expression group is a data total. Defined as a formula, the file that defines the aggregation process of the graph including the database search formula group and the data aggregation formula is defined as the aggregation process definition file group, and the file that defines the graph format is defined as the graph format definition file, A file including the aggregation processing definition file group and the graph format definition file is defined as a graph definition file group, and a start time setting file for managing the graph definition file group and the start time of the graph definition file group and the start time Control the process according to the setting file An automatic graph totalization processing device having a processing control unit for transmitting a totalization processing command to a definition file group; and (B) extracting and extracting data from the database according to the database search formula group indicated by the contents of the startup time setting file. Contents of the data extraction unit that creates a data file and the start-up time setting file that totals the contents of the extracted data file according to the data aggregation formula indicated by the contents of the start-up time setting file and stores them in a totalized file A graph tallying device having a drawing unit for drawing the contents of the totalized file according to the graph format defined by the graph format definition file and storing the contents in an image file; Graph output part that outputs as graph and output A graph output device having an output device such as a CRT for displaying the graph or a printer for printing, and (D) a graph drawing having an input device such as a keyboard for transmitting a graph drawing print command to the graph output device. A graph creating apparatus comprising: a print command device. 2. (A) A graph definition file group, a start time setting file that manages the start time of the graph definition file group, and processing is controlled according to the start time setting file to give an aggregate processing command to the graph definition file group. A graph automatic totalization processing device having a processing control unit for transmitting the following: (B) a data extraction unit for extracting data from the database according to the database search formula group indicated by the contents of the startup time setting file to create an extracted data file; Defined in a graph format definition file instructed by the contents of the startup time setting file and a totaling unit that totals the contents of the extracted data file according to the data totaling expression indicated by the contents of the startup time setting file and stores the totalized file The compiled file according to the created graph format And graphs tabulating apparatus having a drawing unit for storing the result of rendering the content on the image file,
(C) a graph drawing print command device for transmitting a graph drawing print command input by a user as necessary from an input device section such as a keyboard; and (D) receiving a graph drawing print command from the graph drawing print command device. A graph output unit for outputting the contents of the image file to a graph, and a graph output device having an output device unit including a CRT for displaying the output graph and a printer for printing. A graph creating device. 3. (A) Control processing according to the contents of a startup time setting file that manages the startup time of a graph definition file group, and transmit a tally processing command for using the contents of the graph definition file group, B) Data is extracted from the database according to the database search formula group indicated by the contents of the startup time setting file to create an extraction data file, and (C) The extraction is performed according to the data aggregation formula indicated by the contents of the startup time setting file. The contents of the data file are aggregated and stored in the aggregated file, and (D) the contents of the aggregated file are drawn according to the graph format defined in the graph format definition file indicated by the contents of the startup time setting file, and the image file is created. Storing and (E) Inputting by user from input device such as keyboard The graph drawing print command is transmitted,
(F) A graph creating method characterized in that the contents of the image file are output to a graph and displayed on a CRT or printed on a printer by receiving the graph drawing print command.