CN108228611A - Document information copies method and apparatus - Google Patents
Document information copies method and apparatus Download PDFInfo
- Publication number
- CN108228611A CN108228611A CN201611154984.4A CN201611154984A CN108228611A CN 108228611 A CN108228611 A CN 108228611A CN 201611154984 A CN201611154984 A CN 201611154984A CN 108228611 A CN108228611 A CN 108228611A
- Authority
- CN
- China
- Prior art keywords
- source database
- document information
- information
- mark
- odd numbers
- 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
- 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/24—Querying
- G06F16/245—Query processing
-
- 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/22—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/08—Insurance
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of document informations to copy method and apparatus, including:Single operation instruction is copied in reception, obtains the target odd numbers of corresponding source database mark and input;Preconfigured table structural information corresponding with source database mark is searched, table structural information includes the level incidence relation between multiple table ids of configuration and each table id;Corresponding source database server transmission, which is identified, to source database copies single request, copy the multiple table ids for including configuration in single request, the target odd numbers of level incidence relation and input between each table id, receive the return of source database server searches document information corresponding with target odd numbers according to the level incidence relation between multiple table ids and each table id from table corresponding with multiple table ids, and object table ID corresponding with document information, document information write request is sent to exploitation database server, make exploitation database server that document information is written in table corresponding with object table ID.Improve the efficiency for searching abnormal problem.
Description
Technical field
The present invention relates to field of computer technology, and method and apparatus are copied more particularly to a kind of document information.
Background technology
For software development, test environment and production environment can be generally established.Wherein, test environment refers to tester's profit
It is simulated with some tools and data, the environment close to the true use environment of user, the performance before reaching the standard grade for software product
Test.Production environment refers to reach the standard grade after, user oriented formal run the true environment that uses.
In insurance industry, carried out in test environment or production environment at some documents (such as declaration form, request slip etc.)
During reason, it sometimes appear that some abnormal problems (for example a certain declaration form reimbursement there is a problem, the declaration form amount of money there is a problem).
In conventional method, in order to find out the basic reason for causing abnormal problem, need in test environment or production environment
In daily record is beaten to the document for abnormal problem occur, check every row daily record data by artificial and judge the original for exception error occur
Cause.Obviously, time cost is very big, and the efficiency for searching the abnormal problem of appearance is very low.
Invention content
Based on this, it is necessary to provide a kind of document information for the efficiency that can be improved and search abnormal problem and copy method and dress
It puts.
A kind of document information copies method, the described method comprises the following steps:
Single operation instruction is copied in reception, is identified and is inputted in response to the corresponding source database of single operation instruction acquisition of copying
Target odd numbers;
Preconfigured table structural information corresponding with source database mark is searched, the table structural information includes
Level incidence relation between the multiple table ids and each table id of configuration;
Corresponding source database server transmission is identified to the source database and copies single request, and described copy includes in single request
The target odd numbers of level incidence relation and the input between multiple table ids of the configuration, each table id makes described
Source database server according to the level incidence relation between the multiple table id and each table id from the multiple table
Document information corresponding with the target odd numbers is searched in the corresponding tables of ID;
Receive the document information returned from the source database server and object table corresponding with the document information
ID sends document information write request to exploitation database server, and the exploitation database server is made to believe the document
Breath is written in table corresponding with the object table ID.
The source database mark includes Production database mark or test database mark in one of the embodiments,
Know.
The method further includes in one of the embodiments,:
The table topology update notice that the source database server is sent is received, reads in the table topology update notice and wraps
Source database mark, table id to be updated and the corresponding fresh information contained;
Search table structural information corresponding with source database mark;
The table structural information found is carried out according to the table id to be updated and the fresh information corresponding
Update is handled.
The table topology update notice is notified for newly-increased table in one of the embodiments, described to read the table structure
The step of source database mark, table id to be updated and corresponding fresh information for being included in update notification, including:
The source database mark included in the newly-increased table notice is read, the first newly-increased table id is treated and waits to increase newly with described
Associated second table id of the first table id;
It is described the table structural information found to be carried out pair according to the table id to be updated and the fresh information
The step of update processing answered, including:
The first newly-increased table id is treated described in parsing, first table id pair is determined in the table structural information found
The point of addition for the table answered;
First table id and the corresponding table of the second table id on being added in the corresponding point of addition, and described in foundation
Incidence relation between the corresponding table of second table id table corresponding with first table id.
The target odd numbers includes number of policy and/or application odd numbers in one of the embodiments,.
A kind of document information copies device, and described device includes:
Receiving module copies single operation instruction for receiving, and the corresponding source data of single operation instruction acquisition is copied in response to described
Library identifies and the target odd numbers of input;
Table structural information searching module, for searching preconfigured table structure letter corresponding with source database mark
Breath, the table structural information include the level incidence relation between multiple table ids of configuration and each table id;
Single module is copied, single request is copied for identifying corresponding source database server transmission to the source database, it is described
Copy the mesh of multiple table ids comprising the configuration, the level incidence relation between each table id and the input in single request
Mark odd numbers, make the source database server according to the level incidence relation between the multiple table id and each table id from
Document information corresponding with the target odd numbers is searched in table corresponding with the multiple table id;
Document information writing module, for receive the document information that is returned from the source database server and with it is described
The corresponding object table ID of document information sends document information write request to exploitation database server, makes the exploitation data
The document information is written in table corresponding with the object table ID library server.
The source database mark includes Production database mark or test database mark in one of the embodiments,
Know.
The receiving module is additionally operable to receive the table knot that the source database server is sent in one of the embodiments,
Structure update notification, read the source database mark included in table topology update notice, table id to be updated and it is corresponding more
New information;
The table structural information searching module is additionally operable to search table structural information corresponding with source database mark;
Described device further includes:
Update module, for being believed according to the table id to be updated and the fresh information the table structure found
Breath carries out corresponding update processing.
The table topology update notice notifies that the receiving module is additionally operable to for newly-increased table in one of the embodiments,
The source database mark included in the newly-increased table notice is read, the first newly-increased table id is treated and treats the first newly-increased table with described
Associated second table ids of ID;
The update module is additionally operable to treat the first newly-increased table id described in parsing, in the table structural information found
Determine the point of addition of the corresponding table of first table id;In the corresponding point of addition addition on first table id and
The corresponding table of second table id, and establish the pass of the association between the corresponding table of second table id table corresponding with first table id
System.
The target odd numbers includes number of policy and/or application odd numbers in one of the embodiments,.
Above-mentioned document information copies method and apparatus, by obtaining source database mark and mesh in response to copying single operation instruction
Mark odd numbers, search corresponding with source database mark preconfigured table structural information, obtain including multiple table ids and
Level incidence relation between each table id copies single request, and receive source database server to the transmission of source database server
From the corresponding table search of multiple table ids to document information corresponding with target odd numbers and object table corresponding with document information
ID.Then, document information write request is sent to exploitation database server, exploitation database server is made to write document information
Enter to develop in database in table corresponding with object table ID.It realizes and makes a copy for the source document information in source database server
It develops in database, it is clear that after source document information makes a copy for exploitation database, exploitation database server can be believed according to document
Breath carries out case study, and to beat the mode that daily record searches problem in production environment or test environment more quick than traditional,
And then improve the efficiency for searching abnormal problem.
Description of the drawings
Fig. 1 is the application environment schematic diagram that document information copies method in one embodiment;
Fig. 2 is the internal structure chart of terminal in one embodiment;
Fig. 3 is the flow diagram that document information copies method in one embodiment;
Fig. 4 is the flow diagram of table structural information update method in another embodiment;
Fig. 5 is the structure diagram that document information copies device in one embodiment;
Fig. 6 is the structure diagram that document information copies device in another embodiment.
Specific embodiment
In order to make the purpose , technical scheme and advantage of the present invention be clearer, with reference to the accompanying drawings and embodiments, it is right
The present invention is further elaborated.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, and
It is not used in the restriction present invention.
Fig. 1 is the applied environment figure that document information copies method in one embodiment.As shown in Figure 1, terminal 110 passes through net
Network communicates with source database server 120 and exploitation database server 130.It can install and run various in terminal 110
Using.The odd numbers for copying the single target declaration form to be copied of interface input and selection that operating personnel are shown by terminal 110 will be from which
The target document is copied in a database, and then copy single operation and copies single operation instruction to input.Terminal 110 receives this and copies list
Operational order obtains the mark of selected source database and the target odd numbers of input in response to the operational order.Further, eventually
The correspondence being provided in end 110 between table structural information and source database mark according to the correspondence, is searched and source number
Corresponding preconfigured table structural information is identified according to library, wherein, table structural information includes multiple table ids of configuration and each table
Level incidence relation between ID.Terminal 110 copies single request to the transmission of source database server 120.Source database server 120
It is searched and target odd numbers pair from the corresponding table of multiple table ids according to the level incidence relation between multiple table ids and each table id
The document information answered, and the document information found is back to terminal 110.110 record document information of terminal and corresponding mesh
Table id is marked, document information write request is sent to exploitation database server.Developing database server 130 please according to the write-in
It asks and document information is written in the exploitation database in table corresponding with object table ID.
It is appreciated that terminal 110 includes but not limited to various personal computers, smart mobile phone, tablet computer, notebook electricity
Brain, portable wearable device etc., it is numerous to list herein.
Fig. 2 shows the internal structure schematic diagram of the terminal 110 in one embodiment, internal structure such as Fig. 1 of the terminal
It is shown, including connected by system bus processor, built-in storage, non-volatile memory medium, network interface, display screen and
Input unit.Wherein, the non-volatile memory medium of the terminal is stored with operating system, further includes a kind of document information and copies dress
It puts, which, which copies device and be used to implement a kind of document information, copies method.The processor is calculated and is controlled for providing
Ability supports the operation of entire terminal.Built-in storage in terminal copies dress for the document information in non-volatile memory medium
The operation put provides environment, has computer-readable instruction in the built-in storage, which is executed by processor
When, it may be such that processor performs a kind of document information and copies method.Network interface communicates for being connected to network.Terminal
Display screen can be liquid crystal display or electric ink display screen etc., and input unit can be the touch covered on display screen
Button, trace ball or the Trackpad or external keyboard, Trackpad set on layer or electronic equipment casing
Or mouse etc..The terminal can be mobile phone, tablet computer, laptop, desktop computer etc..Those skilled in the art can be with
Understand, the structure shown in Fig. 1 only with the block diagram of the relevant part-structure of application scheme, is not formed to the application
The restriction for the terminal that scheme is applied thereon, specific terminal can include than components more or fewer shown in figure or
Person combines certain components or is arranged with different components.
As shown in figure 3, it in one embodiment, provides a kind of document information and copies method, be now applied in this way
It is illustrated for terminal, this method specifically includes following steps:
Step 302, receive and copy single operation instruction, in response to copy single operation instruction obtain corresponding source database mark and
The target odd numbers of input.
In the present embodiment, operating personnel can be opened by terminal and copy single utility program, and single utility program is copied to run this.
Refer to carry out the application program that document information copies processing it is appreciated that copying single utility program.
Further, operating personnel can copy the target list to be copied of input on single utility program display interface in operation
Number, it carries out copying single operation.Terminal receives this and copies single operation instruction, and copies single operation instruction in response to this and obtain corresponding source data
Library identifies and the target odd numbers of input.Wherein, target odd numbers includes number of policy and/or application odd numbers.
Wherein, source database refers to store the database of the corresponding document information of target odd numbers to be copied.Provide
The database of the document information to be copied.Source database mark refers to for the mark of the unique mark source database.
Further, source database mark can be preconfigured or operating personnel when carrying out copying single operation,
It inputs or selects.Therefore, terminal can obtain preconfigured source database mark.Can also be that acquisition operating personnel are defeated
The source database mark for entering or selecting.Wherein, source database mark includes Production database mark or test database mark.
Step 304, preconfigured table structural information corresponding with source database mark is searched, table structural information includes
Level incidence relation between the multiple table ids and each table id of configuration.
Further, table structural information and source database mark and the table structural information of configuration have been pre-configured in terminal
Between one-to-one relationship.Terminal can be according to the correspondence, and lookup is corresponding with the source database mark obtained to match in advance
The table structural information put.
Wherein, table structural infor-mation indes are according to the Schema information of the table in library, multiple table ids and each table including configuration
Level incidence relation between ID.If be appreciated that a table major key be another table external key, then the two tables it
Between just have level incidence relation.Table id (abbreviation of identification) refers to the mark of unique mark table.
It is appreciated that the table knot being configured in preconfigured table structural information and corresponding source database server in terminal
Structure information is consistent, and it is corresponding just to can guarantee that the table structural information according to configuration is got from source database server in this way
Document information.
Step 306, it identifies corresponding source database server transmission to source database and copies single request, copy and included in single request
The target odd numbers of multiple table ids of configuration, the level incidence relation between each table id and input, makes source database server root
It is searched and target odd numbers pair from table corresponding with multiple table ids according to the level incidence relation between multiple table ids and each table id
The document information answered.
Further, terminal can identify corresponding source database server transmission to source database and copy single request.Wherein, list is copied
The level incidence relation between the multiple table ids being configured, each table id and the target odd numbers of input are included in request.
Source database server can be according to the level incidence relation between multiple table ids and each table id from the source database
Document information corresponding with target odd numbers is searched in table corresponding with this multiple table id in server.
Specifically, source database server can be searched according to target odd numbers with having the table of the target odd numbers, from the table
Obtain document information.Further, can according to the level incidence relation between each table id, from table (i.e. main table) the associated table
Middle acquisition document information.Also it is the corresponding document of target odd numbers in main table it is appreciated that with the information in the associated table of main table
Relevant information.
Further, the document information found refer to the relevant document information of target odd numbers, including the target odd numbers
Original document information and modified document information.
Step 308, the document information returned from source database server and object table corresponding with document information are received
ID, to exploitation database server send document information write request, make exploitation database server by document information write-in with
In the corresponding tables of object table ID.
Further, source database server can will find document information corresponding with target odd numbers and and document information
Corresponding object table ID is back to terminal.Wherein, object table ID corresponding with document information refers to each document information of offer
The ID of table.For example, have table 1, table 2, table 3, table 4 ... table N, wherein, Tables 1 and 2 association is found and mesh from Tables 1 and 2
The corresponding document information of odd numbers is marked, then the ID of each document information and corresponding Tables 1 and 2 is back to by source database server
Terminal.
Terminal receives document information and the table id corresponding with document information that source database server returns, as object table
ID.Terminal can further generate document information write request and be sent to exploitation database server.Develop database server meeting
It, will in database server is developed according to the document information and corresponding object table ID included in the document information write request
Document information be written with object table ID corresponding to table in.
In one embodiment, further, exploitation database server can carry out case study to the document information of write-in
It runs again, to be investigated to abnormal problem.
In the present embodiment, by being pre-configured with table structural information in terminal, acquisition source is instructed then in response to single operation is copied
Database Identification and single goal odd numbers is copied, search preconfigured table structural information corresponding with source database mark, acquisition
Including multiple table ids and each table id between level incidence relation, to source database server transmission copy single request,
And record source database server from the corresponding table search of multiple table ids to document information corresponding with target odd numbers and with list
It is believed that ceasing corresponding object table ID, then, document information write request is sent to exploitation database server, makes exploitation database
Document information is written in exploitation database in table corresponding with object table ID server.Realizing will be in source database server
Source document information make a copy for exploitation database in, it is clear that source document information make a copy for exploitation database after, exploitation database clothes
Device of being engaged in can carry out case study according to document information, play daily record than traditional in production environment or test environment and search problem
Mode it is more quick, and then improve search abnormal problem efficiency.
In addition, for compared to the conventional method of daily record is beaten in production environment or test environment, it can reduce and be asked extremely
Influence during topic investigation to production server or test server runnability, realize does not influence to produce when abnormal problem is investigated
The normal operation of other functions of the server of raw abnormal problem.
In one embodiment, this method further includes:The table topology update notice that source database server is sent is received, is read
Take source database mark, table id to be updated and the corresponding fresh information that table topology update includes in notifying;It searches and source number
Corresponding preconfigured table structural information is identified according to library;According to table id and fresh information to be updated to the table structure that finds
Information carries out the step of corresponding update processing.
It is appreciated that ginseng is described previously, it is an a pair between table structural information and the source database mark being configured in terminal
The relationship answered.When the table structure in source data server updates, then the table structural information of corresponding configuration also needs in terminal
Update is corresponded to, can ensure successfully to obtain document information from source database server.
In the present embodiment, when the table structural information in source database server updates, table structure can be sent to terminal
Update notification.Terminal receives table topology update notice, reads the source database mark included in table topology update notice, treats
Newer table id and corresponding fresh information.
Terminal can identify the correspondence between preconfigured table structural information according to the source database of storage, search
Table structural information corresponding with source database mark.Further, terminal can be according to table id and fresh information to be updated to looking into
The table structural information found carries out corresponding update processing.
In the present embodiment, it can automatically realize the update processing of table structural information, save cost of labor.In addition, only
It needs to be updated table structural information, can be realized without carrying out the operations such as other a large amount of rewriting codes to copying list
The maintenance of application program, it is very convenient.
In one embodiment, table topology update notice is notified for newly-increased table, is included in reading table topology update notice
The step of source database mark, table id to be updated and corresponding fresh information, including:Read the source included in newly-increased table notice
Database Identification treats the first newly-increased table id and with treating associated second table id of the first newly-increased table id.
It is appreciated that newly-increased table notice is that the notice of table is newly added in original table structural information.The present embodiment
In, in newly-increased table notice comprising source database mark, treat the first newly-increased table id and with treating the first newly-increased table id associated the
Two table ids.
In the present embodiment, as shown in figure 4, text is configured in the table structure found according to table id and fresh information to be updated
The step of corresponding update processing is carried out in part (abbreviation table structural information updates step), including:
Step 402, it parses and treats the first newly-increased table id, determine that the first table id is corresponding in the table structural information found
The point of addition of table.
Specifically, terminal can parse included in newly-increased table notice treat the first newly-increased table id, according to the priority of table id
Sequentially, the point of addition of the corresponding table of the first table id is determined in the table structural information found.For example, treat that newly-increased table id is
102, then according to the sequencing of table id, it may be determined that table id can be somebody's turn to do in table structural information to be inserted into behind 101 table
Treat the first newly-increased table id.
Step 404, the first table id and the corresponding table of the second table id are added in corresponding point of addition, and establishes second
Incidence relation between the corresponding table of table id table corresponding with the first table id.
Further, terminal can add the first table id on the corresponding point of addition determined and the second table id is corresponding
Table.As it was noted above, the second table id is associated with the first table id, so terminal can further establish the corresponding table of the second table id
Incidence relation between table corresponding with the first table id.
As shown in figure 5, it in one embodiment, provides a kind of document information and copies device 500.The device includes receiving
Module 502, copies single module 506 and document information writing module 508 at table structural information searching module 504, wherein:
Receiving module 502 copies single operation instruction for receiving, and corresponding source database is obtained in response to copying single operation instruction
Mark and the target odd numbers of input.
Table structural information searching module 504, for searching preconfigured table structure letter corresponding with source database mark
Breath, table structural information include the level incidence relation between multiple table ids of configuration and each table id.
Single module 506 is copied, single request is copied for identifying corresponding source database server transmission to source database, copies single ask
The target odd numbers of multiple table ids comprising configuration, the level incidence relation between each table id and input is sought, makes source database
Server is searched from table corresponding with multiple table ids according to the level incidence relation between multiple table ids and each table id and mesh
Mark the corresponding document information of odd numbers.
Document information writing module 508, for receiving the document information returned from source database server and and document
The corresponding object table ID of information sends document information write request to exploitation database server, makes exploitation database server
Document information is written in table corresponding with object table ID.
In one embodiment, source database mark includes Production database mark or test database mark.
In one embodiment, receiving module 502, which is additionally operable to receive the table topology update that source database server is sent, leads to
Know, source database mark, table id to be updated and the corresponding fresh information included in reading table topology update notice.
Table structural information searching module 504 is additionally operable to search table structural information corresponding with source database mark.
In the present embodiment, as shown in fig. 6, the device further includes:
Update module 510, for being carried out according to table id and fresh information to be updated to the table structural information found pair
The update processing answered.
In one embodiment, table topology update notice is notified for newly-increased table, and receiving module, which is additionally operable to read newly-increased table, to be led to
The source database included in knowing identifies, treats the first newly-increased table id and with treating associated second table id of the first newly-increased table id.
Update module 510, which is additionally operable to parse, treats the first newly-increased table id, and first is determined in the table structural information found
The point of addition of the corresponding table of table id;First table id and the corresponding table of the second table id on being added in corresponding point of addition, and
Establish the incidence relation between the corresponding table of the second table id table corresponding with the first table id.
In one embodiment, target odd numbers includes number of policy and/or application odd numbers.
One of ordinary skill in the art will appreciate that realizing all or part of flow in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, which can be stored in a computer-readable storage and be situated between
In matter, the program is when being executed, it may include such as the flow of the embodiment of above-mentioned each method.Wherein, aforementioned storage medium can be
The non-volatile memory mediums such as magnetic disc, CD, read-only memory (Read-Only Memory, ROM) or random storage note
Recall body (Random Access Memory, RAM) etc..
Each technical characteristic of embodiment described above can be combined arbitrarily, to make description succinct, not to above-mentioned reality
It applies all possible combination of each technical characteristic in example to be all described, as long as however, the combination of these technical characteristics is not deposited
In contradiction, it is all considered to be the range of this specification record.
Embodiment described above only expresses the several embodiments of the present invention, and description is more specific and detailed, but simultaneously
It cannot therefore be construed as limiting the scope of the patent.It should be pointed out that those of ordinary skill in the art are come
It says, without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to the protection of the present invention
Range.Therefore, the protection domain of patent of the present invention should be determined by the appended claims.
Claims (10)
1. a kind of document information copies method, the described method comprises the following steps:
Single operation instruction is copied in reception, in response to the mesh for copying single operation instruction and obtaining corresponding source database and identifying and input
Mark odd numbers;
Preconfigured table structural information corresponding with source database mark is searched, the table structural information includes configuration
Multiple table ids and each table id between level incidence relation;
Corresponding source database server transmission, which is identified, to the source database copies single request, it is described to copy in single request comprising described
The target odd numbers of multiple table ids of configuration, the level incidence relation between each table id and the input, makes the source number
According to library server according to the level incidence relation between the multiple table id and each table id from the multiple table id pair
Document information corresponding with the target odd numbers is searched in the table answered;
The document information returned from the source database server and object table ID corresponding with the document information are received, to
It develops database server and sends document information write request, make the exploitation database server that the document information to be written
In table corresponding with the object table ID.
2. according to the method described in claim 1, it is characterized in that, the source database mark include Production database identify or
Test database identifies.
3. according to the method described in claim 1, it is characterized in that, the method further includes:
The table topology update notice that the source database server is sent is received, reads what is included in the table topology update notice
Source database mark, table id to be updated and corresponding fresh information;
Search table structural information corresponding with source database mark;
Corresponding update is carried out to the table structural information found according to the table id to be updated and the fresh information
Processing.
It is 4. described according to the method described in claim 3, it is characterized in that, table topology update notice is notified for newly-increased table
Read the step of source database mark, table id to be updated and corresponding fresh information included in the table topology update notice
Suddenly, including:
The source database mark included in the newly-increased table notice is read, treat the first newly-increased table id and treats newly-increased the with described
Associated second table id of one table id;
It is described corresponding to the table structural information progress found according to the table id to be updated and the fresh information
The step of update processing, including:
The first newly-increased table id is treated described in parsing, determines that first table id is corresponding in the table structural information found
The point of addition of table;
First table id and the corresponding table of the second table id on being added in the corresponding point of addition, and establish described second
Incidence relation between the corresponding table of table id table corresponding with first table id.
5. method according to any one of claims 1 to 4, which is characterized in that the target odd numbers include number of policy and/or
Apply for odd numbers.
6. a kind of document information copies device, which is characterized in that described device includes:
Receiving module copies single operation instruction for receiving, and the corresponding source database mark of single operation instruction acquisition is copied in response to described
The target odd numbers known and inputted;
Table structural information searching module, for searching preconfigured table structural information corresponding with source database mark,
The table structural information includes the level incidence relation between multiple table ids of configuration and each table id;
Single module is copied, single request is copied for identifying corresponding source database server transmission to the source database, it is described to copy list
The target list of multiple table ids comprising the configuration, the level incidence relation between each table id and the input in request
Number, make the source database server according to the level incidence relation between the multiple table id and each table id from institute
It states and document information corresponding with the target odd numbers is searched in the corresponding table of multiple table ids;
Document information writing module, for receive the document information that is returned from the source database server and with the document
The corresponding object table ID of information sends document information write request to exploitation database server, takes the exploitation database
Being engaged in device will be in document information write-in table corresponding with the object table ID.
7. device according to claim 6, which is characterized in that source database mark include Production database identify or
Test database identifies.
8. device according to claim 6, which is characterized in that the receiving module is additionally operable to receive the source database clothes
The table topology update notice that business device is sent reads the source database included in the table topology update notice and identifies, is to be updated
Table id and corresponding fresh information;
The table structural information searching module is additionally operable to search table structural information corresponding with source database mark;
Described device further includes:
Update module, for according to the table id to be updated and the fresh information to the table structural information found into
The corresponding update processing of row.
9. device according to claim 8, which is characterized in that the table topology update notice is notified for newly-increased table, described
Receiving module is additionally operable to read the source database mark included in the newly-increased table notice, treat the first newly-increased table id and with it is described
Treat associated second table id of the first newly-increased table id;
The update module is additionally operable to treat the first newly-increased table id described in parsing, is determined in the table structural information found
The point of addition of the corresponding table of first table id;First table id and second in addition in the corresponding point of addition
The corresponding table of table id, and establish the incidence relation between the corresponding table of second table id table corresponding with first table id.
10. according to claim 6 to 9 any one of them device, which is characterized in that the target odd numbers include number of policy and/
Or application odd numbers.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201611154984.4A CN108228611B (en) | 2016-12-14 | 2016-12-14 | Document information copying method and device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201611154984.4A CN108228611B (en) | 2016-12-14 | 2016-12-14 | Document information copying method and device |
Publications (2)
Publication Number | Publication Date |
---|---|
CN108228611A true CN108228611A (en) | 2018-06-29 |
CN108228611B CN108228611B (en) | 2020-08-18 |
Family
ID=62651071
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201611154984.4A Active CN108228611B (en) | 2016-12-14 | 2016-12-14 | Document information copying method and device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108228611B (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109857623A (en) * | 2018-12-13 | 2019-06-07 | 深圳壹账通智能科技有限公司 | Service performance analysis method, device and electronic equipment based on journal file |
CN110909071A (en) * | 2018-09-17 | 2020-03-24 | 北京国双科技有限公司 | Data synchronization method, device and system |
CN111581187A (en) * | 2020-05-14 | 2020-08-25 | 海南电网有限责任公司信息通信分公司 | Data management method and device for intelligent park, computer equipment and storage medium |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2013092945A (en) * | 2011-10-26 | 2013-05-16 | Nomura Research Institute Ltd | Data use system |
CN103336843A (en) * | 2013-07-18 | 2013-10-02 | 山东中创软件工程股份有限公司 | Data integration method and device |
CN104317843A (en) * | 2014-10-11 | 2015-01-28 | 上海瀚之友信息技术服务有限公司 | Data synchronism ETL (Extract Transform Load) system |
CN104991975A (en) * | 2015-07-30 | 2015-10-21 | 广东电网有限责任公司佛山供电局 | Data query method and system of electric power business systems |
-
2016
- 2016-12-14 CN CN201611154984.4A patent/CN108228611B/en active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2013092945A (en) * | 2011-10-26 | 2013-05-16 | Nomura Research Institute Ltd | Data use system |
CN103336843A (en) * | 2013-07-18 | 2013-10-02 | 山东中创软件工程股份有限公司 | Data integration method and device |
CN104317843A (en) * | 2014-10-11 | 2015-01-28 | 上海瀚之友信息技术服务有限公司 | Data synchronism ETL (Extract Transform Load) system |
CN104991975A (en) * | 2015-07-30 | 2015-10-21 | 广东电网有限责任公司佛山供电局 | Data query method and system of electric power business systems |
Non-Patent Citations (1)
Title |
---|
张玉峰: "基于索引结构的关系数据库关键词检索", 《中国优秀硕士学位论文全文数据库 信息科技辑I138-366》 * |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110909071A (en) * | 2018-09-17 | 2020-03-24 | 北京国双科技有限公司 | Data synchronization method, device and system |
CN109857623A (en) * | 2018-12-13 | 2019-06-07 | 深圳壹账通智能科技有限公司 | Service performance analysis method, device and electronic equipment based on journal file |
CN111581187A (en) * | 2020-05-14 | 2020-08-25 | 海南电网有限责任公司信息通信分公司 | Data management method and device for intelligent park, computer equipment and storage medium |
Also Published As
Publication number | Publication date |
---|---|
CN108228611B (en) | 2020-08-18 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US11847438B2 (en) | Offline capabilities for live applications in a cloud collaboration platform | |
CN102279872B (en) | Inquiring intention identification drived by search results | |
CN107733984A (en) | A kind of method, terminal and computer-readable recording medium for pushing screen locking information | |
US11733990B2 (en) | Generating software artifacts from a conceptual data model | |
CN108549568A (en) | Using entrance processing method, apparatus, storage medium and electronic equipment | |
CN109739600A (en) | Data processing method, medium, device and calculating equipment | |
CN108228611A (en) | Document information copies method and apparatus | |
CN109558191A (en) | A kind of method, apparatus, storage medium and computer equipment configuring the page | |
CN107844519A (en) | Electronic installation, data base querying scenario generation method and storage medium | |
CN106648569A (en) | Target serialization achieving method and device | |
CN109388551A (en) | There are the method for loophole probability, leak detection method, relevant apparatus for prediction code | |
CN109614312A (en) | Method for generating test case, device, electronic equipment and storage medium | |
US20210042363A1 (en) | Search pattern suggestions for large datasets | |
EP3062245B1 (en) | Dynamic modular ontology | |
US7890523B2 (en) | Search-based filtering for property grids | |
CN108170595A (en) | A kind of dump file generation method and data probe install and uninstall method | |
US9286349B2 (en) | Dynamic search system | |
CN108241607A (en) | Automatically imported method, server and the storage medium of test of heuristics case | |
CN103812908A (en) | Cloud file processing method and system | |
CN112487314A (en) | Building search method and device based on knowledge graph and storage medium | |
CN110309315B (en) | Template file generation method and device, computer readable medium and electronic equipment | |
CN112287658A (en) | Business data processing method and device, electronic equipment and medium | |
CN111221817B (en) | Service information data storage method, device, computer equipment and storage medium | |
CN117435651A (en) | Test data processing method, device, computer equipment and storage medium | |
US20200050708A1 (en) | Graphical Match Policy for Identifying Duplicative Data |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |