Movatterモバイル変換


[0]ホーム

URL:


CN108255909A - Tables of data backup method and server based on oracle database - Google Patents

Tables of data backup method and server based on oracle database
Download PDF

Info

Publication number
CN108255909A
CN108255909ACN201710622205.7ACN201710622205ACN108255909ACN 108255909 ACN108255909 ACN 108255909ACN 201710622205 ACN201710622205 ACN 201710622205ACN 108255909 ACN108255909 ACN 108255909A
Authority
CN
China
Prior art keywords
data
target matrix
backup
tables
target
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
Application number
CN201710622205.7A
Other languages
Chinese (zh)
Other versions
CN108255909B (en
Inventor
唐敏
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Ping An Technology Shenzhen Co Ltd
Original Assignee
Ping An Technology Shenzhen Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Ping An Technology Shenzhen Co LtdfiledCriticalPing An Technology Shenzhen Co Ltd
Priority to CN201710622205.7ApriorityCriticalpatent/CN108255909B/en
Priority to PCT/CN2018/083299prioritypatent/WO2019019706A1/en
Publication of CN108255909ApublicationCriticalpatent/CN108255909A/en
Application grantedgrantedCritical
Publication of CN108255909BpublicationCriticalpatent/CN108255909B/en
Activelegal-statusCriticalCurrent
Anticipated expirationlegal-statusCritical

Links

Classifications

Landscapes

Abstract

The present invention is suitable for database processing technical field, provides tables of data backup method and server based on oracle database.This method includes:The Backup Data table identical with the table structure of target matrix is established, and access rights are set for the Backup Data table according to the target matrix;The target matrix is excel tables;Obtain the type of data in the target matrix;The type of data includes non real-time update the data and real-time update data in the target matrix;According to the type of data in the target matrix, the data to be backed up in the target matrix are backed up by the backup table tables of data.Above-mentioned tables of data backup method and server based on oracle database, the DBA personnel for not needing to profession handle and can do data backup to case of non-partitioned tables, can greatly improve the operating efficiency of data backup, enhance operability.

Description

Tables of data backup method and server based on oracle database
Technical field
The invention belongs to database processing technical field more particularly to the tables of data backup method based on oracle databaseAnd server.
Background technology
Sorts of systems can generate a large amount of data in use, such as customer order data, operation note daily record class numberAccording to results class data such as, attendance performance etc..With the increase of data volume, the inquiry velocity of system in use will be got overCome slower.Common practice is exactly that filing processing is done to historical data, and historical data is moved on to backup table.Exactly because also dataMeasure the excessive performance for influencing whether system, thus in the early stage design table structure when should just consider data filing problem.MostSimple common method is Database partition table to be stored, for example monthly do subregion, when doing data filing, will directly be gone throughHistory subregion removes partition table.Under normal conditions, it when storing data using partition table and data being carried out with filing processing, needsInterrupting service is handled, operability by professional DBA personnel (Database Administrator, database administrator)It is poor, operating efficiency is relatively low.
Invention content
In view of this, an embodiment of the present invention provides tables of data backup method and server based on oracle database,To solve the problems, such as that, operating efficiency poor to the tables of data backup operability of database is low in the prior art.
The first aspect of the embodiment of the present invention provides a kind of tables of data backup method based on oracle database, packetIt includes:
The Backup Data table identical with the table structure of target matrix is established, and is described standby according to the target matrixPart tables of data setting access rights;The target matrix is excel tables;
Obtain the type of data in the target matrix;In the target matrix type of data include it is non real-time moreNew data and real-time update data;
It, will be in the target matrix by the backup table tables of data according to the type of data in the target matrixData to be backed up backed up.
Optionally, it is described according to the target data when data is non real-time update the data in the target matrixData to be backed up in the target matrix are carried out backup packet by the type of data in table by the backup table tables of dataIt includes:
Data to be backed up in the target matrix are gone in the Backup Data table;
Major key and index are established for the Backup Data table according to the target matrix;
The table name of Backup Data table after establishing major key and indexing is changed to the table name of the target matrix.
Optionally, it is described according to the target matrix when data are real-time update data in the target matrixData to be backed up in the target matrix are carried out backup by the backup table tables of data and included by the type of middle data:
Major key and index are established for the Backup Data table according to the target matrix;
The table name of the target matrix is modified, and the table name that major key and the Backup Data table after index will be establishedThe table name being changed to before the target matrix change;
Sequence of the data in target matrix according to the record time from back to front after table name is changed, goes to after renamingBackup Data table in.
Optionally, the data to be backed up by the target matrix, which are gone in the Backup Data table, is specially:
According to time or major key, the data to be backed up in the target matrix are gone into the Backup Data table in batchesIn.
Optionally, when data are real-time update data in the target matrix, the foundation and target matrixThe identical Backup Data table of table structure is specially:Foundation is identical with the table structure of target matrix to carry out subregion according to the timeBackup Data table, the Backup Data table include the first subregion, and the corresponding initial time of first subregion is current time;
The type according to data in the target matrix, by the backup table tables of data by the target dataData to be backed up in table carry out backup and include:
Major key and index are established for the Backup Data table according to the target matrix;
The table name of the target matrix is modified, and the table name that major key and the Backup Data table after index will be establishedThe table name being changed to before the target matrix change;
Target matrix after table name is changed is exchanged with first subregion, and by described first after preset timeSubregion removes the Backup Data table after table name change.
The second aspect of the embodiment of the present invention provides a kind of server,
The server includes memory, processor and is stored on the memory and can run on the processorComputer program, the processor realizes following steps when performing the computer program:
The Backup Data table identical with the table structure of target matrix is established, and is described standby according to the target matrixPart tables of data setting access rights;The target matrix is excel tables;
Obtain the type of data in the target matrix;In the target matrix type of data include it is non real-time moreNew data and real-time update data;
It, will be in the target matrix by the backup table tables of data according to the type of data in the target matrixData to be backed up backed up.
Optionally, it is described according to the target data when data is non real-time update the data in the target matrixData to be backed up in the target matrix are carried out backup packet by the type of data in table by the backup table tables of dataIt includes:
Data to be backed up in the target matrix are gone in the Backup Data table;
Major key and index are established for the Backup Data table according to the target matrix;
The table name of Backup Data table after establishing major key and indexing is changed to the table name of the target matrix.
Optionally, it is described according to the target matrix when data are real-time update data in the target matrixData to be backed up in the target matrix are carried out backup by the backup table tables of data and included by the type of middle data:
Major key and index are established for the Backup Data table according to the target matrix;
The table name of the target matrix is modified, and the table name that major key and the Backup Data table after index will be establishedThe table name being changed to before the target matrix change;
Sequence of the data in target matrix according to the record time from back to front after table name is changed, goes to after renamingBackup Data table in.
Optionally, when data are real-time update data in the target matrix, the foundation and target matrixThe identical Backup Data table of table structure is specially:Foundation is identical with the table structure of target matrix to carry out subregion according to the timeBackup Data table, the Backup Data table include the first subregion, and the corresponding initial time of first subregion is current time;
The type according to data in the target matrix, by the backup table tables of data by the target dataData to be backed up in table carry out backup and include:
Major key and index are established for the Backup Data table according to the target matrix;
The table name of the target matrix is modified, and the table name that major key and the Backup Data table after index will be establishedThe table name being changed to before the target matrix change;
Target matrix after table name is changed is exchanged with first subregion, and by described first after preset timeSubregion removes the Backup Data table after table name change.
The third aspect of the embodiment of the present invention provides a kind of computer readable storage medium, including described computer-readableStorage medium is stored with computer program, when the computer program is executed by processor realize it is aforementioned it is any as described in baseIn the tables of data backup method of oracle database the step of.
Existing advantageous effect is the embodiment of the present invention compared with prior art:The embodiment of the present invention, initially sets up and meshThe identical Backup Data table of the table structure of tables of data is marked, is then visited according to the target matrix for Backup Data table settingIt asks permission, further according to the type of data in the target matrix, the data to be backed up in the target matrix is carried out standbyPart, the DBA personnel for not needing to profession handle and can do data backup to case of non-partitioned tables, can greatly improve data backupOperating efficiency.
Description of the drawings
It to describe the technical solutions in the embodiments of the present invention more clearly, below will be to embodiment or description of the prior artNeeded in attached drawing be briefly described, it should be apparent that, the accompanying drawings in the following description be only the present invention someEmbodiment, for those of ordinary skill in the art, without having to pay creative labor, can also be according to theseAttached drawing obtains other attached drawings.
Fig. 1 is the flow chart for the tables of data backup method based on oracle database that the embodiment of the present invention one provides;
Fig. 2 is a kind of realization flow chart of step S103 in Fig. 1;
Fig. 3 is that the another of step S103 in Fig. 1 realizes flow chart;
Fig. 4 is that another of step S103 realizes flow chart in Fig. 1;
Fig. 5 is the schematic diagram of server provided by Embodiment 2 of the present invention;
Fig. 6 is the block diagram of program module provided by Embodiment 2 of the present invention.
Specific embodiment
In being described below, in order to illustrate rather than in order to limit, it is proposed that such as tool of particular system structure, technology etcBody details, to understand thoroughly the embodiment of the present invention.However, it will be clear to one skilled in the art that there is no these specificallyThe present invention can also be realized in the other embodiments of details.In other situations, it omits to well-known system, device, electricityRoad and the detailed description of method, in case unnecessary details interferes description of the invention.
In order to illustrate technical solutions according to the invention, illustrated below by specific embodiment.
Embodiment one
Fig. 1 shows the realization stream for the tables of data backup method based on oracle database that the embodiment of the present invention one providesJourney, details are as follows:
Step S101 establishes the Backup Data table identical with the table structure of target matrix, and according to the target dataTable sets access rights for the Backup Data table.
Wherein, target matrix is the tables of data backed up, can be excel tables, for example, based on OracleThe tables of data of database.The table structure of target matrix can be excel forms table structure, comprising corresponding code information withRealize corresponding function.In addition, according to the division of function, code information that the table structure of the tables of data of different function is includedIt is not quite similar.
In addition, the table structure of target matrix can also include the information such as number and field.Specifically, each table structure canWith comprising a number, which is the unique mark of corresponding table structure;The field that each table structure is included is according to design needCan there is certain relevance.
It is described to be specially to Backup Data table setting access rights according to the target matrix in this step:KnotThe access rights of the target matrix are closed, some user, certain is set according to actual needs to the Backup Data table establishedThe access rights of user.For example, the target matrix only allows specific user to access, then can to Backup Data table intoRow setting, also only allows specific user to access, to prevent leaking data.
Step S102 obtains the type of data in the target matrix.
Wherein, the type of data can include non real-time update the data and real-time update data in the target matrix.Wherein, it is non real-time update the data refer to will not real-time update or change data, such as attendance data, performance data and all kinds of remittancesTotal data etc..Not real-time update is updated the data due to non real-time, is calculated simply by specific time, such as every nightOr monthly the end of month calculate after generate, therefore non real-time update the data only is needed that non-accountable time is selected to do and returnShelves, without the concern for the influence to business.Real-time update data refer to as operation log and certain synchronous middle table data are (sameCan update synchronous regimes fields after the completion of step) etc. can real-time update or change data.
Specifically, the type of data in identification target matrix, each data type mark can be identified by data typeKnowledge can correspond to a plurality of data.Under normal conditions, the data stored in a tables of data are a data type.
In one embodiment, the type for obtaining data in the target matrix can specifically include:
It pre-sets and non real-time updates the data corresponding with real-time update data data type mark;
Non real-time update the data or real-time update data is determined as according to data type mark in the target matrix.
Wherein, it is described according in the target matrix data type mark be determined as it is non real-time update the data or in real time moreNew data is specifically as follows:
It is identified according to the data type of every data and determines that the data update the data or real-time update data to be non real-time;Or
According to the corresponding data type mark of each tables of data, determine that the data in the tables of data are updated the data to be non real-timeOr real-time update data.
Step S103, according to the type of data in the target matrix, by the backup table tables of data by the meshData to be backed up in mark tables of data are backed up.
In this step, non real-time update the data is needed to take different processing procedures with real-time update data, with rightData to be backed up in the target matrix are backed up.
Referring to Fig. 2, when data is non real-time update the data in the target matrix, step S103 can specifically pass throughProcedure below is realized:
Step S201 goes to the data to be backed up in the target matrix in the Backup Data table.
Wherein, the data to be backed up by the target matrix, which are gone in the Backup Data table, is specially:RootAccording to time or major key, the data to be backed up in the target matrix are gone in batches in the Backup Data table.It is for example, rightThe historical data of 3 months or more does filing processing in target matrix, then can by the data in target matrix 3 months,It is inserted into batches in the Backup Data table by time or major key.
Step S202 establishes major key and index according to the target matrix for the Backup Data table.
Wherein, major key is the unique index (index) of tables of data, such as student Biao Li has student number and name, and name mayThere is duplication of name, but student number is really unique, as soon as a record is searched for from student's table as searched a people, it can only be according to student numberIt goes to search, this can just find out unique one.In another example in store complete machine and accessory in the database of some computer manufacturerProduct information, the table for preserving machine product information are called Pc tables (with reference to table), for preserve the table of accessory supply of material informationMake Parts tables (referenced table).To set external key, with reference to table (referencing table, i.e. Pc tables) and referenced tableIn (referenced table, i.e. parts tables), corresponding two fields must all set index.
In this step, after the data to be backed up in the target matrix are gone in the Backup Data table, needMajor key and index are established to the Backup Data table, so that the backup according to the major key and index in target matrixData in tables of data can normally be quoted according to the data relationship in the target matrix.
The table name of Backup Data table after establishing major key and indexing is changed to the table of the target matrix by step S203Name.
Wherein, the data to be backed up in the target matrix are gone in the Backup Data table, and according to the meshAfter mark tables of data establishes major key and index for the Backup Data table, except the table name for removing tables of data, the Backup DataTable is identical with the table structure and data information of the target matrix.At this point, after major key and index will be establishedThe table name of Backup Data table is changed to the table name of the target matrix, then can complete to back up the target matrixProcess.
By the target matrix for for attendance data table, it is assumed that be to the history number of attendance data table 3 months or moreAccording to filing processing is done, realize that process is as follows:
The Backup Data table (table name B) of one and the identical table structure of attendance data table (table name A) is created, and is examinedDiligent tables of data A carries out tax power to Backup Data table B, to realize that Backup Data table B, inquiry backup can be accessed by limiting certain certain customersData in tables of data B;
By the data in attendance data Table A in 3 months, it is inserted into batches in Backup Data table B by time or major key,Since attendance data Table A updates the data table to be non real-time, can backup be directly inserted by time or major key in batchesIn tables of data B, and without considering the problems of time order and function;
Major key, index etc. are established with reference to attendance data Table A table on Backup Data table B, so that in Backup Data table BData can be quoted correctly;
The table name of attendance data Table A is renamed as tables of data C, then the table name of Backup Data table B is renamed as Table A, you canTo complete the process backed up to the data in attendance data Table A.
Referring to Fig. 3, when data are real-time update data in the target matrix, step S103 specifically can by withLower process is realized:
Step S301 establishes major key and index according to the target matrix for the Backup Data table.
In this step, after the data to be backed up in the target matrix are gone in the Backup Data table, needMajor key and index are established to the Backup Data table, so that the backup according to the major key and index in target matrixData in tables of data can normally be quoted according to the data relationship in the target matrix.Specific explanations content can joinAccording to the related content in step S202, details are not described herein.
The table name of the target matrix is modified by step S302, and will establish major key and the backup number after indexThe table name before the target matrix change is changed to according to the table name of table.
Wherein it is possible to the operation of table name change is carried out by a new table name.For example, the table name of the target matrixFor Table A, the table name of the Backup Data table is table B, then can the table name of the target matrix be changed to table C, then willThe table name of Backup Data table is changed to Table A.
Step S303, sequence of the data in target matrix according to the record time from back to front after table name is changed,It goes in the Backup Data table after renaming.
Wherein, step S303 is specifically as follows:According to time or major key, by the data to be backed up in the target matrixIt goes in batches in the Backup Data table.For example, filing processing was done to the historical data of 3 months or more in target matrix,The data in target matrix 3 months can be then inserted by time or major key in the Backup Data table in batches.
If tables of data only has insertion operation, such as operation log, then this step does not need to interrupting service, the influence to businessWithin 1 second, almost it can be ignored.If tables of data has insertion update operation, such as certain synchronous middle table data are (synchronousSynchronous regime field can be updated after the completion), migrating data answers the new data of priority migration in step S303, and program is avoided to updateWhen report an error, to service impact about at several seconds or so, only need the processing that slightly compares to data after the completion of data filingInfluence is completely eliminated.
Optionally, it after step S303, further includes:According to data in the target matrix and the Backup Data tableIn data carry out data comparison processing, to prevent program from reporting an error when update.
By the target matrix for for operation log, it is assumed that be to the history of operation log tables of data 3 months or moreData do filing processing, realize that process is as follows:
The Backup Data table (table name B) of one and the identical table structure of operation log tables of data (table name A) is created, and is joinedIt examines operation log tables of data A and tax power is carried out to Backup Data table B, to realize that Backup Data table B can be accessed by limiting certain certain customers,Inquire the data in Backup Data table B;
Reference operation daily record data Table A table establishes major key, index etc. on Backup Data table B, so that Backup Data table BIn data can correctly be quoted;
The table name of operation log tables of data A is renamed as tables of data C, then the table name of Backup Data table B is renamed as Table A;
By the data in operation log tables of data C in 3 months, by time or major key, according to the record time after toPreceding sequence is inserted into batches in Backup Data Table A.
Further, when data are real-time update data in the target matrix, the foundation and target matrixThe identical Backup Data table of table structure be specially:It establishes identical with the table structure of target matrix according to time progress subregionBackup Data table, the Backup Data table includes the first subregion, and the corresponding initial time of first subregion is current time.For example, subregion is carried out to Backup Data table by the time, including subregion P1, subregion P2, subregion P3 etc., wherein, subregion P1 is corresponded toStart time be slightly sooner in time than current time, subregion P2, subregion P3 etc. can monthly subregion.For example, current time is May 15, thenThe corresponding start times of subregion P1 can be some day in 5 months, such as May 14.
Wherein, step S103 can specifically be realized by procedure below:
Step S401 establishes major key and index according to the target matrix for the Backup Data table.
In this step, after the data to be backed up in the target matrix are gone in the Backup Data table, needMajor key and index are established to the Backup Data table, so that the backup according to the major key and index in target matrixData in tables of data can normally be quoted according to the data relationship in the target matrix.Specific explanations content can joinAccording to the related content in step S202, details are not described herein.
The table name of the target matrix is modified by step S402, and will establish major key and the backup number after indexThe table name before the target matrix change is changed to according to the table name of table.
Wherein it is possible to the operation of table name change is carried out by a new table name.For example, the table name of the target matrixFor Table A, the table name of the Backup Data table is table B, then can the table name of the target matrix be changed to table C, then willThe table name of Backup Data table is changed to Table A.
Step S403, the target matrix after table name is changed exchange, and with first subregion after preset timeFirst subregion is removed into the Backup Data table after table name change.
Wherein it is possible to the friendship between target matrix and first subregion after realizing table name change is operated by sqlIt changes, such as sql:ALTER TABLE A EXCHANGE PATITION P1WITH TABLE C, i.e., by subregion P1 and number of targetsIt is exchanged according to the data of table C.After the preset time of data exchange is finished, the first subregion is removed into Backup Data table.
For example, the historical data to three months or more in target matrix does filing processing, and almost every in three monthsThe all possible real time modifying of a data, realizes that process is as follows:
Create the Backup Data table that subregion is carried out according to the time of one and the identical table structure of target matrix (table name A)(table name B), the subregion of Backup Data table B include subregion P1, subregion P2, subregion P3 etc., wherein, the corresponding starting points of subregion P1Time is earlier than current time;
Reference target tables of data A tables establish major key, index etc. on Backup Data table B, so that in Backup Data table BData can be quoted correctly;
The table name of target data Table A is renamed as tables of data C, then the table name of Backup Data table B is renamed as Table A;
Tables of data C is exchanged with the P1 subregions of tables of data A, detailed process sql:ALTER TABLE A EXCHANGEPATITION P1WITH TABLE C;
After data exchange is completed 3 months, subregion P1 is removed into tables of data A.
The above-mentioned tables of data backup method based on oracle database is initially set up identical with the table structure of target matrixBackup Data table, then according to the target matrix for the Backup Data table set access rights, further according to the meshThe type of data in tables of data is marked, the data to be backed up in the target matrix are backed up, does not need to the DBA people of professionMember, which carries out processing, to do data backup to case of non-partitioned tables, can greatly improve the operating efficiency of data backup.
It should be understood that the size of the serial number of each step is not meant to the priority of execution sequence, each process in above-described embodimentExecution sequence should determine that the implementation process without coping with the embodiment of the present invention forms any limit with its function and internal logicIt is fixed.
Embodiment two
Corresponding to the picture match method described in foregoing embodiments, Fig. 5 shows picture provided in an embodiment of the present inventionRunning environment schematic diagram with program.For convenience of description, part related to the present embodiment is illustrated only.
In the present embodiment, the computer program 500 is installed and is run in server 50.The server 50 can wrapIt includes, but is not limited only to, memory 501 and processor 502.Fig. 5 illustrates only the server 50 with component 501-502, stillIt should be understood that, it is not required that implement all components shown, the more or less component of the implementation that can be substituted.
The memory 501 can be the internal storage unit of the server 50 in some embodiments, such as the clothesThe hard disk or memory of business device 50.The memory 501 can also be that the outside of the server 50 is deposited in further embodimentsThe plug-in type hard disk being equipped in storage equipment, such as the server 50, intelligent memory card (Smart Media Card, SMC), peaceDigital (Secure Digital, SD) blocks, flash card (Flash Card) etc..Further, the memory 501 can be withBoth the internal storage unit of the server 50 had been included or including External memory equipment.The memory 501 is installed for storingIn the application software and Various types of data of the server 50, such as the program of the tables of data stand-by program based on oracle databaseCode etc..The memory 501 can be also used for temporarily storing the data that has exported or will export.
The processor 502 can be a central processing unit (Central Processing in some embodimentsUnit, CPU), microprocessor or other data processing chips, for run the program code that is stored in the memory 501 orData are handled, such as perform described tables of data stand-by program based on oracle database etc..
The component 501-502 of the server 50 is in communication with each other by system bus.
Referring to Fig. 6, it is the functional block diagram of computer program 500 provided in an embodiment of the present invention.In the present embodiment,The computer program 500 can be divided into one or more modules, and one or more of modules are stored in instituteIt states in memory 501, and performed by one or more processors (the present embodiment is the processor 502), to complete this hairIt is bright.For example, in figure 6, the picture match program 500 can be divided into that tables of data establishes module 601, data type obtainsModulus block 602 and backup module 603.The so-called module of the present invention is the series of computation machine program for referring to complete specific functionInstruction segment, than program more suitable for describing implementation procedure of the computer program 500 in the server 50.It is described belowThe function of the module 601-603 will specifically be introduced.
Wherein, tables of data establishes module 601, for establishing the Backup Data table identical with the table structure of target matrix,And access rights are set for the Backup Data table according to the target matrix.Wherein, the target matrix is excelTable.
Data type acquisition module 602, for obtaining the type of data in the target matrix.Wherein, the targetThe type of data includes non real-time update the data and real-time update data in tables of data.
Backup module 603, will by the backup table tables of data for the type according to data in the target matrixData to be backed up in the target matrix are backed up.
Optionally, when data is non real-time update the data in the target matrix, the backup module 603 can be byIt is divided into the first data transfer unit, first establishing unit and first is renamed unit.
First data transfer unit, for the data to be backed up in the target matrix to be gone to the Backup Data tableIn;
First establishing unit, for establishing major key and index for the Backup Data table according to the target matrix;
First renames unit, for the table name for establishing the Backup Data table after major key and index to be changed to the number of targetsAccording to the table name of table.
Optionally, when data are real-time update data in the target matrix, the backup module 603 can be dividedSecond is segmented into establish unit, second rename unit and the second data transfer unit.
Second establishes unit, for establishing major key and index for the Backup Data table according to the target matrix.
Second renames unit, for the table name of the target matrix to be modified, and after establishing major key and indexThe table name of Backup Data table be changed to the table name before target matrix change.
Second data transfer unit, for the data in the target matrix after table name is changed according to the record time by rearSequence before arriving is gone in the Backup Data table after renaming.
Optionally, first data transfer unit or the second data transfer unit are specifically used for:According to time or major key,Data to be backed up in the target matrix are gone in batches in the Backup Data table.
Optionally, when data are real-time update data in the target matrix, the foundation and target matrixThe identical Backup Data table of table structure is specially:Foundation is identical with the table structure of target matrix to carry out subregion according to the timeBackup Data table, the Backup Data table include the first subregion, and the corresponding initial time of first subregion is current time.InstituteStating backup module 603 can be divided into that third establishes unit, third is renamed unit and third backup units.
Third establishes unit, and major key and index are established for the Backup Data table according to the target matrix.
Third is renamed unit, and the table name of the target matrix is modified, and will be established standby after major key and indexThe table name of part tables of data is changed to the table name before the target matrix change.
Third backup units, the target matrix after table name is changed are exchanged with first subregion, and when defaultBetween after by first subregion remove table name change after Backup Data table.
It is apparent to those skilled in the art that for convenience of description and succinctly, only with above-mentioned each work(Can unit, module division progress for example, in practical application, can be as needed and by above-mentioned function distribution by differentFunctional unit, module are completed, i.e., the internal structure of described device are divided into different functional units or module, more than completionThe all or part of function of description.Each functional unit, module in embodiment can be integrated in a processing unit, also may be usedTo be that each unit is individually physically present, can also two or more units integrate in a unit, it is above-mentioned integratedThe form that hardware had both may be used in unit is realized, can also be realized in the form of SFU software functional unit.In addition, each function listMember, the specific name of module are not limited to the protection domain of the application also only to facilitate mutually distinguish.Above systemThe specific work process of middle unit, module can refer to the corresponding process in preceding method embodiment, and details are not described herein.
In the above-described embodiments, it all emphasizes particularly on different fields to the description of each embodiment, is not described in detail or remembers in some embodimentThe part of load may refer to the associated description of other embodiments.
Those of ordinary skill in the art may realize that each exemplary lists described with reference to the embodiments described hereinMember and algorithm steps can be realized with the combination of electronic hardware or computer software and electronic hardware.These functions are actuallyIt is performed with hardware or software mode, specific application and design constraint depending on technical solution.Professional technicianDescribed function can be realized using distinct methods to each specific application, but this realization is it is not considered that exceedThe scope of the present invention.
In embodiment provided by the present invention, it should be understood that disclosed device/terminal device and method, it can be withIt realizes by another way.For example, device described above/terminal device embodiment is only schematical, for example, instituteThe division of module or unit is stated, only a kind of division of logic function can have other dividing mode in actual implementation, such asMultiple units or component may be combined or can be integrated into another system or some features can be ignored or does not perform.SeparatelyA bit, shown or discussed mutual coupling or direct-coupling or communication connection can be by some interfaces, deviceOr the INDIRECT COUPLING of unit or communication connection, can be electrical, machinery or other forms.
The unit illustrated as separating component may or may not be physically separate, be shown as unitThe component shown may or may not be physical unit, you can be located at a place or can also be distributed to multipleIn network element.Some or all of unit therein can be selected according to the actual needs to realize the mesh of this embodiment scheme's.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, it can alsoThat each unit is individually physically present, can also two or more units integrate in a unit.Above-mentioned integrated listThe form that hardware had both may be used in member is realized, can also be realized in the form of SFU software functional unit.
If the integrated module/unit realized in the form of SFU software functional unit and be independent product sale orIn use, it can be stored in a computer read/write memory medium.Based on such understanding, the present invention realizes above-mentioned implementationAll or part of flow in example method, can also instruct relevant hardware to complete, the meter by computer programCalculation machine program can be stored in a computer readable storage medium, the computer program when being executed by processor, it can be achieved that onThe step of stating each embodiment of the method..Wherein, the computer program includes computer program code, the computer programCode can be source code form, object identification code form, executable file or certain intermediate forms etc..Computer-readable JieMatter can include:Can carry the computer program code any entity or device, recording medium, USB flash disk, mobile hard disk,Magnetic disc, CD, computer storage, read-only memory (ROM, Read-Only Memory), random access memory (RAM,Random Access Memory), electric carrier signal, telecommunication signal and software distribution medium etc..It is it should be noted that describedThe content that computer-readable medium includes can carry out appropriate increasing according to legislation in jurisdiction and the requirement of patent practiceSubtract, such as in certain jurisdictions, according to legislation and patent practice, computer-readable medium does not include electric carrier signal and electricityBelieve signal.
Embodiment described above is merely illustrative of the technical solution of the present invention, rather than its limitations;Although with reference to aforementioned realityExample is applied the present invention is described in detail, it will be understood by those of ordinary skill in the art that:It still can be to aforementioned eachTechnical solution recorded in embodiment modifies or carries out equivalent replacement to which part technical characteristic;And these are changedOr replace, the spirit and scope for various embodiments of the present invention technical solution that it does not separate the essence of the corresponding technical solution should allIt is included within protection scope of the present invention.

Claims (10)

CN201710622205.7A2017-07-272017-07-27Data table backup method and server based on Oracle databaseActiveCN108255909B (en)

Priority Applications (2)

Application NumberPriority DateFiling DateTitle
CN201710622205.7ACN108255909B (en)2017-07-272017-07-27Data table backup method and server based on Oracle database
PCT/CN2018/083299WO2019019706A1 (en)2017-07-272018-04-17Data table backup method based on oracle database, and server

Applications Claiming Priority (1)

Application NumberPriority DateFiling DateTitle
CN201710622205.7ACN108255909B (en)2017-07-272017-07-27Data table backup method and server based on Oracle database

Publications (2)

Publication NumberPublication Date
CN108255909Atrue CN108255909A (en)2018-07-06
CN108255909B CN108255909B (en)2020-08-04

Family

ID=62722014

Family Applications (1)

Application NumberTitlePriority DateFiling Date
CN201710622205.7AActiveCN108255909B (en)2017-07-272017-07-27Data table backup method and server based on Oracle database

Country Status (2)

CountryLink
CN (1)CN108255909B (en)
WO (1)WO2019019706A1 (en)

Cited By (11)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN108984727A (en)*2018-07-112018-12-11郑州云海信息技术有限公司A kind of Database Automatic Backup method, apparatus, equipment and storage medium
CN109271455A (en)*2018-11-122019-01-25武汉达梦数据库有限公司The creation method of data table index when a kind of data are synchronous
CN109617736A (en)*2018-12-262019-04-12杭州和利时自动化有限公司A kind of data transmission method and relevant apparatus
CN110209680A (en)*2019-04-252019-09-06深圳壹账通智能科技有限公司Data-updating method, device and electronic device based on Hive external table
CN110825735A (en)*2019-10-102020-02-21中国平安财产保险股份有限公司Data table processing method and related equipment
CN111159179A (en)*2019-12-122020-05-15中国平安人寿保险股份有限公司Table partitioning method, related device and computer readable storage medium
CN113760601A (en)*2020-11-052021-12-07北京沃东天骏信息技术有限公司Data backup method, device and system
CN113760600A (en)*2020-08-052021-12-07北京京东振世信息技术有限公司Database backup method, database restoration method and related device
CN114528157A (en)*2022-02-212022-05-24中国工商银行股份有限公司Database sensitive table backup method and device
CN114880409A (en)*2022-06-152022-08-09中银金融科技有限公司Data table filing method and related device
CN116010516A (en)*2022-12-212023-04-25北京奇艺世纪科技有限公司Data synchronization system, method, electronic equipment and storage medium

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN110276060B (en)*2019-06-242022-12-09北京明略软件系统有限公司Data processing method and device

Citations (6)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
US20050071391A1 (en)*2003-09-292005-03-31International Business Machines CorporationHigh availability data replication set up using external backup and restore
CN101604269A (en)*2009-07-222009-12-16中国科学院计算技术研究所 A management system and method for backing up data
CN102752322A (en)*2011-04-182012-10-24中国科学院声学研究所Method for storing and querying distributed data in internet of things
CN103197988A (en)*2012-01-052013-07-10中国移动通信集团湖南有限公司Data backup and recovery method, device and database system
CN103870600A (en)*2014-04-022014-06-18中国银行股份有限公司Data table backup method and device based on Oracle database
CN103885855A (en)*2012-12-202014-06-25航天信息股份有限公司Data backup and recovery method and data backup and recovery device

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
US8266101B1 (en)*2009-07-162012-09-11Binpeng ShuaiShare nothing database cluster and real time synchronization by signaling
CN101694637A (en)*2009-11-062010-04-14金蝶软件(中国)有限公司Method and system for restoring database
CN102508833A (en)*2011-09-222012-06-20用友软件股份有限公司Data monitoring device and data monitoring method
CN103164431B (en)*2011-12-132016-04-20北京神州泰岳软件股份有限公司The date storage method of relevant database and storage system
CN106951490B (en)*2017-03-142020-09-18清华大学Storage and cache reading method for correcting data in real time

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
US20050071391A1 (en)*2003-09-292005-03-31International Business Machines CorporationHigh availability data replication set up using external backup and restore
CN101604269A (en)*2009-07-222009-12-16中国科学院计算技术研究所 A management system and method for backing up data
CN102752322A (en)*2011-04-182012-10-24中国科学院声学研究所Method for storing and querying distributed data in internet of things
CN103197988A (en)*2012-01-052013-07-10中国移动通信集团湖南有限公司Data backup and recovery method, device and database system
CN103885855A (en)*2012-12-202014-06-25航天信息股份有限公司Data backup and recovery method and data backup and recovery device
CN103870600A (en)*2014-04-022014-06-18中国银行股份有限公司Data table backup method and device based on Oracle database

Cited By (15)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN108984727A (en)*2018-07-112018-12-11郑州云海信息技术有限公司A kind of Database Automatic Backup method, apparatus, equipment and storage medium
CN109271455B (en)*2018-11-122021-04-09武汉达梦数据库有限公司 A method for creating data table index during data synchronization
CN109271455A (en)*2018-11-122019-01-25武汉达梦数据库有限公司The creation method of data table index when a kind of data are synchronous
CN109617736A (en)*2018-12-262019-04-12杭州和利时自动化有限公司A kind of data transmission method and relevant apparatus
CN110209680A (en)*2019-04-252019-09-06深圳壹账通智能科技有限公司Data-updating method, device and electronic device based on Hive external table
CN110825735A (en)*2019-10-102020-02-21中国平安财产保险股份有限公司Data table processing method and related equipment
CN110825735B (en)*2019-10-102023-08-22中国平安财产保险股份有限公司Data table processing method and related equipment
CN111159179A (en)*2019-12-122020-05-15中国平安人寿保险股份有限公司Table partitioning method, related device and computer readable storage medium
CN113760600A (en)*2020-08-052021-12-07北京京东振世信息技术有限公司Database backup method, database restoration method and related device
CN113760600B (en)*2020-08-052023-09-22北京京东振世信息技术有限公司Database backup method, database restoration method and related devices
CN113760601A (en)*2020-11-052021-12-07北京沃东天骏信息技术有限公司Data backup method, device and system
CN113760601B (en)*2020-11-052024-06-18北京沃东天骏信息技术有限公司Data backup method, device and system
CN114528157A (en)*2022-02-212022-05-24中国工商银行股份有限公司Database sensitive table backup method and device
CN114880409A (en)*2022-06-152022-08-09中银金融科技有限公司Data table filing method and related device
CN116010516A (en)*2022-12-212023-04-25北京奇艺世纪科技有限公司Data synchronization system, method, electronic equipment and storage medium

Also Published As

Publication numberPublication date
WO2019019706A1 (en)2019-01-31
CN108255909B (en)2020-08-04

Similar Documents

PublicationPublication DateTitle
CN108255909A (en)Tables of data backup method and server based on oracle database
CN108536761A (en)Report data querying method and server
CN107688591B (en)A kind of actuarial treating method and apparatus
CN103544323B (en)A kind of data-updating method and device
CN109271450A (en)Database synchronization method, device, server and storage medium
CN109344153A (en)The processing method and terminal device of business datum
CN108388675A (en)Circulation method and terminal device are drawn in a kind of identity
CN109508355A (en)A kind of data pick-up method, system and terminal device
CN103631967B (en)A kind of processing method and processing device of the tables of data with independent increment identification field
CN108304522A (en)Comparison method, device and the terminal device of difference between a kind of database
CN112100219A (en)Report generation method, device, equipment and medium based on database query processing
US20190229931A1 (en)Distributed telephone number ledger and register
CN105550270B (en)Data base query method and device
CN108052569A (en)Data bank access method, device, computer readable storage medium and computing device
CN103606037A (en)Query and configuration method of business data and device thereof
CN107807932A (en)A kind of hierarchical data management method and system based on path enumeration
CN104077680A (en)Contract management system for E-business platform
CN110427775A (en)Data query authority control method and device
CN110162540A (en)Querying method, electronic device and the storage medium of block chain account book data
CN109522332A (en)Customer profile data merging method, device, equipment and readable storage medium storing program for executing
CN109960538A (en)A kind of configuration interface management method, configuration interface managing device and electronic equipment
CN111639057A (en)Log message processing method and device, computer equipment and storage medium
CN109241357A (en)Chain structure model and its construction method, system and terminal device
CN109376142A (en)Data migration method and terminal device
CN110245149A (en) Metadata version management method and device

Legal Events

DateCodeTitleDescription
PB01Publication
PB01Publication
SE01Entry into force of request for substantive examination
SE01Entry into force of request for substantive examination
GR01Patent grant
GR01Patent grant

[8]ページ先頭

©2009-2025 Movatter.jp