CN109299125B - Database updating method and device - Google Patents
Database updating method and device Download PDFInfo
- Publication number
- CN109299125B CN109299125B CN201811285175.6A CN201811285175A CN109299125B CN 109299125 B CN109299125 B CN 109299125B CN 201811285175 A CN201811285175 A CN 201811285175A CN 109299125 B CN109299125 B CN 109299125B
- Authority
- CN
- China
- Prior art keywords
- database
- database updating
- updating
- business transaction
- current business
- 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.)
- Active
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method and a device for updating a database, wherein after a database updating object generated in the current business transaction processing process is obtained, the database updating object is not immediately updated to the database, but is stored; and after the current business transaction is completed, acquiring a stored database updating object, and updating the acquired database updating object into a database. Based on the method and the device, the calling times of the database in the process of processing one service transaction are reduced, the time consumption of processing one service transaction by the service system is reduced, and the performance of the service system is improved.
Description
Technical Field
The invention relates to the technical field of databases, in particular to a database updating method and device.
Background
In the process of processing the business transaction, the business system needs to modify the data of the database in some business operations, so the business system needs to update the database according to the modified data.
In the existing data updating scheme, when data modification of a database occurs once in the process of processing one service operation, a service system synchronizes the data modification to the database immediately, and then continues to process the next service operation. That is, in the process of processing a business transaction, the business system performs a database call every time a database data modification occurs.
However, the above-mentioned solution may cause the service system to call the database many times in the process of processing one service transaction, thereby causing the service system to consume too long time to process one service transaction, and affecting the performance of the service system.
Disclosure of Invention
In view of the above, the present invention has been made to provide a database updating method and apparatus that overcomes or at least partially solves the above-mentioned problems. The specific scheme is as follows:
a database update method, the method comprising:
acquiring a database updating object generated in the current business transaction processing process;
storing the database updating object;
and after the current business transaction is completed, acquiring a stored database updating object, and updating the acquired database updating object into a database.
Optionally, the storing the database update object includes:
determining a state attribute of the database update object;
determining the type and ID of the database updating object;
and storing the database updating object and the type, the ID and the state attribute of the database updating object.
Optionally, the obtaining a stored database update object and updating the obtained database update object into the database includes:
classifying the obtained database updating objects according to object types to obtain a plurality of groups of database updating objects, wherein the object types of the database updating objects contained in each group of database updating objects are the same;
and performing the following processing on each group of database updating objects:
acquiring a target warehousing class corresponding to the object type of the group of database updating objects;
and calling the target warehousing class to update the set of database update objects to the database.
Optionally, the database update object includes:
inquiring an unmodified database updating object from a database in the current business transaction processing process;
inquiring the modified database updating object obtained from the database in the current business transaction processing process;
the newly created database updating object in the current business transaction processing process:
and inquiring the deleted database updating object from the database in the current business transaction processing process.
Optionally, the determining the state attribute of the database update object includes:
determining the state attribute of the unmodified database update object as clear after being inquired and acquired from the database in the current business transaction processing process;
determining the state attribute of the modified database update object which is obtained by inquiring from the database in the current business transaction processing process as dirty;
determining the state attribute of a newly-built database updating object in the current business transaction processing process as new;
and determining the state attribute of the database update object which is deleted after being inquired and acquired from the database in the current business transaction processing process as removed.
A database update apparatus, the apparatus comprising:
the acquisition unit is used for acquiring a database updating object generated in the current business transaction processing process;
the storage unit is used for storing the database updating object;
and the updating unit is used for acquiring the stored database updating object after the current business transaction is completed, and updating the acquired database updating object into the database.
Optionally, the storage unit is specifically configured to:
determining a state attribute of the database update object;
determining the type and ID of the database updating object;
and storing the database updating object and the type, the ID and the state attribute of the database updating object.
Optionally, the updating unit is specifically configured to:
classifying the obtained database updating objects according to object types to obtain a plurality of groups of database updating objects, wherein the object types of the database updating objects contained in each group of database updating objects are the same;
and performing the following processing on each group of database updating objects:
acquiring a target warehousing class corresponding to the object type of the group of database updating objects;
and calling the target warehousing class to update the set of database update objects to the database.
Optionally, the database update object includes:
inquiring an unmodified database updating object from a database in the current business transaction processing process;
inquiring the modified database updating object obtained from the database in the current business transaction processing process;
the newly created database updating object in the current business transaction processing process:
and inquiring the deleted database updating object from the database in the current business transaction processing process.
Optionally, the storage unit is specifically configured to:
determining the state attribute of the unmodified database update object as clear after being inquired and acquired from the database in the current business transaction processing process;
determining the state attribute of the modified database update object which is obtained by inquiring from the database in the current business transaction processing process as dirty;
determining the state attribute of a newly-built database updating object in the current business transaction processing process as new;
and determining the state attribute of the database update object which is deleted after being inquired and acquired from the database in the current business transaction processing process as removed.
By means of the technical scheme, the database updating method and the database updating device provided by the invention do not immediately update the database after acquiring the database updating object generated in the current business transaction processing process, but store the database updating object; and after the current business transaction is completed, acquiring a stored database updating object, and updating the acquired database updating object into a database. Based on the method and the device, the calling times of the database in the process of processing one service transaction are reduced, the time consumption of processing one service transaction by the service system is reduced, and the performance of the service system is improved.
The foregoing description is only an overview of the technical solutions of the present invention, and the embodiments of the present invention are described below in order to make the technical means of the present invention more clearly understood and to make the above and other objects, features, and advantages of the present invention more clearly understandable.
Drawings
Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to refer to like parts throughout the drawings. In the drawings:
FIG. 1 is a schematic structural diagram of a database update system according to an embodiment of the present invention;
FIG. 2 is a schematic flowchart of a database updating method according to an embodiment of the present invention;
fig. 3 is a schematic flowchart of a method for storing the database update object according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of a database updating apparatus according to an embodiment of the present invention.
Detailed Description
Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure 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.
Referring to fig. 1, fig. 1 is a schematic structural diagram of a database update system according to an embodiment of the present invention, where the system includes a business transaction processing module 10, a work unit module 11, an identifier mapping module 12, and a data warehousing module 13, and the business transaction processing module, the identifier mapping module, and the data warehousing module are all connected to the work unit module.
Referring to fig. 2, fig. 2 is a schematic flow chart of a database updating method according to an embodiment of the present invention, the method is applied to a work unit module in a database updating system, and the method includes:
step S200: acquiring a database updating object generated in the current business transaction processing process;
when a business transaction processing module processes a current business transaction, each time a database updating object is generated, an interface provided by the working unit module is called, and the generated database updating object is sent to the working unit module, wherein different business transactions correspond to different working unit modules.
In one implementation, the database update objects include database update objects that are not modified after being retrieved from the database during the current business transaction, database update objects that are newly created during the current business transaction, and database update objects that are deleted after being retrieved from the database during the current business transaction.
Step S210: storing the database updating object;
step S220: and after the current business transaction is completed, acquiring a stored database updating object, and updating the acquired database updating object into a database.
According to the database updating method disclosed by the embodiment of the invention, after the database updating object generated in the current business transaction processing process is obtained, the database updating object is not immediately updated to the database, but is stored; and after the current business transaction is completed, acquiring a stored database updating object, and updating the acquired database updating object into a database. Based on the method, the calling times of the database in the process of processing one service transaction are reduced, the time consumption of processing one service transaction by the service system is reduced, and the performance of the service system is improved.
Referring to fig. 3, fig. 3 is a schematic flowchart illustrating a method for storing the database update object according to an embodiment of the present invention, where the method includes:
step S300: determining a state attribute of the database update object;
in one implementation, determining that the state attribute of the database update object which is not modified after being obtained by querying from the database in the current business transaction process is clear; determining the state attribute of the modified database update object which is obtained by inquiring from the database in the current business transaction processing process as dirty; determining the state attribute of a newly-built database updating object in the current business transaction processing process as new; and determining the state attribute of the database update object which is deleted after being inquired and acquired from the database in the current business transaction processing process as removed.
Step S310: determining the type and ID of the database updating object;
in one possible implementation, the type of the database update object is a target Java class to which the database update object belongs, and the ID of the database update object is unique in the target Java class.
Step S320: and storing the database updating object and the type, the ID and the state attribute of the database updating object.
In one implementation, all database update objects generated during the current business transaction may be stored in the identification mapping module based on a two-level Map container, where the first level of the container is the type of the database update object and the second level is the ID of the database update object, and the work unit module may locate a target object in the identification mapping module by a binary group (i.e., type + ID).
In the prior art, different lists are used to store objects with different state attributes, and in this scheme, when the state attribute of an object changes (for example, from dirty state to removed state), the object needs to be deleted from one list and then added to another list.
In view of this problem, in the embodiment of the present invention, a concept of "stateful object" is proposed, that is, the database update object is packaged into one stateful object by determining the state attribute of the database update object, and then stored in the identity mapping module. Because the object has the state attribute, a plurality of additional lists are not needed for distinguishing; when the database is updated, a plurality of lists do not need to be traversed, and when the state of the object changes (for example, the object is changed from a dirty state to a removed state), the object does not need to be deleted from one list and then added to another list, but the state attribute of the object is directly modified.
In one embodiment, the obtaining the stored database update object and updating the obtained database update object into the database includes:
classifying the obtained database updating objects according to object types to obtain a plurality of groups of database updating objects, wherein the object types of the database updating objects contained in each group of database updating objects are the same;
and performing the following processing on each group of database updating objects:
acquiring a target warehousing class corresponding to the object type of the group of database updating objects;
and calling the target warehousing class to update the set of database update objects to the database.
The data warehousing module is responsible for maintaining the mapping relation between the objects of various types and the warehousing classes. After the current business transaction is completed, the working unit module can acquire the database updating object from the identification mapping module and classify the acquired database updating object according to the object type to obtain a plurality of groups of database updating objects. And for each group of data updating objects, acquiring a target warehousing class corresponding to the type of the data updating object from the data warehousing module, and calling the target warehousing class to update the group of database updating objects to the database. When the target warehousing class is called to update the group of database updating objects to the database, insert, update and delete operations of the warehousing class are called respectively according to the state attributes of the database updating objects contained in the group, and the database updating objects are updated to the database. It should be noted that the database update objects with the state attribute of clean are ignored because these objects are unchanged from the original objects of the database.
Compared with the prior art, the scheme can effectively reduce database calling. This reduction is manifested in two ways:
firstly, the same data record is modified for multiple times, and the scheme can write back to the database only by one-time database calling;
secondly, the modification of a plurality of data records of the same data table can be combined with the batch updating operation of the database very conveniently, and the modification of a plurality of records can be realized in a one-time database calling mode.
Referring to fig. 4, fig. 4 is a schematic structural diagram of a database updating apparatus according to an embodiment of the present invention, the apparatus including:
an obtaining unit 40, configured to obtain a database update object generated in a current service transaction processing process;
a storage unit 41 configured to store the database update object;
and an updating unit 42, configured to obtain the stored database update object after the current service transaction is completed, and update the obtained database update object into the database.
Optionally, the storage unit is specifically configured to:
determining a state attribute of the database update object;
determining the type and ID of the database updating object;
and storing the database updating object and the type, the ID and the state attribute of the database updating object.
Optionally, the updating unit is specifically configured to:
classifying the obtained database updating objects according to object types to obtain a plurality of groups of database updating objects, wherein the object types of the database updating objects contained in each group of database updating objects are the same;
and performing the following processing on each group of database updating objects:
acquiring a target warehousing class corresponding to the object type of the group of database updating objects;
and calling the target warehousing class to update the set of database update objects to the database.
Optionally, the database update object includes:
inquiring an unmodified database updating object from a database in the current business transaction processing process;
inquiring the modified database updating object obtained from the database in the current business transaction processing process;
the newly created database updating object in the current business transaction processing process:
and inquiring the deleted database updating object from the database in the current business transaction processing process.
Optionally, the storage unit is specifically configured to:
determining the state attribute of the unmodified database update object as clear after being inquired and acquired from the database in the current business transaction processing process;
determining the state attribute of the modified database update object which is obtained by inquiring from the database in the current business transaction processing process as dirty;
determining the state attribute of a newly-built database updating object in the current business transaction processing process as new;
and determining the state attribute of the database update object which is deleted after being inquired and acquired from the database in the current business transaction processing process as removed.
It should be noted that specific function implementation of each unit is already described in detail in the method embodiment, and this embodiment is not described again.
The database updating device comprises a processor and a memory, wherein the acquisition unit, the storage unit, the updating unit and the like are stored in the memory as program units, and the processor executes the program units stored in the memory to realize corresponding functions.
The processor comprises a kernel, and the kernel calls the corresponding program unit from the memory. The kernel can be set to be one or more than one, the number of times of calling the database in the process of processing one service transaction is reduced by adjusting the kernel parameters, the time consumption of processing one service transaction by the service system is reduced, and the performance of the service system is improved.
The memory may include volatile memory in a computer readable medium, Random Access Memory (RAM) and/or nonvolatile memory such as Read Only Memory (ROM) or flash memory (flash RAM), and the memory includes at least one memory chip.
An embodiment of the present invention provides a storage medium on which a program is stored, the program implementing the database updating method when executed by a processor.
The embodiment of the invention provides a processor, which is used for running a program, wherein the database updating method is executed when the program runs.
The embodiment of the invention provides equipment, which comprises a processor, a memory and a program which is stored on the memory and can run on the processor, wherein the processor executes the program and realizes the following steps:
acquiring a database updating object generated in the current business transaction processing process;
storing the database updating object;
and after the current business transaction is completed, acquiring a stored database updating object, and updating the acquired database updating object into a database.
Optionally, the storing the database update object includes:
determining a state attribute of the database update object;
determining the type and ID of the database updating object;
and storing the database updating object and the type, the ID and the state attribute of the database updating object.
Optionally, the obtaining a stored database update object and updating the obtained database update object into the database includes:
classifying the obtained database updating objects according to object types to obtain a plurality of groups of database updating objects, wherein the object types of the database updating objects contained in each group of database updating objects are the same;
and performing the following processing on each group of database updating objects:
acquiring a target warehousing class corresponding to the object type of the group of database updating objects;
and calling the target warehousing class to update the set of database update objects to the database.
Optionally, the database update object includes:
inquiring an unmodified database updating object from a database in the current business transaction processing process;
inquiring the modified database updating object obtained from the database in the current business transaction processing process;
the newly created database updating object in the current business transaction processing process:
and inquiring the deleted database updating object from the database in the current business transaction processing process.
Optionally, the determining the state attribute of the database update object includes:
determining the state attribute of the unmodified database update object as clear after being inquired and acquired from the database in the current business transaction processing process;
determining the state attribute of the modified database update object which is obtained by inquiring from the database in the current business transaction processing process as dirty;
determining the state attribute of a newly-built database updating object in the current business transaction processing process as new;
and determining the state attribute of the database update object which is deleted after being inquired and acquired from the database in the current business transaction processing process as removed.
The device herein may be a server, a PC, a PAD, a mobile phone, etc.
The present application further provides a computer program product adapted to perform a program for initializing the following method steps when executed on a data processing device:
acquiring a database updating object generated in the current business transaction processing process;
storing the database updating object;
and after the current business transaction is completed, acquiring a stored database updating object, and updating the acquired database updating object into a database.
Optionally, the storing the database update object includes:
determining a state attribute of the database update object;
determining the type and ID of the database updating object;
and storing the database updating object and the type, the ID and the state attribute of the database updating object.
Optionally, the obtaining a stored database update object and updating the obtained database update object into the database includes:
classifying the obtained database updating objects according to object types to obtain a plurality of groups of database updating objects, wherein the object types of the database updating objects contained in each group of database updating objects are the same;
and performing the following processing on each group of database updating objects:
acquiring a target warehousing class corresponding to the object type of the group of database updating objects;
and calling the target warehousing class to update the set of database update objects to the database.
Optionally, the database update object includes:
inquiring an unmodified database updating object from a database in the current business transaction processing process;
inquiring the modified database updating object obtained from the database in the current business transaction processing process;
the newly created database updating object in the current business transaction processing process:
and inquiring the deleted database updating object from the database in the current business transaction processing process.
Optionally, the determining the state attribute of the database update object includes:
determining the state attribute of the unmodified database update object as clear after being inquired and acquired from the database in the current business transaction processing process;
determining the state attribute of the modified database update object which is obtained by inquiring from the database in the current business transaction processing process as dirty;
determining the state attribute of a newly-built database updating object in the current business transaction processing process as new;
and determining the state attribute of the database update object which is deleted after being inquired and acquired from the database in the current business transaction processing process as removed.
As will be appreciated by one skilled in the art, 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 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.
In a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include forms of volatile memory in a computer readable medium, Random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). The memory is an example of a computer-readable medium.
Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium (transi-tory medium ia), such as a modulated data signal and a carrier wave.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in the process, method, article, or apparatus that comprises the element.
As will be appreciated by one skilled in the art, 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 above are merely examples of the present application and are not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.
Claims (8)
1. A database update method for a unit of work module, the method comprising:
acquiring a database updating object generated by a business transaction processing module in the process of processing the current business transaction; different business affairs correspond to different work unit modules;
determining a state attribute of the database update object;
determining the type and ID of the database updating object; the type of the database updating object is a target Java class to which the database updating object belongs, and the ID of the database updating object is unique in the target Java class;
storing the database updating object and the type, ID and state attribute of the database updating object to an identification mapping module; the database updating object is stored based on a two-level MAP container, the first level of the container is the type of the database updating object, the second level of the container is the ID of the database updating object, and a binary group formed by the type and the ID of the database updating object is used for positioning the database updating object;
and after the current business transaction is completed, acquiring a stored database updating object from the identifier mapping module, and calling a storage class in the data storage module to update the acquired database updating object to the database.
2. The method according to claim 1, wherein the retrieving the stored database update object from the identifier mapping module and calling the repository class in the data repository module to update the retrieved database update object into the database comprises:
classifying the obtained database updating objects according to object types to obtain a plurality of groups of database updating objects, wherein the object types of the database updating objects contained in each group of database updating objects are the same;
and performing the following processing on each group of database updating objects:
acquiring a target warehousing class corresponding to the object type of the group of database updating objects;
and calling the target warehousing class to update the set of database update objects to the database.
3. The method of any of claims 1-2, wherein updating the object with the database comprises:
inquiring an unmodified database updating object from a database in the current business transaction processing process;
inquiring the modified database updating object obtained from the database in the current business transaction processing process;
the newly created database updating object in the current business transaction processing process:
and inquiring the deleted database updating object from the database in the current business transaction processing process.
4. The method of claim 1, wherein determining the state attribute of the database update object comprises:
determining the state attribute of the unmodified database update object as clear after being inquired and acquired from the database in the current business transaction processing process;
determining the state attribute of the modified database update object which is obtained by inquiring from the database in the current business transaction processing process as dirty;
determining the state attribute of a newly-built database updating object in the current business transaction processing process as new;
and determining the state attribute of the database update object which is deleted after being inquired and acquired from the database in the current business transaction processing process as removed.
5. A database update apparatus for a unit of work module, the apparatus comprising:
the acquisition unit is used for acquiring a database updating object generated by the business transaction processing module in the process of processing the current business transaction; different business affairs correspond to different work unit modules;
the storage unit is used for determining the state attribute of the database updating object; determining the type and ID of the database updating object; the type of the database updating object is a target Java class to which the database updating object belongs, and the ID of the database updating object is unique in the target Java class; storing the database updating object and the type, ID and state attribute of the database updating object to an identification mapping module; the database updating object is stored based on a two-level MAP container, the first level of the container is the type of the database updating object, the second level of the container is the ID of the database updating object, and a binary group formed by the type and the ID of the database updating object is used for positioning the database updating object;
and the updating unit is used for acquiring the stored database updating object from the identifier mapping module after the current business transaction is completed, and calling the storage class in the data storage module to update the acquired database updating object to the database.
6. The apparatus according to claim 5, wherein the updating unit is specifically configured to:
classifying the obtained database updating objects according to object types to obtain a plurality of groups of database updating objects, wherein the object types of the database updating objects contained in each group of database updating objects are the same;
and performing the following processing on each group of database updating objects:
acquiring a target warehousing class corresponding to the object type of the group of database updating objects;
and calling the target warehousing class to update the set of database update objects to the database.
7. The apparatus of any of claims 5 to 6, wherein the database update object comprises:
inquiring an unmodified database updating object from a database in the current business transaction processing process;
inquiring the modified database updating object obtained from the database in the current business transaction processing process;
the newly created database updating object in the current business transaction processing process:
and inquiring the deleted database updating object from the database in the current business transaction processing process.
8. The apparatus according to claim 5, wherein the storage unit is specifically configured to:
determining the state attribute of the unmodified database update object as clear after being inquired and acquired from the database in the current business transaction processing process;
determining the state attribute of the modified database update object which is obtained by inquiring from the database in the current business transaction processing process as dirty;
determining the state attribute of a newly-built database updating object in the current business transaction processing process as new;
and determining the state attribute of the database update object which is deleted after being inquired and acquired from the database in the current business transaction processing process as removed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811285175.6A CN109299125B (en) | 2018-10-31 | 2018-10-31 | Database updating method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811285175.6A CN109299125B (en) | 2018-10-31 | 2018-10-31 | Database updating method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109299125A CN109299125A (en) | 2019-02-01 |
| CN109299125B true CN109299125B (en) | 2021-05-28 |
Family
ID=65145452
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811285175.6A Active CN109299125B (en) | 2018-10-31 | 2018-10-31 | Database updating method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109299125B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110674213A (en) * | 2019-08-30 | 2020-01-10 | 中国人民财产保险股份有限公司 | Data synchronization method and device |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101021875A (en) * | 2007-03-22 | 2007-08-22 | 金蝶软件（中国）有限公司 | Object-oriented data bank access method and system |
| CN101436184A (en) * | 2007-11-15 | 2009-05-20 | 金蝶软件（中国）有限公司 | Batch data operating method |
| CN101739435A (en) * | 2008-11-07 | 2010-06-16 | 中国移动通信集团公司 | Database access method, control device and control system |
| CN102420814A (en) * | 2011-11-21 | 2012-04-18 | 航天科工深圳（集团）有限公司 | Data access method and device, and server |
| CN103678632A (en) * | 2013-12-19 | 2014-03-26 | 成都市卓睿科技有限公司 | System and method for updating data fast in data system |
| CN104881461A (en) * | 2015-05-22 | 2015-09-02 | 国云科技股份有限公司 | Rapid data storage method |
| CN106933828A (en) * | 2015-12-29 | 2017-07-07 | 北京国双科技有限公司 | data insertion method and device |
| CN107463612A (en) * | 2017-06-29 | 2017-12-12 | 北京北信源软件股份有限公司 | High concurrent REDIS database operation methods and system |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102999522B (en) * | 2011-09-15 | 2016-09-14 | 阿里巴巴集团控股有限公司 | A kind of date storage method and device |
| CN102426582B (en) * | 2011-09-29 | 2016-03-30 | 用友软件股份有限公司 | Data manipulation management devices and data manipulation management method |
| CN104504158A (en) * | 2015-01-19 | 2015-04-08 | 浪潮(北京)电子信息产业有限公司 | Memory caching method and device for rapidly updating business |
| US10198473B2 (en) * | 2015-04-21 | 2019-02-05 | Sap Se | Hierarchical document flow determination |
| CN108255620B (en) * | 2018-01-08 | 2021-11-05 | 北京奇艺世纪科技有限公司 | Service logic processing method, device, service server and system |
-
2018
- 2018-10-31 CN CN201811285175.6A patent/CN109299125B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101021875A (en) * | 2007-03-22 | 2007-08-22 | 金蝶软件（中国）有限公司 | Object-oriented data bank access method and system |
| CN101436184A (en) * | 2007-11-15 | 2009-05-20 | 金蝶软件（中国）有限公司 | Batch data operating method |
| CN101739435A (en) * | 2008-11-07 | 2010-06-16 | 中国移动通信集团公司 | Database access method, control device and control system |
| CN102420814A (en) * | 2011-11-21 | 2012-04-18 | 航天科工深圳（集团）有限公司 | Data access method and device, and server |
| CN103678632A (en) * | 2013-12-19 | 2014-03-26 | 成都市卓睿科技有限公司 | System and method for updating data fast in data system |
| CN104881461A (en) * | 2015-05-22 | 2015-09-02 | 国云科技股份有限公司 | Rapid data storage method |
| CN106933828A (en) * | 2015-12-29 | 2017-07-07 | 北京国双科技有限公司 | data insertion method and device |
| CN107463612A (en) * | 2017-06-29 | 2017-12-12 | 北京北信源软件股份有限公司 | High concurrent REDIS database operation methods and system |
Non-Patent Citations (1)
| Title |
|---|
| Java反射机制简介及简单实例;decode-life;《http://blog.csdn.net/abudexiatian/article/details/39375885》;20140918;全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109299125A (en) | 2019-02-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110223682B (en) | Voice instruction arbitration method and device | |
| CN109634682B (en) | Configuration file updating method and device for application program | |
| CN106897342B (en) | Data verification method and equipment | |
| CN110895544B (en) | Interface data processing method, device, system and storage medium | |
| CN111784468B (en) | Account association method and device and electronic equipment | |
| CN110968565A (en) | Database creation method and system | |
| CN107451204B (en) | Data query method, device and equipment | |
| CN109299125B (en) | Database updating method and device | |
| CN109388644B (en) | Data updating method and device | |
| CN112597151A (en) | Data processing method, device, equipment and storage medium | |
| CN109977317B (en) | Data query method and device | |
| CN110888723A (en) | Timing task processing method and device | |
| CN111125087A (en) | Data storage method and device | |
| CN116010345A (en) | Method, device and equipment for realizing table service scheme of flow batch integrated data lake | |
| CN114138745A (en) | Data integration method and device, storage medium and processor | |
| CN108241622B (en) | Query script generation method and device | |
| CN111339117B (en) | Data processing method, device and equipment | |
| CN115293243A (en) | Method, device and equipment for realizing intelligent matching of data assets | |
| CN108062329B (en) | Data import method and device | |
| CN110968587A (en) | Data processing method and device | |
| CN114281461A (en) | Management method, equipment and medium for configurable data source attributes | |
| CN111367461B (en) | Storage space management method and device | |
| CN110019507B (en) | Data synchronization method and device | |
| CN108073596B (en) | Data deletion method and device for OLAP database | |
| CN112580915A (en) | Project milestone determination method and device, storage medium and electronic equipment |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |