JPH0433026A - Database index definition method - Google Patents

Abstract

PURPOSE:To improve operability and workability for defining an index by selecting a column to define the registration work of the column constituting the index with an operation on a display screen, and adding an index identifier in the case of deciding and registering the order of the columns according to the order of the selection. CONSTITUTION:The index constituting columns as the index definition objects are registered while displaying the table constituting column names of a data base table on a display screen 40 and selecting the columns on the display screen 40, and the column order of index constituting columns 43 is decided according to the order of selecting the columns. On the other hand, the defined index constituting columns 43 are registered after adding an index identifier 42 and the registered condition is displayed by the index identifier 42 to confirm the registration. Thus, the index constituting columns 43 can be easily registered and especially in the case of defining the index constituting column 43 composed of plural columns, the order of the registration can be easily decided.

Description

[Detailed Description of the Invention] [Industrial Application Field] The present invention relates to a database index definition method,
In particular, when columns that serve as an index for searching data from a database are defined in a table structure, the selection and ordering definition of each column composing the index can be easily registered and modified. This article relates to a database index definition method that allows for

[Conventional technology]

In a database system that organizes and accumulates a large amount of data, an index is provided to search for desired data. As this index, for example, a column name specifying a column of a database can be used. The columns that make up the index are also defined in the table structure, and the index constituent columns are specified.

Conventionally, this type of index definition method for specifying index composition columns has not been done by selecting from the table composition columns of the database table, but for example, by directly specifying the column names, or by specifying the table composition columns. Create a layer that can uniquely identify each column, enter a number in that layer, select the column corresponding to the column from the input number, and determine the order of the columns by the number, and create an index composition column. This is done in a way that defines

[Problem to be solved by the invention]

By the way, the conventional index definition method as described above has the problem that it takes a lot of time to specify the index constituent columns, so it takes a lot of time to define the index, and it is not efficient. .

An object of the present invention is to provide a database index that facilitates the registration of index constituent columns, and in particular, facilitates the operation of determining the registration order when defining index constituent columns consisting of a plurality of columns. The purpose is to provide a definition method.

[Means to solve the problem]

In order to achieve the above purpose, an index definition method is used in which columns that serve as indexes for searching database data are defined in a table structure. Displayed on the display screen, select table configuration column names to be defined by the selection instructions on the display screen using a pointing device, determine the column order of the columns that make up the index based on the selection order, and select the selected columns in the selection order. It is characterized by arranging them, adding index identifiers, registering index constituent columns, and displaying the registration status of the registered index constituent columns.

[Effect]

According to the above means, the index constituent columns to be index defined are registered by displaying the table constituent column names of the database table on the display screen and making selections on the display screen, and the index constituent columns are registered according to the selection order of column selection. Determine column order. In addition, the defined index configuration column is registered with an index identifier added,
To confirm the registration, the registration status is displayed using the index identifier. This way, if you need to make any corrections,
The index configuration columns are displayed using the index identifier, and then the index configuration columns are modified.

That is, the registration of index constituent columns for defining a database index is performed by sequentially selecting columns to be defined on the display screen. The column order of the index constituent columns is determined by the selection order. This makes it easy to select columns to be defined as index constituent columns. When registering the selected column as an index constituent column, do so by adding an index identifier.

Further, since the selection operation is performed by displaying the table constituent columns of the database table on the display screen and selecting them from the display screen, it is possible to prevent the column selected as the index constituent column from not existing in the database table.

The index definer can display the registration status of the index constituent column by specifying the index identifier.
While checking this, continue or modify the registration,
Decide on the final index to be defined. This results in
Index definition operability 9 Improves work efficiency.

〔Example〕

Hereinafter, one embodiment of the present invention will be specifically described using the drawings.

FIG. 1 is a flowchart showing an example of the processing procedure of index definition processing of the database index definition method according to an embodiment of the present invention.

To explain the index definition process with reference to Figure 1,
First, in step 11, column names of the table to be index defined are read.

This is the part that reads the information necessary for index definition processing. The necessary information here is the column name of a column (table configuration column) of a database table that is a table expressed as database data (a table that stores data). Next, the column names of the table constituent columns for which the index definition is to be read in step 12 are displayed on the screen of the display device, and are displayed to the person defining the influenza virus.

Next, in step 13, a process of starting the definition of the index file is performed. For example, the person defining the influenza virus inputs the influenza virus identifier, specifies the influenza virus to be defined, and starts the process of defining the influenza virus.

Next, in step 14, columns forming the index are selected from the table structure columns displayed on one display screen. The selected column is registered as an inch frame constituent column with an inch frame identifier added thereto.

This selection process is performed, for example, by the influenza definer selecting each column name from the table constituent column names displayed on the display screen using a pointing device or the like. Then, in the next step 15, the columns constituting the index are displayed in the order in which they were selected and registered.

In the next step 16, it is determined whether or not the influenza definition has been completed. If the influenza definition has not been completed yet, the process returns to step 14 and the processing from step 14 is repeated. In addition, when the influenza virus definition is to be terminated, when the influenza virus definer notifies the end of the registration of the influenza virus composition columns, this is determined in step 16, and the entire process of the influenza virus definition is terminated.

