JPH05298164A - Logical data structure design supporting device - Google Patents

Abstract

PURPOSE:To facilitate the data item selecting work by a designer by providing a subject attribute conversion supporting device presenting the candidates of subject data items convertible to the related subject data items to the designer. CONSTITUTION:A subject attribute conversion supporting device 3-5 retrieves other subject data item B whose correspondence relation to a subject data item A noticing all the subject data items stored in a logical data structure storage device 3-3 is 1:1 and displays the subject data A, B as attribute data conversion candidates on a display when the item B does not have other relation. When a designer 2 observes the display on the display and judges it as a matter to be converted, he gives the instruction of the conversion from an input device 3-1. The conversion supporting device 3-5 executes the conversion based on the instruction, displays the execution result on the display, and inputs and stores it in the logical data structure storage device 3-3.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a logical data structure design support device, and more particularly to a logical data structure design support device for a database in system design using a computer.

[0002]

2. Description of the Related Art FIG. 7 is a block diagram showing a conventional supporting device of this type, for example, the device disclosed in Japanese Patent Laid-Open No. 1-112467. In the figure, 1 is a logical data structure, 2 is a designer, 3 is a database design support device,
3-1 is an input device, 3-2 is a logical data structure editing device,
3-3 is a logical data structure storage device, 3-4 is an output device, the output device 3-4 has a display and a printer, and the display is combined with the input device 3-1 to form an interactive input device. .

When inputting the logical data structure 1 in the apparatus of FIG. 7, the designer 2 defines all the data items of the logical data structure 1 and the relation between each data item and other data items in a binary relation. Enter in the form. FIG. 8 is a format diagram showing an input example of the binary relation for the logical data item 1. These input data are stored in the logical data structure storage device 3-3. The logical data structure editing device 3-2 is connected to the same data item so as to be one point from the binary relation of the data items stored in the logical data structure storage device 3-3, and is networked. 3-4 Display on the display.

Next, the designer 2 inputs a main data item. The subject means that it becomes a unit of target data for handling information, and in the logical data structure 1, it is a department name, a project name, and an employee number. The logical data structure editing device 3-2 collects the main data item and the related data item into a group, and displays them as shown in FIG. The designer 2 observes this display and makes necessary corrections, and stores the networked and grouped logical data structure in the logical data structure storage device 3-3. However, what is shown in FIG. 9 is an example of a logical data structure, and there are various types of logical data structures, and the logical data structure editing devices 3-2 are different corresponding to the respective types of logical data structures. Edit.

[0005]

The above-described conventional logical data structure design support device is configured as described above, and the designer decides the data item to be the main subject by his / her own judgment. There is a problem in that the appropriateness of the logical data structure design varies.

The present invention has been made in order to solve such a problem, and is a main data element which is a basic constituent element in a logical data structure of a database and is a unit of object data for handling information. Supports the work of converting the attribute data items included in the subject data item that are related to the item, and the work of converting the attribute data items included in the subject data item to the subject data items that are related to the subject data item It is an object of the present invention to provide a logical data structure design support device that performs

[0007]

A logical data structure design support device according to the present invention is provided with a subject attribute conversion support device in a database design support device, and is a candidate for a subject data item that can be converted into a related subject data item. Is presented to the designer, and the designer is assisted so that the main data item can be appropriately selected.

Also, an attribute subject conversion support device is provided in the database design support device to present the designer with candidates of attribute data items that can be converted into related subject data items, and the data items for which the designer is the main subject are selected. The feature is that it helps to select appropriately.

[0009]

According to the present invention, the designer considers the candidate of the subject data item that can be converted into the attribute data item of the related subject data item and the candidate of the attribute data item that can be converted into the related subject data item. You no longer need to rely on your experience to find it.

[0010]

【Example】

