JPH0744572A - Data base retrieval system - Google Patents

Abstract

PURPOSE:To make it unnecessary to consider or input a retrieval key word or a retrieval expression, and to sufficiently facilitate a countermeasure to a huge number of retrieval numbers by reading a bar code applied to an article on a document or the like by an inputting and outputting device, and transmitting the signal to a data base. CONSTITUTION:The power source of an inputting device 3 is turned on, an access to a data base 2 is performed through a telephone line 1, the bar code applied on the document is scanned by a bar code scanner 19, and converted into an electric signal by a bar code reader 20, and the electric signal is transmitted through a MODEM 21 to the data base 2. At the data base 2 side, information related to the document corresponding to the bar code is retrieved by the received electric signal, and the retrieved information is transmitted to the inputting and outputting device 3 of a user. The inputting and outputting device 3 receives the information transmitted from the data base 2, stores it in a memory 16 or a hard disk 17, displays it on a liquid crystal display device 13, or prints it by a printer 18.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION The present invention relates to written articles, documents,
The present invention relates to a database search system capable of obtaining desired information by using a database in which information related to numerical values, figures, tables, etc. is constructed.

[0002]

2. Description of the Related Art Conventionally, written articles, documents, numerical values,
As a method of obtaining information related to figures, tables, etc. (hereinafter abbreviated as a document) using a communication means, a database in which information related to a document is constructed is connected via a telephone line and displayed on the screen. An interactive method of selecting the desired information from the multiple choices that are displayed one after another, or a search condition for entering a search keyword and a search formula that are the search conditions for obtaining the information you want to obtain. An input method is adopted (see Japanese Patent Laid-Open Nos. 2-123467, 4-21518, and 4-192775).

[0003]

However, in the conventional interactive method, it is necessary to return to the initial state and select different selection items when the information to be finally obtained cannot be obtained, which is very time-consuming. There was a problem that it took time. In addition, in the conventional search condition input method, it is necessary to consider the optimum search keyword and search formula and enter the search keyword and search formula, and if the selection or search condition is a little wrong, It is necessary to consider another search condition and repeat again, and it takes a lot of time and effort to obtain the information that you want to obtain, and in general when inputting information by communication, the operation to enter the search condition is required. The problem was that it was complicated.

[0004]

The present invention has been made in view of the above problems, and is connected to a database in which information related to written articles, documents, numerical values, figures, tables, etc. is constructed. Then, in the database search system in which the user can obtain the information desired to be obtained from the database by giving the search condition,
A medium provided with a bar code representing a part of numerical values, figures, tables, etc., and an input / output device for transmitting a signal generated by reading the bar code to the database and receiving information retrieved from the database, A database search system is configured by a database that transmits information corresponding to a barcode to a user based on a signal read by the input / output device.

[0005]

The present invention is configured as described above, and is capable of reading a barcode attached to an article, a document, a numerical value, a figure, a table, etc. on a document with an input / output device and transmitting the signal to a database. Thus, as an operation for obtaining the desired information from the database, it is possible to perform a search simply by reading the bar code with the input / output device.

[0006]

Embodiments of the present invention will be described below with reference to the drawings. FIG. 1 shows a case where a database 2 for constructing newspaper article information is connected to an input / output device 3 used by a user through a telephone line 1, and the input / output device 3 is used.
Is a keyboard 11 and a keyboard controller (KEYC) 12 for processing an input signal from the keyboard 11, a liquid crystal display device (LCD) 13, a liquid crystal drive circuit (LCDRV) 14 for driving the liquid crystal display device 13, and a character for liquid crystal display. Video image memory (GVR) for storing information
A) 15, a program for operating each of the components 11 to 15, a memory 16 for storing received data and data to be transmitted, a hard disk (HDD) 17, a memory 16 and stored in the hard disk 17. A printer 18 for printing character information, a bar code scanner 19 for scanning a bar code, a bar code reader 20 for converting a bar code signal read by the bar code scanner 19 into an electric signal, and a telephone line 1. Modem 21 for transmitting and receiving data, each component 1
It comprises a CPU 22 for controlling 1 to 21 and a bus 23 for connecting the above-mentioned respective components. Further, as a searchable medium, as shown in FIG. 2, a bar code 32 may be attached to a part of each article 31 of the newspaper 30, and the database 2 can be stored in the bar code 32. It suffices if the information related to each article is constructed correspondingly.

By adding a hard disk 17, a printer 18, a bar code scanner 19, a bar code reader 20 and a modem 21 to an ordinary personal computer,
The same configuration as the input / output device 3 can be used. Further, as the barcode scanner 19, a handy pen type which manually scans a pen, a handy CCD type which electronically scans a barcode image by incorporating an image sensor such as CCD, and a laser beam is scanned by a rotating mirror or the like. A handy laser type can be used.
Further, although the communication method using the telephone line 1 is used in the present embodiment, the searchable information is stored in the database by a wireless communication method, a communication method using a dedicated line, or in a device connected in the hard disk 17 or the memory 16. There is no problem even if it is used as 2.

