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

Self-adaptive data storage management method and system based on data block

A data storage and management method technology, applied in the computer field, can solve the problems of increasing maintenance and management costs of enterprises

Active Publication Date: 2013-10-09
TSINGHUA UNIV
View PDF4 Cites 33 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Using two sets of databases to solve the data storage problem will undoubtedly greatly increase the maintenance and management costs of the enterprise, and it is not a fundamental solution to the problem

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
  • Self-adaptive data storage management method and system based on data block
  • Self-adaptive data storage management method and system based on data block
  • Self-adaptive data storage management method and system based on data block

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0041] The core idea of ​​the present invention is: during the operation of the database, the workload of the database is collected, counted and analyzed in real time, the storage format of the data is adaptively adjusted in units of data blocks, and row storage is used for data with frequent short transactions such as updates. Column storage is used for data with frequent analysis transactions such as query statistics. The basic unit of data adaptive adjustment is a data block. The data stored in a data block has the same storage format, either all based on row storage, or all based on column storage, using the storage format identifier in the metadata of the data block header To identify the storage format of the data block. There are data blocks of different storage formats in the data file, and any data block can dynamically and adaptively adjust the storage format according to the transformation of the application, so as to effectively support OLTP and OLAP services at 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

No PUM Login to View More

Abstract

The invention provides a self-adaptive data storage management method and system based on a data block. The self-adaptive data storage management method based on the data block includes the steps of obtaining workloads of a database, wherein the workloads comprise SQL statements for accessing the database, obtaining the data block relative to the workloads, determining the access type of the data block according to the workloads, and converting the storage type of the data block according to the access type. The self-adaptive data storage management method and system based on the data block can simultaneously support the OLTP service and the OLAP service.

Description

technical field [0001] The invention relates to the field of computers, in particular to a data block-based self-adaptive data storage management method and system. Background technique [0002] Traditional relational database systems are all based on row storage (referred to as row database). After decades of development history, row database is the most mature technology for integrated data storage and management. They continue to provide the best combination of simplicity, robustness, flexibility, and performance, and bring compatibility with general data management. This method is very suitable for read and write operations, and meets the application scenarios with frequent short transactions. Supports online transaction processing (OLTP) services. The characteristics of a row database are: data is stored by row; in order to improve query efficiency, it is necessary to create auxiliary physical structures such as indexes and materialized views, which require a large amo...

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): G06F17/30
Inventor 张勇崔跃生李超邢春晓冯建华
Owner TSINGHUA UNIV
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