Method and device for automatically processing data resource operation

Abstract

The invention provides a method and a device for automatically processing data resource operation. The method comprises the following steps of: receiving pre-definition of data resource metadata and operation configuration information; performing routine check and compliance check on the operation configuration information; and if the operation configuration information passes the check, generating a data operation script and a data operation program according to the data resource metadata and the operation configuration information, and generating a corresponding rollback script and a corresponding rollback program. According to the invention, dynamic generation of data resource operation scripts and programs is realized through user-defined setting of the metadata and the operation configuration information, full-flow online automatic processing is achieved, excessive manual intervention for programming programs or scripts is not needed, compliance check and compliance check are combined, the safety, completeness and standardization of data operation are guaranteed to the maximum extent, and therefore the systematic problems caused by nonstandard operation, non-in-place operation, non-compliance, incompleteness and the like are solved.

Description

technical field [0001] The invention relates to the technical field of data resource operation, in particular to a method and device for automatic processing of data resource operation. Background technique [0002] Database is an indispensable key technology for the development of modern computer technology. Especially with the in-depth development of big data technology, more and more information is carried by data, and the completeness and normative requirements for data operation are becoming more and more high. Current data resource operations are generally implemented by software developers by manually writing data operation scripts or programs. There are several obvious problems as follows: 1) When multiple people maintain the same data resource object, conflicts or mutual coverage are likely to occur. 2) Standardization and compliance rely on manual inspection. It is easy to cause risks such as data deletion and wrong update due to improper execution, and even hig...

AI Technical Summary

Problems solved by technology

There are several obvious problems as follows: 1) When multiple people maintain the same data resource object, conflicts or mutual coverage are likely to occur

It is easy to cause risks such as data deletion and wrong update due to improper execution, and even high-risk problems such as deleting databases and tables

3) Data fault tolerance and rollback processing rely on manual programming, which is inefficient and prone to errors and omissions

However, relevant programs cannot be automatically generated, and the inspection and control of the business logic layer by association with metadata has not been realized. There is still a distance from automation and comprehensive processing.

Images