- Patent Title: Query processing using logical query steps having canonical forms
-
Application No.: US17446679Application Date: 2021-09-01
-
Publication No.: US11940997B2Publication Date: 2024-03-26
- Inventor: Ahmad Ghazal , Ron-Chung Hu , Mingyi Zhang
- Applicant: Futurewei Technologies, Inc.
- Applicant Address: US TX Plano
- Assignee: Futurewei Technologies, Inc.
- Current Assignee: Futurewei Technologies, Inc.
- Current Assignee Address: US TX Addison
- Agency: Schwegman Lundberg & Woessner, P.A.
- Main IPC: G06F16/24
- IPC: G06F16/24 ; G06F16/22 ; G06F16/242 ; G06F16/2455

Abstract:
A query processing device includes a communication interface accessing a database and database catalog, a memory storing instructions, and a processor coupled to the memory and the communication interface. The processor executes the instructions to parse a query and generate first and second execution plans for the query, retrieve respective previously determined cardinality values for previously executed logical steps of the first and second execution plans from the database catalog, select an execution plan from the first execution plan or the second execution plan, the selected execution plan having a lower cost based on the previously determined cardinality values, and execute the selected execution plan on data accessed from the database. The query processing system stores actual cardinality values determined during the execution of the logical steps in the database catalog for use by subsequent queries. The query processing device, therefore, re-uses previously determined cardinality values.
Public/Granted literature
- US20220004551A1 QUERY PROCESSING USING LOGICAL QUERY STEPS HAVING CANONICAL FORMS Public/Granted day:2022-01-06
Information query