CN109165263A - Log analysis processing method and processing device, DDL synchronous method and the device of database - Google Patents
Log analysis processing method and processing device, DDL synchronous method and the device of database Download PDFInfo
- Publication number
- CN109165263A CN109165263A CN201811203502.9A CN201811203502A CN109165263A CN 109165263 A CN109165263 A CN 109165263A CN 201811203502 A CN201811203502 A CN 201811203502A CN 109165263 A CN109165263 A CN 109165263A
- Authority
- CN
- China
- Prior art keywords
- ddl
- database
- file
- ddl transaction
- data dictionary
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the present invention discloses log analysis processing method and processing device, DDL synchronous method and the device of a kind of database, can be reduced on the influence of the performance of database, especially in the case where frequently executing DDL operation, avoids database blockage.The log analysis processing method of database includes: to generate DDL transaction file by the log of analytical database；By analyzing the database, obtains DDL and trade field information of the corresponding table after DDL transaction executes, the field information is utilized to generate data dictionary file；The DDL transaction file and data dictionary file are sent to target side, so that the target side executes the DDL transaction file, and update data with existing dictionary using the data dictionary file.
Description
Technical field
The present embodiments relate to database fields, and in particular to a kind of the log analysis processing method and dress of database
It sets, DDL synchronous method and device.
Background technique
Data base logic transaction grade duplication is source by the transaction in analytical database log, forms transaction file
(xf1/xdt), by transmission of network to target side, target end data is encased in by conversions such as user, table, data in target side
Library, to guarantee the consistent of two client databases.The transaction of common database includes DML (data manipulation language), DDL (database
Pattern definition language), DCL (data library control language), DQL (data base query language).Wherein, data are not write in the operation of DQL
Library log does not need to analyze；The operation of DCL is to know to control in advance；The operation of DML is that logic transaction grade duplication is most basic
Function；And the operation of DDL is related to the change of table structure and is mingled with the front and back that DML is operated after DML and DDL before DDL
It sequentially, is the critical function for testing logic transaction grade duplication software stability and ease for use.
Currently used DDL synchronous method is by recording DDL in source creation database D DL trigger (trigger)
Operation, and it is synchronized to target side, this mode is affected to the performance of database, especially in the feelings for frequently executing DDL operation
Under condition, it is easy to cause database blockage, influences being normally carried out for production business.
Summary of the invention
In view of the shortcomings of the prior art and defect, the embodiment of the present invention provide a kind of log analysis processing of database
Method and device, DDL synchronous method and device.
On the one hand, the embodiment of the present invention proposes a kind of log analysis processing method of database, comprising:
DDL transaction file is generated by the log of analytical database；
By analyzing the database, obtains DDL and trade field information of the corresponding table after DDL transaction executes, utilize
The field information generates data dictionary file；
The DDL transaction file and data dictionary file are sent to target side, so that the target side executes the DDL
Transaction file, and data with existing dictionary is updated using the data dictionary file.
On the other hand, the embodiment of the present invention proposes a kind of DDL synchronous method, comprising:
Receive DDL transaction file and data dictionary file that source is sent；
The DDL transaction file is executed, and updates data with existing dictionary using the data dictionary file.
The third aspect, the embodiment of the present invention propose a kind of log analysis processing unit of database, comprising:
Analytical unit, for generating DDL transaction file by the log of analytical database；
Query unit, for obtaining DDL and trading corresponding table after DDL transaction executes by analyzing the database
Field information generates data dictionary file using the field information；
Transmission unit, for the DDL transaction file and data dictionary file to be sent to target side, so that the target
End executes the DDL transaction file, and updates data with existing dictionary using the data dictionary file.
Fourth aspect, the embodiment of the present invention propose a kind of DDL synchronizing device, comprising:
Receiving unit, for receiving the database schema definitional language DDL transaction file and data dictionary text of source transmission
Part；
Execution unit updates data with existing word for executing the DDL transaction file, and using the data dictionary file
Allusion quotation.
5th aspect, the embodiment of the present invention provide a kind of electronic equipment, comprising: processor, memory, bus and are stored in
On memory and the computer program that can run on a processor；
Wherein, the processor, memory complete mutual communication by the bus；
The processor realizes the above method when executing the computer program.
6th aspect, the embodiment of the present invention provide a kind of non-transient computer readable storage medium, on the storage medium
It is stored with computer program, which realizes the above method when being executed by processor.
Log analysis processing method and processing device, DDL synchronous method and the device of database provided in an embodiment of the present invention,
Source generates DDL transaction file by the log of analytical database；By analyzing the database, it is corresponding to obtain DDL transaction
Field information of the table after DDL transaction executes, generates data dictionary file using the field information；The DDL is traded literary
Part and data dictionary file are sent to target side；The DDL transaction file that source is sent is executed in target side, and described in utilization
Data dictionary file updates data with existing dictionary, and entire DDL synchronizing process does not need to create database D DL trigger in source,
Thus compared to the prior art, this programme can be reduced on the influence of the performance of database, especially the case where frequently executing DDL operation
Under, avoid database blockage.
Detailed description of the invention
Fig. 1 is the flow diagram of one embodiment of log analysis processing method of database of the present invention；
Fig. 2 is the flow diagram of one embodiment of DDL synchronous method of the present invention；
Fig. 3 is the structural schematic diagram of one embodiment of log analysis processing unit of database of the present invention；
Fig. 4 is the structural schematic diagram of one embodiment of DDL synchronizing device of the present invention；
Fig. 5 is the entity structure schematic diagram of a kind of electronic equipment provided in an embodiment of the present invention；
Fig. 6 is the entity structure schematic diagram of another electronic equipment provided in an embodiment of the present invention.
Specific embodiment
In order to make the object, technical scheme and advantages of the embodiment of the invention clearer, below in conjunction with the embodiment of the present invention
In attached drawing, technical solution in the embodiment of the present invention is explicitly described, it is clear that described embodiment is the present invention
A part of the embodiment, instead of all the embodiments.Based on the embodiments of the present invention, those of ordinary skill in the art are not having
Every other embodiment obtained under the premise of creative work is made, the range of protection of the embodiment of the present invention is belonged to.
Referring to Fig. 1, the present embodiment discloses a kind of log analysis processing method of database, comprising:
S10, DDL transaction file is generated by the log of analytical database；
It is understood that including that DDL trades the mark of corresponding table in the log of database, existing mapping is utilized
Relationship can be by the identity map at the objn field.
S11, by analyzing the database, obtain DDL and trade field information of the corresponding table after DDL transaction executes,
Data dictionary file is generated using the field information；
S12, the DDL transaction file and data dictionary file are sent to target side, so that the target side executes institute
DDL transaction file is stated, and updates data with existing dictionary using the data dictionary file.
It is understood that only include the field information of the table in the data dictionary file that step S11 is generated, i.e., it is described
Data dictionary file is the corresponding data dictionary file of the table.When updating, it is only necessary to more using the data dictionary file
Content in relation to the table in the data with existing dictionary of fresh target end.
The log analysis processing method of database provided in an embodiment of the present invention, source are raw by the log of analytical database
At DDL transaction file；By analyzing the database, obtains DDL and trade field letter of the corresponding table after DDL transaction executes
Breath generates data dictionary file using the field information；The DDL transaction file and data dictionary file are sent to target
End in order to which target side executes the DDL transaction file that source is sent, and has number using data dictionary file update
According to dictionary, entire DDL synchronizing process does not need to create database D DL trigger in source, thus compared to the prior art, we
Case can be reduced on the influence of the performance of database, especially in the case where frequently executing DDL operation, avoid database blockage.
It is described by analyzing the database on the basis of preceding method embodiment, it obtains the corresponding table of DDL transaction and exists
DDL transaction execute after field information, may include:
SOL mode is looked into using returning, by inquiring the $ base table of the database, obtains the table after DDL transaction executes
Field information.
In the present embodiment, in the case where DDL is not very frequent situation, single DDL synchronous method can be by analysis log
The specific DDL sentence of record, first generates the transaction file of DDL and DDL trades the objn field of corresponding table, then again by looking into
The SQL for asking $ base table inquires the case where each field is by DDL according to the objn of this table, forms data dictionary file.In this way
In target end data, DDL transaction file is first carried out, the change operation of DDL is carried out in target client database, then again data word
In allusion quotation up-to-date to pervious data dictionary file, entire DDL duplication operating process is completed.
It is described by analyzing the database on the basis of preceding method embodiment, it obtains the corresponding table of DDL transaction and exists
DDL transaction execute after field information, may include:
Using analysis base table mode, the dml for reforming $ base table in redo log by analyzing the database is operated, and is obtained
To field information of the table after DDL transaction executes.
What previous embodiment of the method used returns each field value for looking into that SQL is the inquiry $ base table directly into database,
Belong to subsequent inquiry.In the present embodiment, in the case where there is frequent DDL (i.e. moment generates batch DDL and batch DML), if
Reusing back the mode for looking into SQL, it is possible to the data dictionary that just will appear generation is not the state for having executed DDL that time,
Subsequent DML operation is caused to go wrong.
Such as: increasing a column, be inserted into one, be further added by a column, be inserted into one, when log analysis lag, such as
Fruit analyzes first movement for increasing column, and the data dictionary for looking into generation is returned by SQL, is after finally having increased by two column
Data dictionary will report ignorant field errors, lead so in this way when target client database loads first insertion
Cause target side that can not continue to replicate in real time.
In order to solve such case, guarantee has executed the data dictionary generated after DDL, is exactly the data word at that time under state
Allusion quotation, take analytical database reform in redo log ($ base table such as: COL $, OBJ $, TAB $, PARTOBJ $, PARTCOL $,
LOBCOMPPART$、LOB$、LOBFRAG$、PARTLOB$、SUBPARTCOL$、TABCOMPART$、TABPART$、
TABSUBPART $, COLTYPE $, SUBCOLTYPE $, TYPE $, ATTRIBUTE $, SEQ $ etc.) dml operation method, according to
Changing to restore the content of variation for $ base table, belongs to and obtains variation in real time.
The variation of DDL is actually to be reacted to the variation of these $ base table respective fields column, by the phase for inquiring $ base table
The variation held inside the Pass is combined into new data dictionary file, has executed DDL to target side, has then been updated under state at that time again
Data dictionary guarantees that DDL+DML duplication is normal.
In the present embodiment, by analyzing base table, the structure change of library table can be got, in real time convenient for synchronization will be changed
To target client database, so as to meet " increasing by a column, be inserted into one, be further added by a column, be inserted into one " in this frequently
The application demand of DDL scene.
Referring to Fig. 2, the present embodiment discloses a kind of DDL synchronous method, comprising:
S20, DDL transaction file and data dictionary file that source is sent are received；
S21, the DDL transaction file is executed, and updates data with existing dictionary using the data dictionary file.
DDL synchronous method provided in an embodiment of the present invention, the DDL transaction file and data dictionary sent by receiving source
File；The DDL transaction file is executed, and updates data with existing dictionary using the data dictionary file, entire DDL was synchronized
Journey does not need to create database D DL trigger in source, thus compared to the prior art, this programme can be reduced the property to database
It can influence, especially in the case where frequently executing DDL operation, avoid database blockage.
Referring to Fig. 3, the present embodiment discloses a kind of log analysis processing unit of database, comprising:
Analytical unit 10, for generating DDL transaction file by the log of analytical database；
Query unit 11, for obtaining DDL and trading corresponding table after DDL transaction executes by analyzing the database
Field information, utilize the field information generate data dictionary file；
Transmission unit 12, for the DDL transaction file and data dictionary file to be sent to target side, so that the mesh
It marks end and executes the DDL transaction file, and update data with existing dictionary using the data dictionary file.
Specifically, the analytical unit 10 generates DDL transaction file by the log of analytical database；The query unit
11 by analyzing the database, obtains DDL and trades field information of the corresponding table after DDL transaction executes, utilizes the word
Segment information generates data dictionary file；The DDL transaction file and data dictionary file are sent to mesh by the transmission unit 12
End is marked, so that the target side executes the DDL transaction file, and updates data with existing word using the data dictionary file
Allusion quotation.
The log analysis processing unit of database provided in an embodiment of the present invention passes through analysis data by means of analytical unit
The log in library generates DDL transaction file；By means of query unit by analyzing the database, the corresponding table of DDL transaction is obtained
Field information after DDL transaction executes, generates data dictionary file using the field information；By means of transmission unit by institute
It states DDL transaction file and data dictionary file is sent to target side, in order to which target side executes the DDL transaction that source is sent
File, and data with existing dictionary is updated using the data dictionary file, entire DDL synchronizing process does not need to create number in source
According to library DDL trigger, thus compared to the prior art, this programme be can be reduced on the influence of the performance of database, especially frequently held
In the case that row DDL is operated, database blockage is avoided.
On the basis of aforementioned device embodiment, the query unit can be used for:
SOL mode is looked into using returning, by inquiring the $ base table of the database, obtains the table after DDL transaction executes
Field information.
On the basis of aforementioned device embodiment, the query unit can be used for:
Using analysis base table mode, the dml for reforming $ base table in redo log by analyzing the database is operated, and is obtained
To field information of the table after DDL transaction executes.
Referring to Fig. 4, the present embodiment discloses a kind of DDL synchronizing device, comprising:
Receiving unit 20, for receiving the DDL transaction file and data dictionary file of source transmission；
Execution unit 21 updates data with existing for executing the DDL transaction file, and using the data dictionary file
Dictionary.
Specifically, the receiving unit 20 receives the DDL transaction file and data dictionary file that source is sent；The execution
Unit 21 executes the DDL transaction file, and updates data with existing dictionary using the data dictionary file.
DDL synchronizing device provided in an embodiment of the present invention receives the DDL transaction file that source is sent by means of receiving unit
With data dictionary file；The DDL transaction file is executed by means of execution unit, and is updated using the data dictionary file
There is data dictionary, entire DDL synchronizing process does not need to create database D DL trigger in source, thus compared to the prior art,
This programme can be reduced on the influence of the performance of database, especially in the case where frequently executing DDL operation, avoid database blockage.
Fig. 5 shows the entity structure schematic diagram of a kind of electronic equipment provided in an embodiment of the present invention, as shown in figure 5, should
Electronic equipment may include: first processor 110, first memory 120, the first bus 130 and be stored in first memory 120
Computer program that is upper and being run on first processor 110；
Wherein, the first processor 110, first memory 120 complete mutual lead to by first bus 130
Letter；
The first processor 110 realizes side provided by above-mentioned each method embodiment when executing the computer program
Method, for example, DDL transaction file is generated by the log of analytical database；By analyzing the database, DDL friendship is obtained
Field information of the easy corresponding table after DDL transaction executes, generates data dictionary file using the field information；It will be described
DDL transaction file and data dictionary file are sent to target side, so that the target side executes the DDL transaction file, and benefit
Data with existing dictionary is updated with the data dictionary file.
The embodiment of the present invention provides a kind of non-transient computer readable storage medium, is stored thereon with computer program, should
Method provided by above-mentioned each method embodiment is realized when computer program is executed by processor, for example, by analyzing number
DDL transaction file is generated according to the log in library；By analyzing the database, obtains DDL and trade corresponding table in DDL transaction execution
Field information afterwards generates data dictionary file using the field information；By the DDL transaction file and data dictionary file
It is sent to target side, so that the target side executes the DDL transaction file, and is updated and is had using the data dictionary file
Data dictionary.
Fig. 6 shows the entity structure schematic diagram of a kind of electronic equipment provided in an embodiment of the present invention, as shown in fig. 6, should
Electronic equipment may include: second processor 210, second memory 220, the second bus 230 and be stored in second memory 220
Computer program that is upper and being run in second processor 210；
Wherein, the second processor 210, second memory 220 complete mutual lead to by second bus 230
Letter；
The second processor 210 realizes side provided by above-mentioned each method embodiment when executing the computer program
Method, for example, receive DDL transaction file and data dictionary file that source is sent；Execute the DDL transaction file, and benefit
Data with existing dictionary is updated with the data dictionary file.
The embodiment of the present invention provides a kind of non-transient computer readable storage medium, is stored thereon with computer program, should
Method provided by above-mentioned each method embodiment is realized when computer program is executed by processor, for example, receive source hair
The DDL transaction file and data dictionary file sent；The DDL transaction file is executed, and is updated using the data dictionary file
Data with existing dictionary.
It should be understood by those skilled in the art that, embodiments herein can provide as method, system or computer program
Product.Therefore, complete hardware embodiment, complete software embodiment or reality combining software and hardware aspects can be used in the application
Apply the form of example.Moreover, it wherein includes the computer of computer usable program code that the application, which can be used in one or more,
The computer program implemented in usable storage medium (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.) produces
The form of product.
The application is referring to method, the process of equipment (system) and computer program product according to the embodiment of the present application
Figure and/or block diagram describe.It should be understood that every one stream in flowchart and/or the block diagram can be realized by computer program instructions
The combination of process and/or box in journey and/or box and flowchart and/or the block diagram.It can provide these computer programs
Instruct the processor of general purpose computer, special purpose computer, Embedded Processor or other programmable data processing devices to produce
A raw machine, so that being generated by the instruction that computer or the processor of other programmable data processing devices execute for real
The device for the function of being specified in present one or more flows of the flowchart and/or one or more blocks of the block diagram.
These computer program instructions, which may also be stored in, is able to guide computer or other programmable data processing devices with spy
Determine in the computer-readable memory that mode works, so that it includes referring to that instruction stored in the computer readable memory, which generates,
Enable the manufacture of device, the command device realize in one box of one or more flows of the flowchart and/or block diagram or
The function of being specified in multiple boxes.
These computer program instructions also can be loaded onto a computer or other programmable data processing device, so that counting
Series of operation steps are executed on calculation machine or other programmable devices to generate computer implemented processing, thus in computer or
The instruction executed on other programmable devices is provided for realizing in one or more flows of the flowchart and/or block diagram one
The step of function of being specified in a box or multiple boxes.
It should be noted that, in this document, relational terms such as first and second and the like are used merely to a reality
Body or operation are distinguished with another entity or operation, are deposited without necessarily requiring or implying between these entities or operation
In any actual relationship or order or sequence.Moreover, the terms "include", "comprise" or its any other variant are intended to
Non-exclusive inclusion, so that the process, method, article or equipment including a series of elements is not only wanted including those
Element, but also including other elements that are not explicitly listed, or further include for this process, method, article or equipment
Intrinsic element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that
There is also other identical elements in process, method, article or equipment including the element.Term " on ", "lower" etc. refer to
The orientation or positional relationship shown is to be based on the orientation or positional relationship shown in the drawings, and is merely for convenience of the description present invention and simplifies
Description, rather than the device or element of indication or suggestion meaning must have a particular orientation, constructed and grasped with specific orientation
Make, therefore is not considered as limiting the invention.Unless otherwise clearly defined and limited, term " installation ", " connected ",
" connection " shall be understood in a broad sense, for example, it may be being fixedly connected, may be a detachable connection, or be integrally connected；It can be
Mechanical connection, is also possible to be electrically connected；It can be directly connected, two can also be can be indirectly connected through an intermediary
Connection inside element.For the ordinary skill in the art, above-mentioned term can be understood at this as the case may be
Concrete meaning in invention.
In specification of the invention, numerous specific details are set forth.Although it is understood that the embodiment of the present invention can
To practice without these specific details.In some instances, well known method, structure and skill is not been shown in detail
Art, so as not to obscure the understanding of this specification.Similarly, it should be understood that disclose in order to simplify the present invention and helps to understand respectively
One or more of a inventive aspect, in the above description of the exemplary embodiment of the present invention, each spy of the invention
Sign is grouped together into a single embodiment, figure, or description thereof sometimes.However, should not be by the method solution of the disclosure
Release is in reflect an intention that i.e. the claimed invention requires more than feature expressly recited in each claim
More features.More precisely, as the following claims reflect, inventive aspect is less than single reality disclosed above
Apply all features of example.Therefore, it then follows thus claims of specific embodiment are expressly incorporated in the specific embodiment,
It is wherein each that the claims themselves are regarded as separate embodiments of the invention.It should be noted that in the absence of conflict, this
The feature in embodiment and embodiment in application can be combined with each other.The invention is not limited to any single aspect,
It is not limited to any single embodiment, is also not limited to any combination and/or displacement of these aspects and/or embodiment.And
And can be used alone each aspect and/or embodiment of the invention or with other one or more aspects and/or its implementation
Example is used in combination.
Finally, it should be noted that the above embodiments are only used to illustrate the technical solution of the present invention., rather than its limitations；To the greatest extent
Pipe present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that: its according to
So be possible to modify the technical solutions described in the foregoing embodiments, or to some or all of the technical features into
Row equivalent replacement；And these are modified or replaceed, various embodiments of the present invention technology that it does not separate the essence of the corresponding technical solution
The range of scheme should all cover within the scope of the claims and the description of the invention.
Claims (10)
1. a kind of log analysis processing method of database characterized by comprising
Database schema definitional language DDL transaction file is generated by the log of analytical database；
It by analyzing the database, obtains DDL and trades field information of the corresponding table after DDL transaction executes, using described
Field information generates data dictionary file；
The DDL transaction file and data dictionary file are sent to target side, so that the target side executes the DDL transaction
File, and data with existing dictionary is updated using the data dictionary file.
2. obtaining DDL transaction pair the method according to claim 1, wherein described by analyzing the database
Field information of the table answered after DDL transaction executes, comprising:
SOL mode is looked into using returning, by inquiring the $ base table of the database, obtains field of the table after DDL transaction executes
Information.
3. obtaining DDL transaction pair the method according to claim 1, wherein described by analyzing the database
Field information of the table answered after DDL transaction executes, comprising:
Using analysis base table mode, the dml for reforming $ base table in redo log by analyzing the database is operated, and obtains institute
State field information of the table after DDL transaction executes.
4. a kind of DDL synchronous method characterized by comprising
Receive database schema definitional language DDL transaction file and data dictionary file that source is sent；
The DDL transaction file is executed, and updates data with existing dictionary using the data dictionary file.
5. a kind of log analysis processing unit of database characterized by comprising
Analytical unit, for generating database schema definitional language DDL transaction file by the log of analytical database；
Query unit is traded field of the corresponding table after DDL transaction executes for by analyzing the database, obtaining DDL
Information generates data dictionary file using the field information；
Transmission unit, for the DDL transaction file and data dictionary file to be sent to target side, so that the target side is held
The row DDL transaction file, and data with existing dictionary is updated using the data dictionary file.
6. device according to claim 5, which is characterized in that the query unit is used for:
SOL mode is looked into using returning, by inquiring the $ base table of the database, obtains field of the table after DDL transaction executes
Information.
7. device according to claim 5, which is characterized in that the query unit is used for:
Using analysis base table mode, the dml for reforming $ base table in redo log by analyzing the database is operated, and obtains institute
State field information of the table after DDL transaction executes.
8. a kind of DDL synchronizing device characterized by comprising
Receiving unit, for receiving the database schema definitional language DDL transaction file and data dictionary file of source transmission；
Execution unit updates data with existing dictionary for executing the DDL transaction file, and using the data dictionary file.
9. a kind of electronic equipment characterized by comprising processor, memory, bus and storage on a memory and can located
The computer program run on reason device；
Wherein, the processor, memory complete mutual communication by the bus；
The processor realizes such as method of any of claims 1-4 when executing the computer program.
10. a kind of non-transient computer readable storage medium, which is characterized in that be stored with computer journey on the storage medium
Sequence realizes such as method of any of claims 1-4 when the computer program is executed by processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811203502.9A CN109165263A (en) | 2018-10-16 | 2018-10-16 | Log analysis processing method and processing device, DDL synchronous method and the device of database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811203502.9A CN109165263A (en) | 2018-10-16 | 2018-10-16 | Log analysis processing method and processing device, DDL synchronous method and the device of database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109165263A true CN109165263A (en) | 2019-01-08 |
Family
ID=64878275
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811203502.9A Pending CN109165263A (en) | 2018-10-16 | 2018-10-16 | Log analysis processing method and processing device, DDL synchronous method and the device of database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109165263A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111221907A (en) * | 2019-12-31 | 2020-06-02 | 武汉达梦数据库有限公司 | Database added column synchronization method and device based on log analysis |
| CN113641645A (en) * | 2021-08-16 | 2021-11-12 | 中国银行股份有限公司 | Transaction log processing method and device |
| CN114328573A (en) * | 2021-11-19 | 2022-04-12 | 嵊州市光宇实业有限公司 | Analysis method of log data of power system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102752372A (en) * | 2012-06-18 | 2012-10-24 | 天津神舟通用数据技术有限公司 | File based database synchronization method |
| CN106326376A (en) * | 2016-08-15 | 2017-01-11 | 东软集团股份有限公司 | Method and device for copying information after table structure modification |
| CN108121827A (en) * | 2018-01-15 | 2018-06-05 | 农信银资金清算中心有限责任公司 | A kind of synchronous method and device of full dose data |
-
2018
- 2018-10-16 CN CN201811203502.9A patent/CN109165263A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102752372A (en) * | 2012-06-18 | 2012-10-24 | 天津神舟通用数据技术有限公司 | File based database synchronization method |
| CN106326376A (en) * | 2016-08-15 | 2017-01-11 | 东软集团股份有限公司 | Method and device for copying information after table structure modification |
| CN108121827A (en) * | 2018-01-15 | 2018-06-05 | 农信银资金清算中心有限责任公司 | A kind of synchronous method and device of full dose data |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111221907A (en) * | 2019-12-31 | 2020-06-02 | 武汉达梦数据库有限公司 | Database added column synchronization method and device based on log analysis |
| CN113641645A (en) * | 2021-08-16 | 2021-11-12 | 中国银行股份有限公司 | Transaction log processing method and device |
| CN114328573A (en) * | 2021-11-19 | 2022-04-12 | 嵊州市光宇实业有限公司 | Analysis method of log data of power system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108573006B (en) | Cross-machine-room data synchronization system, method and device and electronic equipment | |
| JP2023546249A (en) | Transaction processing methods, devices, computer equipment and computer programs | |
| CN105446966B (en) | The method and apparatus that production Methods data are converted to the mapping ruler of RDF format data | |
| Bailis et al. | Eventual consistency today: Limitations, extensions, and beyond | |
| CN104598610B (en) | A kind of distributed data base data distribution uploads synchronous method | |
| CN103577407B (en) | Querying method and inquiry unit for distributed data base | |
| CN108399256A (en) | Heterogeneous database content synchronization method, device and middleware | |
| CN109690524A (en) | Data Serialization in distributed event processing system | |
| CN105808653B (en) | A kind of data processing method and device based on user tag system | |
| US11314717B1 (en) | Scalable architecture for propagating updates to replicated data | |
| CN105787058B (en) | A kind of user tag system and the data delivery system based on user tag system | |
| US10331657B1 (en) | Contention analysis for journal-based databases | |
| CA2972382A1 (en) | Apparatus and methods of data synchronization | |
| CN109165263A (en) | Log analysis processing method and processing device, DDL synchronous method and the device of database | |
| CN109189852A (en) | A kind of method that data are synchronous and the device synchronous for data | |
| US10133767B1 (en) | Materialization strategies in journal-based databases | |
| US10198346B1 (en) | Test framework for applications using journal-based databases | |
| CN110196758A (en) | Data processing method and device, storage medium and electronic device | |
| CN108460598A (en) | A kind of real-time automation supervision reporting system based on double-strand framework block chain | |
| Almeida et al. | Scalable and accurate causality tracking for eventually consistent stores | |
| CN109902117A (en) | Operation system analysis method and device | |
| US20220129418A1 (en) | Method for determining blood relationship of data, electronic device and storage medium | |
| CN104748757B (en) | A kind of data in navigation electronic map update method and device | |
| Dey et al. | Scalable distributed transactions across heterogeneous stores | |
| CN108536833A (en) | A kind of distributed, database and its construction method towards big data |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190108 |