CN116521443A - Data modification method, system, terminal device and computer readable storage medium - Google Patents
Data modification method, system, terminal device and computer readable storage medium Download PDFInfo
- Publication number
- CN116521443A CN116521443A CN202310396569.3A CN202310396569A CN116521443A CN 116521443 A CN116521443 A CN 116521443A CN 202310396569 A CN202310396569 A CN 202310396569A CN 116521443 A CN116521443 A CN 116521443A
- Authority
- CN
- China
- Prior art keywords
- data
- modification
- modified
- target sub
- determining
- 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
Links
- 238000003860 storage Methods 0.000 title claims abstract description 21
- 238000002715 modification method Methods 0.000 title abstract description 13
- 230000004048 modification Effects 0.000 claims abstract description 162
- 238000012986 modification Methods 0.000 claims abstract description 145
- 238000000034 method Methods 0.000 claims abstract description 26
- 238000012790 confirmation Methods 0.000 claims description 6
- 238000013500 data storage Methods 0.000 claims description 5
- 230000000694 effects Effects 0.000 abstract description 5
- 230000008569 process Effects 0.000 abstract description 5
- 238000010586 diagram Methods 0.000 description 8
- 238000004458 analytical method Methods 0.000 description 7
- 238000004590 computer program Methods 0.000 description 7
- 238000012545 processing Methods 0.000 description 6
- 230000006870 function Effects 0.000 description 5
- 238000005457 optimization Methods 0.000 description 5
- 238000004891 communication Methods 0.000 description 4
- 230000029087 digestion Effects 0.000 description 4
- 238000012423 maintenance Methods 0.000 description 3
- 210000004556 brain Anatomy 0.000 description 2
- 230000002085 persistent effect Effects 0.000 description 2
- 230000009466 transformation Effects 0.000 description 2
- 230000001960 triggered effect Effects 0.000 description 2
- 230000009471 action Effects 0.000 description 1
- 230000004075 alteration Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000004140 cleaning Methods 0.000 description 1
- 125000004122 cyclic group Chemical group 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1448—Management of the data involved in backup or backup restore
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/235—Update request formulation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/40—Transformation of program code
- G06F8/41—Compilation
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Mathematical Physics (AREA)
- Computing Systems (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses a data modification method, a data modification system, a terminal device and a computer readable storage medium, wherein the method comprises the following steps: when a data modification instruction is received, determining data to be modified and modification content corresponding to the data to be modified; determining target sub-data according to the modified content, and generating replacement data corresponding to the target sub-data according to the modified content; determining data characteristics corresponding to the target sub-data, and updating a map corresponding to the data to be modified based on the data characteristics; and updating the target sub data stored in a database into the replacement data. The problem of the correlation technique when modifying data, the modification process is complicated, leads to the data modification inefficiency is solved. The effect of improving the data modification efficiency is achieved.
Description
Technical Field
The present invention relates to the field of data modification, and in particular, to a data modification method, a data modification system, a terminal device, and a computer readable storage medium.
Background
In the related art, when a service person needs to modify service data, a modification flow is required to be reported through a service platform, a developer writes a corresponding modification script, the developer sends the modification script to an operation and maintenance person, and finally the operation and maintenance person manually executes the modification script in a database. Meanwhile, in order to prevent data from being deleted by mistake or being manipulated by mistake to be unrecoverable, a developer also needs to write a backup script corresponding to the modification script to backup the service data to be modified.
Therefore, when modifying data, a developer needs to manually write a backup script according to the modification script, and the operation and maintenance personnel manually execute the modification script, so that the processing process is complex, and the data modification efficiency is low.
Disclosure of Invention
The embodiment of the application solves the problem of low data modification efficiency caused by complex modification flow during data modification by providing the data modification method, the data modification system, the terminal equipment and the computer readable storage medium, and achieves the effect of improving the data modification efficiency.
The embodiment of the application provides a data modification method, which comprises the following steps:
when a data modification instruction is received, determining data to be modified and modification content corresponding to the data to be modified;
determining target sub-data according to the modified content, and generating replacement data corresponding to the target sub-data according to the modified content;
determining data characteristics corresponding to the target sub-data, and updating a map corresponding to the data to be modified based on the data characteristics;
and updating the target sub data stored in a database into the replacement data.
Optionally, the step of determining the data to be modified and the modification content corresponding to the data to be modified when the data modification instruction is received includes:
analyzing the data modification instruction and determining the data to be modified;
and determining a data end corresponding to the data to be modified according to the data to be modified.
Optionally, the step of determining target sub-data according to the modified content and generating the replacement data corresponding to the target sub-data according to the modified content includes:
detecting whether the target sub-data corresponding to the modified content exists in the database;
if the target sub-data cannot be detected, feeding back data exception information to an emitting end of the data modification instruction;
and if the target sub-data is detected, executing the step of generating the replacement data corresponding to the target sub-data according to the modified content.
Optionally, the step of determining the data feature corresponding to the target sub-data and updating the map corresponding to the data to be modified based on the data feature includes:
acquiring a map corresponding to the data to be modified according to the data characteristics;
and updating the map according to the modified content.
Optionally, before the step of updating the target sub-data stored in the database to the replacement data, the method includes:
acquiring original data corresponding to the target sub data and a table name of the original data;
and generating a copy of the original data according to the table name, and storing the original data into a data backup library.
Optionally, after the step of updating the target sub-data stored in the database to the replacement data, the method includes:
sending a modification confirmation notice to an sending end of the data modification instruction;
and determining that the modification is completed according to the received completion modification information, and deleting the original data from the data backup library.
Optionally, after the step of updating the target sub-data stored in the database to the replacement data, the method further includes:
and generating and storing a modification log according to the time of receiving the data modification instruction and the data modification instruction.
In addition, to achieve the above object, an embodiment of the present invention further provides a data modification system, including:
the receiving module is used for determining data to be modified and modification contents corresponding to the data to be modified when receiving a data modification instruction;
the replacing data generating module is used for determining target sub-data according to the modified content and generating replacing data corresponding to the target sub-data according to the modified content;
the map updating module is used for determining data characteristics corresponding to the target sub-data and updating a map corresponding to the data to be modified based on the data characteristics;
and the data storage module is used for updating the target sub data stored in the database into the replacement data.
In addition, in order to achieve the above object, an embodiment of the present invention further provides a terminal device, including a memory, a processor, and a data modification program stored in the memory and executable on the processor, where the processor implements the method as described above when executing the data modification program.
In addition, in order to achieve the above object, an embodiment of the present invention also provides a computer-readable storage medium having stored thereon a data modification program which, when executed by a processor, implements the method as described above.
One or more technical solutions provided in the embodiments of the present application at least have the following technical effects or advantages:
when the database receives the data modification instruction, the data to be modified and the modification content corresponding to the data to be modified are determined. And determining target sub-data according to the content to be modified, and generating replacement data corresponding to the target sub-data according to the modified content. And determining the data characteristics corresponding to the target sub-data, updating the map corresponding to the data to be modified based on the data characteristics, and updating the target sub-data stored in the database into the replacement data.
Drawings
FIG. 1 is a schematic flow chart of a first embodiment of a data modification method of the present application;
FIG. 2 is a schematic flow chart of a second embodiment of a data modification method of the present application;
fig. 3 is a schematic diagram of a terminal structure of a hardware running environment according to an embodiment of the present application.
Detailed Description
In order to solve the problem that when data is modified, because information interaction is needed between a developer and a business person, the developer can modify the data only after writing a script according to the modification requirement of the business person, so that the data modification efficiency is low. The application provides a data modification method, which is characterized in that a database receives a data modification instruction, after receiving the data modification instruction, data to be modified and modification content are determined, target sub-data is determined according to the modification content, and replacement data corresponding to the target sub-data is generated according to the modification content. And determining data characteristics corresponding to the target sub-data, updating a map corresponding to the data to be modified based on the data characteristics, and simultaneously updating the target sub-data stored in the database into replacement data to complete the modification of the data. The data modification is directly completed according to the data modification instruction, a developer is not required to write a script, and the effect of improving the data modification efficiency is achieved.
In order to better understand the above technical solution, exemplary embodiments of the present application will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present application are shown in the drawings, it should be understood that the present application may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.
In order to better understand the above technical solutions, the following detailed description will refer to the accompanying drawings and specific embodiments.
Example 1
In this embodiment, a data modification method is provided.
Referring to fig. 1, the data modification method of the present embodiment includes the steps of:
step S100: when a data modification instruction is received, determining data to be modified and modification content corresponding to the data to be modified;
in this embodiment, the data to be modified refers to the data type, and the modified content refers to the content to be actually modified.
As an optional implementation manner, after receiving the data modification instruction, the database analyzes the data modification instruction, determines the data to be modified, and then determines the corresponding data end according to the data to be modified.
Illustratively, a plurality of data terminals are arranged in the database, and the data terminals are not mutually interfered and are used for supporting the whole system to work. And each data end such as a script storage end, a data storage end, a map storage end, a task digestion end, a robot pool end, a robot instance end and the like is arranged in the database. The script storage end stores script data; the data storage end is a mixed storage brain, supports memory state and persistent storage, and supports any format; the map storage end is used for accessing and maintaining map data; the task digestion end is used for distributing and dispatching the robot digestion tasks to the digestion processing nodes and supporting running multiple instances; the robot pool end is used for maintaining a robot instance creation record, performing persistent storage, and dynamically creating a robot instance according to the record; the robot instance terminal dynamically creates the robot instance according to the robot instance creation record of the robot pool brain robot instance, and belongs to a memory state.
As another alternative embodiment, after determining the data to be modified and the corresponding data end according to the data modification instruction, the modification content is determined.
The method includes determining, according to a data modification instruction, that data to be modified is at a first data end, and determining that modification content of the data to be modified is first data content in the first data end.
As yet another alternative, one data modification instruction may require modification of multiple data contents simultaneously. If two or more data to be modified are determined according to the data modification instruction, respectively determining modification contents corresponding to the data to be modified, and modifying the plurality of data.
Step S200: determining target sub-data according to the modified content, and generating replacement data corresponding to the target sub-data according to the modified content;
in this embodiment, the target sub-data refers to specific data in the data end to which the data modification instruction points. The replacement data refers to new data content to be written in the data side.
As an optional implementation manner, when determining the target sub-data, it is necessary to detect whether there is the target sub-data corresponding to the modification content in the database, and when the target sub-data is not detected, send data exception information to the sending end of the data modification instruction. And if the target sub-data exists in the data end, executing the step of generating the replacement data of the target sub-data according to the modified content.
For example, whether the target sub-data exists in the database may be determined according to the data identification of the target sub-data. When the target sub-data is not detected, then it may be that the data modification instruction is parsed for anomalies or that the data modification instruction is incorrect.
As another alternative, after determining the target sub-data, the modified content is converted into a computer language, and corresponding replacement data is generated.
The modified content is illustratively sent to a compiler, which performs lexical analysis on the modified content, such as identifying keywords, identifiers, literal amounts, special symbols, and the like. Outputting the identified mark flow after lexical analysis, and carrying out grammar analysis on the recorded flow, for example, expressing a language structure in a grammar tree form, checking and filling a symbol table for declarative sentences, checking whether expression operation with reasonable structure is meaningful for executable sentences, and the like. Outputting a grammar tree after grammar analysis, carrying out semantic analysis on the grammar tree, such as static semantic checking on grammar units in the grammar tree according to semantic rules, such as type checking and conversion. The aim is to ensure that the correct structure of the grammar is also legal in terms of semantic analysis. The code subjected to semantic analysis is generated into a representation which is not only close to a target language, but also irrelevant to a specific machine, so that code optimization and code generation are facilitated, the code is further optimized, such as local optimization, cyclic optimization, global optimization and the like, the optimization is actually equivalent transformation, and the instruction sequences before and after transformation complete the same function, but are more saved and more effective in occupied space and time of program execution. And finally, linking the optimized code according to the requirement of the executable file format of the data system to generate an executable program, namely generating the replacement data.
Step S300: determining data characteristics corresponding to the target sub-data, and updating a map corresponding to the data to be modified based on the data characteristics;
in this embodiment, the map is generated according to various data stored in the database, and when the data is queried, various associated data in the database can be quickly obtained according to the content of the map, so that the data searching efficiency is improved. Thus, when modifying the data stored in the database, modification of the profile content is also required.
As an alternative implementation manner, when updating the map according to the target sub-data, the map corresponding to the data to be modified is acquired according to the data characteristics, and then the map is updated according to the modification content.
Illustratively, since each data in the database carries a respective data feature, a map generated from the data in the database also has a corresponding data feature. And determining the atlas to be modified according to the data characteristics corresponding to the target sub-data, acquiring the atlas, then carrying out corresponding modification on the atlas content according to the modification content, and updating and storing the modified atlas.
As another alternative, the data modification instructions may modify only the profile content without modifying the data content. When the content of the map is found to be wrong or the display form of the map needs to be modified, the modification can be carried out on the map.
Illustratively, after receiving the data modification instruction, the database parses the data modification instruction to determine a modification object of the data modification instruction as a data map. And determining a target data map and contents to be modified according to the modification instruction, and updating and saving the map after changing the target data map.
Step S400: and updating the target sub data stored in a database into the replacement data.
In this embodiment, after the replacement data is determined, the replacement data may be directly updated to the target sub-data, and the original data may be deleted.
As an alternative implementation manner, after one data modification is completed, a work log may be generated and saved according to the time of receiving the data modification instruction and the content of the data modification instruction, so that when an exception occurs, a service person or a developer may directly search for a corresponding modification record.
For example, to reduce the memory footprint of log data, it may be provided to automatically clean up historical log data at intervals. Or cleaning a log file generated in the process of storing the task event in the database after the task event is completed.
In this embodiment, when the database receives the data modification instruction, the data to be modified and the modification content corresponding to the data to be modified are determined according to the data modification instruction. And determining target sub-data according to the modified content, generating replacement data of the target sub-data according to the modified content, and updating the target sub-data stored in the database. And updating the map corresponding to the data to be modified according to the data characteristics of the target sub-data. Therefore, the data is modified without the need of updating the data after writing a new script by a developer, and the data modification efficiency can be effectively improved. And the database can work in a multi-thread mode, and multiple data can be modified at the same time.
Example two
Based on the first embodiment, another embodiment of the present application is provided, referring to fig. 2, before the step of updating the target sub-data stored in the database to the replacement data, the method includes the steps of:
step S401: acquiring original data corresponding to the target sub data and a table name of the original data;
step S402: and generating a copy of the original data according to the table name, and storing the original data into a data backup library.
In this embodiment, in order to prevent the problem that the data cannot be recovered due to an exception occurring in the data modification process or a data modification instruction is incorrect, the data to be modified may be backed up before the data is modified.
As an alternative implementation manner, in order to not occupy too much memory, it is not necessary to backup all data in the database, and only when a modification action needs to be executed, a data backup instruction is triggered to backup the data to be modified.
The data backup database is divided in the database, and when the data needs to be modified, the data backup program is triggered to acquire the data to be modified and the table name of the data to be modified, generate a copy file, and store the copy file in the data backup database to complete the data backup.
As another alternative embodiment, if the data modification is completed and the data modification is found to be wrong, the backup data can be directly extracted from the data backup database, and the data can be recovered.
For example, since the backup data carries the time of data backup, the data to be restored can be determined according to the data modification time in the log file and the data backup time in the data backup library.
After the step of updating the target sub-data stored in the database to the replacement data, it includes:
step S500: sending a modification confirmation notice to an sending end of the data modification instruction;
step S600: and determining that the modification is completed according to the received completion modification information, and deleting the original data from the data backup library.
In this embodiment, after the modification of the data is completed, the task execution completion information may be sent to the sending end of the data modification instruction. And receiving feedback confirmation completion modification information, and determining that modification is completed.
As an optional implementation manner, in order to save the memory space occupied by the backup data, the data backed up by the current task in the data backup library may be deleted after each confirmation of completion of the data modification task.
As an alternative, the data in the data backup repository may change with each task execution, i.e., one backup data may be stored in the data backup repository.
Illustratively, before updating the data in the database, the target data is copied and stored in the data backup database, and then the data in the database is updated and modified. After the modification is confirmed, if the task of modifying the same data is received again, the data after the last modification is backed up in the database is obtained and updated to the data backup database, and at the moment, the content of the backup data stored last time is replaced by the data after the last modification. Thereby saving the flow of data backup.
In this embodiment, in order to prevent data modification errors, the data to be modified may be backed up before updating the data in the database. After the modification is completed, the backup data can be cleared, so that the effect of saving the memory space is achieved.
Example III
In an embodiment of the present application, a data modification apparatus is provided.
Referring to fig. 3, fig. 3 is a schematic diagram of a terminal structure of a hardware running environment according to an embodiment of the present application.
As shown in fig. 3, the control terminal may include: a processor 1001, such as a CPU, a network interface 1003, memory 1004, and a communication bus 1002. Wherein the communication bus 1002 is used to enable connected communication between these components. The network interface 1003 may optionally include a standard wired interface, a wireless interface (e.g., WI-FI interface). The memory 1004 may be a high-speed RAM memory or a stable memory (non-volatile memory), such as a disk memory. The memory 1004 may also optionally be a storage device separate from the processor 1001 described above.
It will be appreciated by those skilled in the art that the terminal structure shown in fig. 3 is not limiting of the terminal and may include more or fewer components than shown, or may combine certain components, or a different arrangement of components.
As shown in fig. 3, an operating system, a network communication module, and a data modification program may be included in the memory 1004, which is a type of computer storage medium.
In the data modification apparatus hardware structure shown in fig. 3, the processor 1001 may call a data modification program stored in the memory 1004 and perform the following operations:
when a data modification instruction is received, determining data to be modified and modification content corresponding to the data to be modified;
determining target sub-data according to the modified content, and generating replacement data corresponding to the target sub-data according to the modified content;
determining data characteristics corresponding to the target sub-data, and updating a map corresponding to the data to be modified based on the data characteristics;
and updating the target sub data stored in a database into the replacement data.
Optionally, the processor 1001 may call a data modification program stored in the memory 1004, and also perform the following operations:
analyzing the data modification instruction and determining the data to be modified;
and determining a data end corresponding to the data to be modified according to the data to be modified.
Optionally, the processor 1001 may call a data modification program stored in the memory 1004, and also perform the following operations:
detecting whether the target sub-data corresponding to the modified content exists in the database;
if the target sub-data cannot be detected, feeding back data exception information to an emitting end of the data modification instruction;
and if the target sub-data is detected, executing the step of generating the replacement data corresponding to the target sub-data according to the modified content.
Optionally, the processor 1001 may call a data modification program stored in the memory 1004, and also perform the following operations:
acquiring a map corresponding to the data to be modified according to the data characteristics;
and updating the map according to the modified content.
Optionally, the processor 1001 may call a data modification program stored in the memory 1004, and also perform the following operations:
acquiring original data corresponding to the target sub data and a table name of the original data;
and generating a copy of the original data according to the table name, and storing the original data into a data backup library.
Optionally, the processor 1001 may call a data modification program stored in the memory 1004, and also perform the following operations:
sending a modification confirmation notice to an sending end of the data modification instruction;
and determining that the modification is completed according to the received completion modification information, and deleting the original data from the data backup library.
Optionally, the processor 1001 may call a data modification program stored in the memory 1004, and also perform the following operations:
and generating and storing a modification log according to the time of receiving the data modification instruction and the data modification instruction.
In addition, to achieve the above object, an embodiment of the present invention further provides a data modification system, including:
the receiving module is used for determining data to be modified and modification contents corresponding to the data to be modified when receiving a data modification instruction;
the replacing data generating module is used for determining target sub-data according to the modified content and generating replacing data corresponding to the target sub-data according to the modified content;
the map updating module is used for determining data characteristics corresponding to the target sub-data and updating a map corresponding to the data to be modified based on the data characteristics;
and the data storage module is used for updating the target sub data stored in the database into the replacement data.
In addition, in order to achieve the above object, an embodiment of the present invention further provides a terminal device, including a memory, a processor, and a data modification program stored in the memory and executable on the processor, where the processor implements the data modification method as described above when executing the data modification program.
In addition, in order to achieve the above object, an embodiment of the present invention also provides a computer-readable storage medium having stored thereon a data modification program which, when executed by a processor, implements the data modification method as described above.
It will be appreciated by those skilled in the art that embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present application 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 application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations 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.
It should be noted that in the claims, any reference signs placed between parentheses shall not be construed as limiting the claim. The word "comprising" does not exclude the presence of elements or steps not listed in a claim. The word "a" or "an" preceding an element does not exclude the presence of a plurality of such elements. The application may be implemented by means of hardware comprising several distinct elements, and by means of a suitably programmed computer. In the unit claims enumerating several means, several of these means may be embodied by one and the same item of hardware. The use of the words first, second, third, etc. do not denote any order. These words may be interpreted as names.
While preferred embodiments of the present application have been described, additional variations and modifications in those embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. It is therefore intended that the following claims be interpreted as including the preferred embodiments and all such alterations and modifications as fall within the scope of the application.
It will be apparent to those skilled in the art that various modifications and variations can be made in the present application without departing from the spirit or scope of the invention. Thus, if such modifications and variations of the present application fall within the scope of the claims and the equivalents thereof, the present application is intended to cover such modifications and variations.
Claims (10)
1. A method of data modification, for application to a database, the method comprising the steps of:
when a data modification instruction is received, determining data to be modified and modification content corresponding to the data to be modified;
determining target sub-data according to the modified content, and generating replacement data corresponding to the target sub-data according to the modified content;
determining data characteristics corresponding to the target sub-data, and updating a map corresponding to the data to be modified based on the data characteristics;
and updating the target sub data stored in a database into the replacement data.
2. The method of claim 1, wherein the step of determining the data to be modified and the modification content corresponding to the data to be modified when the data modification instruction is received comprises:
analyzing the data modification instruction and determining the data to be modified;
and determining a data end corresponding to the data to be modified according to the data to be modified.
3. The method of claim 1, wherein the step of determining target sub-data according to the modified content and generating replacement data corresponding to the target sub-data according to the modified content comprises:
detecting whether the target sub-data corresponding to the modified content exists in the database;
if the target sub-data cannot be detected, feeding back data exception information to an emitting end of the data modification instruction;
and if the target sub-data is detected, executing the step of generating the replacement data corresponding to the target sub-data according to the modified content.
4. The method of claim 1, wherein the step of determining the data characteristic corresponding to the target sub-data and updating the map corresponding to the data to be modified based on the data characteristic comprises:
acquiring a map corresponding to the data to be modified according to the data characteristics;
and updating the map according to the modified content.
5. The method of claim 1, wherein before the step of updating the target sub-data stored in the database to the replacement data, comprising:
acquiring original data corresponding to the target sub data and a table name of the original data;
and generating a copy of the original data according to the table name, and storing the original data into a data backup library.
6. The method of claim 5, wherein after the step of updating the target sub-data stored in the database to the replacement data, comprising:
sending a modification confirmation notice to an sending end of the data modification instruction;
and determining that the modification is completed according to the received completion modification information, and deleting the original data from the data backup library.
7. The method of claim 1, wherein after the step of updating the target sub-data stored in the database to the replacement data, further comprising:
and generating and storing a modification log according to the time of receiving the data modification instruction and the data modification instruction.
8. A data modification system, the data modification system comprising:
the receiving module is used for determining data to be modified and modification contents corresponding to the data to be modified when receiving a data modification instruction;
the replacing data generating module is used for determining target sub-data according to the modified content and generating replacing data corresponding to the target sub-data according to the modified content;
the map updating module is used for determining data characteristics corresponding to the target sub-data and updating a map corresponding to the data to be modified based on the data characteristics;
and the data storage module is used for updating the target sub data stored in the database into the replacement data.
9. A terminal device comprising a memory, a processor and a data modification program stored on the memory and executable on the processor, the processor implementing the method of any of claims 1-7 when executing the data modification program.
10. A computer readable storage medium, characterized in that the computer readable storage medium has stored thereon a data modification program, which, when executed by a processor, implements the method of any of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310396569.3A CN116521443A (en) | 2023-04-06 | 2023-04-06 | Data modification method, system, terminal device and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310396569.3A CN116521443A (en) | 2023-04-06 | 2023-04-06 | Data modification method, system, terminal device and computer readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116521443A true CN116521443A (en) | 2023-08-01 |
Family
ID=87407484
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310396569.3A Pending CN116521443A (en) | 2023-04-06 | 2023-04-06 | Data modification method, system, terminal device and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116521443A (en) |
-
2023
- 2023-04-06 CN CN202310396569.3A patent/CN116521443A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9207933B2 (en) | Identifying authors of changes between multiple versions of a file | |
| CN103092742B (en) | Program log recording optimization method and system | |
| CN108763091B (en) | Method, device and system for regression testing | |
| US20080276226A1 (en) | Device, method and computer program product for evaluating a debugger script | |
| US7103885B2 (en) | Comment driven processing | |
| CN111694612A (en) | Configuration checking method, device, computer system and storage medium | |
| US8230406B2 (en) | Compiler option consistency checking during incremental hardware design language compilation | |
| CN110659210A (en) | Information acquisition method and device, electronic equipment and storage medium | |
| CN113296786A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN111125067B (en) | Data maintenance method and device | |
| CN110209565B (en) | Metadata model debugging method and device | |
| KR101860674B1 (en) | Method, Server and Computer Program for Crash Report Grouping | |
| CN110543641B (en) | Chinese and foreign language information comparison method and device | |
| CN109582318B (en) | Processing method and device for Portobuf localization, terminal and storage medium | |
| CN116521443A (en) | Data modification method, system, terminal device and computer readable storage medium | |
| US9396239B2 (en) | Compiling method, storage medium and compiling apparatus | |
| CN111880803B (en) | Software construction method and device applied to multiple platforms | |
| CN113495723B (en) | Method, device and storage medium for calling functional component | |
| CN111930387B (en) | Integration method and device of integration package, electronic equipment and storage medium | |
| CN109213490B (en) | Program processing method and device and related equipment | |
| CN113792026A (en) | Deployment method and device of database script and computer readable storage medium | |
| CN109019217B (en) | Elevator control software field debugging system | |
| RU2260206C2 (en) | Method and device for reproduction of program and carrier with recorded program for reproduction of program | |
| CN112148581A (en) | Code specification checking method, device, system and storage medium | |
| CN118035210A (en) | Data dictionary management method, storage medium, device and product of database |
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 |