Relational data base system and method for rapidly realizing a query to a database

• US 6,269,359 B1
• Filed: 01/28/1993
• Issued: 07/31/2001
• Est. Priority Date: 01/30/1992
• Status: Expired due to Fees

• Current Assignee: Fujitsu Limited
• Original Assignee: Fujitsu Limited
• Inventors: Sekine, Yutaka
• Primary Examiner(s): Alam, Hosain T.
• Application Number:
  US08/010,291
• Time in Patent Office: 3,106 Days
• Field of Search: 395/660, 395/700, 395/650, 395/601-606, 707/1-3, 707/10
• US Class Current: 1/1
• CPC Class Codes: G06F 16/24535 of sub-queries or views
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing

Abstract

In a relational data base system having a function of view resolution for analyzing a query sentence in an execution procedure for a query from a user, using a content defined in a view table for the query designating the view table, converting the retrieval of the view table to that of an actual table, and creating the execution procedure, the system includes: an early bind definition unit for the view table for creating plural execution procedures in advance to realize the query to the defined view table in accordance with a query structure to the view table; a definition information dictionary operatively connected to the early bind definition means; an execution procedure management unit provided in the definition information dictionary for storing plural execution procedures to realize the query to the view table previously created; an execution procedure composition unit operatively connected to the definition information dictionary for retrieving an information of the execution procedure stored in the dictionary when receiving the query to the defined view table, extracting the execution procedure adapted to the query, and composing the extracted execution procedure with the query input from the user; and an execution unit operatively connected to the execution procedure composition unit for executing the composed execution procedure.

Claims

1. A relational data base system having a function of view resolution for analyzing a query sentence in an execution procedure for a query from a user, using a content defined in a view table for the query designating the view table, converting a retrieval of the view table to that of an actual table, and creating the execution procedure, the system comprising:

early bind definition means for creating and updating by an evaluation execution time a plurality of execution procedures when the view table is defined and before a query is inputted, to realize the query subsequently inputted to the view table in accordance with a query structure to the view table;

a definition information dictionary operatively connected to the early bind definition means to store information;

execution procedure management means provided in the definition information dictionary for storing said plurality of execution procedures to realize the query subsequently inputted to the view table;

execution procedure composition means operatively connected to the definition information dictionary for retrieving, based on object query conditions, a corresponding one of the plurality of execution procedures stored in the definition information dictionary when the query to the view table is inputted, for extracting the one execution procedure adapted to the query, and for composing the extracted execution procedure with the query; and

execution means operatively connected to the execution procedure composition means for executing the composed execution procedure.

2. A relational data base system as claimed in claim 1, wherein the definition information dictionary further comprises:

a table definition management table for storing a type of table and an indication of an early bind for the view table;

a content management table for storing the content defined in the view table; and

an index management table for storing a name of an index.

3. A relational data base system as claimed in claim 1, wherein the execution procedure management means comprises column conditions for the view table, and wherein one of said plurality of execution procedures executes contents described in the column conditions.

4. A relational data base method for analyzing a query sentence in an execution procedure for a query from a user, using a content defined in a view table for the query designating the view table, converting a retrieval of the view table to that of an actual table, and creating the execution procedure, the method comprising the steps of:

creating and updating by an evaluation execution time a plurality of execution procedures when the view table is defined and before a query is inputted, to realize the query subsequently inputted to the view table in accordance with a query structure to the view table;

storing information and said plurality of execution procedures to realize the query subsequently inputted to the view table;

retrieving, based on object query conditions, a corresponding one of the stored plurality of execution procedures when the query to the view table is inputted, extracting the one execution procedure adapted to the query, and composing the extracted execution procedure with the query; and

executing the composed execution procedure.