JPH0844760A - System and method for data base retrieval - Google Patents

Abstract

PURPOSE:To provide a data base which prevents data from being copied and facilitates retrieval. CONSTITUTION:Respective data in the data base 33 are given storage inhibition attributes to inhibit the data given the storage inhibition attributes from being stored. Respective data in the data base 33 are given printing inhibition attributes to inhibit the data given the printing inhibition attributes from being printed. Further, detail data are made to correspond to data names, and detail data made to correspond to names and all or some of displayed data names are displayed by retrieving >=1 data names. When one data name is selected, detail data made to correspond to the data name are displayed and when a list of data names is scrolled, the detail data made to correspond to displayed data names are displayed.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION The present invention accesses a database from a window system or the like to search information (data).
The present invention relates to a database search system and method for obtaining data by referring to.

Further, the present invention relates to a screen display system, and more particularly to a screen display system for searching a database on a window display system such as a personal computer and a workstation.

[0003]

2. Description of the Related Art Conventionally, an unspecified number of users access a database from a window system or the like, display retrieved information (data) on a display on the window system, and copy the retrieved information (data). A search system that processes paste and information (data), and outputs to a file or an external device such as a printer has been put into practical use.

Further, in the conventional database search system, the table name to be searched is determined and then the item name on the determined table is selected.

In other search systems, a list of items for each table is displayed as a window in a superimposed manner on the original display, or a table item is displayed as a pop-up window for selection each time a table is selected.

[0006]

The database is searched by an unspecified number of users through the window system, and the search information (data) can be freely copied and output to external devices such as file output and print output. What is done causes problems in terms of "security" such as leakage of confidential information.

An object of the present invention is to prevent the leakage of confidential information by controlling the output to an external device other than the display in order to solve the above problems.

Further, the conventional retrieval system has a problem that it is difficult to retrieve the table name and the item name. Therefore, an object of the present invention is to provide a database search system and method by which a table name and an item name can be easily selected by simultaneously displaying a table name and an item name associated with each table. To do.

[0009]

In order to achieve such an object, the invention described in claim 1 is a database search system for displaying data searched from a database on a screen. And a storage prohibition attribute giving means for giving a storage prohibition attribute to each of the data in the database, and prohibiting the storage of the data having the storage prohibition attribute in the search data storage means. A storage prohibition means is provided.

According to a second aspect of the present invention, there is provided a database retrieval system for displaying data retrieved from a database on a screen, wherein retrieval data printing means for printing the retrieved data and data in the database are provided. It is characterized by further comprising a print prohibition attribute giving unit for giving a print prohibition attribute, and a print prohibiting unit for prohibiting printing of the data to which the print prohibition attribute is given to the search data printing unit.

A third aspect of the present invention is a database retrieval system in which detailed data is associated with a data name, wherein the data name retrieval means retrieves one or more data names from the database. A data name display means for displaying a list of data names, a detailed data display means for displaying detailed data associated with all or some of the displayed data names, and one data name is selected. And a selected data display means for displaying detailed data associated with the data name, and when the list of data names is scrolled, it is associated with all or part of the data names displayed by scrolling. And scroll data display means for displaying the detailed data thus obtained.

Here, the table name in the second embodiment corresponds to the data name, and the item name corresponds to the detailed data.

According to a fourth aspect of the present invention, there is provided a database search method for displaying the data retrieved from the database on a screen, and a storage prohibition attribute giving step of giving a storage prohibition attribute to each of the data in the database, A storage prohibition step of prohibiting storage of data to which the storage prohibition attribute is added, a step of determining whether or not the storage prohibition attribute is added to the retrieved data, and the storage prohibition attribute being added And a search data storing step of storing non-search data.

According to a fifth aspect of the present invention, there is provided a database search method for displaying the data retrieved from the database on a screen, and a print inhibition attribute assigning step of assigning a print inhibition attribute to each of the data in the database, A print prohibition step of prohibiting printing of data to which the print prohibition attribute is added, a step of judging whether or not the print prohibition attribute is added to the retrieved data, and the print prohibition attribute is added. And a step of printing search data that does not exist.

According to a sixth aspect of the present invention, there is provided a method of searching a database in which detailed data is associated with a data name, the data name searching step of searching for one or more data names from the database, and the searched data name. A data name display step for displaying a list of data names, a detailed data display step for displaying detailed data associated with all or part of the displayed data names, and one data name is selected. And a selected data display step of displaying detailed data associated with the data name, and when the list of data names is scrolled, all or some of the data names displayed by scrolling are associated with data names. And a scroll data display step for displaying the detailed data thus obtained. Here, the table name in the second embodiment corresponds to the data name, and the item name corresponds to the detailed data.

[0016]

According to the database output control system of the present invention,
Means for adding access attributes to confidential information (data),
A means for prohibiting output of search data to an external device other than the display according to the access attribute and a means for canceling the access attribute are provided.

According to the present invention, the access attribute is added to the data and the attribute is set in the confidential information (data). When the database is accessed from the window system and the confidential information (data) is referred to, the access attribute is detected, and output is prohibited to an external device (file, printer, etc.) other than the display.

Further, by releasing the access attribute, it is possible to freely output the search information (data).

Further, according to the present invention, data candidates to be searched are searched from the database, a list of names of the data candidates is displayed in a table format, and all or some of the data candidates in the displayed table are displayed. Detailed data is displayed. When a name of a data candidate in the table is clicked, detailed data corresponding to the data candidate is displayed, and when the table is scrolled, all or some of the data candidates displayed by scrolling are displayed. Detailed data is displayed.

[0020]

Embodiments of the present invention will be described below in detail with reference to the drawings.

(Embodiment 1) FIG. 1 is a block diagram showing an example of a preferred information processing network system configuration of the present invention.

The server which provides the service to the client is the mainframe 20 or the UNIX server 40.
And a database (DB) 30. A client that requests a service from the server is configured by the personal computer 50 or the workstation 60.

Further, the present system includes a printer server 30.
0, all components are connected by a communication line (LAN) 10.

FIG. 2 is a software block diagram for explaining the software configuration of the database output control system of the present invention.

The client has a database search request unit 11 for performing a search request process in the database, a data creation unit 12 for creating data to be stored in the database, and an access for adding / deleting an access attribute to confidential information (data). An attribute management unit 13, a data output control unit 14 that determines a data output destination device, checks attributed data, and selects information (data) to be output, and an external device output unit 15 that transmits data to an external device.
Consists of

The server comprises a database search processing unit 31 that responds to a database search request from a client, a database management unit 32 that manages the database, and a database 33 that stores data.

The external output device C100 is a display 2
1, a disk memory 22 and a printer 23.

A communication line (LAN) 10 connects the server and the client.

FIG. 3 shows confidential information (data) (A) and (B) to which an access attribute is added.

FIGS. 4A and 4B are flowcharts showing a procedure for adding an access attribute.

In FIG. 4A, data to be stored in the database is created (step 11), and within that data, the range of information (data) desired to be stored as precision information (data) is specified (step 12). , A mode for adding an access attribute is set (step 13), and a start attribute and an end attribute are added to the information of the beginning position and the information of the final position of the range-designated information (data) (step 14). Then, the mode for adding the access attribute is canceled (step 15), and the process is terminated.

In FIG. 4B, a mode for adding an access attribute to information (data) is set (step 2
1) Create the data to be saved in the database. At this time, an attribute is added to each input data (step 2
2). The mode for adding the access attribute is canceled (step 23), and the process ends.

FIG. 5 is a flow chart showing control of output of information (data). In FIG. 5, the information (data) retrieved from the database is output to the device to be output (step 31). At this time, these data are received by the data output control unit 12 shown in FIG. A check is made (step 32), and if the output destination is a display, output information (data) is output to the display device (step 34), and the processing ends. If the output destination is an external device other than the display, the output information (data) is checked, and information other than the information (data) to which the access attribute is added is output to the designated device (step 33), and the process is ended.

The present invention is not a window system,
It can also be applied to other systems such as DOS.

It is also possible to add a stepwise (level) condition to the access attribute so that the data to which a certain attribute is added can be output to a printer, and the data having a certain attribute can be output to a file.

Information (data) with access attribute added
When outputting to an external device other than the display, the attribute additional information (data) can be replaced with a space and output.

Not only the confidential information (data) designated in the file but also the access attribute can be added to the file itself to control the entire file.

(Embodiment 2) FIG. 6 is a hardware block diagram of the database search system of the present invention. In FIG. 6, reference numeral 33 denotes a storage device for storing a database, 62
Is an input device for inputting search conditions, 63 is a central processing unit for searching the database stored in the storage device 33 according to the input search conditions, and 21 is a display for displaying the search results.

FIG. 7 is a flow chart showing the operation of the database search system of the present invention. As shown in the figure, the central processing unit 63 searches the table name according to the input from the input device 62 and displays the search result on the display 21.
(S71). Next, the item name corresponding to the searched table is searched and displayed on the display 61 (S
72). Further, the input device 62 waits for an input (S7).
3).

When there is an input for selecting a table name, the item corresponding to the selected table is displayed (S74).
When there is an input for scrolling the table name list, the table list is scrolled (S75) and a list of item names corresponding to the displayed table is displayed (S77). When there is an input for scrolling the list of item names, the item name is scrolled (S76).

FIG. 8 shows an example of display by the database search system of the present invention. In FIG. 8, 71 is a scroll bar for vertically scrolling the table, 72 is a scroll bar for horizontally scrolling item names, and 73 is a selected item name.

The display by the database search system of the present invention may be in the form as shown in FIG.

[0043]

As described above, according to the present invention, the confidential information (data) has a means for adding an access attribute and a means for canceling it, and outputs the information (data) retrieved from the database to an external device. At this time, a device for determining the output destination device and outputting the information (data) other than the additional attribute information (data) to the designated device in the case of an external device other than the display is provided, so conventionally, a large number of unspecified users It is possible to prevent the search information (data) from being copied, output to a file or printed out by searching the database through the window system.

Since a table showing a list of search data candidates is displayed and the data associated with the displayed table is displayed, it is easy to select a search data name from the search data candidates. become.

[Brief description of drawings]

FIG. 1 is a hardware block diagram of a database search system of the present invention in a first embodiment.

2 is a software block diagram of the database search system of the present invention in Embodiment 1. FIG.

FIG. 3 is an explanatory diagram showing confidential information (data) to which an access attribute is added.

FIG. 4 is a flowchart showing a process of adding an access attribute.

FIG. 5 is a flowchart showing a process of controlling output of information (data).

FIG. 6 is a hardware block diagram of a database search system according to the present invention in a second embodiment.

FIG. 7 is a flowchart showing the operation of the database search system of the present invention in the second embodiment.

FIG. 8 is an explanatory diagram showing a display by the database search system of the present invention according to the second embodiment.

FIG. 9 is an explanatory diagram showing display by the database search system of the present invention according to the second embodiment.

[Explanation of symbols]

 10 communication line (LAN) 11 database search request unit 12 data creation unit 13 access attribute management unit 14 data output control unit 15 external device output unit 20 mainframe 21 display 30 database 31 database search processing unit 32 database management unit 33 database 40 UNIX server 50 Personal computer (PC) 60 Workstation (WS) 62 Input device 63 Central processing unit 71 Scroll bar 72 Scroll bar 73 Selected item name

Claims (6)

[Claims] 1. A database retrieval system for displaying data retrieved from a database on a screen, wherein the retrieval data storage means stores the retrieved data, and a storage for giving a storage prohibition attribute to each of the data in the database. A database search system comprising: a prohibition attribute imparting means; and a storage prohibition means for prohibiting storage of data to which the storage prohibition attribute is imparted in the search data storage means. 2. A database retrieval system for displaying data retrieved from a database on a screen, wherein a retrieval data printing means for printing the retrieved data, and printing for giving a print inhibition attribute to each of the data in the database. A database search system comprising: a prohibition attribute giving means; and a print prohibition means for prohibiting printing of data to which the print prohibition attribute is given to the search data printing means. 3. A database retrieval system in which detailed data is associated with a data name, wherein a data name retrieval means for retrieving one or more data names from the database and a list of retrieved data names are displayed. Data name display means, detailed data display means for displaying detailed data associated with all or some of the displayed data names, and when one data name is selected, the data name is associated When the list of the data names is scrolled, the selected data display means for displaying the detailed data attached is displayed, and the detailed data associated with all or part of the data names displayed by the scroll is displayed. A database search system comprising scroll data display means. 4. A database search method for displaying data retrieved from a database on a screen, comprising: a storage-prohibited attribute assigning step of assigning a storage-prohibited attribute to each of the data in the database; A storage prohibition step of prohibiting storage of data, a step of determining whether or not the storage prohibition attribute is added to the retrieved data, and a search of storing search data to which the storage prohibition attribute is not added A database searching method comprising: a data storing step. 5. A database search method for displaying data retrieved from a database on a screen, comprising: a print inhibition attribute assigning step of assigning a print inhibition attribute to each of the data in the database; A print prohibition step of prohibiting printing of data, a step of determining whether or not the print prohibition attribute is added to the retrieved data, and a search for printing the search data to which the print prohibition attribute is not attached A database search method comprising a data printing step. 6. A method of searching a database in which detailed data is associated with a data name, wherein a data name searching step of searching for one or more data names from the database and a list of searched data names are displayed. Data name display step, detailed data display step that displays detailed data associated with all or part of the displayed data name, and when one data name is selected, it corresponds to the data name A selected data display step of displaying detailed data attached, and when the list of the data names is scrolled, detailed data associated with all or part of the data names displayed by scrolling is displayed. A database search method, comprising: a scroll data display step.