JPH04287119A - Table compressing/developing system - Google Patents

Abstract

PURPOSE:To improve efficiency for utilizing the space of a dictionary or the like and to shorten input/output time by providing the valid number or the maximum number of parameters at a parameter table and executing the processing of compressing the table or developing the compressed table while excluding useless records in the case of inputting/outputting data to the dictionary or the like concerning the table compressing/developing system. CONSTITUTION:A parameter table 1 is provided while being composed of the valid number (m) of parameters, the maximum number (n) of parameter, 0-row data setting an initial value to an input value field for storing a parameter name and an inputted value corresponding to every row on a screen, and 1-(n) rows data having the input fields for storing inputted value while copying this 0 row data and corresponding to the input from the screen, the input value of the parameter is set to the relevant input field. Then, the not-inputted row data is excluded in the case of the output, the table is compressed while setting the valid number (m) and afterwards, the data are outputted to the dictionary or the like.

Description

[Detailed description of the invention]

0001

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a table compression/expansion method for compressing/expanding records in table format.

0002

2. Description of the Related Art Conventionally, in a dictionary input/output function used in a recording file of a computer system, as shown in FIG. The contents of this are stored in the dictionary 23 as they are. The configuration and operation of FIG. 9 will be briefly described below.

[0003] In FIG. 9, a variable table 21 has a record for each row of the table on a table-format screen 22, and holds variable names and input values. The table-format screen 22 is a table-format screen displayed on the display, and is used to input values in association with variable names. The dictionary 23 is a variable table 21
It is a dictionary that stores .

Next, the operation will be explained. (1) Display the table-format screen 22 shown in the figure on the display. (2) The user inputs a value into the variable name input field on the screen 22 using the keyboard, for example, DD1, EE1, F.
Enter F1 as shown. In response to this input, the variable names D01 and E0 are added as shown in the variable table 21.
1. Store input values DD1, EE1, and FF1 in F01.

(3) All records in the variable table 21, ie, all records including blank records with no input values, are stored as they are in the dictionary 23 and saved.

[0006]

[Problems to be Solved by the Invention] As mentioned above, since all the records of the variable table 21 were stored as they were in the dictionary 23, the number of rows in the table increased, resulting in blank spaces where variable values were not set. When there are many useless records, there is a problem that the space in the dictionary 23 cannot be used efficiently and a lot of time is required for inputting and outputting data to and from the dictionary 23.

[0007] The present invention provides the effective number of variables in the variable table,
By setting a maximum number of records and performing compression by deleting unnecessary records during input/output to dictionaries, etc., and processing to expand the compressed records, we aim to improve the efficiency of use of space in dictionaries, etc., and shorten input/output time. It is an object.

[0008]

[Means for Solving the Problems] Means for solving the problems will be explained with reference to FIG. In FIG. 1, variable table 1 consists of the effective number m of variables, the maximum number n of variables, 0 row data where initial values are set, and 1 row data to n row data where input values are stored in association with variable names. It is something.

Screen 2 is for displaying the contents of variable table 1 on the display and for inputting variable values from input fields. The dictionary 3 stores and saves the variable table 1.

0010

[Operation] As shown in FIG. 1, the present invention sets the input value of the variable in the corresponding input field in the variable table 1 in response to the input from the screen 2, and sets the input value of the variable in the corresponding input field in the variable table 1, and sets the input value of the variable in the corresponding input field in the variable table 1. After deleting and setting the effective number m, dictionary 3
I am trying to output it to etc. Also, after importing data from dictionary 3 and storing it in variable table 1, copy the 0-row data for (maximum number of variables n - effective number of variables m) to the end of variable table 1 and expand it. That's what I do.

Therefore, for variable table 1, dictionary 3
Compression that deletes unnecessary records during input/output to etc.
By performing processing to expand the compressed data, it is possible to improve the efficiency of use of space such as the dictionary 3 and shorten input/output time.

0012

Embodiment Next, the structure and operation of an embodiment of the present invention will be explained in detail using FIGS. 1 to 8. In FIG. 1, variable table 1 includes a control record (CONTROL record) that sets control information such as the number of screens, a format record (FORMAT record) that sets information such as screen divisions and formats, variable types,
Effective number of variables m, maximum number of variables n, variable names A, B, C,
It is composed of 0 line data in which initial values are set, and 1 line data to n line data in line units that store the values of variables input from the screen.

