Database processing method and device
A processing method and technology of processing equipment, applied in the field of data processing, can solve problems such as hindering other operations of the database and low efficiency of defragmentation, and achieve the effect of improving operation efficiency
Active Publication Date: 2021-05-25
SAMSUNG ELECTRONICS CHINA R&D CENT +1
View PDF6 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0006] The purpose of the exemplary embodiment of the present invention is to provide users with a database processing method and equipment to solve the technical problems in the prior art that the defragmentation efficiency is low and other operations on the database are hindered during the defragmentation process
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0041] Various example embodiments will now be described more fully with reference to the accompanying drawings, in which some example embodiments are shown.
[0042] figure 1 A flowchart showing a database processing method according to an exemplary embodiment of the present invention.
[0043] refer to figure 1 , in step S10, acquire statistical information about the database to be organized in the terminal, and provide the acquired statistical information. As an example, the database to be sorted may be an embedded database, such as an SQLite database.
[0044]Preferably, the step of obtaining statistical information about the database to be sorted may include: detecting whether there is a predetermined identifier in the database to be sorted, for example, the predetermined identifier may be stored in the handle of the database to be sorted, so the handle of the data to be sorted can be detected Is there a predetermined identifier in .
[0045] If it is detected that th...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
A database processing method and device are provided, the database processing method comprising: obtaining statistical information about a database to be organized in a terminal, and providing the obtained statistical information; determining the operating state of the terminal; based on the determined operating state of the terminal and the provided The statistical information determines the data processing mode of the database to be sorted; defragmentation is performed on the database to be sorted in the determined data processing mode. By adopting the database processing method and device of the exemplary embodiments of the present invention, the statistical information of the database to be sorted can be automatically collected, and the database to be sorted can be defragmented by using different data processing methods based on the operating status of the terminal, which improves the subsequent The operational efficiency of the database.
Description
technical field [0001] The present invention relates to the field of data processing, more specifically, to a database processing method and equipment. Background technique [0002] The ideal state of the database file structure is that the logical adjacent pages of tables and indexes are stored as continuously as possible in the file, the space in the page is fully utilized and the records are compact. The logical adjacent pages and records of many tables and indexes cannot be guaranteed to be stored consecutively when they are saved in the database file, so fragmentation occurs. Database fragmentation affects the performance of database queries, inserts, deletes, and updates. [0003] There are two existing defragmentation methods for databases: [0004] The first method of defragmentation needs to query the fragmentation rate of a certain index of the database through an upper-level application or middleware program other than the database, and then decide to initiate a...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/215
CPCG06F16/215
Inventor 谭姝向小岩张海蒂刘飞刘庭芳
Owner SAMSUNG ELECTRONICS CHINA R&D CENT