JPH0789333B2 - Database control method - Google Patents

Description

The present invention relates to a database control method, and more particularly to an end user interface for searching a structured database.

[Conventional technology]

As a method of searching data in a structured database,
As shown in Japanese Patent Application Laid-Open No. 57-109050, a logical configuration diagram of a database is displayed on the display screen, and it is used as a guide when inputting a search command in order to output data required by an operator.

[Problems to be solved by the invention]

However, in this method, although the guide is displayed, the operator cannot obtain the necessary data unless the search procedure is sequentially performed according to the structure of the structural database.

The object of the present invention is to solve the problems of the prior art.

[Means for solving problems]

A means is provided in which the edited format is registered in the table format of the data to be output, and the data is read from the database and displayed in accordance with the specified registered format.

[Action]

A person who searches the database can edit the output format once and input it, and then simply specify the format to obtain desired data regardless of the structure of the database.

〔Example〕

Next, an embodiment of the present invention will be described with reference to the drawings. First
FIG. 1 is a schematic configuration diagram of a computer system to which the present invention is applied. The central processing unit 1 includes a processing unit 2 that performs processing according to a program stored in the memory 3, and a memory 3 that stores the program and various data. The external storage device 4 is accessed as the program is executed, and stores a database and other data. A processing request is issued to the program from the terminal device 5, and the processing result of the program and an instruction to the operator are displayed on the terminal device 5.

In such a system, a data dictionary having database definition information is stored in the external storage device 4 as shown in FIG. 2a, and a database shown in FIG. 3 is stored. In the present invention, table definition information including table information 21 described later in detail and column information 22 showing details of the table is stored.

The creation of this table definition information and the control of the display of the table using this will be described.

First, the creation of table definition information will be described. First
4a and 4b are flowcharts of a program included in the central processing unit 1, and the control is performed by this execution. FIGS. 5a and 5b show the transition of the display screen of the terminal device 5 in creating the table definition information. First, a process of inputting a database name is performed (401). At this time, the guidance shown in Japanese is displayed on the screen 51, and each name in English is keyed in. This is sent to the center side and input. Then, according to this, the records constituting the database are displayed like the screen 52 (402). If there is no target record and nothing is selected by the operator, the process returns to step 401, and the operator sets ZAI as shown in the figure.
When KOREC is selected and the Y mark is keyed in at that position (403), the target record selection is recognized (404).
Recognizing the operator's instruction as to whether or not to make a table with only the target record (405), when NO, the directory regarding the direct owner record (parent record) of the target record is displayed as in the read screen 53 (406). Recognizing that SHOHINREC has been selected by the operator (407), the components of these records are displayed as in screen 54.
To explain the above in the database of FIG. 3, the inventory record was selected as the target record, and the merchandise record which is one of the owner records was selected next. In the screen 54, the upper two lines show the structure (format) of the components of the inventory record and the rest of the components of the commodity record, respectively. Since it is not possible to display the entire screen at once, scroll horizontally to display as shown by the dotted line. When it is necessary to edit a component (409) First, an operator adds a mark of "E" for deletion to the unnecessary component name on the screen. Then specify the order of the components. For example, "M" is a ZTY with a component named SNAME indicated by "T".
It is specified to be moved before the PE component. By reading this, the components are selected and rearranged (410). Then step 410 as on screen 55
Display the result edited in step 4 for operator confirmation (41
1). Since this is a format edit, only the directory is referenced, not the data. Therefore, it is displayed as a blank format. The operator looks at this and confirms whether or not the desired deletion rearrangement has been input, and inputs that effect. If the displayed format is acceptable (412), the definition information in the format of this table is created and registered (413). At this time, the operator is notified of the end of editing as shown in screen 56. In step 413, table information 21 and column information 22 are created and registered. Table information
21 stores the table name of the table created by the above processing, the Japanese name of the table, the password, the creation date, the creation time, the schema name, the number of records to be configured, the component name to be configured, and the like. The column information 22 is pointed to by the table information 21, and the relation information between the record information of the database forming the table and the record constituting the table, that is, the part storing the record name, the set name, and the definition information of two records, and the table The component information and editing format that make up each column in the table, that is, the record number, component name, column header, input / output width, attribute, presence / absence of repetition, and editing format (instructions such as adding a mark in the column) in the table It is composed of a part arranged in a column order and stored. This stores the format of the table as shown on screen 55. Table information 21 and column information 22
Is registered for one table.

By the above process, the table format arbitrarily designated by the operator is registered.

Next, the control for displaying the table of the registered formats will be described.

Table name ZAIK at the time of registration from terminal 5 as shown in screen 61
Enter O to indicate the display. The central processing unit 1 reads out the table information 21 and the like with this table name and displays the format of the registered table such as the screen 62. If the operator wants to obtain data for this table, he will key in "8" in the operation column. When the central processing unit 1 recognizes this, it searches the database of FIG. 3 by the registered record name, component name, etc. to obtain data, and displays it according to the format as a screen 63.

As described above, tabular output that has been arbitrarily edited regardless of the structure of the database can be obtained with a simple instruction. Once the table format is registered, it is not necessary to register again even if the data is updated.

〔The invention's effect〕

According to the present invention as described above, it is possible to obtain arbitrarily edited data in a structural database by a simple operation.

[Brief description of drawings]

FIG. 1 is a schematic configuration diagram of a computer system to which the present invention is applied, FIG. 2a is a diagram showing an example of a dictionary in the present invention, FIG. 2b is a diagram showing detailed examples of table information and column information, and FIG. Is a diagram showing an example of a database,
FIGS. 4a and 4b are flowcharts of table format registration control, FIGS. 5a and 5b are screen examples when registering a table format, and FIG. 6 is a screen example when displaying a table. 21 …… Table information, 22 …… Column information.

Front page continuation (56) Reference JP 59-95645 (JP, A) JP 61-15276 (JP, A) JP 56-90369 (JP, A) JP 59-180763 (JP , A) JEFFREY D. ULLMAN, Translated by Toshiyasu Kunii, Nobuo Ohbo "Computer Science Research Series 24 Principles of Database Systems" (SHO 60-5-25) Japan Computer Association PP. 115-149 “3 Network model and DBTG proposal” D. C. Tsichritisis, F.H. Lochovsky, translated by Tadao Saito "Computer Science Research Book Series 20 Database Management System" (SHO 54-11-25) Japan Computer Association P.P. 146-199 “Chapter 6 Network System” C. J. Date, J. Fujiwara, "Introduction to Database Systems" (SHO 59-1-30) Maruzen PP. 445-467 "26. DBTG data operation"

Claims (1)

[Claims] 1. A method of controlling a structural database in which a plurality of data records and components within the records are stored according to a structural structure, wherein a plurality of component names are selected from a target record and its parent record. The table definition information in a table format is organized, the structural database is searched in response to a search command based on the component name in the table definition information, and data corresponding to each component name is output according to the table format. A method of controlling a database characterized by: