JPH06162117A - Register processing system for hierarchical structure data base - Google Patents

Abstract

PURPOSE:To improve the efficiency by increasing the processing speed of the registration of data in the data base in hierarchical structure of unspecified repetition. CONSTITUTION:An input data file analytic process part 4 inputs a data base definition information table 1, an input format description information table 2, and an input data file 3, inputs input data of the input data file 3 in order, and stores items in a memory in order to generate intermediate work data 5. Fixed items which are inputted later from the input data at the time of this generation are updated later by using a blank dummy as a record temporarily. The input data file analytic process part 4 while generating the intermediate work data 5 generates a work data record information table 6 having record information in the memory. A data base registering process part 7 registers the intermediate work data 5 in the data base 8 according to the work data record information table 6.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a hierarchical structure database registration processing method, and more particularly to a hierarchical structure database registration processing method for registering data in a hierarchical structure database having indefinite repetition.

[0002]

2. Description of the Related Art Conventionally, in this type of hierarchical structure database registration processing method, since the order of input data and the order of registration in the database differ depending on the hierarchical structure having indefinite repetition, it is temporarily re-edited in an intermediate work file. Registered in the database since then.

[0003]

In the conventional hierarchical structure database registration processing method described above, when the registration amount is large, editing cannot be performed on the memory device because of the capacity.
Since the intermediate work file is used, there is a problem that the input / output of the file takes time and the processing efficiency does not increase.

[0004]

The hierarchical structure database registration processing method of the present invention is a hierarchical structure database registration processing method for registering data in a hierarchical structure database having indefinite repetition. Input the format description information of the input data that associates the database definition information with the input data, and the input data, determine the items specified by the database definition information for each record of the input data, and read them sequentially into the memory. For records whose reading order is different from the registration order in the database, a dummy record is tentatively read, the dummy record is updated by reading a later record to create intermediate work data, and the intermediate work data created on this memory is also deleted. Input data file analysis processing means for creating record information and this input Constructed by having a database registration processing means for registering in the database in accordance with the record information over datafile analysis means it is also create intermediate work data created.

[0005]

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

FIG. 1 is a block diagram of an embodiment of the present invention.
The embodiment shown in FIG. 1 has a database definition information table 1, an input format description information table 2, and an input data file 3.
An input data file analysis processing unit 4 for receiving input from
The input data file analysis processing unit 4 comprises a database registration processing unit 7 for inputting the intermediate work data 5 on the memory device and the work data record information table 6 and performing a registration process in the database 8.

The database definition information table 1 is a table in which database definition structure information is registered when the system is created. FIG. 2 is a diagram showing an example of the database definition structure information, which is usually defined by definition items, item attributes, and item types. The item attribute is “CHAR in the example of FIG.
It is indicated by "ACTER" and "NIPPONGO", the former is a 1-byte alphanumeric character and the Kana character, the latter is a 2-byte Japanese character, and the fixed-length item having that length is indicated by the number in parentheses. The variable length item is indicated by "V" in the parentheses, and a simple "(V)" indicates a repeating group item.The item type is "KEY" or "PKEY" in the example of FIG. , And “TEXT”, the former is a key item or a primary key item to be searched, and the latter is a text item that handles document data. Is a 1-byte alphanumeric / kana primary key item with a length of 10 bytes.

The input format description information table 2 is a table of the input format description information for the data input when the data is input to the input data file 3. Figure 3
Is a diagram showing an example of input format description information, showing the data identification number, definition item, the first column of data, and the length of the data, and shows the maximum length of the data for the variable length item. .

The input data file 3 is a file that stores input data. FIG. 4 is a diagram showing an example of input data on the input data file 3, which is created and stored according to the input format description information of the input format description information table 2.
The input data shown in FIG. 4 is created in accordance with the input format description information shown in FIG.

FIGS. 5 and 6 show a work data record information table 6 and an intermediate work which the input data file analysis processing unit 4 outputs on the memory device when the information shown in each example of FIGS. 2, 3 and 4 is input. FIG. 6A to FIG. 6F are diagrams showing an example of the contents of the data 5, and show the state in which the contents of the intermediate work data 5 are changed by the processing of the input data file analysis processing unit 4. The procedure of the processing of the input data file analysis processing unit 4 will be described below with reference to FIGS.

FIG. 6A shows the database definition information 02.
Creates a fixed-length item level record, PK
"B91093001" is output as the EY item, and a blank of 10 bytes in length is dummy output as the fixed item A that should appear in the subsequent line. Then, as shown in FIG. 5, the buffer number, the record number, the record position, the record length, and the record existence flag are output to the work data record information table 6. The buffer number is the number of sheets of the buffer memory that stores the intermediate work data 5, and has, for example, four buffer memories and is used in order from 1 to 4. "1" is output as the buffer number. The record number is the record number in one buffer memory. "1" is also output to the record number. The record position is a relative position from the beginning in the buffer memory. "1" is also output to the record position. The record length is the length of the entire record. "20" is output including the dummy length in the record length. The record existence flag outputs "1" when the record is output. Next, in FIG.
A variable item record of a level is created, and the variable item length A is output as "a database is a set of data and anyone can easily retrieve necessary information.""1","2","21","76", and "1" are output to the work data record information table 6, respectively. Next, FIG. 6 (c) creates a record of a fixed length item of the 03 level under the repeated group item of the 02 level, and as a fixed length item B which should appear in a subsequent line,
Dummy output of 10-byte blank. The work data record information table 6 contains "1", "3", and "9", respectively.
7 ”,“ 10 ”, and“ 1 ”are output.
(D) is to create a record of variable items at 03 level under the repeated group item at 02 level. As variable items, "relational type database expresses related data as they are in" table form ". Information can be simplified. Is output. Work data record information table 6
Are "1", "4", "107", and "9", respectively.
6 ”and“ 1 ”are output. Next, in FIG.
This is to update the record of the fixed length item of level 03 under the repeated group item of level, and to output "RELATENAL" as the fixed length item B. Next in FIG.
(F) is for updating the record of the fixed-length item at the 02 level, and updates and outputs "DB" as the fixed-length item A.

The database registration processing unit 7 sequentially inputs the intermediate work data 5 and the work data record information table 6 created by the above processing procedure and registers them in the database 8.

In the above example, the repeat group item 03
There is one level variable item B, but if there are multiple items,
The variable item B is repeated after the fixed item B on the intermediate work data 5, and a record is added to the work data record information table 6.

[0014]

As described above, the present invention is a process of registering data in a database having indefinite repetition or having a hierarchical structure, in which records of input data are sequentially read in the buffer memory and are output from the subsequent lines. Fixed-length items are temporarily created as blank dummy intermediate work data, and by having separate record information of the intermediate work data, the intermediate work data is compressed and the intermediate work data using a file becomes unnecessary. Therefore, there is an effect that the registration process can be speeded up.

[Brief description of drawings]

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

FIG. 2 is a diagram showing an example of contents of a database definition information table of the embodiment shown in FIG.

FIG. 3 is a diagram showing an example of contents of an input format description information table of the embodiment of FIG.

FIG. 4 is a diagram showing an example of contents of an input data file of the embodiment shown in FIG.

FIG. 5 is a diagram showing an example of contents of a work data record information table of the embodiment of FIG.

FIG. 6 is a diagram showing an example of contents of intermediate work data sequentially created by an input data file analysis processing unit of the embodiment of FIG.

[Explanation of symbols]

 1 database definition information table 2 input format description information table 3 input data file 4 input data file analysis processing unit 5 intermediate work data 6 work data record information table 7 database registration processing unit 8 database

Claims (1)

[Claims] 1. In a hierarchical structure database registration processing method for registering data in a hierarchical database having indefinite repetition, definition information of the database and format description information of input data for associating the database definition information with the input data. , And input data, the items specified in the database definition information are determined for each record of the input data, and the items are read sequentially into the memory. The records whose reading order differs from the registration order in the database are provisional. Input data file analysis processing means for reading the dummy record, updating the dummy record by reading the subsequent record to create intermediate work data, and creating record information of the intermediate work data created on this memory,
And a database registration processing means for registering the intermediate work data created by the input data file analysis processing means in the database in accordance with the similarly created record information.