Screen 2 is for displaying the contents set in variable table 1 and for inputting variable values from input fields. The dictionary 3 stores a variable table 1 in which variable values are stored in input fields on the screen. Here, the unit information in the dictionary 3 is information for initially creating the variable table 1, and the user-defined data is data input by the user from the screen 2 and stored in the variable table 1. A detailed explanation will be given below.

According to the order shown in the flowchart of FIG.
The process of creating variable table 1 based on unit information will be described with reference to FIG. In FIG. 2, S1 reads unit information into variable table 1. This reads the unit information created and stored in advance in the dictionary 3 in FIG.
Store as -1. This variable table 1-1 is set with variable types 3 (here, three types, variables A, B, and C), the effective number m of variables, and the maximum number n of variables.

[0015] In S2, the maximum value n and initial values (initial value E of variable E, initial value F of variable F) of variables are extracted from the variable table 1-1 whose contents were stored in S1. S3 copies the initial value to line 0. This is the variable table 1-1 on the left.
The initial values (initial value E of variable E, initial value F of variable F) are taken out and copied as 0 row data of variable table 1-2 on the right side.

[0016] S4 expands the maximum number of variables. This is data from one row to n of variable table 1-2 on the right side.
As shown in the row data, the content of the 0 row data is copied and expanded by the maximum number n. S5 performs screen display. Through the above processing, the unit information is extracted from the dictionary 3, 0-line data with initial values set based on this is created, and 0-line data is copied by the maximum number n to create 1-line data or n-line data. Expand. This creates a variable table 1 with n rows of data from the unit information created in advance.
-2 can be created, and the user is now ready to input the value of the variable from the screen.

Next, the operation when outputting user-defined data will be described in detail in accordance with the order shown in the flowchart of FIG. 4 and with reference to FIG. Here, the variable table 1-2 on the left side of FIG. 5 corresponds to the variable table 1-2 on the right side created in FIG. In FIG. 4, S11 inputs data from the screen. S12 updates the variable table. These S11 and S12 are the values of the variables in the variable table 1-3 on the left side of FIG.
, E, F are stored with values DD1, EE1, FF1, and variables D, E, F of two rows of data are stored with values DD2, EE2, FF2, etc.

[0018] In S13, it is determined whether or not the key variable has no value. If YES, that is, if no value has been input to the key variable, delete the row data of that row in S14, proceed to S17 when finished in S16, and repeat S13 for the next row if not finished. conduct. On the other hand, S1
If NO in 3, that is, if the value of the key variable has been input, the effective number is counted in S15, and when the process is finished in S16, the process advances to S17, and when the process is not finished, S13 is performed for the next line.

[0019] In S17, the effective number m is updated. this is,
Since we have deleted the row data for which no value has been entered in the key variable from the variable table 1-3 on the left side of FIG. Here, 3 is set in the effective number field of variable 4. S18 outputs (stores) the data to the dictionary 3 as user-defined data.

Through the above processing, the row data that the user inputs from screen 2 and stores in the variable table 1-3 in FIG. , and set the effective number of variables to compress it as shown in variable table 1-4 on the right side of Figure 5.
This is stored in the dictionary 3 as user-defined data. As a result, row data in which no variable values have been input is deleted and compressed before being stored in the dictionary 3, making it possible to effectively use the space in the dictionary 3 and reducing the capacity of the variable tables 1-4 to be output. This can be done in a short time.

Next, the operation at the time of inputting user-defined data will be described in detail in accordance with the order shown in the flowchart of FIG. 6 and with reference to FIG. Here, the variable table 1-5 on the left side of FIG. 7 is obtained by storing the variable table 1-4 on the right side created in FIG. 5 in the dictionary 3 and reading it out from the dictionary 3. In FIG. 6, in S21, user-defined data is input from the dictionary 3. As a result, variable table 1-5 on the left side of FIG. 7 is created.

