JP3359951B2 - Database search device - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

The present invention relates to relates to a database search device, in particular to a plurality of de <br/> Tabe scan search device client for the database system provided on a network to access is there.

[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 a client machine via a network. To access and perform a search,
The user prepares a search program in which searchable and displayable fields are set among fields of the database in advance in accordance with the RDB accessed for each client machine, or every time a search process is performed, the generator A general-purpose search program that automatically sets all fields to be searchable and displayable, displays each field on the screen at the time of actual search, sets conditions according to the purpose, and performs a search is used.

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. Not only is the process complicated, but also when the structure of the RDB is changed, it is necessary to change the search programs of all the client machines, and there is a problem that the management becomes complicated.

[0004] On the other hand, since fields that are irrelevant to the search and fields that do not need to be displayed are usually set in the RDB according to the application, every time a search process is performed, all fields can be searched and displayed by the generator. When using a general-purpose search program that automatically sets possible fields, fields irrelevant to the above search and fields that do not need to be displayed are automatically set as search fields or display fields, and the search screen and the display screen of the searched record are displayed. There is a problem that the operation becomes complicated and the search operability and the visibility of the search result deteriorate.

[0005]

SUMMARY OF THE INVENTION The present invention has been made in view of the above-mentioned problems of the prior art, and its main object is to handle a plurality of databases having different structures and to reduce the structure of the database. handling of the database, even if you change, operability complicated search means is to provide a database search device without complicated.

[0006]

Means for Solving the Problems] According to the above objects the present invention, a database on one or more having a plurality of fields stored in the storage device, 1 for performing search processing with respect to the database one a de <br/> Tabe scan search device and a search means on more than, the settable and setting change information searchable fields and displayable fields of each field in the database side it is, the search unit, the database, characterized in that it comprises the searchable fields and reads information displayable fields, and a layout processing unit capable of setting a search processing screen corresponding to the information It is achieved by providing a 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 means can set the search processing screen according to the information. Even if there are a plurality of databases having different structures or the structure of the database changes, the search means can always perform the search processing with the same program, and there is no need to perform operations on unnecessary fields. Furthermore, by making it possible to identify the search means or the user of the search means , and by 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 changed according to the user. Can be set.

[0008]

BRIEF DESCRIPTION OF THE DRAWINGS FIG. 1 is a block diagram of a preferred embodiment of the present invention.

FIG. 1 is a block diagram showing a system configuration of a server-client type workstation to which the present invention is applied. This system uses a mass storage device 2
And a plurality of client devices 4 connected to the server 1 via a known network 3. Each client machine 4 receives a structure of a search target database, a search information type, and a display information type, which will be described later, from the server 1 and automatically generates a search item, a search screen, and a display screen based on the information.
1 is provided.

The storage device 2 stores two databases A and B having different structures from each other. Here, FIG.
2 shows a database structure, a search level set value, a display level set value, and a display format set in the database A. For example, the database A is a database for managing patent publications, and includes fields such as “publishing country”, “publication date”, “publication number”, “publication type”,
"Application date", "Name of invention", "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 "Issue country" and "Identification number"
And the search level setting value of “image” is “0”,
Excluded from searchable fields. "Public number"
Is set to "2", and only the search in 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 set value of the field “Issuing country” is “0”, and when displaying the search result on the client device 4, the field is excluded from the display target field. The display level set value of the field “image” is “0”, and only the display of this field after the search is open to general users. That is, the general user can only search by the “public number” and display the “image” field.

Hereinafter, the database A in this embodiment will be described.
3 and FIG.
This will be described with reference to the display screen of the client device 4 in FIG.

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

FIGS. 4 to 6 show screen displays for actually setting search conditions. In this embodiment, a search by a specific user is assumed. First, search conditions for “publication date”, “publication number”, “publication type”, “application date”, and “field” are set on the screen of FIG. 4, and then a search key (keyword )
And enter the search target fields of the search key on the screen of FIG. 6 as “name of invention”, “name or name”, “address or residence”, “inventor”, “summary”, “claims”. "," Detailed description ", and" brief description of drawings ".

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

On the other hand, apart from such a search process, the server 1 changes the record structure, changes the search level, and changes the record data. Since the structure, search information type and display information type are checked and read from the search target database if necessary, there is no need to make any changes on the client device 4 side.

Note that the character string searchable fields of each database (for example, in database A, "name of invention", "name or name", "address or residence", "inventor", "summary", " Range, "detailed description,
In “Brief description of drawings”, the autocorrelation information of each character (code) is created as a map at the time of storage, and is stored together with the document as a kind of index.
Is managed. Therefore, a high-speed search can be performed only by creating the autocorrelation information for the search character string and checking it against 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 evidenced by the foregoing description, according to the database search device according to the present invention, and can be set and setting change information searchable fields and displayable fields in the database side, and By enabling the search means to set a search processing screen according to the information, the search means always performs the search processing using the same program even if there are a plurality of databases having different structures or the database structure is changed. And no need to perform operations on unnecessary fields. Furthermore, by making it possible to identify the search means or the user of the search means , and by 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 changed according to the user. Can be set. From the above, the operability of the database and the operability of the search means are improved.

[Brief description of the 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 a display of the client machine.

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

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

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Server 2 Storage device 3 Network 4 Client machine 11 Layout processing part

Continuation of the front page (56) References JP-A-2-196354 (JP, A) JP-A-4-347747 (JP, A) JP-A-62-274324 (JP, A) JP-A-60-225252 (JP JP-A-4-92970 (JP, A) Hiromichi Ito et al., Patent Information Management System Based on Client-Server Database, Mitsubishi Electric Technical Report, Japan, Mitsubishi Electric Engineering Co., Ltd., December 25, 1991 , Vol. 65, No. 12, pp. 41-45 (58) Fields investigated (Int. Cl. ⁷ , DB name) G06F 17/30 G06F 12/00 G06F 12/14 G06F 15/00 JICST file (JOIS)

Claims (4)

(57) [Claims] 1. A one and a database on more than, the database search and a search means on one or more for performing the search process on the database having a plurality of fields stored in the storage device An apparatus, 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 unit is configured to set the searchable field and the displayable information. It reads the field information, and the database search apparatus characterized by having a layout processing unit capable of setting a search processing screen corresponding to the information. 2. A database according to claim 1, wherein the database provided in the server-side to the server-client workstation, and the searching means is characterized by being provided to the client-side search equipment. 3. A database search device according to claim 1 or claim 2, characterized in that the database is composed of a relational database. To wherein said database side, an identification portion for identifying provided the user of the searching means <br/> or search means, wherein the searchable fields and displayed according to a user of the search means or retrieval means set the possible field information and database search device according to any one of claims 1 to 3, characterized in that the configurable.