CN101236519A - Radioactive source control application level backup recovery method - Google Patents

Abstract

The invention discloses a method for recovering a radioactive source control application level backup, which comprises the following steps: (1) establishing a shadow data copy in a data table; (2) establishing a data adding, deleting and modifying trigger; (3) establishing a storage process for various application data access operations, and establishing a data access operation interface layer; (4) accessing data through a data access operation interface layer, and writing corresponding data into a shadow copy data table through the cooperation of a storage process and a trigger; (5) restored by shadow data copy. The invention provides a method for quickly recovering data records, can also be used as data access audit at an application level, and can quickly discover any change of data by using the radioactive source control application level backup recovery method.

Description

A kind of radioactive source control applications grade backup restoration method

Technical field

The present invention relates to a kind of data backup restoration method, particularly a kind of radioactive source control applications grade backup restoration method.

Background technology

Aspect radioactive source article regulation management, country has formulated laws and regulations, and each unit of working mainly uses Microsoft Excel to manage the storage of radioactive source article, use and circulate.The at present domestic management software of also not forcing to use unified radioactive source article control.After incidents such as storage migration, negotiation take place when the radioactive source article, corresponding control record will change or increase record.Because radioactive source article control staff's maloperation is filled in mistake, change confusion with these control records sometimes.When these situations take place, can only correct, not only still might have mistake according to original document of paper media document or backup, and because control flow process complexity, by regulated item enormous amount various in style, required time is long.Secondly, utilize the management software of Microsoft SQLServer 200 as control data storage source, though Microsoft SQL Server 200 supports standard database backup and restore funcitons, can not recover the original contents of certain bar data recording of certain time point very soon by the backup of database rank.

Summary of the invention

The present invention has overcome deficiency of the prior art, and a kind of quick restore data record is provided, and can also take on the data access audit of application level, can find the radioactive source control applications grade backup restoration method of any variation of data fast.

In order to solve the problems of the technologies described above, the present invention is achieved by the following technical solutions:

This method comprises the following steps:

(1) in data form, sets up the shadow copying data;

(2) set up the data additions and deletions and change trigger;

(3) be that storing process is created in various application data access operations, set up the data access operation interface layer;

(4) pass through data access operation interface layer visit data, and corresponding data are write the shadow copy data form by storing process and trigger cooperation;

(5) recover by the shadow copying data.

Compared with prior art, the invention has the beneficial effects as follows: this method changes trigger by setting up shadow copying data and additions and deletions, and by its cooperation, has shortened the release time of data recording, has improved recovery efficient.

Embodiment

Below in conjunction with embodiment the present invention is described in further detail:

At first, in database, use SQL statement to create data form, be called the raw data form.The shadow copying data data form that then further uses SQL statement to create the raw data forms according to the definition and the fields such as increase time stamp, operation user and class of operation of raw data form.On the raw data form, create data insertion, renewal, deletion action trigger program code then, comprise in the code and obtain the code that in the shadow copying data data form of correspondence, writes the data variation incident in the raw data form after the influenced data entry contents.At last, according to analysis to the application system design, identify the activity of data manipulations such as all will insert data in the raw data form, upgrade, deletion, use the storing process code of data base management system (DBMS) support to realize corresponding service logical operation respectively, and the program code that fixes on client or application layer approximately must not be directly to the data in the raw data form insert, upgrade, data manipulation such as deletion, and can only finish by calling corresponding storing process.When the client application code will change data clauses and subclauses in the raw data form, call the corresponding storing process that encapsulates service logic, parameter is new data entry contents.This storing process finds the corresponding data clauses and subclauses in the raw data form after, carry out the data alter operation, cause the Data Update trigger on the raw data form this moment automatically.This Data Update trigger obtains raw data before changing, and these information are write corresponding shadow copying data data form, thereby the immediate backup of having finished raw data recovers.

Claims (1)

1. a radioactive source control applications grade backup restoration method is characterized in that, this method comprises the following steps:

(1) in data form, sets up the shadow copying data;

(2) set up the data additions and deletions and change trigger;

(3) be that storing process is created in various application data access operations, set up the data access operation interface layer;

(4) pass through data access operation interface layer visit data, and corresponding data are write the shadow copy data form by storing process and trigger cooperation;

(5) recover by the shadow copying data.