Teradata US, Inc.

Yi Xia

Paul Laurence Sinclair

Grace Kwan-On Au

Rama Krishna Korlapati

Mohammed Yassin Al-Kateb

Sanjay Nair

Kuorong Chiang

Tri Minh Tran

Sanjib Kumar Mishra

Anantha B Subramanian

Chengyang Zhang

Bin Cao

Techniques for improving complex database queries are provided. A determination is made whether to adopt a static or dynamic query execution plan for a received database query based on metrics. When a dynamic query execution plan is adopted, the database query is separated into query fragments. A plan fragment is generated for each query fragment and executed to generate feedback for the plan fragment. The feedback from the execution of each plan fragment is used to initiate query rewrite rules to simplify the corresponding query fragments. The rewritten query fragments are combined to generate the dynamic query plan.

Incremental simplification and optimization of complex queries using dynamic result feedback

A data store system includes an array of persistent storage devices configured to store a plurality of data store tables. The data store system includes a processor in communication with the storage device. The processor may receive a query comprising an aggregate function and identify structure of an argument of the aggregate function. The subset of data store tables may be associated with the argument. The processor may partially-execute the aggregate function on each data store table in the subset involved in the argument of the aggregate function to create partially-executed results for each data store table of the subset of data store tables. The processor may join the partially-executed results based on join conditions contained in the aggregate function. The processor may complete execution of the aggregate function on the partially-executed results to generate a final result of the aggregate function. A method and computer-readable medium are also disclosed.

Multi-table aggregation through partial-group-by processing

Growing community of inventors

Rancho Palos Verdes, CA, United States of America

Yi Xia