CN106933697A - A kind of hardware based real-time data base backup scenario - Google Patents
A kind of hardware based real-time data base backup scenario Download PDFInfo
- Publication number
- CN106933697A CN106933697A CN201511015422.7A CN201511015422A CN106933697A CN 106933697 A CN106933697 A CN 106933697A CN 201511015422 A CN201511015422 A CN 201511015422A CN 106933697 A CN106933697 A CN 106933697A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- heterogeneous
- ult
- atl
- 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
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/1456—Hardware arrangements for backup
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1448—Management of the data involved in backup or backup restore
- G06F11/1451—Management of the data involved in backup or backup restore by selection of backup contents
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of hardware based real-time data base backup scenario, it is related to technical field of data transmission, is concentrated by information, effectively utilize and use existing information, reduces information island.The data transmission method includes：ATL transparent gateways, LLT restart monitoring, ULT Stubs.By similar to " robot dog " hardware, automatically incremental data is extracted from different heterogeneous databases, data are stored so as to realize the back-up job of isomeric data on specified storage medium in XML file stream mode after extraction, and system uses dedicated hardware processing data, improves data processing efficiency.Cleaned according to trigger condition and the heterogeneous system data being pre-configured with, collected, data are modeled with analysis with reference to data digging method.
Description
Technical field
The present invention relates to a kind of Database Backup Solution Program, the real-time standby of heterogeneous database is realized by proprietary hardware
Part.
Background technology
With the progressively in-depth of IT application in enterprise, joint demand is more and more urgent between information.Because preliminary project is built
If during do not consider information association problem, inter-system data is not planned, data structure Pang is looked into, type of database from
Access, MSSQL, MYSQL, ORACLE have.Being not easy to enterprise carries out data management.
Current existing database backup system technology is mainly the backup scenario of database manufacturer offer, can only be for single
Individual database or certain vendor database are backed up.Global backup can not be carried out, and with significant limitation：Technical staff couple
It is big in the manual back-up job intensity of a large amount of disparate databases, it is difficult to which that DB Backup is collected comprehensively；Database dispersion,
Multi-vendor data form is various, it is impossible to carry out united analysis；Data bulk is big, and data user rate is low, it is impossible to which formation is made a concerted effort, and is turned into
One by one " data silo ", decision-making level is difficult to be managed mass data；Test report checking is difficult, and feedback cycle is long, nothing
Method is to the direct verification of data.Therefore a kind of hardware based real-time data base backup scenario.Our weights urgently to be resolved hurrily are turned into
Want problem.Fall.
The content of the invention
It is an object of the invention to solve above-mentioned data backup work arrangement weak point, there is provided a kind of brand-new, directly perceived
A species XML format soft or hard combination backup scenario.In order to solve the above-mentioned technical problem, the present invention uses following technical side
Case is realized：
The present invention is based on three zones on hardware device：ATL transparent gateways, LLT restart monitoring, ULT Stubs.By similar to
" robot dog " hardware, extracts incremental data from different heterogeneous databases automatically, and data are stored in XML file stream mode after extraction
So as to realize the back-up job of isomeric data on to specified storage medium, system uses dedicated hardware processing data, improves data
Treatment efficiency.
Described ATL transparent gateways, it is characterized in that：System receives upper end server and issues dispatch command.Same isomeric data
Connection is set up in storehouse, extracts the data in heterogeneous database, is imported with file manifold formula.And in real time data are carried out with data form turn
Standard x ML file streams are turned to, file stream writes central database, do not do any preservation locally by ULT Stubs.Using chip
Control mode connects heterogeneous database and obtains isomerous database access authority, the program backup isomery number customized by chip
According to data in storehouse.So as to realize the connection and management of heterogeneous database.It is standby equivalent to PLSQL functions are reduced into fixed data
Part function, and burning program is specified into chip.The connection for having chip efficient process heterogeneous database is controlled.
Described LLT restarts monitoring, it is characterized in that：System monitors the heterogeneous database running status of access automatically, works as prison
There is unusual condition in the heterogeneous database of control, system sends alerting tone prompting user, and records current breakpoint, stops data backup
Work.Worked on after heterogeneous database recovers normally.The linker of database is cured to certain chip, by it regularly
Remove access heterogeneous Data Bases.Program enters alert status after the event such as cannot respond to, when within the unit interval repeatedly not
Recover, triggering alarm.And notify ATL transparent gateways.So as to realize that LLT restarts monitoring.
Described ULT Stubs, it is characterized in that：It is connected with central database, the XML data that ATL transparent gateways are obtained
Stream is written to central database and realizes data backup function.ULT is directly write the XML data stream of ATL by internal system bus
Enter to central database.The information such as data classification table name are directly defined by XML, and XML data is converted to central database by ULT
Script is directly operated to central database.
Brief description of the drawings
Fig. 1 is a kind of hardware based real-time data base backup scenario block diagram of the invention.
Fig. 1 is a kind of hardware based real-time data base backup scenario block diagram of the invention, as shown in figure 1, one kind is based on
A kind of real-time data base backup scenario block diagram of hardware, there is provided brand-new, backup of the intuitively soft or hard combination of a species XML format
Scheme.
Based on three zones on hardware device：ATL transparent gateways, LLT restart monitoring, ULT Stubs.By similar to
" robot dog " hardware, extracts incremental data from different heterogeneous databases automatically, and data are stored in XML file stream mode after extraction
So as to realize the back-up job of isomeric data on to specified storage medium, system uses dedicated hardware processing data, improves data
Treatment efficiency.It is of the invention to implement effectively to solve and be backed up for single database or certain vendor database.No
Global backup can be carried out, technical staff is big for the manual back-up job intensity of a large amount of disparate databases, it is difficult to standby to database
Part carries out the problem for collecting comprehensively；Alleviate database dispersion, multi-vendor data form it is various, it is impossible to carry out united analysis；Number
Data bulk is big, and data user rate is low, it is impossible to which formation is made a concerted effort, as " data silo " one by one so that decision-making level is difficult to magnanimity
The problems such as data are managed；Test report checking difficulty is overcome, feedback cycle is long, it is impossible to the direct verification of data, so that
For telecommunications provide a kind of backup scenario of brand-new, the intuitively soft or hard combination of a species XML format.
In the present embodiment, described utilization ATL transparent gateways, issue scheduling and refer to by system reception upper end server
Order.Set up with heterogeneous database and connected, extract the data in heterogeneous database, imported with file manifold formula.And in real time to data
Carry out data form and be converted into standard x ML file streams, file stream writes central database, do not appoint locally by ULT Stubs
What is preserved.Heterogeneous database is connected using chip controls mode and isomerous database access authority is obtained, is customized by chip
Program backup heterogeneous database in data.So as to realize the connection and management of heterogeneous database.It is simple equivalent to by PLSQL functions
Fixed data backup function is turned to, and burning program is specified into chip.There is the connection control of chip efficient process heterogeneous database
System.
Described LLT restarts monitoring, monitors the heterogeneous database running status of access automatically by system, different when what is monitored
There is unusual condition in structure database, system sends alerting tone prompting user, and records current breakpoint, stops data backup work.
Worked on after heterogeneous database recovers normally.The linker of database is cured to certain chip, is regularly gone to visit by it
Ask heterogeneous database.Program enters alert status after the event such as cannot respond to, when not recovering repeatedly within the unit interval,
Triggering alarm.And notify ATL transparent gateways.So as to realize that LLT restarts monitoring.
Described ULT Stubs, are connected by same central database, the XML data stream write-in that ATL transparent gateways are obtained
Data backup function is realized to central database.ULT passes through internal system bus, during the XML data stream of ATL is directly write to
Heart database.The information such as data classification table name are directly defined by XML, and XML data is converted to central database script language by ULT
Speech is directly operated to central database.
Presently preferred embodiments of the present invention is the foregoing is only, not for limiting practical range of the invention.Every foundation
The content of scope of the present invention patent makees any trickle amendment, equivalence changes and modification, belongs to claimed
In the range of.The claimed scope of the invention is by appending claims and its equivalent thereof.Paragraph.
Claims (4)
1. in a kind of hardware based real-time data base backup scenario, it is characterised in that：ATL transparent gateways, LLT restart monitoring,
ULT Stubs, by similar to " robot dog " hardware, incremental data being extracted from different heterogeneous databases automatically, number after extraction
XML file stream mode is stored on specified storage medium so as to realize the back-up job of isomeric data according to this.
2. ATL transparent gateways according to claims 1, it is characterised in that：System receives upper end server and issues scheduling
Instruction, sets up with heterogeneous database and connects, and extracts the data in heterogeneous database, is imported with file manifold formula, and logarithm in real time
Standard x ML file streams are converted into according to data form is carried out, file stream writes central database, do not do locally by ULT Stubs
Any preservation, connects heterogeneous database and obtains isomerous database access authority using chip controls mode, is customized by chip
Data in good program backup heterogeneous database, so as to realize the connection and management of heterogeneous database, equivalent to by PLSQL functions
Fixed data backup function is reduced to, and burning program is specified into chip, there is the connection of chip efficient process heterogeneous database
Control.
3. the LLT according to claims 1 restarts monitoring, it is characterised in that：System monitors the isomeric data of access automatically
Storehouse running status, when the heterogeneous database of monitoring occurs unusual condition, system sends alerting tone prompting user, and records current disconnected
Point, stops data backup work, is worked on after heterogeneous database recovers normally, and the linker of database is cured into spy
Determine chip, access heterogeneous Data Bases are regularly gone by it, program enters alert status after the event such as cannot respond to, when in list
Do not recover triggering alarm in the time of position repeatedly, and notify ATL transparent gateways, so as to realize that LLT restarts monitoring.
4. ULT Stubs according to claims 1, it is characterised in that：Described same central database is connected, ATL
The XML data stream that transparent gateway is obtained is written to central database and realizes data backup function, and ULT passes through internal system bus,
The XML data stream of ATL is directly write into the information such as central database, data classification table name directly to be defined by XML, ULT will
XML data is converted to central database script and directly central database is operated.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201511015422.7A CN106933697A (en) | 2015-12-31 | 2015-12-31 | A kind of hardware based real-time data base backup scenario |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201511015422.7A CN106933697A (en) | 2015-12-31 | 2015-12-31 | A kind of hardware based real-time data base backup scenario |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106933697A true CN106933697A (en) | 2017-07-07 |
Family
ID=59442090
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201511015422.7A Pending CN106933697A (en) | 2015-12-31 | 2015-12-31 | A kind of hardware based real-time data base backup scenario |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106933697A (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1445672A (en) * | 2002-03-14 | 2003-10-01 | 上海网上乐园信息技术有限公司 | System for backing up isomerous data in same network and its realization method |
| CN102630087A (en) * | 2012-02-24 | 2012-08-08 | 中兴通讯股份有限公司 | Heterogeneous processing method and apparatus thereof |
| WO2013189409A3 (en) * | 2013-03-22 | 2014-02-20 | 中兴通讯股份有限公司 | Service disaster recovery method and system |
-
2015
- 2015-12-31 CN CN201511015422.7A patent/CN106933697A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1445672A (en) * | 2002-03-14 | 2003-10-01 | 上海网上乐园信息技术有限公司 | System for backing up isomerous data in same network and its realization method |
| CN102630087A (en) * | 2012-02-24 | 2012-08-08 | 中兴通讯股份有限公司 | Heterogeneous processing method and apparatus thereof |
| WO2013189409A3 (en) * | 2013-03-22 | 2014-02-20 | 中兴通讯股份有限公司 | Service disaster recovery method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103595131B (en) | On-line monitoring system of transformer device of transformer substation | |
| CN110007913A (en) | Visual flow chart of data processing setting method, device, equipment and storage medium | |
| CN102857371B (en) | A kind of dynamic allocation management method towards group system | |
| CN107454140A (en) | A kind of Ceph cluster automatically dispose method and system based on big data platform | |
| CN103500475B (en) | A kind of adjustment method, system of office buildings gate control system | |
| CN111143167B (en) | Alarm merging method, device, equipment and storage medium for multiple platforms | |
| CN104836699A (en) | Equipment state processing method and equipment state processing system | |
| CN105245371A (en) | Automatic deployment system and method based on ansable | |
| CN103488793A (en) | User behavior monitoring method based on information retrieval | |
| CN113487277B (en) | Digital employee management system based on robot flow automation | |
| CN106815342A (en) | A kind of distributed file system user quota system and method | |
| CN105487971A (en) | Method and system for recording and reproducing operation steps in software testing | |
| CN104348653A (en) | Method and system for realizing user task of cloud management platform as well as trigger | |
| CN104065503A (en) | Discriminant analysis method for fault sourcing of facilities in intelligent traffic internet of things | |
| CN103778024A (en) | Server system and message processing method thereof | |
| CN114172921A (en) | Log auditing method and device for scheduling recording system | |
| CN113395185A (en) | Information technology management system | |
| CN113206867A (en) | Intelligent data acquisition monitoring system and method and timing acquisition service module | |
| CN101650678A (en) | Asynchronous replication method based on file operational semantics | |
| CN103366433B (en) | A kind of Real-Time Monitoring all-purpose card gate inhibition status method | |
| CN104123217A (en) | Capture method and system of execution instruction of service server | |
| CN106933697A (en) | A kind of hardware based real-time data base backup scenario | |
| CN106330567A (en) | Server management control method and server management control system for server cluster | |
| CN104394033B (en) | Monitoring system, method and device across data center | |
| CN202615555U (en) | Outdoor environment alarm system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| CB02 | Change of applicant information |
Address after: Software Park No. 89 Copper Road Software Avenue Gulou District of Fuzhou city in Fujian province 350001 F District No. 4 building 20, 21, 22 Applicant after: Incorporated company of middle Futong Address before: 350001, No. 19, No. 89, No. 19, software Avenue, Gulou District, Fuzhou, Fujian Applicant before: Incorporated company of middle Futong |
|
| CB02 | Change of applicant information | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: Software Park No. 89 Copper Road Software Avenue Gulou District of Fuzhou city in Fujian province 350001 F District No. 4 building 20, 21, 22 Applicant after: Zhongfutong Group Co., Ltd. Address before: Software Park No. 89 Copper Road Software Avenue Gulou District of Fuzhou city in Fujian province 350001 F District No. 4 building 20, 21, 22 Applicant before: Incorporated company of middle Futong |
|
| CB02 | Change of applicant information | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20170707 |
|
| WD01 | Invention patent application deemed withdrawn after publication |