CN105989162B - online data extraction method and device - Google Patents
online data extraction method and device Download PDFInfo
- Publication number
- CN105989162B CN105989162B CN201510095962.4A CN201510095962A CN105989162B CN 105989162 B CN105989162 B CN 105989162B CN 201510095962 A CN201510095962 A CN 201510095962A CN 105989162 B CN105989162 B CN 105989162B
- Authority
- CN
- China
- Prior art keywords
- service
- data
- online
- online data
- business
- 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.)
- Active
Links
Images
Abstract
The invention discloses a online data extraction method and a device, firstly, business data generated in a business development process are obtained, then online data are determined from the business data according to preset rules, and finally the online data are extracted.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a method and a device for extracting online data.
Background
With the gradual improvement of the construction of the comprehensive payment platform system, the system also supports more and more services gradually. The services relate to various industries, such as bank card payment (such as mobile phone recharging for self-service card swiping and the like) services related to a business hall self-service terminal of a communication operator; traffic police take the bank card payment of the field fine of the mobile POS machine on the highway and so on; the mobile phone payment client provides various convenient payment services for cardholders, such as water, electricity and coal payment, credit card payment, mobile phone charge recharging, air ticket purchase, card transfer and the like; and services such as card swiping and order buying at cashier desks of large shopping malls, shopping centers and supermarkets. After the service developer develops the service, the service developer needs to operate the service to be online and then can be applied by the user.
The traditional business online operation scheme mainly comprises: the technicians familiar with the service development process manually extract online data (such as service data in various tables of a database), test the extracted online data, and confirm the accuracy and usability of the extracted online data so as to operate and finish the service online.
According to the traditional business online operation scheme, due to the fact that online data have diversity and complexity, manual extraction of the online data needs to consume a large amount of time and energy of technicians, data omission easily occurs, and the business online efficiency and success rate are greatly influenced.
Disclosure of Invention
In view of this, the present invention provides methods and apparatuses for extracting online data, so as to overcome the problems in the prior art that since online data has diversity and complexity, not only a lot of time and effort are required for technicians to be consumed for manually extracting online data, but also data omission easily occurs, and the efficiency and success rate of online business are greatly affected.
In order to achieve the purpose, the invention provides the following technical scheme:
a method for extracting online data, the method comprising:
acquiring service data generated in a service development process;
determining online data from the service data according to a preset rule;
and extracting the online data.
Preferably, after the extracting the online data, the method further includes:
and generating a Structured Query Language (SQL) script according to the online data.
Preferably, after the extracting the online data, the method further includes:
and generating an electronic form Excel file according to the online data.
Preferably, the determining the online data from the service data according to the preset rule specifically includes:
th information input by a user is obtained;
and determining that the service data corresponding to the th information in the service data is online data.
Preferably, the th message includes:
any or more of service development account information, service development version number information, service module information associated with the service development account.
an online data extraction device, the device comprising:
the system comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring service data generated in the service development process;
the online data determining unit is used for determining online data from the service data according to a preset rule;
and the extraction unit is used for extracting the online data.
Preferably, the apparatus further comprises:
, a processing unit, configured to generate a Structured Query Language (SQL) script according to the online data after the online data is extracted.
Preferably, the apparatus further comprises:
and the second processing unit is used for generating an electronic form Excel file according to the online data after the online data are extracted.
Preferably, the online data determining unit is specifically configured to:
th information input by a user is obtained;
and determining that the service data corresponding to the th information in the service data is online data.
Preferably, the th message includes:
any or more of service development account information, service development version number information, service module information associated with the service development account.
According to the technical scheme, compared with the prior art, the online data extraction method and the device are disclosed, firstly, the business data generated in the business development process are obtained, then the online data are determined from the business data according to the preset rules, and finally the online data are extracted.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.
FIG. 1 is a schematic flow chart of online data extraction methods disclosed in the embodiments of the present invention;
fig. 2 is a schematic structural diagram of kinds of online data extraction devices disclosed in the embodiment of the present invention.
Detailed Description
For the sake of reference and clarity, the descriptions, abbreviations or abbreviations of the technical terms used hereinafter are summarized as follows:
SQL: structured Query Language, Structured Query Language.
The technical solutions in the embodiments of the present invention will be described clearly and completely with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only partial embodiments of of the present invention, rather than all embodiments.
Furthermore, the terms "comprises" and "comprising," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a series of elements of is not necessarily limited to those elements, but may include other elements not expressly listed or inherent to such process, method, article, or apparatus.
As can be seen from the background art, in the prior art, since online data has diversity and complexity, not only a lot of time and effort need to be consumed by technicians to manually extract online data, but also data omission easily occurs, and the efficiency and success rate of online service are greatly affected.
The method and the device can shorten the time of taking several hours for the original manual online data extraction to a few minutes, save a large amount of time and energy of technicians, reduce data errors generated by manual extraction, ensure the accuracy of online data extraction and further greatly improve the online efficiency and the success rate of services.
The method and the device for extracting online data disclosed by the invention are described in detail by the following embodiments.
Example
Referring to fig. 1, a flow chart of online data extraction methods disclosed in the present invention is shown, the method specifically includes the following steps:
s101: and acquiring service data generated in the service development process.
The service data has various types, and can be divided into the following types according to the major classification: data related to business process logic; protocol information data; basic configuration data, etc. According to the service module division, the method can be divided into the following steps: transaction flow configuration data, bridging flow configuration data, assembly flow configuration data, container configuration data, information management configuration data, and the like. In short, the data that can support a specific service to normally develop during the service development process are all referred to as service data. The service module is an internal definition of the comprehensive payment platform system, is an important component of the whole comprehensive payment platform system, and can be divided into the following parts according to the internal functions of the comprehensive payment platform system: the system comprises a transaction flow module, a bridging module, an assembling module, a basic information management module and the like.
S102: and determining online data from the service data according to a preset rule.
Specifically, th information input by a user can be obtained, and the business data corresponding to the th information in the business data is determined to be online data, wherein the th information includes any or more of business development account information, business development version number information, and business module information related to a business development account.
Before new service development, a service development account, a service development version and a service module related to the service development account are initialized, in the process of service development, the comprehensive payment platform system performs necessity check on generated service data to confirm the legality of the service data, and automatically distinguishes the service development account, the service development version and the service module related to the service development account for the service data according to the identification of the service data. After the service development is completed and before the service needs to be subjected to online operation, the online data is determined from the service data by adopting the above mode.
S103: and extracting the online data.
The extraction in the step refers to that the comprehensive payment platform system filters and extracts the service data to generate effective, non-redundant and accurate on-line data.
After the online data is extracted, an SQL script or an Excel file can be generated according to the online data and provided for technicians, so that the technicians can conveniently test corresponding service functions, the accuracy and the availability of the extracted online data are confirmed, and finally the service online is completed through operation.
After the business is online, the business development account, the business development version and the business module related to the business development account can be reset so as to operate the lower development stage of the business or the online operation of other businesses.
The embodiment discloses online data extraction methods, which comprise the steps of firstly obtaining service data generated in the service development process, then determining online data from the service data according to preset rules, and finally extracting the online data.
The method is described in detail in the embodiments disclosed in the invention, and the method can be realized by adopting various forms of devices, so that devices are also disclosed in the invention, and the detailed description is given below by giving specific embodiments.
Example two
Referring to fig. 2, a schematic structural diagram of online data extraction devices disclosed in the present invention is shown, the device specifically includes the following units:
the acquiring unit 11 is configured to acquire service data generated in a service development process.
And an online data determining unit 12, configured to determine online data from the service data according to a preset rule.
An extracting unit 13, configured to extract the online data.
The online data determining unit 12 is specifically configured to:
th information input by a user is obtained;
and determining that the service data corresponding to the th information in the service data is online data.
The th information includes:
any or more of service development account information, service development version number information, service module information associated with the service development account.
The device further comprises:
, a processing unit, configured to generate a Structured Query Language (SQL) script according to the online data after the online data is extracted.
Or, the second processing unit is configured to generate a spreadsheet Excel file according to the online data after the online data is extracted.
It should be noted that, the detailed function implementation of each unit is already described in detail in the method embodiment section, and for details, reference is made to the relevant description of the method embodiment, which is not described again in this embodiment.
In summary, the following steps:
the invention discloses a online data extraction method and a device, firstly, business data generated in a business development process are obtained, then online data are determined from the business data according to preset rules, and finally the online data are extracted.
The embodiments in the present description are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other. The device disclosed by the embodiment corresponds to the method disclosed by the embodiment, so that the description is simple, and the relevant points can be referred to the method part for description.
It should be noted that the above-described embodiments of the apparatus are merely illustrative, and the units illustrated as separate components may or may not be physically separate, and the components displayed as units may or may not be physical units, that is, may be located at , or may be distributed on multiple network units.
It is clear to those skilled in the art from the foregoing description that the present invention can be implemented by software plus necessary general-purpose hardware, and certainly can be implemented by dedicated hardware including application-specific integrated circuit, dedicated CPU, dedicated Memory, dedicated components, etc. , where the functions performed by the computer program can be easily implemented by corresponding hardware, and the specific hardware structure for implementing the same functions as can be various, such as analog circuit, digital circuit, or dedicated circuit, etc. however, for the present invention, the implementation of the software program is more preferable, based on the understanding that the technical solution of the present invention and the portions contributing to the prior art can be embodied in the form of software products stored in a storage medium, such as a floppy disk, a usb disk, a mobile hard disk, a Read-Only-optical disk, a Random Access Memory (RAM), an Access Memory (Access Memory), or a personal computer, such as a personal computer, a network server () for executing the present invention.
In summary, the above embodiments are only used for illustrating the technical solutions of the present invention, and not for limiting the same; although the present invention has been described in detail with reference to the above embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the above embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (6)
1, A method for extracting online data, the method comprising:
acquiring service data generated in a service development process; in the service development process, the comprehensive payment platform system performs necessity check on the generated service data to confirm the legality of the service data, and automatically distinguishes a service development account, a service development version and a service module related to the service development account for the service data according to the identification of the service data;
after the service development is finished and before the service is on-line operated, th information input by a user is obtained, wherein the th information comprises any or more of service development account information, service development version number information and service module information related to a service development account;
determining that the service data corresponding to the th information in the service data is online data;
and extracting the online data through a comprehensive payment platform system.
2. The method of claim 1, wherein after said extracting said inline data, said method further comprises:
and generating a Structured Query Language (SQL) script according to the online data.
3. The method of claim 1, wherein after said extracting said inline data, said method further comprises:
and generating an electronic form Excel file according to the online data.
The online data extraction device of kinds, characterized by that, the said device includes:
the system comprises an acquisition unit, a processing unit and a processing unit, wherein the acquisition unit is used for acquiring service data generated in the service development process; in the service development process, the comprehensive payment platform system performs necessity check on the generated service data to confirm the legality of the service data, and automatically distinguishes a service development account, a service development version and a service module related to the service development account for the service data according to the identification of the service data;
the system comprises an online data determining unit, a business module determining unit and a business module determining unit, wherein the online data determining unit is used for acquiring th information input by a user after business development is finished and before online operation is carried out on the business, determining that business data corresponding to th information in the business data is online data, and th information comprises any or more of business development account information, business development version number information and business module information related to a business development account;
and the extraction unit is used for extracting the online data through the comprehensive payment platform system.
5. The apparatus of claim 4, further comprising:
, a processing unit, configured to generate a Structured Query Language (SQL) script according to the online data after the online data is extracted.
6. The apparatus of claim 4, further comprising:
and the second processing unit is used for generating an electronic form Excel file according to the online data after the online data are extracted.
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 CN105989162A (en) | 2016-10-05 |
| CN105989162B true 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) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106649121B (en) * | 2016-12-28 | 2019-08-13 | 中国银联股份有限公司 | A kind of test result analysis method and device |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
| CN104572449A (en) * | 2014-12-23 | 2015-04-29 | 中国移动通信集团广东有限公司 | Automatic test method based on case library |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7634478B2 (en) * | 2003-12-02 | 2009-12-15 | Microsoft Corporation | Metadata driven intelligent data navigation |
| CN104111879B (en) * | 2014-07-03 | 2018-04-03 | 北京思特奇信息技术股份有限公司 | A kind of program file automatic wire charging method and system |
-
2015
- 2015-03-04 CN CN201510095962.4A patent/CN105989162B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
| CN104572449A (en) * | 2014-12-23 | 2015-04-29 | 中国移动通信集团广东有限公司 | Automatic test method based on case library |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105989162A (en) | 2016-10-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20210035126A1 (en) | Data processing method, system and computer device based on electronic payment behaviors | |
| CN103279868A (en) | Method and device for automatically identifying fraud order form | |
| CN111062713B (en) | Payment system, method, server device, medium and device | |
| US20120253958A1 (en) | System for generating digital receipts | |
| RU2013101602A (en) | BUYER LOYALTY SYSTEM IN RESTAURANT AND RETAIL NETWORKS USING WEB SERVERS, MOBILE COMMUNICATIONS AND TERMINALS AT THE POINT OF SALES | |
| US10102537B2 (en) | Methods, systems and computer readable media for utilizing payment card transaction data to conduct product price comparisons | |
| CN107239279A (en) | Order data based on electric business class PaaS platform system is obtained and method for pushing | |
| CN110766275A (en) | Data verification method and device, computer equipment and storage medium | |
| CN110033120A (en) | For providing the method and device that risk profile energizes service for trade company | |
| CN106296178A (en) | Method of payment based on NFC and device | |
| CN114418714A (en) | 5G base station operation and maintenance management system and method | |
| US20150120424A1 (en) | Mobile point saving system and method | |
| CN105989162B (en) | online data extraction method and device | |
| CN113609020A (en) | Test case recommendation method and device | |
| CN110704486B (en) | Data processing method, device, system, storage medium and server | |
| CN108280648B (en) | Transaction processing method and server | |
| CN110782310A (en) | Method, device and system for asynchronously acquiring user attribute information from third-party platform | |
| CN116167860A (en) | Account checking processing method and device, electronic equipment and storage medium | |
| CN110390555A (en) | A kind of multi-platform integration internet mall system and distribution method | |
| CN108345948A (en) | Reservation panic buying method, apparatus, server and computer readable storage medium | |
| CN107767173A (en) | A kind of method for promoting ecommerce | |
| CN108256979A (en) | Mobile payment type app control method and device | |
| CN109714381B (en) | Consumption tracking based information pushing method, equipment, storage medium and device | |
| CN102231199A (en) | Method and device for processing transaction information asynchronously | |
| CN112487086A (en) | Data synchronization method and device, electronic equipment and storage medium |
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 |