CN109446267A - It is a kind of based on 95598 strange land dual-active calamities for the inter-library data integrated system and method for model - Google Patents
It is a kind of based on 95598 strange land dual-active calamities for the inter-library data integrated system and method for model Download PDFInfo
- Publication number
- CN109446267A CN109446267A CN201811112615.8A CN201811112615A CN109446267A CN 109446267 A CN109446267 A CN 109446267A CN 201811112615 A CN201811112615 A CN 201811112615A CN 109446267 A CN109446267 A CN 109446267A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- library
- strange land
- active
- 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.)
- Granted
Links
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/1458—Management of the backup or restore process
- G06F11/1464—Management of the backup or restore process for networked environments
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of based on 95598 strange land dual-active calamities for the inter-library data integrated system and method for model.Integrated system includes: data replication module, data integration module, power telecom network, data providing module.Realized in above system it is a kind of based on 95598 strange land dual-active calamities for the inter-library data integrating method of model, comprise the following processes: data duplication, data extract and data provide.The present invention effectively converts the integrated of strange land database to local data base and integrates, and ensure that the data consistency at dual-active center in integrating process, realizes that safely and effectively strange land calamity is standby.
Description
Technical field:
The present invention relates to intelligent customer service, further to it is a kind of based on 95598 strange land dual-active calamities for the inter-library data of model
Integrated system and method.
Background technique:
For 95598 electric service of national grid towards huge numbers of families, it is corporate image that service request is high, social effectiveness is big
The important window of displaying.Window department of the Customer Service Center as State Grid Corporation of China, it is the safety of information system, reliable
Property will be directly related to the social image of State Grid Corporation of China, the business continuance guarantee of especially 95598 core business systems
System Construction is particularly important.In conjunction with double/mostly living mature experience of a variety of applications of client service center's application characteristic and industry and advanced
Strange land dual-active mode is applied to 95598 customer service systems by case.It is standby to build 95598 strange land dual-active core business calamity of client service center
System is abnormal on the successional influence of whole business function by the single-point for reducing core business system to greatest extent；Disaster recovery and backup systems
After building up, Liang Ge data center will provide access service to south, north center and provinces and cities remote user respectively；When disaster occurs,
User's flowing of access of defect center can be all forwarded to the processing of another data center.Inter-library data integration is strange land dual-active
The core of disaster recovery and backup systems construction, database is securely and reliably very important one in entire strange land dual-active system Construction
Link.
Method commonly used in the prior art is using the master/slave data library of redundancy setting, when primary database breaks down
It is rapidly switched to standby database, to guarantee continuing working for system.But the master/slave data library of existing redundancy setting is all
With city, when local disaster accident occurs, meeting simultaneous faults in master/slave data library causes loss of data, brings to production and living
Extreme influence.And the difficult point of remote strange land dual-active is how will integrate with the strange land marketing data for saving as unit, is stored into
The public library of general headquarters, to meet the requirement of two centre data consistency.If two centre datas are inconsistent, disaster will be caused
End data is irrecoverable.
Summary of the invention:
The present invention is the above-mentioned deficiency in order to overcome the prior art, provides that can be realized strange land calamity standby, is guaranteed in dual-active
Heart data consistency it is a kind of based on 95598 strange land dual-active calamities for the inter-library data integrated system and clone method of model.Specifically
Technical solution is as follows:
It is a kind of based on 95598 strange land dual-active calamities for the inter-library data integrated system of model, comprising:
Data replication module, for by variations such as 27 province (city) Corporation system archives slowly and the high number of recycling degree
According to 27 that copy to general headquarters respectively corresponding inquiry libraries；
Data integration module, for by 27 Data Integrations of the inquiry library to Disaster Preparation Center's public library, including by 27 provinces
The process of customer profile information data unification；
Power telecom network is the medium of data duplication；
Data providing module is used for unified interface to 95598 calling service operational support systems, 95598 intelligent interactions
The operation systems such as power grid and 955988 unified calling access platforms provide uniform data service.
Preferably, above-mentioned data replication module includes:
Application database is present in 95598 system of each province (city), belongs to for storing the marketing data of each province (city) 95598
In strange land library；
Data replicate software module, are OGG (Oracle Golden Gate) application layer asynchronous logic duplication software；
Data replicate source, for the source data of storage replication software, including tissue numeric field data, client's numeric field data, clothes
Business numeric field data, power grid numeric field data, marketing equipment numeric field data, support numeric field data and common data；Organizational domains storage saves code, power supply list
Bit number and title, higher level provide unit number and categorical data；Client domain stores client, stoichiometric point and power utility check archives
Information data；Service the data that numeric field data storage power utility check business, electricity customer service center Added Management and industry expand packaging record；
Power grid domain stores the data of transformer, substation and its route relationship, platform area, route and route platform cell relation；Marketing device Domain
Store the data of mutual inductor, decompression instrument marketing equipment；Supporting domain store code information and code classification data；It deposits in common data domain
Store up Unicode information and Unicode classification data；
Data replicate target side, and for the target end data of storage replication software, data type and data replicate software
Source is consistent.
As further preferred scheme, above-mentioned data integration module includes:
Inquire database module, ETL software module and public database；
The inquiry database module is present in general headquarters for storing the marketing data of collect 27 provinces (city)
System；
The ETL software module is tool of the data from inquiry centralized database to public database；
The public database, for storing the data according to unified data model after integrated.
A kind of inter-library data copy method based on 95598 strange land dual-active calamities for model realized in above system, packet
Include following process:
Step 1: constructing data preparation area by client service center's inquiry library standard data model；
Step 2: by marketing data conversion and real-time synchronization is to data preparation area；
Step 3: opening province (city) marketing firewall data duplication related port；
Step 4: opening client service center's test equipment area firewall data duplication related port；
Step 5: using dmp file initial interrogation library derived from data preparation area database, and starting the duplication of OGG data
Process.
A kind of inter-library data copy method based on 95598 strange land dual-active calamities for model realized in above system, institute
Step 5 is stated to comprise the following processes:
Step 5.1: reading Online Redo in data duplication source using capture process (Capture Process)
Log or Archive Log, is then parsed, and the variation for only extracting wherein data such as increases, deletes, changes operation, and by relevant information
The customized intermediate form of GoldenGate TDM is converted to be stored in queue file；
Step 5.2: queue file being transmitted to goal systems by TCP/IP using transmission process；Capture process is each
It runs through the data variation in log and after data transmission to goal systems, can write a self-criticism a little, record the current log for completing to capture
Position, the presence of checkpoint can make capture process that can continue to replicate from checkpoint location after suspension and recovery；
Step 5.3: goal systems receives data variation and is cached in GoldenGate TDM queue, and queue is a system
The file for arranging interim storing data variation, waits delivery process to read data；
Step 5.4:GoldenGate delivers process and reads data variation from queue and create corresponding SQL statement, leads to
The local interface for crossing database executes, and is submitted to the checkpoint that oneself is updated after database succeeds, and record has completed duplication
The reproduction process of position, data is finally completed.
A kind of inter-library data integration side based on 95598 strange land dual-active calamities for model realized on above-mentioned clone method
Method, including following subsequent process:
Data integration is using ETL tool, by 27 Data Integrations of the inquiry library to Disaster Preparation Center's public library, including by 27
The process of the customer profile information data unification of province.ETL be data pick-up, conversion and loading (Extraction,
Transformation, Loading) English abbreviation.
ETL data integration process includes: data pick-up；Data pick-up refers to reads data from original operation system
Out, original service system here refers to inquiry database, and extraction mode selects full dose to extract, and extracts complete in inquiry database
Portion's data, are loaded into public database；Strange land province (city) marketing system application database is integrated into the public of general headquarters' system
After database, it can be connect according to the unified calling in 95598 calling service operational support systems, 95598 intelligent interaction power grids and 955988
The business for entering the operation systems such as platform needs to provide unified data service；Data load imports the data converted according to plan
Into data warehouse, any one following mode may be selected:
Method one: direct SQL statement is operated；
Method two: it is loaded using the distinctive loading tool batch of relational database.
As the preferred embodiment of integrated approach, above-mentioned integrated approach further includes subsequent consistency verification of data process:
Step 21: pause oracle database duplicating process, so that oracle database submits all affairs；
Step 22: obtaining the timestamp information SCN of data copy source client database；
Step 23: after inquiry data replicate target client database and obtain current time stamp information SCN, restarting pause
It is synchronous to restore oracle database for oracle database duplicating process；
Step 24: in the timestamp information SCN phase one of data copy source client database and data duplication target client database
In the case where cause, then consistency verification of data is done to corresponding table.
From the above it can be seen that it is provided by the invention it is a kind of based on 95598 strange land dual-active calamities for the inter-library number of model
Integrated system and clone method replicate software according to unified data model for the marketing number of 27 provinces (city) in strange land by OGG
According to local total system is copied to, corresponding inquiry database is constituted, using ETL Integrated Simulation to public database, externally to mention
For unified data service.Integrated by strange land database is effectively converted into local data base and integrates, and ensure that and integrated
The data consistency at dual-active center in journey realizes that safely and effectively strange land calamity is standby.
Detailed description of the invention:
Fig. 1 is for the inter-library data integrated system schematic diagram based on 95598 strange land dual-active calamities for model.
Specific embodiment:
Embodiment:
The present invention is further illustrated with reference to the accompanying drawings and detailed description, but is not intended as limiting the present invention
The foundation of system.
As shown in Figure 1, it is of the invention it is a kind of based on 95598 strange land dual-active calamities for the inter-library data integrated system of model, packet
It includes:
Data replication module, for by variations such as 27 province (city) Corporation system archives slowly and the high number of recycling degree
According to 27 that copy to general headquarters respectively corresponding inquiry libraries；
Data integration module, for by 27 Data Integrations of the inquiry library to Disaster Preparation Center's public library, including by 27 provinces
The process of customer profile information data unification；
Power telecom network is the medium of data duplication；
Data providing module is used for unified interface to 95598 calling service operational support systems, 95598 intelligent interactions
The operation systems such as power grid and 955988 unified calling access platforms provide uniform data service.
Above-mentioned data replication module includes: application database, for storing the marketing data of each province (city) 95598, is existed
In each province (city) 95598 system, belong to strange land library；Data replicate software module, are OGG (Oracle Golden Gate) applications
Layer asynchronous logic replicates software；Data replicate source, for the source data of storage replication software, including tissue numeric field data, visitor
Family numeric field data, service numeric field data, power grid numeric field data, marketing equipment numeric field data, support numeric field data and common data；Organizational domains storage
It saves code, power supply unit number and title, higher level and provides unit number and categorical data；Client domain stores client, stoichiometric point and use
The information data that electric-examination is consulted the files；It services numeric field data storage power utility check business, electricity customer service center Added Management and industry and expands packet
Fill the data of record；Power grid domain stores the number of transformer, substation and its route relationship, platform area, route and route platform cell relation
According to；Device Domain of marketing stores the data of mutual inductor, decompression instrument marketing equipment；Supporting domain store code information and code classification number
According to；Common data domain stores Unicode information and Unicode classification data；Data replicate target side, soft for storage replication
The target end data of part, data type are consistent with data duplication software source.
Above-mentioned data integration module includes: inquiry database module, ETL software module and public database；It is described to look into
It askes database module and is present in general headquarters' system for storing the marketing data of collect 27 provinces (city)；The ETL is soft
Part module is tool of the data from inquiry centralized database to public database；The public database, for storing according to system
Data after one data model is integrated.
A kind of inter-library data integrating method based on 95598 strange land dual-active calamities for model realized in above system, packet
Include following process: data duplication, data are extracted and data provide.
The data duplication is strange land application database according to unified data model, and building duplication software source end data is multiple
The data field of source processed includes: organizational domains, client domain, service-domain, power grid domain, marketing device Domain, supporting domain, common data；Mesh
The data field at mark end is consistent with source；Software, which is replicated, by OGG copies to target side；Data reproduction process, is described as follows:
Step 1: constructing data preparation area by client service center's inquiry library standard data model；
Step 2: by marketing data conversion and real-time synchronization is to data preparation area；
Step 3: opening province (city) marketing firewall data duplication related port；
Step 4: opening client service center's test equipment area firewall data duplication related port；
Step 5: using dmp file initial interrogation library derived from data preparation area database, and starting the duplication of OGG data
Process.
Data duplicating process in step 5 is as follows:
Step 5.1: using capture process (Capture Process) source system end read Online Redo Log or
Archive Log, is then parsed, and the variation for only extracting wherein data such as increases, deletes, changing operation, and relevant information is converted
It is stored in queue file for the customized intermediate form of GoldenGate TDM；
Step 5.2: queue file being transmitted to goal systems by TCP/IP using transmission process.Capture process is each
It runs through the data variation in log and after data transmission to goal systems, can write a self-criticism a little, record the current log for completing to capture
Position, the presence of checkpoint can make capture process that can continue to replicate from checkpoint location after suspension and recovery；
Step 5.3: goal systems receives data variation and is cached in GoldenGate TDM queue, and queue is a system
The file for arranging interim storing data variation, waits delivery process to read data；
Step 5.4:GoldenGate delivers process and reads data variation from queue and create corresponding SQL statement, leads to
The local interface for crossing database executes, and is submitted to the checkpoint that oneself is updated after database succeeds, and record has completed duplication
The reproduction process of position, data is finally completed.
Data integration is using ETL tool, by 27 Data Integrations of the inquiry library to Disaster Preparation Center's public library, including by 27
The process of the customer profile information data unification of province；ETL be data pick-up, conversion and loading (Extraction,
Transformation, Loading) English abbreviation；ETL data integration process can be divided into three steps: data pick-up, conversion
With cleaning, load；Wherein, data conversion is not directed in 95598 strange land dual-active disaster recovery and backup systems with cleaning.Data pick-up refers to
Data are read out from original operation system, original service system here refers to inquiry database, and extraction mode selects
Full dose extracts, and extracts the total data in inquiry database, is loaded into public database；Data load the data that will be converted
It imported into data warehouse according to plan, any one following mode may be selected:
Method one: direct SQL statement is operated；
Method two: it is loaded using the distinctive loading tool batch of relational database.
It, can basis after strange land province (city) marketing system application database is integrated into the public database of general headquarters' system
The operation systems such as the unified calling access platform in 95598 calling service operational support systems, 95598 intelligent interaction power grids and 955988
Business need to provide unified data service.
During inter-library data integration, Mongodb daily record data, Oracle relational data and unstructured data etc.
There are time differences for the independent asynchronous replication of a variety of data, this will will lead to the inconsistent problem of system data, it is also necessary to use
Targetedly strategy solves system data consistency problem.Steps are as follows for the data consistency verification method used herein:
Step 21: pause oracle database duplicating process, so that oracle database submits all affairs；
Step 22: obtaining the timestamp information SCN of source database；
Step 23: after inquiring target client database and obtaining current time stamp information SCN, restarting the Oracle data of pause
It is synchronous to restore oracle database for library duplicating process；
Step 24: in the case where source database is consistent with the timestamp information SCN of target client database, then to right
Table is answered to do consistency verification of data.
It should be understood by those ordinary skilled in the art that: the discussion of any of the above embodiment is exemplary only, not
It is intended to imply that the scope of the present disclosure (including claim) is limited to these examples；Under thinking of the invention, above embodiments
Or it can also be combined between the technical characteristic in different embodiments, and there are different aspects present invention as described above
Many other variations, in order to it is concise they do not provided in details.Therefore, all within the spirits and principles of the present invention,
Any omission, modification, equivalent replacement, improvement for being made etc., should all be included in the protection scope of the present invention.
The embodiment of the present invention be intended to cover fall into all such replacements within the broad range of appended claims,
Modifications and variations.Therefore, all within the spirits and principles of the present invention, any omission, modification, equivalent replacement, the improvement made
Deng should all be included in the protection scope of the present invention.
Claims (7)
1. it is a kind of based on 95598 strange land dual-active calamities for the inter-library data integrated system of model characterized by comprising
Data replication module corresponding is looked into for 27 province (city) Corporation system file datas to be copied to 27 of general headquarters respectively
Ask library；
Data integration module, for by 27 Data Integrations of the inquiry library to Disaster Preparation Center's public library；
Power telecom network is the medium of data duplication；
Data providing module is used for unified interface to 95598 calling service operational support systems, 95598 intelligent interaction power grids
Uniform data service is provided with operation systems such as 955988 unified calling access platforms.
2. it is according to claim 1 it is a kind of based on 95598 strange land dual-active calamities for the inter-library data integrated system of model, it is special
Sign is that the data replication module includes:
Application database is present in 95598 system of each province (city), belongs to different for storing the marketing data of each province (city) 95598
Ground library；
Data replicate software module, are OGG (Oracle Golden Gate) application layer asynchronous logic duplication software；
Data replicate source, for the source data of storage replication software, including tissue numeric field data, client's numeric field data, service-domain
Data, power grid numeric field data, marketing equipment numeric field data, support numeric field data and common data；Organizational domains storage saves code, power supply unit is compiled
Number and title, higher level provide unit number and categorical data；Client domain stores the information of client, stoichiometric point and power utility check archives
Data；Service the data that numeric field data storage power utility check business, electricity customer service center Added Management and industry expand packaging record；Power grid
Domain stores the data of transformer, substation and its route relationship, platform area, route and route platform cell relation；Device Domain of marketing stores
The data of mutual inductor, decompression instrument marketing equipment；Supporting domain store code information and code classification data；Common data domain storage system
One code information and Unicode classification data；
Data replicate target side, and for the target end data of storage replication software, data type and data replicate software source
Unanimously.
3. system according to claim 2, which is characterized in that the data integration module includes:
Inquire database module, ETL software module and public database；
The inquiry database module is present in general headquarters' system for storing the marketing data of collect 27 provinces (city)；
The ETL software module is tool of the data from inquiry centralized database to public database；
The public database, for storing the data according to unified data model after integrated.
4. a kind of inter-library data duplication based on 95598 strange land dual-active calamities for model realized in the system described in claim 3
Method, which is characterized in that comprise the following processes:
Step 1: constructing data preparation area by client service center's inquiry library standard data model；
Step 2: by marketing data conversion and real-time synchronization is to data preparation area；
Step 3: opening province (city) marketing firewall data duplication related port；
Step 4: opening client service center's test equipment area firewall data duplication related port；
Step 5: using dmp file initial interrogation library derived from data preparation area database, and starting OGG data and be copied into
Journey.
5. a kind of inter-library data duplication based on 95598 strange land dual-active calamities for model realized in the system described in claim 4
Method, which is characterized in that the step 5 comprises the following processes:
Step 5.1: using capture process (Capture Process) data duplication source read Online Redo Log or
Archive Log, is then parsed, and the variation for only extracting wherein data such as increases, deletes, changing operation, and relevant information is converted
It is stored in queue file for the customized intermediate form of GoldenGate TDM；
Step 5.2: queue file being transmitted to goal systems by TCP/IP using transmission process；Capture process is being run through every time
Data variation in log and after data transmission to goal systems, can write a self-criticism a little, record the current position log for completing to capture,
The presence of checkpoint can make capture process that can continue to replicate from checkpoint location after suspension and recovery；
Step 5.3: goal systems receives data variation and is cached in GoldenGate TDM queue, and queue is a series of faces
When storing data variation file, wait delivery process read data；
Step 5.4:GoldenGate delivers process and reads data variation from queue and create corresponding SQL statement, passes through number
It being executed according to the local interface in library, is submitted to the checkpoint for updating oneself after database succeeds, record has completed the position of duplication,
The reproduction process of data is finally completed.
6. a kind of inter-library data based on 95598 strange land dual-active calamities for model realized on the clone method described in claim 5
Integrated approach, including following subsequent process:
Data integration is using ETL tool, by 27 Data Integrations of the inquiry library to Disaster Preparation Center's public library, including by 27 provinces
The process of customer profile information data unification；It is specific as follows:
Data pick-up；Data pick-up refers to reads out data from original operation system, original service system here
Refer to inquiry database, extraction mode selects full dose to extract, and extracts the total data in inquiry database, is loaded into public database
In；It, can be according to 95598 callings after strange land province (city) marketing system application database is integrated into the public database of general headquarters' system
Service business supports the business of the operation systems such as system, 95598 intelligent interaction power grids and 955988 unified calling access platforms to need
Unified data service is provided；The data converted are imported into data warehouse by data load according to plan, may be selected following
Any one mode:
Method one: direct SQL statement is operated；
Method two: it is loaded using the distinctive loading tool batch of relational database.
7. a kind of inter-library data integrating method based on 95598 strange land dual-active calamities for model according to claim 6, feature
It is, further includes subsequent consistency verification of data process:
Step 21: pause oracle database duplicating process, so that oracle database submits all affairs；
Step 22: obtaining the timestamp information SCN of data copy source client database；
Step 23: after inquiry data replicate target client database and obtain current time stamp information SCN, restarting the Oracle of pause
It is synchronous to restore oracle database for database duplicating process；
Step 24: consistent with the data duplication timestamp information SCN of target client database in data copy source client database
In the case of, then consistency verification of data is done to corresponding table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811112615.8A CN109446267B (en) | 2018-09-25 | 2018-09-25 | Cross-database data integration system and method based on 95598 ex-situ double-active disaster recovery model |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811112615.8A CN109446267B (en) | 2018-09-25 | 2018-09-25 | Cross-database data integration system and method based on 95598 ex-situ double-active disaster recovery model |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109446267A true CN109446267A (en) | 2019-03-08 |
| CN109446267B CN109446267B (en) | 2023-06-02 |
Family
ID=65533146
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811112615.8A Active CN109446267B (en) | 2018-09-25 | 2018-09-25 | Cross-database data integration system and method based on 95598 ex-situ double-active disaster recovery model |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109446267B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109960613A (en) * | 2019-03-11 | 2019-07-02 | 中国银联股份有限公司 | A kind of method and device of data batch processing |
| CN110309128A (en) * | 2019-07-05 | 2019-10-08 | 广东铭太信息科技有限公司 | Oracle backup file automatic leading-in device and its implementation, the method that the importing of backup file is carried out using the device |
| CN113190536A (en) * | 2021-03-02 | 2021-07-30 | 上海英方软件股份有限公司 | Rapid repair method and device for double-active database management replication system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130066955A1 (en) * | 2011-09-09 | 2013-03-14 | Kevin S. Neel | Masking database outages from clients and applications |
| CN104346454A (en) * | 2014-10-30 | 2015-02-11 | 上海新炬网络技术有限公司 | Data consistency verification method based on Oracle database |
| CN104573056A (en) * | 2015-01-22 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | Database large data volume online migration method based on oracle |
| CN106339509A (en) * | 2016-10-26 | 2017-01-18 | 国网山东省电力公司临沂供电公司 | Power grid operation data sharing system based on large data technology |
| WO2017177769A1 (en) * | 2016-04-11 | 2017-10-19 | 平安科技（深圳）有限公司 | Ogg version deployment method and system, server, and storage medium |
-
2018
- 2018-09-25 CN CN201811112615.8A patent/CN109446267B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130066955A1 (en) * | 2011-09-09 | 2013-03-14 | Kevin S. Neel | Masking database outages from clients and applications |
| CN104346454A (en) * | 2014-10-30 | 2015-02-11 | 上海新炬网络技术有限公司 | Data consistency verification method based on Oracle database |
| CN104573056A (en) * | 2015-01-22 | 2015-04-29 | 浪潮电子信息产业股份有限公司 | Database large data volume online migration method based on oracle |
| WO2017177769A1 (en) * | 2016-04-11 | 2017-10-19 | 平安科技（深圳）有限公司 | Ogg version deployment method and system, server, and storage medium |
| CN106339509A (en) * | 2016-10-26 | 2017-01-18 | 国网山东省电力公司临沂供电公司 | Power grid operation data sharing system based on large data technology |
Non-Patent Citations (3)
| Title |
|---|
| 常永娟等: "基于ORACLE GoldenGate技术的营销基础数据平台应用探究", 《大众用电》 * |
| 张文超: "基于Oracle数据库的灾备方法与应用研究", 《中国优秀硕士学位论文全文数据库信息科技辑》 * |
| 费冬虎等: "海量数据管理平台统一接入访问工具的设计与实现", 《上海电力学院学报》 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109960613A (en) * | 2019-03-11 | 2019-07-02 | 中国银联股份有限公司 | A kind of method and device of data batch processing |
| CN109960613B (en) * | 2019-03-11 | 2023-05-12 | 中国银联股份有限公司 | Data batch processing method and device |
| CN110309128A (en) * | 2019-07-05 | 2019-10-08 | 广东铭太信息科技有限公司 | Oracle backup file automatic leading-in device and its implementation, the method that the importing of backup file is carried out using the device |
| CN110309128B (en) * | 2019-07-05 | 2020-07-17 | 广东铭太信息科技有限公司 | Oracle backup file automatic importing device, implementation method thereof and method for importing backup file by using device |
| CN113190536A (en) * | 2021-03-02 | 2021-07-30 | 上海英方软件股份有限公司 | Rapid repair method and device for double-active database management replication system |
| CN113190536B (en) * | 2021-03-02 | 2023-01-17 | 上海英方软件股份有限公司 | Rapid repair method and device for double-active database management replication system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109446267B (en) | 2023-06-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103198159B (en) | A kind of many copy consistency maintaining methods of isomeric group reformed based on affairs | |
| CN109446267A (en) | It is a kind of based on 95598 strange land dual-active calamities for the inter-library data integrated system and method for model | |
| CN109284346A (en) | A kind of distribution network planning method and device based on cloud computing | |
| CN101937435B (en) | Online synchronized method of distributed real-time database confronting power system | |
| CN104318481A (en) | Power-grid-operation-oriented holographic time scale measurement data extraction conversion method | |
| CN108446396B (en) | Power data processing method based on improved CIM model | |
| CN105843702A (en) | Method and device for data backup | |
| CN108763234A (en) | A kind of real time data synchronization method and system | |
| CN109933416A (en) | A kind of moving method, device and storage medium using data | |
| CN108206522B (en) | Power equipment state monitoring method and system | |
| CN104699760A (en) | Data synchronization method used for heterogeneous system and based on safety isolation | |
| CN102495916A (en) | Multi-application-system panoramic modeling method based on object matching | |
| CN106599293A (en) | CIM XML power grid model used for integrated dispatching and distribution system | |
| CN106202149A (en) | A kind of IEC61850 model file conversion method | |
| CN105787090A (en) | Index building method and system of OLAP system of electric data | |
| CN111078951A (en) | Power graph model data management system and method | |
| CN108876445A (en) | A kind of data interoperation application based on battalion's distribution end-equipment common information model | |
| WO2019056564A1 (en) | Power distribution network fault repair system data sharing method for information exchange bus based on iec 61968 standards | |
| CN116073381A (en) | Automatic equipment point distribution decision method considering reliability of power distribution network | |
| CN110008198B (en) | Database structure and dispatching automation system | |
| CN109271350A (en) | A kind of database and information point table automatic comparison and synchronous method based on telemechanical communication | |
| CN106649419A (en) | Electricity information acquisition system-based cross-platform database data migration method | |
| Jiang | Investigation on the construction of urban intelligent emergency management system based on data mining technology | |
| CN201868874U (en) | Automatic PI measuring point maintenance system for power system | |
| CN107729462B (en) | Method and system for updating work log table |
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 |