JPH11143750A - Device and method for generating and updating data layout - Google Patents

Abstract

PROBLEM TO BE SOLVED: To automatically generate data layout, to retrieve validity, and to update it. SOLUTION: A record which is read from a file by a record reading part 5 and whose layout is unclear is transferred to an automatic record layout generating part 1 by a record content inspecting part 2. The automatic record layout generating part 1 determines field attributes common among the records according to majority decision within the number of scanned data, and generates the layout of the record. A record layout updating part 6 can update the content of data displayed along the layout at a record content displaying part 3.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data layout generating / updating apparatus and a data layout generating / updating method.

[0002]

2. Description of the Related Art In information processing, a file whose definition content of a record is unknown may be handled. In such a case, the record contents must be printed in hexadecimal number or printed in JIS code or SJIS code, and the printed result must be visually analyzed to clarify the definition contents of the record. Need work.

To solve this problem, Japanese Patent Application Laid-Open No. Hei 5-200401 discloses a record layout generation processing apparatus which can automatically generate a record layout from file data in a computer.

According to the publication, first, an attribute analysis unit determines one or more predetermined attribute candidates that can be taken by a code of each digit for each record of a given record group, and determines corresponding ones of all the records. The number of decisions for each attribute candidate is accumulated for each digit.

Next, the item information estimating unit determines, for each digit, one attribute to be selected from among the attribute candidates by a predetermined selection based on the magnitude of the number of cases and the priority determined in the attribute. Is divided into items consisting of one or more consecutive digits according to a predetermined relationship between the digit attributes of adjacent digits, and item attributes are determined based on the digit attributes of the digits belonging to the item. Then, item information indicating the arrangement of the item and the item attribute is generated.

[0006] Finally, the layout generating section generates a record layout based on the item information.

[0007]

In the above-described record layout generation processing apparatus, since the record layout is only automatically generated, there is a problem that the validity of the automatically generated record layout cannot be confirmed.

[0008]

According to the present invention, there is provided a data layout generating / updating apparatus for reading and analyzing data whose layout is unknown, and for automatically generating a layout. And a layout updating unit for reviewing the layout based on the display.

According to the data layout generating / updating method of the present invention, data whose layout is unknown is read and analyzed.
The layout is generated, and the contents of the data are displayed according to the generated layout, and the layout is updated.

The program recording medium of the present invention reads and analyzes data whose layout is unknown, generates the layout, displays the contents of the data in accordance with the generated layout, and records a program for updating the layout. It is characterized by having done.

[0011]

DESCRIPTION OF THE PREFERRED EMBODIMENTS In the present invention, in a stage where a file already exists and a record layout is analyzed and determined,
Reads a file, analyzes its contents, and automatically generates field definitions in records. The analysis scans the record from the left and assumes the field attributes and the number of digits for a 2-byte field, a 1-byte field, and a binary field. The same operation is performed for a plurality of records in the file, and the field definition is automatically generated based on the majority decision of the assumed field definition. In addition, the actual record contents can be displayed by the generated record definition, and the record definition can be corrected and confirmed.

Next, an embodiment of the present invention will be described with reference to FIG. FIG. 1 is a diagram showing the configuration of one embodiment of the present invention. In FIG. 1, reference numeral 1 denotes a record layout automatic analyzer which scans the contents of a record from the most significant digit to generate a one-field definition. A record content verifying unit for determining a field definition to be determined, a record content display unit for displaying the contents of the record according to the record definition and enabling manual correction, and a record definition unit for managing the record definition Reference numeral 5 denotes a record reading unit that reads records from the file in record units, and reference numeral 6 denotes a record layout updating unit that updates the record layout in conjunction with the record content display unit 3.

Next, the operation of this embodiment will be described with reference to FIGS.
This will be described with reference to FIG.

FIG. 2 is a flowchart mainly showing the operation of the record layout automatic analysis unit 1. The record read by the record reading unit 5 is scanned from the most significant digit by the record content verification unit 2, and the record layout automatic analysis unit 1 first determines whether it can be the first byte of a 2-byte system (A-2). . If true, it is determined that the next 1 byte is within the range of the 2-byte system (A
-3). Here, L indicates the entire record, and L (N) indicates the byte content at the relative position n in the record. If the determination result at A-3 is true, L (N) and L (N + 1) are defined as two-byte fields (A-4).
While the determination results of A-2 and A-3 continue to be true, the number of bytes is set to twice the number of determinations when the field length of the 2-byte system is A-3.