The order of the columns constituting the defined index depends on the order displayed in the process of step 15.

FIG. 2 is a block diagram illustrating an example of the system configuration of an inch fever definition processing device that implements the inch fever definition method of the present invention in one aspect.

In FIG. 2, 1 is the computer main body, 2 is a terminal display, 3 is a terminal input device, 4 is an external storage device, 5 is a central processing unit in the computer main body, 6 is a main memory in the computer main body, 7
is a database.

As shown in Figure 2, the configuration of the influenza fever definition processing device includes a terminal display 2 for displaying definition information to the influenza fever definer, and a terminal input device including a pointing device for inputting necessary information by the influenza fever definer. A device 3, an external storage device 4 in which programs and the like are stored, and a database 7 are connected to a computer main body (CPU) 1. The computer main body 1 includes a central processing unit 5 for executing the program for the inch fever definition process.
and a main memory 6 used as a work area for program execution.In this computer main body 1, the influenza definition process described in the above-mentioned processing flow (FIG. 1) is executed.

Next, a specific example of the database index definition process executed here will be explained by showing an example of a display screen on a terminal display.

FIG. 3 is a diagram showing an example of a start screen for the influenza virus definition process. As shown in FIG. 3, on the display screen of the terminal display 2, a start screen 30 for the inch file definition process is displayed with "define, modify, delete inch file" displayed in the title column at the top of the screen. At the bottom of the screen, if there is an index already defined, the definition method index is displayed in an index list 32, and an index identifier input field 33 is opened. Using this start screen 30, the index file definer can
2, look at the contents of the registered index list displayed in 2, and enter, for example, r as the index identifier of the newly defined index identifier in the index identifier input field 33.
Input 1ndex I J as the index identifier defined here.

FIG. 4 is a diagram illustrating an example of the influenza system configuration column registration processing screen of the influenza system definition process. As shown in FIG. 4, on the display screen of the terminal display 2, there is an index structure column registration processing screen 40 with "Index structure column approval, modification" displayed in the title field at the top of the screen.
is displayed, and the registration process for the input file configuration columns is performed.

At the top of this registration process screen 40, an index identifier input field 42 is opened, and the index identifier RINDEX IJ that has already been input is displayed here, and the index identifier column defined by this index identifier is entered in the index identifier input field 43. will be displayed. The index file definer looks at the displayed content of the displayed index file structure column field 43 and confirms the registered content, and if the contents of the displayed index structure column include an undesired index structure column, performs correction processing. and re-register.

FIG. 5 is a diagram showing an example of a column name display screen for table configuration columns to be defined. As shown in FIG. 5, a column name display screen 50 is displayed on the display screen of the terminal display 2, with "Display column name of table" displayed in the title column at the top of the screen. , all table structure columns 22 of the table structure columns for which indexes are defined are displayed. The index definer uses a pointing device to sequentially designate and select desired table structure columns from among the table structure columns 22 displayed here. Through such a selection operation, column selection of table constituent columns for which an index is to be defined is performed, and the index constituent columns are registered in the selected order.

FIG. 6 is a flowchart illustrating an example of a processing procedure for modifying an index constituent column defined as an index.

To explain the process of modifying index constituent columns with reference to FIG. 6, first, in step 61, a process of displaying the registered index is performed, and the index identifier corresponding to the index constituent column that has already been defined and registered is displayed. do. Next, in step 62, processing is performed to select an index to be modified. As a result, the index to be modified is selected from the displayed index identifiers.

In the next step 63, processing is performed to display the columns constituting the selected index. That is, the index constituent columns are displayed on the screen based on the index identifier.

Next, in step 64, the order of each of the index constituent columns constituting the index is changed.

Performs processing such as adding and deleting columns, and performs processing to modify index composition columns. Then, in the next step 65, the index constituent columns forming the index resulting from the correction are displayed. As a result, the index configuration columns that make up the index reflecting the correction processing here are displayed, and the column configuration of the index is displayed.

In the next step 66, it is determined whether or not the modification of the index constituent columns of the index to be modified has been completed. If the modification or change has not been completed yet, the process returns to step 64 and the processing from step 64 is performed. Repeat.

Further, when the modification processing is completed, when the index definer notifies the completion of the modification processing of the index constituent columns, this is determined in step 66 and the modification processing of the index constituent columns is ended.

FIG. 7 is a diagram showing an example of a start screen for index correction processing. As shown in FIG. 7, a start screen 70 for performing index correction processing is displayed on the display screen of the terminal display 2, with "Index Definition, Modification, and Deletion" displayed in the title column at the top of the screen. Ru. This start screen 70 is the same as the start screen 30 when performing index definition processing. On the start screen 70 of this correction process, the index identifier rin of the registered index that has already been input and registered in the index list 32 is displayed.
dex 1 , 1ndex 2 , 1ndex 3 ,
− J is displayed and the index identifier input field 3 is displayed.
3 will be opened. This index identifier field 3
In step 3, input the index identifier for which correction processing is to be performed.

