CN107784068A - Acquisition methods, device, storage medium, processor and the service end of data variation - Google Patents
Acquisition methods, device, storage medium, processor and the service end of data variation Download PDFInfo
- Publication number
- CN107784068A CN107784068A CN201710781094.4A CN201710781094A CN107784068A CN 107784068 A CN107784068 A CN 107784068A CN 201710781094 A CN201710781094 A CN 201710781094A CN 107784068 A CN107784068 A CN 107784068A
- Authority
- CN
- China
- Prior art keywords
- request message
- data variation
- time point
- terminal
- query result
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- 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/23—Updating
- G06F16/2358—Change logging, detection, and notification
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of acquisition methods of data variation, device, storage medium, processor and service end.This method includes：Receive and come from the request message of terminal, wherein, request message is used to obtain in service end one or more databases from first time point to the data variation occurred between the second time point；Data variation is inquired about according to request message, obtains Query Result；Query Result is back to terminal.The present invention solves in correlation technique time and effort consuming, technical problem less efficient, accuracy is poor by way of data variation in artificial enquiry database.
Description
Technical field
The present invention relates to computer realm, is situated between in particular to a kind of acquisition methods of data variation, device, storage
Matter, processor and service end.
Background technology
At present, in software development process, exploitation and Test Engineer usually require to be informed in special time section exactly
The data variation being stored on point in database.In order to realize this target, exploitation and Test Engineer generally require to first pass through
Various database client ending tools initiate connection to access each database, then by writing and performing SQL
(Structured Query Language, referred to as SQL) sentence inquires the specific data variation occurred in database.So
And there is following drawback in aforesaid operations mode：
(1) it is inefficient.For example, if multiple tables of data on multiple database instances change, then engineer
Need to establish from different database instances and connect, then write different SQL statements again and go to access tables of data to inquire about data
Change, time and effort consuming and less efficient.
(2) easily omit.For example, when multiple tables of data change, engineer probably forgets to check certain number
Bug be present according to table, or program, have modified data in the tables of data that this should not be changed, but engineer does not send out but in time
It is existing.
(3) it is difficult to the order for knowing data variation.Needing to verify the order that the data in multiple tables of data change
When, because the speed of computer is very fast, therefore, timely verification is difficult to using manual type.
(4) when having data on stock in database, it is generally difficult to differentiate the true scope of data variation using manual type.
For example, including tens of thousands of row data in a tables of data, which data is specifically inserted actually, and which data which have modified
Several fields, which data is deleted, only rely on manual type and be difficult to accurately confirm.
For it is above-mentioned the problem of, not yet propose effective solution at present.
The content of the invention
At least part embodiment of the present invention provides a kind of acquisition methods of data variation, device, storage medium, processor
And service end, time and effort consuming, efficiency in a manner of at least solving in correlation technique by data variation in artificial enquiry database
Technical problem relatively low, accuracy is poor.
According to a wherein embodiment of the invention, there is provided a kind of acquisition methods of data variation, including：
The request message for coming from terminal is received, wherein, request message is used to obtain one or more data in service end
Storehouse is from first time point to the data variation occurred between the second time point；Data variation is inquired about according to request message, looked into
Ask result；Query Result is back to terminal.
Alternatively, before reception comes from the request message of terminal, in addition to：Receive come from terminal match somebody with somebody confidence
Breath, wherein, configuration information includes：The identification information of the one or more database instances generated in service end；According to configuration
Information determines that one or more database instances are in connection status.
Alternatively, after reception comes from the request message of terminal, in addition to：The parameter carried in request message is believed
Breath is verified, wherein, parameter information includes：First time point, the second time point, data variation configured information；To request
In the case of message verification successfully, request message is split as according to database instance corresponding to data variation configured information multiple
Inquiry request, wherein, each requesting query request corresponds to different database instances respectively.
Alternatively, data variation is inquired about according to request message, obtaining Query Result includes：Distinguished by each inquiry request
Data access daily record is obtained to corresponding database instance；Extraction and each database are real from the data access daily record got
Data variation information corresponding to example；The data variation information extracted is converted into the second preset format from the first preset format,
Obtain Query Result.
Alternatively, data variation is being inquired about according to request message, after obtaining Query Result, in addition to：By Query Result
The 3rd preset format is converted into from the second preset format.
Alternatively, first time point be by active user terminal start current code test process at the beginning of between point,
Second time point was the time point of terminal initial request messages, wherein, the initiation opportunity of request message includes one below：Terminal
According to active user input control command determine displaying Query Result time point, terminal periodic displaying Query Result when
Between point.
According to a wherein embodiment of the invention, a kind of acquisition device of data variation is additionally provided, including：
First receiving module, the request message of terminal is come from for receiving, wherein, request message is used to obtain service end
Upper one or more databases are from first time point to the data variation occurred between the second time point；Acquisition module, for root
Data variation is inquired about according to request message, obtains Query Result；Feedback module, for Query Result to be back into terminal.
Alternatively, said apparatus also includes：Second receiving module, the configuration information of terminal is come from for receiving, wherein,
Configuration information includes：The identification information of the one or more database instances generated in service end；Determining module, for basis
Configuration information determines that one or more database instances are in connection status.
Alternatively, said apparatus also includes：Correction verification module, for carrying out school to the parameter information carried in request message
Test, wherein, parameter information includes：First time point, the second time point, data variation configured information；Module is split, for right
In the case of request message verification successfully, request message is split as according to database instance corresponding to data variation configured information
Multiple queries are asked, wherein, each requesting query request corresponds to different database instances respectively.
Alternatively, acquisition module includes：Acquiring unit, for real to corresponding database respectively by each inquiry request
Example obtains data access daily record；Extraction unit, for the extraction from the data access daily record got and each database instance
Corresponding data variation information；Processing unit, for the data variation extracted information to be converted into from the first preset format
Two preset formats, obtain Query Result.
Alternatively, said apparatus also includes：Processing module, for Query Result to be converted into the 3rd from the second preset format
Preset format.
Alternatively, first time point be by active user terminal start current code test process at the beginning of between point,
Second time point was the time point of terminal initial request messages, wherein, the initiation opportunity of request message includes one below：Terminal
According to active user input control command determine displaying Query Result time point, terminal periodic displaying Query Result when
Between point.
According to a wherein embodiment of the invention, a kind of storage medium is additionally provided, storage medium includes the program of storage, its
In, equipment performs the acquisition methods of above-mentioned data variation where controlling storage medium when program is run.
According to a wherein embodiment of the invention, a kind of processor is additionally provided, processor is used for operation program, wherein, journey
The acquisition methods of above-mentioned data variation are performed during sort run.
According to a wherein embodiment of the invention, a kind of service end is additionally provided, including：One or more processors, storage
Device, display device and one or more programs, wherein, one or more programs are stored in memory, and are configured
To be performed by one or more processors, the data that one or more programs are used for any one in perform claim requirement 1 to 6 become
The acquisition methods of change.
In at least part embodiment of the present invention, the request message of terminal is come from using reception, the request message is used for
One or more databases are obtained in service end from first time point to the mode of the data variation occurred between the second time point,
Data variation is inquired about according to request message, obtains Query Result；Query Result is back to terminal, it is specific to have reached automatic Display
The purpose of the data variation of specified database example in period, consequently facilitating Developmental Engineer can in software development process
Test job can smoothly be carried out by smoothly carrying out debugging efforts and Test Engineer, improve operating efficiency, and then solve phase
In the technology of pass by way of data variation in artificial enquiry database time and effort consuming, technology less efficient, accuracy is poor
Problem.
Brief description of the drawings
Accompanying drawing described herein is used for providing a further understanding of the present invention, forms the part of the application, this hair
Bright schematic description and description is used to explain the present invention, does not form inappropriate limitation of the present invention.In the accompanying drawings：
Fig. 1 shows a kind of system structure diagram for being used to realize the acquisition methods of data variation；
Fig. 2 is the flow chart according to the sheet wherein acquisition methods of the data variation of an inventive embodiments；
Fig. 3 is the structured flowchart according to the sheet wherein acquisition device of the data variation of an inventive embodiments；
Fig. 4 is the structured flowchart according to the acquisition device of the data variation of this wherein one preferred inventive embodiments.
Embodiment
In order that those skilled in the art more fully understand the present invention program, below in conjunction with the embodiment of the present invention
Accompanying drawing, the technical scheme in the embodiment of the present invention is clearly and completely described, it is clear that described embodiment is only
The embodiment of a part of the invention, rather than whole embodiments.Based on the embodiment in the present invention, ordinary skill people
The every other embodiment that member is obtained under the premise of creative work is not made, it should all belong to the model that the present invention protects
Enclose.
It should be noted that term " first " in description and claims of this specification and above-mentioned accompanying drawing, "
Two " etc. be for distinguishing similar object, without for describing specific order or precedence.It should be appreciated that so use
Data can exchange in the appropriate case, so as to embodiments of the invention described herein can with except illustrating herein or
Order beyond those of description is implemented.In addition, term " comprising " and " having " and their any deformation, it is intended that cover
Cover it is non-exclusive include, be not necessarily limited to for example, containing the process of series of steps or unit, method, system, product or equipment
Those steps or unit clearly listed, but may include not list clearly or for these processes, method, product
Or the intrinsic other steps of equipment or unit.
According to a wherein embodiment of the invention, there is provided a kind of embodiment of the acquisition methods of data variation is, it is necessary to illustrate
, can be held the step of the flow of accompanying drawing illustrates in the computer system of such as one group computer executable instructions
OK, although also, show logical order in flow charts, in some cases, can be with different from order herein
Perform shown or described step.
This method embodiment can perform in the system that terminal and service end are formed.Fig. 1 shows a kind of for realizing
The system structure diagram of the acquisition methods of data variation.As shown in figure 1, terminal can be connected via data network or electronics connects
Service end is connected to, such as：Security server, Resource Server, game server.In a kind of alternative embodiment, above-mentioned terminal can
To be any mobile computing device.Data network connection can be that LAN connects, wide area network connects, Internet connection, or its
The data network connection of his type.Terminal can perform be connected to by a server (such as：Resource Server) or one group
The network service that distributed server performs.Network service is network user service, such as data query.
In specific implementation process, service end can include：First server and second server.Terminal is first to the first clothes
Business device sends access request.First server to access request complete verification and partition after, be sent to second server with
The data variation occurred in the range of specified time on database is obtained, by its format conversion is again then SQL forms, wherein,
Binlog2sql instruments are installed on two servers, for parsing binary log (binlog), the binlog2sql instrument energy
Enough core-logs by wide area information server software systems (binlog, it comprises all access to database and parameter)
Be converted to SQL forms.Then, Query Result is back to terminal by second server via first server.Finally, terminal is right again
Query Result is formatted processing, so that it is complete and is presented to engineer in an orderly manner, and then largely improves
Debugging and the operating efficiency of test.
It should be noted that the distributed structure/architecture of above-mentioned first server and second server can also be replaced with first
Server and the function of realization needed for second server merge into same server.
Under above-mentioned running environment, this application provides the acquisition methods of data variation as shown in Figure 2.Fig. 2 is basis
The flow chart of the sheet wherein acquisition methods of the data variation of an inventive embodiments, as shown in Fig. 2 this method comprises the following steps：
Step S22, receive and come from the request message of terminal, wherein, request message be used to obtain in service end one or
Multiple databases are from first time point to the data variation occurred between the second time point；
Step S25, data variation is inquired about according to request message, obtains Query Result；
Step S27, Query Result is back to terminal.
By above-mentioned steps, the request message for receiving and coming from terminal can be used, the request message, which is used to obtain, to be serviced
One or more databases are from first time point to the mode of the data variation occurred between the second time point on end, according to request
Information query data variation, obtains Query Result；Query Result is back to terminal, reached in automatic Display special time period
The purpose of the data variation of specified database example, consequently facilitating Developmental Engineer can smoothly carry out in software development process
Debugging efforts and Test Engineer can smoothly carry out test job, improve operating efficiency, and then solve in correlation technique
Time and effort consuming, technical problem less efficient, accuracy is poor by way of data variation in artificial enquiry database.
Above-mentioned database instance can be understood as one group of background process/thread and a shared section key.In service end
Multiple database instances can be run, different database instances corresponds to different ports respectively.Each database instance internal memory
The data of storage are relatively independent, and a database instance can correspond to multiple databases, and a database can correspond to multiple data
Table.Each database instance can load within life cycle and open a database.
Alternatively, in step S22, before reception comes from the request message of terminal, step performed below can also be included：
Step S20, the configuration information for coming from terminal is received, wherein, configuration information includes：One generated in service end
The identification information of individual or multiple database instances；
Step S21, determine that one or more database instances are in connection status according to configuration information.
Terminal can provide a user interactive interface, in order to the relevant information of each database instance of user configuration, its
It can include but is not limited to：Title, Internet protocol (IP) address, port, username and password.
First server receives the configuration information for coming from terminal and stored, and is then tested according to configuration information each
Connectedness between individual database instance.If connection can not be realized by storing one or more database instances, returned to terminal
Failure prompt message is returned, is used to checking and changing configuration information with prompting.
During being preferable to carry out, above-mentioned first time point is to start current code test process in terminal by active user
At the beginning of between point, the second time point was the time point of terminal initial request messages, wherein, the initiation opportunity of request message includes
One below：The control command that terminal inputs according to active user determines the time point of displaying Query Result, terminal periodic exhibition
Show the time point of Query Result.
START button can be set on interactive interface, and when user clicks on START button, terminal can record automatically
Start the time point of test (equivalent to above-mentioned first time point).Terminal needs to verify its connection between first server
Property.If connection can not be realized between terminal and first server, need to show failure prompt message in interactive interface, to carry
Show that user checks configuration information.
In addition, the end time of database change can be obtained (equivalent to above-mentioned second time point) by following two modes
：
Mode one, " display data change " button is configured in above-mentioned interactive interface, after user clicks on this button, can touched
Send out request message above-mentioned, and the time for clicking on this button can be registered as the end time of database change.
Mode two, at interval of preset duration (such as：15 seconds) trigger above-mentioned request message when, whenever the knot of preset duration
When beam time point reaches, the end time point is recorded as to the end time of database change.
Alternatively, in step S22, after reception comes from the request message of terminal, step performed below can also be included：
Step S23, the parameter information carried in request message is verified, wherein, parameter information includes：The very first time
Point, the second time point, data variation configured information；
Step S24, in the case of to request message verification successfully, according to database corresponding to data variation configured information
Request message is split as multiple queries request by example, wherein, it is real that each requesting query request corresponds to different databases respectively
Example.
Terminal sends request message to first server, wherein, the request message is used to obtain one or more databases
The data variation of example, the parameter information carried in request message can include but is not limited to：Active user, database change
End time of the time started (the i.e. above-mentioned time point for starting test) with database change, data variation configured information (including：
The list of the database instance of acquisition change is needed, specifies and need the database instance excluded and tables of data).Such as：User
Wish to check database instance A database B tables of data C, then, it is necessary to enter to the global database delta data got
Row screening, incoherent data just will not be back to terminal from first server.
First server receives and checking request message.That is, first server needs to confirm to carry in the request message
Completely, accurate parameter information, if parameter information is imperfect or inaccurate, such request message can be regarded as illegally
Message.Such as：Do not carried in request message database change at the beginning of between and/or database change end time；
Or at the beginning of changing with database between corresponding content should fill in the time type information, it is but actually corresponding
It is literal type information.
Further, the database change of above-mentioned request message institute acquisition request can be related to multiple database instances, and
Request message is disposably to be sent from terminal to first server again.Therefore, first server is needed according to each database
Example corresponds to the principle of an inquiry request respectively, and the inquiry that request message is split as to multiple access disparate databases examples please
Ask to access the binlog2sql-api in second server, wherein, binlog2sql-api is in the existing work(of binlog2sql
On the basis of energy provide one can by terminal interactive interface (such as：Webpage client) interface that can access.
Alternatively, in step s 25, according to request message inquire about data variation, obtain Query Result can include it is following
Perform step：
Step S251, data access daily record is obtained to corresponding database instance by each inquiry request respectively；
Step S252, data variation letter corresponding with each database instance is extracted from the data access daily record got
Breath；
Step S253, the data variation information extracted is converted into the second preset format from the first preset format, obtained
Query Result.
Binlog2sql-api often receives an inquiry request and the request will be verified, and after the validation will
Request is transmitted to binlog2sql.Checking herein is primarily to ensure to include necessary parameter letter in each inquiry request
Breath.
Further, binlog2sql obtains database to corresponding database instance respectively according to each inquiry request and become
Change information, to obtain the data access daily record binlog of database instance.Binlog2sql is formatted processing to binlog,
So as in numerous and diverse extracting data stipulated time section for being provided from binlog (i.e. between at the beginning of database changes and data
Storehouse change end time between period) database change information, the database change information that then will be got again
SQL forms are converted into by text formatting.Finally, Query Result is returned to binlog2sql-api by binlog2sql.
Query Result is returned to first server by binlog2sql-api again.
Alternatively, in step S25, data variation is inquired about according to request message, after obtaining Query Result, can also be included
Step performed below：
Step S26, Query Result is converted into the 3rd preset format from the second preset format.
First server is formatted processing to Query Result and then returned after being verified to Query Result
Back to terminal.Partial information in the database change information of SQL forms is mainly converted into by formatting here to be easy to use
The information that family is read, such as：Temporal information in database change information is converted into the daily when layout for being available for user's identification
Formula.
Terminal-pair Query Result, which is formatted, to be handled and is presented to user by interactive interface, has thus reached following skill
Art effect：
(1) all database changes automatic Display in the same page, goes to write SQL pin one by one again without user
Sheet and access database instance.
(2) all database change is intactly shown, and thus avoid missing data table or data item.
(3) change of database is shown sequentially in time, and user is it can be clearly understood that the priority of database change is suitable
Order relation.
(4) total data change, which can significantly be set out, comes, and clearly distinguishes and come with historical data, is easy to
User checks whether this data variation meets expection exactly.Such as：Historical data and use are shown using the first color
Second color shows latest data, or, historical data is shown in first area and shows latest data in second area.
The formatting processing carried out herein is mainly used in determining the exhibition method of database change, so that displaying content is tried one's best
Attractive in appearance and saving space.
According to a wherein embodiment of the invention, a kind of embodiment of the acquisition device of data variation is additionally provided, Fig. 3 is root
According to the structured flowchart of the sheet wherein acquisition device of the data variation of an inventive embodiments, as shown in figure 3, the device includes：First
Receiving module 10, the request message of terminal is come from for receiving, wherein, request message is used to obtain in service end one or more
Individual database is from first time point to the data variation occurred between the second time point；Acquisition module 20, for being disappeared according to request
Breath inquiry data variation, obtains Query Result；Feedback module 30, for Query Result to be back into terminal.
Alternatively, Fig. 4 be according to the structured flowchart of the acquisition device of the data variation of this wherein one preferred inventive embodiments,
As shown in figure 4, said apparatus can also include：Second receiving module 40, the configuration information of terminal is come from for receiving, its
In, configuration information includes：The identification information of the one or more database instances generated in service end；Determining module 50, use
In determining that one or more database instances are in connection status according to configuration information.
Alternatively, as shown in figure 4, said apparatus can also include：Correction verification module 60, for carrying in request message
Parameter information is verified, wherein, parameter information includes：First time point, the second time point, data variation configured information；Tear open
Sub-module 70, it is real according to database corresponding to data variation configured information in the case of to request message verification successfully
Request message is split as multiple queries request by example, wherein, each requesting query request corresponds to different database instances respectively.
Alternatively, acquisition module 20 includes：Acquiring unit (not shown), for by each inquiry request respectively to
Corresponding database instance obtains data access daily record；Extraction unit (not shown), for from the data access got
Data variation information corresponding with each database instance is extracted in daily record；Processing unit (not shown), for that will extract
To data variation information be converted into the second preset format from the first preset format, obtain Query Result.
Alternatively, as shown in figure 4, said apparatus can also include：Processing module 80, for Query Result is pre- from second
If format conversion is the 3rd preset format.
Alternatively, first time point be by active user terminal start current code test process at the beginning of between point,
Second time point was the time point of terminal initial request messages, wherein, the initiation opportunity of request message includes one below：Terminal
According to active user input control command determine displaying Query Result time point, terminal periodic displaying Query Result when
Between point.
The embodiments of the present invention are for illustration only, do not represent the quality of embodiment.
In the above embodiment of the present invention, the description to each embodiment all emphasizes particularly on different fields, and does not have in some embodiment
The part of detailed description, it may refer to the associated description of other embodiment.
In several embodiments provided herein, it should be understood that disclosed technology contents, others can be passed through
Mode is realized.Wherein, device embodiment described above is only schematical, such as the division of the unit, Ke Yiwei
A kind of division of logic function, can there is an other dividing mode when actually realizing, for example, multiple units or component can combine or
Person is desirably integrated into another system, or some features can be ignored, or does not perform.Another, shown or discussed is mutual
Between coupling or direct-coupling or communication connection can be INDIRECT COUPLING or communication link by some interfaces, unit or module
Connect, can be electrical or other forms.
The unit illustrated as separating component can be or may not be physically separate, show as unit
The part shown can be or may not be physical location, you can with positioned at a place, or can also be distributed to multiple
On unit.Some or all of unit therein can be selected to realize the purpose of this embodiment scheme according to the actual needs.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, can also
That unit is individually physically present, can also two or more units it is integrated in a unit.Above-mentioned integrated list
Member can both be realized in the form of hardware, can also be realized in the form of SFU software functional unit.
If the integrated unit is realized in the form of SFU software functional unit and is used as independent production marketing or use
When, it can be stored in a computer read/write memory medium.Based on such understanding, technical scheme is substantially
The part to be contributed in other words to prior art or all or part of the technical scheme can be in the form of software products
Embody, the computer software product is stored in a storage medium, including some instructions are causing a computer
Equipment (can be personal computer, server or network equipment etc.) perform each embodiment methods described of the present invention whole or
Part steps.And foregoing storage medium includes：USB flash disk, read-only storage (ROM, Read-Only Memory), arbitrary access are deposited
Reservoir (RAM, Random Access Memory), mobile hard disk, magnetic disc or CD etc. are various can be with store program codes
Medium.
Described above is only the preferred embodiment of the present invention, it is noted that for the ordinary skill people of the art
For member, under the premise without departing from the principles of the invention, some improvements and modifications can also be made, these improvements and modifications also should
It is considered as protection scope of the present invention.
Claims (15)
- A kind of 1. acquisition methods of data variation, it is characterised in that including：The request message for coming from terminal is received, wherein, the request message is used to obtain one or more data in service end Storehouse is from first time point to the data variation occurred between the second time point；The data variation is inquired about according to the request message, obtains Query Result；The Query Result is back to the terminal.
- 2. according to the method for claim 1, it is characterised in that receive come from the terminal the request message it Before, in addition to：The configuration information for coming from the terminal is received, wherein, the configuration information includes：One generated in the service end The identification information of individual or multiple database instances；Determine that one or more of database instances are in connection status according to the configuration information.
- 3. according to the method for claim 1, it is characterised in that receive come from the terminal the request message it Afterwards, in addition to：The parameter information carried in the request message is verified, wherein, the parameter information includes：The very first time Point, second time point, data variation configured information；In the case of to request message verification successfully, according to database instance corresponding to the data variation configured information The request message is split as multiple queries request, wherein, it is real that each requesting query request corresponds to different databases respectively Example.
- 4. according to the method for claim 3, it is characterised in that the data variation is inquired about according to the request message, obtained Include to the Query Result：Data access daily record is obtained to corresponding database instance by each inquiry request respectively；Data variation information corresponding with each database instance is extracted from the data access daily record got；The data variation information extracted is converted into the second preset format from the first preset format, obtains the Query Result.
- 5. according to the method for claim 4, it is characterised in that the data variation is being inquired about according to the request message, After obtaining the Query Result, in addition to：The Query Result is converted into the 3rd preset format from second preset format.
- 6. according to the method for claim 1, it is characterised in that the first time point is in the terminal by active user Point between at the beginning of startup current code test process, when second time point is that the terminal initiates the request message Between point, wherein, the initiation opportunity of the request message includes one below：The control that the terminal inputs according to the active user System order determines to show the time point that the time point of the Query Result, the terminal periodic show the Query Result.
- A kind of 7. acquisition device of data variation, it is characterised in that including：First receiving module, the request message of terminal is come from for receiving, wherein, the request message is used to obtain service end Upper one or more databases are from first time point to the data variation occurred between the second time point；Acquisition module, for inquiring about the data variation according to the request message, obtain Query Result；Feedback module, for the Query Result to be back into the terminal.
- 8. device according to claim 7, it is characterised in that described device also includes：Second receiving module, the configuration information of the terminal is come from for receiving, wherein, the configuration information includes：Institute State the identification information of the one or more database instances generated in service end；Determining module, for determining that one or more of database instances are in connection status according to the configuration information.
- 9. device according to claim 7, it is characterised in that described device also includes：Correction verification module, for being verified to the parameter information carried in the request message, wherein, the parameter information bag Include：The first time point, second time point, data variation configured information；Split module, for the request message verification successfully in the case of, according to the data variation configured information pair The request message is split as multiple queries request by the database instance answered, wherein, each requesting query request corresponds to respectively Different database instances.
- 10. device according to claim 9, it is characterised in that the acquisition module includes：Acquiring unit, for obtaining data access daily record to corresponding database instance respectively by each inquiry request；Extraction unit, for extracting data variation letter corresponding with each database instance from the data access daily record got Breath；Processing unit, for the data variation extracted information to be converted into the second preset format from the first preset format, obtain The Query Result.
- 11. device according to claim 10, it is characterised in that described device also includes：Processing module, for the Query Result to be converted into the 3rd preset format from second preset format.
- 12. device according to claim 7, it is characterised in that the first time point is at the end by active user Point between at the beginning of end startup current code test process, second time point are that the terminal initiates the request message Time point, wherein, the initiation opportunity of the request message includes one below：The terminal inputs according to the active user Control command determines to show the time point that the time point of the Query Result, the terminal periodic show the Query Result.
- A kind of 13. storage medium, it is characterised in that the storage medium includes the program of storage, wherein, run in described program When control the storage medium where data variation in equipment perform claim requirement 1 to 6 described in any one acquisition methods.
- A kind of 14. processor, it is characterised in that the processor is used for operation program, wherein, right of execution when described program is run Profit requires the acquisition methods of the data variation described in any one in 1 to 6.
- A kind of 15. service end, it is characterised in that including：One or more processors, memory, display device and one or Multiple programs, wherein, one or more of programs are stored in the memory, and be configured as by one or Multiple computing devices, one or more of programs are used for the data variation described in any one in perform claim requirement 1 to 6 Acquisition methods.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710781094.4A CN107784068A (en) | 2017-09-01 | 2017-09-01 | Acquisition methods, device, storage medium, processor and the service end of data variation |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710781094.4A CN107784068A (en) | 2017-09-01 | 2017-09-01 | Acquisition methods, device, storage medium, processor and the service end of data variation |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107784068A true CN107784068A (en) | 2018-03-09 |
Family
ID=61437821
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710781094.4A Pending CN107784068A (en) | 2017-09-01 | 2017-09-01 | Acquisition methods, device, storage medium, processor and the service end of data variation |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107784068A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109491973A (en) * | 2018-09-25 | 2019-03-19 | 中国平安人寿保险股份有限公司 | Electronic device, declaration form delta data distribution analysis method and storage medium |
| CN111083012A (en) * | 2019-12-18 | 2020-04-28 | 苏州浪潮智能科技有限公司 | Data center switch flow statistical method and equipment |
| CN111163096A (en) * | 2019-12-31 | 2020-05-15 | 江苏满运软件科技有限公司 | Method, device, electronic equipment and storage medium for providing data interface service |
| CN111159244A (en) * | 2019-12-30 | 2020-05-15 | 中消云（北京）物联网科技研究院有限公司 | Data query method and device |
| CN111209292A (en) * | 2019-12-31 | 2020-05-29 | 成都库珀区块链科技有限公司 | Bin data management method, device and system |
| CN112084267A (en) * | 2020-07-29 | 2020-12-15 | 北京思特奇信息技术股份有限公司 | Method for solving global broadcast of distributed database |
| CN112802610A (en) * | 2021-01-31 | 2021-05-14 | 淮航 | Passenger information big data intelligent processing method and device |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105183860A (en) * | 2015-09-10 | 2015-12-23 | 北京京东尚科信息技术有限公司 | Data synchronization method and system |
| CN106559225A (en) * | 2015-09-24 | 2017-04-05 | 百度在线网络技术（北京）有限公司 | The method and apparatus of data calibration |
-
2017
- 2017-09-01 CN CN201710781094.4A patent/CN107784068A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105183860A (en) * | 2015-09-10 | 2015-12-23 | 北京京东尚科信息技术有限公司 | Data synchronization method and system |
| CN106559225A (en) * | 2015-09-24 | 2017-04-05 | 百度在线网络技术（北京）有限公司 | The method and apparatus of data calibration |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109491973A (en) * | 2018-09-25 | 2019-03-19 | 中国平安人寿保险股份有限公司 | Electronic device, declaration form delta data distribution analysis method and storage medium |
| CN111083012A (en) * | 2019-12-18 | 2020-04-28 | 苏州浪潮智能科技有限公司 | Data center switch flow statistical method and equipment |
| CN111083012B (en) * | 2019-12-18 | 2021-10-26 | 苏州浪潮智能科技有限公司 | Data center switch flow statistical method and equipment |
| CN111159244A (en) * | 2019-12-30 | 2020-05-15 | 中消云（北京）物联网科技研究院有限公司 | Data query method and device |
| CN111159244B (en) * | 2019-12-30 | 2024-02-09 | 中消云（北京）物联网科技研究院有限公司 | Data query method and device |
| CN111163096A (en) * | 2019-12-31 | 2020-05-15 | 江苏满运软件科技有限公司 | Method, device, electronic equipment and storage medium for providing data interface service |
| CN111209292A (en) * | 2019-12-31 | 2020-05-29 | 成都库珀区块链科技有限公司 | Bin data management method, device and system |
| CN111163096B (en) * | 2019-12-31 | 2022-03-25 | 贵阳货车帮科技有限公司 | Method, device, electronic equipment and storage medium for providing data interface service |
| CN111209292B (en) * | 2019-12-31 | 2023-08-11 | 成都库珀创新科技有限公司 | Bin data management method, device and system |
| CN112084267A (en) * | 2020-07-29 | 2020-12-15 | 北京思特奇信息技术股份有限公司 | Method for solving global broadcast of distributed database |
| CN112084267B (en) * | 2020-07-29 | 2024-06-07 | 北京思特奇信息技术股份有限公司 | Method for solving global broadcasting of distributed database |
| CN112802610A (en) * | 2021-01-31 | 2021-05-14 | 淮航 | Passenger information big data intelligent processing method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107784068A (en) | Acquisition methods, device, storage medium, processor and the service end of data variation | |
| US11847167B2 (en) | System and method for generation of chat bot system with integration elements augmenting natural language processing and native business rules | |
| US20170279840A1 (en) | Automated event id field analysis on heterogeneous logs | |
| US20180173808A1 (en) | Intent and bot based query guidance | |
| US8527945B2 (en) | Method and system for integrating multiple scripts | |
| EP3814976A1 (en) | Artificial intelligence assisted content authoring for automated agents | |
| CN110276074B (en) | Distributed training method, device, equipment and storage medium for natural language processing | |
| CN103916482A (en) | Data synchronous transmission method based on sqlite | |
| CN101287040A (en) | Action prediction based on interactive history and context between sender and recipient | |
| US20220052976A1 (en) | Answer text processing methods and apparatuses, and key text determination methods | |
| CN104461531B (en) | A kind of implementation method of reporting system SQL | |
| US20190050376A1 (en) | Automatic value formatting based on intrinsic structural semantics | |
| CN107766393A (en) | Information processing method, client and server based on database | |
| CN105512955A (en) | Method and system for assembling modular products | |
| CN111597318A (en) | Method, device and system for executing business task | |
| CN109597739A (en) | Voice log services method and system in human-computer dialogue | |
| CN101202792B (en) | Method and apparatus for processing messages based on relationship between sender and recipient | |
| CN113722020A (en) | Interface calling method, device and computer readable storage medium | |
| US11057320B2 (en) | Operation for multiple chat bots operation in organization | |
| US20090198531A1 (en) | Method and system for discovering dependencies in project plans of distributed system | |
| CN107515866A (en) | A kind of data manipulation method, device and system | |
| CN104657248A (en) | Java thread stack analysis method and system | |
| CN111917848A (en) | Data processing method based on edge computing and cloud computing cooperation and cloud server | |
| US9471650B2 (en) | System and method for contextual workflow automation | |
| CN116701011A (en) | Algorithm service dispatching management system based on rule engine |
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 | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20181211 Address after: Room 1615, Floor 16, Vivian Building, 29 Suzhou Street, Haidian District, Beijing Applicant after: Beijing Mutual Gold New Finance Technology Co., Ltd. Address before: 100080 17th Floor, Yuanwei Building, 29 Suzhou Street, Haidian District, Beijing Applicant before: BEIJING QUNAR SOFTWARE TECHNOLOGY CO., LTD. |
|
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180309 |