JPH04260172A - Data base retrieving system - Google Patents
Data base retrieving systemInfo
- Publication number
- JPH04260172A JPH04260172A JP3022027A JP2202791A JPH04260172A JP H04260172 A JPH04260172 A JP H04260172A JP 3022027 A JP3022027 A JP 3022027A JP 2202791 A JP2202791 A JP 2202791A JP H04260172 A JPH04260172 A JP H04260172A
- Authority
- JP
- Japan
- Prior art keywords
- relative position
- data
- data base
- database
- condition
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 claims description 9
- 239000000284 extract Substances 0.000 claims description 2
- 238000010586 diagram Methods 0.000 description 8
- 230000000052 comparative effect Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
【0001】0001
【産業上の利用分野】本発明はデータベースシステムに
おける検索に関し、特に任意の複数条件による検索方式
に関する。BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a search in a database system, and more particularly to a search method using a plurality of arbitrary conditions.
【0002】0002
【従来の技術】従来、プログラムにおいて条件判断を行
う場合、条件データとそれに対するデータ名称で比較を
行っていた。2. Description of the Related Art Conventionally, when determining conditions in a program, comparisons have been made between condition data and the corresponding data names.
【0003】0003
【発明が解決しようとする課題】上述した比較方法では
、任意の複数条件による比較を行う際に、あらゆる条件
の組み合わせを想定しなければならずプログラム規模が
膨大になるという欠点がある。SUMMARY OF THE INVENTION The above-mentioned comparison method has the disadvantage that when performing a comparison based on a plurality of arbitrary conditions, all combinations of conditions must be assumed, resulting in an enormous program size.
【0004】0004
【課題を解決するための手段】本発明のデータベース検
索方式は、データベース表の全データ項目の相対位置を
指定した相対位置表を参照して検索項目を抽出し、前記
検索項目と検索条件とを比較するようにして構成される
。[Means for Solving the Problems] The database search method of the present invention extracts search items by referring to a relative position table that specifies the relative positions of all data items in a database table, and matches the search items and search conditions. It is constructed in a comparative manner.
【0005】また、本発明のデータベース検索方式は、
データベースにおける各データ項目の相対位置を示す相
対位置表と、前記相対位置表を参照して前記データベー
スから抽出したデータと検索条件とを比較する比較手段
とを有する。[0005] Furthermore, the database search method of the present invention is as follows:
It has a relative position table that indicates the relative position of each data item in the database, and a comparison means that refers to the relative position table and compares data extracted from the database with search conditions.
【0006】[0006]
【実施例】以下、本発明について図面を参照して詳細に
説明する。DESCRIPTION OF THE PREFERRED EMBODIMENTS The present invention will be described in detail below with reference to the drawings.
【0007】図1は本発明の一実施例を示す説明図であ
る。同図においてデータベース検索方式はデータベース
表の相対位置表化手段1と、比較手段2とから構成され
ている。FIG. 1 is an explanatory diagram showing one embodiment of the present invention. In the figure, the database search method is composed of a database table relative position tabulating means 1 and a comparing means 2.
【0008】図2(a)はデータベースの構造例を示す
説明図、同図(b)はその相対位置表を示す説明図であ
る。例えば、人事データベース表(a)の「所属=総務
部かつ 性別=男」のデータを検索すると、最初に人
事データベース表(a)の全データ項目の項目番号・開
始位置・終了位置・桁数を基に相対位置表(b)を作成
する。FIG. 2(a) is an explanatory diagram showing an example of the structure of a database, and FIG. 2(b) is an explanatory diagram showing its relative position table. For example, if you search for data for "Affiliation = General Affairs Department and Gender = Male" in the personnel database table (a), first find the item number, start position, end position, and number of digits of all data items in the personnel database table (a). Based on this, a relative position table (b) is created.
【0009】図3は上記のデータベース検索方式の動作
を示す説明図である。相対位置表を作成した後、所属コ
ードで(相対位置表の項目NO.に対応している)で相
対位置表(b)を参照すると、開始位置「53」・終了
位置「56」・桁数「4」を得る。この時、総務部「0
001」の値を条件エリアに移送する。FIG. 3 is an explanatory diagram showing the operation of the above database search method. After creating the relative position table, if you refer to the relative position table (b) using the affiliation code (corresponding to the item number in the relative position table), you will see the start position "53", end position "56", and number of digits. Get "4". At this time, the General Affairs Department “0
001" value to the condition area.
【0010】次に、開始位置「53」・終了位置「56
」より、データベース表(a)の相対位置「53〜56
」の部分を比較エリアに移送する。Next, start position "53" and end position "56"
”, the relative position of database table (a) “53-56
" part is transferred to the comparison area.
【0011】最後に、条件エリアと比較エリアの内容を
比較する。条件が満たされれば、性別についても同様の
処理を行う。Finally, the contents of the condition area and the comparison area are compared. If the conditions are met, the same process is performed for gender.
【0012】0012
【発明の効果】以上、説明したように本発明は、相対位
置表を利用することにより、各種データベース表におい
て任意の複数条件による検索を容易に行えるという効果
がある。As described above, the present invention has the advantage that by using a relative position table, searches can be easily performed in various database tables based on a plurality of arbitrary conditions.
【図1】本発明の一実施例を示す説明図。FIG. 1 is an explanatory diagram showing one embodiment of the present invention.
【図2】(a)はデータベース表の例を示す説明図、(
b)はそれに対応する相対位置表を示す説明図。[Figure 2] (a) is an explanatory diagram showing an example of a database table;
b) is an explanatory diagram showing a relative position table corresponding thereto.
【図3】本発明の動作を示す説明図。FIG. 3 is an explanatory diagram showing the operation of the present invention.
1 相対位置表化手段 2 比較手段 1 Relative position tabulation means 2. Comparison means
Claims (2)
位置を指定した相対位置表を参照して検索項目を抽出し
、前記検索項目と検索条件とを比較することを特徴とす
るデータベース検索方式。1. A database search method, which extracts search items by referring to a relative position table specifying the relative positions of all data items in a database table, and compares the search items with search conditions.
相対位置を示す相対位置表と、前記相対位置表を参照し
て前記データベースから抽出したデータと検索条件とを
比較する比較手段とを有することを特徴とする請求項1
記載のデータベース検索方式。2. The invention is characterized by comprising a relative position table indicating the relative position of each data item in the database, and comparison means for comparing data extracted from the database with search conditions by referring to the relative position table. Claim 1
Database search method described.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
JP3022027A JPH04260172A (en) | 1991-02-15 | 1991-02-15 | Data base retrieving system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
JP3022027A JPH04260172A (en) | 1991-02-15 | 1991-02-15 | Data base retrieving system |
Publications (1)
Publication Number | Publication Date |
---|---|
JPH04260172A true JPH04260172A (en) | 1992-09-16 |
Family
ID=12071505
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
JP3022027A Pending JPH04260172A (en) | 1991-02-15 | 1991-02-15 | Data base retrieving system |
Country Status (1)
Country | Link |
---|---|
JP (1) | JPH04260172A (en) |
Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH02257285A (en) * | 1989-03-29 | 1990-10-18 | Chubu Nippon Denki Software Kk | Data base retrieval table generating system |
-
1991
- 1991-02-15 JP JP3022027A patent/JPH04260172A/en active Pending
Patent Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH02257285A (en) * | 1989-03-29 | 1990-10-18 | Chubu Nippon Denki Software Kk | Data base retrieval table generating system |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106874401A (en) | A kind of ciphertext index method of data base-oriented encrypted fields fuzzy search | |
JP3603392B2 (en) | Document classification support method and apparatus | |
JPH04260172A (en) | Data base retrieving system | |
JPH0644309A (en) | Data base managing system | |
JPS617936A (en) | Information retrieving system | |
JPH0619756A (en) | Edi format conversion method | |
JP2583879B2 (en) | Information retrieval device | |
CA2375481A1 (en) | A method and system for referencing, archiving and retrieving symbolically linked information | |
JPH01163826A (en) | Coupling processing system for relational data base | |
JP2718107B2 (en) | Comparison processing method | |
JPS63238622A (en) | Relation retrieval system | |
JPS613266A (en) | Kanji conversion system for katakana described name | |
JPH0795300B2 (en) | Name management method in database | |
JPH0546669A (en) | Hit ratio improvement system for data base retrieval system | |
JPH04116772A (en) | Connection data base retrieval device | |
JPH03245233A (en) | Label retrieving system | |
JPS61141036A (en) | Data retrieval system | |
JPH0798711A (en) | And calculating/retrieving system for table | |
JPS63286930A (en) | Character string retrieving device | |
JPH06274385A (en) | Data base system | |
JPS60247756A (en) | Data base device | |
JPH07129446A (en) | Data base access method | |
JPH04360272A (en) | Personnel information retrieving system | |
JPH0447367A (en) | Data base retrieval system | |
JPH0340070A (en) | Data base retrieving device |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
A02 | Decision of refusal |
Free format text: JAPANESE INTERMEDIATE CODE: A02 Effective date: 19980217 |