JP2009176015A - Database retrieval system, retrieval screen providing method and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a high-convenience database retrieval system. <P>SOLUTION: An information retrieval server 20 receives a retrieval request from a terminal device 30, reads data item information of a table of a retrieval target from a database server 10, generates a retrieval screen including a display area of a data item name list of the table based on the read data item information, reads an index of the table from the database server 10, and changes a display color of a key item in the data item name list of the generated retrieval screen. The information retrieval server 20 transmits retrieval screen data wherein the display color of the key item is changed to the terminal device 30. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

  The present invention relates to a database search system that transmits a search screen to a terminal and receives a search condition input from the search screen to search a database.

  In recent years, with the development of database technology, many various database search systems have been developed. For example, there is a database search system in a web environment using a report net (registered trademark) of Cognos Co., Ltd. In such a system, a terminal uses a web browser to send a database search request, a search result, etc. to a web server. Send and receive between.

Further, for example, Patent Document 1 discloses a system for searching information content stored in a database using a web browser at a client terminal.
JP 2003-114815 A

  However, in the system as described above, in order to obtain the search processing result quickly, the user sets the search condition by referring to the data item list and the index data before inputting the search condition on the search screen. Then, it was inconvenient because it was necessary to check whether the search process would be accelerated. For this reason, there are many cases where a search is performed without confirming the key item, and as a result, the search time is often increased.

The present invention has been made in view of the above problems, and an object thereof is to provide a highly convenient database search system and the like.
Another object of the present invention is to provide a database search system and the like that can shorten the search processing time.

In order to achieve the above object, a database search system according to the first aspect of the present invention provides:
A database search system for searching database information,
Means for receiving a search request from a terminal;
Means for reading data item information of a table to be searched from the database;
Means for generating a search screen including a display area of a list of data item names of the table based on the read data item information;
Means for reading index information corresponding to the table from the database;
Means for changing the display color of the key item in the data item name list of the generated search screen based on the index information;
Means for transmitting search screen data in which the display color of the key item is changed to the terminal;
It is characterized by providing.

The search screen providing method according to the second aspect of the present invention includes:
A search screen providing method in a database search system for searching database information,
Receiving a search request from a terminal;
Reading data item information of a table to be searched from the database;
Generating a search screen including a display area of a list of data item names of the table based on the read data item information;
Reading index information corresponding to the table from the database;
Changing the display color of the key item in the data item name list of the generated search screen based on the index information;
Transmitting search screen data in which the display color of the key item is changed to the terminal;
It is characterized by providing.

A program according to the third aspect of the present invention is:
Computer
Means for receiving a search request from a terminal;
Means for reading data item information of a table to be searched from the database;
Means for generating a search screen including a display area of a list of data item names of the table based on the read data item information;
Means for reading index information corresponding to the table from the database;
Means for changing a display color of a key item in the data item name list of the generated search screen based on the index information;
Means for transmitting search screen data in which the display color of the key item is changed to the terminal;
It is made to function as.

  According to the present invention, a highly convenient database search system can be realized. Further, the search processing time can be shortened.

Hereinafter, a database search system according to an embodiment of the present invention will be described with reference to the drawings.
A system configuration of a database search system according to an embodiment of the present invention is shown in FIG. 1, and a functional configuration diagram is shown in FIG. As shown in FIG. 1, the database search system includes a database server 10, an information search server 20, and a terminal device 30, which are connected to each other via a network such as a LAN.

  The database server 10 includes a control unit including a CPU (Central Processing Unit), a ROM (Read Only Memory), a RAM (Random Access Memory), a storage unit including a hard disk device, a NIC (Network Interface Card), a router, And a communication unit including a communication device such as a modem. In response to a request from the information search server 20, the control unit reads various data stored in the storage unit and reads them in the information search server 20 by reading and executing an operation program or the like stored in advance in the storage unit. Process to supply. The storage unit stores a data table, an index indicating a key value for the key item of each data table, a system management table that holds index information for each data table, and the like. The system management table includes index configuration information that associates data tables with indexes.

  The information retrieval server 20 includes a computer including a control unit including a CPU, ROM, RAM, and the like, a storage unit including a hard disk device, and a communication unit including a communication device such as a NIC, router, or modem. The control unit logically realizes the request reception unit 201, the database search unit 202, and the like by reading and executing an operation program or the like stored in advance in the storage unit.

The request receiving unit 201 transmits a processing menu screen or the like related to database search to the terminal device 30, and receives and processes various requests related to database search from the terminal device 30.
For example, when a search processing request is received from the terminal device 30, the request reception unit 201 reads a list of data items of a specified data file from the database server 10 or the like, and displays a data item list of the specified data file And a region for receiving the input of the search condition is generated and transmitted to the requesting terminal device 30. In generating the search screen, the request receiving unit 201 reads the index configuration information of the data table corresponding to the data file designated from the terminal device 30 from the system management table of the database server 10, and based on the read index configuration information. Update the display color of the key item.

  An example of the search screen supplied to the terminal device 30 is shown in FIG. In this example, since the data items such as “accounting period”, “GL book date”, and “slip number” are set as key items in the index configuration information read from the system management table of the database server 10, the request reception unit 201. Updates the display color of these key items in the display area of the data item list on the search screen (for example, changes from “black” to “red”).

  Further, when receiving a search execution request together with the search condition data input from the terminal device 30 to the search screen, the request reception unit 201 passes the received search condition data to the database search unit 202. When the search result data corresponding to the search condition is received from the database search unit 202, a search result display screen is generated and transmitted to the terminal device 30 that is the search request source.

  The database search unit 202 performs a data table search process of the database server 10 based on the search condition received from the request reception unit 201 and passes the search result to the request reception unit 201. The database search unit 202 may be realized by a known database search tool such as a report net (registered trademark) of Cognos.

  The terminal device 30 includes a control unit including a CPU, a ROM, a RAM, a storage unit including a hard disk device, a display unit including a liquid crystal display, an input unit including a keyboard and a mouse, a NIC, a router, and a modem. Etc., and a personal computer equipped with a communication control unit including the like. The control unit of the terminal device 30 executes a program or the like stored in the storage unit, thereby realizing a web browser function or the like, connected to the information server 20 via the network, and transmits / receives information related to data search processing. .

