CN111782670A - Method and device for automatically processing data resource operation - Google Patents

Method and device for automatically processing data resource operation Download PDF

Info

Publication number
CN111782670A
CN111782670A CN202010603383.7A CN202010603383A CN111782670A CN 111782670 A CN111782670 A CN 111782670A CN 202010603383 A CN202010603383 A CN 202010603383A CN 111782670 A CN111782670 A CN 111782670A
Authority
CN
China
Prior art keywords
data
check
configuration information
script
program
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202010603383.7A
Other languages
Chinese (zh)
Inventor
刘鸿羽
袁甲
陈顺友
张棋刚
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Industrial and Commercial Bank of China Ltd ICBC
Original Assignee
Industrial and Commercial Bank of China Ltd ICBC
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Industrial and Commercial Bank of China Ltd ICBC filed Critical Industrial and Commercial Bank of China Ltd ICBC
Priority to CN202010603383.7A priority Critical patent/CN111782670A/en
Publication of CN111782670A publication Critical patent/CN111782670A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • G06F16/235Update request formulation
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/14Error detection or correction of the data by redundancy in operation
    • G06F11/1402Saving, restoring, recovering or retrying
    • G06F11/1474Saving, restoring, recovering or retrying in transactions
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • G06F16/2393Updating materialised views

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Quality & Reliability (AREA)
  • Mathematical Physics (AREA)
  • Stored Programmes (AREA)

Abstract

The invention provides a method and a device for automatically processing data resource operation. The method comprises the following steps: receiving predefinition of data resource metadata and operation configuration information; performing a regularity check and a compliance check on the operation configuration information; and if the check is passed, 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. The invention realizes dynamic generation of data resource operation scripts and programs through self-defined setting of metadata and operation configuration information, automatically processes on the whole flow line, does not need excessive manual intervention to program or script, simultaneously combines with regularity inspection and regularity inspection, and ensures the safety, the integrity and the standardization of data operation to the maximum extent, thereby reducing the systematic problems caused by nonstandard, out-of-place, irregular and incomplete operation.

Description