Example 1. Embodiments of the present invention will be described below with reference to the drawings. FIG. 1 is a block diagram showing an embodiment of the first invention of this application. In the figure, the same reference numerals as those in FIG. 7 indicate the same or corresponding portions, and 3-5 is a subject attribute conversion support device. FIG. 3 shows the data input from the input device 3-1 and stored in the logical data structure storage device 3-3, and (3) of FIG. 3 represents all data items (in FIG. 3, not all data items but main data items). Figure 8 is a collection of
Equivalent to.

FIG. 5 is a flowchart showing the operation of the subject attribute conversion support device 3-5.
Finds another subject data item B having a correspondence of 1: 1 with respect to the subject data item A in which all the subject data items stored in the logical data structure storage device 3-3 are noted, and the item B is related to another subject data item B. If not, the subject data A and B are displayed on the display as attribute data conversion candidates.

FIG. 4A shows an example of this display. The designer 2 observes the display on the display, and when it determines that the conversion should be performed, gives the conversion instruction from the input device 3-1. The subject attribute conversion support device 3-5 executes conversion based on this instruction, displays the execution result on the display, and inputs and stores it in the logical data structure storage device 3-3.

Embodiment 2. FIG. 2 is a block diagram showing an embodiment of the second invention of this application. In the figure, the same symbols as those in FIG. 7 indicate the same or corresponding portions, and 3-6 is an attribute main body conversion device. FIG. 6 is a flow chart showing the operation of the attribute subject conversion device 3-6. For all subject data stored in the logical data structure storage device 3-3, the attribute data item S included in the subject subject data item A of interest is searched for. , As a conversion candidate, as shown in (2) of FIG. The designer 2 observes this display, and when it determines that conversion should be performed, gives a conversion instruction from the input device 3-1. The attribute-based conversion support device 3-6 executes the conversion based on this instruction, displays the execution result on the display, and inputs and stores it in the logical data structure storage device 3-3.

Although the first invention and the second invention have been separately described above, in the actual design, the first invention and the second invention are simultaneously executed, and the subject attribute conversion is performed in the database design support device 3. It goes without saying that the support device 3-5 and the attribute subject conversion support device 3-6 can be provided together.

[0015]

Since the logical data structure design support device of the present invention is constructed as described above, the following effects can be obtained.

When there is a subject data item that can be converted into an attribute data item of a related subject data item in the logical data structure, the device itself makes a candidate of the subject data item that can be converted by the designer. Therefore, there is an effect that the task of selecting the main data item can be easily and appropriately performed.

When there is an attribute data item that can be converted into an attribute data item of a related main data item in the logical data structure, the device itself gives the designer a candidate for the attribute data item. Since it is presented, there is an effect that the designer can easily and appropriately search for the existence of the data item that can be converted into the main data item.

[Brief description of drawings]

FIG. 1 is a block diagram showing an embodiment of a first invention of this application.

FIG. 2 is a block diagram showing an embodiment of the second invention of this application.

FIG. 3 is a diagram showing data stored in a logical data structure storage device of FIGS. 1 and 2.

FIG. 4 is a diagram showing data displayed on the output device of FIGS. 1 and 2.

5 is a flowchart showing the operation of the subject attribute conversion support device of FIG. 1. FIG.

FIG. 6 is a flowchart showing an operation of the attribute-based conversion support device in FIG.

FIG. 7 is a block diagram showing a conventional device.

FIG. 8 is a diagram showing an example of data input by the device of FIG.

9 is a diagram showing an example of a data structure edited by the device of FIG. 7. FIG.

[Explanation of symbols]

 1 Logical Data Structure 2 Designer 3 Database Design Support Device 3-1 Input Device 3-2 Logical Data Structure Editing Device 3-3 Logical Data Structure Storage Device 3-4 Output Device 3-5 Subject Attribute Conversion Support Device 3-6 Attributes Subject conversion support device

─────────────────────────────────────────────────── ───

[Procedure amendment]

[Submission date] July 28, 1992

[Procedure Amendment 1]

