JPH09128278A - Data base update procedure generation device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To easily generate and correct a data base update procedure while data and a table on a screen are referred to by generating the data base update procedure through the use of a graphical user interface. SOLUTION: When a procedure generation control part 2 controlling a whole device displays a fixed data base update processing procedure on the display of a terminal 13 with a graphical user interface (GUI), a data analysis part 3 analyzes data which a user selects and inputs. When the data retrieval of a data base is required at that time, a data retrieval part 4 recognizes the type of the data base becoming an object. At the time of accessing an A-data base 9, for example, data is obtained by using an A-data base retrieval part 5. Data of the retrieved result is set to a state where it can be displayed on the screen in a data work part 8. At the time of developing the data base update processing, data extracted or worked by a designated condition is displayed on the screen.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to creating a database update procedure, and more particularly to GUI (Graphical User Interface)
ace) related to the procedure creation device.

[0002]

2. Description of the Related Art Conventionally, in the creation of this type of database update procedure, a database access program for performing data retrieval, update, deletion, etc. is created in a database operation language called SQL (Structured Query Language).

That is, in the conventional creation of a database update procedure, it is necessary to recognize in advance what the structure of the table to be searched is, how many target data items are and what the contents are. It was necessary to keep in mind, and based on that, the database access program by SQL was created.

Further, if the types of databases are different, it is necessary to confirm the structure of the table and the data content individually for each database.

[0005]

As described above, the SQL is
In order to create a database update procedure using, it is necessary to confirm in advance the table structure and data content of the database and fully understand the functions of SQL itself. Therefore, it is generally difficult for a database user (end user) to create or modify such a procedure, which causes the database to be unusable.

An object of the present invention is to allow a person who does not have sufficient knowledge of SQL or database to easily create or modify the update procedure of the database while referring to the data or table on the screen. It is to realize a database update procedure creation device capable of performing.

[0007]

A database update procedure creation device of the present invention includes a procedure creation control unit for controlling a series of processing operations created using a GUI in creating a procedure for performing a routine database update process. , A data analysis unit that analyzes the input contents of each process setting screen displayed by the procedure generation control unit, a data search unit that searches the database for data, and the data search unit matches the extraction conditions from the database. And a data processing unit that processes the data into a format that can be displayed on the screen after the data is acquired.

Further, in the database update procedure creation device of the present invention, the procedure creation control section is provided with means for storing the created procedure together with a table containing data relating to a series of processing operations.

[0009]

Next, the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram showing an embodiment of the present invention. Referring to FIG. 1, in the database update procedure creation device 1 according to the present invention, the procedure generation control unit 2 for controlling the entire device provides a standard database update processing procedure on the display of the terminal 13 by the GUI, and the user selects and inputs it. The data analysis unit 3 executes the analysis of the obtained data. At this time, when a data search of the database is required, the data search unit 4 recognizes the target database type. For example, when accessing the A database 9, the A database search unit 5 is used, and the B database 10 is searched. When accessing, the B database searching unit 6 is used. Similarly, when accessing the C database 11, data is acquired using the C database searching unit 7. The data of the search result is made displayable on the screen in the data processing unit 8, and when the database update procedure is created, the data extracted or processed according to the specified condition is displayed on the screen.

Further, the procedure control unit 2 completes the setting on each setting screen of the database update processing by the GUI,
When it is desired to save the series of processing performed up to that point, the procedure file 12 is output.

Next, the operation of the above-mentioned database update procedure creation device 1 will be described.

First, FIG. 7 shows a flowchart of main processing operations. In the figure, first, an initial screen is displayed on the screen (step 701), and either the creation or modification of a procedure is selected here (step 702). In the case of procedure modification, the procedure file to be modified is selected. It is opened (step 703), and the contents of the procedure file are read into the parameter table (on memory) (step 704).

Next, in the process selection screen shown in FIG. 2 (step 705), a process category is selected, and when the data update process is selected here (step 706), the data update process main screen shown in FIG. 3 is displayed. Display (Step 70)
7) If the data addition process is selected (step 70)
9) the data addition processing main screen shown in FIG. 4 is displayed (step 710), and when the data replacement processing is selected (step 712), the data replacement processing main screen shown in FIG. 5 is displayed (step 713). ), If the deletion process is selected, the data deletion process main screen shown in FIG. 6 is displayed (step 715).

In this way, the data updating process (step 7
08), data addition processing (step 711), data replacement processing (step 714), and data deletion processing (step 716) out of the four routine database update processing procedures, any of the procedure files can be created by the GUI (step 717).