In this case, if the index identifier input into the index identifier input field 33 as described above is not displayed in the index list 32.

This is used to input an index identifier for registering a new index. In this case, registration processing is performed.

Here, for example, the index identifier rindex 2 J displayed in the index list 22 is input into the index identifier field 33 as the index identifier of the index to be modified.

FIG. 8 and FIG. 9 are diagrams showing an example of an index configuration column correction processing screen. As shown in FIG. 8, an index configuration column correction processing screen 8o is displayed on the display screen of the terminal display 2, with "Index configuration column registration and modification" displayed in the title field at the top of the screen. Column correction processing is performed. This correction processing screen 80 is the same as the registration correction processing screen 4o for the index configuration columns described above. This screen 80
The index identifier input field 42 contains the index identifier input field 33 of the correction processing start screen 70.
The index identifier rindex 2 J of the index entered in and subject to modification is displayed, and the index configuration column indicated by this index identifier rindex 2 J is displayed in the index configuration column field 4.
3. The index definer looks at the displayed content of the displayed index configuration column field 43 and modifies the index configuration column configuration. Additionally, as part of the modification process, unnecessary columns from the index constituent columns are deleted. Then, the result of the modification is determined by looking at the final display contents of the index configuration column field 43.
Confirm the modification details, re-register, and finish the index configuration column modification process. For example, as shown in FIG. 9, the display contents of the modified index structure column field 43 are the same as the display contents of the index structure column field 43 on the screen of FIG. The state of the index composition column field 43 on the screen shown in FIG. 9 is corrected (column E, column C, and column B are displayed as index composition columns) by performing correction processing from the state shown in FIG. .

As explained above, the main parts of the in-desk definition method for defining and modifying index constituent columns according to this embodiment are summarized as follows.

The index configuration column registration process that defines an index involves (1) reading the table configuration column names of the database table, (2) displaying the read table configuration column names, and (3) attempting to define them. (4) Select the table constituent column names displayed on the display screen in sequence with a pointing device, and select the index constituent columns that constitute the index according to the selection order. The process of determining the column order and registering the index, and (5) the process of displaying the registration status of the index constituent columns are performed in sequence.

In addition, in the process of modifying the defined index configuration column, (6) processing to display the index identifier added to the index configuration column of the target index to be modified, and (7) column configuration using the displayed index identifier. (8) Processing of displaying the registration status of the index configuration column of the index to be modified using the selected index identifier; (9) Displaying the displayed index configuration column (10) Using a pointing device, select a column to be deleted from the displayed index configuration columns and delete the column from the index configuration columns; (11) Table configuration of the database table. (12) Displaying the read table configuration column name; (13) Selecting the displayed table configuration column with a pointing device and adding the column to the columns that make up the index. Processing and are performed sequentially.

The present invention has been specifically described above based on examples, but 1.
It goes without saying that the present invention is not limited to the embodiments described above, and can be modified in various ways without departing from the spirit thereof.

〔Effect of the invention〕

As described above, according to the present invention, the index constituent columns can be determined by selecting from the table constituent columns, so it is possible to prevent a mismatch in which a column specified as an index constituent column does not exist in the table. can.

In addition, multiple types of indexes are registered in the order of column selection,
Index definition is easy.

[Brief explanation of drawings]

FIG. 1 is a flowchart showing an example of the processing procedure of an index definition process of a database index definition method according to an embodiment of the present invention, and FIG. 2 is an index definition that implements the index definition method of the present invention in one aspect. A block diagram illustrating an example of the system configuration of the processing device; FIG. 3 is a diagram illustrating an example of a start screen for index definition processing; FIG. 4 is a diagram illustrating an example of an index configuration column registration processing screen for index definition processing. , FIG. 5 is a diagram showing an example of a column name display screen for table configuration columns to be defined. FIG. 6 is a flowchart showing an example of a processing procedure for modifying an index constituent column defined as an index; FIG. 7 is a diagram showing an example of a start screen for index modification processing; FIGS. 8 and 9 are: FIG. 3 is a diagram illustrating an example of an index configuration column correction processing screen. In the figure, 1... Computer main body, 2... Terminal display, 3... Terminal input device, 4... External storage device, 5...
... Central processing unit, 6... Main memory, 7... Database, 22... Table configuration columns, 30... Index definition processing start screen, 32... Index list,
33.42...Index identifier field, 4
0... Index configuration column registration processing screen, 43...
- Index configuration column field, 50-- Column name display screen, 30... Index correction processing start screen,
80... Index configuration column correction processing screen.

Claims (1)

[Claims] 1. An index definition method that defines columns that serve as indexes for searching database data in a table structure, reads the table structure column names to be index defined, and displays the read table structure column names on the display screen. Then, in accordance with the selection instructions on the display screen using the pointing device, select the table constituent column names to be defined, determine the column order of the columns that make up the index according to the selection order, arrange the selected columns in the selection order, and assign the index identifier. A database index definition method characterized by further registering index constituent columns and displaying the registration status of the registered index constituent columns.