JPH0830642A - Cd-rom data retrieval system - Google Patents

Abstract

PURPOSE:To perform quick retrieval without restricting the setting of a retrieving key item or the like by storing a retrieving key file in a magnetic disk arranged on the host computer side and retrieving addresses in a CD-ROM file. CONSTITUTION:A terminal 1 edits inputted retrieving data to a communication message based upon a previously determined layout and transmits the message to a host computer 3 through a communication line. The computer 3 prepares a retrieving condition expression necessary for the retrieval of a relational data base 4 based upon the received retrieving data, allocates respective inputted item values to a comparing value area in the condition expression and retrieves data satisfying the condition from a data file 7. The computer 3 extracts a CD-ROM address from a record in the file 7, prepares a communication message and transmits the message to the terminal 1. The terminal 1 extracts the address of a retrieved result from the message, reads out a record from a CD-ROM file in a CD-ROM device 5 and displays the record on a screen.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a CD-ROM data retrieval system and a CD-ROM data retrieval method.

[0002]

2. Description of the Related Art A CD-ROM device has a large capacity (540M).
Although it is used as a database for various searches because it can input the data of B), it has the characteristic that the reading speed is much slower than other media such as magnetic disks and floppy disks, and the search speed is improved. It has become a challenge.

As one of the countermeasures against this problem in the CD-ROM data retrieval system, a retrieval key file consisting of a retrieval key and an address on the data file of the data having the retrieval key is provided in the CD-RO separately from the data file.
Created on M, when searching, search the search key file,
The method of reading the address of the data on the data file from the search key file and reading the data from the data file at the address and displaying it on the screen is adopted.

[0004]

DISCLOSURE OF THE INVENTION Problems to be Solved by the Invention
In the ROM data retrieval system, the retrieval speed varies depending on the structure of the retrieval key file and the amount of retrieval data.

In the case of data having a complicated search key or data having many search key items, the structure of the search key file becomes complicated and the size of the search key file increases, so that there is a problem that the search speed decreases.

Therefore, the conventional method has a drawback that in order to realize a system in which the search time is short, the setting of the search key item and the inspection method are limited.

The object of the present invention is to perform a search in a short time without limiting the setting of search key items and the search method.
It is to provide a ROM data retrieval system.

[0008]

A first invention is a CD-R.
CD-ROM in which a terminal to which a CD-ROM device including an OM file is connected and a host computer including a relational database are connected via a communication line
In the data search system, the terminal edits the input search data into a communication message based on a predetermined layout, transmits the edited communication message to the host computer through the communication line, and from the host computer The CD-ROM address is extracted from the received communication message and the CD-ROM address is extracted from this CD-ROM address.
The record is read out from the CD-ROM file of the ROM device by a predetermined method and displayed on the screen, and the host computer creates a predetermined search condition expression from the received communication message, and creates the search condition expression. A data file provided in advance on the relational database is searched by a search condition expression, the CD-ROM address is extracted from the record of the searched data file to create a communication telegram, and the communication message is transmitted to the terminal through the communication line. It is characterized by doing.

The second invention is a CD-ROM data retrieval in which a terminal to which a CD-ROM device including a CD-ROM file is connected and a host computer including a relational database are connected via a communication line. In the CD-ROM data search method in the system, the search data input from the terminal is edited into a communication message based on a predetermined layout, and the edited communication message is transmitted to the host computer through the communication line, The host computer creates a predetermined search condition expression from the received communication message and searches the data file previously provided on the relational database by the created search condition expression, and the searched data file Records from CD-ROM
The address is extracted to create a communication message, which is transmitted to the terminal through the communication line. The terminal extracts the CD-ROM address from the communication message received from the host computer and the CD-ROM address from the CD-ROM address.
It is characterized in that the record is read out from the CD-ROM file of the ROM device by a predetermined method and displayed on the screen.

[0010]

Next, the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram showing an embodiment of the present invention.

In the CD-ROM data retrieval system of the present embodiment, as shown in FIG. 1, a terminal 1 to which a CD-ROM device 5 is connected and a host computer 3 equipped with a relational database 4 are connected by a communication line 2. Connected by.

The data file 7 in the relational database 4 on the magnetic disk of the host computer 3 is the CD-R of each record of the CD-ROM file 6.
It is composed of an OM address and data items required for retrieval.

