JPH03175576A - Data base retrieval processing device - Google Patents

Abstract

PURPOSE:To use a data base retrieval processing system in a wide range by determining a retrieval method and a graph output form with the operation of a work station to automatic ally retrieve and process a data base in a host and automatically displaying the processing results as a graph on the work station side. CONSTITUTION:A list of operation items to determine the retrieval and processing method and the graph output form is prepared in a work station 10, and processing request information is generated by the selecting operation of operation items and is reported to a host 12, and meanwhile, a list where indication items required for retrieval and processing of the data base are stored is prepared in the host 12, and an indication item corresponding to the processing request from the work station 10 is taken out and the processing is performed, and the processing results are reported to the work station 10. The work station 10 receives the processing results to take out information of a graph form corresponding to the processing results from a list of graph information and displays the processing results as a graph. Thus, high level data base retrieval and processing and graph output are realized with an easy operation.

Description

[Detailed Description of the Invention] [Summary] This invention relates to a database search processing device that searches and processes a database on a host computer based on a processing request in response to an input operation on a workstation, and displays the processing results in a graph on a workstation. The aim is to realize search processing and graph output with simple operations. 1. A list of operation items that determine search processing methods and graph output formats is prepared on the workstation, and processing request information is transmitted by selecting operation items. On the other hand, the host prepares a list containing the instruction items necessary for searching and processing the database, retrieves the instruction items corresponding to the processing request from the workstation, and performs the processing. The workstation is configured to perform processing and notify the processing results to the workstation, and the workstation that receives the processing results extracts graph-format information corresponding to the processing results from the graph information list and displays the processing results in a graph. .

[Industrial Application Field] The present invention utilizes a database in which a host computer (hereinafter referred to as "host") searches a database based on a processing request in response to an input operation on a workstation and displays the processing results in a graph on a personal computer. The present invention relates to an information processing device.

In marketing information analysis systems used for business management, when a processing request is made to the host through input operations on the workstation, the host analyzes the processing request from the workstation, searches the database, processes it, and processes it. The results are sent to the workstation and displayed graphically. With such a database search processing device, input operations are complicated in order to realize advanced database search processing, and operations are also complicated when displaying processing results in easy-to-understand graphs. It is desirable to be able to perform sophisticated database searches and display the results in graphs with simple operations.

[Prior Art] Conventionally, in a database search processing method such as a market analysis system, a user has to decide on a large number of items in order to process a database search and output the results in a graph.

For example, the complexity of specifying items is three times or more when searching a database by specifying one item and when searching a database by specifying three items. Also, to output the processing results as a graph,
The amount of parameters to be specified, such as the graph format, axis titles, units, etc., becomes very large.

FIG. 4 shows a conventional system, which consists of a workstation 10, a host 12, and a database 14.
In order to realize advanced search processing of the database 14 on the host 12, as shown in ■ to ■ on the workstation 10, the following steps are required: determining the database to be used, determining the table to be used, setting the search items, and specifying conditions. settings of,
Each operation for determining the processing/editing method is necessary.

In addition, in order to display the processing results of the database search processing on the host 12 in a graph on the workstation 10,
0, it is necessary to determine the X-axis and Y-axis, the unit of each axis, the graph type (format), the scale, and the range to be displayed.

[Problem to be solved by the invention] However, in the conventional database search processing method, in order to determine the search items to be searched and processed, and to output the processing results in a graph, a considerably complicated process is required at the workstation. Since operations are required and the operation items are wide-ranging, it is necessary to have sufficient knowledge about database search processing, and graph output similarly requires considerable knowledge about graph processing, which is difficult for general users. In many cases, the database search processing system was not fully utilized.

The present invention has been made in view of these conventional problems, and an object of the present invention is to provide a database search processing device that can realize sophisticated database search processing and graph output with simple operations.

[Means to solve the problem] FIG. 1 is a diagram explaining the principle of the present invention.

In FIG. 1, the present invention first describes a workstation 1.
The present invention is directed to a database search processing device that searches and processes a database 14 of a host 12 based on a processing request corresponding to an input operation of 0, and displays the processing results in a graph on a workstation 10.

In the present invention, for such a database search processing device, the workstation 10 has a menu file 16 storing operation items for determining the search processing method and graph output format, and a menu file 16 for selecting the operation items stored in the menu file 16. Create processing request information according to the operation and send it to host 1
2, a graph information file 20 that stores graph information that determines the graph output format corresponding to the operation item of the menu file 16;
Graph output means 22 for creating and outputting a graph based on the corresponding graph information acquired from 0,
On the other hand, the host 12 has a processing request file 24 that stores instruction items necessary for searching and processing the database 14.
Search processing means 26 that searches and processes the database 14 according to instruction items taken out from the processing request file 24 based on processing request information from the workstation 12, and notifies the workstation 10 of the processing results.
The configuration is such that it includes:

[Function] According to the database search processing device of the present invention having such a configuration, when an operation item for determining the search method and graph output format is selected by operating the workstation 10, the menu file 16 and the processing request file 24 are The database 14 is automatically searched and processed by the host 12, and the workstation 10 is automatically processed based on the processing results.
The processing results are automatically displayed in graphs using the graph information file, and the user can easily control the operation items on the workstation without needing any knowledge of database search processing or graph creation. A desired database search process and a graph display of the results can be realized with a simple operation of selection, and the database search processing system can be widely used.

[Embodiment] FIG. 2 is a block diagram showing an embodiment of the present invention, taking as an example a case where a market analysis system is constructed.

In FIG. 2, the database search processing method of the present invention is composed of a host 12 and a workstation 10. Although one workstation 10 is shown in this embodiment, in reality, a plurality of workstations are connected to the host 12. Station 10 is connected.

The workstation 10 is composed of a CPU 25, a keyboard 28 and a mouse 30 for input, a display device 32, a menu file 16, a condition file 34, and a graph information file 20. The menu processing section 18 and the graph output processing section 22 are controlled by the control function of the CPU 25. It consists of

The menu file 16 stores a plurality of operation items indicated by menu numbers 1 to n, and these operation items are information that determines the search processing method of the database 14 in the host 12 and the graph output format when displaying the processing results in a graph. be.

That is, the menus (operation items) stored in the menu file 16 are displayed on the display device 32, and when this menu display is selected and specified using the keyboard 28 or mouse 30, the processing request ID corresponding to the selected menu is displayed. It is obtained by the menu processing section 18.

For example, taking a market analysis system as an example, the menus in the menu file 16 include analysis by wholesaler, analysis by retail store,
The menu includes analysis by product, analysis by manufacturer, and a combined analysis of these. Furthermore, the menu file 16 has a hierarchical structure, and by making necessary menu selections from the top to the bottom, it is possible to specify the target analysis item and determine the processing request ID. For example, if you specify product-based analysis as a major category, it is divided into major categories, medium categories, product groups, individual items, ranks, containers, etc., and you can analyze any of these elements. You can now select it as an item.

Furthermore, processing request information for analysis processing to the host 12 is as follows:
In addition to the processing request ID based on the menu file 16, conditions 1 to n stored in the condition file 34 are selectively added. As the conditions 1 to n, for example, regional conditions such as cities and nine prefectures, period conditions for specifying the analysis period, etc. are prepared.

Therefore, in the menu processing section 18 implemented by the CPU 25 of the workstation 10, when a desired menu is selected from the menu displayed on the display device 32 using the keyboard 28 or the mouse 30, the Corresponding menu data,
That is, the processing request ID is read out, and this processing request ID specifies the database search processing method and the graph output format of the processing results. Furthermore, various condition data are extracted from the condition file 34 according to the condition specification, and the processing request I
Analysis request data having a format configuration in which condition data is added to D is created and notified to the host 12.

On the other hand, the graph output processing unit 22 and graph information file 20 provided in the workstation 10 are
It is used when graphing the processing results from and displaying the graph on the display device 32.

The graph information file 20 stores graph patterns 1 to n that determine graph formats (types of graphs) corresponding to menus 1 to n of the menu file 16. The graph patterns 1 to n store data that determines basic graph patterns such as a bar graph, a share graph, a goal achievement status graph, a pie chart, and the like. Therefore, the graph output processing unit 22 reads the graph pattern corresponding to the condition request ID added to the processing result from the host 12 from the graph information file 20, and substitutes specific numerical values based on the processing result for the parameters of the graph pattern. After creating graph information and finally developing it in bitmap memory, it is displayed on the CRT 32.

Next, explaining the host 12, the host 12 has a database 14. Search processing section 26 and processing request file 2
4 is provided.

The processing request file 24 stores processing patterns 1 to n consisting of instruction items necessary for searching and processing the database 14, and the processing patterns 1 to n are processing requests determined by menus 1 to n in the menu file 16 of the workstation 10. There is a one-to-one correspondence with each ID. That is,
Processing patterns 1-n are prepared in the processing request file 24 corresponding to menus 1-n.

Here, each of the processing patterns (instruction items) 1 to n stored in the processing request file 24 is not a program itself for processing and searching a database, but a search processing section 26
It specifies the search method to be performed for the program file 36 and the processing procedure (execution procedure) of the programs 1 to n packaged and stored in the program file 36.

Therefore, the search processing section 26 performs the workstation 1
When the analysis request data from 0 is received, the corresponding processing pattern i is extracted from the processing request file 24 according to the processing request ID included in the analysis request data, and the processing pattern i is
Search and process the database 14 in response to processing requests from the workstation 10 by selecting and sequentially executing any one of programs 1 to n in the program file 36 according to the search method and program procedure specified by Then, processing data is added to the processing request ID as a processing result, and the result is notified to the workstation 10.

Next, the database search process according to the embodiment shown in FIG. 2 will be explained with reference to FIG. 3.

In FIG. 3, first, a plurality of menus are displayed on the display device 32 of the workstation 10 to determine the search processing method and graph output format prepared as the menu file 16, and the user selects one of the displayed menus. When you select what you need, the menu processing section 18
The processing request ID of the selected menu is extracted from the menu file 16.

Next, the screen of the display device 32 switches to a condition input display, and when the conditions necessary for analysis are input, the conditions extracted from the condition file 34 are added to the processing request ID in the menu processing section 18, and the host 12 is searched and processed. It is sent to the processing section 26.

The search processing unit 26 of the host 12 extracts the processing request ID from the analysis request data from the workstation 10, provides it to the processing request file 24, extracts the corresponding processing pattern i, and applies conditions to the search method determined by this processing pattern i. The database 14 is then searched, the search processing unit 26 acquires the search data necessary for the analysis request from the workstation 10, and the analysis processing is performed on the acquired search data.

The processing result obtained by the search processing unit 26 is the processing request ID.
The graph output processing section 22 of the workstation 10 is notified in the form that the processing data is added to the graph. The graph output processing unit 22 of the workstation 10 uses the processing request ■D included in the processing result to generate the graph information file 2.
The corresponding graph pattern, that is, the graph information that determines the graph format is extracted from 0, and the processing result is converted into graph information by applying the specific numerical value of the processing data received from the host 2 to the parameters of this graph information, After developing it in the bitmap memory, it is displayed as a graph on the display device 32.

As is clear from this series of database search processes, the user only needs to input operation items on the workstation 10 to determine the search processing method and graph output format, that is, menu input and conditions for specifying the search range. Menu manual input and condition input are often displayed on the display as names that indicate specific analysis content, so even if you are conducting an advanced search using a large amount of databases 14, it is important to have knowledge about database search and processing methods. The necessary analysis requests can be made without any need for them.

In addition, regarding the graph display of analysis results, the graph information file 20 has a graph format that allows you to display the processing results manually from the menu, so you can automatically display the processing results based on the processing results without any knowledge of graph creation. Graph information will be created and displayed on the display.

Although the above embodiment takes as an example a database search processing device for a market analysis system, the present invention is not limited to this, and the present invention is not limited to this, and the present invention is not limited to this, and the present invention is not limited to this. Perform processing,
The present invention can be directly applied to appropriate database search processing as long as the system displays the processing results in graphs on a workstation.

[Effects of the Invention] As described above, according to the present invention, a user can use database search and processing methods and graphs without any knowledge of database search and processing methods or graph output of processing results. You can obtain a graph display of the processing results based on the desired database search processing by selecting the operation item that determines the output format, that is, the menu selection operation, and even advanced database processing analysis and graph display can be achieved with simple operations. Therefore, the database search processing system can be widely used.

[Brief explanation of drawings]

FIG. 1 is a diagram explaining the principle of the present invention; Figure 2 is a configuration diagram of an embodiment of the present invention: FIG. 3 is a processing explanatory diagram of the present invention; FIG. 4 is an explanatory diagram of the conventional method. In the figure, 10: Work station 2 two host computers (host) 4 16 8 0 2 4 5 6 8 0 2 4 6 :Database : Menu file :Menu processing means Nigelaf information file : Graph output means :Processing request file : CPU :Search processing means :keyboard :mouse :Display device :condition file :Program file

Claims (1)

[Claims] (1) Database search processing in which the host computer (12) searches and processes the database (14) based on processing requests in response to input operations on the workstation (10), and the processing results are displayed in graphs on the workstation (10). In the device, the workstation (10) has a menu file (16) storing operation items for determining a search processing method and a graph output format, and a menu file (16) for selecting operation items stored in the menu file (16). a menu processing means (18) that creates processing request information in response and notifies the host computer (12); and graph information storing graph information that determines a graph format to be output corresponding to the operation item of the menu file (16). When a file (20) and a processing result are received from the host computer (12), a graph is created and output displayed based on the processing result and the corresponding graph information obtained from the graph information file (20). A graph output means (22) is provided, and the host computer (12) has a database (
A processing request file (24) that stores instruction items necessary for searching and processing the workstation (14) and the workstation (10).
), searching and processing the database (14) according to the instruction items extracted from the processing request file (24) based on processing request information from the processing request file (24), and notifying the workstation (10) of the processing results. A processing means (26) is provided, and when an operation item that determines the search method and graph output format is selected by operating the workstation (10), automatic processing is performed using the menu file (16) and the processing request file (24). 1. A database search processing device that performs database search processing and output graph display.