JPS61202249A - Analysis processing system for statistics given from structure type data base - Google Patents

Abstract

PURPOSE:To facilitate the analysis of statistics by storing the data extracted from a structure type data base into an individual data base according to the information given from a parameter file and a control file and then storing the statistic analysis processing data in an extraction file. CONSTITUTION:The data extracted from an achievement data base 3 is stored in an individual data base 7 according to the parameter and the information given from a parameter file 4 and a control file 5 in response to an indication given from a terminal 1. While the statistic analysis processing data is extracted from the base 7 according to the parameter given from the file 4 in response to the indication of the terminal 1.

Description

DETAILED DESCRIPTION OF THE INVENTION (Field of Industrial Application) The present invention relates to a statistical analysis processing method from a structured database.

When performing statistical analysis, a person with computer knowledge created the data necessary for statistical analysis in the necessary format each time.

In addition, data extraction, processing, statistical analysis, and processing result output from existing structured databases that are centrally managed can be done in one place, and end-user-oriented (using online terminals). does not exist, C0BO
A large number of programs had to be developed using languages such as L.

The purpose of the present invention is to create a structured database that is end user-oriented and that has not been provided before, and that enables data to be extracted from existing structured databases and processed for form processing, statistical analysis, and business graph processing. The purpose of this invention is to provide a statistical analysis processing method.

(Means for Solving the Problems) The method of the present invention uses an existing structural database, search conditions for the structural database, processing of data extracted from the structural database, depth analysis methods, statistical analysis instructions, etc. A terminal for specifying the parameters as parameters, a parameter file for storing the parameters, and information that allows the end user who operates the terminal to access the structural database without being aware of its structure. a personal database for storing data extracted from the structured database in response to instructions from the terminal and based on parameters and information from the lameter file and the control file; and an extraction file for storing data for statistical analysis processing extracted from the personal database in response to an instruction from the terminal and based on parameters from the parameter file.

(Example) The present invention will be explained with reference to the drawings.

FIG. 1 shows an embodiment of the invention.

Referring to FIG. 1, this embodiment includes a terminal 1, a comprehensive statistical analysis system 2, a performance database 3, a Harameter file 4, a control file 5, an extraction file 6, a personal database 7, and a printer. It consists of 8.

The comprehensive statistical analysis system 2 is composed of a host computer, and is connected online to a terminal 1 equipped with a display and a keyboard.

The performance database 3 is, for example, an order file.

Manufacturing record file, warehousing file, shipping file.

This is a structured database in which test results files, etc. are organically linked.

The parameter file 4 is for storing various parameters input from the terminal 1, and the control file 5 is for allowing the end user operating the terminal 1 to access the performance database 3 without being aware of its structure. It is used to store information in advance. In addition, the personal database 7 is the performance database 3.
The extraction file 6 is used to store data retrieved from the personal database 7 and necessary for statistical analysis processing or business graph processing.

Next, the operation of this embodiment will be explained in the order of operations performed by the terminal operator. In the following explanation, all instructions refer to instructions from the terminal 1 to the comprehensive statistical analysis system 2.

■ Parameter registration The end user inputs the form creation 2 personal database creation instruction as a parameter interactively with the terminal 1. Parameter registration has the same function as creating a single program. A search condition from the performance database 3, which is an existing structural database, is given, and a processing 1 editing method for the extracted data is instructed by a parameter.

These parameters are stored in parameter file 4.

■ This is an instruction to execute the parameters registered in the form creation instruction ■, and the comprehensive statistical analysis system 2 extracts the necessary data from the performance database 3 and outputs it to the personal database 7 in the form format specified by the parameters in the parameter file 4. . In this case, the control file 5 functions. Types of forms include totals, tally sheets, and detailed tables.

There are total details, horizontal spreadsheets, etc.

■Personal database creation instruction In accordance with the parameter execution instruction entered in ■, the comprehensive statistical analysis system 2 extracts it from the performance database 3 to the personal database 7 as aggregate data for statistical analysis or business graph processing. The control file 5 also functions at this time. The personal database 7 has the function of creating new data and storing it as cumulative data.

■ Extraction instruction from personal database Data required for statistical analysis processing or business graph processing is retrieved from the personal database 7 created in step ■ and extracted into the extraction file 6.

■Statistical analysis or business graph instruction Perform statistical analysis processing or business graph processing from the extraction file 6 created in ■. It is possible to select the extracted data and repeatedly execute various functions.

There are 17 types of statistical analysis methods such as XY plot, histogram, standard statistics, correlation analysis, single regression/multiple regression analysis, and business graphs include pie graphs, bar graphs, band graphs, and line graphs.

There are graph functions such as element bar graphs, element line graphs, etc.

As a result, the graph and table displayed on terminal 1 are as follows:
It is also possible to output it to the computer 8, and it is also possible to leave it as a document.

(Effects of the Invention) According to the present invention, the end user can perform necessary form processing and
Since it became possible to easily perform statistical analysis processing, business graph processing, etc., it had a great effect on improving program management and increasing program physiological efficiency.

[Brief explanation of the drawing]

FIG. 1 shows an embodiment of the invention. 1...Terminal, 2...Comprehensive statistical analysis system, 3...Actual results database, 4...
・Para)-17 file, 5... Control file, 6... Extract file, 7...
Personal database, 8...Printer.

Claims (1)

[Scope of Claims] An existing structural database; a terminal for giving parameters such as search conditions for the structural database, processing and editing methods, statistical analysis instructions, etc. for data extracted from the structural database; and the parameters. a control file that stores information in advance so that an end user operating the terminal can access the structural database without being aware of its structure; a personal database for storing data extracted from the structured database in response to instructions and based on parameters and information from the parameter file and the control file; and an extraction file for storing data for statistical analysis extracted from the personal database based on parameters.