CN110134664A - Acquisition methods, device and the computer equipment in Data Migration path - Google Patents
Acquisition methods, device and the computer equipment in Data Migration path Download PDFInfo
- Publication number
- CN110134664A CN110134664A CN201910295665.2A CN201910295665A CN110134664A CN 110134664 A CN110134664 A CN 110134664A CN 201910295665 A CN201910295665 A CN 201910295665A CN 110134664 A CN110134664 A CN 110134664A
- Authority
- CN
- China
- Prior art keywords
- path
- sentence
- word
- source address
- closing
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000013508 migration Methods 0.000 title claims abstract description 51
- 230000005012 migration Effects 0.000 title claims abstract description 51
- 238000000034 method Methods 0.000 title claims abstract description 46
- 238000013459 approach Methods 0.000 claims abstract description 14
- 239000000284 extract Substances 0.000 claims abstract description 12
- 238000004590 computer program Methods 0.000 claims description 31
- 238000000605 extraction Methods 0.000 claims description 14
- 230000008569 process Effects 0.000 description 17
- 238000012545 processing Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 3
- 230000006399 behavior Effects 0.000 description 2
- 239000000203 mixture Substances 0.000 description 2
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 230000002708 enhancing effect Effects 0.000 description 1
- 238000003780 insertion Methods 0.000 description 1
- 230000037431 insertion Effects 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 1
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/21—Design, administration or maintenance of databases
- G06F16/214—Database migration support
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of acquisition methods in Data Migration path, this method comprises: to acquisite approachs sentence；It determines the fisrt feature word and the first closing in the path statement, the source address sentence in the path statement is obtained according to the fisrt feature word and first closing；It determines the second feature word and the second closing in the path statement, the destination address sentence in the path statement is obtained according to the second feature word and the second closing；Source address is extracted from source address sentence, and, using the destination address sentence as the destination address；Data Migration path is obtained according to source address and destination address.The present invention program can extract source address and destination address from path statement automatically, so that it is determined that Data Migration path, high-efficient, and accuracy rate is high.
Description
Technical field
The present invention relates to field of computer technology, more particularly to a kind of acquisition methods in Data Migration path, device and
Computer equipment.
Background technique
When the data of currently processed big data platform, need clearly to know the ins and outs of each data, therefore at data
It needs for the source information of data and purpose information, that is, the migration path of data to be filled up to inside scheduling document during reason,
Then it goes to read scheduling document execution task when Platform deployment.
Traditional technology is filled in using the migration path for manually parsing data from HQL code corresponding with data-base cluster
Into document, in the larger situation of HQL task amount, time-consuming, low efficiency for artificial parsing.
Summary of the invention
The purpose of the present invention is to provide a kind of acquisition methods in Data Migration path, device, computer equipments and readable
Storage medium, be able to solve path statement task amount it is larger when, it is artificial parse Data Migration path time-consuming, low efficiency is asked
Topic.
The purpose of the present invention is achieved through the following technical solutions:
A kind of acquisition methods in Data Migration path, which comprises
To acquisite approachs sentence；
The fisrt feature word and the first closing in the path statement are determined, according to the fisrt feature word and described
One closing obtains the source address sentence in the path statement；Determine the second feature word and the second knot in the path statement
Beam word obtains the destination address sentence in the path statement according to the second feature word and the second closing；
Source address is extracted from the source address sentence, and, using the destination address sentence as the destination address；
The source address and the destination address are for determining Data Migration path；
Data Migration path is obtained according to the source address and destination address.
Fisrt feature word and the first closing in the determination path statement in one of the embodiments, packet
It includes:
Path word in the path statement and the Feature Words prestored are matched, the fisrt feature word is obtained；
Path word in the path statement and the closing prestored are matched, first closing is obtained.
It is described in one of the embodiments, that the path is obtained according to the fisrt feature word and first closing
Source address sentence in sentence, comprising:
Multiple path words between the fisrt feature word and first closing are extracted, the source address language is obtained
Sentence.
The second feature word and the second closing in the path statement are determined in one of the embodiments, comprising:
Path word in the path statement and the Feature Words prestored are matched, the second feature word is obtained；
Path word in the path statement and the closing prestored are matched, second closing is obtained.
It is described in one of the embodiments, that the path statement is obtained according to the second feature word and the second closing
In destination address sentence, comprising:
Multiple path words between the second feature word and second closing are extracted, the destination address is obtained
Sentence.
It is described in one of the embodiments, to extract source address from the source address sentence, comprising:
Multiple path words in the source address sentence and the Feature Words prestored are matched；
When including the destination path word to match with the Feature Words in the source address sentence, constantly described in extraction
Path word between destination path word and the end mark of the source address sentence, obtains source address substatement, until described
It does not include the destination path word to match with the Feature Words in source address substatement, by the source address substatement, as
The source address.
In one of the embodiments, further include:
The source address and the destination address are stored in the form of text, and record storage path.
A kind of acquisition device in Data Migration path, described device include:
Path statement obtains module, is used for acquisite approachs sentence；
Sentence extraction module, for determining fisrt feature word and the first closing in the path statement, according to described
Fisrt feature word and first closing obtain the source address sentence in the path statement；It determines in the path statement
Second feature word and the second closing obtain the purpose in the path statement according to the second feature word and the second closing
Address sentence；
Movement routine extraction module, for extracting source address from the source address sentence, and, by the destination address
Sentence is as the destination address；
Migration path obtains module, for obtaining Data Migration path according to the source address and destination address.
A kind of computer equipment, including memory and processor, the memory are stored with computer program, the processing
Device realizes following steps when executing the computer program:
To acquisite approachs sentence；
The path statement is split, source address sentence and destination address sentence are obtained；
Source address is extracted from the source address sentence, and, destination address is extracted from the destination address sentence；Institute
Source address and the destination address are stated for determining Data Migration path；
Data Migration path is obtained according to the source address and destination address.
A kind of computer readable storage medium, is stored thereon with computer program, and the computer program is held by processor
Following steps are realized when row:
To acquisite approachs sentence；
The path statement is split, source address sentence and destination address sentence are obtained；
Source address is extracted from the source address sentence, and, destination address is extracted from the destination address sentence；Institute
Source address and the destination address are stated for determining Data Migration path；
Data Migration path is obtained according to the source address and destination address.
The acquisition methods in Data Migration path provided by the invention, to acquisite approachs sentence；It determines in the path statement
Fisrt feature word and the first closing, obtained in the path statement according to the fisrt feature word and first closing
Source address sentence；Determine the second feature word and the second closing in the path statement, according to the second feature word and
Second closing obtains the destination address sentence in the path statement；Source address is extracted from the source address sentence, and,
Using the destination address sentence as the destination address；Data Migration path is obtained according to the source address and destination address,
Source address and destination address can be extracted from path statement automatically, so that it is determined that Data Migration path, when path statement is appointed
When business amount is larger, speed is fast, high-efficient, and accuracy rate is high.
Detailed description of the invention
Fig. 1 is the applied environment figure of the acquisition methods in Data Migration path in one embodiment；
Fig. 2 is the flow diagram of the acquisition methods in Data Migration path in one embodiment；
Fig. 3 is the structural block diagram of the acquisition device in Data Migration path in one embodiment；
Fig. 4 is the internal structure chart of computer equipment in one embodiment；
Fig. 5 is the internal structure chart of computer equipment in another embodiment.
Specific embodiment
In order to make the objectives, technical solutions, and advantages of the present invention clearer, with reference to the accompanying drawings and embodiments, right
The present invention is further elaborated.It should be appreciated that specific embodiment described herein is only used to explain the present invention, not
For limiting the present invention.
The acquisition methods in Data Migration path provided by the invention, can be applied in application environment as shown in Figure 1.Tool
Body, server to acquisite approachs sentence；Server determines fisrt feature word and the first closing in the path statement, according to
The fisrt feature word and first closing obtain the source address sentence in the path statement；Determine the path statement
In second feature word and the second closing, obtained in the path statement according to the second feature word and the second closing
Destination address sentence；Server extracts source address from source address sentence, and, using the destination address sentence as the mesh
Address；Server obtains Data Migration path according to source address and destination address.Wherein, server can use independent service
The server cluster of device either multiple servers composition is realized.
In one embodiment, it as shown in Fig. 2, providing a kind of acquisition methods in Data Migration path, answers in this way
For being illustrated for the server in Fig. 1, comprising the following steps:
Step S201, to acquisite approachs sentence；
Wherein, path statement refers to the sentence handled data, inquiry language specially corresponding with data-base cluster
Speech, for example, facing HQL (Hibernate Query Language) query statement of object completely.Data-base cluster is to utilize
At least two or more database servers constitute a virtual centralized database logical image, provide to client transparent
Data service.
Wherein, path statement is made of multiple path words, includes the source address and mesh of data in multiple path words
Address.
In the specific implementation process, server can obtain corresponding path statement from data-base cluster.
Step S202 determines fisrt feature word and the first closing in the path statement, according to the fisrt feature
Word and first closing obtain the source address sentence in the path statement；Determine the second feature in the path statement
Word and the second closing obtain the destination address language in the path statement according to the second feature word and the second closing
Sentence.
Wherein, source address sentence refer to include data source address sentence, destination address sentence refers to include data
Destination address sentence；Fisrt feature word refer to the associated Feature Words of source address sentence, the first closing refers to and source
The associated Feature Words of address sentence.
In the specific implementation process, there are multiple Feature Words in path statement, different Feature Words represent different behaviors, root
Path statement is split according to Feature Words, so that it may obtain multiple sentences, each sentence carries out different processing to data.
For example, " from ... middle selection " acquisition data are represented, " insertion " represents output data to destination address, " deletion " generation
Table deletes data etc.；
Step S203 extracts source address from source address sentence, and, using the destination address sentence as the purpose
Address.
Wherein, the source address in source address sentence and specific Feature Words are associated, such as source address and specific feature
Word connection.
In the specific implementation process, Feature Words corresponding with source address in source address sentence are inquired, so that it may extraction source
Address.
For example, source address sentence is " select X from A ", wherein " X " represents the data of selection, that source address " A "
It can be inquired according to " from " this Feature Words.
Likewise, the destination address in destination address sentence is also associated with specific other Feature Words, such as purpose
Address and Feature Words corresponding with destination address connection.
In the specific implementation process, Feature Words corresponding with destination address in destination address sentence are inquired, so that it may mention
Take destination address.
For example, destination address sentence is " insert overwrite B ", that destination address " B " can basis
The inquiry of " insert overwrite " this Feature Words.
Step S204 obtains Data Migration path according to source address and destination address.
Wherein, Data Migration path refers to that data move to the destination address after processing from the source address before processing
Path.
In the specific implementation process, there are many different migration paths to possibility between destination address for source address, but determine
Source address and destination address, have determined that the set of all migration paths from source address to destination address.
For example, source address is " A ", destination address is " B ", then the migration path of data is the institute for moving to " B " from " A "
There is the set in path.
In the acquisition methods in above-mentioned Data Migration path, by acquisite approachs sentence, path statement is split, with obtaining source
Location sentence and destination address sentence；Source address is extracted from source address sentence, and, destination is extracted from destination address sentence
Location；Source address and destination address are for determining Data Migration path；Then Data Migration is obtained according to source address and destination address
Path can extract source address and destination address from path statement automatically, so that it is determined that Data Migration path, when path language
It is high-efficient when sentence task amount is larger, and accuracy rate is high.
The fisrt feature word and the first closing in path statement are determined in one of the embodiments, comprising:
Path word in path statement and the Feature Words prestored are matched, fisrt feature word is obtained；
In the specific implementation process, Feature Words associated with source address are prestored in server, it will be in path statement
Multiple path words are matched with the Feature Words prestored respectively, the identical path word of the Feature Words inquired and prestored, as first
Feature Words.
For example, the path word in path statement and " from " that prestores are matched, obtain in the word of path
The position of " from "；" from " that matching is obtained is as fisrt feature word.
Path word in path statement and the closing prestored are matched, the first closing is obtained.
Wherein, closing associated with destination address is prestored in server, by multiple path words in path statement
Language is matched with the closing prestored respectively, the identical path word of the closing inquired and prestored, as the first closing.
In the specific implementation process, after inquiring fisrt feature word, by next path word of fisrt feature word and
At least one closing prestored matches respectively, if the identical path word of the closing for inquiring and prestoring, will with prestore
The identical path word of closing as the first closing, if the identical path word of the closing for not inquiring and prestoring
Language continues to match next path word and the closing prestored, until the matched road of closing for obtaining and prestoring
Diameter word.
For example, the closing progress that next path word of " from " and " delect ", " and ", " on " etc. are prestored
Match, if mismatched, continues next path word path of unmatched path word and " delect ", " and ", " on " etc.
The closing prestored is matched, until getting " delect " conduct for obtaining matching with " delect " matched word
First closing extracts " A " between " from " and " delect ", and " A " is exactly source address sentence.
Likewise, determining the second feature word and the second closing in path statement, comprising:
Path word in path statement and the Feature Words prestored are matched, second feature word is obtained；
In the specific implementation process, Feature Words associated with destination address are prestored in server, it will be in path statement
Multiple path words respectively and the Feature Words matching that prestores, the identical path word of the Feature Words inquired and prestored, as the
Two Feature Words.
For example, the path word in path statement and " the insert overwrite " that prestores are matched, road is obtained
The position of " insert overwrite " in diameter word；" the insert overwrite " that matching is obtained is as second feature
Word.
Path word in path statement and the closing prestored are matched, the second closing is obtained.
In the specific implementation process, after inquiring second feature word, by next path word of second feature word and
At least one closing prestored matches respectively, if the identical path word of the closing for inquiring and prestoring, will with prestore
The identical path word of closing as the second closing, if the identical path word of the closing for not inquiring and prestoring
Language continues to match next path word and the closing prestored, until the matched road of closing for obtaining and prestoring
Diameter word.
In the specific implementation process, the first closing and the second closing may be identical, it is also possible to different.
For example, the position in query path sentence where " insert overwrite ", by " insert overwrite "
As fisrt feature word；Then next path word path of " insert overwrite " and " left join " etc. are prestored
Closing matched, if mismatch, continue next path word path of unmatched path word and " left
The closing that join " etc. is prestored is matched, until obtaining and " left join " matched path word, by " left join "
As the first closing, " B " between " insert overwrite " and " left join " is extracted, " B " is exactly destination address language
Sentence.
The path statement is obtained according to the fisrt feature word and first closing in one of the embodiments,
In source address sentence, comprising:
Multiple path words between the fisrt feature word and first closing are extracted, the source address language is obtained
Sentence.
Specifically, fisrt feature word indicates that source address sentence will start, source address sentence is connected to fisrt feature word
Afterwards；First closing, which refers to, indicates the beginning of next sentence with the associated Feature Words of source address sentence, the first closing,
Namely source address sentence has finished, and the first closing is connected to after source address sentence；Therefore it may only be necessary to inquire the first spy
The position of word and the first closing is levied, multiple path words between fisrt feature word and the first closing are extracted, so that it may
To source address sentence.
In the specific implementation process, there are multiple Feature Words in path statement, different Feature Words represent different behaviors, example
Such as, " select from ", which is represented, obtains data, and " insert overwrite " represents output data to destination address,
" delect ", which is represented, deletes data etc..
For example, path statement are as follows:
“select X from A
delect Y of X
insert overwrite B
left join……”
Then it is determined that the position in path statement where " from ", is used as fisrt feature word for " from "；Determine road
" delect " is used as the first closing by the position in diameter sentence where " delect ".
Determine the second feature word and the second closing in path statement, and extract second feature word and the second closing it
Between multiple path words, obtain destination address sentence.
Likewise, second feature word, which refers to, indicates mesh with the associated Feature Words of destination address sentence, second feature word
Address sentence will start, after destination address sentence is connected to second feature word；Second closing refers to and destination address language
The associated Feature Words of sentence, the second closing indicate that the beginning of next sentence, that is, destination address sentence have finished,
Second closing is connected to after destination address sentence.
Therefore it may only be necessary to inquire the position of second feature word and the second closing, second feature word and closing are extracted
Between multiple path words, so that it may obtain destination address sentence.
Similarly, position " insert overwrite " where is determined in path statement, by " insert
Overwrite " is used as second feature word；It determines in path statement the position where " left join ", " left join " is made
For the second closing, the path word between " insert overwrite " and " left join " is extracted, so that it may obtain purpose
Address sentence.
Source address is extracted from source address sentence in one of the embodiments, comprising:
Multiple path words in source address sentence and the Feature Words prestored are matched.
In the specific implementation process, due in source address sentence may there are also further restriction to source address,
Whether need to inquire in source address sentence further includes having Feature Words.
For example, path statement are as follows:
“select X from……(……from A)
delect Y of X
insert overwrite B
left join……”
So corresponding source address sentence is exactly " ... (... from A) ".
When in source address sentence including the destination path word to match with Feature Words, destination path word is constantly extracted
Path word between the end mark of source address sentence, obtains source address substatement, until not including in source address substatement
The destination path word to match with Feature Words, by source address substatement, as source address.
In the specific implementation process, it when in source address sentence including the destination path word to match with Feature Words, says
There are also the further restrictions to source address for bright source address sentence, therefore, it is necessary to further be split to source address sentence,
The path word between destination path word and the end mark of source address sentence is constantly extracted, source address substatement is obtained, until
It does not include the destination path word to match with Feature Words in source address substatement.
For example, inquiry source address sentence neutralizes " from " phase when source address sentence is " ... (... from A) "
The path word matched further extracts the path word between " from " and end mark, obtains source address substatement " A ", when
When not including the path word to match with " from " in " A ", " A " is used as source address.
The present embodiment describes the case where source address is not attached to owner, wherein owner refers to corresponding with source address
The specific owner of file constantly extracts the end of destination path word and source address sentence when source address is accompanied with owner
Path word between symbol, obtains source address substatement, until not including the mesh to match with Feature Words in source address substatement
Path word is marked, splits source address substatement to obtain owner and source address.
Destination address is extracted from destination address sentence in one of the embodiments, comprising:
By destination address sentence address as a purpose.
In the specific implementation process, due to usually not being further limited to destination address in destination address sentence, because
This, directly by destination address sentence address as a purpose.
For example, obtained destination address sentence is " B ", then directly by the address as a purpose " B ".
Method in one of the embodiments, further include:
Source address and destination address are stored in the form of text, and record storage path.
In the specific implementation process, due to needing to be read out the scheduling document for filling in source address and destination address,
To execute Platform deployment task, therefore, it is necessary to the source addresses got and destination address to store in the form of text, and record storage
Path.
For example, obtain source address " A " and destination address " B ", by the corresponding relationship between " A ", " B " and " A " and " B " with
Textual form storage, and record storage path.
It should be understood that although each step in the flow chart of Fig. 2 is successively shown according to the instruction of arrow, this
A little steps are not that the inevitable sequence according to arrow instruction successively executes.Unless expressly state otherwise herein, these steps
It executes there is no the limitation of stringent sequence, these steps can execute in other order.Moreover, at least part in Fig. 2
Step may include that perhaps these sub-steps of multiple stages or stage are executed in synchronization to multiple sub-steps
It completes, but can execute at different times, the execution sequence in these sub-steps or stage, which is also not necessarily, successively to be carried out,
But it can be executed in turn or alternately at least part of the sub-step or stage of other steps or other steps.
In one of the embodiments, as shown in figure 3, providing a kind of acquisition device in Data Migration path, device packet
It includes:
Path statement obtains module 301, is used for acquisite approachs sentence；
Sentence extraction module 302, for determining fisrt feature word and the first closing in the path statement, according to institute
It states fisrt feature word and first closing obtains source address sentence in the path statement；It determines in the path statement
Second feature word and the second closing, the mesh in the path statement is obtained according to the second feature word and the second closing
Address sentence；
Movement routine extraction module 303, for extracting source address from the source address sentence, and, by the purpose
Address sentence is as the destination address；
Migration path obtains module 304, for obtaining Data Migration path according to source address and destination address.
Sentence extraction module 302 includes: in one of the embodiments,
Fisrt feature word determination unit, for by the path statement path word and the Feature Words that prestore carry out
Match, obtains the fisrt feature word；
First closing determination unit, for by the path statement path word and the closing that prestores carry out
Match, obtains first closing.
Sentence extraction module 302 in one of the embodiments, further include:
Source address sentence acquiring unit, for extracting multiple roads between the fisrt feature word and first closing
Diameter word obtains the source address sentence.
Sentence extraction module 302 in one of the embodiments, further include:
Second feature word determination unit, for by the path statement path word and the Feature Words that prestore carry out
Match, obtains the second feature word；
Second closing determination unit, for by the path statement path word and the closing that prestores carry out
Match, obtains second closing.
Sentence extraction module 302 in one of the embodiments, further include:
Destination address sentence acquiring unit, it is multiple between the second feature word and second closing for extracting
Path word obtains the destination address sentence.
Movement routine extraction module in one of the embodiments, comprising:
Matching unit, for matching multiple path words in source address sentence and the Feature Words prestored；
Source address acquiring unit, for when in source address sentence including the destination path word to match with Feature Words,
The path word between destination path word and the end mark of source address sentence is constantly extracted, source address substatement is obtained, until
It does not include the destination path word to match with Feature Words in source address substatement, by source address substatement, as source address.
In one of the embodiments, further include:
Memory module, for source address and destination address to be stored in the form of text, and record storage path.
In one embodiment, a kind of computer equipment is provided, which can be server, internal junction
Composition can be as shown in Figure 4.The computer equipment include the processor connected by device bus, memory, network interface and
Database.Wherein, the processor of the computer equipment is for providing calculating and control ability.The memory packet of the computer equipment
Include non-volatile memory medium, built-in storage.The non-volatile memory medium is stored with operating device, computer program and data
Library.The built-in storage provides environment for the operation of operating device and computer program in non-volatile memory medium.The calculating
The data that the acquisition of the database of machine equipment migration path for storing data is related to.The network interface of the computer equipment is used for
It is communicated with external terminal by network connection.To realize a kind of Data Migration path when the computer program is executed by processor
Acquisition methods.
In one embodiment, a kind of computer equipment is provided, which can be terminal, internal structure
Figure can be as shown in Figure 5.The computer equipment includes processor, the memory, network interface, display connected by system bus
Screen and input unit.Wherein, the processor of the computer equipment is for providing calculating and control ability.The computer equipment is deposited
Reservoir includes non-volatile memory medium, built-in storage.The non-volatile memory medium is stored with operating system and computer journey
Sequence.The built-in storage provides environment for the operation of operating system and computer program in non-volatile memory medium.The calculating
The network interface of machine equipment is used to communicate with external terminal by network connection.When the computer program is executed by processor with
Realize a kind of acquisition methods in Data Migration path.The display screen of the computer equipment can be liquid crystal display or electronic ink
Water display screen, the input unit of the computer equipment can be the touch layer covered on display screen, be also possible to computer equipment
Key, trace ball or the Trackpad being arranged on shell can also be external keyboard, Trackpad or mouse etc..
It will be understood by those skilled in the art that structure shown in Fig. 4-5, only part relevant to the present invention program
The block diagram of structure, does not constitute the restriction for the computer equipment being applied thereon to the present invention program, and specific computer is set
Standby may include perhaps combining certain components or with different component layouts than more or fewer components as shown in the figure.
In one embodiment, a kind of computer equipment, including memory and processor are provided, is stored in memory
Computer program, the processor perform the steps of to acquisite approachs sentence when executing computer program；Determine the path statement
In fisrt feature word and the first closing, the path statement is obtained according to the fisrt feature word and first closing
In source address sentence；The second feature word and the second closing in the path statement are determined, according to the second feature word
The destination address sentence in the path statement is obtained with the second closing；Source address is extracted from the source address sentence, with
And using the destination address sentence as the destination address；Data Migration road is obtained according to the source address and destination address
Diameter.
Processor executes first in determination path statement when computer program in one of the embodiments,
Feature Words and the first closing, comprising: the path word in the path statement and the Feature Words prestored are matched, obtained
The fisrt feature word；Path word in the path statement and the closing prestored are matched, obtain described first
Closing.
Processor executes described according to the fisrt feature word and described when computer program in one of the embodiments,
First closing obtains the source address sentence in the path statement, comprising: extracts the fisrt feature word and first knot
Multiple path words between beam word, obtain the source address sentence.
The second feature in the path statement is determined when processor executes computer program in one of the embodiments,
Word and the second closing, comprising: the path word in the path statement and the Feature Words prestored are matched, obtained described
Second feature word；Path word in the path statement and the closing prestored are matched, obtaining described second terminates
Word.
Processor executes described according to the second feature word and second when computer program in one of the embodiments,
Closing obtains the destination address sentence in the path statement, comprising: extracting the second feature word and described second terminates
Multiple path words between word, obtain the destination address sentence.
In one of the embodiments, processor execute computer program when described in from the source address sentence extraction source
Address, comprising: match multiple path words in the source address sentence and the Feature Words prestored；When the source address
When including the destination path word to match with the Feature Words in sentence, the destination path word and the source are constantly extracted
Path word between the end mark of address sentence, obtains source address substatement, until not including in the source address substatement
The destination path word to match with the Feature Words, by the source address substatement, as the source address.
When processor executes computer program in one of the embodiments, further include: by the source address and the mesh
Address store in the form of text, and record storage path.
In one embodiment, a kind of computer readable storage medium is provided, computer program is stored thereon with, is calculated
Machine program performs the steps of to acquisite approachs sentence when being executed by processor；Determine the fisrt feature word in the path statement
With the first closing, the source address language in the path statement is obtained according to the fisrt feature word and first closing
Sentence；The second feature word and the second closing in the path statement are determined, according to the second feature word and the second closing
Obtain the destination address sentence in the path statement；Source address is extracted from the source address sentence, and, by the purpose
Address sentence is as the destination address；Data Migration path is obtained according to the source address and destination address.
When computer program is executed by processor in one of the embodiments, in the determination path statement
One Feature Words and the first closing, comprising: the path word in the path statement and the Feature Words prestored are matched, obtained
To the fisrt feature word；By in the path statement path word and the closing that prestores match, obtain described the
One closing.
It is described according to the fisrt feature word and institute when computer program is executed by processor in one of the embodiments,
It states the first closing and obtains source address sentence in the path statement, comprising: extract the fisrt feature word and described first
Multiple path words between closing, obtain the source address sentence.
The second spy in the path statement is determined when computer program is executed by processor in one of the embodiments,
Levy word and the second closing, comprising: the path word in the path statement and the Feature Words prestored are matched, institute is obtained
State second feature word；Path word in the path statement and the closing prestored are matched, second knot is obtained
Beam word.
It is described according to the second feature word and when computer program is executed by processor in one of the embodiments,
Two closings obtain the destination address sentence in the path statement, comprising: extract the second feature word and second knot
Multiple path words between beam word, obtain the destination address sentence.
It is extracted from the source address sentence described in when computer program is executed by processor in one of the embodiments,
Source address, comprising: match multiple path words in the source address sentence and the Feature Words prestored；When the source
When including the destination path word to match with the Feature Words in the sentence of location, the destination path word and described is constantly extracted
Path word between the end mark of source address sentence, obtains source address substatement, does not wrap until in the source address substatement
The destination path word to match with the Feature Words is included, by the source address substatement, as the source address.
When computer program is executed by processor in one of the embodiments, further include: by the source address and described
Destination address stores in the form of text, and record storage path.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with
Instruct relevant hardware to complete by computer program, computer program to can be stored in a non-volatile computer readable
It takes in storage medium, the computer program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein, this hair
Any reference used in each embodiment provided by bright to memory, storage, database or other media, may each comprise
Non-volatile and/or volatile memory.Nonvolatile memory may include read-only memory (ROM), programming ROM
(PROM), electrically programmable ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory.Volatile memory may include
Random access memory (RAM) or external cache.By way of illustration and not limitation, RAM is available in many forms,
Such as static state RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double data rate sdram (DDRSDRAM), enhancing
Type SDRAM (ESDRAM), synchronization link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM
(RDRAM), direct memory bus dynamic ram (DRDRAM) and memory bus dynamic ram (RDRAM) etc..
Each technical characteristic of above embodiments can be combined arbitrarily, for simplicity of description, not to above-described embodiment
In each technical characteristic it is all possible combination be all described, as long as however, the combination of these technical characteristics be not present lance
Shield all should be considered as described in this specification.
Only several embodiments of the present invention are expressed for above embodiments, and the description thereof is more specific and detailed, but can not
Therefore it is construed as limiting the scope of the patent.It should be pointed out that for those of ordinary skill in the art,
Under the premise of not departing from present inventive concept, various modifications and improvements can be made, and these are all within the scope of protection of the present invention.
Therefore, the scope of protection of the patent of the invention shall be subject to the appended claims.
Claims (10)
1. a kind of acquisition methods in Data Migration path, which is characterized in that the described method includes:
To acquisite approachs sentence；
The fisrt feature word and the first closing in the path statement are determined, according to the fisrt feature word and first knot
Beam word obtains the source address sentence in the path statement；Determine that the second feature word in the path statement and second terminates
Word obtains the destination address sentence in the path statement according to the second feature word and the second closing；
Source address is extracted from the source address sentence, and, using the destination address sentence as the destination address；
Data Migration path is obtained according to the source address and destination address.
2. the method according to claim 1, wherein fisrt feature word in the determination path statement and
First closing, comprising:
Path word in the path statement and the Feature Words prestored are matched, the fisrt feature word is obtained；
Path word in the path statement and the closing prestored are matched, first closing is obtained.
3. the method according to claim 1, wherein described terminate according to the fisrt feature word with described first
Word obtains the source address sentence in the path statement, comprising:
Multiple path words between the fisrt feature word and first closing are extracted, the source address sentence is obtained.
4. the method according to claim 1, wherein determining the second feature word and second in the path statement
Closing, comprising:
Path word in the path statement and the Feature Words prestored are matched, the second feature word is obtained；
Path word in the path statement and the closing prestored are matched, second closing is obtained.
5. the method according to claim 1, wherein described obtain according to the second feature word and the second closing
Take the destination address sentence in the path statement, comprising:
Multiple path words between the second feature word and second closing are extracted, the destination address language is obtained
Sentence.
6. being wrapped the method according to claim 1, wherein described extract source address from the source address sentence
It includes:
Multiple path words in the source address sentence and the Feature Words prestored are matched；
When including the destination path word to match with the Feature Words in the source address sentence, the target is constantly extracted
Path word between path word and the end mark of the source address sentence, obtains source address substatement, until the source
It does not include the destination path word to match with the Feature Words in the substatement of location, by the source address substatement, as described
Source address.
7. the method according to claim 1, wherein further include:
The source address and the destination address are stored in the form of text, and record storage path.
8. a kind of acquisition device in Data Migration path, which is characterized in that described device includes:
Path statement obtains module, is used for acquisite approachs sentence；
Sentence extraction module, for determining fisrt feature word and the first closing in the path statement, according to described first
Feature Words and first closing obtain the source address sentence in the path statement；Determine second in the path statement
Feature Words and the second closing obtain the destination address in the path statement according to the second feature word and the second closing
Sentence；
Movement routine extraction module, for extracting source address from the source address sentence, and, by the destination address sentence
As the destination address；
Migration path obtains module, for obtaining Data Migration path according to the source address and destination address.
9. a kind of computer equipment, including memory and processor, the memory are stored with computer program, feature exists
In the step of processor realizes any one of claims 1 to 7 the method when executing the computer program.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program
The step of method described in any one of claims 1 to 7 is realized when being executed by processor.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910295665.2A CN110134664A (en) | 2019-04-12 | 2019-04-12 | Acquisition methods, device and the computer equipment in Data Migration path |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910295665.2A CN110134664A (en) | 2019-04-12 | 2019-04-12 | Acquisition methods, device and the computer equipment in Data Migration path |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110134664A true CN110134664A (en) | 2019-08-16 |
Family
ID=67569773
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910295665.2A Pending CN110134664A (en) | 2019-04-12 | 2019-04-12 | Acquisition methods, device and the computer equipment in Data Migration path |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110134664A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111177482A (en) * | 2019-12-30 | 2020-05-19 | 浪潮(北京)电子信息产业有限公司 | Method, device and equipment for parallel processing of graph data and readable storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105068989A (en) * | 2015-07-23 | 2015-11-18 | 中国测绘科学研究院 | Place name and address extraction method and apparatus |
| CN108628811A (en) * | 2018-04-10 | 2018-10-09 | 北京京东尚科信息技术有限公司 | The matching process and device of address text |
-
2019
- 2019-04-12 CN CN201910295665.2A patent/CN110134664A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105068989A (en) * | 2015-07-23 | 2015-11-18 | 中国测绘科学研究院 | Place name and address extraction method and apparatus |
| CN108628811A (en) * | 2018-04-10 | 2018-10-09 | 北京京东尚科信息技术有限公司 | The matching process and device of address text |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111177482A (en) * | 2019-12-30 | 2020-05-19 | 浪潮(北京)电子信息产业有限公司 | Method, device and equipment for parallel processing of graph data and readable storage medium |
| CN111177482B (en) * | 2019-12-30 | 2022-04-22 | 浪潮(北京)电子信息产业有限公司 | Method, device and equipment for parallel processing of graph data and readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110442603B (en) | Address matching method, device, computer equipment and storage medium | |
| CN108446116A (en) | Generation method, device, computer equipment and the storage medium of the application program page | |
| CN109165266A (en) | List generation method, device, computer equipment and storage medium | |
| CN109918586A (en) | Short link jump method, device, short linked server and storage medium | |
| CN109446173A (en) | Daily record data processing method, device, computer equipment and storage medium | |
| CN109542412A (en) | Interface message generation method, device, computer equipment and storage medium | |
| CN108804159A (en) | Javascript module loadings method and its preprocess method, device and computer equipment | |
| CN109597618B (en) | Program development method, program development device, computer device, and storage medium | |
| CN108874661A (en) | Test mapping relations library generating method, device, computer equipment and storage medium | |
| CN108241676A (en) | Realize the method and apparatus that data synchronize | |
| CN109361628A (en) | Message assemble method, device, computer equipment and storage medium | |
| CN110019644B (en) | Search method, apparatus and computer-readable storage medium in dialog implementation | |
| US8397217B2 (en) | Integrating templates into tests | |
| CN109408644A (en) | Knowledge base update method, apparatus, computer equipment and storage medium | |
| CN104283947A (en) | Java script dynamic consolidated server and work process thereof | |
| US8196093B2 (en) | Apparatus and method for componentizing legacy system | |
| CN106990974B (en) | APP updating method and device and electronic equipment | |
| CN110134664A (en) | Acquisition methods, device and the computer equipment in Data Migration path | |
| CN109213775A (en) | Searching method, device, computer equipment and storage medium | |
| CN115994085A (en) | Code coverage rate test processing method, device, equipment and storage medium | |
| CN109614325A (en) | A kind of method and device, electronic equipment and the storage medium of determining control property | |
| CN111240790B (en) | Multi-language adaptation method, device, client and storage medium for application | |
| CN110659022B (en) | Method for automatically calling Python script based on Java | |
| CN117234582A (en) | Project code processing method and device, electronic equipment and storage medium | |
| US10540157B2 (en) | Systems to remove object relational mappings from a software project |
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 |