JP2000099542A - Inquiry of production result and inquiry device of database - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a means by which a user himself can easily and flexibly retrieve, select, extract, work and display data that he requires from a database and to reduce the cost of database application development. SOLUTION: A user sets the item, the display system and the condition of a production result which he intends to draw out from a data base. A schema retrieval part 2 retrieves schema definition information 11 which a database management system 10 manages based on information and issues and inquiry sentence 4 by an inquiry sentence generation part 3 by using obtained information of the data structure of the database. The database management system 10 storages production information from PLC(programmable logic controller) 6 monitoring/controlling production equipment 5 in the database 7. A retrieval result work part 8 shapes the retrieval result which the data base management system 10 takes out from the database 7 in accordance with a display system which the user sets in the input part 1 and displays it to an output part 9.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an apparatus for inquiring production results, and is suitably applied to, for example, database application development, online analysis (OLAP) tools, multidimensional databases, and the like.

[0002]

2. Description of the Related Art Conventionally, when developing a database application, an application developer has performed business analysis, database schema design, screen design, etc., after listening to a user's intention. This is no problem for applications used in routine work. However, once these applications are created, it takes a lot of man-hours to change specifications, and it is not possible to perform flexible searches other than routine tasks. Flexible tools are needed for data analysis and decision making. In particular, the vast amount of time-series data generated during the manufacturing process is often analyzed from a variety of viewpoints to examine problems when analyzing data for quality improvement.Conventionally, data was converted from a database to spreadsheet software. Reading, processing and graphing were done manually by trial and error.

[0003]

SUMMARY OF THE INVENTION The present invention provides means for a user to easily, flexibly search, select, extract, process, and display data he or she needs from a database. The purpose is to reduce costs.

[0004]

According to a first aspect of the present invention, there is provided a method for setting information to be taken out by a user and a display format thereof when making an inquiry for extracting information on production results required by the user from a database. It has a function to search schema definition information based on the information, generate a query statement, and change the schema if the data required by the user can not be obtained from the database,
The data obtained as a result of the inquiry is displayed in the display format.

[0005] The invention according to claim 2 has means for setting information to be taken out by a user and a display format thereof when inquiring information required by the user from a database, and a schema based on the information. Searches definition information, generates a query, and has a function to change the schema if the data required by the user cannot be obtained from the database. The data obtained as a result of the query is displayed in the above display format It is characterized by doing.

According to a third aspect of the present invention, in the first aspect of the present invention, schema definition information is searched based on data set by a user, and an inquiry sentence is generated.

According to a fourth aspect of the present invention, in the first aspect of the present invention, there is provided a schema management means for changing a schema definition, and when data required by a user cannot be obtained from a database, the schema management means is provided. It is characterized by changing the definition of the schema.

According to a fifth aspect of the present invention, in the first aspect of the present invention, there is provided a means for setting and storing information and a display format desired by a user, and reused as a graphical user interface. is there.

[0009] The invention of claim 6 is characterized in that, in the invention of claim 1, the user can input and output on a screen of a terminal different from the database server via the communication network.

According to a seventh aspect of the present invention, in the first aspect of the present invention, when data required by a user cannot be obtained from one database, information of another database on a communication network is searched, and the result is obtained. It is characterized in that desired data is obtained by using the data.

[0011]

FIG. 1 is a diagram showing an example of a production result inquiry device according to the first aspect of the present invention. As shown in FIG. , Conditions are set in the input unit 1, and the schema search unit 2 searches the schema definition information 11 managed by the database management system 10 based on the information, and uses the obtained data structure information of the database. The inquiry sentence 4 is issued by the inquiry sentence generation unit 3.
The database management system 10 monitors and controls the production equipment 5 by a PLC (programmable logic controller).
6 is stored in the database 7, and the search result processing unit 8 shapes the search result retrieved from the database 7 by the database management system 10 according to the display format set by the user in the input unit 1, and outputs the result. It has means for displaying in the section 9.

FIG. 2 is a view showing an example of a production result inquiry device according to the second aspect of the present invention. As shown in FIG. The schema search unit 2 searches the schema definition information 11 managed by the database management system 10 based on the information, and uses the obtained information on the data structure of the database to generate a query Issue 4. The search result processing unit 8 has means for shaping the search results retrieved from the database 7 by the database management system 10 in accordance with the display format set by the user at the input unit 1 and displaying the result on the output unit 9.

FIG. 3 is a view showing an example of a production result inquiry device according to the third aspect of the present invention. As shown in FIG. The schema search unit 2 searches the schema definition information 11 in which information on the data structure managed by the database management system 10 is described based on the information, and uses the obtained data to generate a query sentence generation unit. At step 3, an inquiry 4 is issued.

(Embodiment 1) FIG. 4 is a diagram showing an embodiment according to the third aspect of the present invention. Here, a relational database (RDB) is considered. A user 20 uses input / output devices 21 such as a keyboard, a display, and a mouse to input text fields T1, T2,
Enter the required variable name in ... Here, for example, assuming that the user wants to see the relationship between the humidity and the number of good products, the user inputs T1: humidity T2: the total number of good products. When the schema search button 23 is pressed, the column names of the RDB described in the schema definition file 24 are searched, and the matching results are displayed in drop-down lists C1, C2,. Similar column names may be displayed in the drop-down list in descending order of similarity. The input method to the input / output device 21 may be text data or data converted from voice or image data other than the keyboard and mouse.

Further, as shown in FIG. 5, the user may press a diagram display button 25 to display an entity relationship (ER) diaphragm 26, and select a column name from a table therein. For example, C1: humidity in the process table, C2: number of non-defective products in the lot table are selected, and the following SQL statement is generated from the word T2. SELECT Humidity, SUM (number of non-defective products) FROM process, lot WHERE lot. Lot number = process. Lot number

FIG. 6 is a diagram for explaining a production result inquiry device according to the fourth aspect of the present invention.
The schema management unit 12 enters between the schema search unit 2 and the schema definition information 11, and has a function of changing the schema definition when a search result desired by the user is not obtained. R
Taking the DB as an example, this change may be made to the view.

FIG. 7 is a diagram for explaining a production result inquiry device according to the fifth aspect of the present invention.
When the above-described setting of the input unit 1 by the user and the generated query 4 are stored in the file 35 in the secondary storage device 30 and a similar search is performed later, the setting of the input unit 1 and the query 4 The search result processing unit 8 can call the file 31 again from the file 31 to make an inquiry and display the latest production result information on the display unit 9.

(Embodiment 2) FIG. 8 is a diagram showing an embodiment of the invention according to claim 5, in which the user wants to see the number of non-defective products every day in a line graph. On the search result display screen 40, a graph setting button 41 is used to set a graph. Here, the type of graph, data range, display setting, and the like may be performed. The data to be assigned to X and Y in the graph 42 is set as a result of the schema information search. Here, the shipping date and the number of non-defective products (total for each day) in the lot table are respectively used. These various settings are saved as a file. If you want to see the latest information on the number of good products every day again, read this file and query the database, and the graph will be displayed on the same graphical user interface. Furthermore, after reading the file, the display format may be changed with the graph setting button 41 or the SQL sentence may be corrected with the button 43.

FIG. 9 is a diagram showing a production result inquiry device according to the sixth aspect of the present invention. As shown, a client 50 used by a user and a database server 70 are connected via a communication network 60. The schema search unit 2 and the search result processing unit 8 exchange data with the database management system 10 through the communication network 60. The communication network 60 may be a LAN (local area network), a WAN (wide area network) or the Internet.

FIG. 10 is a diagram showing a production result inquiry device according to the seventh aspect of the present invention. As shown in FIG.
0 is connected to the communication network 60. The schema search unit searches schema definition information on a database server on a communication network and creates a query. This communication network is LAN (local area network), WAN (wide area network)
Alternatively, it may be the Internet.

[0021]

According to the first aspect of the present invention, the database user can easily, flexibly select, extract, process, and display his / her necessary data on production performance data including a huge amount of time-series data. Become.

Effect of the invention of claim 2: The user of the database can easily and flexibly select his or her necessary data,
Extraction, processing, and display are possible.

Advantageous effect of the third aspect of the present invention: a search with a high degree of freedom is possible because a search is performed by text, and SQL
The user can easily perform a flexible search without knowing the database query language such as.

Advantageous Effects of the Invention According to Claim 4: Since the data structure of the database can be changed by the user instead of the database developer, the cost of database application development and maintenance can be reduced. In addition, since the data structure is changed not directly by the user but by the schema management unit, it can be safely changed.

Effect of the invention of claim 5: By reusing the settings of the input / output screen, it is possible to reduce the search load of the database user, and to perform analysis by correcting past settings. Can also.

According to the sixth aspect of the present invention, since a single server can handle a plurality of users by using a client-server system, the operation cost can be reduced and the performance of the entire system can be improved. it can.

Effect of the present invention according to claim 7: Data can be searched over a wider area and problems can be analyzed.

[Brief description of the drawings]

FIG. 1 is a diagram showing an example of a production result inquiry device according to the invention of claim 1;

FIG. 2 is a diagram showing an example of a production result inquiry device according to the invention of claim 2;

FIG. 3 is a diagram showing an example of a production result inquiry device according to the invention of claim 3;

FIG. 4 is a diagram showing an embodiment relating to the invention of claim 3;

FIG. 5 is a diagram showing an example of a diaphragm display.

FIG. 6 is a diagram for explaining a production result inquiry device according to the invention of claim 4;

FIG. 7 is a diagram for explaining a production result inquiry device according to the invention of claim 5;

FIG. 8 is a diagram showing an embodiment of the invention of claim 5;

FIG. 9 is a diagram showing a production result inquiry device according to the invention of claim 6;

FIG. 10 is a diagram showing a production result inquiry device according to the invention of claim 7;

[Explanation of symbols]

DESCRIPTION OF SYMBOLS 1 ... Input part, 2 ... Schema search part, 3 ... Query sentence generation part, 4 ... Query sentence, 5 ... Production equipment, 6 ... PLC,
7 ... database, 8 ... search result processing unit, 9 ... output unit,
10: Database management system, 11: Schema definition information, 12: Schema management unit, 20: User, 21: Input / output device, 22: Input screen, 23: Schema search button, 24: Schema definition file, 25: Diagram display Button, 26 ... diagram, 30 ... secondary storage device, 31 ... file, 40 ... search result display screen, 50 ...
Client, 60: communication network, 70: database server.

Claims (7)

[Claims] 1. An inquiry for extracting information on production results required by a user from a database has means for setting information desired by the user and a display format thereof, and schema definition information based on the information. Has a function to change the schema when the data required by the user cannot be obtained from the database by generating a query sentence and displaying the data obtained as a result of the query in the above display format. Inquiry device for achievements. 2. An inquiry for extracting information required by a user from a database, comprising means for setting information desired by the user and a display format thereof.
Searches schema definition information based on that information, generates a query sentence, and has a function to change the schema if the data required by the user cannot be obtained from the database. Database inquiry device for displaying the above in the display format. 3. The production result inquiry apparatus according to claim 1, wherein the apparatus searches schema definition information based on data set by a user and generates an inquiry sentence. 4. A schema managing means for changing a schema definition, wherein when data required by a user cannot be obtained from a database, the schema definition is changed by the schema managing means. The production result inquiry device according to claim 1. 5. The production result inquiry apparatus according to claim 1, further comprising means for setting and storing information and display format desired by the user and reusable as a graphical user interface. 6. The production result inquiry device according to claim 1, wherein the user can input / output on a screen of a terminal different from the database server via the communication network. 7. When data required by a user cannot be obtained from one database, information of another database on the communication network is searched, and desired data is obtained by using the search result. The production result inquiry device according to claim 1.