JPH08315005A - Data processing device - Google Patents

Abstract

(57) [Abstract] [Purpose] To provide a data processing device capable of setting a data processing procedure by a simple operation. [Arrangement] An operator inputs a data processing procedure by arranging displays 27 and 28 showing processing steps and a display 30 showing a data flow direction between processing steps in a setting area 20 displayed on the display. The data to be input has the branch parts 25a as the starting points and the respective arrows 30a to 30
It is sent to each of the processing steps based on the condition set in c. The data input to the display 27 indicating the processing steps is processed according to the processing (eg, totalization, display, etc.) set for each of the processing steps. The content of each processing step is set by the processing method setting unit 33 and the like.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data processing device, and more particularly, to efficient and labor-saving work of a staff member who needs a multifaceted data analysis and judgment on a large scale and complicated information in an irregular manner. The present invention relates to a data processing device for supporting the.

[0002]

2. Description of the Related Art In the case where necessary information is taken out from information recorded in a database and processed into information desired by a device user, the information requested by the user according to the situation and evaluation index. When the analysis method and the judgment method of fluctuate frequently, it is necessary to frequently change the data processing method. In such a case, the following method has been conventionally used.

(1) Computer language (C language, FO
A method of creating and using a data analysis program corresponding to each processing in RTRAN language).

(2) A method in which the staff processes and outputs the information by utilizing the software such as the information retrieval tool which cooperates with the existing spreadsheet, statistical analysis and database.

(3) By using a macro definition in a dedicated language used in spreadsheet software or the like,
How to process information.

(4) AI such as expert system
A method that uses a system to systematize the technology transfer, evaluation, and judgment know-how of repetitive tasks.

[0007]

However, the above methods (1) to (4) have the following problems.

According to the method (1), desired information of the staff can be obtained, but the program specifications are determined, created,
It takes time to confirm.

In the method (2), large-scale and complicated analysis,
The judgment process cannot be easily set by the staff and the data processing cannot be performed satisfactorily even in the processing time. In addition, the setting method in (2) is an information collection / form format according to a certain method, and since the declarative setting method is the main body, it is necessary for the staff to set complicated analysis according to a fixed setting method. It required skill.

The method (3) can be used only for simple data processing because the processing time is slow and the setting method is complicated.

The method (4) requires expert knowledge to systematize the system at a high level, and the staff themselves have difficulty in interpreting the output result.

As described above, there has been a problem in that the labor of the staff is excessive in any of the conventional methods, and satisfactory data processing cannot be performed.

The present invention has been made to solve the above problems, and an object of the present invention is to provide a data processing device in which the information processing procedure can be easily set by the staff.

[0014]

A data processing device according to claim 1 is a data processing device for processing input data according to a processing procedure consisting of a plurality of set processing steps. , A direction display means for displaying the data flow direction between the process steps, and a desired process step and the data flow direction from the displayed process step and the displayed data flow direction. It is provided with a selecting means for selecting and a setting means for setting a processing procedure based on the selected processing step and data flow direction.

A data processing device according to a second aspect is the data processing device according to the first aspect, further comprising an inspection means for inspecting whether the processing procedure set by the setting means includes a contradiction. It is equipped with more.

A data processing device according to a third aspect is the data processing device according to the first or second aspect, further comprising conversion means for converting the processing procedure set by the setting means into an execution format. Is.

A data processing device according to a fourth aspect is the data processing device according to any one of the first to third aspects, wherein the data processing device stores a condition for executing the processing procedure set by the setting means. And means for executing the processing procedure set by the setting means based on the stored conditions.

[0018]

A data processing apparatus according to claim 1 displays each of a plurality of processing steps and a data flow direction between the processing steps, and a desired processing is performed from the displayed processing steps and the displayed data flow direction. A process and a data flow direction are selected, and a processing procedure is set based on the selected processing process and the data flow direction.

In addition to the effect of the first aspect, the data processing apparatus according to the second aspect of the present invention checks whether or not the set processing procedure includes a contradiction.

A data processing device according to a third aspect of the invention, in addition to the operation of the first or second aspect, converts a set processing procedure into an execution format.

In addition to the operation according to any one of claims 1 to 3, the data processing device according to claim 4 stores a condition for performing a set processing procedure, and sets based on the stored condition. The processing according to the processing procedure set by the means is performed.

[0022]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS FIG. 1 is a data editing / processing support device (data processing device) in production planning according to an embodiment of the present invention.
2 is a block diagram showing the configuration of No. 1 and the device configuration associated with the data editing / processing support device 1. FIG.

Referring to the drawing, data editing / processing support device 1
Is realized by a workstation, a personal computer or the like having a graphic display screen and a mouse input device as a whole, and an input / output interface unit 15 for exchanging data with staff (device user),
An information processing procedure setting unit 6 for setting an information processing procedure input by the staff; an analysis component storage unit 9 for storing an analysis component which is one unit of the information processing procedure set by the information processing procedure setting unit 6; An information processing procedure interpretation unit 7 that interprets the analysis components stored in the analysis component storage unit 9 and automatically generates a database (DB) search sentence and converts the interpretation components into an execution format, and an information processing procedure interpretation unit 7 And the information processing procedure execution unit 8 that activates the interpreted component converted into the execution format that satisfies the activation condition.

The input / output interface unit 15 has an information processing procedure input unit 11 for inputting an information processing procedure, an interpretation result output unit 12 for outputting an interpretation result from the information processing procedure interpretation unit 7, and an analysis result. And an analysis procedure result output unit 13 for outputting

