JPH03189841A - Computation display system for relational data base - Google Patents

Abstract

PURPOSE:To perform operations for the coupling and projection, etc., of a relational data base (RDB) and to generate a desired table even unfamiliar to operating language by displaying the relational table of RDB stored in a filing device in an displayed image on a display, and operating a window on the display. CONSTITUTION:A relational data base (RDB) processing function 1 which performs the read/writed of the relational table stored in the filing device offers the function of the relational data base realized in the RDB, and also, a window control function 2 performs the control of a multiwindow, and performs a con trol function on the window of a display device D. When the title of the relation al table is inputted from the window, a display RDB function 3 displays the relational table on the window under the control of window control function 2. Thereby, it is possible to perform the operation to couple a displayed relation al table with the relational table of another window in so-called cut and paste with a window DB control function 4.

Description

[Detailed Description of the Invention] [Field of Industrial Application] The present invention relates to a relational-based (hereinafter referred to as RDB) arithmetic display method, and particularly relates to a method for relating RDB table operations to operations within one window of a display. .

[Conventional technology]

Conventional RDB calculation and display systems use an RDB operation tool called COBOL or EUF as an RDB operation language to perform operations such as projection and join on basic tables and virtual tables.

[Problem to be solved by the invention]

The RDB operation language used in the conventional RDB calculation display method described above is based on whether the language specifications such as C0BOL are understood or not.
You need to understand the simple language provided by UF and the basic tables defined on file-based peripherals,
Since it is necessary to know about virtual tables, it has the disadvantage that table operations cannot be performed quickly and easily.

[Means to solve the problem]

The RDB calculation display method of the present invention includes a relational database (RDB) processing function for reading and writing relational tables stored in a file device, a window control function for controlling multi-windows, and a function for reading and writing relational tables stored in a file device. A display RDB function that displays a part of one relational table on a display window as a relational table equivalent to that stored in a peripheral device, and an arbitrary table (column) of the relational table displayed in the window and It is configured with a window DB operation function that extracts rows and performs calculations, and performs behind-the-scenes database calculations on the relational table of the calculation results on another window, and a window display function that displays the results of those calculations. has been done.

〔Example〕

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

FIG. 1 is a block diagram showing an embodiment of the 'RDB calculation display method of the present invention.

The 10RDB processing function operates the relational table stored in the file device F (for example, a magnetic disk) in the RDB calculation and display method of this embodiment.

The RDB processing function 1 provides the function of a relational database realized by RDB.

Further, the window control function 2 performs multi-window control and realizes an operation function on the window of the display device.

Then, when you enter the name of the relationship table from the window, 3
The display RDB function displays a relational table on a window under the window control function 2.

Therefore, the displayed relationship table can be combined with a relationship table in another window by so-called cut and paste using the window DB operation function 4.

The results are displayed using the window display function 5.

〔Effect of the invention〕

As explained above, the RDB calculation display method of the present invention displays the RDB relationship table stored in the file device on the display as it is, and also displays the RDB by operating the window on the display.
This has the effect of allowing operations such as combinations and projections of The effect is that you can create a table of your choice (virtual table) without knowing anything about it.

[Brief explanation of drawings]

FIG. 1 is a block diagram showing an embodiment of the RDB calculation display method of the present invention. 1... RDB processing function, 2... Window control function, 3... Display RDB function, 4... Window DB operation function, 5...
...Window display function, D...Display device, F
...File device.

Claims (1)

[Claims] A relational database (RDB) processing function that reads and writes relational tables stored in a file device, a window control function that controls multi-windows, and a part of a relational table stored in a file device on a display. A display RDB function that displays a relational table equivalent to that stored in a peripheral device on a window, and extracts and calculates any table (column) and row (row) of the relational table displayed on the window. A relational database calculation display method having a window DB operation function for performing table operation database calculations on the relational table of calculation results on another window, and a window display function for displaying the calculation results.