Now, a method for obtaining the information related to the desired document will be described with reference to the flowchart of FIG. 3 and the explanatory view of the system of the present invention of FIG. As shown in the flowchart of FIG. 3, first, the power supply of the input / output device 3 is turned on (step 101), and the database is accessed through the telephone line 1 (step 102). Then, the barcode 32 provided on the document is scanned by the barcode scanner 19 (step 103), converted into an electric signal by the barcode reader 20 (step 104), and then electrically converted to the database 2 via the modem 21. A signal is transmitted (step 105). On the database 2 side, the information related to the document corresponding to the bar code 32 is searched by the received electric signal (step 106), and the searched information is transmitted to the input / output device 3 of the user (step 107).
The input / output device 3 receives the information transmitted from the database 2 (step 108), stores the information in the memory 16 or the hard disk 17 (step 109), and displays it on the liquid crystal display device 13 or prints it with the printer 18 ( After step 110), the power supply of the input / output device 3 is turned off to end the process (step 111).

As described above, since the information related to the document desired to be obtained can be obtained only by scanning the bar code 32 with the bar code scanner 19, there is no need to consider or enter a search keyword or search formula. , It becomes possible to search very easily and in a short time without making a mistake. Also, if you need to obtain information related to the cut out document by cutting out the file and cutting out the file or cutting out only the barcode 32 part and file it, you can easily obtain it. become able to. Further, since the search condition is the barcode 32, it becomes possible to sufficiently deal with a huge number of search numbers.

As shown in FIG. 4 (a), the information content of the code number read by the bar code scanner 19 is at least the database name number, article / document,
It suffices if it includes numbers indicating numbers, figures, tables, etc. Further, as shown in FIG. 4B, the information content when transmitting from the user's input / output device 3 to the database 2 may include at least a code number, an ID number, and a password. Other than that can be set in advance before starting communication. Then, as shown in FIG. 4C, at least the code number, as the information content when transmitting from the database 2 to the user,
It may include the user name, user telephone number, and information related to the document. Further, as shown in FIG. 4D, the information content when displaying by the liquid crystal display device 13 or printing by the printer 18 may include at least a code number and information related to a document.

Further, by adding the bar code 32 to the posting column and the questionnaire column so that the sentence created in advance in the input / output device 3 can be transferred to the database 2, the opinions and impressions of the user can be immediately obtained. You can also let me know.

[0012]

As described above, according to the database search system of the present invention, a search condition is established by connecting to a database in which information related to articles, documents, numerical values, figures, tables, etc. on a document is constructed. In a database search system in which the user can obtain the information he / she wants to obtain from the database by giving,
A medium having a bar code representing a part of a figure, a table, etc., an input / output device for transmitting a signal generated by reading the bar code to the database and receiving information retrieved from the database, By using a database search system that consists of a database that sends information corresponding to barcodes to users based on the signals read by the output device, you can scan the barcodes with a barcode scanner and associate it with the document you want to obtain. To be able to get the information to
There is no need to think or enter a search keyword or search formula, and it is extremely easy and can be done without fail in a short time. Articles can be cut out and filed, or only the bar code part can be cut out and filed. That way, if you suddenly need to get information,
It is possible to provide a database search system that can be easily obtained and can sufficiently deal with a huge number of search numbers because it is a bar code.

[Brief description of drawings]

FIG. 1 is a diagram showing the configuration of a database search system according to the present invention.

FIG. 2 is a diagram showing a configuration of a newspaper according to the present invention.

FIG. 3 is a flowchart showing a flow of a database search system according to the present invention.

FIG. 4 is a diagram showing information content according to the present invention, (a)
Is the information content of the code number, (b) is the information content that the input / output device sends to the database, (c) is the information content that the database sends to the input / output device,
(D) is information content to be displayed or printed.

[Explanation of symbols]

 1: Telephone line 2: Database 3: Input / output device 11: Keyboard 12: Keyboard controller (KEYC) 13: Liquid crystal display device (LCD) 14: Liquid crystal drive circuit (LCDRV) 15: Video image memory (GVRA) 16: Memory 17: Hard Disk (HDD) 18: Printer 19: Bar Code Scanner 20: Bar Code Reader 21: Modem 22: CPU 23: Bus 30: Newspaper 31: Article 32: Bar Code

Claims (1)

[Claims] 1. Obtaining information that a user wants to obtain from a database by connecting to a database in which information related to written articles, documents, numbers, figures, tables, etc. is constructed and giving search conditions. In a database search system capable of performing, a medium to which a bar code representing a part of the article, document, numerical value, figure, table, etc. is attached, and a signal generated by reading the bar code is transmitted to the database and is transmitted from the database. An input / output device for receiving the retrieved information, and a database for transmitting the information corresponding to the barcode to the user by the signal read by the input / output device,
A database search system characterized by: