JPS593628A - Table display control system - Google Patents

Abstract

PURPOSE:To control tuple identifier in a user-side area and to handle access requests generated at random, by storing tuple identifiers in a tuple identifier control means and providing a means for reading it automatically when a display request is generated. CONSTITUTION:The tuple identifiers are stored in the tuple identifier control means and when the display request is generated, a tuple identifier is read automatically. For example, when a request for retrieval processing is sent out of a data base control part 9, table data 2 is outputted from the data base 1 and the block of the table data is also sent out. Then when a user operates a scroll control key 14, a scroll control part 11 detects that and sends a scroll request, etc., to the data base control part 9. A TID control table 8 is looked up to read the TID of a table data block to be displayed next on the basis of current position information and scroll-direction information, and sends it to the data base 1 to make a request to send out the corresponding table data block.

Description

DETAILED DESCRIPTION OF THE INVENTION Technical Field of the Invention The present invention relates to table data that enables predetermined data portions to be called in a random order for table data of a large size that cannot be accommodated on one display screen in a display device. Regarding display control method,
In particular, the present invention relates to a table display control method in a relational database system that performs table searches in an interactive manner.

Background of the technology In previous database systems, when using a database, it was necessary to create specifications for the search format to create data and instruct the system in advance, but recent systems called relational databases Now, at the time of execution, it is possible to instruct or change the search format one by one using a prepared language, depending on the situation of the search results. This results in
The usability of databases has increased and search efficiency has been significantly improved.

Shikashi, in relational database systems, when displaying large table data on a display device, there is a limit to the memory capacity that can be used as a buffer, and when accessing the database, records are searched in a predetermined search order. Since only this method was allowed, it was essentially impossible to adapt to requests for randomly referencing the table vertically, horizontally, and horizontally at any time. For example, if you want to look at a previously referenced position again, as shown in Figure 1, it is specified in the database that you go to the end position of the table, then return to the starting position and move forward to reach the destination position. This is an extremely inconvenient processing method.

This is because the user does not have a means to directly call any record in the database.

One solution to this problem was to expand all the data retrieved from the database onto a work file, and then respond to random reference requests with the data on this work file. There are problems such as the processing time becomes long when the amount is large, and the file size becomes too large to ignore.

Object and Structure of the Invention An object of the present invention is to solve the problems of the conventional method described above, and for this reason, it is possible to solve the problems of the conventional method described above. This system focuses on TID, manages it in the user's area, and uses it as a key to process random access requests to database records.

The present invention has a structure in which a relational database processing system that manages a plurality of table data blocks using a table data block is provided with a table data block that is larger than the display screen. When a table data block constituting a tm tear is called up from the database to a display screen and displayed, the table data block's table data block's table data block identifier is stored in the table data block management means, and the table data block that has already been displayed is displayed again. When a request is made, the corresponding table data block in the table data management means is automatically read out, a request is made to the database to transfer the table data block corresponding to the table data block, and the table data block is transferred. At 9 o'clock, this will be displayed on the display screen.') K It is characterized by being controlled.

Examples of the invention The present invention will be explained below based on examples.

FIG. 2 is a system configuration diagram of an embodiment of the present invention. In the figure, 1 is a relational database, 2 is table data, 3 is a tagle identifier TID, 4 is a processing device, 5 is an input/output control unit, 6 is a memory, 7 is a user work area, 8 is a TID management table, and 9 is a database management department,
10(d) is a display control section, 11 is a scroll control section, 12 is a display terminal device, 13 is a keyboard, and 14 is a scroll control key.

The database management unit 9 manages the relational database 1 while interacting with the user of the display terminal device 12.
The search process for table data 2 is controlled. The table data 2 has a Tara pull identifier TID3 for each predetermined data management block.

When the database 1 outputs the table data 2 in response to a request from the database management unit 9, the blocks of table data managed by the TID 3 are sent out in a fixed order. At this time, the corresponding TID is also sent out. This TID is information that is invisible to the user and was conventionally used only for data management control within the database system, but in the present invention, in order to enable random access to table data, Every time a table data block is received from the database 1, its TID is held in the form shown in FIG.

In the figure, the area where the TID is displayed is the TID storage area, which manages data that identifies the already displayed block and the currently displayed block in the table data 2.

When the user operates the scroll control key 14 to instruct the scroll button and scroll direction during execution of the search process, the scroll control unit 11 detects this and sends the scroll request and scroll direction to the database management unit 9. Notice.

The database management unit 9 refers to the T-block management table 8, reads the TID of the table data block to be displayed next from the current position information and scroll direction information, sends it to the database 1, and stores the table data corresponding to the TID. Request sending of a data block. When the requested table data block is sent from the database 1, it is joined to the table data block at the current position in the work area 7 of the memory 6, and the scroll control section 11 performs a known scroll readout to display the data on the display. Display the top nine.

In this way, within the table data area for the already displayed portion, you can scroll to any position vertically, horizontally, and
Table data can be referenced.

Note that instead of the scroll control as shown above, the screen may be controlled to be switched by page turning.

Effects of the Invention As described above, according to the present invention, table search processing in a relational database system becomes extremely easy, and search processing time can be shortened.

[Brief explanation of drawings]

FIG. 1 is an explanatory diagram showing the table search order of the conventional method, FIG. 2 is a configuration diagram of the system of this embodiment, and FIG. ;iT
It is an explanatory diagram of an IDW filling table. In the figure, l is a relational database, 21d is table data, 3 is a TID 14 is a processing device, 5 is an input/output control unit, 6 is a memory, 7 is a user work area, and 8 is a TID
Management table, 9 is database management section, 10 is display control section, 11 is ? In the crawl control section, 12 is a display terminal device, 13 is a keyboard, and 14 is a scroll control key. Patent applicant: Fujitsu Ltd. Representative Patent Attorney Fumihiro Hase (1 other person) 145 years old, 1 year old, figure f'3m

Claims (1)

[Claims] In a relational database processing system that manages a plurality of table data blocks using a table data block, a table data block that makes up the table is searched for by providing a table data block that is larger than the display screen. When calling and displaying the table data block on the display screen, the table data block's multiple identifier is stored in the table data block management means, and when there is a request to display the already displayed table data block again, Automatically reads the corresponding table data block, requests the database to transfer the table data block corresponding to the table data block, and controls to display this on the display screen when the table data block is transferred. A table display control method characterized by: