Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Database management method and device, equipment and storage medium

A management method and database technology, applied in the field of database management methods, equipment, storage media, and devices, can solve problems such as difficulty in guaranteeing query performance of database tables, and achieve the effect of improving business processing efficiency and good query performance

Pending Publication Date: 2021-05-11
BIGO TECH PTE LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

For some usage scenarios, database managers or database users often encounter various types or strategies of table structures customized according to business needs. The diversification of table structures makes it difficult to guarantee the query performance of database tables and needs to be optimized.

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 more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Database management method and device, equipment and storage medium
  • Database management method and device, equipment and storage medium
  • Database management method and device, equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] The present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, but not to limit the present invention. In addition, it should be noted that, for the convenience of description, only some structures related to the present invention are shown in the drawings but not all structures. In addition, the embodiments and the features in the embodiments of the present invention can be combined with each other under the condition of no conflict.

[0021] figure 1 It is a schematic flowchart of a database management method provided by an embodiment of the present invention. The method can be executed by a database management device, wherein the device can be implemented by software and / or hardware, and generally can be integrated into a computer device.

[0022] In the embodiment of the present inventi...

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

No PUM Login to View More

Abstract

The embodiment of the invention discloses a database management method and device, equipment and a storage medium. The method comprises the steps of obtaining corresponding execution information when a target query statement is executed in an original database table; adjusting an original table structure of the original database table according to the execution information to obtain a target table structure; and generating a target database table according to the target table structure and data in the original database table, first query performance index information when the target query statement being executed in the target database table is superior to second query performance index information when the target query statement is executed in the original database table. According to the technical scheme provided by the embodiment of the invention, for the target query statement, the table structure of the original database table is adjusted according to the execution information, so that better query performance can be obtained when execution is performed again in the newly generated target database table, and the business processing efficiency can be improved.

Description

technical field [0001] The embodiments of the present invention relate to the technical field of databases, and in particular, to a database management method, device, equipment, and storage medium. Background technique [0002] With the wide application of database technology and the continuous growth of business data, there are many deficiencies in database management. For some usage scenarios, database managers or database users often encounter various types or strategies of table structures customized according to business needs. The diversification of table structures makes it difficult to guarantee the query performance of database tables and needs to be optimized. Contents of the invention [0003] The embodiment of the present invention provides a database management method, device, equipment and storage medium, which can optimize the existing database management method. [0004] In a first aspect, an embodiment of the present invention provides a database managem...

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
no application Login to View More
IPC IPC(8): G06F16/22G06F16/2453G06F16/2455G06F16/242G06F16/215
CPCG06F16/2282G06F16/24553G06F16/2433G06F16/2453G06F16/2228G06F16/215
Inventor 陈锦铭丘玉秀
Owner BIGO TECH PTE LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com