FIG. 8 is a flow chart of a routine data updating process. Table selection setting (step 81), search condition setting (step 82), calculation processing setting (step 83), aggregation processing setting (step 84), distribution destination setting (step 8)
5), matching key setting (step 86), and update processing setting (step 87).

FIG. 9 is a flow chart of a standard data addition process. Table selection setting (step 91), search condition setting (step 92), calculation processing setting (step 93), aggregation processing setting (step 94), distribution destination setting (step 9)
5), each setting is performed in the order of additional processing setting (step 96).

FIG. 10 is a flow chart of a routine data replacement process. Each setting is performed in the order of table selection setting (step 101) and replacement processing setting (step 102).

FIG. 11 is a flow chart of typical data deletion processing. Each setting is performed in the order of table selection setting (step 111) and deletion processing setting (step 112).

Next, a specific processing flow of the data update processing will be described.

First, the data update processing main screen (FIG. 3)
When the table selection button (31) is selected with, the processing flow of the table selection setting shown in FIG. 12 is executed, and the table selection screen is displayed (step 1201). Then, select the database and table on which the data to be distributed is based on the screen (step 12).
02). When it is desired to display the data of the table specified here (step 1203), the data is displayed on the screen in response to the request (step 1204). If the processing on this table selection setting screen is confirmed (step 1205), the input contents are checked (step 1206), and if there is no problem, a value is set in the table selection information storage field (1901) of the parameter table shown in FIG. Settings (step 120)
7) Yes.

Next, referring to FIG. 3, search condition button (3
If 2) is selected, the flow of the search condition setting process shown in FIG. 13 begins, and the search condition setting screen is displayed first (step 1301). Then, the necessary columns are selected from the column list of the selection table and the extraction conditions are designated (step 1302).
When it is desired to display the data that meets the conditions specified here (step 1303), the data that meets the conditions is displayed on the screen in response to the request (step 1304). When the processing on this search condition setting screen is confirmed (step 1305), the input contents are checked (step 1
306), if there is no problem, a value is set in the search condition information storage field (1902) of the parameter table shown in FIG. 19 (step 1307).

Next, referring to FIG. 3, the calculation condition button (3
When 3) is selected, the processing flow of the arithmetic processing setting shown in FIG. 14 starts, and the arithmetic processing setting screen is first displayed (step 1401). Then, based on the column information selected on the search condition setting screen, arithmetic processing is set for the data to be distributed (step 1402). When it is desired to display the result of the distribution data when the arithmetic expression specified here is executed (staple 1403), the data subjected to the arithmetic processing in response to the request is displayed on the screen (step 1404). If the processing on the calculation processing setting screen is confirmed (step 140
5) Check the input contents (step 140
6) If there is no problem, a value is set in the calculation information storage field (1903) of the parameter table shown in FIG. 19 (step 1407).

Next, referring to FIG. 3, when the tally button (34) is selected, the flow of the tally process setting process shown in FIG. 15 starts, and the tally process setting screen is first displayed (step 15).
01). Then, an aggregation key is set based on the column information selected on the search condition setting screen, and settings necessary for aggregation are made (step 1502). If you want to display the distribution data of the aggregation result based on the aggregation key specified here (step 1503),
In response to the request, the data subjected to the totalization processing is displayed on the screen (step 1504). If the processing on this aggregation processing setting screen is confirmed (step 1505), the input contents are checked (step 1506), and if there is no problem, a value is set in the aggregation information storage field (1904) of the parameter table shown in FIG. (Step 1507)

Next, referring to FIG. 3, when the distribution button (35) is selected, the distribution destination setting process shown in FIG. 16 is executed.
First, the distribution destination setting screen is displayed (step 160).
1). Then, it is selected which table in which database the distribution data created in the above process is to be distributed (step 1602). When it is desired to display the table data contents of the distribution destination specified here (step 1603), the distribution destination table data is displayed on the screen in response to the request (step 16).
04). If the processing on this distribution destination setting screen is confirmed (step 1605), the input contents are checked (step 1606). If there is no problem, a value is set in the distribution destination information storage field (1905) of the parameter table shown in FIG. The setting is made (step 1607).

