Login| Sign Up| Help| Contact|

Patent Searching and Data


Title:
DATA PROCESSING METHOD, ELECTRONIC DEVICE, AND STORAGE MEDIUM
Document Type and Number:
WIPO Patent Application WO/2023/232120
Kind Code:
A1
Abstract:
Embodiments of the present application provide a data processing method, an electronic device, and a storage medium. In the embodiments of the present application, an index tree scanning mode is used in combination with a mechanism of data pages for randomly sampling a database table, and in the process of obtaining random sampling data in a target database table, full table scan does not need to be carried out on the target database table, so that the number of I/O accesses to a disk is effectively reduced, the I/O resource of the disk is saved, and the query performance of a database system is enhanced, especially under the condition that a distributed database system has mass data.

Inventors:
MA ZHANFENG (CN)
YANG XINJUN (CN)
ZHAO JIANWEI (CN)
LI FEIFEI (CN)
HUANG GUI (CN)
Application Number:
PCT/CN2023/097899
Publication Date:
December 07, 2023
Filing Date:
June 01, 2023
Export Citation:
Click for automatic bibliography generation   Help
Assignee:
ALIBABA CLOUD COMPUTING LTD (CN)
International Classes:
G06F16/22
Foreign References:
CN115168338A2022-10-11
CN108614836A2018-10-02
US20030097354A12003-05-22
Other References:
ANONYMOUS: "[mysql] Full table scan process & clustered index differences and connections", CSDN, 16 January 2021 (2021-01-16), XP093117175, Retrieved from the Internet [retrieved on 20210116]
WALE GARRETT: " Full table scan and index tree scan in MySQL ", BLOG PARK, 14 May 2022 (2022-05-14), XP093117174, Retrieved from the Internet [retrieved on 20220514]
ZECY: " MySQL and Oracle randomly select N records in Oracle ", CSDN BLOG, 18 March 2021 (2021-03-18), XP093117178, Retrieved from the Internet [retrieved on 20240109]
Attorney, Agent or Firm:
BEIJING TONGJUN LAW FIRM (CN)
Download PDF: