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

Data storage method and device

A data storage and data technology, applied in database indexing, electronic digital data processing, structured data retrieval, etc., can solve problems such as insufficient database performance, achieve the effects of simplifying component design and implementation, reducing computing time, and optimizing performance

Pending Publication Date: 2020-09-29
北京智通寰宇科技有限公司
View PDF5 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The technical problem to be solved by the present invention lies in the problem of insufficient performance of the database. Aiming at the defects in the prior art, a

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
  • Data storage method and device
  • Data storage method and device
  • Data storage method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0066] In order to solve the technical problems of the existing HTAP technical solution being blunt and unsatisfactory in performance, an embodiment of the present invention proposes a data storage method, which can automatically select a storage structure to improve database performance. The data storage method uses artificial intelligence technology to achieve the improvement of database performance in HTAP tasks by dynamically selecting the storage structure, and on this basis, an autonomous database system without human intervention is designed. Compared with the existing autonomous database system, this data storage method proposes a new design direction—storage structure design. This design direction can further strengthen the design space of the autonomous database, and can further improve the performance of the existing autonomous database. .

[0067] Such as figure 1 As shown, a data storage method provided by an embodiment of the present invention includes the follo...

Embodiment 2

[0093] Such as figure 2 As shown, the second embodiment is basically the same as the first embodiment, and the similarities will not be repeated. The difference lies in:

[0094] When applying a data storage method in the embodiment of the present invention, it can be divided into two parts. The first part is to obtain the performance model of the storage structure in different data characteristics under the current environment. The content of this part is only for the first time. It runs once when the database is running; the second part is the automatic generation of the optimal storage structure, which runs regularly and once for each partition of each data table. Partitioning reduces the amount of data required for sampling, improves the parallelism of design tasks, and can also adapt to query loads that are not evenly distributed on the data, because in this case each partition may have a different optimal storage structure.

[0095] When implementing the data storage m...

Embodiment 3

[0117] Such as Figure 5 As shown, a data storage device 5 according to an embodiment of the present invention includes: a testing module 51 , a selection module 52 , a calculation module 53 and a replacement module 54 .

[0118] in,

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 invention discloses a data storage method and device, and relates to the technical field of computers. One specific embodiment of the method comprises the steps of performing performance testing on a target database to generate a performance expression model of each type of storage structure; predicting a query load of the target database, and selecting a to-be-selected storage structure according to the query load and data characteristics of the to-be-stored data; calculating a performance prediction value of each data feature in each to-be-selected storage structure according to the performance expression model, and obtaining the total cost of each to-be-selected storage structure based on each performance prediction value; and selecting the to-be-selected storage structure with theminimum total cost as an optimal storage structure, and replacing the current storage structure with the optimal storage structure. According to the embodiment, the storage structure can be flexibly selected, so that the database performance is improved.

Description

technical field [0001] The present invention relates to the technical field, in particular to a data storage method and device. Background technique [0002] In the era of big data, the diversity of data patterns, the complexity of data usage, and the volume of data pose greater challenges to database management systems. Users can no longer use a single database management system to manage different data, but select the corresponding database according to the different characteristics of the data. Researchers divide relational big data into online transaction processing (OLTP), online analytical processing (OLAP) and streaming computing (Streaming) according to usage characteristics, and develop corresponding database management systems to manage their data. These database management systems are deeply customized during research and development, and the design of each component is very different. [0003] Due to the increase in the number and complexity of database systems...

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/21G06F16/22G06F16/2455
CPCG06F16/217G06F16/22G06F16/24564
Inventor 王宏志魏龑郑博梁栋燕钰
Owner 北京智通寰宇科技有限公司
Features
  • Generate Ideas
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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