Materialized view generation based on runtime statistics
AssigneeMicrosoft Technology Licensing, LLC
InventorsBrandon Barry HAYNES, Jyoti LEEKA, Anna PAVLENKO, Rana ALOTAIBI, Alekh JINDAL
Life of this patent
Estimating the term…
Loading patent…
AssigneeMicrosoft Technology Licensing, LLC
InventorsBrandon Barry HAYNES, Jyoti LEEKA, Anna PAVLENKO, Rana ALOTAIBI, Alekh JINDAL
Estimating the term…
Embodiments described herein are directed to generating and returning materialized views for queries (or subexpressions thereof) having a particular relationship with each other. For instance, machine learning-based techniques may be utilized to identify query subexpressions that have at least one of a semantically equivalent relationship or a containment relationship with each other. Responsive to identifying such relationship(s), a materialized view may be generated for the identified subexpressions. When a query is subsequently received, machine learning-based techniques may be utilized to determine whether a subexpression of the query possesses at least one of a semantically equivalent relationship or a containment relationship with another subexpression for which a materialized view has been generated. Responsive to determining that such a subexpression of the query possesses one or more of such relationships, the materialized view generated for the other subexpression is returned.
A system, comprising:
A method, comprising:
A computer-readable storage medium having program instructions recorded thereon that, when executed by at least one processor, perform a method comprising:
Dependencies are inferred from the claim text.