JP2718836B2 - Database system - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database system capable of easily registering data retrieval results of a relational database in a database file. Conventionally,
In a relational database system, if the results of statistical processing in a two-dimensional tabular database are re-edited into a different tabular format from that of the database from which the search was made (hereinafter referred to as the original data), The search results cannot be stored directly, and after calling the registration program to store the data in a format that matches the output format, the data of the search results must be re-arranged on the screen. Could not register.

[0002] Therefore, in order to register such a search result, conventionally, a complicated registration procedure was required, so that the search result was not registered. When the same search result was required, the same search processing was performed again. Was being done. SUMMARY OF THE INVENTION It is an object of the present invention to provide a database system that can easily register a search result in a relational database file in a format suitable for an output format.

[0003]

2. Description of the Related Art FIG. 9 shows a conventional database system. In the figure, reference numeral 81 denotes a search data creation unit which searches for data based on data on a database and search processing information defining search information. A search processing information storage unit 82 stores search processing information defining search information, and a database file 83 stores data to be a database. 8
Reference numeral 4 denotes a search result storage unit, which is a buffer memory for storing the search results created by the search data creation unit 81. Reference numeral 85 denotes a database management unit which manages database data and data input / output of the database file 83. 86 is an input / output device,
It comprises a keyboard, a display device, a printing device and the like. Reference numeral 87 denotes an output format setting unit for determining a format for outputting a search result or the like to a display device or a printing device, 88 denotes original data to be searched, and 89 denotes a registered search result. Reference numeral 90 denotes a search data registration unit for registering search results as a database.

The operation of the configuration shown in FIG. For example, when a list of product stocks at each sales office is to be created, a business office name, a product name such as a television or a radio, etc. is input from an input / output device as a key for defining search information. Then, the key is stored in the search processing information storage unit 82 as search processing information. On the other hand, from the database file 83, a record in which the product name and the stock quantity at each sales office are combined is input to the search data creation unit 81. The search data creation unit 81 selects a record that gives the stock quantity of the television and radio at the designated business office according to the key that defines the search information stored in the search processing information storage unit 82. The search results obtained in this way are stored in the search result storage unit 84, and the output format setting unit 87
Is output to a display device or a printing device in the output format designated by.

In a conventional relational database system, a two-dimensional tabular database is used.
Format different from the form of the original data as a total result of the statistical processing
The search results arranged in the formula cannot be registered directly, and the operator calls a program such as a table to register the search results once in that format, rearranges the search result data on the display screen, and reorganizes the program. Relational database
The registration process had to be performed using the registration function for the source .

FIG. 10 shows a flow of a search result registration process. The description will be made according to the numbered circles shown. Start search result storage processing. An operator calls a program that provides a data storage format. The operator arranges the search result data in a format to be registered on the display device according to the program. Enter a file name. Register search results. The registration processing ends.

[0007]

As described above, in a conventional relational database system, a search is not possible.
If the contents obtained by searching are statistically processed and output in a format different from the format of the original data, the search results cannot be directly registered in the database file, and the search results must be registered.
Call a table format program, etc.
In could not be registered only after an array of data of search results.

Conventionally, the registration procedure is complicated, so that the results of statistical processing are not registered, and the same search processing is performed again when the same search result is required. Therefore, it is difficult to register the obtained search result as a database and use it in other processes. According to the present invention, even when a search result is output in an output format different from the format of the original data,
An object of the present invention is to provide a database system that can be easily registered in a database file.

[0009]

SUMMARY OF THE INVENTION The present invention relates to a relationer.
Database file (3) that stores the
Search processing information storage unit (2) for storing search conditions, and search
Searches database files based on conditions and searches
Search data creation unit (1) for creating data, and the search data
And the format data required for the output format of the search results.
The search result storage section (4) to store
A database management unit (5) for management and input / output
In the database system, in the search result storage section (4)
Search data created by the stored search data creation section (1)
Search data and form data when the data is in a two-dimensional table format
Extract only search data from
A search data registration unit (10) for recording is provided .

FIG. 1 shows the basic configuration of the present invention. In the figure, 1 is a search data creation unit, 2 is a search processing information storage unit,
3 is a database file, 4 is a search result storage unit (intermediate file), 5 is a database management unit, 6 is an input / output device, 7 is an output format setting unit, 10 is a search data registration unit, 1
1 is original data which is data to be searched, and 12 is a registered search result. In the figure, the function of each unit is the same as that of the configuration in FIG. 9 except that the search data registration unit 10 performs the direct registration processing based on the data in the search result storage unit 4.

