DATA PROCESSING METHOD, ELECTRONIC DEVICE, AND STORAGE MEDIUM

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.

More Like This:

WO/2021/099627	METHOD AND ASSOCIATED COMPUTER SYSTEM FOR GENERATING DATA IN A DATA STRUCTURE
WO/2021/035843	SEISMIC NETWORK BIG DATA DEDUPLICATION METHOD BASED ON BLOOM FILTER ALGORITHM
WO/2023/078130	INDEX CREATION METHOD AND APPARATUS, AND COMPUTER-READABLE STORAGE MEDIUM

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:

CN115168338A	2022-10-11
CN108614836A	2018-10-02
US20030097354A1	2003-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:

View/Download PDF PDF Help

Previous Patent: VEHICLE CONTROL METHOD AND APPARATUS, DEVICE, MEDIUM AND VEHICLE

Next Patent: MEASUREMENT METHOD AND COMMUNICATION DEVICE