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

Real-time database backup system and method based on FPGA (field programmable gate array)

A backup system and database technology, which is applied in the direction of data error detection, electrical digital data processing, special data processing applications, etc., can solve the problems of inability to realize database backup, complex processing methods, etc., and achieve logic modification. Simple and fast, simple circuit layout and wiring, and the effect of reducing the size of the system

Active Publication Date: 2013-01-02
UNIV OF JINAN
View PDF4 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] For the Chinese patent 200610161789.4, a database system disaster recovery method is proposed. Each database in the database local area network performs the same database operation on its own instance by listening to the data packets in the network, and at the same time, it can realize the database master and backup through the agent process on the database server. However, this bus method requires that each database must be homogeneous, and heterogeneous database backup cannot be realized. Each database server also needs to establish a message network for message transmission to achieve active-standby switching, which is complicated to deal with

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
  • Real-time database backup system and method based on FPGA (field programmable gate array)
  • Real-time database backup system and method based on FPGA (field programmable gate array)
  • Real-time database backup system and method based on FPGA (field programmable gate array)

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0045] The present invention will be further described below in conjunction with the accompanying drawings and embodiments.

[0046] Such as figure 1 As shown, the application server 1 is connected to the corresponding database server 3 through the FPGA2.

[0047] The key of the present invention lies in data packet processing, SQL statement format conversion and message inspection of FPGA2, and is characterized in that it can realize heterogeneous database backup.

[0048] Such as figure 2 As shown, the environment of the backup method of the present invention includes an application server 1, FPGA 2, communication links, master-slave databases 31 and 32, and the master-slave databases 31 and 32 can be deployed to different locations through the communication links.

[0049] SRAM group 10, data flow replication module 6, data flow conversion module 7, return result consistency checking module 8 and error packet feedback module 9 and some independent RJ45 interfaces 5 corre...

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 real-time database backup system and a real-time database backup method based on an FPGA (field programmable gate array) and relates to the FPGA and a database backup disaster recovery technology. Database operating data flows are positioned into two or multiple 1G RJ45 interfaces through the high-speed copying function of an FPGA board and are transmitted to different data servers, and databases in two or multiple data servers are simultaneously and consistently operated to realize database real-time backup.

Description

technical field [0001] The invention relates to an FPGA and database backup disaster recovery technology, in particular to an FPGA-based real-time database backup system and backup method. Background technique [0002] Database backup technologies mainly include offline backup and online backup. [0003] Offline data backup, also known as cold backup, is a file backup operation performed when the database is closed. Offline databases are usually backed up based on file copies. When implementing them, the database must be closed and wait for the backup to complete. Backups are exclusive to the database, which affects the continuous operation of application services and prevents data updates during the backup period. Offline backups are usually full data backups or incremental backups. [0004] Online database backup, also known as hot backup, is the data backup of the database without stopping data access. The database management system that supports logical online backup ...

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/30G06F11/14
Inventor 陈贞翔王金光杨波张蕾彭立志
Owner UNIV OF JINAN
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