JPH01150932A - Data base inquiry processing system - Google Patents

Abstract

PURPOSE:To facilitate a regular-form inquiry by using a management file and a parameter preserving file according to a regular-form request from a terminal, using the parameter prepared by a non-regular-form inquiry and carrying out a regular-form inquiry processing. CONSTITUTION:The title system is the one to attain the regular-form inquiry with the use of the parameter prepared by the non-regular-form inquiry. For this, regular-form information (for example, the title of calculator name, etc.) is stored into a control file 5 by a regular-form processing so as to carry out a regular-form by using the parameter of a parameter preserving file 4, the simple input from a terminal 3b is carried out by the regular-form information of the management file 5, and the regular-form inquiry is carried out by using the parameter of the parameter preserving file 4. Consequently, a data base obtained by using the parameter prepared by means of the non-regular-form inquiry can be inquired by the regular-form inquiry, and the inquiry can be realized without damaging the contents of the parameter preserving file 4.

Description

[Detailed description of the invention] [Table of contents] Overview Industrial field of application Prior art (Figure 3) Problems to be solved by the invention Means for solving the problems (Figure 1) Working examples (a ) Explanation of one embodiment (Figure 2) (b) Explanation of other embodiments Effects of the invention [Summary] Regarding a database query processing method in which a database is processed with a routine query based on a request from a terminal, this invention was created using an unstructured query. With the aim of easily realizing fixed queries using parameters, database files are created using unstructured query processing in a database query processing method in which a data processing unit processes fixed queries based on fixed requests from a terminal. A parameter storage file that stores parameters and a management file that stores standardized information that can be used for standard inquiries using the parameters of the parameter storage file are provided, and the management file and the management file are stored in response to a standard request from the terminal. The parameters created in the non-routine query using the parameter storage file are used to process the regular query.

[Industrial application field]

The present invention relates to a database query processing method for processing a fixed query on a database based on a request from a terminal.

BACKGROUND OF THE INVENTION In recent years, with the expansion of the field of use of databases, databases are being used in various fields.

Query processing is used to search such databases and obtain the desired financial table output, and due to the ease of operation,
A fixed query method is used that performs fixed query processing and obtains fixed table output.

On the other hand, with such standard formats, it is not possible to obtain necessary financial tables other than the standard format, so package software has appeared that can perform non-standard query processing to easily output the necessary items in the financial tables. .

Such a non-routine query can only be executed by someone who is familiar with the package software, so it is desirable to be able to implement a routine query using parameters created in the non-routine query.

[Conventional technology]

FIG. 3 is an explanatory diagram of the prior art.

In FIG. 3(A), a computer (data processing unit) 1 is connected to a large number of terminals 3 such as personal computers and a database file 2 to form a system.

The terminal 3 includes a display section 30, an input section 31, and a printing section 32.

In such a system, parameters are input from the terminal 3 in order to perform atypical inquiry processing.

For example, as shown in Figure 3 (A), if database file 2 is a database of deposits and savings of customers in a financial business, atypical inquiries are performed about once a month in order to individually create a circular accounting table. . The ring element table is, for example, the third
In the example table of deposit and savings status of each customer shown in Figure (D), the horizontal axis shows the account number.

The monthly balance and average balance are plotted against each account number on the vertical axis.

To obtain such a table by querying the database file 2, the atypical processing screen shown in FIG. Input the inquiry items (parameters) on the axis using the codes in the database file 2, and then similarly input the inquiry items on the vertical axis using the codes on the non-routine processing screen shown in FIG. 3(C).

Here, as shown in Figure 3 (B), the parameter code "0001" of the account number (No.) is set as the "type" on the horizontal axis, and the parameter code "0002" of the deposit is set as "detail 1".
'', the parameter code "0005" of the data for month X as "Breakdown 2", and the remaining parameter code "0010" for month X as "count", and the vertical axis is as shown in Figure 3 (C). For example, the parameter code "0001" of account No. 0 is set in "Type", and the position code "100-500" on database file 2 of account No. 1 is set as "condition".
” is being input on the screen.

Similarly, when parameter codes for the average balance are entered on the screen on the horizontal axis, the computer 1 accesses the database file 2 through non-routine inquiry processing using these codes as parameters, and calculates the calculation as shown in Figure 3 (D). Edit the table output and transfer it to terminal 3.

In the terminal 3, the printing unit 32 prints out this table output, for example.

In this way, it is possible to obtain a variety of necessary non-standard timetables other than the regular ones, and to obtain various necessary timetables depending on the business.

The parameters created by this non-standard processing can be saved in the parameter storage file 4, and the parameters are stored in correspondence with the parameter numbers.

Therefore, the parameters are read out to the display unit 30 of the terminal 3 by simply specifying the parameter number without creating a new one next time, and thereby the same table can be output in the same way.

[Problem that the invention seeks to solve]

By the way, when inputting such an atypical inquiry, a guidance screen for parameter input is displayed, and the input of the parameter is sufficient.

However, even with this type of simplification of input, it is still necessary to enter the code on the matrix screen according to the table format, and this code is also in database file 2, so it is difficult to use the codebook. Need to refer.

For this reason, in the past, those who were familiar with such non-routine inquiry packages created the parameters.In banking, the development department at the headquarters creates the parameters, obtains an environmental accounting table, and then creates the parameters for each branch office. The documents were sent to the company and used for promotion of sales, etc.

Therefore, there is a problem that only a few people who are familiar with the operating procedures etc. can use it, and the number of end users does not increase. The problem was that it was not available.

The present invention utilizes parameters created by an ad hoc query,
The object of the present invention is to provide a database query processing method that makes it possible to easily perform routine queries.

[Means for solving problems]

FIG. 1 is a diagram explaining the principle of the present invention.

In the figure, the same parts as shown in Figure 3 are indicated by the same symbols, 3a and 3b are terminals, 5 is a bill management file, and the parameters in parameter storage file 4 are used. This is used to store standardized information that can be used to perform standardized queries through standardized processing.

Then, the computer 1 processes a fixed inquiry using the parameters created in the non-standard inquiry using the management file 5 and the parameter storage file 4 in response to a fixed request from the terminal 3b.

[Effect]

The present invention makes it possible to perform regular queries using parameters created in non-standard queries.

Therefore, in order to be able to perform standardization using the parameters in the parameter storage file 4, standardization information (for example, table name, etc.) is stored in the management file 5 through the standardization process. A simple input is made from the terminal 3b using the stylized information in the file 5, and a stylized inquiry is performed using the parameters in the parameter storage file 4.

Therefore, it is possible to query a database using parameters created by a non-routine query using a regular query, without damaging the contents of the parameter storage file 4.

〔Example〕

(a) Description of one embodiment FIG. 2 is a configuration diagram of an embodiment of the present invention.

In the figures, the same parts as those shown in FIGS. 1 and 3 are indicated by the same symbols.

In this example, the information system of a financial institution is used as an example of the system configuration shown in Figure 1, and the terminal 3a is installed in the development department and sales promotion department of the headquarters, and the terminal 3b is installed in the sales branch. .

Here, it is assumed that the created parameters corresponding to the parameter numbers have already been stored in the parameter storage file 4 by the non-standard processing shown in FIG.

First, the parameters of the non-standard query are standardized.

(2) When a formalization request is issued to the computer 1 from the input unit 31 of the terminal 3a in the development department, the formalization processing program is started.

(2) The computer 1 provides an input screen for standardization to the terminal 3a, and causes the display unit 30 to display the input screen. In this example, enter the table name in Japanese, the parameter number, ,
Overlay (ruled lines on table output, format, etc.) No.
, security level, etc.

(2) The operator inputs standard registration data from the input section 31 along the input screen.

In this example, corresponding to the examples in Figure 3 CB) to (D), the table name is "Remaining at the end of the month" and the parameter No. 0 is r 0.
01 J---- is being input.

When the operator presses the end key from the input unit 31 after completing the input, the input data is transferred to the computer 1.

