CN109255108A - Management method, device, computer equipment and the storage medium of pipelined data - Google Patents
Management method, device, computer equipment and the storage medium of pipelined data Download PDFInfo
- Publication number
- CN109255108A CN109255108A CN201810798391.4A CN201810798391A CN109255108A CN 109255108 A CN109255108 A CN 109255108A CN 201810798391 A CN201810798391 A CN 201810798391A CN 109255108 A CN109255108 A CN 109255108A
- Authority
- CN
- China
- Prior art keywords
- flowing water
- bank
- template
- information
- pipelined data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Finance (AREA)
- General Engineering & Computer Science (AREA)
- General Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Accounting & Taxation (AREA)
- Economics (AREA)
- General Business, Economics & Management (AREA)
- Technology Law (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Development Economics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
Provided herein a kind of management method of pipelined data, device, computer equipment and storage medium, obtain the first flowing water information of bank statistics, pipelined data and beacon information are carried in the first flowing water information, the beacon information includes at least Bank Name；According to the beacon information, bank's flowing water template corresponding with the beacon information is selected in the database as target flowing water template；It is stored in the database and the one-to-one bank's flowing water template of the beacon information；The pipelined data correspondence that the first flowing water information carries is added in the target flowing water template；Management method, device, computer equipment and the storage medium of pipelined data provided herein carry out data analysis comparison convenient for enterprise's reconciliation and to bank's pipelined data of user.
Description
Technical field
This application involves field of computer technology, in particular to a kind of management method of pipelined data, device, computer are set
Standby and storage medium.
Background technique
Generally for different banks, the bank's flowing water template used is not also identical, and is directed to different enterprises, bank
Used bank's flowing water template is not also identical.At present on the market without the tool of unified management different bank flowing water template, no
The flowing water of more banks can be supported to import and configure, different banks is not convenient to use for the pipelined data of different users and is flowed
Water template, it has not been convenient to which user carries out data analysis comparison and enterprise's reconciliation for different banks.
Summary of the invention
The main purpose of the application is that the management method for providing a kind of pipelined data, device, computer equipment and storage are situated between
Matter carries out data analysis comparison convenient for enterprise's reconciliation and to bank's pipelined data of user.
To achieve the above object, this application provides a kind of management methods of pipelined data, comprising the following steps:
The first flowing water information of bank statistics is obtained, carries pipelined data in the first flowing water information and to mark
Information, the beacon information include at least Bank Name；
According to the beacon information, bank's flowing water template corresponding with the beacon information is selected in the database and is made
For target flowing water template；It is stored in the database and the one-to-one bank's flowing water template of the beacon information；
The pipelined data correspondence that the first flowing water information carries is added in the target flowing water template.
Further, the first flowing water information for obtaining bank statistics, carries flowing water in the first flowing water information
Before the step of data and beacon information, the beacon information includes at least Bank Name, comprising:
Storage and the one-to-one bank's flowing water template of the beacon information in the database.
Further, the step stored in the database with the one-to-one bank's flowing water template of the beacon information
Suddenly, comprising:
Bank's flowing water template that user uploads is received, bank's flowing water template of the upload is stored in the database
In, and configure the mapping relations of bank's flowing water template and the beacon information.
Further, the step stored in the database with the one-to-one bank's flowing water template of the beacon information
Suddenly, comprising:
The title bar field of default flowing water template is obtained by preset shell script, and raw according to the title bar field
It is stored in the database at corresponding bank's flowing water template, and configuration bank's flowing water template and the beacon information
Mapping relations.
Further, the pipelined data correspondence that the first flowing water information is carried is added to the target flowing water mould
After step in plate, the method also includes:
In all pipelined datas stored in the target flowing water template of the database, select in the pipelined data
User be designated user target pipelined data, and the target pipelined data is loaded onto same data form.
Further, it in all pipelined datas stored in the target flowing water template of the database, selects
User in the pipelined data is the target pipelined data of designated user, and the target pipelined data is loaded onto same number
After the step in table, the method also includes:
The permission of checking of the data form is configured, and the designated user will be issued to the data form postponed
Corresponding user terminal.
Further, it in all pipelined datas stored in the target flowing water template of the database, selects
User in the pipelined data is the target pipelined data of designated user, and the target pipelined data is loaded onto same number
After the step in table, the method also includes:
From the pipelined data in the data form, the corresponding spending amount in each bank of designated user is obtained, and
Designated user is calculated in the spending amount ratio of each bank.
Present invention also provides a kind of managing devices of pipelined data, comprising:
Acquiring unit carries flowing water in the first flowing water information for obtaining the first flowing water information of bank statistics
Data and beacon information, the beacon information include at least Bank Name；
Selecting unit, for selecting in the database corresponding with the beacon information according to the beacon information
Bank's flowing water template is as target flowing water template；It is stored in the database and is flowed with the one-to-one bank of the beacon information
Water template；
Adding unit, the pipelined data correspondence for carrying the first flowing water information are added to the target flowing water mould
In plate.
The application also provides a kind of computer equipment, including memory and processor, is stored with calculating in the memory
The step of machine program, the processor realizes any of the above-described the method when executing the computer program.
The application also provides a kind of computer storage medium, is stored thereon with computer program, the computer program quilt
The step of processor realizes method described in any of the above embodiments when executing.
Management method, device, computer equipment and the storage medium of pipelined data provided herein have with following
Beneficial effect:
Management method, device, computer equipment and the storage medium of pipelined data provided herein obtain bank's system
First flowing water information of meter carries pipelined data and beacon information in the first flowing water information, and the beacon information is extremely
It less include Bank Name；According to the beacon information, bank's stream corresponding with the beacon information is selected in the database
Water template is as target flowing water template；It is stored in the database and the one-to-one bank's flowing water mould of the beacon information
Plate；The pipelined data correspondence that the first flowing water information carries is added in the target flowing water template；Convenient for enterprise's reconciliation
And data analysis comparison is carried out to bank's pipelined data of user.
Detailed description of the invention
Fig. 1 is the management method step schematic diagram of pipelined data in one embodiment of the application；
Fig. 2 is the management method step schematic diagram of pipelined data in another embodiment of the application；
Fig. 3 is the managing device structural block diagram of pipelined data in one embodiment of the application；
Fig. 4 is the managing device structural block diagram of pipelined data in another embodiment of the application；
Fig. 5 is the structural schematic block diagram of the computer equipment of one embodiment of the application.
The embodiments will be further described with reference to the accompanying drawings for realization, functional characteristics and the advantage of the application purpose.
Specific embodiment
It is with reference to the accompanying drawings and embodiments, right in order to which the objects, technical solutions and advantages of the application are more clearly understood
The application is further elaborated.It should be appreciated that specific embodiment described herein is only used to explain the application, not
For limiting the application.
Referring to Fig.1, this application provides a kind of management methods of pipelined data, comprising the following steps:
Step S1 obtains the first flowing water information of bank statistics, carried in the first flowing water information pipelined data with
And beacon information, the beacon information include at least Bank Name；
Step S2 selects bank's stream corresponding with the beacon information according to the beacon information in the database
Water template is as target flowing water template；It is stored in the database and the one-to-one bank's flowing water mould of the beacon information
Plate；
The pipelined data correspondence that the first flowing water information carries is added in the target flowing water template by step S3.
In the present embodiment, pipelined data is not only comprised only in above-mentioned first flowing water information, further includes having beacon information.
What above-mentioned pipelined data indicated is the flowing water of user, such as takes in how much amount of money, expenditure how much amount of money, a variety of numbers such as expenditure time
According to.Above-mentioned beacon information mainly includes bank ID, User ID, bank ID for indicating specific bank sort, as Bank of China,
China Construction Bank, safety bank etc.；User ID then is used to indicate the identity of user, such as Huawei, Tencent, safety science and technology, a
People user Zhang San etc..Above-mentioned beacon information is convenient for by above-mentioned beacon information to first for indicating above-mentioned first flowing water information
Flowing water information distinguishes.For example, convenient for distinguishing above-mentioned first flowing water information which is according to the bank ID in beacon information
The flowing water information of bank statistics distinguishes which bank's system is above-mentioned first flowing water information be according to User ID and bank ID
Which enterprise of meter or the flowing water information of personal user etc..
Different enterprises or different personal users, corresponding flowing water information are not quite similar, therefore, corresponding bank's stream
Water template also has otherness；For example, same bank can for bank's flowing water template used in Huawei, Liang Jia enterprise of Tencent
With different (can be and be substantially the same, but have small otherness), different bank is for bank used in one enterprise of Huawei
Flowing water template is also different.Therefore, in conjunction with bank ID and the difference of User ID, different bank's flowing water templates can be corresponded to.
The above method is applied to overflow pipe platform, the overflow pipe platform as described in above-mentioned steps S1, in the present embodiment
(the cruel system of wealth) and each bank management system (bank official website) can be provided with mating interface in advance, and correspond to configured with obtaining
The acquisition permission of flowing water information gets the upper of bank statistics convenient for overflow pipe platform automatically from each bank management system
State the first flowing water information.It is understood that above-mentioned first flowing water information is also possible to user manually from each bank management system
The list data downloaded on system, the overflow pipe platform being then uploaded in the present embodiment, overflow pipe platform can
Get the above-mentioned first flowing water information of bank statistics.
As described in above-mentioned steps S2, bank's flowing water corresponding with each beacon information is stored in above-mentioned database
Template, i.e., each the bank's flowing water template stored in database correspond to each beacon information；It is understood that above-mentioned
It is stored with one and the one-to-one bank's flowing water Template Map table of above-mentioned beacon information in database, is believed according to above-mentioned mark
Breath, then can be selected from above-mentioned mapping table with bank's flowing water template corresponding to above-mentioned beacon information, then as
Target flowing water template.A title bar, such as earnings column, payout column, timing node are generally included in above-mentioned target flowing water template
Column etc..
In the present embodiment, according to the difference of bank ID, corresponding to different bank's flowing water templates；In other embodiments,
It can be the difference according to bank ID and the difference of user, corresponding to different bank's flowing water templates.In general, the quantity of bank
Relatively limited, different bank ID, corresponding bank's flowing water template is also relatively limited；And the quantity of user is more, different user ID
Bank's flowing water template number corresponding to corresponding bank is also more, and still, same bank is made for the user of different ID
Template is roughly the same, only has some small differences, therefore above-mentioned bank's flowing water template can be two parts, wherein one
Part is foundation forms, which includes identical title bar (such as earnings column, payout column etc.) in flowing water list；Another portion
Be divided into difference template comprising be in flowing water list with otherness title bar；To modify above-mentioned bank's flowing water template, lead to
Often only need to modify that a part of difference template.
As described in above-mentioned steps S3, the pipelined data correspondence of above-mentioned first flowing water information is added to the target flowing water mould
In plate, for example, specific amount received number is added in the earnings column of the target flowing water template, gold will be specifically paid
Specified number word is added in the earnings column of above-mentioned target flowing water template.In overflow pipe platform in the present embodiment, different bank
Flowing water information can match different bank's flowing water templates, the first flowing water information for adding all bank statistics may be implemented,
And be managed collectively, facilitate user to carry out data analysis comparison for different banks, and be convenient for enterprise's reconciliation.
In the present embodiment, when above-mentioned target flowing water template and above-mentioned beacon information to it is corresponding when the above-mentioned target selected
The content typesetting format of flowing water template is then consistent with original typesetting of above-mentioned first flowing water information.Therefore, by above-mentioned first flowing water
When the pipelined data correspondence of information is added in above-mentioned target flowing water template, then it can not change the flowing water in the first flowing water information
The typesetting of data, and be directly added in above-mentioned target flowing water template by original typesetting, save calculation amount.
Referring to Fig. 2, in one embodiment, the first flowing water information of above-mentioned acquisition bank statistics, the first flowing water information
In carry pipelined data and beacon information, the beacon information includes at least before the step S1 of Bank Name, comprising:
Step S10 is stored and the one-to-one bank's flowing water template of the beacon information in the database.
In the present embodiment, need to be stored with the multiple and one-to-one bank of the beacon information in advance in the database
Flowing water template, after subsequent the first flowing water information for getting bank statistics, the flowing water that will be carried in the first flowing water information
Data be added to in the one-to-one bank's flowing water template of the beacon information.
In one embodiment, above-mentioned to store in the database and the one-to-one bank's flowing water template of the beacon information
Step S10, comprising:
Step S101 receives bank's flowing water template that user uploads, bank's flowing water template of the upload is stored in institute
It states in database, and configures the mapping relations of bank's flowing water template and the beacon information.
Specifically, user (administrator that can be overflow pipe platform) can be from current-carrying water above and below the website of each bank
Template, and be uploaded to overflow pipe platform, overflow pipe platform receive bank's flowing water template of user's upload, and by its
It is stored in the database, and the mapping relations of configuration bank's flowing water template and the beacon information, is convenient for basis
Beacon information matches corresponding bank's flowing water template.Above-mentioned flowing water template is a Microsoft Excel, which has title bar, mark
Frame is selected below topic column for the corresponding pipelined data of input.
In another embodiment, above-mentioned storage in the database and the one-to-one bank's flowing water template of the beacon information
Step S10, comprising:
Step S102 obtains the title bar field of default flowing water template by preset shell script, and according to the mark
Topic column field generates corresponding bank's flowing water template and is stored in the database, and configuration bank's flowing water template and institute
State the mapping relations of beacon information.
In the present embodiment, it from current-carrying water template above and below the website of each bank, is got by preset shell script
The title bar field of flowing water template, and by above-mentioned title bar field according to the corresponding write-in one of type-setting mode of above-mentioned flowing water template
In blank form, a flowing water table is generated, so that the flowing water table is consistent with the typesetting of above-mentioned flowing water template, the flowing water table
Then it is stored in above-mentioned database as above-mentioned bank's flowing water template；Meanwhile configuring bank's flowing water template and the mark
The mapping relations of information, convenient for matching corresponding bank's flowing water template according to beacon information.
In one embodiment, the above-mentioned pipelined data correspondence for carrying the first flowing water information is added to the target stream
After step S3 in water template, the method also includes:
Step S4 in all pipelined datas stored in the target flowing water template of the database, selects the stream
User of the water number in is the target pipelined data of designated user, and the target pipelined data is loaded onto same data form
In.
Due to same user, there may be account in multiple banks, and in the pipelined data of each bank difference.This reality
It applies in example, the first flowing water information of statistics is got from bank, and pipelined data is respectively corresponded and is added to the target flowing water
After in template, the flowing water list of user is generated；Then as described in above-mentioned steps S4, in above-mentioned flowing water list, according to the ID of user
Select all flowing water lists of same designated user, and load it in the same data form, be convenient for comparative analysis,
Calculate spending amount etc.；Such as comparative analysis goes out the user in the spending amount of different bank, judges which bank of user preference
Deng, while the weight proportion consumed in all spending amounts using different bank can also be calculated.For example, in user's first use
The weight proportion of bank of state consumption is 30%, and the use of the weight proportion that safety bank consumes is 70% etc..Or it can also unite
Some month of user is counted out in spending amount, the amount received etc. for passing through each bank.
Therefore, in another embodiment, the above-mentioned all flowing water numbers stored in the target flowing water template of the database
In, the target pipelined data that user in the pipelined data is designated user is selected, and by the target pipelined data
It is loaded onto after the step S4 in same data form, the method also includes:
Step S501 obtains corresponding the disappearing in each bank of designated user from the pipelined data in the data form
Take the amount of money, and calculates designated user in the spending amount ratio of each bank.
In the present embodiment, designated user is calculated in the spending amount ratio of each bank, user, which has, convenient for calculating disappears
Take the weight proportion consumed in the amount of money using different bank, convenient for judging user preference is consumed using which bank.
In one embodiment, in the above-mentioned all pipelined datas stored in the target flowing water template of the database, choosing
The user selected out in the pipelined data is the target pipelined data of designated user, and the target pipelined data is loaded onto together
After step S4 in one data form, the method also includes:
Step S50 configures the permission of checking of the data form, and described by being issued to the data form postponed
User terminal corresponding to designated user.
In the present embodiment, above-mentioned data form is also configured with and checks permission accordingly；For example, to above-mentioned data form text
Part is encrypted, and user correctly enters password and can just check, which can be in advance set by the overflow pipe platform；
User can not open Fileview when inputting password mistake.The above-mentioned data form configured is issued to the user of designated user
Terminal understands oneself in the spending amount of all banks, convenient for the financial management of user convenient for user.It, can be in the present embodiment
The telephone number that user is bound with bank account is got, and extracts the content of text in above-mentioned data form, generates text
Above-mentioned text information is sent to the terminal of user by this information by way of short message.Or it is available to user and silver
Then above-mentioned data form is sent to user by the mailbox that row account is bound by way of mail.
Referring to Fig. 3, a kind of managing device of pipelined data is additionally provided in one embodiment of the application, comprising:
Acquiring unit 10 carries stream in the first flowing water information for obtaining the first flowing water information of bank statistics
Water number is accordingly and beacon information, the beacon information include at least Bank Name；
Selecting unit 20, for selecting in the database corresponding with the beacon information according to the beacon information
Bank's flowing water template as target flowing water template；It is stored in the database and the one-to-one bank of the beacon information
Flowing water template；
Adding unit 30, the pipelined data correspondence for carrying the first flowing water information are added to the target flowing water
In template.
In the present embodiment, pipelined data is not only comprised only in above-mentioned first flowing water information, further includes having beacon information.
What above-mentioned pipelined data indicated is the flowing water of user, such as takes in how much amount of money, expenditure how much amount of money, a variety of numbers such as expenditure time
According to.Above-mentioned beacon information mainly includes bank ID, User ID, bank ID for indicating specific bank sort, as Bank of China,
China Construction Bank, safety bank etc.；User ID then is used to indicate the identity of user, such as Huawei, Tencent, safety science and technology, a
People user Zhang San etc..Above-mentioned beacon information is convenient for by above-mentioned beacon information to first for indicating above-mentioned first flowing water information
Flowing water information distinguishes.For example, convenient for distinguishing above-mentioned first flowing water information which is according to the bank ID in beacon information
The flowing water information of bank statistics distinguishes which bank's system is above-mentioned first flowing water information be according to User ID and bank ID
Which enterprise of meter or the flowing water information of personal user etc..
Different enterprises or different personal users, corresponding flowing water information are not quite similar, therefore, corresponding bank's stream
Water template also has otherness；For example, same bank can for bank's flowing water template used in Huawei, Liang Jia enterprise of Tencent
With different (can be and be substantially the same, but have small otherness), different bank is for bank used in one enterprise of Huawei
Flowing water template is also different.Therefore, in conjunction with bank ID and the difference of User ID, different bank's flowing water templates can be corresponded to.
Above-mentioned apparatus is applied to overflow pipe platform, overflow pipe platform (the cruel system of wealth) and each silver in the present embodiment
Row management system (bank official website) can be provided with mating interface in advance, and configured with the acquisition power for obtaining corresponding flowing water information
Limit, the above-mentioned first flowing water information of bank statistics is got convenient for acquiring unit 10 automatically from each bank management system.It can
With understanding, above-mentioned first flowing water information is also possible to the table that user downloads from each bank management system manually
The acquiring unit 10 of data, the overflow pipe platform being then uploaded in the present embodiment, overflow pipe platform can be got
The above-mentioned first flowing water information of bank statistics.
It is stored with bank's flowing water template corresponding with each beacon information in above-mentioned database, i.e., is deposited in database
Each bank's flowing water template of storage corresponds to each beacon information；It is understood that being stored with one in above-mentioned database
A and one-to-one bank's flowing water Template Map table of above-mentioned beacon information, selecting unit 20 then may be used according to above-mentioned beacon information
With selected from above-mentioned mapping table with bank's flowing water template corresponding to above-mentioned beacon information, then as target flowing water
Template.A title bar, such as earnings column, payout column, timing node column etc. are generally included in above-mentioned target flowing water template.
In the present embodiment, according to the difference of bank ID, corresponding to different bank's flowing water templates；In other embodiments,
It can be the difference according to bank ID and the difference of user, corresponding to different bank's flowing water templates.In general, the quantity of bank
Relatively limited, different bank ID, corresponding bank's flowing water template is also relatively limited；And the quantity of user is more, different user ID
Bank's flowing water template number corresponding to corresponding bank is also more, and still, same bank is made for the user of different ID
Template is roughly the same, only has some small differences, therefore above-mentioned bank's flowing water template can be two parts, wherein one
Part is foundation forms, which includes identical title bar (such as earnings column, payout column etc.) in flowing water list；Another portion
Be divided into difference template comprising be in flowing water list with otherness title bar；To modify above-mentioned bank's flowing water template, lead to
Often only need to modify that a part of difference template.
Finally, the pipelined data correspondence of above-mentioned first flowing water information is added to the target flowing water template by adding unit 30
In, for example, specific amount received number is added in the earnings column of the target flowing water template, by specific amount paid
Number is added in the earnings column of above-mentioned target flowing water template.In overflow pipe platform in the present embodiment, different bank
Flowing water information can match different bank's flowing water templates, and the first flowing water information for adding all bank statistics may be implemented, and
It is managed collectively, facilitates user to carry out data analysis comparison for different banks, and be convenient for enterprise's reconciliation.
In the present embodiment, when above-mentioned target flowing water template and above-mentioned beacon information to it is corresponding when above-mentioned selecting unit 20 select
The content typesetting format for the target flowing water template selected out is then consistent with original typesetting of above-mentioned first flowing water information.Therefore, it adds
When the pipelined data correspondence of above-mentioned first flowing water information is added in above-mentioned target flowing water template by unit 30, then it can not change
The typesetting of pipelined data in first flowing water information, and be directly added in above-mentioned target flowing water template by original typesetting, it saves
Calculation amount.
Referring to Fig. 4, in one embodiment, the managing device of above-mentioned pipelined data further include:
Storage unit 100, for storage in the database and the one-to-one bank's flowing water template of the beacon information.
In the present embodiment, storage unit 100 needs to be stored with the multiple and beacon information one in the database in advance
One corresponding bank's flowing water template, after subsequent the first flowing water information for getting bank statistics, by the first flowing water information
The pipelined data of middle carrying be added to in the one-to-one bank's flowing water template of the beacon information.
In one embodiment, said memory cells 100 include:
First storing sub-units deposit bank's flowing water template of upload for receiving bank's flowing water template of user's upload
It is stored in the database, and configures the mapping relations of bank's flowing water template and the beacon information.
Specifically, user (administrator that can be overflow pipe platform) can be from current-carrying water above and below the website of each bank
Template, and it is uploaded to overflow pipe platform, the first storing sub-units receive bank's flowing water template of user's upload, and will
It is stored in the database, and the mapping relations of configuration bank's flowing water template and the beacon information, is convenient for root
Corresponding bank's flowing water template is matched according to beacon information.Above-mentioned flowing water template is a Microsoft Excel, which has title bar,
Frame is selected below title bar for the corresponding pipelined data of input.
In another embodiment, said memory cells 100 include:
Second storing sub-units, for obtaining the title bar field of default flowing water template by preset shell script, and
It generates corresponding bank's flowing water template according to the title bar field to be stored in the database, and configuration bank's stream
The mapping relations of water template and the beacon information.
In the present embodiment, from current-carrying water template above and below the website of each bank, the second storing sub-units pass through preset
Shell script gets the title bar field of flowing water template, and by above-mentioned title bar field according to the typesetting side of above-mentioned flowing water template
In formula one blank form of corresponding write-in, a flowing water table is generated, so that the typesetting of the flowing water table and above-mentioned flowing water template
Unanimously, which is then stored in above-mentioned database as above-mentioned bank's flowing water template；Meanwhile configuring bank's flowing water
The mapping relations of template and the beacon information, convenient for matching corresponding bank's flowing water template according to beacon information.
In one embodiment, the managing device of above-mentioned pipelined data further include:
Loading unit 40, in all pipelined datas for being stored in the target flowing water template of the database, selection
The user in the pipelined data is the target pipelined data of designated user out, and the target pipelined data is loaded onto same
In data form.
Due to same user, there may be account in multiple banks, and in the pipelined data of each bank difference.This reality
It applies in example, the first flowing water information of statistics is got from bank, and pipelined data is respectively corresponded and is added to the target flowing water
After in template, the flowing water list of user is generated；Loading unit 40 selects all streams of same designated user according to the ID of user
Water list, and load it in the same data form, be convenient for comparative analysis, calculate spending amount etc.；Such as to score
It is precipitated which bank of user preference etc. judged in the spending amount of different bank by the user, while all disappear can also be calculated
Take the weight proportion consumed in the amount of money using different bank.For example, user's first is using the weight proportion that Bank of China consumes
30%, and the use of the weight proportion that safety bank consumes is 70% etc..Or some month of user can also be counted logical
Cross spending amount, the amount received etc. of each bank.
Therefore, in one embodiment, the managing device of above-mentioned pipelined data further include:
Computing unit, it is corresponding in each bank for from the pipelined data in the data form, obtaining designated user
Spending amount, and calculate designated user in the spending amount ratio of each bank.
In the present embodiment, computing unit calculates designated user in the spending amount ratio of each bank, convenient for calculating
User has the weight proportion consumed in spending amount using different bank, convenient for judging user preference is disappeared using which bank
Take.
In one embodiment, the managing device of above-mentioned pipelined data further include:
Issuance unit for configuring the permission of checking of the data form, and will be issued with the data form postponed
To user terminal corresponding to the designated user.
In the present embodiment, issuance unit is also configured with above-mentioned data form and checks permission accordingly；For example, to above-mentioned number
It is encrypted according to form document, user correctly enters password and can just check, which can be in advance in overflow pipe platform
Set；User can not open Fileview when inputting password mistake.The above-mentioned data form configured is issued to specified
The user terminal of user understands oneself in the spending amount of all banks, convenient for the financial management of user convenient for user.This implementation
In example, the available telephone number bound to user and bank account, and extract in the text in above-mentioned data form
Hold, generates text information, above-mentioned text information is sent to the terminal of user by way of short message.Or it available arrives
Then above-mentioned data form is sent to user by the mailbox that user and bank account are bound by way of mail.
In conclusion obtaining bank's system for the management method and device of the pipelined data provided in the embodiment of the present application
First flowing water information of meter carries pipelined data and beacon information in the first flowing water information, and the beacon information is extremely
It less include Bank Name；According to the beacon information, bank's stream corresponding with the beacon information is selected in the database
Water template is as target flowing water template；It is stored in the database and the one-to-one bank's flowing water mould of the beacon information
Plate；The pipelined data correspondence that the first flowing water information carries is added in the target flowing water template；Convenient for enterprise's reconciliation
And data analysis comparison is carried out to bank's pipelined data of user.
Referring to Fig. 5, a kind of computer equipment is also provided in the embodiment of the present application, which can be server,
Its internal structure can be as shown in Figure 5.The computer equipment includes processor, the memory, network connected by system bus
Interface and database.Wherein, the processor of the Computer Design is for providing calculating and control ability.The computer equipment is deposited
Reservoir includes non-volatile memory medium, built-in storage.The non-volatile memory medium is stored with operating system, computer program
And database.The built-in storage provides environment for the operation of operating system and computer program in non-volatile memory medium.
The database of the computer equipment is for storing the data such as bank's flowing water template.The network interface of the computer equipment be used for it is outer
The terminal in portion passes through network connection communication.A kind of manager of pipelined data is realized when the computer program is executed by processor
Method.
Above-mentioned processor executes the step of management method of above-mentioned pipelined data:
The first flowing water information of bank statistics is obtained, carries pipelined data in the first flowing water information and to mark
Information, the beacon information include at least Bank Name；
According to the beacon information, bank's flowing water template corresponding with the beacon information is selected in the database and is made
For target flowing water template；It is stored in the database and the one-to-one bank's flowing water template of the beacon information；
The pipelined data correspondence that the first flowing water information carries is added in the target flowing water template.
In one embodiment, above-mentioned processor obtains the first flowing water information of bank statistics, in the first flowing water information
Pipelined data and beacon information are carried, before the step of beacon information includes at least Bank Name, comprising:
Storage and the one-to-one bank's flowing water template of the beacon information in the database.
In one embodiment, above-mentioned processor stores and the one-to-one bank's flowing water of the beacon information in the database
The step of template, comprising:
Bank's flowing water template that user uploads is received, bank's flowing water template of the upload is stored in the database
In, and configure the mapping relations of bank's flowing water template and the beacon information.
In one embodiment, above-mentioned processor stores and the one-to-one bank's flowing water of the beacon information in the database
The step of template, comprising:
The title bar field of default flowing water template is obtained by preset shell script, and raw according to the title bar field
It is stored in the database at corresponding bank's flowing water template, and configuration bank's flowing water template and the beacon information
Mapping relations.
In one embodiment, the pipelined data correspondence that the first flowing water information carries is added to described by above-mentioned processor
After step in target flowing water template, comprising:
In all pipelined datas stored in the target flowing water template of the database, select in the pipelined data
User be designated user target pipelined data, and the target pipelined data is loaded onto same data form.
In one embodiment, all pipelined datas that above-mentioned processor stores in the target flowing water template of the database
In, the user selected in the pipelined data is the target pipelined data of designated user, and the target pipelined data is added
It is loaded onto after the step in same data form, comprising:
The permission of checking of the data form is configured, and the designated user will be issued to the data form postponed
Corresponding user terminal.
In one embodiment, all pipelined datas that above-mentioned processor stores in the target flowing water template of the database
In, the user selected in the pipelined data is the target pipelined data of designated user, and the target pipelined data is added
It is loaded onto after the step in same data form, comprising:
From the pipelined data in the data form, the corresponding spending amount in each bank of designated user is obtained, and
Designated user is calculated in the spending amount ratio of each bank.
It will be understood by those skilled in the art that structure shown in Fig. 5, only part relevant to application scheme is tied
The block diagram of structure does not constitute the restriction for the computer equipment being applied thereon to application scheme.
One embodiment of the application also provides a kind of computer storage medium, is stored thereon with computer program, computer journey
A kind of management method of pipelined data is realized when sequence is executed by processor, specifically:
The first flowing water information of bank statistics is obtained, carries pipelined data in the first flowing water information and to mark
Information, the beacon information include at least Bank Name；
According to the beacon information, bank's flowing water template corresponding with the beacon information is selected in the database and is made
For target flowing water template；It is stored in the database and the one-to-one bank's flowing water template of the beacon information；
The pipelined data correspondence that the first flowing water information carries is added in the target flowing water template.
In one embodiment, above-mentioned processor obtains the first flowing water information of bank statistics, in the first flowing water information
Pipelined data and beacon information are carried, before the step of beacon information includes at least Bank Name, comprising:
Storage and the one-to-one bank's flowing water template of the beacon information in the database.
In one embodiment, above-mentioned processor stores and the one-to-one bank's flowing water of the beacon information in the database
The step of template, comprising:
Bank's flowing water template that user uploads is received, bank's flowing water template of the upload is stored in the database
In, and configure the mapping relations of bank's flowing water template and the beacon information.
In one embodiment, above-mentioned processor stores and the one-to-one bank's flowing water of the beacon information in the database
The step of template, comprising:
The title bar field of default flowing water template is obtained by preset shell script, and raw according to the title bar field
It is stored in the database at corresponding bank's flowing water template, and configuration bank's flowing water template and the beacon information
Mapping relations.
In one embodiment, the pipelined data correspondence that the first flowing water information carries is added to described by above-mentioned processor
After step in target flowing water template, comprising:
In all pipelined datas stored in the target flowing water template of the database, select in the pipelined data
User be designated user target pipelined data, and the target pipelined data is loaded onto same data form.
In one embodiment, all pipelined datas that above-mentioned processor stores in the target flowing water template of the database
In, the user selected in the pipelined data is the target pipelined data of designated user, and the target pipelined data is added
It is loaded onto after the step in same data form, comprising:
The permission of checking of the data form is configured, and the designated user will be issued to the data form postponed
Corresponding user terminal.
In one embodiment, all pipelined datas that above-mentioned processor stores in the target flowing water template of the database
In, the user selected in the pipelined data is the target pipelined data of designated user, and the target pipelined data is added
It is loaded onto after the step in same data form, comprising:
From the pipelined data in the data form, the corresponding spending amount in each bank of designated user is obtained, and
Designated user is calculated in the spending amount ratio of each bank.
In conclusion for the management method of the pipelined data provided in the embodiment of the present application, device, computer equipment and depositing
Storage media obtains the first flowing water information of bank statistics, and pipelined data and mark letter are carried in the first flowing water information
Breath, the beacon information include at least Bank Name；According to the beacon information, selects believe with the mark in the database
The corresponding bank's flowing water template of manner of breathing is as target flowing water template；It is stored in the database a pair of with the beacon information one
The bank's flowing water template answered；The pipelined data correspondence that the first flowing water information carries is added to the target flowing water template
In；Data analysis comparison is carried out convenient for enterprise's reconciliation and to bank's pipelined data of user.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, the computer program can store and a non-volatile computer
In read/write memory medium, the computer program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein,
Any reference used in provided herein and embodiment to memory, storage, database or other media,
Including non-volatile and/or volatile memory.Nonvolatile memory may include read-only memory (ROM), programming ROM
(PROM), electrically programmable ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory.Volatile memory may include
Random access memory (RAM) or external cache.By way of illustration and not limitation, RAM can by diversified forms
, such as static state RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double speed are according to rate SDRAM (SSRSDRAM), increasing
Strong type SDRAM (ESDRAM), synchronization link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM
(RDRAM), direct memory bus dynamic ram (DRDRAM) and memory bus dynamic ram (RDRAM) etc..
It should be noted that, in this document, the terms "include", "comprise" or its any other variant are intended to non-row
His property includes, so that the process, device, article or the method that include a series of elements not only include those elements, and
And further include the other elements being not explicitly listed, or further include for this process, device, article or method institute it is intrinsic
Element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including being somebody's turn to do
There is also other identical elements in the process, device of element, article or method.
The foregoing is merely preferred embodiment of the present application, are not intended to limit the scope of the patents of the application, all utilizations
Equivalent structure or equivalent flow shift made by present specification and accompanying drawing content is applied directly or indirectly in other correlations
Technical field, similarly include in the scope of patent protection of the application.
Claims (10)
1. a kind of management method of pipelined data, which comprises the following steps:
The first flowing water information of bank statistics is obtained, carries pipelined data and beacon information in the first flowing water information,
The beacon information includes at least Bank Name；
According to the beacon information, bank's flowing water template corresponding with the beacon information is selected in the database as mesh
Mark flowing water template；It is stored in the database and the one-to-one bank's flowing water template of the beacon information；
The pipelined data correspondence that the first flowing water information carries is added in the target flowing water template.
2. the management method of pipelined data according to claim 1, which is characterized in that described to obtain the first of bank statistics
Flowing water information, pipelined data and beacon information are carried in the first flowing water information, and the beacon information includes at least silver
Before the step of row title, comprising:
Storage and the one-to-one bank's flowing water template of the beacon information in the database.
3. the management method of pipelined data according to claim 2, which is characterized in that storage and the institute in the database
The step of stating beacon information one-to-one bank's flowing water template, comprising:
Bank's flowing water template that user uploads is received, bank's flowing water template of the upload is stored in the database, and
Configure the mapping relations of bank's flowing water template and the beacon information.
4. the management method of pipelined data according to claim 2, which is characterized in that storage and the institute in the database
The step of stating beacon information one-to-one bank's flowing water template, comprising:
The title bar field of default flowing water template is obtained by preset shell script, and according to title bar field generation pair
The bank's flowing water template answered is stored in the database, and configuration bank's flowing water template and the beacon information are reflected
Penetrate relationship.
5. the management method of pipelined data according to claim 1, which is characterized in that described by the first flowing water information
The pipelined data correspondence of carrying is added to after the step in the target flowing water template, the method also includes:
In all pipelined datas stored in the target flowing water template of the database, the use in the pipelined data is selected
Family is the target pipelined data of designated user, and the target pipelined data is loaded onto same data form.
6. the management method of pipelined data according to claim 5, which is characterized in that the target in the database
In all pipelined datas stored in flowing water template, the target flowing water that the user in the pipelined data is designated user is selected
Data, and after the step that the target pipelined data is loaded onto same data form, the method also includes:
The permission of checking of the data form is configured, and right by the designated user institute is issued to the data form postponed
The user terminal answered.
7. the management method of pipelined data according to claim 5, which is characterized in that the target in the database
In all pipelined datas stored in flowing water template, the target flowing water that the user in the pipelined data is designated user is selected
Data, and after the step that the target pipelined data is loaded onto same data form, the method also includes:
From the pipelined data in the data form, the corresponding spending amount in each bank of designated user is obtained, and calculate
Spending amount ratio of the designated user in each bank.
8. a kind of managing device of pipelined data characterized by comprising
Acquiring unit carries pipelined data in the first flowing water information for obtaining the first flowing water information of bank statistics
And beacon information, the beacon information include at least Bank Name；
Selecting unit, for selecting bank corresponding with the beacon information in the database according to the beacon information
Flowing water template is as target flowing water template；It is stored in the database and the one-to-one bank's flowing water mould of the beacon information
Plate；
Adding unit, the pipelined data correspondence for carrying the first flowing water information are added to the target flowing water template
In.
9. a kind of computer equipment, including memory and processor, it is stored with computer program in the memory, feature exists
In the step of processor realizes any one of claims 1 to 7 the method when executing the computer program.
10. a kind of computer storage medium, is stored thereon with computer program, which is characterized in that the computer program is located
The step of reason device realizes method described in any one of claims 1 to 7 when executing.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810798391.4A CN109255108B (en) | 2018-07-19 | 2018-07-19 | Method and device for managing running data, computer equipment and storage medium |
| PCT/CN2018/108031 WO2020015184A1 (en) | 2018-07-19 | 2018-09-27 | Account statement data management method and apparatus, and computer device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810798391.4A CN109255108B (en) | 2018-07-19 | 2018-07-19 | Method and device for managing running data, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109255108A true CN109255108A (en) | 2019-01-22 |
| CN109255108B CN109255108B (en) | 2022-06-17 |
Family
ID=65049000
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810798391.4A Active CN109255108B (en) | 2018-07-19 | 2018-07-19 | Method and device for managing running data, computer equipment and storage medium |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN109255108B (en) |
| WO (1) | WO2020015184A1 (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112465618A (en) * | 2020-12-22 | 2021-03-09 | 航天信息股份有限公司企业服务分公司 | Universal importing method and system for bank statement |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102255786A (en) * | 2010-05-20 | 2011-11-23 | 中国移动通信集团广西有限公司 | Service message processing method and device |
| CN105631738A (en) * | 2015-12-30 | 2016-06-01 | 中国建设银行股份有限公司 | Standard inputting and storing system for accountant document template |
| CN106339932A (en) * | 2016-08-24 | 2017-01-18 | 明算科技（北京）股份有限公司 | Accounting document generating method and accounting document generating device |
| CN106779803A (en) * | 2016-11-24 | 2017-05-31 | 久远谦长（北京）技术服务有限公司 | A kind of method that financial institution's flowing water is matched with carrier data |
| CN107038553A (en) * | 2016-12-29 | 2017-08-11 | 平安科技（深圳）有限公司 | Data processing method and device |
| CN107679819A (en) * | 2017-06-12 | 2018-02-09 | 平安科技（深圳）有限公司 | Financial data processing method, device, computer equipment and storage medium |
| CN107767066A (en) * | 2017-10-31 | 2018-03-06 | 浪潮金融信息技术有限公司 | Wisdom site user behavior analysis method and device, storage medium and terminal |
| CN107888672A (en) * | 2017-11-02 | 2018-04-06 | 深圳市牛鼎丰科技有限公司 | Billing data processing method, device, storage medium and computer equipment |
| CN107918910A (en) * | 2017-09-28 | 2018-04-17 | 平安普惠企业管理有限公司 | Financial affairs receipt generation method, device, equipment and computer-readable recording medium |
| CN107944996A (en) * | 2017-10-17 | 2018-04-20 | 九派天下支付有限公司 | A kind of fund account checking method and system |
| CN108074176A (en) * | 2016-11-15 | 2018-05-25 | 平安科技（深圳）有限公司 | One kind carries voucher generation method and device in advance |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106815366A (en) * | 2017-01-23 | 2017-06-09 | 北京思特奇信息技术股份有限公司 | A kind of method and system of Mass production data |
| CN106897508A (en) * | 2017-02-14 | 2017-06-27 | 北京数码大方科技股份有限公司 | The generation method and device of drawing |
-
2018
- 2018-07-19 CN CN201810798391.4A patent/CN109255108B/en active Active
- 2018-09-27 WO PCT/CN2018/108031 patent/WO2020015184A1/en active Application Filing
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102255786A (en) * | 2010-05-20 | 2011-11-23 | 中国移动通信集团广西有限公司 | Service message processing method and device |
| CN105631738A (en) * | 2015-12-30 | 2016-06-01 | 中国建设银行股份有限公司 | Standard inputting and storing system for accountant document template |
| CN106339932A (en) * | 2016-08-24 | 2017-01-18 | 明算科技（北京）股份有限公司 | Accounting document generating method and accounting document generating device |
| CN108074176A (en) * | 2016-11-15 | 2018-05-25 | 平安科技（深圳）有限公司 | One kind carries voucher generation method and device in advance |
| CN106779803A (en) * | 2016-11-24 | 2017-05-31 | 久远谦长（北京）技术服务有限公司 | A kind of method that financial institution's flowing water is matched with carrier data |
| CN107038553A (en) * | 2016-12-29 | 2017-08-11 | 平安科技（深圳）有限公司 | Data processing method and device |
| CN107679819A (en) * | 2017-06-12 | 2018-02-09 | 平安科技（深圳）有限公司 | Financial data processing method, device, computer equipment and storage medium |
| CN107918910A (en) * | 2017-09-28 | 2018-04-17 | 平安普惠企业管理有限公司 | Financial affairs receipt generation method, device, equipment and computer-readable recording medium |
| CN107944996A (en) * | 2017-10-17 | 2018-04-20 | 九派天下支付有限公司 | A kind of fund account checking method and system |
| CN107767066A (en) * | 2017-10-31 | 2018-03-06 | 浪潮金融信息技术有限公司 | Wisdom site user behavior analysis method and device, storage medium and terminal |
| CN107888672A (en) * | 2017-11-02 | 2018-04-06 | 深圳市牛鼎丰科技有限公司 | Billing data processing method, device, storage medium and computer equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2020015184A1 (en) | 2020-01-23 |
| CN109255108B (en) | 2022-06-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110297912A (en) | Cheat recognition methods, device, equipment and computer readable storage medium | |
| CN108876133A (en) | Risk assessment processing method, device, server and medium based on business information | |
| CN110286974A (en) | Application configuration method, apparatus, equipment and storage medium based on the H5 page | |
| CN109657215A (en) | Document structure tree method, equipment, storage medium and device based on template | |
| CN105956842A (en) | Electronic membership card management method and device | |
| CN110147495A (en) | Page response method, apparatus, equipment and medium based on Configuration Online | |
| CN107526635A (en) | A kind of asynchronous deriving method of data | |
| CN109670835A (en) | Air control method, apparatus, equipment and readable storage medium storing program for executing based on service node | |
| CN111581210A (en) | Data importing method and system | |
| CN107679819A (en) | Financial data processing method, device, computer equipment and storage medium | |
| CN109615463A (en) | A kind of intelligent booking management system and application based on wechat small routine | |
| CN110309099A (en) | Interface managerial method, device, equipment and computer readable storage medium | |
| CN109461069A (en) | Air control method, apparatus, equipment and readable storage medium storing program for executing based on service node | |
| CN109600724A (en) | A kind of method and apparatus that short message is sent | |
| CN110363222A (en) | Picture mask method, device, computer equipment and storage medium for model training | |
| CN106598946A (en) | Content extracting method and device | |
| CN107392560A (en) | A kind of Excel list datas issue acquisition method and system based on internet | |
| CN112035519A (en) | User image drawing method and device, computer readable storage medium and terminal equipment | |
| CN109191104A (en) | A kind of information processing method and its equipment | |
| CN109255108A (en) | Management method, device, computer equipment and the storage medium of pipelined data | |
| CN109587244A (en) | Cloud data in mobile phone processing method, device, computer readable storage medium and electronic equipment | |
| US20140344129A1 (en) | Centralized entitlements | |
| CN110083782A (en) | Inspection method, device, computer equipment and the storage medium of electronic insurance policy | |
| CN104468635B (en) | The user right step-up authentication method and system of the network platform | |
| Nielsen | Digitising a small island state: A lesson in Faroese |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |