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

A method and device for migrating database statistical information

A statistical information and database technology, applied in the field of database statistical information migration, can solve the problems of unable to update statistical information, fail to protect user data privacy, unable to view table statistical information, etc., to eliminate manual participation, improve automation and efficiency, protect The effect of data privacy

Active Publication Date: 2022-02-22
ALIBABA GRP HLDG LTD
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The purpose of this application is to provide a method and device for migrating database statistical information to solve the problems in the prior art that the statistical information of tables outside the scope of authority cannot be viewed, the statistical information cannot be simply updated through statements in the database, and the problem of not being able to Can protect user data privacy issues

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
  • A method and device for migrating database statistical information
  • A method and device for migrating database statistical information
  • A method and device for migrating database statistical information

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0048] The application will be described in further detail below in conjunction with the accompanying drawings.

[0049] In a typical configuration of the present application, the terminal, the device serving the network and the trusted party all include one or more processors (CPUs), input / output interfaces, network interfaces and memory.

[0050]Memory may include non-permanent storage in computer readable media, in the form of random access memory (RAM) and / or nonvolatile memory such as read only memory (ROM) or flash RAM. Memory is an example of computer readable media.

[0051] Computer-readable media, including both permanent and non-permanent, removable and non-removable media, can be implemented by any method or technology for storage of information. Information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random acces...

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 purpose of this application is to provide a method and device for migrating database statistical information. According to the analysis request of the statement to be analyzed, the statistical information to be updated in the remote database is pulled to the local database; The statistical information to be updated is converted into the data structure of the local database. It solves the migration problem of automatically pulling the statistical information of the data table in the remote database to the local database, so the corresponding statistical information can be read from the local database, and the database engine level provides the ability to update statistics through statements in the database The function of information; further, the converted statistical information is fed back to the diagnostic statement of the sentence to be analyzed, which can automatically diagnose the problem and perform related optimization, and then delete the relevant information, thereby eliminating manual participation and improving automation and efficiency , and protect user data privacy to meet the needs of the cloud environment.

Description

technical field [0001] The present application relates to the field of computers, in particular to a technique for migrating database statistical information. Background technique [0002] In the database, when there is a problem with the execution of the structured query statement (SQL statement), the existing solution is: the database administrator analyzes the execution plan according to the structured query statement (SQL statement), table structure and statistical information , according to the information provided by the statistical information and the execution plan, determine where the performance problem lies and optimize it accordingly. However, in the cloud environment, due to reasons such as scale, automation, and privacy policies, it is inappropriate for a DBA (Database Administrator, database management and operation and maintenance personnel) to log in to a customer instance and view the table structure and statistical information of the customer instance. Di...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/27G06F16/23G06F16/2458
CPCG06F16/23G06F16/2462G06F16/27
Inventor 窦贤明王佳毅曾文旌
Owner ALIBABA GRP HLDG 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