Late-binding database views
AssigneeAmazon Technologies, Inc.
InventorsHuiyuan Wang, Meng Tong, Naresh Kishin Chainani, Mengchu Cai
Life of this patent
Estimating the term…
Abstract
A database management system receives a command defining a view of the database. The view definition is accepted without determining whether references to schema elements within the view definition are resolvable to existing elements of the database schema. A query of the view is received. In response to the query of the view, the database management system resolves references to schema elements in the view definition by determining whether the references correspond to data available for processing the query.
Claims20
A system comprising:
- at least one processor;
- and
- at least one memory comprising instructions that, in response to being executed by the at least one processor, cause the system at least to:
- receive a definition of a view of a database, the definition comprising a reference to an element of a database schema;
- validate the definition of the view by at least determining that the definition is syntactically correct, without determining whether the reference identifies a corresponding schema element of the database schema;
- provide to a client of the system, prior to determining whether the reference to the element refers to the corresponding schema element of the database schema, an indication that queries of the view may be submitted for processing by the system, the indication provided based at least in part on the validation of the definition of the view of the database;
- and
- resolve the reference to the element in response to a request to query the view, by at least determining that data corresponding to the element is available for processing the query.
A method, comprising:
- receiving, at a database management system, a definition of a view of a database, the definition comprising a reference to an element of a database schema;
- validating the definition of the view without resolving the reference to the element, based at least in part on determining that the definition of the view is syntactically valid;
- providing to a client of the database management system, without determining whether the reference to the element refers to a corresponding schema element of the database schema, an indication that a query may be submitted to the view for processing by the database management system, the indication based at least in part on the validation of the definition of the view;
- and
- resolving the reference to the element in response to a request to query the view, wherein resolving the reference comprises determining that data corresponding to the element is accessible for processing the query.
A non-transitory computer-readable storage medium having stored thereon executable instructions that, as a result of being executed by one or more processors of a computer system, cause the computer system to at least:
- determine that a command comprises a definition of a view of a database, the definition comprising a reference to an element of a database schema;
- validate the definition of the view without resolving whether the reference to the element identifies a corresponding schema element of the database schema, based at least in part on determining that the definition of the view is syntactically valid;
- provide to a client, prior to determining whether the reference to the element refers to the corresponding schema element, an indication that queries of the view may be submitted for processing by the computer system, the indication is based at least in part on the validation of the definition of the view;
- and
- resolve the reference to the element in response to a request to query the view, wherein resolving the reference comprises determining that data corresponding to the element is available for processing the query.
Dependencies are inferred from the claim text.