If the determination result of any of A-2 and A-3 is false, a determination is made as a 1-byte system (A-
5). The one-byte system is determined based on whether or not the corresponding byte is in the range of ANK. If true, it is defined as a 1-byte field (A-6). The length of the 1-byte field is the same as the number of times that the determination of A-4 is true. However, the number of times during which the next byte is false in the determination of A-2 and A-3 and is true in the determination of A-5. A
If the determination of -5 is false, it is defined as a hexadecimal field (A-7).

When the evaluation of one byte is completed, the relative position is increased to scan the next byte (one byte system, one byte system,
In the hexadecimal field, it is incremented by 1, and in the 2-byte field, it is incremented by 2) (A-8). The end of the record is determined by whether the relative position has exceeded the record length (A-1). If true, the analysis for one record ends.

FIG. 3 is a flowchart for explaining the function of the record layout verification processing. First, in order to automatically analyze the record layout, the record reading unit 5
The record is read (B-1). The number of records to be scanned is determined in advance, and it is determined whether the number does not exceed the number (B-2). The read record is sent to the record layout automatic analysis unit 1 by the record content verification unit 2 (B-3). The record layout automatic analysis unit 1 analyzes the field attributes for records. When the automatic analysis of the record layout of the planned number of scans is completed, the record content verification unit 2 determines a field attribute common to the records by majority vote within the number of scan records (B-5). The record definition unit 4 stores the determined field attribute as a final record layout element (B-6).
The record content verification unit 2 changes the position of the field (item position) to determine the next field attribute (B-
7), it is determined whether it is the last field (B-4).
If it is not the last field, the processing of B-6 and B-7 is repeated. After determining the last field attribute, the record definition unit 4 determines the final record layout (B-8).

FIG. 4 is a diagram for explaining the function of displaying the contents of a record and updating the record layout. The record content display unit 3 displays the record content as shown in FIG. 4 using the record layout automatically generated by the processing up to FIG. Display according to the attribute and display in hexadecimal are performed at C-2 in FIG.

After the display, the field length can be changed by moving the cursor C-1. The field length is displayed on C-3, and increases or decreases according to the amount of cursor movement. If the field length C-3 is changed,
The cursor moves automatically. Field length C-3 is set to 0
, The field definition is deleted, and a new field definition is inserted if the field length is divided by commas such as n and m. C-4 indicates the attribute of the field, and the field attribute can be changed. The record layout changed here is updated by the record layout updating unit 6.

A program for performing the operation of the embodiment including the flowcharts of FIGS. 2 and 3 described above may be recorded on a recording medium such as a floppy disk, and the program may be executed by an information processing apparatus.

Although the above embodiment is directed to a record, the present invention is not limited to this, and can also be applied to the content analysis of binary data repeated in a fixed layout. For this purpose, a mechanism for managing the binary data is provided instead of the record reading unit 5 in FIG. 1, and while changing the offset from the beginning of the binary data by the length corresponding to the record length, the mechanism for managing the binary data May be passed to the record verification unit 2.

[0022]

According to the present invention, by analyzing record contents in a file, it is possible to automatically generate a field definition of a record and display the actual record contents using the generated record layout. In addition, since the record layout can be easily reviewed and changed in the displayed state, the work for obtaining the record layout can be efficiently performed.

[Brief description of the drawings]

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

FIG. 2 is a flowchart for automatically generating a record layout according to the embodiment shown in FIG. 1;

FIG. 3 is a flowchart of a record layout verification process according to the embodiment shown in FIG. 1;

FIG. 4 is a diagram for explaining display of record contents and updating of a record layout according to the embodiment shown in FIG. 1;

[Explanation of symbols]

 1 Record layout automatic analysis unit 2 Record content verification unit 3 Record content display unit 4 Record definition unit 5 Record reading unit 6 Record layout update unit

Claims (7)

[Claims] 1. A layout automatic generation unit for reading and analyzing data whose layout is unknown and generating the layout, a layout display unit for displaying data contents according to the generated layout, and reviewing the layout based on the display. And a layout updating unit for generating a data layout. 2. A data layout generating / updating method for reading and analyzing data whose layout is unknown, generating the layout, displaying data contents in accordance with the generated layout, and providing the layout update. 3. A program recording medium on which a program for reading and analyzing data whose layout is unknown, generating the layout, displaying data contents along the generated layout, and updating the layout is recorded. 4. An information processing apparatus for executing the program according to claim 3. 5. The data layout generating / updating apparatus according to claim 1, wherein the generation of the layout is performed by determining a field attribute common to the data by a majority decision within the number of scan data. 6. The data layout generation / update method according to claim 2, wherein the generation of the layout is performed by determining a field attribute common to the data by majority decision within the number of scan data. 7. The program recording medium according to claim 3, wherein the generation of the layout is performed by determining a field attribute common to the data by majority decision within the number of scan data.