As a device associated with the data editing / processing support device 1, a host computer 2 and a production planning device 3
And a database server that stores desired data among the data stored in the database registration device 5 in a preset data format (including a production planning information database). 4) and a personal computer 14 for inputting and outputting the analysis result output from the data editing / processing support device 1.

Next, the information recorded in the database server 4 is the information shown in FIG. 2, and by processing this information, the total weight of each type shown in FIG. 6 is output. The operation performed by each component of the data editing / processing support apparatus 1 will be described, assuming that a form to be created is created.

The data recorded in the database server 4 is the production plan result information transmitted from the host computer 2 and the production planning device 3 via the database registration device 5, and as shown in FIG. Order No.
The data includes, in order, two kinds of product names (product 1 and product 2), production date (scheduled production date), delivery date, number of pieces, and weight. To create the form of FIG. 6 from this data, the staff inputs the information processing procedure via the information processing procedure input unit 11.

The input of the information processing procedure is performed by the staff arranging processing steps to be performed for information processing using an input device such as a mouse and a data flow direction between the processing steps within a set area. Be done.

FIG. 3 is a diagram showing an input screen of an information processing procedure for creating the form shown in FIG. The input screen is roughly composed of a setting area 20 for setting an information processing procedure, an edit icon section 21 which is a set of icons for editing, and a part icon section 22 which is a set of part icons.

The edit icon portion 21 is for copying (COPY), moving (MOVE), and moving parts existing in the setting area 20.
It is a set of icons for erasing (ERASE). The staff can exert each function by selecting (clicking) these icons with the mouse.

The part icon section 22 is a set of icons for arranging parts in the setting area 20. The component icon part 22 has a branch component 2 for branching information.
5, icons such as an arrow part 30 indicating the flow of information, an item name setting part 27 for setting an item name, and a processing method setting part 28 for setting a processing method such as tabulation and display are included.

In the setting area 20, a screen for setting line items of a form to be output and a screen for setting column items are switched and displayed. These switching is performed by the row / column item switching part 2
This is done by the staff selecting the item to be set according to 3. In the figure, this means that line items are set. In the form shown in FIG. 6, since numerical values are arranged only in the form in the row direction, only line items are set.

When creating the form shown in FIG. 6, the staff inputs the information processing procedure shown in the setting area 20. That is, the branch part 2 is located at the upper left of the drawing.
5a is arranged, and the arrow 30 starts from the branch part 25a
a to 30c are arranged. Item name setting components 27a to 27c are arranged at the end portions of the arrows 30a to 30c. An arrow 30d is arranged with the item name setting component 27a as the start end, and a branch component 25b is arranged at the end of the arrow 30d. Arrows 30d to 30g are arranged with the branch component 25b as an end, and item name setting components 27d to 27g are arranged at respective end portions of the arrows 30d to 30g. Arrows 30h to 30k are arranged with the item name setting components 27d to 27g as the starting ends, and processing method setting components 28a to 28d are arranged at the end portions of the arrows 30h to 30k. At the lower right of the drawing of the setting area 20, a processing method setting unit 33 used for setting the content of the processing method setting component 28d is displayed. An item name setting component 27b is arranged at the end of the arrow 30b. Arrow 3 starting from item name setting component 27b
0l is arranged, and a blocked part 35b is arranged at the end portion of the arrow 30l. An item name setting component 27c is arranged at the end of the arrow 30c. An arrow 30m is arranged with the item name setting component 27c as the starting end, and a processing method setting component 28e is arranged at the terminal end of the arrow 30m.

Next, the setting method of each component and the processing performed by each component will be described.

Referring to the drawing, the branch component 25a existing in the upper left of the drawing of the setting area 20 is a component icon portion 22.
Is set by the branch part icon 25 of, and indicates the starting point of processing of input information. In the branch part icon 25, the part inside the circle is "M", and in the branch part 25a, the part inside the circle is
It is "2", which means that the staff input "2" as the branch variable M at the setting stage.
The branch variable indicates the number of branches of information and is based on a simulation technique.

The three arrows 30a to 30c displayed with the branch icon 25a as the starting point are parts showing the flow of information. These arrows are set by the arrow icon 30 of the component icon section 22. The staff has set a conditional expression that "type 1 =" type A "" on the arrow 30a and "type 1 =" type B "" on the arrow 30b.
Of the input information, only the information that matches each conditional expression will be sent to the next processing step via the respective arrows. On the other hand, since no condition is set for the arrow 30c, the input information is unconditionally sent to the next processing step via the arrow 30c. Since the name of the type 1 of the input data is either the type A or B, the input data is (1) arrow 30a or 30b,
(2) The flow is branched into two flows indicated by the arrow 30c and sent to each process. Therefore, the branch variable M of the branch icon 25a is set to "2". The numbers "1" and "2" are attached to the lower side of the drawings of the arrows 30a to 30c, which indicate the numbers attached to each of the two streams of information.

An item name setting component 27 is provided at the end of the arrow 30a.
a is set. This part is a part icon part 22
The item name setting component icon 27 is set. As a result, the information item flowing through the arrow 30a is given the item name "product type A", and the information item flowing through the arrow 30a is treated as the item name "product type A" in the subsequent processing.

