SQL语句执行方法和装置、计算机设备、存储介质
By establishing a mapping relationship between database tables and physical tables, the problem of slow database table query speed is solved, enabling efficient SQL statement execution and flexible database development.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- JINGDONG TECH HLDG CO LTD
- Filing Date
- 2023-03-23
- Publication Date
- 2026-07-17
AI Technical Summary
In existing technologies, the data query processing speed of specific database tables is relatively low, especially when the amount of data in the related tables is large, the query processing speed will drop significantly.
By obtaining the description information, configuration information, and database resource information of the target database table, the target translator and the target physical database resources are determined. The first SQL statement is translated into a second SQL statement executable by the target physical database using the first mapping relationship. The mapping relationship is directly established between a single database table and a single physical table, avoiding the query conversion process between multiple database related tables.
It improves data query speed, reduces the difficulty and cost of developing and maintaining heterogeneous databases, enhances development flexibility, and avoids modifications to physical table definitions.
Smart Images
Figure CN116303542B_ABST