JPH06301728A - Data base structure and its retrieving device - Google Patents

Abstract

PURPOSE:To provide the data base structure and its retrieving device, by which handleability of a data base and operability of the retrieving device side do not become troublesome nor complicated, even when the plural data base of each different structure is handled and when the structure of the data base is change. CONSTITUTION:Information of a retrievable field and a displaceable field is set to a data base side and its setting is changeable, and also, on the retrieving device side, a retrieval processing screen corresponding to its information can be set, by which even if plural data bases of each different structure exist, or the structure of the data base is changed, the retrieving device side can always execute the retrieval processing by the same program, and it is also unnecessary to execute an operation related to an unnecessary field. Moreover, when a user can be discriminated, and the information of retrievable and displaceable fields can be limited in accordance with the result of this discrimination, retrieval and display levels can be set in accordance with the user, therefore, handleability of the data base and operability of the retrieving device side are improved.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database structure and a search device therefor, and more particularly to a database structure suitable for a database system provided on a network accessed by a plurality of clients and a search device therefor.

[0002]

2. Description of the Related Art Conventionally, for example, in a server-client type workstation provided with a plurality of clients and a server, a relational database (hereinafter referred to as RDB) provided in the server is transmitted from the client machine via a network. To access and search
Depending on the RDB accessed by each client machine, the user may create a search program in which searchable fields and displayable fields are set in each field of the database in advance, or a generator may be used each time a search process is performed. A general-purpose search program was used in which all fields were automatically set to be searchable and displayable, each field was displayed on the screen at the time of actual search, conditions were set according to the purpose, and the search was performed.

However, when a search program is created for each client machine, if there are a plurality of RDBs having different fields, a dedicated search program for each RDB must be prepared for all the client machines, and the management thereof is required. Not only becomes complicated, but also when the structure of the RDB is changed, the search programs of all client machines must be changed, which causes a problem of complicated management.

On the other hand, the RDB usually has fields irrelevant to the search and fields that do not need to be displayed depending on its use. Therefore, every time the search processing is performed, all fields can be searched and displayed by the generator. When using a general-purpose search program that is automatically set as possible, fields unrelated to the above search and fields that do not need to be displayed are also automatically set as search fields or display fields, and the search screen and the display screen of the searched records are displayed. There is a problem that it becomes complicated and the search operability and the visibility of search results deteriorate.

[0005]

SUMMARY OF THE INVENTION The present invention has been made in view of the problems of the prior art as described above, and its main purpose is to handle a plurality of databases having different structures or to structure a database. An object of the present invention is to provide a database structure and its search device that do not complicate the handling of the database and the operability on the side of the search device even if the database is changed.

[0006]

According to the present invention, the above-mentioned object is to perform one or more databases having a plurality of fields stored in a storage device and a search process for the databases. 1. A database structure having one or more search devices according to claim 1, and a search device therefor, wherein information of searchable fields and displayable fields of each of the fields can be set and changed on the database side. And a database structure characterized in that the search device has a layout processing unit capable of reading information of the searchable field and displayable field and setting a search processing screen according to the information. This is achieved by providing the search device.

[0007]

As described above, the information of the searchable field and the displayable field can be set and changed on the database side, and the search processing screen corresponding to the information can be set on the search device side. Even if there are a plurality of databases having different structures, or the structures of the databases are changed, the search device can always perform the search process with the same program, and it is not necessary to perform operations on unnecessary fields. Further, by making it possible to identify the search device or the user of the search device and limiting the information of the searchable field and the displayable field according to the identification result, the search level and the display level can be set according to the user. Can be set.

[0008]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENT A preferred embodiment of the present invention will now be described in detail with reference to the accompanying drawings.

FIG. 1 is a block diagram showing the system configuration of a server / client type workstation to which the present invention is applied. This system is a mass storage device 2
And a plurality of client machines 4 connected to the server 1 via a known network 3. The layout processing unit 1 that receives the structure of the search target database, the search information type, and the display information type, which will be described later, from each server 4 and automatically generates the search item, the search screen, and the display screen based on this information.
1 is provided.

In the storage device 2, two databases A and B having different structures are stored. Here, FIG.
Shows the database structure, the search level setting value, the display level setting value, and the display format set in the database A. For example, the database A is a database for managing patent publications, and has fields of “issue country”, “publication date”, “publication number”, “publication type”,
"Application date", "Invention title", "Identification number", "Name or name", "Address or residence", "Inventor",
“Summary”, “Claims”, “Detailed description”, “Brief description of drawings”, “Field” and “Image” are set. Of these, the fields "Issuing country" and "Identification number"
And the search level setting value of "image" is "0",
Excluded from searchable fields. "Public number"
The search level setting value of is "2", and only the search by this field is open to general users. The search level setting value of the remaining fields is "1", and only the privileged user can search. Further, the display level setting value of the field "Issuing country" is "0", and when displaying the search result on the client machine 4, the field is excluded from the display target field. The display level setting value of the field "image" is "0", and only the display of this field after the search is open to general users. That is, a general user can only search by the "public number" and display the "image" field.

