Database search processor for real-time adaptive searching based on request and data structure

• US 5,226,165 A
• Filed: 07/24/1991
• Issued: 07/06/1993
• Est. Priority Date: 10/24/1990
• Status: Expired due to Term

• Current Assignee: International Computers Limited (Fujitsu Limited)
• Original Assignee: International Computers Limited (Fujitsu Limited)
• Inventors: Martin, Michael W.
• Primary Examiner(s): Lee, Thomas C.
• Assistant Examiner(s): Philipp, Timothy L.
• Application Number:
  US07/735,031
• Time in Patent Office: 713 Days
• Field of Search: 395/800, 395/600, 395/700
• US Class Current: 707/758
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: G06F 8/30 Creation or generation of source code
• CPC Class Codes: Y10S 707/99936 Pattern matching access

Abstract

A dedicated search processor searches data retrieved from a disc file in response, to search requests from a host processor. The search processor consists of a programmable processor. The processor has a code generator which generates a machine-code search program specifically tailored to the particular combination of search request and data structure, and containing mainly in-line sequences of instructions. The search program can therefore be executed very rapidly, allowing a high search rate to be sustained.

Claims

1. A database search processor comprising:

a) a programmable processor,

b) means for receiving data to be searched, the data having a specified data structure,

c) means for receiving a search request, said search request including a search value comprising a plurality of characters, and

d) code generator means responsive to the search request, for generating a machine-code search program, specific to the particular search request and data structure, for searching the data, said code generator means comprising means for scanning each said character in said search value and, for each said character, generating a machine-code comparison instruction containing that character as a literal value, and machine-code branch instruction for branching on the result of said comparison instruction, thereby generating an in-line loop-free sequence of machine code for comparing said search value with the data to be searched.

2. A database search processor according to claim 1 wherein the data comprises a series of data records, each said record having a specified record structure, and the machine-code search program generated by the code generator is specific to that record structure.

3. A database search processor according to claim 1 wherein said machine-code search program includes a sequence of instructions for locating the start of each field to be searched within the record.

4. A database search processor according to claim 1 in combination with a data file store comprising at least one disc file unit, for storing the data to be searched.

5. A data processing system comprising:

a) a host processor,

b) a data file store for storing a series of data records representing a database to be searched, each said record having a specified record structure,

c) a database search processor comprising a programmable processor, means for receiving a search request from the host processor said search request including a search value comprising a plurality of characters, and code generator means responsive to the search request, for generating a machine-code search program, specific to the particular search request and data structure, for searching data retrieved from the data file store, said code generator means comprising means for scanning each said character in said search value and, for each said character, generating a machine-code comparison instruction containing that character as a literal value, and a machine-code branch instruction for branching on the result of said comparison instruction, thereby generating an in-line loop-free sequence of machine code for comparing said search value with the data to be searched.

6. A data processing system according to claim 5 wherein the data file store comprises at least one disc file unit.