JPH05100922A - Converting system for symbolic link format file into relational data base table format - Google Patents

Abstract

PURPOSE:To automatically determine a data row and an item name row by setting the uppermost row in which attributes of a row of a memory table and each item coincide with each other as a data start row, and setting the upper row in which two kinds or more of characters exist as the item name row. CONSTITUTION:A file conversion/transfer program 1 on a terminal computer reads a symbolic link file 3 by a file input part 11, and places and stores it in a row and a column in a memory table by a memory table expanding part 12. An attribute determining part 13 determines the attribute concerned from attributes in each item in the column. A data start row determining part 14 sets the uppermost row in which the attribute of the column and the attributes of each item coincide with each other as a data start row. An item name row determining part 15 returns to the upper row by one row each from the data start row, and sets the row in which two kinds or more of characters except a null character exist as an item name row. A data transfer part 17 transfers a directory consisting of the attribute of the row and the item name row, and a data part of the row being under the data start row to a data base store program 5 on a host computer.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a method for converting a symbolic link format file, which is a de facto standard as a data exchange file format between application programs on a terminal, into a relational database file on a host computer by MML software.

[0002]

2. Description of the Related Art A symbolic link file has no identifier for distinguishing a data part and an item name part. When converting such a symbolic link file into a table of a relational database having a distinction between the data part and the item name part, the first line in the symbolic link file is the item name line and the second line is the data start line. The information was created and converted within a predetermined frame.

[0003]

In the conventional data conversion method as described above, the user must always execute the conversion so that the line in the symbolic link file is the item name line and the data starts from the line. It is necessary to specify it, and there is a drawback that the operability of the system is poor.

Further, if the first line is unconditionally used as data from the item name line and the second line, there is a drawback that the degree of freedom of the symbolic link file is lost.

[0005]

The present invention inputs a symbolic link format file on a terminal in a system for converting a symbolic link format file existing on a terminal computer into a relational database table format on a host computer. Means, means for storing and storing the input symbolic link format file information in a memory table, means for determining the attribute of the column from the attributes of each item in the column in the memory table, and the memory table A means for setting the highest row among the rows in which the determined column attribute and the attribute of each item match as a data start row, and returning to the row one row above the data start row in the memory table A means for setting a line having two or more types of characters excluding white space as an item name line, an attribute of the column, and the item It is characterized in that a data section of a directory consisting of each item of a name row and a row in which an attribute of each column below the data start row of the memory table and an attribute of each item match is sent to a database storage program on a host computer. .

[0006]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, the present invention will be described with reference to the drawings.

FIG. 1 is a system configuration diagram of an embodiment of the present invention, FIG. 2 is a storage example of a storage table of symbolic link file information, and FIGS. 3 and 4 are flowcharts of this embodiment.

In this embodiment, as shown in FIG. 1, the file conversion / transfer program 1 provided on the terminal has a file input unit 11, a memory table expansion unit 12, an attribute determination unit 13, a data start line determination unit 14, and an item name. It has a row determining unit 15, a data converting unit 16, and a data transferring unit 17, and further has a database storing program 2 on the host, a symbolic link file 3 on the terminal, and a database 4 on the host.

First, the file conversion transfer program 1 on the terminal transfers the symbolic link file 3 to the file input section 1
1, read the data item information of the symbolic link file while reading sequentially,
Decompose into storage location of column and data item. Then, the memory table expansion unit 12 arranges and stores in a matrix in the memory table.

The storage table 2 of the symbolic link file 3 illustrated in FIG. 2 will be described in detail below.
The storage table 2 has data items 21 arranged and stored in a matrix. Further, the stored data attribute section 22 is provided by allocating the first 1 byte of each data item 21. The stored data attribute section 22 stores the attribute section of the data item. It is possible to determine whether the value is a numerical value or a value other than the numerical value based on the information in the symbolic file. If the value is other than a numeric value, the internal code of the stored data item is identified to distinguish between the Kanji attribute and the alphanumeric character attribute. Therefore, the stored data attribute portion 22 stores three pieces of information, an alphanumeric character attribute (A), a kanji character attribute (K), and a numerical value attribute (N).

Next, the stored table is used as the attribute determining unit 13
Reads the stored data attribute section 22 sequentially from the top in the vertical direction in column 1, and classifies the contents of the stored data attribute section 22. The attribute with the largest number among them is determined as the attribute of column 1. Then again, the process proceeds to the determination process of the attribute in the column 2 on the right. In this way, the attributes of all columns are determined. Here, the conversion attribute of the directory of the table on the host is automatically determined.

Next, the data start row determining section 14 compares the stored data attribute section 22 of row 1 from the left to see whether the attribute determined by the attribute determining section 13 matches the stored data attribute section 22. If there is an item attribute that does not match here, proceed to the next line. If all the attributes in the line match, this line is determined as the data start line. Here, the data 21 stored below the data start line
Is to be transferred to the relational database 4 on the host.

Next, the item name line determination unit 15 returns to the line immediately before the data start line to determine the item name line. Then, the stored data attribute portion 22 is sequentially determined from the left column to determine whether the row does not include a numerical attribute. If there is a numeric attribute here, move to the previous row.
If there is a numeric attribute even if you return to the first line,
This symbolic file is regarded as having no item heading, and is transferred to the relational database 4 on the host as a table having no item heading. In the case of a line that does not include a numerical attribute, the character code of the stored data item 21 is determined whether or not there are two or more types of characters in this line, excluding blank characters. This is because software that handles symbolic files may store a delimiter line (-) or one blank line on the display. Therefore, a line in which all the attributes in the line are Kanji or alphanumeric characters and two or more types of character codes are determined as the item name line.

Next, the data conversion unit 16 creates a table directory so that it can be converted into a table on the host. A directory consists of attributes of each column of the table and item names of each column.

Next, the data transfer unit 17 transfers the directory information to the database storage program 5 on the host,
Then, the data part is transferred. The data section sequentially transfers the rows determined by the data start row determining section 14 to the lower rows one by one. At this time, the lines to be actually transferred to the host are only the lines in which the attributes of the directory determined by the attribute determining unit 13 and the stored data attribute unit 22 all match.

The database storage program 5 receives the data from the file conversion transfer program 1 on the terminal,
A directory part and a data part are stored as table data in the on-host database 4.

Next, referring to the flow charts of FIGS. 3 and 4, the storage data item of the storage table of FIG. 2 will be described as an example.

Assuming that the most attribute in each item is a column attribute, column 1 is alphanumeric characters, column 2 is alphanumeric characters, and column 3 is a numerical value.

Next, the row designation number (L) and the column designation number (c) are set to an initial value 0 in order to obtain the data start row. These numbers correspond to the matrix of the storage table. Then, when it is determined whether each column (c) in the row (L) matches the column attribute, the data start row (d) becomes 4. That is, it is determined that the data of this symbolic file starts from the 4th line.

Next, the value of the data start row (d) is subtracted by 1,
No numeric attributes in the line, not all blanks,
And that there are two or more types of characters. Here, in line (L), in line 3, there is no numerical attribute, but since there is only one type of character (-) in the line, (L) is further decremented by 1 and the process moves to the previous line 2. Line 2 is a line with all Chinese characters, but there are two or more types of stored codes. Therefore, the line in which (L) is 2, that is, the second line is determined as the item name line.

[0021]

As described above, the present invention has an effect that data lines and item name lines can be automatically determined and a symbolic link file can be converted into a relational database without bothering the user.

[Brief description of drawings]

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

FIG. 2 is a diagram showing a storage example of an information storage table of a symbolic link file 3 in FIG.

3 is a flow chart of a file conversion transfer program in FIG.

FIG. 4 is a flowchart of the file conversion transfer program in FIG.

[Explanation of symbols]

 1 File conversion transfer program 11 File input unit 12 Memory table expansion unit 13 Attribute determination unit 14 Data start line determination unit 15 Item name line determination unit 16 Data conversion unit 17 Data transfer unit 3 Symbolic link file 4 Relational database 5 Database storage program

Claims (1)

[Claims] 1. A method for converting a symbolic link format file existing on a terminal computer into a table format of a relational database on a host computer, means for inputting the symbolic link format file on the terminal, and the inputted symbolic Means for storing and storing the link format file information on the memory table,
Means for determining the attribute of the column from the attribute of each item in the column in the memory table, and data of the highest row of the rows in which the attribute of the determined column of the memory table and the attribute of each item match A means for defining a start row, a means for returning to the row one row above the data start row in the memory table, a means for defining a row in which two or more kinds of characters are present in the row excluding blank characters as an item name row, The data part of the row in which the attributes of the column and the attributes of each item below the data start row of the memory table match the attributes of the column and each item of the item name row to the database storage program on the host computer A method of converting a symbolic link format file into a relational database table format characterized by sending.