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

Big data management disaster tolerance method for realizing reading and writing separation based on partition table technology

A read-write separation and partition table technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as inability to cope with big data storage, imperfect database design, etc., to improve stability and security, Ease of maintenance and prevention of disasters

Inactive Publication Date: 2018-09-07
浙江知水信息技术有限公司
View PDF3 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In the current software development process, database design is an important part. There are problems such as imperfect database design, inability to cope with large data storage, and inability to quickly perform disaster backup and restoration. Partition table technology can be used to solve 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
  • Big data management disaster tolerance method for realizing reading and writing separation based on partition table technology

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0016] The present invention will be further explained below in conjunction with the accompanying drawings and specific embodiments.

[0017] A large data management disaster recovery method based on partition table technology to achieve read-write separation, which includes the following steps: Step S1: according to the three partition types of range partition, Hash partition, and composite partition, establish a corresponding partition table; Step S2: pair step Create an index for the partition table established in S1; Step S3: Divide the database into a master database and a slave database; Step S4: The master database handles transactional operations, and the slave database handles SELECT query operations; Step S5: Synchronize the slave database with the master database .

[0018] In an embodiment of the present invention, the partition table includes the following operations: query, insert, update, delete records, add, merge and delete partitions.

[0019] In an embodime...

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 big data management disaster tolerance method for realizing reading and writing separation based on a partition table technology. The big data management disaster tolerance method comprises the following steps: S1, establishing a corresponding partition table according to a range partition, a Hash partition and a composite partition; S2, creating an index for the partitiontable established in the step S1; S3, partitioning a database into a primary database and a slave database; S4, processing a transactional operation by the primary database, and processing a SELECT query operation by the salve database; and S5, synchronizing the slave database and the primary database. Through reading and writing operation, a plurality of libraries coexist, so that the disaster occurrence is avoided effectively, and the data stability and security are improved. On the aspect of data performance, I / O operation is balanced; the physical disk space is allocated reasonably; and the big data query performance is improved greatly. On the other hand, data maintenance is facilitated, and the data availability is enhanced.

Description

technical field [0001] The invention belongs to the application field of database management, and in particular relates to a large data management disaster recovery method that realizes read-write separation based on partition table technology. Background technique [0002] In modern big data software development and application scenarios, oracle database software is mostly used as the carrier of data storage, and oracle database partition technology is an important means and method for oracle database performance optimization, which is useful for dealing with big data processing, improving data query efficiency and Data management disaster recovery backup plays an important role. [0003] At present, in the application of the database, the data is stored in a single table, and all the tables correspond to the physical files in the computer disk. Due to the design problem of the database, as time goes by, the amount of data in a single table increases, and the data query Th...

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 Applications(China)
IPC IPC(8): G06F17/30
Inventor 黄敏张林杰陈金满
Owner 浙江知水信息技术有限公司
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