JPH1173350A - Method and system for constructing and updating relational database system having image processing function - Google Patents

Abstract

PROBLEM TO BE SOLVED: To reduce the occurrences of work mistakes at the time of organization and updating and to improve work efficiency, productivity and maintainability by simulatively and visibly representing the images of a table before and after updation. SOLUTION: Whether a table to be an object is a new one or an existing one is inputted and selected from an input device 100, and in the case of the existing one, an RDIR 310 is retrieved to show a list of existing tables and selection is performed by the device 100. A selection table performs image display on a display. In the case of updating, a final image is simulatively constructed with the means 100 about how to change the table and how to produce if it is a new one and is shown as an image on a displaying means 220. In the case of updating and organization without more change, how different which part of the table that is shown as an image is analyzed. A table is organized and updated by automatically performing retrieval, creation and execution of a DDL sentence group that is needed to produce the table which is simulatively organized based on the analysis result.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

The present invention relates to a method for constructing and updating a relational database system, and more particularly to a method and system for constructing and updating a relational database system capable of simulated and visible image processing.

[0002]

2. Description of the Related Art Conventionally, a relational database system of this type is constructed and updated by a large number of DDL statements (data definition language, Data Description).
Language) was required. When changing the layout of a table, the index definition, usage right transfer definition,
Delete the virtual table definition, trigger definition, etc., and then delete and redefine the table definition. After that, a procedure of re-defining the previously deleted index definition, usage right transfer definition, and the like is performed. In each process, a definition DDL statement must be created.

[0003]

As described above, the conventional method of constructing and updating a relational database system has the following problems.

[0004] The first problem is that a large number of DDL sentences must be created.

[0005] The reason is that even if only one table is defined, at least a DB file definition, a storage definition,
Table definition, index definition, usage right transfer definition 5
This is because a statement is required. If this is a redefinition, a DDL statement for definition deletion is added, and more DDs are added.
L sentence is required.

A second problem is that it is not clear what DDL statement is required for updating.

The reason is that, depending on the contents of the update, for example, whether only the index definition needs to be changed or whether all the definitions need to be changed is required.
This is because the sentences are different.

Accordingly, the present invention has been made in view of the above-mentioned problems, and has as its object to eliminate the trouble of manually creating a DDL sentence, to improve work efficiency and operability, and to improve visual efficiency. It is an object of the present invention to provide a relational database system construction / update method and method for improving maintainability by performing actual update after confirmation.

[0009]

In order to achieve the above object, a method for constructing / updating a relational database system according to the present invention comprises the steps of: (a) updating an image of a table or newly constructing a table based on information input from input means; (B) when an instruction to update and construct a table according to the displayed image is input, analyze the simulated image; A DDL sentence group necessary for creating the simulated table is automatically searched and generated from the analyzed result.

[0010] The construction / update method of the relational database system according to the present invention comprises a table image creation means for creating an update / construction image of a table by input means, and a table image for analyzing the image created by the table image creation means. An analysis unit; and a DDL sentence creating unit that searches and creates a DDL sentence group required for updating / constructing from a result analyzed by the table image analyzing unit.

[Summary of the Invention] In the present invention, a table image creating means (230 in FIG. 1) for simulating which part of the relational database is to be changed and how to update the image of the table, A table image analysis means (240 in FIG. 1) for analyzing the updated table image, and a DDL sentence for searching for a DDL sentence necessary for creating the updated table and automatically creating the DDL sentence It has a creating means (250 in FIG. 1).

According to the present invention, the image of the table before the update is displayed on the display, and the image when the update is performed by the table image creating means is simulated on the display. This is displayed visually, and the user does not need to be aware of the DDL sentence.

The difference between the simulated displayed image and the actual table is analyzed by the table image analyzing means.

As a result of the analysis, a DDL sentence group necessary for creating a simulated table is automatically searched and created. For this reason, the creator can carry out operations and operations without being aware of the amount or type of the DDL sentence at all.

[0015]

Next, the configuration of an embodiment of the present invention will be described in detail with reference to the drawings.

FIG. 1 is a block diagram showing a configuration of an embodiment of the present invention. In FIG. 1, reference numeral 100 denotes input means such as a keyboard and a mouse, and reference numeral 200 denotes a data processing device that operates under program control. Reference numeral 300 denotes a relational database already built on a magnetic disk or an electronic disk, and reference numeral 400 denotes an output device such as a display. Relational database 300
, 310 is a directory file having a “system table” for managing all definition information of the relational database system, and 320 is a database file storing actual table data.

The data processing device 200 includes a table selecting means 210, a display means 220, a table image creating means 230, a table image analyzing means 240, a DDL sentence creating means 250, and an executing means 260.

The table selecting means 210 is provided with the input means 10
It is determined by searching the directory file (RDIR) 310 whether the table name input by “0” already exists. The input table name is RDIR310
, All the definition information relating to the table is selected (selected) from the RDIR 310.

The display means 220 visually displays the selected table on the output device 400 based on the related definition information.