The database A in this embodiment will be described below.
3 is a flowchart of FIG. 3 and FIG.
~ It demonstrates with reference to the display screen of the client machine 4 of FIG.

First, the record structure definition for the database A on the server 1 side, and the search / correspondence corresponding to each field
Set the display level and register the actual record. Next, the user inputs the user ID at the client machine 4, receives a list of databases from the server 1 side, and selects a search target database. It is determined whether or not the structure and search information type of this search target database are the same as those of the previous processing. If they are not the same, the structure and search information are received from the server 1 side. Then, a search item and a search screen are automatically generated based on this information.

4 to 6 are screen displays for actually setting search conditions. In this embodiment, a search by a specific user is assumed. First, on the screen of FIG. 4, search conditions such as “publication date”, “publication number”, “publication type”, “application date”, and “field” are set, and then on the screen of FIG. )
6 and enter the search target field of the search key on the screen of FIG. 6 to “name of invention device”, “name or name”, “address or place of residence”, “inventor”, “summary”, “claim” , “Detailed description” and “Simple description of the drawing”.

Next, a search request is issued to the server 1 side,
The server 1 side performs a search process and sends the result to the client machine 4. Then, the client machine 4 selects a display record and requests the server 1 side to transmit the record data. Further, the client machine 4 determines whether the display information type is the same as the previous processing, and if not, the display information is received from the server 1 side. Then, a display screen is automatically generated based on this information, and the record data is received and displayed from the server 1 side.

On the other hand, in addition to such a search process, the record structure, the search level, and the record data are changed on the server 1 side. Since the structure, the search information type, and the display information type are confirmed and read from the search target database if necessary, it is not necessary to make any changes on the client machine 4 side.

A character string searchable field of each database (for example, in database A, "name of invention invention", "name or name", "address or residence", "inventor", "summary", "request""Range","detaileddescription",
At the time of storage, "Short description of drawings"), autocorrelation information of each character (code) is simultaneously created as a map and stored as a kind of index together with the document.
Is managed by. Therefore, it is possible to perform a high-speed search only by creating autocorrelation information for a search character string and matching it with the map. The speed of this search hardly depends on the capacity of the entire document, but depends on the length of the character string to be searched.

[0017]

As is apparent from the above description, according to the database structure and the search device thereof according to the present invention,
Information of searchable fields and displayable fields can be set and changed on the database side, and the search processing screen can be set on the search device side according to the information, so that multiple databases with different structures can be set. However, even if there is a change in the structure of the database, the search device can always perform a search process with the same program, and it is not necessary to perform an operation for an unnecessary field. Further, by making it possible to identify the search device or the user of the search device and limiting the information of the searchable field and the displayable field according to the identification result, the search level and the display level can be set according to the user. Can be set.
From the above, the handleability of the database and the operability on the search device side are improved.

[Brief description of drawings]

FIG. 1 is a block diagram showing a system configuration of a server / client type workstation to which the present invention is applied.

FIG. 2 is an explanatory diagram showing a structure of a database stored in a storage device.

FIG. 3 is a flowchart showing a procedure for searching a database of a server / client type workstation to which the present invention is applied.

FIG. 4 is an explanatory diagram showing a search screen on the display of the client machine.

FIG. 5 is an explanatory diagram showing a search screen on the display of the client machine.

FIG. 6 is an explanatory diagram showing a search screen on the display of the client machine.

[Explanation of symbols]

 1 server 2 storage device 3 network 4 client device 11 layout processing unit

Claims (4)

[Claims] 1. A database having one or more databases having a plurality of fields stored in a storage device, and one or more retrieval devices for performing a search process on the databases. A structure and a search device therefor, wherein information of a searchable field and a displayable field of each of the fields can be set and changed on the database side, and the search device can search the searchable field. A database structure and a search device therefor having a layout processing unit capable of reading information of a displayable field and setting a search processing screen according to the information. 2. The database structure according to claim 1, wherein the database is provided on a server side in a server / client type workstation, and the search device is provided on a client side. The search device. 3. The database structure according to claim 1 or 2, wherein the database is a relational database. 4. The database side has an identification section for identifying a search device or a user of the search device, and the searchable field and the displayable field are classified according to the search device or the user of the search device. 4. A database structure and a search device therefor according to claim 1, wherein information can be set and the setting can be changed.