Next, referring to FIG. 3, a butt button (36)
If is selected, the flow of the matching key setting process shown in FIG. 17 is started, and the matching setting screen is first displayed (step 17
01). And the distribution data created in the process so far,
It is specified which column of the distribution destination table is used as a key to match (step 1702). If the process on this matching key setting screen is confirmed (step 1703), the input contents are checked (step 1704), and if there is no problem, a value is set in the matching key information storage field (1906) of the parameter table shown in FIG. Setting (step 1705)
I do.

Next, referring to FIG. 3, the update processing button (3
When 7) is selected, the processing flow of update processing setting shown in FIG. 18 is entered, and the update processing setting screen is first displayed (step 1801). Then, the distribution data created in the process so far is specified in detail as to whether the record is to be replaced, added, or deleted according to the specified condition (step 1802). If the processing on this update processing setting screen is confirmed (staple 1803), the input contents are checked (step 1804), and if there is no problem, the update processing information storage field (19) of the parameter table shown in FIG.
A value is set to (07) (step 1805).

Finally, in FIG. 3, the procedure storage button (3
When 8) is selected, the contents of the update processing parameter file shown in FIG. 19 with a procedure file name are output as a procedure file (data update processing).

Data addition processing (FIG. 9) other than the data update processing described in detail above, data replacement processing (FIG. 10),
The data deletion process (FIG. 11) is also performed by the same process flow as described above with reference to FIGS. 20, 21, and 22, respectively.
Each procedure file can be created based on each parameter table shown in.

As described above, since the database update procedure creating device of the present invention provides each process setting screen in accordance with the standard procedure by GUI, the process content is clear and the correction is easy. Further, even if the database types are different, a database search unit is prepared for each database type and actually acquires data by SQL. Therefore, although these are hidden from the user, the table list of the database and the condition extraction data can be checked on the screen at any time when the procedure is created.

[0031]

Since the database updating procedure creating device of the present invention can create the database updating procedure according to the fixed order by the GUI, even a user who does not have specialized knowledge such as SQL language can create and modify the database updating procedure.

Further, while the database update procedure is being created, the table list and data of the database to be used can be referred to on the screen, and the data of the extraction result by the search condition and the data of the calculation / totalization result for the condition extracted data can be displayed Since it can be confirmed above, the user can create a procedure while thinking about the problem.

[Brief description of the drawings]

FIG. 1 is a block diagram showing an embodiment of the present invention.

FIG. 2 is a processing selection screen.

FIG. 3 is an update processing main screen.

FIG. 4 is a main screen of additional processing.

FIG. 5 is a replacement processing main screen.

FIG. 6 is a deletion processing main screen.

FIG. 7 is a flowchart showing an outline of processing operation.

FIG. 8 is a flowchart of the update process on the screen.

FIG. 9 is a flowchart of the addition processing on the screen.

FIG. 10 is a flowchart of the replacement process on the screen.

FIG. 11 is a flowchart on the screen of a deletion process.

FIG. 12 is a flow chart of processing on a table selection screen.

FIG. 13 is a flowchart of processing on a search condition setting screen.

FIG. 14 is a flowchart of the process on the calculation process setting screen.

FIG. 15 is a flowchart of the processing on the totalization processing setting screen.

FIG. 16 is a flowchart of processing on a distribution destination setting screen.

FIG. 17 is a flowchart of the process on the matching key setting screen.

FIG. 18 is a flowchart of the processing on the update processing setting screen.

FIG. 19 is an explanatory diagram of an update processing parameter table.

FIG. 20 is an explanatory diagram of an additional processing parameter table.

FIG. 21 is an explanatory diagram of a replacement processing parameter table.

FIG. 22 is an explanatory diagram of a deletion processing parameter table.

[Explanation of symbols]

 1 database update procedure creation device 2 procedure generation control unit 3 data analysis unit 4 data search unit 5 A database search unit 6 B database search unit 7 C database search unit 8 data processing unit 9 A database 10 B database 11 C database 12 procedure file 13 terminals

Claims (2)

[Claims] 1. A procedure generation control section for controlling a series of processing operations to be performed by using a GUI when creating a procedure for performing a routine database update process, and each processing setting screen displayed by the procedure generation control section. A data analysis unit that analyzes the input contents of the data, a data search unit that searches the database for data, and a data display unit that acquires data matching the extraction condition from the database by the data search unit and displays the data in a format that can be displayed on the screen. A database update procedure creation device comprising a data processing unit for processing data. 2. The database update procedure creation device according to claim 1, wherein the procedure creation control unit comprises means for storing the created procedure together with a table containing data relating to a series of processing operations. Update procedure creation device.