As a search procedure, first, the terminal 1 to which the CD-ROM device 5 is connected edits the search data input in the item for searching the screen into a communication message based on a predetermined layout. The edited communication message is transmitted to the host computer 3 through the communication line 2.

The host computer 3 creates a search condition expression necessary for searching the data file 7 of the relational database 4 from the received search data of the communication message, and the relational database 4 is created by the created search condition expression. Search for.

FIG. 2 is a diagram showing a configuration example of a communication message and a search condition expression. Referring to FIG. 2, the communication telegram is in the order of item 1, item 2, item 3 and the communication management unit in which predetermined information necessary for managing communication such as communication time and terminal information is stored. It consists of stored item values. The search condition expression is composed of a data item name, a comparison operator, and a comparison value area in which data of comparison values is set. Each input item value is applied to the comparison value area of the search condition expression, and data satisfying this condition is searched from the data file 7. In this embodiment, item 1 is XXX
Data that is ZZZ and item 2 is greater than YYYY or item 3 is NNN (called partial match) will be searched.

The host computer 3 extracts the CD-ROM address from the retrieved record of the data file 7 to create a communication message, and the terminal 1 through the communication line 2.
Send to.

The terminal 1 extracts the CD-ROM address of the search result from the received communication message. CD taken out
-From the ROM address, the CD-R of the CD-ROM device 5
The records are read from the OM file 6, the search records are displayed in the search order on the screen of the terminal 1, and the search processing is ended.

The method of reading records from a CD-ROM file will be described below.

The CD-ROM address indicates the number of the record in the CD-ROM file.
From the ROM address and record length, the corresponding record is
The number of bytes from the beginning of the CD-ROM file can be known. The physical position value obtained by adding the calculated number of bytes to the physical position of the file pointer at the beginning of the CD-ROM file becomes the physical position of the file pointer that is the corresponding record. The physical position of this file pointer is moved by a seek command to read the corresponding record.

As described above, the present invention realizes a system with a short search time by providing the search key file on the magnetic disk of the host computer side and searching the address of the CD-ROM file. Therefore, it is possible to provide a system with high serviceability that does not require the number of search key items and the inspection method to be limited.

[0022]

As described above, according to the present invention, the search time is shortened by providing the search key file on the magnetic disk on the host computer side and searching the address of the CD-ROM file. This has the effect of making it possible to provide a system with high serviceability that does not require restrictions on the number of search key items and the inspection method.

[Brief description of drawings]

FIG. 1 is a block diagram showing one embodiment of the present invention.

FIG. 2 is a partial operation explanatory diagram of the present invention.

[Explanation of symbols]

 1 Terminal 2 Communication Line 3 Host Computer 4 Relational Database 5 CD-ROM Device 6 CD-ROM File 7 Data File

Claims (2)

[Claims] 1. A CD-R with a CD-ROM file
In a CD-ROM data retrieval system in which a terminal connected to an OM device and a host computer equipped with a relational database are connected via a communication line,
The terminal edits the input search data into a communication message based on a predetermined layout, transmits the edited communication message to the host computer through the communication line, and from the communication message received from the host computer. Take out the CD-ROM address and use this CD-ROM
From the address, the CD-ROM of the CD-ROM device
The record is read from the file by a predetermined method and displayed on the screen, the host computer creates a predetermined search condition expression from the received communication message, and the relational database is created by the search condition expression created. A CD characterized in that a data file provided in advance is searched, the CD-ROM address is extracted from the record of the searched data file to create a communication message, and the communication message is transmitted to the terminal through the communication line. -ROM data retrieval system. 2. A CD-R with a CD-ROM file
C in a CD-ROM data retrieval system in which a terminal connected to an OM device and a host computer equipped with a relational database are connected via a communication line
In the D-ROM data search method, the search data input from the terminal is edited into a communication message based on a predetermined layout, and the edited communication message is transmitted to the host computer through the communication line, and the host computer The computer creates a predetermined search condition expression from the received communication message and searches the data file previously provided on the relational database according to the created search condition expression, and records of the searched data file. From the CD-ROM address extracted from the communication message received from the host computer, the CD-ROM address is extracted from the CD-ROM address, the communication message is created and transmitted to the terminal through the communication line.
From the D-ROM address to the C of the CD-ROM device
A CD-characterized in that a record is read from a D-ROM file by a predetermined method and displayed on a screen.
ROM data retrieval method.