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

Web development environment-oriented relational database data backtracking method

A technology of development environment and backtracking method, applied in relational database, database model, database design/maintenance, etc., can solve the problems of database transaction log files, manual recovery, cumbersome process, etc.

Active Publication Date: 2017-09-08
ZHEJIANG UNIV OF TECH
View PDF3 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The disadvantage of this method is that the access to the database will be affected when the full backup is performed, and the user experience is not good. At the same time, there are many database transaction log files that come with the database. When restoring, each log file needs to be manually restored, and the process is cumbersome.

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
  • Web development environment-oriented relational database data backtracking method
  • Web development environment-oriented relational database data backtracking method
  • Web development environment-oriented relational database data backtracking method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0058] The present invention will be further described below in conjunction with the drawings.

[0059] Reference Figure 1 ~ Figure 3 , A method for backtracking relational database data for a Web development environment, including the following steps:

[0060] The first step is to establish a SeeLog log processing model in the Web environment. The process is as follows:

[0061] 1.1 Obtain SeeLog automatically: In the Web environment, when a user operates a database, DML (DataManipulation Language) statements will be executed, including three forms: UPDATE, INSERT, and DELETE. After the DML statement is successfully executed, the log processing unit will be triggered. Such as figure 1 As shown in (1), user requirements are sent to the server in parallel in a stream, and the DML statements in the requirements will trigger the log processing unit to write these DML statements into the memory in the order of execution time. The log processing unit uses the AOP (Aspect Oriented Pro...

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 Web development environment-oriented relational database data backtracking method which comprises the following steps: 1, establishing a Web environment SeeLog log processing model, comprising the following procedures: 1.1, automatically acquiring a SeeLog log; 1.2, dynamically adjusting a persistent behavior of the log according to an algorithm; 1.3, performing a persistent operation by adopting a log segmentation strategy; 2, performing database recovery by adopting a TBack data backtracking mechanism, comprising the following procedures: performing data backtracking by utilizing a database event log once the database fails at a certain time point, and recovering the database to any time point before failure; and 3, immediately writing each event into a persistent layer by adopting a self-backup mechanism of a memory log, so that the memory log is not lost. According to the method disclosed by the invention, low-cost data backup can be realized, and the method can be independent of specific relational database kind or version.

Description

Technical field [0001] The invention relates to a method for backtracking relational database data in a Web development environment. Background technique [0002] With the development of the information age, proper storage of data is indispensable. Data is usually stored in a database. Once the database fails, data will be lost. Therefore, database backup and recovery technology is particularly important. [0003] At present, the backup technology at the system application level mainly adopts dual-system hot backup. At the database level, common database backup and recovery solutions mainly include physical backup and logical backup. Physical backup needs to copy the physical files of the database (including control files, data files, log files, etc.) to storage media. According to the operating status of the database at the time of backup, it is divided into offline backup and online backup. Offline backup refers to copying the physical files of the database to the storage mediu...

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): G06F11/14G06F17/30
CPCG06F11/1471G06F11/1474G06F16/21G06F16/219G06F16/284G06F2201/80
Inventor 陆佳炜卢成炳李杰肖刚张元鸣徐俊周焕高燕煦马俊陈烘
Owner ZHEJIANG UNIV OF TECH
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