Arrow 3 starting from the item name setting component 27a
0d is set to terminate the branch component 25b. A branch variable “2” is set in the branch part 25b. From the branch part 25b, four arrows 30d to 30g
Is branched, and the conditional expression of “product 2 =“ product a ”” is indicated by an arrow 30d, the conditional expression of “product 2 =“ product b ”” is shown by an arrow 30e, and the product type 2 = is shown by an arrow 30f. Conditional expressions of "product c" are set respectively. Branch part 25b
Only information that meets each condition will flow through the respective arrows. Arrow 30d ~
Item name setting components 27d to 27f are provided at the ends of 30f.
Is set. As a result, the item name of "product a" is set in the information flowing through the arrow 30d.
The item name of "product type b" is set in the information sent via 0e, and the item name of "product type c" is set in the information sent via the arrow 30f.

Arrows 30h to 30j are set starting from each of the item name setting components 27d to 27f. At the end of each of the arrows 30h to 30j, the processing method setting component 28 is
a to 28c are set. Processing method setting component 28a-
Each of 28c processes the information sent via each of the arrows 30h to 30j. Processing contents are processing method setting section 3
It is set by 3.

In FIG. 3, the processing method setting unit 33 sets the name of the processing method to “weight total”, and “weight” is simply added from the initial value 0 as a total item (item to be totaled in the sent data). It is set to be totaled in. The format line, column, output control, rounding method, and unit are also set by the processing method setting unit 33.

An arrow 30 branched from the branch part 25b
Since no condition is attached to g, all data will flow through the arrow 30g. The end of the arrow 30g is connected to the item name setting component 27g, and the transmitted data is sent via the arrow 30k after the item "subtotal" is added by the item name setting component 27g, and the processing method setting component The weight is totalized by 28d.

Since the contents of the processing method setting parts 28a to 28d are the same, the staff selects the copy (COPY) icon of the edit icon portion 21 to set the processing method setting part 28a as the original, for example. It is possible to set each component by copying the components 28b to 28d.

Further, the processing performed after the branch part 25b, which is the part surrounded by the dotted line 35a, is made into a block (partization) with the block name "product type 2 total" by the operation of the editing icon 21 by the staff. The staff can handle the blocked part as one part.

At the end of the arrow 30b, the item name setting component 2
7b is set. As a result, the item name "product type B" is added to the information flowing through the arrow 30b. An arrow 30l is arranged starting from the item name setting component 27b, and the information flowing through the arrow 30l is processed by the blocked component 35b. The block name of the block-shaped component 35b is "type 2 total",
Here, the same processing as the block surrounded by the dotted line 35a is performed.

At the end of the arrow 30c, an item name setting component 27c for setting the item name "total" is set. A processing method setting component 28e for totaling weights is set from the item name setting component 27c via the arrow 30m. The function of the processing method setting component 28e is also the same as that of the processing method setting components 28a to 28d, and is set so as to aggregate the item of "weight" in the data.

FIG. 4 is a flow chart showing the processing performed by the information processing procedure setting unit 6 of the data editing / processing support apparatus when the information processing procedure illustrated in FIG. 3 is input.

If it is determined in step S001 that the staff member has selected one component from the component icon portion 22, the staff member selects the next component (the component downstream of the component selected in step S001) in step S002. Is performed. In step S003, the attribute value of the selected component is set. Here, the setting of the attribute value is to set parameters such as restrictions on the flow of processing.

If it is determined in step S011 that the blocked component is called by the staff, the desired component of the staff is selected from the blocked components in step S012.
The part selected in step S013 is the setting area 2
It is placed in 0. In step S014, the attribute value of the arranged component is set. Here, the attribute value means a parameter for each part, and in FIG.
3 means the contents set by 3.

If it is determined in step S021 that the staff has instructed componentization (blocking), a range for componentization is set in step S022. This means, for example, the portion surrounded by the dotted line 35a in FIG. In step S023, the attribute value of the range in which componentization is performed is set. Here, the attribute value means a parameter such as a component name at the time of componentization.

If it is determined in step S031 that the staff has selected the editing command, the editing command selected in step S032 is executed. The selection of the edit command is performed by the staff selecting an icon such as copy, move, or delete of the edit icon portion 21.

If it is determined in step S041 that the staff has selected the information customization setting function, that information is registered in step S042. Here, the information customization setting refers to setting for managing a simple information relationship with a representative name. The staff can execute the series of processing registered by this function by specifying the customized name. As an example, the following settings are made when setting "Manage" type code A "whose numerical value is greater than 10 and less than 15 or" type code B "whose numerical value is 3 under the name" cold type "". Expression (1) is registered by the staff as customization information.

Cold product type = (product product code A> 10 & product product code A <15) OR product product product code B = 3 (1) As a result of this registration, the name “cold product product” is the numerical value of product product code A. Information is greater than 10 and 1
Less than 5 or numerical information of product code B is 3
Will be defined.

If it is determined in step S051 that the staff has selected the device management command, the device management command is executed in step S052. Here, the device management command is a command for outputting an image of a form created by the processing procedure currently set in the setting area 20. By selecting this command, the staff can set and edit the processing procedure while visually judging the image of the form, so that the work efficiency is improved.

When the staff issues an end command for setting the machining procedure in step S061, the process here is ended.

When it is selected in step S061 in FIG. 4 to finish the input of the machining procedure, the inputted machining procedure is stored in the analysis component storage unit 9 as an analysis component. The information processing procedure interpretation unit 7 is an analysis component storage unit 9
The analysis part is read from and the procedure of information processing is interpreted.