The table image creating means 230 inputs the final image as to how the table is actually changed and what kind of table is to be created when newly constructing the table. Based on the input information from 100, the table is constructed simulated, and the image of the simulated table is displayed on the display means 220.

The table image analysis means 240 analyzes which part of the table simulated by the table image creation means 230 differs from the table actually constructed, and how.

The DDL sentence creating means 250 automatically creates a DDL sentence group necessary for creating a table simulated by the table image creating means 230 based on the result analyzed by the table image analyzing means 240. Search / Create.

The execution means 260 includes the DDL statement creation means 25
With 0, the created DDL statement is actually executed to build and update the table.

FIG. 2A is a diagram for explaining a processing flow according to the embodiment of the present invention. Next, the operation of the embodiment of the present invention will be described with reference to FIG. 1 and FIG.

Whether the target table is new or existing is input from the input means 100 and selected (step 211).

For an existing table, RDIR 310
To display a list of existing tables (step 212), and select from the list via the input means 100 (step 213). At this time, all the definition information relating to the selected table is selected from the RDIR 310, and based on this information, the selected table is displayed as an image (step 221).

On the other hand, if it is determined in step 211 whether or not the table has been registered, in the case of a new table, the table name is input from the input means 100, and no image is displayed at this stage.

The table image creation means 230 inquires whether or not to update or newly construct a table (step 231). When updating, how to actually change the table is described. In the case of newly constructing, what kind of table is desired to be constructed, a final image is constructed simulated by the input means 100 (step 232), and expressed by the display means 220 (step 233).

Next, as in the image displayed on the display means 220, it is inquired whether or not to update (or newly construct) (step 241). If there is a change, the processing from step 231 is repeated.

If it is determined in step 241 that there is no change and update / construction is performed according to this image, the table image analysis means 240 determines which table is displayed in step 221 and which table is displayed in step 233. The differences are analyzed for how the parts differ (step 242).

The DDL sentence creating means 250 executes step 24
Based on the analysis result of step 2, a DDL sentence group required to create the table simulated in step 232 is automatically searched and created (step 251).

The DDL created in step 251
The statement is actually executed by the execution means 260 to construct and update the table (step 261). Note that the above processing steps may be realized by control of a program executed by the data processing device 200.

[0033]

BRIEF DESCRIPTION OF THE DRAWINGS FIG. 1 is a block diagram showing an embodiment of the present invention; FIG.

In FIG. 1, reference numeral 100 denotes an input device such as a keyboard and a mouse, and reference numeral 200 denotes a data processing device that operates under program control. Reference numeral 300 denotes a relational database already built on a magnetic disk or an electronic disk, and reference numeral 400 denotes an output device such as a display. Reference numeral 310 denotes a directory file having a “system table” for managing all definition information of the relational database system, and 320 denotes a database file having actual table data.

The table selecting means 210 is provided with the input means 10
It is determined whether or not the table name input by “0” already exists by searching the RDIR (directory file) 310. If the table is an existing table, all the definition information related to the table is selected from the RDIR 310.

The display means 220, based on the related definition information,
The selected table is visually represented, for example, as shown in FIG. FIG. 2B shows a display image of the selected table.

The table image creating means 230 determines how to actually change the table,
In the case of newly constructing, what kind of table is desired to be created, a final image is simulated by the input means 100, and the final image is displayed by the display means 220, for example, as shown in FIG.
Expressed as shown in (C). FIG. 2C is a diagram showing a display image of a simulated table.

The table image analysis means 240 compares the table (see FIG. 2C) simulated by the table image creation means 230 with the actually constructed table (see FIG. 2B). And analyze how they differ.

The DDL sentence creating means 250 creates a table (see FIG. 2C) simulated by the table image creating means 230 based on the result analyzed by the table image analyzing means 240. The required DDL sentence group is automatically searched and created.

The execution means 260 includes the DDL statement creation means 25
0 is actually executed to actually construct and update the table (see FIG. 2C).

Next, the operation of one embodiment of the present invention will be described with reference to FIGS.

Whether the target table is new or existing is inputted from the input device 100 and selected (step 211). If the table is an existing table, a list of existing tables is displayed by searching the RDIR 310 (step 212), and the table is selected from the list by the input device 100 (step 213). At this time, all the definition information relating to the selected table is selected from the RDIR 310, and based on this, the selected table is changed to the one shown in FIG.
As shown in (B), an image is displayed on the display (step 221). On the other hand, in the case of a new table, the table name is input from the input device 100, and no image is displayed at this stage.

An inquiry is made as to whether the table is to be updated or newly constructed (step 231). When the table is to be updated, how to actually change the table is described.
In addition, in the case of newly constructing, what kind of table is desired to be created, a final image is simulated by the input means 100 as shown in FIG. 2C, for example (step 232). The created table is displayed as an image on the display means 220 (step 22).
2).

Referring to FIG. 2C, table item W
, The item V is deleted, and the item Z is expanded in record size.

Next, as displayed on the display means 220 (see FIG. 2C), an inquiry is made as to whether the table is to be updated or constructed (step 241). If there is a change, the operation from step 231 is started. repeat.

