JPH0362241A - Generation system for table name train data - Google Patents

Abstract

PURPOSE:To designate a table name into the conditions by producing a record having a table name as the data with a table name train data generation command. CONSTITUTION:A directory information updating means 16 inputs the directory information on a subject table via a directory information storage means 14 based on the subject table identification information received from a command analyzing means 12. Then the means 16 updates the directory information on the subject table stored in the means 14. At the same time, a record updating means 17 extracts the record of the subject table stored in a record storage means 13 based on the subject table identification information received from the means 12 and adds the table name train data extracted by a table name extracting means 15 to each extracted record to update the record stored in the means 13. As a result, the conditions similar to other items of the subject table can be designated to the table name train of the records.

Description

[Detailed description of the invention]

[Industrial Application Field] The present invention relates to a method for adding new items (fields) and data to all records in a table that is a collection of records in the same format, and particularly relates to a method for adding new items (fields) and data to all records in a table that is a collection of records in the same format. This paper relates to a table name column data generation method that inserts data into each record as data. [Prior Art] Conventionally, a table name representing a collection of records in the same format did not exist in the record itself, and if the table name was inserted into the record as new item (column) data, teeth,
Users can define directory information about items,
I had to enter table names one by one as column data. [Problem to be Solved by the Invention] In the conventional technology described above, the table name did not exist in the record, so unless the table name was explicitly inserted into the record as column data, records of multiple tables could be The disadvantages are that when the records are combined into one table, it becomes difficult to tell which records come from which table, and it becomes impossible to specify the table name as a condition. Furthermore, when explicitly inserting a table name into a record as column data, the directory information and column data of the table name column to be inserted must be explicitly specified, which is a disadvantage in that it is time consuming. In view of the above points, an object of the present invention is to add directory information of a new column that holds the table name as column data to the directory information of the table when a table name column data generation command is input. By inserting it into each record in the table, when records from multiple tables are combined into the same table after table name column data is generated, it is possible to identify which table each record was retrieved from. The object of the present invention is to provide a table name column data generation method that allows the same conditions as for other items in a table to be specified for the table name column of a record. [Means for Solving the Problems] The table name column data generation method of the present invention includes an input means for inputting a command, and a command input from the input means is analyzed to generate new column data using the table name as data. A command analysis means for identifying a table name column data generation command to be generated, a record storage means for storing records in a fixed format as one table, and a directory for the entire table and each item of the record stored in this record storage means. a directory information storage means for storing information, a table name extraction means for extracting directory information of the entire target table from the directory information storage means based on the target table identification information input from the command analysis means, and the command analysis means. The target table identification information input from the means is inputted into the directory information of the target table from the directory information storage means, and the directory information of the table name column is added to the target table recorded in the directory storage means. Directory information updating means for updating directory information; extracting records of the target table stored in the record storage means based on the target table identification information input from the command analysis means; and assigning the table name to each extracted record. and record updating means for updating the record stored in the record storage means by adding the table name column data extracted by the extraction means.

[Effect]

In the table name column data generation method of the present invention, the input means inputs a command, and the command analysis means analyzes the command input from the input means to generate new column data using the table name as data. A generation command is identified, the record storage means stores records in a fixed format as one table, the directory information storage means stores directory information of the entire table stored in the record storage means and each item of the record, The name extraction means retrieves the directory information of the entire target table from the directory information storage means based on the target table identification information input from the command analysis means, and the directory information update means extracts the directory information of the entire target table from the directory information storage means based on the target table identification information input from the command analysis means. The record updating means inputs the directory information of the target table from the directory information storage means and adds the directory information of the table name column to update the directory 1#1 information of the target table stored in the directory storage means. Based on the target table identification information input from the command analysis means, records of the target table stored in the record storage means are extracted, and table name column data extracted by the table name extraction means is added to each extracted record. Update record F stored in record storage means. [Example] Next, the present invention will be described in detail with reference to the drawings. FIG. 1 is a diagram showing the fit of a table name column data generation method according to an embodiment of the present invention. The table name column data generation method of this embodiment includes an input means 11, a command analysis means 12, a record storage means 13, a directory information storage means 14, a table name extraction means 15, a directory information update means 16, It is composed of record updating means 17. The input means 11 is means for inputting commands for performing operations regarding table data and directories. The command analysis means 12 is a means for analyzing a command input from the input means 11 and outputting target table identification information to a means that performs a designated function. Referring to FIG. 2, when a table name column data generation command is input, the processing of the command analysis means 12 includes a command analysis step 201, a table name column data generation command judgment step 202, and a process to the table name extraction means. It consists of a step 203 for outputting target table identification information, a step 204 for outputting target table identification information to the directory information updating means, and a step 205 for outputting target table identification information to the record updating means. The record storage means 13 is means for holding records to be searched, updated, etc. The directory 18 information storage means 14 is means for holding directory information related to each item of the record stored in the record storage means 13 and the entire table. The table name extraction means 15 is called when the command analysis means 12 identifies a table name string data generation command, and is means for extracting directory information regarding the entire target table from the directory information storage means 14. Referring to FIG. 3, the processing in the table name extraction means 15 includes a step 301 of inputting target table identification information from the command analysis means, a step 302 of inputting directory information of the entire target table from the directory information storage means, and a step 302 of inputting directory information of the entire target table from the directory information storage means. Step 303 of outputting directory information of the entire table to the record updating means
It consists of. The directory information update means 16 is the command analysis means 1
input the target table identification information from 2, add a new column of directory information as the last column of directory information to the directory information stored in the directory information storage means 14 based on the input target table identification information, This is means for updating the directory information stored in the directory information storage means 14 with added directory information. Referring to FIG. 4, the process in the directory information updating means 16 includes a step 401 for inputting target table identification information from the command analysis means, a step 402 for inputting target table directory information from the directory information storage means, and a step 402 for inputting table name information from the directory information storage means. Column addition directory information creation step 403 and directory information update step 40 of directory information storage means
It consists of 4. The record update means 17 adds the table name as the last item to all records of the target table stored in the record storage means 13 based on the table name extracted by the table name extraction means 15, and This is means for updating the record in the record storage means 13 with the added record. Referring to FIG. 5, the process in the record update means 17 includes a step 50 of inputting target table identification information from the command analysis means.
1, step 502 of inputting target table directory information from table name extraction means, step 503 of inputting target table record from record storage means, step 504 of determining end of target table record, and step 505 of adding record of table name column data. and record update step 5 of the record storage means.
It consists of 06. Next, the operation of the table name column data generation method of this embodiment configured as described above will be explained. When a command is input from the input means 11, the command analysis means 12 analyzes the command input from the input means 11 (step 201), determines whether it is a table name column data generation command (step 202), and If the command is not a name column data generation command, the process is terminated, and if it is a table name column data generation command, the target table identification information is output to the table name extraction means 15 (step 203), and the target table identification information is output to the directory information update means 16. Output step 204
), the target table identification information is output to the record updating means 17 (step 205), and the process ends. The table name extraction means 15 inputs the target table identification information from the command analysis means 12 (step 301), inputs the directory information of the entire table of the target table from the directory information storage means 14 (step 302), and inputs the directory information of the entire table of the target table (step 302). The directory information is output to the record updating means 17 (step 303), and the process ends. The directory information update means 16 is the command analysis means 1
Step 401) to input the target table identification information from 2), step 402) to input the directory information of the target table from the directory information storage means 14, and new directory information in which the directory information in the table name column is added as the directory information in the last column. Step 403), the directory information storage means 1 is created using the created directory information.
The directory information stored in step 404 is updated (step 404), and the process ends. The record updating means 17 inputs the target table identification information from the command analysis means 12 (step 501), inputs the directory information of the entire table of the target table from the table name extraction means 15 (step 502), and inputs the target table from the record storage means 13 (step 502). Step 503) to input the record of the target table, and determine whether or not the record of the target table has ended.Step 504), if the record has ended, the process ends; Add the table name to the record as table name column data of the last item of the record (step 505), update the record stored in the record storage means 13 with the record after adding the table name column data (step 506), I11 in step 503
return control. Next, the operation of the table name column data generation method of this embodiment will be explained in more detail with reference to FIGS. 6 to 11. Here, for example, the input means 11 is a keyboard, the command analysis means 12 is a computer program, the record storage means 13 and the directory information storage means 14 are a relational database management system using magnetic disks, the table name extraction means 15. It is possible to assume that the directory information updating means 16 and the record updating means 17 are all computer programs. When a table name column data generation command is input through the input means 11 for a table as shown in FIG. Table name extraction means 15. using as target table identification information. The information is output to the directory information storage means 16 and the record updating means 17. The table name extraction means 15 extracts the directory information of the entire table as shown in FIG. 8 from the directory information as shown in FIG. Output to. The directory information update means 16 is the command analysis means 1
Based on the table name "Tokyo residents" input from step 2, directory information is searched from the directory information storage means 14, and the fourth column of directory information (column definition information) is created as shown in FIG. Then, the item names of the entire table are changed to the column names of the fourth column, and the directory information stored in the directory information storage means 14 is updated. The record updating means 17 retrieves the record of the target table from the record storage means 13 based on the table name "Tokyo residents" inputted from the command analysis means 12, and stores the data "Tokyo residents" as the fourth column data. is inserted for all records, and a new table as shown in FIG. 10 is created. Even if the new table created in this way and another table obtained by another table name column data generation command are combined into one table as shown in Figure 11, each record will have table name column data. is inserted, so you can identify which records come from which tables. [Effects of the Invention] As explained above, the present invention allows the user to explicitly write the table name into the record as column data by generating a record with the table name as data using the table name column data generation command. When records from multiple tables are combined into one table, you can identify which table each record comes from just by entering a command, without having to go through the trouble of inserting records into a condition. This has the effect of making it possible to specify a name.

[Brief explanation of drawings]

FIG. 1 is a block diagram showing the configuration of a table name column data generation method according to an embodiment of the present invention, and FIG. 2 shows the processing when a table name column data generation command is input to the command analysis means in FIG. The flowchart shown in Figure 3 is
4 is a flowchart showing the processing of the table name extraction means in FIG. 1; FIG. 5 is a flowchart showing the processing of the record updating means in FIG. 1; Figure 6 is a diagram showing an example of a table for which table name column data is generated. Figure 7 is a diagram showing an example of directory information for the table shown in Figure 6. Figure 8 is a diagram showing an example of directory information for the table shown in Figure 7. A diagram showing an example of the directory information of the entire table extracted from the directory information by the table name extraction means in FIG. 1.
A diagram showing an example of directory information in which the directory information in the table name column is added to the end by the directory information updating means in the diagram. Figure 1O is the record updating means in Figure 1 for the table shown in Figure 6 Figure 11 is an example of a table in which the table shown in Figure 10 and a table created in the same way as Figure 10 are combined into one table with table name column data added to the end by FIG. In the figure, 11... Input means, 12... Command analysis means, 13... Record storage means, 14... Directory information storage means, 15... Table name extraction means, 16... Directory information Update means, 17: record update means.

Claims (1)

[Scope of Claims] An input means for inputting a command, and a command analysis means for identifying a table name column data generation command for analyzing the command input from the input means and generating new column data using the table name as data. a record storage means for storing records in a fixed format as one table; a directory information storage means for storing directory information of the entire table and each item of the record stored in the record storage means; and the command analysis means. table name extraction means for extracting the directory information of the entire target table from the directory information storage means based on the target table identification information input from the command analysis means; Directory information updating means inputting directory information of the target table from the information storage means and adding directory information of a table name column to update the directory information of the target table stored in the directory storage means; and from the command analysis means. Based on the input target table identification information, records of the target table stored in the record storage means are extracted, table name column data extracted by the table name extraction means is added to each extracted record, and the table name column data extracted by the table name extraction means is added to the extracted records. 1. A table name column data generation method comprising: record updating means for updating records stored in storage means.