Method and device for automatically processing data resource operation
Technical Field
The present invention relates to the field of data resource operation technologies, and in particular, to a method and an apparatus for automatically processing data resource operations.
Background
The database is an indispensable key technology for the development of modern computer technology, particularly, with the deep development of big data technology, more and more information is carried by data, and the requirements on completeness and normalization of data operation are higher and higher. Current data resource operations are typically implemented by software developers by manually writing data operation scripts or programs. There are several significant problems as follows: 1) when multiple persons maintain the same data resource object, collision or mutual coverage is easy to occur. 2) Normalcy, compliance rely on manual inspection. The risk of data deletion, error updating and the like is easily caused because bits are not executed, and even the high risk problems of library deletion, table deletion and the like exist. 3) Data fault tolerance and rollback processing depend on manual programming, and are low in efficiency and prone to error and leakage.
In addition, the existing partial data resource processing system mainly realizes basic functions of flow processing, grammar checking and the like of the programmed data operation script or program. However, the related programs cannot be automatically generated, inspection and control of the business logic layer in association with metadata are not realized, and there is a distance from automation and all-around processing.
Disclosure of Invention
The embodiments of the present invention mainly aim to provide a method and an apparatus for automatically processing data resource operations, so as to implement automatic online processing of data resources and ensure the security, completeness and efficiency of processing.
In order to solve at least one of the above problems, an embodiment of the present invention provides a method for automatically processing a data resource operation, where the method includes:
receiving predefinition of data resource metadata and operation configuration information;
performing a regularity check and a compliance check on the operation configuration information;
and if the check is passed, 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.
Optionally, in an embodiment of the present invention, the receiving the predefinition of the operation configuration information includes: predefinitions for data object relationships, data object conditions, and data operation types are received.
Optionally, in an embodiment of the present invention, the 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 includes: and analyzing the data object relationship, the data object condition and the data operation type of the data resource metadata, automatically generating a data operation script and a data operation program, and generating a corresponding rollback script and a corresponding rollback program.
Optionally, in an embodiment of the present invention, the performing the regularity check and the compliance check on the operation configuration information includes: and carrying out grammar check, performance check, authority check, safety check, standard check, examination and approval and custom check on the operation configuration information.
Optionally, in an embodiment of the present invention, the method further includes: storing operation information for predefining data resource metadata and operation configuration information, and storing operation information for performing routine check and compliance check on the operation configuration information.
The embodiment of the invention also provides a device for automatically processing the data resource operation, which comprises:
the predefining module is used for receiving predefining data resource metadata and operation configuration information;
the operation checking module is used for performing routine check and compliance check on the operation configuration information;
and the script generation module is used for 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 if the check is passed.
Optionally, in an embodiment of the present invention, the pre-defining module is specifically configured to receive pre-definitions of data object relationships, data object conditions, and data operation types.
Optionally, in an embodiment of the present invention, the script generating module is specifically configured to analyze a data object relationship, a data object condition, and a data operation type of data resource metadata, automatically generate a data operation script and a data operation program, and generate a corresponding rollback script and a corresponding rollback program.
Optionally, in an embodiment of the present invention, the operation checking module is specifically configured to perform syntax checking, performance checking, permission checking, security checking, specification checking, examination and approval, and custom checking on the operation configuration information.
Optionally, in an embodiment of the present invention, the apparatus further includes: and the operation information storage module is used for storing predefined operation information for the data resource metadata and the operation configuration information and storing operation information for performing the routine check and the compliance check on the operation configuration information.
The invention also provides an electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method when executing the program.
The present invention also provides a computer-readable storage medium storing a computer program for executing the above method.
The invention realizes dynamic generation of data resource operation scripts and programs through self-defined setting of metadata and operation configuration information, automatically processes on the whole flow line, does not need excessive manual intervention to program or script, simultaneously combines with regularity inspection and regularity inspection, and ensures the safety, the integrity and the standardization of data operation to the maximum extent, thereby reducing the systematic problems caused by nonstandard, out-of-place, irregular and incomplete operation.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained based on these drawings without creative efforts.
FIG. 1 is a flow chart of a method for automatically processing data resource operations according to an embodiment of the present invention;
FIG. 2 is a schematic structural diagram of an apparatus for automatically processing data resource operations according to an embodiment of the present invention;
FIG. 3 is a diagram illustrating a structure of a metadata processing unit according to an embodiment of the present invention;
FIG. 4 is a schematic structural diagram of an operation definition unit according to an embodiment of the present invention;
FIG. 5 is a schematic structural diagram of an operation checking module according to an embodiment of the present invention;
FIG. 6 is a schematic structural diagram of an operation processing unit according to an embodiment of the present invention;
FIG. 7 is a schematic diagram of the structure of the rollback unit in an embodiment of the present invention;
FIG. 8 is a schematic structural diagram of an operation analysis module according to an embodiment of the present invention;
fig. 9 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
The embodiment of the invention provides a method and a device for automatically processing data resource operation.
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Fig. 1 is a flowchart of a method for automatically processing a data resource operation according to an embodiment of the present invention, where the method includes:
step S1, predefined data resource metadata and operation configuration information are received.
Wherein the predefining specifically comprises defining data resource metadata with a specific business meaning. Generally, standardized objects in the database field such as tables, fields, serial numbers, views and the like can be defined, and service use descriptions such as theme fields, functional characteristics and the like can be defined in an extensible manner, so that definition and identification of data objects with similar service meanings are realized.
Furthermore, the predefining further comprises: when a plurality of data objects need to be operated simultaneously and an incidence relation exists before the plurality of data objects, defining the relation among the objects; defining conditions for triggering the association relation during the association operation of multiple data objects; the types of operations that are supported by different data objects are configured.
In step S2, the operation configuration information is subjected to a regularity check and a compliance check.
The operation configuration information can be checked through the configuration operation check rule, and the operation is ensured to be correct and legal. The inspection is divided into a regular inspection and a compliance inspection.
The normative check mainly executes basic technical checks such as syntax check, performance check, authority check and the like according to check rules.
The compliance inspection is mainly based on the compliance inspection such as inspection rule safety inspection, standard inspection, examination and approval, custom inspection and the like.
Further, if the check fails, recording and storing the operation configuration information which fails to pass the check to give a prompt by visual early warning information, and simultaneously stopping the process.
And step S3, if the check is passed, 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.
After the check is passed, analyzing related data objects, association relations, triggering conditions and operation types, automatically generating data operation scripts and programs, and synchronously generating reverse operation rollback scripts and programs.
In addition, the correctness of the relevant operation script and program can be verified through the database server. The verification process is traceless verification, namely related data objects are automatically backed up before verification, snapshot rollback can be performed after the data operation script is verified, and influence of data introduced due to verification is avoided. If the verification is correct, export operation can be executed, and the data operation script and the program are exported to be stored in a file which can be identified by the database. Similarly, the rollback script and rollback program may also perform authentication and export operations.
As an embodiment of the present invention, receiving the predefinition of the operational configuration information comprises: predefinitions for data object relationships, data object conditions, and data operation types are received.
The predefined data object relationship is an association relationship of predefined data objects, that is, an association relationship between predefined objects. The predefined data object condition is a predefined trigger condition, i.e. by which condition the predefined association is triggered. The predefined data operation types are predefined operation types supported for different data objects.
In this embodiment, 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 includes: and analyzing the data object relationship, the data object condition and the data operation type of the data resource metadata, automatically generating a data operation script and a data operation program, and generating a corresponding rollback script and a corresponding rollback program.
Specifically, taking the update of a certain data object as an example, a user selects the data object in an operation interface, the system automatically displays metadata information of the object, and the user configures attribute fields and field value logic of an update target and an update condition respectively based on related information and selects an operation type (including addition, combination, deletion, update and the like) as the update, thereby completing the configuration. The system calls a rule engine program realized based on a rule base, analyzes and configures the data object relationship, the data object condition and the data operation type of data resource metadata, automatically and dynamically assembles and generates a data operation script and a data operation program, and generates a corresponding rollback script and a corresponding rollback program. Compared with the operation script generation, the rollback script generation has no obvious difference except that the operation type is reverse operation (reverse operation contrast: newly increased or deleted, combined or deleted, deleted or newly increased, updated or deleted and newly increased).
As an embodiment of the present invention, the performing the regularity check and the compliance check on the operation configuration information includes: and carrying out grammar check, performance check, authority check, safety check, standard check, examination and approval and custom check on the operation configuration information. If the inspection is not passed, recording and storing the operation configuration information which is not passed by the inspection, prompting by visual early warning information, and simultaneously stopping the flow.
As an embodiment of the invention, the method further comprises: storing operation information for predefining data resource metadata and operation configuration information, and storing operation information for performing routine check and compliance check on the operation configuration information.
Specifically, the storage process mainly records related data objects, including related operation information and data resource change information, including user operation records, data operation history, rule definition conditions, and the like. Further, different data analysis models and algorithms may be defined based on the different data analysis objects recorded. And the operations of data cleaning, data modeling, data analysis and the like are completed by combining the defined data analysis model. By recording the operation information and the data object change history, safety audit, history backtracking and statistical analysis are facilitated.
The invention realizes dynamic generation of data resource operation scripts and programs through self-defined setting of metadata and operation configuration information, automatically processes on the whole flow line, does not need excessive manual intervention to program or script, simultaneously combines with regularity inspection and regularity inspection, and ensures the safety, the integrity and the standardization of data operation to the maximum extent, thereby reducing the systematic problems caused by nonstandard, out-of-place, irregular and incomplete operation.
Fig. 2 is a schematic structural diagram of an apparatus for automatically processing data resource operations according to an embodiment of the present invention, where the apparatus includes: a pre-defining module 10, an operation checking module 20 and a script generating module 30.
And the predefining module 10 is used for receiving predefining of data resource metadata and operation configuration information.
The predefined module 10 includes a metadata processing unit 110 and an operation definition unit 120. The metadata processing unit 110 is specifically configured to define data resource metadata with a specific service meaning. Generally, standardized objects in the database field such as tables, fields, serial numbers, views and the like can be defined, and service use descriptions such as theme fields, functional characteristics and the like can be defined in an extensible manner, so that definition and identification of data objects with similar service meanings are realized.
As shown in fig. 3, the metadata processing unit 110 includes a metadata definition subunit 111, a metadata loading subunit 112, wherein:
metadata defines subunit 111: for defining data resource metadata with a specific business meaning. The user may define database domain standardized objects such as tables, fields, serial numbers, views, etc. And service use description such as a definition theme domain, functional characteristics and the like can be expanded to realize definition and identification of the similar service meaning data object.
Metadata-loaded subcell 112: the method mainly realizes loading of the metadata object of the designated database, and provides user editing and selection through a visual interface.
The operation definition unit 120 is specifically configured to define a relationship between objects when a plurality of data objects need to be operated simultaneously and an association relationship exists before the plurality of data objects; defining conditions for triggering the association relation during the association operation of multiple data objects; the types of operations that are supported by different data objects are configured. As shown in fig. 4, the operation definition unit 120 includes a data object selection subunit 121, a data object relationship definition subunit 122, a data object condition definition subunit 123, and a data operation definition subunit 124, where:
data object selection subunit 121: for selecting the data object desired to be operated on. At least one data object can be selected as a data operation target according to dimensions such as data object names, data object body domains, data object functional characteristics and the like.
Data object relationship definition subunit 122: when operating on a single data object, the processing of the unit can be ignored. When a plurality of data objects need to be operated simultaneously and the association relationship exists before the plurality of data objects, the relationship between the objects is set through the unit. Such as: quote, cascade, etc.
Data object condition definition subunit 123: the method is mainly used for defining the condition triggering the association relation when the multi-data object is associated.
The data operation defines subunit 124: the operations supported by the configuration are similar for different data objects. Such as addition, deletion, modification of table data records.
And an operation checking module 20, configured to perform a regularity check and a compliance check on the operation configuration information.
The operation checking module 20 may check the operation configuration information by configuring the operation checking rule, so as to ensure that the operation is correct and legal. The inspection is divided into a regular inspection and a compliance inspection. As shown in fig. 5, the operation checking module 20 includes a checking rule definition unit 210, a basic checking unit 220, a compliance checking unit 230, and an early warning unit 240. Wherein:
the check rule definition unit 210: and configuring a user operation check rule to ensure that the operation is correct and legal. The method is divided into two categories of basic checking rules and compliance checking rules according to rule action types. And the scope is divided into a global scope, a data object scope, a theme domain and a function type multi-dimension according to the rule.
The basic check unit 220: basic technical checks such as syntax check, performance check, authority check and the like are mainly executed according to the rules.
The compliance check unit 230: the method is mainly based on compliance inspection such as rule safety inspection, standard inspection, examination and approval, custom inspection and the like.
The early warning unit 240: and if the inspection is passed, the unit is not started, otherwise, the unit is started, and the information record of which the inspection is not passed is stored, so that the user is prompted by visual early warning information, and the process is stopped.
And the script generating module 30 is configured to generate a data operation script and a data operation program according to the data resource metadata and the operation configuration information if the check is passed, and generate a corresponding rollback script and a corresponding rollback program.
The script generating module 30 is specifically configured to, after the checking is passed, analyze the relevant data object, the association relationship, the trigger condition, and the operation type, automatically generate a data operation script and a program, and synchronously generate a reverse operation rollback script and a program. The script generating module 30 includes an operation processing unit 310 and an operation rollback unit 320.
As shown in fig. 6, the operation processing unit 310 includes: an operation script generation subunit 311, an operation script verification subunit 312, and an operation script derivation subunit 313. Wherein:
the operation script generation subunit 311: the operation information defined by the operation definition unit 120 is read. And after analyzing the related objects, relations, conditions and operations, automatically generating a data operation script and a program. And a visual interface is provided for the user to look up and modify the generated result.
The operation script verification subunit 312: after the operation script generation sub-unit 311 generates the script and program, it may connect to a desired database server to verify the correctness of the relevant operation script and program. The unit supports traceless verification, namely the unit automatically backs up related data objects before verification, and can select snapshot rollback after the data operation script is verified, so that the influence of data introduced due to verification is avoided.
Operation script derivation subunit 313: if the operation script verification subunit 312 verifies that the operation script is correct, an export operation may be performed on the interactive interface to export the operation script and the program into a file storage recognizable by the database.
As shown in fig. 7, the operation rollback unit 320 includes: a rollback script generating sub-unit 321, a rollback script verifying unit 322, and a rollback script exporting unit 323. Wherein:
the rollback script generating subunit 321: the operation information defined by the operation defining unit 120 is read. After analyzing the related objects, relations, conditions and operations, when automatically generating the data operation script and the program, synchronously generating the reverse operation rollback script and the program. And a visual interface is provided for the user to look up and modify the generated result.
Rollback script verification subunit 322: after the rollback script generating subunit 321 generates the rollback script and program, it may connect to a desired database server to verify the correctness of the relevant rollback script and program. The unit supports traceless verification, namely the unit automatically backs up related data objects before verification, and can select snapshot rollback after rollback data script verification, so that influence of data introduced due to verification is avoided.
Rollback script export subunit 323: if the rollback script verification subunit 322 verifies that the rollback script and the program are correct, an export operation may be performed on the interactive interface to export the rollback script and the program into a file storage that is recognizable to the database.
As an embodiment of the present invention, the predefining module 10 is specifically configured to receive a predefinition of data object relationships, data object conditions, and data operation types. The predefined data object relationship is an association relationship of predefined data objects, that is, an association relationship between predefined objects. The predefined data object condition is a predefined trigger condition, i.e. by which condition the predefined association is triggered. The predefined data operation types are predefined operation types supported for different data objects.
In this embodiment, the script generating module 30 is specifically configured to analyze the data object relationship, the data object condition, and the data operation type of the data resource metadata, automatically generate a data operation script and a data operation program, and generate a corresponding rollback script and a corresponding rollback program.
As an embodiment of the present invention, the operation checking module 20 is specifically configured to perform syntax checking, performance checking, permission checking, security checking, specification checking, examination and approval, and custom checking on the operation configuration information. If the inspection is not passed, recording and storing the operation configuration information which is not passed by the inspection, prompting by visual early warning information, and simultaneously stopping the flow.
As an embodiment of the present invention, the apparatus further comprises: the operation information storage module 40 is configured to store operation information for predefining data resource metadata and operation configuration information, and store operation information for performing a regularity check and a compliance check on the operation configuration information.
The operation information storage module 40 is specifically configured to record related data objects, including related operation information and data resource change information, including user operation records, data operation histories, rule definition situations, and the like. Further, different data analysis models and algorithms may be defined based on the different data analysis objects recorded. And the operations of data cleaning, data modeling, data analysis and the like are completed by combining the defined data analysis model. By recording the operation information and the data object change history, safety audit, history backtracking and statistical analysis are facilitated.
As shown in fig. 8, the operation information storage module 40 includes an operation record aggregation unit 410, an analysis model definition unit 420, and an operation analysis unit 430. Wherein:
the operation record collecting unit 410: the operation record service interface is mainly provided for the operation definition unit 120, the operation check module 20, the operation processing unit 310 and the operation rollback unit 320 to call so as to record user operation records, data operation histories, rule definition conditions, and the like.
The analysis model definition unit 420: different analysis models and algorithm implementations are defined according to different data analysis objects. And finishing the main steps of selecting a model, exercising the model, evaluating the model, utilizing the model and optimizing the model in data analysis modeling.
The operation analyzing unit 430: the relevant recorded data is processed by the unit, and the operations of data cleaning, data modeling, data analysis and the like are completed by combining the data analysis model defined by the analysis model definition unit 420. The main objectives are achieved as follows: 1) and recording user operation records and data object change history, so that safety audit, history backtracking and statistical analysis are facilitated. 2) And analyzing the same and similar operations of the same and similar data objects to form a standard scheme for the user to select. The operation of a typical scene is templated and standardized. 3) And carrying out multidimensional visual data display and drill-down analysis.
The invention realizes dynamic generation of data resource operation scripts and programs through self-defined setting of metadata and operation configuration information, automatically processes on the whole flow line, does not need excessive manual intervention to program or script, simultaneously combines with regularity inspection and regularity inspection, and ensures the safety, the integrity and the standardization of data operation to the maximum extent, thereby reducing the systematic problems caused by nonstandard, out-of-place, irregular and incomplete operation.
The invention also provides an electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method when executing the program.
The present invention also provides a computer-readable storage medium storing a computer program for executing the above method.
As shown in fig. 9, the electronic device 600 may further include: a communication module 6110, an input unit 6120, an audio processing unit 6130, a display 6160, and a power supply 6170. It is noted that the electronic device 600 does not necessarily include all of the components shown in FIG. 9; furthermore, the electronic device 600 may also comprise components not shown in fig. 9, which may be referred to in the prior art.
As shown in fig. 9, a central processor 6100, also sometimes referred to as a controller or operational control, may include a microprocessor or other processor device and/or logic device, which central processor 6100 receives input and controls the operation of the various components of the electronic device 600.
The memory 6140 may be, for example, one or more of a buffer, a flash memory, a hard drive, a removable media, a volatile memory, a non-volatile memory, or other suitable devices. The information relating to the failure may be stored, and a program for executing the information may be stored. And the central processing unit 6100 may execute the program stored in the memory 6140 to realize information storage or processing, or the like.
The input unit 6120 provides input to the central processor 6100. The input unit 6120 is, for example, a key or a touch input device. The power supply 6170 is used to provide power to the electronic device 600. The display 6160 is used for displaying display objects such as images and characters. The display may be, for example, an LCD display, but is not limited thereto.
The memory 6140 may be a solid state memory, such as Read Only Memory (ROM), Random Access Memory (RAM), SIM card, or the like. There may also be a memory that holds information even when power is off, can be selectively erased, and is provided with more data, an example of which is sometimes called an EPROM or the like. The memory 6140 may also be some other type of device. The memory 6140 includes a buffer memory 6141 (sometimes referred to as a buffer). The memory 6140 may include an application/function store 6142, the application/function store 6142 to store application programs and function programs or procedures for performing operations of the electronic device 600 by the central processor 6100.
The memory 6140 may also include a data store 6143, the data store 6143 for storing data, such as contacts, digital data, pictures, sounds, and/or any other data used by the electronic device. The driver store 6144 of the memory 6140 may include various drivers for the electronic device for communication functions and/or for performing other functions of the electronic device (e.g., messaging application, address book application, etc.).
The communication module 6110 is a transmitter/receiver 6110 which transmits and receives signals via an antenna 6111. A communication module (transmitter/receiver) 6110 is coupled to the central processor 6100 to provide input signals and receive output signals, which may be the same as in the case of a conventional mobile communication terminal.
Based on different communication technologies, a plurality of communication modules 6110, such as a cellular network module, a bluetooth module, and/or a wireless local area network module, may be disposed in the same electronic device. The communication module (transmitter/receiver) 6110 is also coupled to a speaker 6131 and a microphone 6132 via an audio processor 6130 to provide audio output via the speaker 6131 and receive audio input from the microphone 6132 to implement general telecommunications functions. The audio processor 6130 may include any suitable buffers, decoders, amplifiers and so forth. In addition, the audio processor 6130 is also coupled to the central processor 6100, thereby enabling recording locally through the microphone 6132 and playing locally stored sounds through the speaker 6131.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The principle and the implementation mode of the invention are explained by applying specific embodiments in the invention, and the description of the embodiments is only used for helping to understand the method and the core idea of the invention; meanwhile, for a person skilled in the art, according to the idea of the present invention, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present invention.

Claims (12)

1. A method for automated processing of data resource operations, the method comprising:
receiving predefinition of data resource metadata and operation configuration information;
performing a regularity check and a compliance check on the operation configuration information;
and if the check is passed, 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.
2. The method of claim 1, wherein receiving the predefined of operational configuration information comprises: predefinitions for data object relationships, data object conditions, and data operation types are received.
3. The method of claim 2, wherein generating a data manipulation script and a data manipulation program based on the data resource metadata and the manipulation configuration information, and generating a corresponding rollback script and a rollback program comprises: and analyzing the data object relationship, the data object condition and the data operation type of the data resource metadata, automatically generating a data operation script and a data operation program, and generating a corresponding rollback script and a corresponding rollback program.
4. The method of claim 1, wherein the performing a regularity check and a compliance check on the operational configuration information comprises: and carrying out grammar check, performance check, authority check, safety check, standard check, examination and approval and custom check on the operation configuration information.
5. The method of claim 1, further comprising: storing operation information for predefining data resource metadata and operation configuration information, and storing operation information for performing routine check and compliance check on the operation configuration information.
6. An apparatus for automated processing of data resource operations, the apparatus comprising:
the predefining module is used for receiving predefining data resource metadata and operation configuration information;
the operation checking module is used for performing routine check and compliance check on the operation configuration information;
and the script generation module is used for 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 if the check is passed.
7. The apparatus of claim 6, wherein the predefining module is specifically configured to receive a predefinition of data object relationships, data object conditions, and data operation types.
8. The apparatus of claim 7, wherein the script generating module is specifically configured to parse data object relationships, data object conditions, and data operation types of data resource metadata, automatically generate a data operation script and a data operation program, and generate a corresponding rollback script and a corresponding rollback program.
9. The apparatus of claim 6, wherein the operation checking module is specifically configured to perform syntax checking, performance checking, permission checking, security checking, specification checking, review approval, and custom checking on the operation configuration information.
10. The apparatus of claim 6, further comprising: and the operation information storage module is used for storing predefined operation information for the data resource metadata and the operation configuration information and storing operation information for performing the routine check and the compliance check on the operation configuration information.
11. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of any one of claims 1 to 5 when executing the program.
12. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program for executing the method of any one of claims 1 to 5.
CN202010603383.7A 2020-06-29 2020-06-29 Method and device for automatically processing data resource operation Pending CN111782670A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010603383.7A CN111782670A (en) 2020-06-29 2020-06-29 Method and device for automatically processing data resource operation

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010603383.7A CN111782670A (en) 2020-06-29 2020-06-29 Method and device for automatically processing data resource operation