FIG. 5 is a flow chart showing the processing performed by the information processing procedure interpretation unit 7. In step S101, one of the uninterpreted or modified analytical components is read from the analytical component storage unit 9. In step S102, an information flow route search is performed for the procedure (tree structure information) of the analysis component, and in step S103, it is checked whether there is a setting error in the attribute value of the analysis component. If YES in step S103, a report regarding an attribute value setting error is output through the interpretation result output unit 12 in step S104.

In step S105, it is checked whether or not undefined information and undefined variables are used in the analysis component. If YES in step S105, step S10 is performed.
In 6, the undefined information variable use report is output through the interpretation result output unit 12.

In step S107, it is checked whether or not the analysis component has unused information and unused variables. If YES in step S107, a report of unused information variables is output through the interpretation result output unit 12 in step S108.

In step S109, it is determined whether or not there are multiple settings of variables. If YES in step S109, a report regarding the multiple settings of variables is output through the interpretation result output unit 12 in step S110.

In step S111, it is determined whether or not there is an unexecutable contradiction in the analysis component, and in step S111 Y
If it is ES, the processing here ends.

If NO at step S111,
In step S112, a database search sentence (SQL sentence) for retrieving necessary information from the database server 4 to execute the analysis component is automatically generated. In step S113, the analysis procedure (tree-structured processing model) included in the analysis component is converted into an execution format in a dedicated language. The analysis component converted into the database search statement and the execution format in step S114 is the execution format storage unit 1.
0 is registered, and the processing here ends.

The analysis component stored in the execution format storage unit 10 is managed by the information processing procedure execution unit 8 and is executed when the activation condition set by the staff is satisfied.

As a start setting method, a method is started when processing of another analysis component group is being performed, a method of individually starting a hand from a starting screen, a method of starting a timer according to time, and a method of starting at a fixed cycle time. There is a method of repeating. It is also possible to combine a plurality of methods as the activation method. For example, conditions such as "monitor any database item in a certain cycle, judge the change information when the numerical value is changed, and start the analysis component depending on the situation if the set condition is met" It is possible to set it as an automatic database management system.

FIG. 8 is a flow chart showing the processing performed by the information processing procedure executing section 8. The processing routine of FIG. 8 is executed at a constant cycle time (can be set from ms unit to several hours depending on the occupancy of the CPU) in step S201. In step S202, the analysis component that satisfies the activation condition is read from the execution format storage unit 10.

The analysis component read in step S203 is executed. By executing the database search statement included in the analysis component activated at this time, necessary information is read from the database, and the data is evaluated and processed according to the interpretation procedure. As a method of reading information from the database, either a method of repeating reading / processing for each record or a method of reading information collectively and processing as an internal variable may be used. The evaluated and processed information is output via the analysis result output unit 13 in a form format and a screen format according to the setting.

The analysis result is also recorded in the database server 4. Further, the analysis result is output to the personal computer 14 as necessary, and can be processed by utilizing spreadsheet and statistical analysis software.

During the execution of the analysis component, if the activation condition of another analysis component is satisfied, the analysis component satisfying the condition is newly activated. If the analysis part contains a dialogue command symbol for temporarily suspending the process and waiting for information input from the staff, the process is interrupted when the dialogue command symbol is executed, and the The process is suspended until there is an input.

In step S204, it is determined whether there is another executable analysis component, and if YES, step S204
The process from 203 is repeated.

If NO in step S204, the process here ends. Next, processing when the analysis component shown in the input screen shown in FIG. 3 is executed will be described.

When the analysis component is executed, the data shown in FIG. 2 is read from the database server 4 by the database search statement. Read the order No. The order No. Data processing is performed in order.

Order No. The information of 0001 is the type 1 =
Since the information is “product A” and product 2 = “product a”, processing is performed by the following three flows based on the conditional expressions set for each of the arrows starting from the branch part 25a.

(1) Branch part 25a → item name setting part 27a → branch part 25b → item name setting part 27d → processing method setting part 28a (2) branch part 25a → item name setting part 27a → branch part 25b → Item name setting part 27g → Processing method setting part 2
Flow of 8d (3) Branch part 25a → item name setting part 27c → processing method setting part 28e The following processing is performed on the information of 0001.

(1) Processing for totaling weight after item names "variety A" and "variety a" are added. (2) Weighting after adding item names "variety A" and "subtotal". (3) After the item name “total” is added, the weight is calculated. Order No. Order No. including processing of 0001 Processing based on the product type name of each order is performed in order, and as a result, the respective data collected are output as the weight data of each product type in the form of the form shown in FIG.

Next, the information input to the database server 4 is the information shown in FIG. 9, and from this information, the staff can confirm the number, weight and delivery date according to each division and each type shown in FIG. The information processing procedure input unit 11 is assumed for the case of creating a form that outputs the quantity and the delivery rate ratio.
The information input by will be described. Since the form in FIG. 11 has numerical values arranged in the row direction and the column direction, the row items and the column items are set.

FIG. 12 is a diagram showing a processing procedure of line items set by the staff to create the form of FIG. 11, and FIG. 13 is a column set by the staff to create the form of FIG. It is a figure which shows the processing procedure of an item.

Referring to FIG. 12, in the line item, the branch part 25a is arranged as the beginning of the machining procedure. Arrows 30a to 30c are arranged from the branch part 25a, and item name setting parts 27a to 27c are arranged at the end of each arrow. An arrow 30g is arranged with the item name setting component 27a as the starting end, and a branch component 25b is arranged at the end of the arrow 30g. Arrows 30d to 30f are arranged from the branch part 25b. Arrows 30d-3
Item name setting components 27d to 27f are arranged at the respective ends of 0f. An arrow 30h is set with the item name setting component 27b as a starting end, and a blocked component 35d is arranged at the end portion of the arrow 30a.

Further, in the setting area 20, a processing flow setting section 37a for setting the branch condition of the arrow 30a is displayed. In the processing flow setting unit 37a, the arrow 30a
Name ("-" is set because it is not defined here), branch control (a number given to the flow of information, which is the same as the number set below in the drawing of arrow 30a) No.) and branching conditions are set. The "&" symbol included in the branch condition is a prefix meaning that the item having that prefix is a database item. Different prefixes are used depending on the types of items and variables. The types of prefixes are shown in FIG. That is, an item having a "%" symbol as a prefix is processed as a form cell item, a variable having a "#" symbol as a prefix is processed as a local variable, and a variable having a "*" symbol as a prefix is processed as a global variable. Also, items having the "@" symbol as a prefix are treated as customized items. The range enclosed by the """symbol is treated as a character string.

Further, in the setting area 20, the item name setting component 2
An item name setting section 39a for setting the setting contents of the item name of 7a is displayed. In the item name setting unit 39a, the name of the item name setting component 27a, the format line, the column (the number of characters for displaying the item name), and the output control (output process of the character string) are set.

Referring to FIG. 13, in the column item, a branch part 25d, which is the starting point of the machining procedure, is arranged at the upper left of the drawing of the setting area 20. Arrows 30h to 30k are arranged with the branch part 25d as the starting end, and the arrow 30h
Item name setting component 27h is provided at each end of h to 30k.
~ 27k are arranged. Item name setting parts 27h-2
Arrows 30l to 30o are arranged with 7k as a starting end, and processing method setting components 28a to 28d are arranged at the end portions of the arrows 30l to 30o. Further, in the setting area 20, a processing method setting unit 33a for setting the contents of the processing method setting components 28a to 28c and a processing method setting unit 33b for setting the processing method of the processing method setting component 28d are displayed. Further, in the setting area 20, a processing flow setting section 37b for setting the condition of the information flowing through the arrow 30j is displayed. Further, the setting area 20 displays a customization setting section 41 for making customization settings.

It should be noted that the parts such as the item name setting part and the processing method setting part are either solid lines or dotted lines. It is displayed so that the staff can tell at a glance if there is any. Referring to the legend in Figure 7,
If the part forming the outer periphery of the part is a solid line, the part is a part for laying out the form, while if the outer peripheral part of the part is a dotted line, the part is a part for performing internal processing (for example, counting). .

Next, the data processing performed by setting the row item and the column item will be described. Referring to FIG.
The information input from the database server 4 in the line item is branched by the branch component 25a. Branch part 25a
Since the branch variable of is 2, the input information is divided into two streams and processed. One flow is arrow 3
Flow through either 0a or 30b, and the arrow 3
According to the branch condition set for each of 0a and 30b,
If the division name in the input information is "section A", the information flows through the arrow 30a, while if the division name is "section B", the information flows through the arrow 30b. . The second flow is due to the arrow 30c, and since no branch condition is set for this arrow, all input information will flow through the arrow 30c.

The item names “partition A”, “partition B”, and “total” are added to the information flowing through the arrows 30a to 30c by the item name setting components 27a to 27c, respectively. The item name setting unit 39a is used to set the item name. The information having the item name “Category A” is further branched into two flows by the branch component 25b. If the product name is "product A", the arrow 30d flows and the item name setting part 2
The item name “product type A” is further added by 7d. On the other hand, if the product name is "product B", the item name "product B" is added by the item name setting component 27e through the arrow 30e. Further, all the information input to the branch component 25b flows in the arrow 30f where the branch condition is not set, and the item name "total" is added by the item name setting component 27f.

The portion surrounded by the dotted line 35 is made into blocks (parts) by the staff, and this part is treated as one part with the block name "product type classification". The information from the item name setting component 27b is transmitted via the arrow 30h by the blocked component 35d and the dotted line 35
The same processing as the part surrounded by is performed.

Referring to FIG. 13, in the processing of the column item, the input information is branched by the branch component 25d.
Since no conditions are set for the arrows 30h and 30i, all the input information flows through the arrows 30h and 30i, and the item names "quantity" and "weight" are set by the item name setting parts 27h and 27i, respectively. After that, it is processed by the processing method setting parts 28a and 28b. Processing method setting part 28
The processing method performed in a and 28b is set by the processing method setting unit 33a. In the processing method setting component 28a, the processing method name is "total 1", and the numerical data of the "number of orders" of the input information is added from the initial value 0 by simple addition. On the other hand, in the processing method setting component 28b, "total 2" is set as the processing method name, and the "order weight" data in the input data is simply added from the initial value 0.

"@Delivery in progress" is set as a branch condition in the arrow 30j. This setting is performed by the process flow setting unit 3
7b. “@Delivery date middle” is a word set by the information customization function to mean that the difference between the production date and the delivery date is less than 5. This setting is performed by the customization setting unit 41.

As a result, the information flowing through the arrow 30j has a difference of less than 5 between the production date and the delivery date.
The item name is set, and the numerical data of “order weight” of the data input by the processing method setting component 28c with the processing method name “total 3” is added from the initial value 0 by simple addition.

Since no branching condition is set for the arrow 30k, all the input information flows through the arrow 30k and the item name setting component 27k sets the item name "delivery ratio" and then the machining method setting. Processing is performed by the part 28d. The contents of processing by the processing method setting component 28d are set by the processing method setting unit 33b. Here, the processing method is set so that ratio calculation is performed. "Precision rate" is set as the name of the processing method, the numerical value of "total 2" of the processing method setting component 28b is used as the denominator of the ratio, and the numerical value of "total 3" of the processing method setting component 28c is used as the numerator. Will be done.

Order No. shown in FIG. The data processing set in FIGS. 12 and 13 will be described assuming that 0001 data is input.

With reference to FIG. 12, the order number entered in the line item is displayed. Since the data of 0001 is the data of the category A, the item name of the "category A" is set by the item name setting component 27a via the arrow 30a. Since the data is data of the product type B, it is sent via the arrow 30e and the item name "product type B" is set. Data is also sent from the branch part 25b through the arrow 30f for which the condition is not set, whereby the item name "total" is set. The item name setting component 27c gives the item name "total" to the data sent from the branch component 25a via the arrow 30c in which the condition is not set.

That is, the order number. In the data of 0001, in the line item, a part to which the item names of “Category A” and “Product type B” are attached, a part to which the item names of “Category A” and “Total” are attached, and an item name of “Total” Will be processed in three parts.

Next, referring to FIG. 13, as the column items, the order number. The data of 0001 starts from the branching part 25d and goes through the arrows 30h and 30i, respectively, and the item name "number"
And after the item name "weight" is attached, processing method setting part 2
The number of orders and the order weight are totaled by 8a and 28b. The entered order number. Since the data of 0001 is the production date of August 3 and the delivery date is August 5, the condition of the delivery date set in the customization setting unit 41 is satisfied, and the data also flows to the arrow 30j. Arrow 30j
As for the flow of data through, the numerical value of the order weight in the data is aggregated by the post-processing method setting component 28c to which the item name “Delivery medium amount” is added.

In the input data, after the item name of the delivery ratio is set from the branch part 25d through the arrow 30k with no condition set, the ratio is calculated by the processing method setting part 28d.

That is, the order number. In the column items, the data of 0001 is “number”, “weight”, “medium amount on time”,
It will be processed by the part to which the item of "Delivery ratio" is attached.

By the processing of each row item and column item described above, the No. When the data of 0001 is input,
The fields marked with * in the form shown in are updated.

The processing described above is the order No. As a result, the tabulation and ratio calculation are performed for each item, and finally the form as shown in FIG. 14 is output via the analysis procedure result output unit 13.

Next, the information recorded in the database server 4 is the information shown in FIG.
A case where the form shown in 5 is output will be described. In FIG. 15, the information recorded in the database server 4 is arranged in the roll week order in the vertical direction (row direction).

Since this form displays the data contents in the column direction, only the column items are set.

At this time, the processing procedure in the column direction input by the user through the information processing procedure input section is as shown in FIG. Referring to the figure, the setting area 20 of the display screen
A branch component 25a is disposed in the branch component 25a, and an arrow 30a indicating the flow of information is set from the branch component 25a. The condition that the delivery date is on time is set for the arrow 30a, and only the condition that satisfies this condition will flow through the arrow 30a. Here, "@ delivery date middle" is a name defined by the information customizing function as shown in FIG. A processing method setting component 28a is arranged at the end of the arrow 30a. "Sort" is set for the processing method of the processing method setting component 28a. The content of the processing performed by the processing method setting component 28a is set by the sort content setting unit 45. Here, the name of the processing method setting component 28a is set to "roll week unit". Further, the processing method setting component 28a is set with three sort keys of sort keys 1 to 3, and the staff sorts the numerical data in the item by selecting one of the sort keys in the item of totaling points. be able to. Here, the roll week unit of the sort key 1 is selected as the aggregation point, and the roll week is sorted. In addition, since the number is set as the total item, the number is totaled every time the roll week, which is the total point, changes. Data from the processing method setting component 28a is sent to the branch component 25b via an arrow 30b. The number of branches of the branch part 25b is "5", and the information input to the branch part 25b is the item name setting part 27 via the arrows 30c to 30g.
a to 27e. Item name setting component 27a
The information input to ~ 27e is processed through the arrows 30h to 30l after the item names of "roll week", "outer diameter", "pipe GrNo.", "Number of pipes", and "delivery date" are set. It is input to the law setting components 28f to 28j. The processing content of the processing method setting component 28f is set by the processing flow setting unit 37. In the processing flow setting unit 37, the processing method setting component 28f
In addition to the fact that the process performed in step 1 is "display" and the name is "roll week", format lines, columns, and output control (arrangement of output data) are set. There is a small number (7.2) set in the “column” item, but this indicates that there are 7 significant digits, and 2 digits are set as the digits below the decimal.

Similarly, the machining method setting component 28g displays the "outer diameter" in the input data, and the machining method setting component 28i displays the "number" of the input data. In the part 28j, the "delivery date" of the input data is displayed. Further, in the processing method setting component 28h, the input data "pipe making GrNo." Is displayed.

When the staff performs the column item setting shown in FIG. 16 through the information processing procedure input unit 11, the column shown in FIG.
The form shown in is output.

Next, it is assumed that the information recorded in the database server 4 is the information shown in FIG. 2 and the staff outputs the form shown in FIG. 17 based on the information.

At this time, the staff inputs the processing procedure shown in FIG. 18 in the column item setting, and inputs the processing procedure shown in FIG. 19 for setting the processing procedure of the row item. The information input with reference to FIG.
It is branched by 5a. Here, the arrow 30a indicates “category =
The condition of “Category =“ Category B ”” is set in the “category A” and the arrow 30b, and no condition is set in the arrow 30c. Satisfy the conditions set in arrow 30a,
The information that has flowed through the arrow 30a includes the item name setting component 27.
The item name of "Category A" satisfies the condition set by the arrow 30b by a, and the item name setting component 27b sets the item name of "Category B" in the information flowing through the arrow 30b. Becomes Further, the item name "total" is set by the item name setting component 27c in the information flowing through the arrow 30c. The information in which the item name of "Category A" is set by the item name setting component 27a is then input to the branch component 25b via the arrow 30d. If the product name is "product A", the information input to the branch part 25b indicates that the product name "product A" is set by the item name setting component 27d via the arrow 30e, and the product name is "product B". For example, the item name of the "product type B" is set by the item name setting component 27e through the arrow 30f, and if the product type name is "product type C", the item name of the "product type C" by the item name setting component 27f through the arrow 30g. First name is set. The information input to the branch part 25b is unconditionally input to the item name setting part 27d via the arrow 30h, and the item name "subtotal" is set in the item name setting part 27d.

The processing within the dotted line 35 is divided into blocks by the staff, and this block is the item name setting component 2
It is used for the information output from 7b.

The flow of information in line items will be described with reference to FIG. The input information starts from the branch part 25a, and the arrow 30a indicates that the condition of "@ deadline ahead" is satisfied.
After the item name “advance delivery date” is set by the item name setting component 27a via the, the processing method setting component 28a totals the “weight” items. Here, "@ delivery date ahead" is information set by the information customizing function, and here is information that production date <delivery date.

For the information satisfying the condition of "@ delivery delay", after the item name of "delivery delay" is set by the item name setting component 27b through the arrow 30b, the item of "weight" is set by the processing method setting component 28b. Is calculated. Here, "@ delay in delivery date" is information defined by the information customizing function, which is information defined as production date> delivery date.

All the information input to the branch part 25a is input to the item name setting part 27c via the arrow 30c, the item name "subtotal" is set, and then the "weight" is set by the processing method setting part 28c. Items are totaled.

By the settings of FIGS. 18 and 19, the form shown in FIG. 17 is created. FIG. 20 is a diagram for explaining an image of a composite format form output in one embodiment of the present invention.

As shown in FIG. 22, this form is a form in which two forms, a form of order details and a form of manufacturing process, which are vertically freely arranged forms, are set in a composite format. This form is created by the staff setting each item of the display of the composite format form setting shown in FIG. By using the composite format form setting of FIG. 21, the form 1 and the form 2 are output in a vertically combined form.

As a composite form of a form, for example, after form B and form C are combined in the horizontal direction as shown in FIG. 23,
It is also possible to combine three types of forms by further combining the combined form with the form A in the vertical direction.

FIG. 24 is a diagram for explaining the setting of a freely arranged form. With reference to the figure, the staff can freely arrange the items for displaying data in the layout design screen 47 in the freely arranged form. The form setting unit 49a is used for setting the form, and the display content setting unit 49b is used for setting the display content.

25 to 29 are views showing an example of information processing using this apparatus. The information contained in the database server 4 is the information shown in FIG. 25. From these pieces of information, the staff sets the difference ratio (the weight of each product type set in the planned monthly production amount and the production plan result information). It is assumed that the order details of a product having a large ratio of the total weight of each product) are output. Here, the staff sets the processing procedure for creating the form shown in FIG. 26 as the first stage processing. In the form shown in FIG. 26, the total number of pieces, the total weight, the total weight of orders whose delivery date and production date match (medium delivery date), and the delivery date among the total weights in each form. The volume ratio (delivery ratio) is output. The output numerical value is recorded in the database server 4. Next, from the information recorded in the database server 4, according to the form shown in FIG. 27, the weight of each of the products A to C, the monthly production scheduled amount, the difference between the weight and the monthly production scheduled amount, the weight against the monthly production scheduled amount, and the monthly The ratio of the difference in the planned production amount (difference ratio) is output. The output information is recorded in the database server 4.

For the difference ratio information recorded in the database server 4, the determination component set by the user and shown in FIG. 28 is activated. Difference ratio is +20.0 for judgment parts
The setting is made so that the order details of the corresponding product are output when the difference ratio is equal to or higher than% or the difference ratio is equal to or lower than -20.0%. As a result, as shown in FIG. 29, the order details of the product type that matches the conditions of the determination component are output. The output order details are simultaneously recorded in the database server 4.

Regarding the processing of information using the above-described apparatus, a method of manually activating each analysis component one by one and the same procedure as the individual form creation shown so far are followed by a series of staff operations. There is a method of automating the analysis procedure of as a know-how (= making an analysis know-how database). That is, the analysis procedure is a method in which the analysis procedure itself is set as one component.

FIG. 30 shows the above-mentioned staff analysis procedure (see FIG. 2).
5 to 29) is an example of automation setting.

The setting method of the analysis procedure shown in FIG. 30 is the same as the setting of the analysis component. Conventionally, it was difficult to set for the staff without computer knowledge because it was possible to set only the final result information shown in FIG. 29 from the basic information shown in FIG. 25 at one time. Since it can be set to, it is possible to set intuitively while organizing the analysis procedure. The only difference is that the process step (= component) to be set is added to the setting of the analysis component. For example, in FIG. 30, analysis parts, comment parts,
Unique parts such as output parts and end parts are displayed. Of these parts, the analysis part indicates the individual data processing procedure shown above, the comment part displays the specified message on the screen, the output part outputs the specified form, and the end part indicates the end of the process. It is a component for clarification. Even if there is no ending part, if there is no part to be processed, the process automatically ends. By combining these parts, non-regular procedures can be made into a database as regular,
It is also possible to pass on the technology.

The information output from the information processing procedure execution unit 8 is simultaneously sent to the personal computer 14 via the communication device as needed, and is detailed by the spreadsheet software or the statistical analysis software according to the staff's request. Analysis is performed.

[0117]

According to the data processing apparatus of the first aspect,
Since the data processing procedure can be set by a simple operation, usability is improved.

In the data processing device according to the second aspect, in addition to the effect of the data processing device according to the first aspect, it is possible to reduce setting mistakes in the processing procedure.

According to the data processor of claim 3, in addition to the effects of the data processor of claim 1 or 2,
Usability is improved.

In addition to the effect of the data processing device according to any one of claims 1 to 3, the data processing device according to claim 4 executes the processing procedure based on the stored condition. improves.

[Brief description of drawings]

FIG. 1 is a block diagram showing a configuration of a data editing / processing support device in production planning and an associated device configuration according to an embodiment of the present invention.

FIG. 2 is a diagram showing a first example of information recorded in a database server 4 of FIG.

FIG. 3 is a first diagram showing setting of an information processing procedure.

FIG. 4 is a flowchart showing a process performed by an information processing procedure setting unit 6 in FIG.

5 is a flowchart showing a process performed by an information processing procedure interpretation unit 7 in FIG.

FIG. 6 is a diagram showing a form output by the settings shown in FIG.

FIG. 7 is a diagram for explaining variables used in the present embodiment.

8 is a flowchart showing a process performed by an information processing procedure execution unit 8 in FIG.

9 is a diagram showing a second example of information recorded in the database server 4 of FIG.

10 is a diagram showing a third example of information recorded in the database server 4 of FIG.

FIG. 11 is a first diagram showing an example of a form.

FIG. 12 is a second diagram showing the setting of the information processing procedure.

FIG. 13 is a third diagram showing the setting of the information processing procedure.

14 is a diagram showing a form output by the settings shown in FIGS. 12 and 13. FIG.

FIG. 15 is a second diagram showing an example of a form.

FIG. 16 is a fourth diagram showing the setting of the information processing procedure.

FIG. 17 is a third diagram showing an example of a form.

FIG. 18 is a fifth diagram showing the setting of the information processing procedure.

FIG. 19 is a sixth diagram showing the setting of the information processing procedure.

FIG. 20 is a fourth diagram showing an example of a form.

FIG. 21 is a diagram illustrating setting of a composite form.

FIG. 22 is a diagram for explaining an image of a composite form.

FIG. 23 is a diagram showing an image of a composite form of forms A to C.

FIG. 24 is a diagram for explaining a freely arranged form.

FIG. 25 is a diagram showing a specific example of information recorded in the database server 4.

FIG. 26 is a diagram showing a specific example of a form created based on the information shown in FIG. 25.

FIG. 27 is a diagram showing a specific example of a form created based on the information of FIGS. 25 and 26.

28 is a diagram showing a determination component based on the information of FIG.

29 is a diagram showing a form output based on the determination condition of the determination component of FIG. 28.

FIG. 30 is an example of automatic setting of the staff analysis procedure shown in FIGS. 25 to 29.

[Explanation of symbols]

 1 data processing and support device 2 host computer 3 production planning device 4 database server 5 database registration device 6 information processing procedure setting unit 7 information processing procedure interpretation unit 8 information processing procedure execution unit 9 analysis component storage unit 10 execution format storage unit 11 Information Processing procedure input section 12 Interpretation result output section 13 Analysis procedure result output section 15 Input / output interface section 20 Setting area 25 Branch parts 27 Item name setting parts 28 Processing method setting parts 30 Arrow parts

Claims (4)

[Claims] 1. A data processing device for processing input data according to a processing procedure including a plurality of set processing steps, wherein the processing display means displays each of the plurality of processing steps, and data between the processing steps. Direction display means for displaying the flow direction of, a selection means for selecting a desired processing step and a data flow direction from the displayed processing step and the displayed data flow direction, and the selected processing step and A data processing device, comprising: a setting unit that sets a processing procedure based on a data flow direction. 2. The data processing apparatus according to claim 1, further comprising an inspection unit that inspects whether the processing procedure set by the setting unit includes a contradiction. 3. The data processing apparatus according to claim 1, further comprising a conversion unit that converts the processing procedure set by the setting unit into an execution format. 4. A storage unit that stores a condition for executing the processing procedure set by the setting unit, and an executing unit that executes the processing procedure set by the setting unit based on the stored condition. Further equipped with,
The data processing device according to claim 1.