CN105989162A - Online data extraction method and apparatus - Google Patents
Online data extraction method and apparatus Download PDFInfo
- Publication number
- CN105989162A CN105989162A CN201510095962.4A CN201510095962A CN105989162A CN 105989162 A CN105989162 A CN 105989162A CN 201510095962 A CN201510095962 A CN 201510095962A CN 105989162 A CN105989162 A CN 105989162A
- Authority
- CN
- China
- Prior art keywords
- standard grade
- data
- reaching
- business
- information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses an online data extraction method and apparatus. The method comprises the steps of firstly, obtaining business data generated in a business development process; secondly, determining online data from the business data according to a preset rule; and finally, extracting the online data. Through the method and apparatus, the time for finishing original manual online data extraction is shortened to be a few minutes from a few hours, a lot of time and efforts of technicians are saved, data errors generated by manual extraction are reduced, the accuracy of online data extraction is ensured, the online efficiency of businesses is greatly improved, and the online success rate of the businesses is greatly increased.
Description
Technical field
The present invention relates to technical field of data processing, in particular, relate to one and reach the standard grade data pick-up
Method and device.
Background technology
Along with the construction of aggregate payment plateform system is the most perfect, this system the most gradually supports more and more
Business.These business relate to multiple industry, and such as, the business hall self-aided terminal of communication operator relates to
Bank card pay (such as: the self-service prepaid mobile phone recharging etc. swiped the card) business；On expressway, traffic police takes mobile POS
The business such as the bank card payment of machine scene fine；The mobile phone whole people pay client and include water for what holder provided
Electricity coal payment, credit card repayment, top up, air ticket purchase, card card transfer accounts etc. all kinds of convenience-for-people
The business of paying；Swipe the card the business such as check in large-scale store, shopping center, the cashier in supermarket.Business development people
Member, after developing above-mentioned business, needs to operate after above-mentioned business is reached the standard grade and could be applied by user.
Traditional business is reached the standard grade operation scheme, predominantly: by the skill being familiar with this business development process
Art personnel, extract data (e.g., the business datum in the various table of data base) of reaching the standard grade by hand, and to extraction
Data of reaching the standard grade test, confirm the accuracy of data of reaching the standard grade and the availability of extraction, to have operated
Business is reached the standard grade.
Traditional business is reached the standard grade operation scheme, owing to data of reaching the standard grade have multiformity and complexity, causes hands
Work extracts data of reaching the standard grade not only to be needed to expend the substantial amounts of time and efforts of technical staff, and is susceptible to data
Omit, greatly have impact on efficiency and success rate that business is reached the standard grade.
Summary of the invention
In view of this, the invention provides one and reach the standard grade data pick-up method and device, to overcome existing skill
Art has multiformity and complexity due to data of reaching the standard grade, causes the manual data of reaching the standard grade that extract not only to need consumption
Take the substantial amounts of time and efforts of technical staff, and be susceptible to data omission, greatly have impact in business
The efficiency of line and the problem of success rate.
For achieving the above object, the present invention provides following technical scheme:
One is reached the standard grade data pick-up method, and described method includes:
Obtain the business datum produced during business development；
Determine, from described business datum, data of reaching the standard grade according to preset rules；
Reach the standard grade described in extraction data.
Preferably, after data of reaching the standard grade described in described extraction, described method also includes:
According to described data genaration SQL SQL script of reaching the standard grade.
Preferably, after data of reaching the standard grade described in described extraction, described method also includes:
According to described data genaration Electronic forms Excel file of reaching the standard grade.
Preferably, described from described business datum, determine that according to preset rules data of reaching the standard grade specifically include:
Obtain the first information of user's input；
Determine that business datum corresponding with the described first information in described business datum is for data of reaching the standard grade.
Preferably, the described first information includes:
The business mould of business development accounts information, business development version number information, business development account association
Any one or more in block message.
One is reached the standard grade data pick-up device, and described device includes:
Acquiring unit, for obtaining the business datum produced during business development；
Reach the standard grade data determination unit, for determining, from described business datum, data of reaching the standard grade according to preset rules；
Extracting unit, be used for extracting described in reach the standard grade data.
Preferably, described device also includes:
First processing unit, for after data of reaching the standard grade described in described extraction, according to described data of reaching the standard grade
Generating structure query language SQL script.
Preferably, described device also includes:
Second processing unit, for after data of reaching the standard grade described in described extraction, according to described data of reaching the standard grade
Generate Electronic forms Excel file.
Preferably, data determination unit of reaching the standard grade described in specifically for:
Obtain the first information of user's input；
Determine that business datum corresponding with the described first information in described business datum is for data of reaching the standard grade.
Preferably, the described first information includes:
The business mould of business development accounts information, business development version number information, business development account association
Any one or more in block message.
Understand via above-mentioned technical scheme, compared with prior art, the invention discloses one and reach the standard grade number
According to abstracting method and device, first, the business datum that acquisition produces during business development, then,
Determine, from described business datum, data of reaching the standard grade, data of finally reaching the standard grade described in extraction according to preset rules.Logical
Cross said method and device, the time needing to take several hours by the original manual data pick-up that carries out reaching the standard grade
Can complete within shortening to a few minutes, save the substantial amounts of time and efforts of technical staff, and decrease
The error in data extracted by hand and produce, it is ensured that the accuracy of data pick-up of reaching the standard grade, and then substantially increase
Reach the standard grade efficiency and the success rate of business.
Accompanying drawing explanation
In order to be illustrated more clearly that the embodiment of the present invention or technical scheme of the prior art, below will be to reality
Execute the required accompanying drawing used in example or description of the prior art to be briefly described, it should be apparent that below,
Accompanying drawing in description is only embodiments of the invention, for those of ordinary skill in the art, not
On the premise of paying creative work, it is also possible to obtain other accompanying drawing according to the accompanying drawing provided.
Fig. 1 is the schematic flow sheet of a kind of data pick-up method of reaching the standard grade disclosed in the embodiment of the present invention；
Fig. 2 is the structural representation of a kind of data pick-up device of reaching the standard grade disclosed in the embodiment of the present invention.
Detailed description of the invention
For the sake of quoting and understanding, the explanation of the technical term being used below, summary of writing a Chinese character in simplified form or abridge
As follows:
SQL:Structured Query Language, SQL.
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out
Clearly and completely describe, it is clear that described embodiment is only a part of embodiment of the present invention, and
It is not all, of embodiment.Based on the embodiment in the present invention, those of ordinary skill in the art are not doing
Go out the every other embodiment obtained under creative work premise, broadly fall into the scope of protection of the invention.
Term " first " in description and claims of this specification and above-mentioned accompanying drawing, " second "
Etc. being for distinguishing similar object, without being used for describing specific order or precedence.Should manage
Solving the term so used can exchange in the appropriate case, this is only to describe in embodiments of the invention
The differentiation mode that the object of same alike result is used when describing.Additionally, term " includes " and " tool
Have " and their any deformation, it is intended that cover non-exclusive comprising, in order to comprise a series of list
Process, method, system, product or the equipment of unit is not necessarily limited to those unit, but can include the most clear
That list to Chu or for intrinsic other unit of these processes, method, product or equipment.
From background technology, prior art has multiformity and complexity due to data of reaching the standard grade, causes
The manual data of reaching the standard grade that extract not only need to expend the substantial amounts of time and efforts of technical staff, and are susceptible to number
According to omission, greatly have impact on efficiency and success rate that business is reached the standard grade.
Reach the standard grade data pick-up method and device to this end, the invention discloses one, first, obtain in business
The business datum produced in development process, then, determine from described business datum according to preset rules on
Line data, data of finally reaching the standard grade described in extraction.By said method and device, by the most manual carrying out
Line data pick-up needs the time taken several hours can complete within shortening to a few minutes, saves skill
The substantial amounts of time and efforts of art personnel, and decrease the error in data extracted by hand and produce, it is ensured that reach the standard grade
The accuracy of data pick-up, and then substantially increase reach the standard grade efficiency and the success rate of business.
By below embodiment, data pick-up method and device of reaching the standard grade disclosed by the invention will be carried out in detail below
Describe in detail bright.
Embodiment one
Refer to accompanying drawing 1, for the schematic flow sheet of a kind of data pick-up method of reaching the standard grade disclosed by the invention.Should
Method specifically includes following steps:
S101: obtain the business datum produced during business development.
Business datum has polytype, divides according to big class, can be divided into: being correlated with of operation flow logic
Data；Protocol information data；Configurations data etc..Divide according to business module, can be divided into: hand over
Easily flow process configuration data, bridge joint flow process configuration data, assembling flow path configuration data, container configuration data,
Communication management configuration data etc..In a word, as long as during business development, it would be preferable to support specifically certain industry
Involved data, referred to as business datum can be normally carried out in business.Above-mentioned business module is comprehensive
Pay the inside definition of plateform system, be the important component part of whole aggregate payment plateform system, according to combining
Close payment platform system built-in function can be divided into: transaction flow module, bridge module, assembling module,
Basic Information Management module etc..
S102: determine, from described business datum, data of reaching the standard grade according to preset rules.
Concrete, the first information of user's input can be obtained, determine in described business datum with described the
Business datum corresponding to one information is data of reaching the standard grade.The first information mentioned here includes business development account
Information, business development version number information, business development account association business module information in any one
Plant or multiple.
Before new business exploitation, business development account, business development version, business development account are associated
Business module initializes, during business development, and the aggregate payment plateform system industry to producing
Business data carry out necessity inspection, to confirm the legitimacy of business datum, and according to the mark of business datum
Automatically business datum is carried out business development account, business development version and the industry of business development account association
The differentiation of business module.After business development completes, this business is reached the standard grade before operation by needs, uses
Upper type from as described in business datum determines data of reaching the standard grade.
S103: data of reaching the standard grade described in extraction.
Extraction described in this step, refers to that aggregate payment plateform system carries out screening and extracts business datum,
Generate effectively, not redundancy, reach the standard grade data exactly.
After data are reached the standard grade in extraction, also can according to data genaration SQL script or the Excel file of reaching the standard grade,
It is supplied to technical staff, to facilitate technical staff that corresponding business function is tested, confirms extraction
The accuracy of data of reaching the standard grade and availability, final operation finishing service is reached the standard grade.
After this business has been reached the standard grade, also business development account, business development version, business can be opened
The business module sending out account association resets, with next development phase to this business or to other
Reaching the standard grade of business operates.
Present embodiment discloses one to reach the standard grade data pick-up method, first, obtain during business development
The business datum produced, then, determines, from described business datum, data of reaching the standard grade according to preset rules,
Reach the standard grade described in rear extraction data.By said method, the original manual data pick-up that carries out reaching the standard grade is needed flower
Take time of several hours shorten to a few minutes within can complete, save technical staff's substantial amounts of time
And energy, and decrease the error in data extracted by hand and produce, it is ensured that the accuracy of data pick-up of reaching the standard grade,
And then substantially increase reach the standard grade efficiency and the success rate of business.
Describing method in detail in the invention described above disclosed embodiment, the method for the present invention can use
The device of various ways realizes, and therefore the invention also discloses a kind of device, concrete enforcement is given below
Example is described in detail.
Embodiment two
Refer to accompanying drawing 2, for the structural representation of a kind of data pick-up device of reaching the standard grade disclosed by the invention.Should
Device specifically includes such as lower unit:
Acquiring unit 11, for obtaining the business datum produced during business development.
Reach the standard grade data determination unit 12, for determining, from described business datum, number of reaching the standard grade according to preset rules
According to.
Extracting unit 13, be used for extracting described in reach the standard grade data.
Above-mentioned reach the standard grade data determination unit 12 specifically for:
Obtain the first information of user's input；
Determine that business datum corresponding with the described first information in described business datum is for data of reaching the standard grade.
The described first information includes:
The business mould of business development accounts information, business development version number information, business development account association
Any one or more in block message.
Described device also includes:
First processing unit, for after data of reaching the standard grade described in described extraction, according to described data of reaching the standard grade
Generating structure query language SQL script.
Or, the second processing unit, for after data of reaching the standard grade described in described extraction, reach the standard grade according to described
Data genaration Electronic forms Excel file.
It should be noted that the concrete function of above-mentioned unit realizes carrying out in embodiment of the method part
Describing in detail, specifically refer to the associated description of embodiment of the method, the present embodiment repeats no more.
In sum:
The invention discloses one to reach the standard grade data pick-up method and device, first, obtain in business development
The business datum produced in journey, then, determines, from described business datum, data of reaching the standard grade according to preset rules,
Finally reach the standard grade data described in extraction.By said method and device, the original manual data that carry out reaching the standard grade are taken out
The time that taking needs to take several hours can complete within shortening to a few minutes, saves technical staff big
The time and efforts of amount, and decrease the error in data extracted by hand and produce, it is ensured that data pick-up of reaching the standard grade
Accuracy, and then substantially increase reach the standard grade efficiency and the success rate of business.
In this specification, each embodiment uses the mode gone forward one by one to describe, and each embodiment stresses
Being the difference with other embodiments, between each embodiment, identical similar portion sees mutually.
For device disclosed in embodiment, owing to it corresponds to the method disclosed in Example, so describing
Fairly simple, relevant part sees method part and illustrates.
Additionally it should be noted that, device embodiment described above is only schematically, wherein said
The unit illustrated as separating component can be or may not be physically separate, shows as unit
The parts shown can be or may not be physical location, i.e. may be located at a place, or also may be used
To be distributed on multiple NE.Some or all of mould therein can be selected according to the actual needs
Block realizes the purpose of the present embodiment scheme.It addition, in the device embodiment accompanying drawing of present invention offer, mould
Annexation between block represents have communication connection between them, specifically can be implemented as one or more
Communication bus or holding wire.Those of ordinary skill in the art are not in the case of paying creative work, i.e.
It is appreciated that and implements.
Through the above description of the embodiments, those skilled in the art is it can be understood that arrive this
Invention can add the mode of required common hardware by software and realize, naturally it is also possible to pass through specialized hardware
Realize including special IC, dedicated cpu, private memory, special components and parts etc..General feelings
Under condition, all functions completed by computer program can realize with corresponding hardware easily, and
And, the particular hardware structure being used for realizing same function can also be diversified, such as analog circuit,
Digital circuit or special circuit etc..But, the most more in the case of software program realize be more
Good embodiment.Based on such understanding, technical scheme is the most in other words to existing skill
The part that art contributes can embody with the form of software product, and this computer software product stores
In the storage medium that can read, such as the floppy disk of computer, USB flash disk, portable hard drive, read only memory (ROM,
Read-Only Memory), random access memory (RAM, Random Access Memory), magnetic
Dish or CD etc., including some instructions with so that computer equipment (can be personal computer,
Server, or the network equipment etc.) perform the method described in each embodiment of the present invention.
In sum, above example only in order to technical scheme to be described, is not intended to limit；
Although being described in detail the present invention with reference to above-described embodiment, those of ordinary skill in the art should
Work as understanding: the technical scheme described in the various embodiments described above still can be modified by it, or to it
Middle part technical characteristic carries out equivalent；And these amendments or replacement, do not make appropriate technical solution
Essence depart from various embodiments of the present invention technical scheme spirit and scope.
Claims (10)
1. a data pick-up method of reaching the standard grade, it is characterised in that described method includes:
Obtain the business datum produced during business development；
Determine, from described business datum, data of reaching the standard grade according to preset rules；
Reach the standard grade described in extraction data.
2. according to the method described in claim 1, it is characterised in that at number of reaching the standard grade described in described extraction
According to afterwards, described method also includes:
According to described data genaration SQL SQL script of reaching the standard grade.
3. according to the method described in claim 1, it is characterised in that at number of reaching the standard grade described in described extraction
According to afterwards, described method also includes:
According to described data genaration Electronic forms Excel file of reaching the standard grade.
4. according to the method described in any one in claims 1 to 3, it is characterised in that described basis is pre-
If rule determines that from described business datum data of reaching the standard grade specifically include:
Obtain the first information of user's input；
Determine that business datum corresponding with the described first information in described business datum is for data of reaching the standard grade.
Method the most according to claim 4, it is characterised in that the described first information includes:
The business mould of business development accounts information, business development version number information, business development account association
Any one or more in block message.
6. a data pick-up device of reaching the standard grade, it is characterised in that described device includes:
Acquiring unit, for obtaining the business datum produced during business development；
Reach the standard grade data determination unit, for determining, from described business datum, data of reaching the standard grade according to preset rules；
Extracting unit, be used for extracting described in reach the standard grade data.
7. according to the device described in claim 6, it is characterised in that described device also includes:
First processing unit, for after data of reaching the standard grade described in described extraction, according to described data of reaching the standard grade
Generating structure query language SQL script.
8. according to the device described in claim 6, it is characterised in that described device also includes:
Second processing unit, for after data of reaching the standard grade described in described extraction, according to described data of reaching the standard grade
Generate Electronic forms Excel file.
9. according to the device described in any one in claim 6～8, it is characterised in that described in reach the standard grade number
According to determine unit specifically for:
Obtain the first information of user's input；
Determine that business datum corresponding with the described first information in described business datum is for data of reaching the standard grade.
Device the most according to claim 9, it is characterised in that the described first information includes:
The business mould of business development accounts information, business development version number information, business development account association
Any one or more in block message.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510095962.4A CN105989162B (en) | 2015-03-04 | 2015-03-04 | online data extraction method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510095962.4A CN105989162B (en) | 2015-03-04 | 2015-03-04 | online data extraction method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105989162A true CN105989162A (en) | 2016-10-05 |
| CN105989162B CN105989162B (en) | 2020-01-31 |
Family
ID=57039516
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510095962.4A Active CN105989162B (en) | 2015-03-04 | 2015-03-04 | online data extraction method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105989162B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106649121A (en) * | 2016-12-28 | 2017-05-10 | 中国银联股份有限公司 | Test result analysis method and apparatus |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050120021A1 (en) * | 2003-12-02 | 2005-06-02 | Microsoft Corporation | Metadata driven intelligent data navigation |
| CN101576849A (en) * | 2008-05-09 | 2009-11-11 | 北京世纪拓远软件科技发展有限公司 | Method for generating test data |
| CN101989305A (en) * | 2010-11-09 | 2011-03-23 | 福州星网视易信息系统有限公司 | Data incremental backup method and system |
| CN102567841A (en) * | 2011-11-23 | 2012-07-11 | 杭州精尚投资管理有限公司 | Project supervision system and method |
| CN103942245A (en) * | 2014-02-19 | 2014-07-23 | 浪潮软件股份有限公司 | Data extracting method based on metadata |
| CN104111879A (en) * | 2014-07-03 | 2014-10-22 | 北京思特奇信息技术股份有限公司 | Automatic program file online method and system |
| CN104572449A (en) * | 2014-12-23 | 2015-04-29 | 中国移动通信集团广东有限公司 | Automatic test method based on case library |
-
2015
- 2015-03-04 CN CN201510095962.4A patent/CN105989162B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050120021A1 (en) * | 2003-12-02 | 2005-06-02 | Microsoft Corporation | Metadata driven intelligent data navigation |
| CN101576849A (en) * | 2008-05-09 | 2009-11-11 | 北京世纪拓远软件科技发展有限公司 | Method for generating test data |
| CN101989305A (en) * | 2010-11-09 | 2011-03-23 | 福州星网视易信息系统有限公司 | Data incremental backup method and system |
| CN102567841A (en) * | 2011-11-23 | 2012-07-11 | 杭州精尚投资管理有限公司 | Project supervision system and method |
| CN103942245A (en) * | 2014-02-19 | 2014-07-23 | 浪潮软件股份有限公司 | Data extracting method based on metadata |
| CN104111879A (en) * | 2014-07-03 | 2014-10-22 | 北京思特奇信息技术股份有限公司 | Automatic program file online method and system |
| CN104572449A (en) * | 2014-12-23 | 2015-04-29 | 中国移动通信集团广东有限公司 | Automatic test method based on case library |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106649121A (en) * | 2016-12-28 | 2017-05-10 | 中国银联股份有限公司 | Test result analysis method and apparatus |
| CN106649121B (en) * | 2016-12-28 | 2019-08-13 | 中国银联股份有限公司 | A kind of test result analysis method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105989162B (en) | 2020-01-31 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107316188A (en) | Payment and settlement method and system are taken in public transport | |
| CN106326248A (en) | A storage method and device for data of databases | |
| CN104333597A (en) | IT online service system and method | |
| CN106980995A (en) | A kind of identification of electronic invoice layout files and checking method and relevant apparatus | |
| CN109636567A (en) | Business handling method, server, storage medium and device based on big data | |
| CN109325845A (en) | A kind of financial product intelligent recommendation method and system | |
| CN108171597A (en) | A kind of bank's billing and accounting system assembly method that fastext is supported to respond and system | |
| CN108446968A (en) | A kind of method, apparatus and terminal device of accounting entry | |
| CN110349035A (en) | Transaction processing system and method | |
| CN115204998A (en) | Account checking method and account checking system based on search and data analysis engine library | |
| CN102968858B (en) | Transaction data backup method in AFC system and transaction terminal | |
| CN110276672A (en) | A kind of account checking method, device, equipment and computer readable storage medium | |
| CN113362162A (en) | Wind control identification method and device based on network behavior data, electronic equipment and medium | |
| CN105989162A (en) | Online data extraction method and apparatus | |
| CN112651733A (en) | Channel route selection method, device, equipment and storage medium | |
| US20040199465A1 (en) | Payment apparatus and method, and money assignment apparatus and method | |
| CN106548562A (en) | The method that self-aided terminal moves back card | |
| CN115063132A (en) | Information processing method, apparatus, device, storage medium, and program product | |
| KR100963926B1 (en) | Method and System for Operating Card for Foreign Tourist and Recording Medium | |
| CN115082179A (en) | Data processing method, device, equipment and storage medium | |
| CN109102381B (en) | Accounting processing method and device | |
| CN112750043A (en) | Business data pushing method and device and server | |
| CN111445330A (en) | Account checking method and device | |
| CN112561674A (en) | Passenger transport income settlement method, device, storage medium and electronic equipment | |
| CN111625458A (en) | Service system testing method, device and equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |