US6269359B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Relational data base system and method for rapidly realizing a query to a database
Assignee: Fujitsu Ltd
•
Filing: 1993-01-28
•
Granted: 2001-07-31
•
Expires: 2013-01-28
Abstract
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.
Inventors
- 👤 Yutaka Sekine
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-07 13:20
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/245; G06F16/2453; G06F16/24534; G06F16/24535; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932
Claims Analysis
Total Claims: 6
Claim 1
Independent Claim
233 words
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.
Claim 2
Dependent Claim
233 words
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.
Claim 3
Dependent Claim
65 words
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.
Claim 4
Dependent Claim
40 words
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.
Claim 5
Dependent Claim
171 words
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.
Claim 6
Dependent Claim
171 words
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.
References Cited (Backward Citations)
US4330822A
Cited
US4829427A
Cited
US4769772A
Cited
GB2172130A
Cited
US5276870A
Cited
US5091852A
Cited
US5257366A
Cited
US5379419A
Cited
US5367675A
Cited
US5301317A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2004-07-30 | 2005-01-29 | 2005-07-31 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2008-07-30 | 2009-01-29 | 2009-07-31 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2012-07-30 | 2013-01-29 | 2013-07-31 | $7700.00 | Window Closed / Lapsed |