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

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.