JPH04219871A - Data base system - Google Patents

Abstract

(57) [Summary] This bulletin contains application data before electronic filing, so abstract data is not recorded.

Description

[Detailed description of the invention]

0001

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database system that allows search results of data in a relational database to be easily registered in a database file. Conventionally,
In a relational database system, if the aggregated results of statistical processing in a two-dimensional tabular database are edited into a tabular format that is different from the format of the database data that was the source of the search (hereinafter referred to as the original data), , the search results cannot be stored directly, and must be stored in a relational database by calling a registration program to store them in a format that matches the output format, and then rearranging the search result data on the screen. could not be registered.

[0002] Therefore, in the past, in order to register such search results, a complicated registration procedure was required, so the search was not registered, and if the same search result was needed, the same search process was performed again. It was. An object of the present invention is to provide a database system that allows search results to be easily registered in a relational database file in a format that matches the output format.

0003

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

[0004] The operation of the configuration shown in the figure will be explained. For example, when attempting to create a list of product inventory at each office, the name of the office, product name of television, radio, etc. is input as a key to define search information using the input/output device. Then, the key is stored in the search processing information storage section 82 as search processing information. On the other hand, from the database file 83, a record in which the product name and inventory quantity at each office are combined is input to the search data creation section 81. The search data creation section 81 selects a record giving the inventory quantity of televisions and radios at the specified business office, according to the keys that define the search information stored in the search processing information storage section 82. Then, the search results obtained in this manner are stored in the search result storage section 84, and are outputted to a display device or a printing device in the output format specified by the output format setting section 87.

[0005] In conventional relational database systems, search results that are arranged to be output in a format different from the original data format cannot be directly registered in the search result format, and the operator must register them once in that format. It was necessary to call up a program such as a tabular format, rearrange the search result data on the display screen, and perform the registration process.

FIG. 10 shows the flow of search result registration processing. The explanation will be given according to the circled numbers shown in the figure. ■ Start search result storage processing. ■ The worker calls a program that provides the 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 the file name. ■ Register search results. ■ Finish the registration process.

[0007]

[Problem to be solved by the invention] As mentioned above, in conventional relational database systems, two
If the data is rearranged so that the aggregation results of statistical processing in a dimensional tabular database are output in a format different from the original data format, the search results cannot be directly registered in the database file. Registration was not possible without calling a registration program to register the data in the display format that outputs the search results, and then rearranging the search result data on the screen.

[0008] Conventionally, the registration procedure was complicated, so the aggregated results of statistical processing were not registered, and when the same search results were needed, the same search process was performed again. Therefore, it has been difficult to register the obtained search results as a database and use them in other processes. The present invention allows search results to be output in an output format different from the format of the original data.
The purpose is to provide a database system that allows easy registration in database files.

[0009]

[Means for Solving the Problems] The present invention allows a data search data registration unit to automatically generate file names, etc. even for search result data in a rearranged format according to the output format. It is now possible to register files directly as a database.

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

[0011]

[Operation] The flow of the search result registration process in the basic configuration of the present invention will be explained with reference to FIG. The explanation will be given according to the numbers shown. Refer to FIG. 1 as necessary. ■ Start the registration process. ■ Search results are given arranged according to the output format. ■ Decide whether to register or not. If you wish to register, proceed to ■. If you do not want to register, proceed to ■. ■ If registering, the operator inputs the file name using the input device. Alternatively, a registered file name is automatically generated. ■ The data stored in the search result storage section (intermediate file) 4 includes the data necessary for screen or print output, so only the data necessary for registering as a data base is retrieved and output. It is registered in the database file in a format according to the format. ■ Finish the registration process.

According to the present invention, even if the data arrangement is changed in a relational database so that search results such as tabular statistical processing results are output in a format different from the original data format, the output format can be changed on the relational database. You can easily register by following the format.

[0013]

[Embodiment] An embodiment of the present invention will be explained with reference to FIGS. 3 to 8. FIG. 3 shows an example of database search in the present invention. Figure (a) shows an example of two-dimensional data to which the present invention is applied. It consists of records that combine the business office names of Shinjuku, Kawasaki, and Osaka with the product names of TV and radio and the respective quantities. Figure (b) shows an example in which the two-dimensional data in Figure (a) is edited and output in the output format as shown in the figure, with the two-dimensional tally results using the business office name as the vertical key and the product name as the horizontal key. . Figure (c) is Figure (a)
Shows the search results of two-dimensional aggregation of two-dimensional data. Each piece of data is arranged as shown in Figure (c) so that the aggregated data of the vertical and horizontal keys in the two-dimensional data (a) is output in the format shown in Figure (b). The control code in Figure (c) indicates the total. And figure (c)
When registering the search results in the database file, only the items necessary for the database surrounded by dotted lines in the figure should be registered in the arrangement shown.

FIG. 4 shows the flow of generating item information in the database of the present invention. As an example, the case of processing the two-dimensional data in FIG. 3(a) will be explained according to the numbers shown in the figure.

■ Product name of horizontal key (TV, radio)
Sort records by. (As a result, for example,
In the table, records with television in the product name are collected in the upper part, and records with radio in the product name are collected in the lower part. ■ Remember record field values. For example, set television as the record item value. ■ Read the record. ■ Determine whether the data is complete. If the process has not finished, proceed to ■; if it has finished, the process ends. ■ Determine whether the record value is the same as last time. For example, if the previous record was on TV and this time it is also on TV, press ■ to read the next record. If the data is not completed at ■, proceed to ■, and so on, and repeat the process. ■ In ■, if the record item value is radio,
Now that we have finished reading the record that has television as the record item value, we set radio as the next item value.

Thereafter, the processes ① to ② are repeated in the same way, and the process ends when all records have been read. From the illustrated flow, it can be seen that there are two types of product items in the horizontal direction in the two-dimensional data of FIG. 3(a): television and radio.

FIG. 5 shows the flow of two-dimensional statistical processing in the database system of the present invention. The explanation will be given according to the numbers shown. (1) Sort records by vertical item value (office name) and horizontal item value (product name). That is, Fig. 3(a
), for example, records with office name Shinjuku are collected at the top of the table, then among records with Shinjuku, for example, those with TVs are collected at the top of the table, and then records with Shinjuku are collected at the top of the table. Try to collect records that have radios. Similar sorting is performed for the office names of Kawasaki and Osaka. (2) Set the vertical direction (office name) key. For example, a key is set for the office name Shinjuku. (3) Determine whether the data has been completed. If not, proceed to (4); if it has been completed, perform termination processing. (4) Set the horizontal direction keys. For example, settings are made for television and radio in sequence.

(5) In this embodiment, if the keys do not match, a flag is set and the processing is temporarily stopped, so it is determined whether the keys match and it is necessary to read the record. If reading is necessary, proceed to (6); if there is no match and reading is not necessary, proceed to (8) without reading the record. (6) If the keys match and it is necessary to read the record, read the record. (7) After reading the record, perform processing to set a flag indicating that the read is not required as required in the determination in (3) (the read not required shown in the figure indicates this). (8) Determine whether the vertical key and record value are equal. If they are equal, proceed to (9); if not, proceed to (12). In other words, since Shinjuku is currently set as the vertical direction key,
If the record is Shinjuku, proceed to (9); if the record is different, then all the records of the vertical key for Shinjuku have been read, so in (12), the intermediate search result of the vertical key aggregation results is entered. Output the tally results to a file and set the next vertical key. (9) If the horizontal key and record value are equal, proceed to (10); if they are different, repeat the process from (5) onwards. (10) If the horizontal key is TV, then in (10) the account calculation is performed using a record that has Shinjuku and TV as item values. (11) At present, the flag necessary for the judgment in (3) is set, meaning that no lead is required.
Performs processing that requires reading. Then, (4) repeat the following process. The above process is repeated to obtain the two-dimensional tally result shown in Figure 3(b).

FIGS. 6 to 8 show examples of output forms for database searches in the embodiment of the present invention. FIG. 6 is an example of a two-dimensional data output list. The figure shows an example of the results of an inquiry about business office name, product name, and quantity in the database. FIG. 7 shows an example of setting the search result output format. A case is shown in which the office name is set as the vertical key, the product name is set as the horizontal key, and the quantity is set as the statistical data, and the output format shown in FIG. 8 (described later) is determined. FIG. 8 shows an example of an output list of search results. Search results (table results) as shown in the figure are output with the business office name in the vertical key and the product name in the horizontal key.

According to the present invention, among the data stored in the search result storage section (intermediate file) that outputs the search results shown in FIG.
(TV, radio), quantities can be registered in a simple procedure by arranging them in the format shown.

[0021]

[Effects of the Invention] According to the present invention, even when outputting search results in a format different from the format of the original data in a relational database, it is possible to register the results as a database in a format that matches the output format with a simple procedure. The usability of search results can be improved.

[Brief explanation of the drawing]

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

FIG. 2 shows a flow of search result registration processing in the present invention.

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

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

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

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 conventional search result registration processing.

[Explanation of symbols]

1: Search data creation section, 2: Search processing information storage section, 3: Database file, 4: Search result storage section (intermediate file), 5: Database management section, 6: I/O device, 7: Output format setting section, 10: Search data registration section, 11: Original data, 12: Search results.

Claims (2)

[Claims] [Claim 1] A search data creation unit (1) that creates search results based on search processing information that defines search information and data in a database file, a database file (3) that stores a database, and a database file that stores the search processing information. A database file (3) includes a search processing information storage section (2) for storing information, and a database management section (5) for managing and inputting/outputting database data.
In a database system that searches data registered in a search processing information storage unit (2) based on search processing information, a database management unit (5) stores search results created by a search data creation unit (1). The search data registration unit (which imports the data of the search result at the time it is created and processes it to register it in the database file (3)
10) A database system characterized in that the search results are automatically registered in a database file each time a search process is performed. 2. The database system according to claim 1, wherein the data in the database to be searched is two-dimensional tabular data, and the search result is two-dimensional aggregated data.