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.
Legal claims defining the scope of protection, as filed with the USPTO.
2. The system of claim 1, wherein the element of the database schema corresponds to data stored by a remote data storage service.
3. The system of claim 1, wherein the element refers to data potentially stored in at least one of a semi-structured or unstructured collection of data.
4. The system of claim 3, wherein the at least one memory comprising further instructions that, in response to being executed by the at least one processor, cause the system at least to parse at least one of the semi-structured or unstructured collection of data to identify data corresponding to the element of the database schema.
5. The system of claim 1, wherein the at least one memory comprising further instructions that, in response to being executed by the at least one processor, cause the system at least to execute the query of a view based at least in part on an estimated cost of resolving unresolved references included in the definition.
7. The method of claim 6, wherein the element of the database schema refers to a collection of data stored externally to the database.
8. The method of claim 6, wherein the element refers to data potentially stored in at least one of a semi-structured or unstructured collection of data.
9. The method of claim 6, wherein the definition of the view is validated without determining whether schema elements referenced by the definition of the view correspond to defined elements of the database schema.
10. The method of claim 9, further comprising determining, each time the view is queried, whether schema elements referenced by the definition of the view correspond to defined elements of the database schema.
12. The method of claim 6, wherein validating the definition of the view comprises determining that the definition is syntactically valid without determining whether the definition comprises references to non-existent elements of the database schema.
13. The method of claim 6, further comprising formulating a query plan based at least in part on a cost of resolving the reference to the element.
15. The non-transitory computer-readable storage medium of claim 14, wherein the element of the database schema refers to a collection of data stored externally to the database.
16. The non-transitory computer-readable storage medium of claim 14, wherein the element refers to at least one of a structured or semi-structured collection of data.
17. The non-transitory computer-readable storage medium of claim 14, wherein the instructions further comprise instructions that, as a result of being executed by the one or more processors, cause the computer system to validate the definition of the view without determining whether schema elements referenced by the definition of the view correspond to defined elements of the database schema.
18. The non-transitory computer-readable storage medium of claim 14, wherein the instructions further comprise instructions that, as a result of being executed by the one or more processors, cause the computer system to determine, each time the view is queried, whether schema elements referenced by the definition of the view correspond to existing elements of the database schema.
19. The non-transitory computer-readable storage medium of claim 14, wherein the instructions further comprise instructions that, as a result of being executed by the one or more processors, cause the computer system to resolve the reference to the element by at least retrieving a column of data corresponding to the element from a remote data store.
20. The non-transitory computer-readable storage medium of claim 14, further comprising estimating a cost of resolving references to the element of the database schema.
Cooperative Patent Classification codes for this invention. Click any code to explore related patents in that topic.
May 17, 2018
April 16, 2024
Browse 5M+ US patents with plain-English claim translations and AI-generated analysis.