[0011]

FIG. 2 is a flow chart of a search result registration process in the basic configuration of the present invention. The description will be made according to the illustrated numbers. Refer to FIG. 1 as necessary. Start the registration process for the search result . Format data arranged according to the output format (format
Required data) and search data (data obtained by search)
Data) search results that include is given. Judge whether to register or not. If you want to register, go to. If not, proceed to. To register, the operator inputs the file name from the input device. Register if there is no registration file name input
Automatically generate file names. Since the search result storage unit (intermediate file) 4 to the stored data is also included formatted data necessary for the screen or printed out, only the data (search data) necessary to register as a database is It is extracted and registered on the database file in a format according to the output format. The registration processing ends.

According to the present invention, even when the data arrangement is changed in the relational database so that the retrieval results such as the statistical processing results in the table format are output in a format different from the original data format, the output format is displayed on the relational database. You can easily register in the format according to.

[0013]

An embodiment of the present invention will be described with reference to FIGS. FIG. 3 shows an example of a database search in the present invention. FIG. 1A shows an example of two-dimensional data to which the present invention is applied. It consists of records in which the sales office names, Shinjuku, Kawasaki, and Osaka, are combined with their respective TVs and radios as product names. Fig. (B) shows an example of editing the 2D data of Fig. (A) with the sales office name as the vertical key and the product name as the horizontal key, editing the output format as shown in the figure, and outputting it. . Figure (c) shows the search results obtained by two-dimensionally summing the two-dimensional data of Figure (a). Each data is arranged as shown in Fig. (C) so that the total data obtained by summarizing the vertical and horizontal keys in the two-dimensional data (a) is output in the format shown in Fig. (B). The control code in FIG. 3 (c) indicates the sum. Then, when registering the search results of FIG. 3C on the database file, only the items necessary for the database surrounded by the dotted line in the figure are registered in the arrangement shown.

FIG. 4 shows a flow of generating item information in the database of the present invention. The case of processing the two-dimensional data in FIG. 3A will be described as an example according to the numbers shown.

The records are sorted by the product name (television, radio) of the horizontal key. (As a result, for example, in the table, records having TV in the product name are collected in the upper part, and records having radio are collected in the lower part. The record item value is stored. For example, TV is set as the record item value. Reads the record Determines whether the data has been completed, if not, proceeds to the end, and if completed, ends the processing Determines whether the record value is the same as the previous time. If the record item value is radio, then the television is used to read the record item value. Since the reading of the record held as is completed, the radio is set as the next item value.

Thereafter, the above processes are repeated in the same manner. When reading of all records is completed, the process is terminated. From the illustrated flow, it can be read that there are two types of product items in the horizontal direction in the two-dimensional data of FIG.

FIG. 5 shows a flow of two-dimensional statistical processing in the database system of the present invention. The description will be made according to the illustrated numbers. (1) Sort records by vertical item value (business office name) and horizontal item value (product name). That is, according to the two-dimensional data of FIG. 3A, for example, records of the office name Shinjuku are collected at the top of the table, and records having TV, for example, of records having Shinjuku are collected at the top of the table. , to collect the records with the Shinjuku and radio to the next.
The same sort is performed for the branch offices Kawasaki and Osaka. (2) Set the vertical (business name) key. For example, a key is set for the office name Shinjuku. (3) It is determined whether or not the data has been completed. If the data has not been completed, the process proceeds to (4). If the data has been completed, the termination process is performed. (4) Set the horizontal key. For example, TV and radio are sequentially set.

(5) In the present embodiment, if the keys do not match, a flag is set and the temporary processing is stopped. Therefore, it is determined whether the keys match and the record needs to be read. If reading is necessary, proceed to (6). If there is no match and reading is not necessary, do not read the record (8).
Proceed to. (6) If the keys match and a record read is required, read the record. (7) After reading the record, perform a process of setting a flag indicating the need for reading required in the judgment of (3) (reading unnecessary in the figure indicates this). (8) Determine whether the vertical key is equal to the record value. If they are equal, go to (9); if not, go to (12). That is, since Shinjuku has been set as the vertical key, if the record is Shinjuku, go to (9). Otherwise, the reading of the vertical key record for Shinjuku has been completed. In step 12), the tabulation result is output to the intermediate file as a search result in the middle of the vertical key tabulation result, and the next vertical key is set. (9) If the horizontal key is equal to the record value, proceed to (10); otherwise, repeat the processing from (5). (10) If the horizontal key is a television, in (10), the accounting calculation is performed using a record having Shinjuku and television as item values. (11) At this point, the flag necessary for the judgment in (3) is set to a flag indicating that reading is not required. (4) The following processing is repeated. The above processing is repeated to obtain the two-dimensional total result shown in FIG.

FIGS. 6 to 8 show examples of output forms for database search in the embodiment of the present invention. FIG. 6 shows an example of a two-dimensional data output list . The database is searched for a sales office name, a product name, and a quantity .
An example of the result is shown below. FIG. 7 shows a setting example of the search result output format. Statistical processing of sales office name as vertical key, product name and total quantity as horizontal key
Is set to be displayed. This gives
This determines the output format of FIG. FIG. 8 shows an example of an output list of search results. Vertical key sales offices name, the horizontal key as the product name, product name, the quantity demanded, Table
"Total" which is the format data necessary to determine the format of the indication
By adding a title and outputs the search result as shown in FIG.

Further, according to the present invention, the search result storage section (4)
Data to be stored (search data and form data, etc.)
Search data registration unit (10) registers as a database
Format that can extract and register only the search data necessary for
(Record) and register. For example, in the case of FIG.
Excluding “Total”, which is the formula data, extract only the business office name, product name (TV, radio), and quantity required for registration.
Create and register code.

[0021]

According to the present invention, even in a case where a search result is output in a format different from the format of the original data in the relational database, it can be registered as a database in a format suitable for the output format by a simple procedure. The usability of search results can be improved.

[Brief description of the drawings]

FIG. 1 is a diagram showing a basic configuration of the present invention.

FIG. 2 shows a flow of a search result registration process according to the present invention.

FIG. 3 is a diagram illustrating an example of a database search.

FIG. 4 is a diagram showing a flow of item information generation.

FIG. 5 is a diagram showing a flow of a two-dimensional statistical process.

FIG. 6 is a diagram showing an example of a two-dimensional data output list.

FIG. 7 is a diagram showing an example of a search result output format.

FIG. 8 is a diagram showing an example of a search result output list.

FIG. 9 is a diagram showing an example of a conventional database system.

FIG. 10 is a diagram showing a flow of a conventional search result registration process.

[Explanation of symbols]

 1: search data creation unit, 2: search processing information storage unit, 3: database file, 4: search result storage unit (intermediate file), 5: database management unit, 6: input / output device, 7: output format setting unit, 10: search data registration unit, 11: original data, 12: search result.

 ────────────────────────────────────────────────── ─── Continued on the front page (56) Reference Nobuhiko Nishio “Review 4TH DI VERSION VERSION 2.0 J” Nikkei Byte (1990-07-01) PP. 186-198. , FRANCE PP. 93-116, 143-148. Oki et al. “Business Integrated Software Superpipes for Personal Computers” Toshiba Review Vol. 41, NO. 7 (1986-07-01) PP. 626-629. "4TH DIMENSION QUICK START" Manual ACI, PARIS, FRANCE PP. 6-7.

Claims (3)

(57) [Claims] A database file (3) for storing a relational database including a two-dimensional tabular database, and a search processing information storage unit for storing search conditions.
(2) a search data creation unit (1) that searches a database file based on search conditions to create search data;
A search result storage unit (4) for storing the search data and format data required as an output format of the search results, and a database management unit for managing and inputting / outputting database data.
(5) In the database system provided with (5), the search data creation unit (1) is a two-dimensional tabular database.
Open the vertical key and the horizontal key from the search and search, the two-dimensional search results
Aggregate the data to be the same as the above two-dimensional tabular data
Create a two-dimensional summary database in the form of search data and
And a function to register the search data.
If the search data creation unit (1)
The original tabular search data is stored along with the form data.
Only search data is extracted from the search result storage
Database system automatically generates a record to be registered in the database, the search data registration unit for registering in the database (10), characterized the Moketako. 2. The method of claim 1, the database file
(3) data using the vertical and horizontal keys.
Sort, search records in the sorted result sequentially,
Set the flag for the read record and
It is necessary or unnecessary to manage search data.
A database system wherein the recording instruction is given by a command . 3. The method according to claim 1, wherein
The search data registration section is used when no registration file name is specified.
Is a feature that automatically generates a registration file name.
Database system.