[Document name to be amended] Statement

[Correction target item name] 0007

[Correction method] Change

[Correction content]

[0007]

A logical data structure design support apparatus according to the present invention is provided with a subject attribute conversion support apparatus in a database design support apparatus and is capable of converting attribute data items of related subject data items. The feature is that the candidate of the data item is presented to the designer, and the designer is assisted so that the main data item can be appropriately selected.

[Procedure Amendment 2]

[Document name to be amended] Statement

[Correction target item name] 0010

[Correction method] Change

[Correction content]

[0010]

EXAMPLES Example 1. Embodiments of the present invention will be described below with reference to the drawings. Figure 1 is a block diagram showing an embodiment of a first invention of the present application, in the figure, the same reference numerals as in FIG. 7 designate the same or corresponding parts 3-5 are principal attributes conversion support device. FIG. 3 shows data input from the input device 3-1 and stored in the logical data structure storage device 3-3.
8 is obtained by collecting (3) of (3) for all data items (in FIG. 3, only main data items are used instead of all data items).

[Procedure 3]

[Document name to be amended] Statement

[Correction target item name] 0013

[Correction method] Change

[Correction content]

Embodiment 2. FIG. 2 is a block diagram showing an embodiment of the second invention of this application. In the figure, the same reference numerals as those in FIG. 7 indicate the same or corresponding parts, and 3-6 is an attribute main body conversion support device. . FIG. 6 is a flow chart showing the operation of the attribute subject conversion support device 3-6. For all subject data items stored in the logical data structure storage device 3-3, the subject subject data item A of interest is selected. The included attribute data item S is searched for and displayed on the display as a conversion candidate as shown in (2) of FIG. The designer 2 observes this display, and when it is determined that conversion should be performed, the input device 3-
The conversion instruction is given from 1. Attribute-based conversion support device 3-
6 executes conversion based on this instruction, displays the execution result on the display, and inputs it to the logical data structure storage device 3-3 for storage.

[Procedure amendment 4]

[Document name to be amended] Statement

[Correction target item name] 0017

[Correction method] Change

[Correction content]

Further, when there is an attribute data item that can be converted into a related main data item in the logical data structure, the device itself presents the candidate of the attribute data item to the designer. There is an effect that the designer can easily and appropriately search for the existence of the attribute data item that can be converted into the main data item.

[Procedure Amendment 5]

[Document name to be corrected] Drawing

[Correction target item name] Figure 9

[Correction method] Change

[Correction content]

[Figure 9]

Claims (2)

[Claims] 1. An input device, an output device, a logical data structure editing device for editing a logical data structure of a database, data input from the input device, and a logical data structure edited by the logical data structure editing device. A logical data structure storage device for inputting a data item which is a basic constituent element in a logical data structure of a database, a binary relation between the data items, and a main data item which is a unit of target data for handling information. In a logical data structure design support device for editing a logical data structure, a subject attribute conversion support device is provided, and for all subject data items stored in the logical data structure storage device, the focused subject data item A and 1: 1 To the attribute data item by detecting the subject data item B that has the corresponding relation of Main data item A as conversion candidates, and displays the B, the logical data structure design support apparatus characterized by converting the main data items in the attribute data item in accordance with an instruction input from the input device. 2. An input device, an output device, a logical data structure editing device for editing a logical data structure of a database, data input from the input device, and a logical data structure edited by the logical data structure editing device. A logical data structure storage device for inputting a data item which is a basic constituent element in a logical data structure of a database, a binary relation between the data items, and a main data item which is a unit of target data for handling information. In a logical data structure design support device for editing a logical data structure, an attribute subject conversion support device is provided, and for all subject data items stored in the logical data structure storage device, attribute data included in the focused subject data item Display the item as a candidate for conversion to the main data item, and enter the instruction input from the above input device. Logical data structure design support apparatus characterized by converting the attribute data item mainly data item I.