The computer 1 stores this standardized input information in the financial statement management file 5.

In this example, for the standard form (calculation table) NO, rKIJ, the financial table name is registered as "remaining at the end of the current month" and the parameter NO0 is registered as ro OIJ, and the standardization process ends.

The operator standardizes the necessary parameter numbers in the parameter storage file 4, and if necessary, inputs the parameter No. 1 of the parameter storage file 4 for confirmation, and displays the corresponding parameters of the file 4.

Next, a process of making a standard query using the non-standard parameters that have been subjected to the standardization process will be described.

(2) When a standard selection request is issued to the convenience store 1 from the input unit 31 of the terminal 3b at the branch, the standard processing program is started.

The computer 1 accesses the bill management file 5 and generates a bill selection screen.

Computer l transfers the table selection screen to terminal 3b,
As shown in FIG. 2, the table No. 0 and the name of the table are displayed on the display section 30.

The operator looks at the screen of the display section 30, inputs the desired table number from the input section 31, and selects the table.

(2) The calculation table No. 0 is transferred to the computer 1, and the computer 1 extracts the corresponding parameter No. from the calculation sheet management file 5 according to the calculation sheet No. 0.

Then, the parameter storage file 4 is accessed using this parameter number, and the corresponding parameter information is extracted.

(2) Further, the computer 1 generates a next input screen to input other inquiry conditions, transfers it to the terminal 3b, and displays it on the display unit 30.

In this example, as shown in FIG. 2, other inquiry conditions include the store number of the account to be inquired and the time series (for which month or from which month to which month).

The operator follows this screen and inputs the store number and time series.

Then press the end key.

(2) As a result, other inquiry conditions are transferred to the computer 1, and the computer 1 edits the parameters together with the parameter information extracted in step (2).

For example, in the example shown in Figure 3, the parameter for month X in breakdown 2 of the horizontal axis parameters in Figure 3 (B) is set to "0005".
Re-edit the input time-series data and display it in Figure 3 (
Replace the condition of the vertical axis parameter in C) with the input store number.

(2) The computer 1 accesses the database file 2 using the edited parameters, obtains the necessary data on the horizontal and vertical axes, and outputs the data to the terminal 3b.

As a result, the printing unit 32 prints out the remaining balance at the end of the current month in the account of the designated branch as a list.

In this way, a query can be realized by a regular query process using parameters created in an unconventional query process.

Therefore, even a person who does not know the complicated operations of non-routine processing can easily utilize the parameters (assets) created as needed through non-routine processing through routine queries.

(b) Description of Other Embodiments In the above-described embodiments, a database for financial services was explained, but the present invention can be applied to various databases such as a sales database for commercial transactions and an inventory management database for factories.

Furthermore, the table output is not limited to the print section, but may also be a file, display section, etc. of the terminal. - Although the present invention has been described above with reference to Examples, the present invention can be modified in various ways according to the gist of the present invention, and these are not excluded from the present invention.

〔Effect of the invention〕

As explained above, according to the present invention, it is possible to make a fixed inquiry using parameters created by a non-standard inquiry, thereby increasing the number of users of various fixed tables.

Further, it has the effect of being easily realized, and the parameters of an unstructured query can be easily standardized.

[Brief explanation of the drawing]

FIG. 1 is an explanatory diagram of the principle of the present invention, FIG. 2 is a configuration diagram of an embodiment of the present invention, and FIG. 3 is an explanatory diagram of the prior art. In the figure, 1 - computer (data processing unit), 2
-Database file, 3.3a, 3 kr terminal, 4-parameter storage file, 5-account management file.

Claims (1)

[Claims] A database query processing method in which a data processing unit (1) processes a routine query on a database file (2) in response to a routine request from a terminal (3), wherein parameters created in the non-routine query processing are saved. A parameter storage file (4) and a management file (5) storing formatted information that can be used for formatted queries using the parameters of the parameter storage file (4) are provided, and the formats can be accessed from the terminal (3). The corresponding management file (
5) and parameters created in an unstructured query using the parameter storage file (4) to process a structured query.