[0022] In S22, 0-row data is copied to the end of the variable table by (maximum number of rows - number of valid rows). This is variable table 1 created by inputting from dictionary 3 in S21.
-5 maximum number of variables n, effective number of variables m (here 3)
Therefore, as shown in the variable table 1-6 on the right side of Figure 7, the 0-row data part is expanded to 4-row data, 5-row data by the maximum number n - effective number 3 = (n-3). Repeat with row data, repeating a total of (n-3) times up to n row data. This means that the compressed row data is expanded to its original state.

[0023] In S23, screen display is performed. Then, when there is an input from the user, variable table 1 on the right side of Figure 7
-6 is stored in the corresponding row data position. As described above, the user-defined data that has been compressed and stored in the dictionary 3 is read out, and based on the maximum number of variables set in it, n, and the effective number of variables, m, the original state before compression is calculated. can be expanded to. Thereby, the space in the dictionary 3 can be used effectively and the time required for input/output processing to the dictionary 3 can be shortened.

FIG. 8 shows an overall configuration diagram of the present invention. Here, the dictionary input/output is for inputting/outputting the dictionary 3-1, and is composed of a compression/expansion processing unit 5 that compresses/expands the variable table 1, and the like. The dictionary management tool is used to create and store unit information, etc.
It is a tool to manage 1.

The control processing includes various controls (various controls such as displaying the variable table 1 on the screen 2, taking in the value of the variable input from the screen 2 and storing it in the variable table 1, etc.). It is something to do. Further, as described above, the operation is as follows: (1) Unit information is extracted from the dictionary 3-1 and the variable table 1 at the upper right is created. Then, based on the upper right variable table 1, the 0th row data, 1st row data, to nth row data are developed to generate the upper left variable table 1 (already described using FIGS. 2 and 3).

(2) Store the value input from the top of the screen 2 into the variable table 1 at the lower left. Among the row data of the variable table 1 in the lower left that stores variable values, delete the row data in which the value of the key variable is not stored and set the effective number m of variables as shown in the variable table 1 in the lower right. Compress it like this. This compressed variable table 1 in the lower right is added to dictionary 3-1.
The data is stored as user-defined data (as described above with reference to FIGS. 4 and 5).

[0027]

[Effects of the Invention] As explained above, according to the present invention,
Set the effective number and maximum number of variables in variable table 1, and set dictionary 3.
Compression that deletes unnecessary records during input/output to etc.
Since a configuration is adopted in which processing is performed to expand compressed data, it is possible to improve the utilization efficiency of space such as the dictionary 3 and to shorten input/output time to the dictionary 3 and the like. This is particularly effective when the maximum number of variable tables 1 is very large.

[Brief explanation of the drawing]

FIG. 1 is a configuration diagram of one embodiment of the present invention.

FIG. 2 is a flowchart of unit information input processing according to the present invention.

FIG. 3 is an explanatory diagram at the time of inputting unit information according to the present invention.

FIG. 4 is a flowchart of user-defined data output processing according to the present invention.

FIG. 5 is an explanatory diagram when outputting user-defined data according to the present invention.

FIG. 6 is a flowchart of user-defined data input processing according to the present invention.

FIG. 7 is an explanatory diagram at the time of inputting user-defined data according to the present invention.

FIG. 8 is an overall configuration diagram of the present invention.

FIG. 9 is an explanatory diagram of the prior art.

[Explanation of symbols]

1: Variable table 2: Screen 3: Dictionary 4: Dictionary input/output section 5: Compression/expansion processing section

Claims (2)

[Claims] Claim 1: In a table compression/expansion method for compressing/expanding records in table format, the effective number m of variables is
, the maximum number of variables n, 0 line data with initial values set in the input value field that stores variable names and input values in association with each line on the screen, and input data that is a copy of this 0 line data. A variable table (1) consisting of one to n rows of data having an input field for storing a value,
In response to the input from the screen, set the input value of the variable in the corresponding input field, delete the row data that is not input at the time of output, set the effective number m, compress it, and then output it to a dictionary etc. A table compression/expansion method characterized by being configured as follows. Claim 2: After importing data from the dictionary or the like and storing it in the variable table (1), the 0-line data is copied and expanded by (maximum number of variables n - effective number of variables m). The table compression/expansion method according to claim 1, characterized in that: