JPH10222406A - Record extracting device and recording medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To easily extract a record desirable for a user out of plural records divided by plural hierarchies at high speed. SOLUTION: When a record at low-order level is to be extracted while designating any arbitrary record at desired level, a CPU classifies the respective records at plural hierarchical levels for each level, acquires the detailed number of records added to the relevant designated record and the detailed number of records added to the record next to the relevant designated record from a control table adding the detailed number of records at the next low-order level to be extracted concerning the relevant record for each record classified for each level (steps S52 and S54), retrieves the records at the low-order level within these ranges (steps S58 and S66) and outputs them (step S64).

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a record extracting apparatus for extracting records when a record divided into a plurality of hierarchies is output on a form, and an instruction for causing a computer to execute such record extracting processing. The present invention relates to a computer-readable recording medium storing a program.

[0002]

2. Description of the Related Art Conventionally, a data record is created from a data file generated and stored by a data processing device or the like in accordance with format information for each predefined record.
2. Description of the Related Art A form output device configured to sequentially output, for example, print out each record is known.

[0003] In such a form output device, when a record divided into a plurality of hierarchies is output as a form, a form in which the subordinate relation of each hierarchy can be immediately output can be output immediately.
On the premise of this, records of each hierarchy are mixed and sorted and stored.

[0004]

Such storage is good when outputting a form in the above format, but a certain level, a certain record of a certain section is designated, and all the records of the same section at the lower level are specified. If you want to extract it and make it an output target, there is no control over the record or where it is stored, so it is necessary to search and extract all records as search targets at the specified stage. And the processing is complicated.

Similarly, when a certain level is specified and only records of the same level are to be output, it is necessary to search and extract all records at the specified stage as search targets. The processing was complicated. An object of the present invention is to enable a user to easily and quickly extract a desired record from a plurality of records divided in a plurality of hierarchies.

[0006]

The means of the present invention are as follows. The control table storage unit classifies the records of the plurality of hierarchical levels for each level, and adds, for each record classified for each level, address information of a specific record at the next lower level to be extracted for the record. The stored control table is stored. The record extraction means refers to the control table stored in the control table storage means when an arbitrary record of a desired level is specified, and stores address information of a specific record of the next lower level added to the specified record. The range of the next lower level record to be extracted is specified based on the address information of the next lower level specific record added to the next record of the specified record, and the records in that range are extracted.

The operation of the means of the present invention is as follows. When an arbitrary record at a desired level is designated and a record at a lower level is extracted, the record extracting means classifies the records at a plurality of hierarchical levels stored in the control table storage means for each level, and For each record classified for each record, refer to the control table to which the address information of the specific record of the next lower level to be extracted for the record is added, and check the specific record of the next lower level added to the specified record. Based on the address information and the address information of the next lower level specific record added to the next record of the specified record, the range of the next lower level record to be extracted is specified, and the records in that range are extracted. . Therefore, it is possible to easily and quickly extract a record desired by the user from a plurality of records divided in a plurality of hierarchies.

[0008]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS A record extracting apparatus according to one embodiment of the present invention will be described below with reference to FIGS. FIG. 1A is a diagram showing a configuration of a computer system to which a record extraction device according to an embodiment of the present invention is applied. In FIG. 1, reference numeral 10 denotes a CPU that controls the entire record extraction device. . Reference numeral 12 denotes an input device such as a keyboard and a mouse, and 14 denotes a display device such as a CRT.
Reference numeral 6 denotes a printing device such as a page printer. Reference numeral 18 denotes an operating system (OS), input control, file control, data record creation processing control, data display control, programs for creating a control table as described in detail below, created record files and control tables, and the like. Storage device such as a hard disk for storing the information of Reference numeral 20 denotes a RAM that is used as a work memory when the CPU 10 executes the program stored in the storage device 18, and stores the program, data records, and other information.

The programs and data stored in the storage device 18 may be stored in advance, or may be supplied via a portable storage medium 22 such as a floppy disk or an optical (magnetic) disk or a communication line 24. Alternatively, the information may be stored in the storage device 18. Alternatively, in addition to the program stored in the storage device 18, the CPU 1
0 is a program for directly storing a program stored in the portable storage medium 22 or a program given through the communication line 24 in the RAM.
20 and can be executed.

FIG. 2 is a diagram showing a sales file as an example of a record file stored in the storage device 18. As shown in FIG. This sales file contains "code", "name",
"Segment", "Sales amount", "Gross margin amount", "Gross margin ratio"
It consists of fields such as “Days of turnover”, “Level”, “Dependency” and so on. Here, the “level” field indicates the level of details, with “0” being the highest level, and the level increases as the number increases. That is, the “section” is “1”
In other words, it indicates that the description one row below “first half” is “product A”, “product B”, and “product C”. Further, the “dependent” field indicates which code part (the “code” and “name” fields) is dependent.

The record extracting apparatus according to the present embodiment designates an arbitrary record at a desired level and outputs a report as shown in FIG. When extracting records, instead of performing a process of searching for all records in the sales file and extracting desired records each time, first,
Create a control table from the sales file shown in FIG.
A desired record is immediately extracted by referring to the control table.

First, referring to the flowchart of FIG.
Processing for creating a control table as shown in FIG. 4 on the storage device 18 will be described. That is, the CPU 10 first retrieves one record from the record file stored in the storage device 18, in this embodiment, the sales file,
It is stored in the RAM 20 (step S10), and it is determined whether or not the content is an end of file (EOF) (step S12). If it is not EOF, the data of the record corresponds to the code part corresponding to the fields “code” and “name”, and the fields “sales amount”, “gross profit amount”, “gross profit rate”, and “number of days of receivable turnover” A record distribution process for distributing the data to the actual data part is performed (step S14). At this time, in addition to this, if the retrieved record is the first record, a process of creating an item name table and storing it in the storage device 18 is performed.

Next, the data of the field "section" in the record stored in the RAM 20 is taken out (step S16), and the contents of the section are selected (step S1).
8). Further, the level is selected based on the data of the field “level” (step S20), and the level m section n
Is selected (step S2).
2).

Here, if there is no change compared with the level at the time of processing the previous record (step S24), RA
The number of data of the level temporarily stored in M20 is incremented (step S26), and data is registered in the selected data management control table (step S26).
28), and return to step S10.

Therefore, when the process is performed on the first record of the sales file of FIG. 2, data is registered in the code part and the division 1 data part of the record of record number "0" of the level 0 data management control table. You. However, in this case, data is not yet registered in the “specification” field of the code part.

In the figure, for convenience of explanation, a code part,
Although the division 1 data section and the division 2 data section are drawn separately, these are a series of records. That is, each record of the level 0 data management control table includes “code”, “name”, “specification”, “sales amount (category 1)”, “gross profit amount (category 1)”, “gross profit rate (category 1)”. 1), "Days of credit turnover (Category 1)", "Sales amount (Category 2)", "Gross profit amount (Category 2)", "Gross profit rate (Category 2)", and "Days of credit turnover (Category 2)" ) "Field. This is the same in the level 1 data management control table.

Therefore, when the processing for the second record in the sales file of FIG. 2 is performed, data is registered in the section 2 data portion of the record with the record number “0” in the level 0 data management control table. In this case, the data number is not incremented in step S26.

If it is determined in step S24 that the level has been lowered (Down), the number of data items in the lower level is initialized (step S30).
The data is registered in the selected data management control table (step S28), and the process returns to step S10.

Therefore, for example, when the processing is performed on the third record of the sales file shown in FIG. 2, the level is lowered from "0" to "1". Initialized to “1”,
Record number "0" of level 1 data management control table
The data is registered in the code part and the division 1 data part of the record of.

If it is determined in step S24 that the level has been increased (Up), the number of data of this level is registered in the specification information of the upper level (step S32), and the selected data The data is registered in the management control table (step S28), and the process returns to step S10.

Therefore, for example, when the processing is performed on the seventh record of the sales file shown in FIG. 2, the level is increased from "1" to "0".
Number of data of level “1” temporarily stored in “2”
Is registered in the “specification” field of the code part of the level 0 data management control table.

Thereafter, such processing is repeated, and if it is determined in step S12 that EOF has occurred, the control table creation processing ends. As a result, FIG.
A control table as shown in FIG. In this embodiment, since there is only the level "1", the "specification" field of each record of the level 1 data management control table is "0".

FIG. 5 is a flowchart showing a lower level extraction process for immediately extracting a desired record by referring to this control table when an arbitrary record at a desired level is designated and a lower level record is extracted. It will be described according to.

That is, first, the specification range specified by the user is searched (step S40), the specification level m is obtained (step S42), and the specification level of the control table stored in the storage device 18 is obtained. The specification target is selected from the data management control table of m (step S4)
4). Then, one record is extracted from the data management control table at the specification level m (step S46), and the EOF is performed.
It is determined whether or not it is (step S48). If it is not EOF, it is determined whether or not the retrieved record is the specification target selected in step S44 (step S44).
50), otherwise return to step S46.

If the record is to be specified, the number x of detailed records is obtained from the "specification" field of the code part of the record (step S52). In addition, the number y of detailed records is obtained from the “detailed” field of the next record (step S54), and the number of main detailed records is calculated by (y−x) (step S56). Then, the x-th record is searched from the data management control table at the detail level m + 1 (step S58), and the number z of processed records is set to “0”.
(Step S60), and the number of records in the present specification y
Only when −x is greater than the number of processed records z (step S62), the x-th searched record is output (step S64). Then, after searching for the next record and incrementing the number z of records to be processed (step S66), the process returns to step S62. Then, when the number y-x of the present specification records becomes the same as the number z of processed records (step S62), the process returns to the step S46.

That is, for example, the number x of detail records in the record “0” of the level 0 data management control table is “1”, and the number y of detail records of the next record is “2”.
Therefore, the number of records (y−x) of the present specification is “2”. Therefore, in step S58, the section 1 data section and the section 2 data section of the record "0" of the level 1 data management control table are respectively searched, and step S64 is performed.
Is output respectively. Then, in step S66, the next record is searched and output again in step S64. Then, in step S66, the next record is further searched.
Since it is determined that −x and the number of processed records z are the same “2”, the searched record “2” is not output.

When the record “1” of the level 0 data management control table is taken out as the specification target, the number x of the detail records is “2”, and the number y of the detail records of the next record is also “2”. Therefore, the number of records (y−x) of the present specification is “0”. Therefore, step S5
In step S62, even if the division 1 data part and the division 2 data part of the record "2" of the level 1 data management control table are respectively searched, in step S62, the number of the detailed records yx and the processing record "2" with the same number z
Therefore, the retrieved record “2” is not output.

As described above, a plurality of records classified into a plurality of hierarchies are managed by a control table in which address information to the next lower level is added for each record classified for each level and for each record classified for each level. Therefore, when an arbitrary record at a desired level is designated and a record at a lower level is extracted, address information to the next lower level specified by the record and the address of the next record are referred to by referring to the control table. The range (start address, number of records) of the next lower level record to be extracted based on the information can be immediately specified.

In this embodiment, the case of two layers has been described as an example for the sake of simplicity. However, it is needless to say that the same processing can be performed in the case of more layers.
In addition, the present invention can be applied to any database and table data as long as the data is managed in a record configuration.

[0030]

According to the present invention, a record desired by a user can be easily and quickly extracted from a plurality of records divided in a plurality of hierarchies. That is, a plurality of records classified into a plurality of layers are managed by a control table in which address information to the next lower level is added for each record classified for each level and for each record classified for each level. When an arbitrary record is specified and a lower-level record is extracted, by referring to the control table, the extraction is performed based on the address information to the next lower level specified by the record and the address information of the next record. The range of the next lower level record (start address, number of records) to be specified can be immediately specified.

[Brief description of the drawings]

FIG. 1A is a block diagram of a computer system to which a record extraction device according to an embodiment of the present invention is applied, and FIG. 1B is a diagram showing an output example of a record form divided by hierarchy. is there.

FIG. 2 is a diagram showing the contents of a sales file as an example of a record file.

FIG. 3 is a flowchart of a control table creation process.

FIG. 4 is a diagram showing a configuration of a control table.

FIG. 5 is a flowchart of a lower level extraction process.

[Explanation of symbols]

 Reference Signs List 10 CPU 12 Input device 14 Display device 16 Printing device 18 Storage device 20 RAM 22 Storage medium 24 Communication line

Claims (3)

[Claims] 1. Classifying each record of a plurality of hierarchical levels for each level, and for each record classified for each level,
A control table storing means for storing a control table to which address information of a specific record of the next lower level to be extracted for the record is added; and a control table storing means for storing an arbitrary record of a desired level when the record is designated. With reference to the control table, based on the address information of the next lower-level specific record added to the specified record and the address information of the next lower-level specific record added to the next record of the specified record, A record extraction device, comprising: a record extraction unit for specifying a range of a record of a next lower level to be extracted and extracting records in the range. 2. The control table is created from a record file including a plurality of records including information indicating a hierarchy of the record, and the record file.
The record extracting apparatus according to claim 1, further comprising: a control table creating unit that stores the control table in the control table storage unit. 3. When designating an arbitrary record at a desired level and extracting a record at a lower level thereof, the records at a plurality of hierarchical levels are classified at each level, and each record classified at each level is classified at each level. Referring to the control table to which the address information of the next lower-level specific record to be extracted for the record is added, the address information of the next lower-level specific record added to the specified record, and the next Based on the address information of the specific record of the next lower level added to the record, a range of the next lower level record to be extracted is specified, and an instruction for causing the computer to execute a process of extracting the record of the range is included. Stored the program,
Computer-readable recording medium.