Publications (1)

Publication Number Publication Date
CN111782670A true CN111782670A (en) 2020-10-16

Family

ID=72760300

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010603383.7A Pending CN111782670A (en) 2020-06-29 2020-06-29 Method and device for automatically processing data resource operation

Country Status (1)

Country Link
CN (1) CN111782670A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113268470A (en) * 2021-06-17 2021-08-17 重庆富民银行股份有限公司 Efficient database rollback scheme verification method

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107656722A (en) * 2017-07-31 2018-02-02 平安科技(深圳)有限公司 Data manipulation method, device and computer-readable recording medium
CN108241622A (en) * 2016-12-23 2018-07-03 北京国双科技有限公司 The generation method and device of a kind of query script

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108241622A (en) * 2016-12-23 2018-07-03 北京国双科技有限公司 The generation method and device of a kind of query script
CN107656722A (en) * 2017-07-31 2018-02-02 平安科技(深圳)有限公司 Data manipulation method, device and computer-readable recording medium

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113268470A (en) * 2021-06-17 2021-08-17 重庆富民银行股份有限公司 Efficient database rollback scheme verification method

Similar Documents

Publication Publication Date Title
CN112783793B (en) Automatic interface test system and method
CN109933521A (en) Automated testing method, device, computer equipment and storage medium based on BDD
CN108280137B (en) Task-based pipe network data editing method and device
CN110930131A (en) Vehicle maintenance method, device, equipment and medium
CN111984239B (en) Page configuration method, page configuration device, server and storage medium
CN112905459A (en) Service interface testing method and device, electronic equipment and storage medium
CN103049374B (en) Automatic testing method and device
CN113760611B (en) System site switching method and device, electronic equipment and storage medium
CN111782670A (en) Method and device for automatically processing data resource operation
CN113535141A (en) Database operation code generation method and device
KR101252358B1 (en) Apparatus and method for testing plc command
CN114443039A (en) Input parameter verification method and device, electronic equipment and storage medium
CN112286796A (en) Software testing method, device and storage medium
CN110764835A (en) File configuration method and device of application environment, computer equipment and storage medium
CN116150029A (en) Automatic overdue batch testing method and device for loan system
CN115952079A (en) Method and system for recording mobile application automation behaviors and analyzing and positioning defects
CN112860585B (en) Test script assertion generation method and device
CN112099797B (en) Industrial control screen based function setting method and device and industrial control screen
CN112445634B (en) Fault repairing method and device, electronic equipment and storage medium
CN112306954A (en) File system testing method and device
CN115437903A (en) Interface test method, device, apparatus, storage medium, and program
CN113504928A (en) Automatic application deployment method and device
CN112783799A (en) Software daemon test method and device
CN110806981A (en) Application program testing method, device, equipment and storage medium
CN114116453B (en) Method, device, equipment and readable medium for testing case association configuration information

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination