JP2878352B2 - Information processing system - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION [Summary] An advanced database, which relates to a database search processing device that searches and processes a database on a host computer based on a processing request corresponding to an input operation of a workstation and displays the processing result in a graph on the workstation With the aim of realizing search processing and graph output by simple operations, a list of operation items that determine the search processing method and graph output format is prepared on the workstation, and the processing request information is selected by the operation of the operation item. Creates and notifies the host.On the other hand, the host prepares a list that stores the instructions required for database search and processing, extracts the instruction items corresponding to the processing request from the workstation, and performs the processing. To notify the workstation of the processing result, and the workstation receiving the processing result Is configured to extract information in a graph format corresponding to a processing result from a list of graph information, and display the processing result in a graph.

[Industrial Application Field] The present invention relates to a host computer (hereinafter referred to as a “host”) based on a processing request corresponding to an input operation of a workstation.
The present invention relates to an information processing apparatus using a database for searching a database and displaying a processing result in a graph on a personal computer.

In a marketing information analysis system and the like used for corporate management, when a processing request is made to a host by input operation of a workstation, the host analyzes the processing request from the workstation, searches a database, processes the database,
The processing result is sent to the workstation and displayed as a graph. In 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 a processing result in a graph so that it is easy to understand. It is desired to be able to perform advanced database search processing and graph display of results with simple operations.

[Related Art] In recent years, in a database search processing system such as a market analysis system, a user has to determine a very large number of items in order to process a database and output a graph of a result.

For example, in a case where a database is searched by specifying one certain item, and in a case where a database is searched by specifying three items, the complexity of specifying an item is three times or more. To output the processing result as a graph,
The amount of specifying parameters such as graph format, axis title, unit, etc. is very large.

FIG. 4 shows a conventional system, which comprises a workstation 10, a host 12, and a database 14. In order to realize a high-level search and processing of the database 14 by the host 12, the following items are shown. Decide which database to use, decide which table to use,
Each operation of setting an item to be searched, setting a condition to be specified, and determining a processing / editing method is required.

In order to display the processing result of the database search processing of the host 12 on the workstation 10 as a graph,
As shown in, determination of the X axis, Y axis, determination of the unit of each axis,
Determination of graph type (format), determination of scale (scale),
Each operation of determining the range to be displayed is required.

[Problems 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 as a graph, a considerably complicated work is required in a workstation. Since the operation is required and the operation items are diversified, it is required to have sufficient knowledge on database search and processing, and the graph output also requires considerable knowledge on the craft processing, which is impossible for general users. In many cases, there is a problem that the database search processing system cannot be used sufficiently.

SUMMARY OF THE INVENTION The present invention has been made in view of such conventional problems, and has as its object to provide a database search processing device capable of realizing advanced database search processing and graph output with a simple operation.

[Means for Solving the Problems] FIG. 1 is an explanatory view of the principle of the present invention.

In FIG. 1, first, the present invention is directed to an information processing system including a first processing device and a second processing device.

In such an information processing system, the first processing device includes a graph information file storing a graph output format indicating the type of graph to be output and displayed, and a menu file storing search items and operation items indicating the graph output format. When,
A man-machine interface processing means for transmitting processing request information to the second processing device based on the input operation item,
A graph output unit for outputting and displaying a graph in accordance with a graph output format based on a processing result returned from the second processing device, wherein the second processing device stores data matching the search item related to the reception in a database. And processing means for processing data obtained by the search processing means based on the search item and returning a result of processing to the first processing device.

[Operation] According to the database search processing device of the present invention having such a configuration, when an operation item for determining a search method and a graph output format is selected by operating the workstation 10, the menu file 16 and the processing request file 24 are changed. The database 14 is automatically searched and processed by the host 12 using
In addition, the processing result will be automatically displayed as a graph on the workstation 10 using the graph information file based on the processing result, and the user needs no knowledge of database search processing and graph creation. Instead, it is possible to perform desired database search processing and graph display of the result by a simple operation of only selecting an operation item at a workstation, thereby enabling widespread use of a database search processing system.

Embodiment FIG. 2 is a block diagram of an embodiment showing an embodiment of the present invention, and exemplifies a case where a market analysis system is constructed.

In FIG. 2, the database search processing system according to the present invention comprises a host 12 and a workstation 10. In this embodiment, one workstation 10 is shown.
In practice, multiple workstations 10
Is connected.

Workstation 10 has CPU 25 and keyboard 2 for input
8 and mouse 30, display device 32, menu file 1
6. The menu processing unit 18 and the graph output processing unit 22 are configured by the control function of the CPU 25 and configured by the condition file 34 and the graph information file 20.

A plurality of operation items indicated by menu numbers 1 to n are stored in the menu file 16, and these operation items are information for determining a search / processing method of the database 14 in the host 12 and a graph output format for displaying a processing result in a graph. . That is, the menu (operation items) stored in the menu file 16 is displayed on the display device 32. When this menu display is selected and specified by the keyboard 28 or the mouse 30, the processing request ID corresponding to the selected and specified menu is displayed. It is obtained by the menu processing unit 18.

For example, taking a market analysis system as an example, the menu of the menu file 16 includes an analysis by wholesaler, an analysis by retailer,
An analysis by product, an analysis by manufacturer, and a composite analysis of these are prepared as a menu. Further menu files
Reference numeral 16 has a hierarchical structure, and a required menu item can be selected from the upper level to the lower level to specify a target analysis item and determine a processing request ID. For example, if analysis by product is specified as a major category, the category is divided into major category, middle category, product group, single item, rank, container, etc., and any of these elements is analyzed. It will be selected as an item.

Further, the processing request information of the analysis processing to the host 12 includes:
In addition to the processing request ID based on the menu file 16, the 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 a city and a prefecture, a period condition for designating an analysis period, and the like are prepared.

Therefore, in the menu processing unit 18 realized by the CPU 25 of the workstation 10, the keyboard 28 or the mouse 30 is selected from the menu displayed on the display device 32.
When the required menu selection is made, the corresponding menu data from the menu file 16, that is, the processing request ID
Is read, and the processing request ID specifies the database search processing method and the graph output format of the processing result. Further, various condition data is extracted from the condition file 34 by the condition designation, and analysis request data having a format configuration in which the condition data is added to the processing request ID is created and notified to the host 12.

On the other hand, the graph output processing unit 22 and the graph information file 20 provided in the workstation 10 are used when processing results from the host 12 are graphed and displayed on the display device 32 in a graph.

The graph information file 20 stores graph patterns 1 to n that determine the graph format (type of graph) corresponding to the menus 1 to n of the menu file 16. As the graph patterns 1 to n, data for determining basic graph patterns such as a bar graph, a share graph, a target achievement status graph, and a pie graph are stored. Therefore,
The graph output processing unit 22 reads the corresponding graph pattern from the graph information file 20 based on the condition request ID added to the processing result from the host 12, and substitutes a specific numerical value based on the processing result into a parameter of the graph pattern. After creating the information and finally expanding it to bitmap memory, it will be displayed on the CRT32.

Next, the host 12 will be described. The host 12 is provided with a database 14, a search processing unit 26, and a processing request file 24.

The processing request file 24 stores processing patterns 1 to n including 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. Each of the IDs has a one-to-one correspondence. That is, processing patterns 1 to n are prepared in the processing request file 24 corresponding to the menus 1 to n.

Here, each of the processing patterns (instruction items) 1 to n stored in the processing request file 24 is not the program itself for processing and searching the database, but the search method and processing performed by the search processing unit 26 on the database 14. The processing procedure (execution procedure) of the programs 1 to n packaged and stored in the program file 36 is designated.

Therefore, the search processing section 26 is
When the analysis request data is received, the corresponding processing pattern i is extracted from the processing request file 24 in accordance with the processing request ID included in the analysis request data, and is stored in the program file 36 according to the search method and program procedure designated by the processing pattern i. By selecting and executing one of the programs 1 to n sequentially, the database 14 is searched and processed according to the processing request from the workstation 10, and processing data is added to the processing request ID as a processing result. To notify the workstation 10.

Next, a database search process according to the embodiment of FIG. 2 will be described with reference to FIG.

In FIG. 3, first, a plurality of menus for determining a search processing method and a graph output format prepared as the menu file 16 are displayed on the display device 32 of the workstation 10, and the user can select one of the displayed menus from the displayed menu. When the necessary items are selected, the menu processing unit 18 requests the processing of the menu selected and specified from the menu file 16.
The ID is retrieved.

Subsequently, the screen of the display device 32 is switched to a condition input display, and when conditions necessary for the analysis are input, the conditions extracted from the condition file 34 are added to the processing request ID by the menu processing unit 18, and the search processing of the host 12 is performed. The data is sent to the processing unit 26.

The search processing unit 26 of the host 12 is the workstation 10
The processing request ID is extracted from the analysis request data from the server and given to the processing request file 24, the corresponding processing pattern i is extracted, a condition is added to the search method determined by the processing pattern i, and a search of the database 14 is executed. The search data required for the analysis request from the station 10 is obtained by the search processing unit 26, and the analysis processing is executed on the obtained search data.

The processing result obtained by the search processing unit 26 is notified to the graph output processing unit 22 of the workstation 10 in a form in which processing data is added to the processing request ID. The graph output processing unit 22 of the workstation 10 extracts the corresponding graph pattern, that is, the graph information that determines the graph format, from the graph information file 20 by using the processing request ID included in the processing result. By applying a specific numerical value of the processing data received from the host 12 to the parameter, the processing result is converted into graph information, developed into a bitmap memory, and then displayed on the display device 32 as a graph.

As is apparent from such a series of database search processing, the user only needs to input the operation items for determining the search processing method and the graph output format at the workstation 10, that is, the menu input and the condition input for specifying the search range. Often, menu input and condition input are also displayed on the display as names indicating specific analysis contents, so that even in the case of advanced processing search using a large number of databases 14, knowledge of the database search method and processing method is required. The required analysis requests can be made without any need.

Also, as for the graph display of the analysis result, since the graph format for displaying the processing result by menu input is prepared in the graph information file 20, it is automatically based on the processing result without requiring any knowledge on graph creation. Graph information is created and displayed on the display.

In the above embodiment, the database search processing device for the market analysis system is taken as an example.
The present invention is not limited to this. The present invention can be applied to any appropriate database search processing as long as the system performs a database search processing on the host side in response to a request from the workstation and displays the processing result in a graph on the workstation. Can be applied.

[Effects of the Invention] As described above, according to the present invention, a user does not need any knowledge on a database search method and a processing method, and a database search and processing method and a graph without any need for graph output of a processing result. An operation item that determines the output format, that is, a menu selection operation can provide a graph display of a processing result based on a desired database search process. In addition, since information for identifying the output format is added to the search request and the search result, even when a plurality of search results are requested from one processing device, the search result is output in a desired output format. can do. Further, there is an effect that the output processing in the first processing device and the database search process in the second processing device based on the operator's instruction can be performed without the intervention of the operator in the middle. Therefore, even a sophisticated database processing analysis and graph display can be realized by a simple operation, so that the database search processing system can be widely used.

[Brief description of the drawings]

 FIG. 1 is a diagram illustrating the principle of the present invention; FIG. 2 is a diagram illustrating the configuration of an embodiment of the present invention; FIG. 3 is a diagram illustrating the processing of the present invention; FIG. In the figure, 10: workstation 12: host computer (host) 14: database 16: menu file 18: menu processing means 20: graph information file 22: graph output means 24: processing request file 25: CPU 26: search processing means 28: Keyboard 30: Mouse 32: Display device 34: Condition file 36: Program file

Continuation of front page (56) References JP-A-63-165959 (JP, A) JP-A-57-43242 (JP, A) JP-A-64-18890 (JP, A) JP-A-64-8436 (JP) , A)

Claims (1)

(57) [Claims] 1. An information processing system comprising a first processing device and a second processing device, wherein the first processing device includes a graph information file storing a graph output format indicating a type of graph to be output and displayed. A menu file storing search items and operation items indicating a graph output format; a man-machine interface processing means for transmitting processing request information to the second processing device based on the input operation items; And a graph output unit for outputting and displaying a graph in accordance with the graph output format based on the processing result returned from the processing device of the above. Search processing means for searching from a database, processing data obtained by the search processing means based on the search item and processing results The information processing system characterized by having a processing unit to reply to one of the processing apparatus.