Next, a search screen supply process that is a feature of the database search system according to the embodiment of the present invention will be described with reference to the flowchart of FIG.
First, the terminal device 30 transmits a login request to the information search server 20 in response to a predetermined operation for logging in to the information search server 20. In response to this, the control unit of the information search server 20 transmits the login screen data to the terminal device 30, receives the user ID, password, and the like input by the user on the login screen from the terminal device 30, and performs the verification process. I do. When the user authentication is completed, predetermined menu screen data is transmitted to the terminal device 30 (step S11). Here, the user selects, for example, “search data file” from the menu screen and designates the data file to be searched. In response to this operation, the terminal device 30 transmits a search processing request or the like to the information search server 20.

  When receiving a search processing request from the terminal device 30 (step S12), the control unit of the information search server 20 reads a list of data items of the specified data file from the database server 10 and lists the data items of the specified data file. A search screen including an area for displaying and an area for receiving input of search conditions is generated (step S13). Further, the control unit reads the index configuration information of the data table corresponding to the designated data file from the system management table of the database server 10, identifies the key item based on the read index configuration information, and generates it in step S13. The display color of the key item in the data item list on the retrieved screen is updated (step S14).

And the control part of the information search server 20 transmits the search screen data in which the display color of the key item was updated to the terminal device 30 (step S15). The terminal device 30 receives and displays the search screen data. At this time, in the data item list on the search screen, the display color of the key item is different from that of the other items, so that the user can know which item is the key item at this point.
The search screen supply process has been described above. Thereafter, the terminal device 30 transmits the search condition input on the search screen to the information search server 20 together with the search execution request. In response to this, the information search server 20 executes the search process and displays the search result display screen. It transmits to the terminal device 30.

  As described above, according to the present invention, when the data item list is displayed on the search screen, the key items are displayed in different colors, so that the user can know the key items on the search screen. This eliminates the need for an operation for starting up another screen in order to know key items as in the prior art, and improves convenience. Moreover, since it becomes easy to set a key item as a search condition as needed, the case where the data extraction time in a search process becomes short increases.

The present invention can be variously modified and applied.
In the above embodiment, the display color of the key item is changed. However, the present invention is not limited to this, and any display form may be used as long as the key item can be recognized by the user. For example, the key item may be underlined or highlighted, and a mark indicating the key item may be displayed together.

The system of the present invention can be realized using a normal computer system, not a dedicated system. For example, by storing a program for executing the above-described operation in a computer-readable recording medium (FD, CD-ROM, DVD, etc.) and installing the program in a computer, the information retrieval server 20 or the like May be configured. Alternatively, it may be stored in a disk device of a server device on a network such as the Internet and downloaded to a computer, for example.
In addition, when the OS realizes the above functions by sharing the OS or jointly with the OS and the application, etc., only the part other than the OS may be stored and distributed in the medium, or may be downloaded to the computer. Good.

It is a figure which shows the structure of the database search system which concerns on embodiment of this invention. It is a function block diagram of the database search system of FIG. It is a figure which shows an example of the search screen which an information search server provides. It is a flowchart for demonstrating a search screen supply process.

Explanation of symbols

DESCRIPTION OF SYMBOLS 10 Database server 20 Information search server 30 Terminal device 201 Request reception part 202 Database search part

Claims (3)

A database search system for searching database information,
Means for receiving a search request from a terminal;
Means for reading data item information of a table to be searched from the database;
Means for generating a search screen including a display area of a list of data item names of the table based on the read data item information;
Means for reading index information corresponding to the table from the database;
Means for changing the display color of the key item in the data item name list of the generated search screen based on the index information;
Means for transmitting search screen data in which the display color of the key item is changed to the terminal;
A database search system comprising: A search screen providing method in a database search system for searching database information,
Receiving a search request from a terminal;
Reading data item information of a table to be searched from the database;
Generating a search screen including a display area of a list of data item names of the table based on the read data item information;
Reading index information corresponding to the table from the database;
Changing the display color of the key item in the data item name list of the generated search screen based on the index information;
Transmitting search screen data in which the display color of the key item is changed to the terminal;
A method for providing a search screen, comprising: Computer
Means for receiving a search request from a terminal;
Means for reading data item information of a table to be searched from the database;
Means for generating a search screen including a display area of a list of data item names of the table based on the read data item information;
Means for reading index information corresponding to the table from the database;
Means for changing a display color of a key item in the data item name list of the generated search screen based on the index information;
Means for transmitting search screen data in which the display color of the key item is changed to the terminal;
Program to function as.

Images