In the inquiry of step 241, when there is no change and, for example, as shown in FIG. 2C, the table is updated and constructed, the table (see FIG. 2B) displayed in step 221 and the step 222 are displayed. In the table (see FIG. 2 (C)) displayed as an image, what part is different and how is analyzed (step 242). That is, the table image analysis means 240
In the analysis, it is analyzed that the items W, V, and Z change as described above.

Based on the analysis result of step 242, a DDL sentence group required to create a table (see FIG. 2C) simulated in step 232 is automatically searched and created ( Step 251).

The DDL created in step 251
The statement is actually executed to construct and update the table (step 261).

[0049]

As described above, according to the present invention, the following effects can be obtained.

The first effect of the present invention is that it is possible to simulate and visualize which part of a relational database is to be changed and how the image of the table before and after the update is performed. In this case, it is possible to reduce the occurrence of work mistakes and to improve work efficiency, productivity, and maintainability.

The reason is that, in the present invention, actually,
The image after construction / update is not created by DDL statements,
This is because it can be grasped visually. In addition, this is because the actual update is performed after confirming the image once.

A second effect of the present invention is that a DDL sentence is automatically searched for and automatically generated, whereby actual updating can be performed without being conscious of the type and amount of the required DDL sentence. Improving efficiency and productivity.

The reason is that, in the present invention, the difference between the table image of the simulated update table and the table image of the existing table is analyzed, and a DDL statement for creating the update table is searched and automatically generated. It depends.

[Brief description of the drawings]

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

FIG. 2A is a flowchart illustrating a processing flow according to an embodiment of the present invention. (B) is a diagram for explaining an embodiment of the present invention, and is a diagram showing an example of an image display of a selected table. (C) is a diagram for describing an embodiment of the present invention, and is a diagram illustrating an example of an image display of a simulated table.

[Explanation of symbols]

 REFERENCE SIGNS LIST 100 input device (keyboard) 200 data processing device 210 table selection means 220 display means 230 table image creation means 240 table image analysis means 250 DDL sentence creation means 260 execution means 300 storage device 310 directory file 320 database file 400 display

Claims (6)

[Claims] 1. An image of a table update or a newly constructed table is simulated based on information input from an input unit, and the created image is displayed on a display unit. (B) According to the displayed image, Update table
When an instruction to construct is input, the simulated image is analyzed, and a DDL (data definition language) required to create the simulated table from the analyzed result is created. ) A method for constructing and updating a relational database system, which automatically searches and generates sentences. (A) If the target table is a table registered in a database, the table is displayed as an image on a display means based on definition information on the table, and (b) updated or newly updated. Information on a table to be constructed is input, and a table to be updated / constructed is simulated based on the information, and this is displayed on a display means as an image. (C) The table is displayed as the simulated image. Inquires the user whether to update or build the table. (D) If there is a change, repeat the above steps (b) and (c)
(E) When updating and constructing the table according to the simulated image, the simulated image is analyzed. At this time, if an existing table exists, Analyzing the difference between the image before the update displayed in the step (a) and the image after the update displayed in the step (b), (f) creating the simulation based on the result of the analysis Searching and automatically creating a DDL (data definition language) statement group necessary to create a table of the created image; and (g) executing the created DDL statement to update / construct the table. A method for constructing and updating a relational database system. 3. A table image creating means for creating an image for updating and constructing a table based on information input from an input means, a table image analyzing means for analyzing an image created by the table image creating means, and the table. A relational database comprising: a DDL (data definition language) sentence group necessary for updating / constructing the table from a result analyzed by the image analyzing means; System construction / update method. 4. The relational database system according to claim 3, further comprising means for actually executing the DDL statement created by said DDL statement creating means to construct and update said table. method. 5. A means for constructing / updating a relational database system, comprising: (a) table image creating means for creating an image for updating and building a table based on input information; and (b) said table. A table image analyzing means for analyzing the image created by the image creating means, and (c) a DDL necessary for updating / constructing the table from a result analyzed by the table image analyzing means.
DDL that searches and automatically creates sentences (data definition language) group
A recording medium on which a program for causing a computer to function each of the above (a) to (c) is described. (A) when the target table is a table already registered in the database, a process of displaying the table on a display means based on definition information relating to the table; (b) updating or updating the table; A process of inputting information relating to a table to be constructed to the user, simulating a table to be updated / constructed based on the information, and displaying the simulated table on the display means, and (c) the simulated image. (D) processing for inquiring the user whether to update or construct the table as described above, (d) processing for shifting to the processing of (b) again when there is a change, (e) according to the simulated image When the table is updated and constructed, the simulated image is analyzed. At this time, if there is an existing table, the image displayed in the step (a) is displayed. A process of analyzing a difference between the image before update and the image after update displayed in the step (b); (f) a process of analyzing the simulated image based on the result of the analysis in (e). D required to create a table
(G) a process of searching and automatically creating a DL (data definition language) sentence group; and (g) a process of executing the created DDL sentence to update / construct the table. A) a recording medium on which a program for causing each of the processes of the above to function by a computer is recorded.