Implementation method based on sqlldr2 and og data synchronization
An implementation method and data synchronization technology, which is applied in the field of data processing, can solve problems such as difficulty in cross-platform data import, frequent data import and export, and inability to add or delete according to requirements, so as to achieve the effect of reducing workload
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment Construction
[0031] see figure 1 , in the embodiment of the present invention, a kind of realization method based on sqlldr2 and ogg data synchronization, described realization method comprises Oracle database, sqlldr2 client, ogg synchronization tool, HDFS distributed file system;
[0032] The sqlldr2 client is used to export the Oracle database data, and the data is exported in txt form, and transmitted to the HDFS distributed file system;
[0033] The ogg synchronization tool is used to synchronously export the log files of the Oracle database. After the redo log in the Oracle database loads the modified log files from the disk into the memory, the archive log mode archives and backs up the modified log files. When the data is exported , the source end of the ogg synchronization tool reads the redo log in real time and parses it into SQL statements and transmits it to the target end in the form of a binary file. The process of the ogg synchronization tool process on the target end reads...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com