CN110046153A - A kind of method, device and equipment of account fund verification - Google Patents
A kind of method, device and equipment of account fund verification Download PDFInfo
- Publication number
- CN110046153A CN110046153A CN201811374743.XA CN201811374743A CN110046153A CN 110046153 A CN110046153 A CN 110046153A CN 201811374743 A CN201811374743 A CN 201811374743A CN 110046153 A CN110046153 A CN 110046153A
- Authority
- CN
- China
- Prior art keywords
- business
- verification
- account fund
- model
- service node
- 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
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2477—Temporal data queries
-
- 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/04—Trading; Exchange, e.g. stocks, commodities, derivatives or currency exchange
Abstract
Present description provides a kind of account fund checking method, device and equipment.The described method includes: generating configuration interface, so that user according to verification account fund business in the configuration interface configuration querying condition, wherein, the querying condition is used to describe the incidence relation between each service node and the service node that the business of the verification account fund includes；According to the querying condition of user configuration, the service node is mapped to model, and the incidence relation between the service node is mapped to the incidence relation between the model；The SQL script of the business of the verification account fund is generated, according to the incidence relation between the model and the model to check the account fund.It is apparent intuitive can to make the logic between each service node of verification business by user interface interaction design, and automatically generates SQL script, without writing manually, keeps account fund verification more simple and convenient, verification script more standardizes.
Description
Technical field
The present invention relates to the method, device and equipments that field of computer technology more particularly to a kind of account fund are checked.
Background technique
Bank, enterprise and some third-party platforms etc. require to check the fund to circulate daily, for example pay
Treasured has thousands of a business transition families, and circulation and surplus budgetary funds number are up to hundred billion daily, these transition families are occurred daily
The verification of volume and remaining sum is most important.Since the number of account is more, and the import/export business of account and cash flow are all extremely complex,
, can be than more difficult currently, some technologies are when the disengaging fund to account is checked, bad maintenance, and everyone from
Oneself goes to write verification script, it is difficult to which specification verification script checks content quality also bad control.
Summary of the invention
To overcome the problems in correlation technique, present description provides a kind of method, apparatus of account fund verification
And equipment.
Firstly, present description provides a kind of methods of account fund verification, which comprises
Generate configuration interface so that user according to verification account fund business in the configuration interface configuration querying item
Part, wherein the querying condition is used to describe each service node and the industry that the business of the verification account fund includes
Incidence relation between business node；
According to the querying condition of user configuration, the service node is mapped to model, and by the service node it
Between incidence relation be mapped to the incidence relation between the model；
The SQL of the business of the verification account fund is generated according to the incidence relation between the model and the model
Script；
The account fund is checked by the SQL script of the business of the verification account fund.
Secondly, present description provides a kind of device of account fund verification, described device includes:
Configuration module generates configuration interface, so that user is according to the business of verification account fund in the configuration interface
Configuration querying condition, wherein the querying condition is used to describe each service node that the business of the verification account fund includes
And the incidence relation between the service node；
The service node is mapped to model according to the querying condition of user configuration by mapping block, and by the industry
Incidence relation between business node is mapped to the incidence relation between the model；
Script generation module generates the verification account according to the incidence relation between the model and the model and provides
The SQL script of the business of gold；
Module is checked, the account fund is checked by the SQL script of the business of the verification account fund.
Further, this application provides a kind of equipment, for checking account fund, the equipment includes: the equipment
Memory, for storing executable computer instruction；
Processor performs the steps of when for executing the computer instruction
Generate configuration interface so that user according to verification account fund business in the configuration interface configuration querying item
Part, wherein the querying condition is used to describe each service node and the industry that the business of the verification account fund includes
Incidence relation between business node；
According to the querying condition of user configuration, the service node is mapped to model, and by the service node it
Between incidence relation be mapped to the incidence relation between the model；
The SQL foot of the business of verification account fund is generated according to the incidence relation between the model and the model
This；
The account fund is checked by the SQL script of the business of the verification account fund.
The application's the utility model has the advantages that will check the industry of account fund according to the querying condition that user configures in configuration interface
Each service node of business is mapped to the incidence relation that the incidence relation between model and service node is mapped between model, so
The SQL script for generating the business of verification account fund according to the incidence relation between model and model afterwards carries out core to account fund
It is right.It is apparent straight that the logic between each service node of the business of account fund can be made to check by user interface interaction design
It sees, and automatically generates SQL verification script, without writing manually, keep account fund verification more simple and convenient, verification script is more advised
Model.
It should be understood that above general description and following detailed description be only it is exemplary and explanatory, not
It can the limitation present invention.
Detailed description of the invention
The drawings herein are incorporated into the specification and forms part of this specification, and shows and meets implementation of the invention
Example, and be used to explain the principle of the present invention together with specification.
Fig. 1 is a kind of flow chart of account fund checking method shown in one exemplary embodiment of this specification；
Fig. 2 is the schematic diagram of the querying condition configured by configuration interface shown in one exemplary embodiment of this specification；
Fig. 3 be one exemplary embodiment of this specification shown in configuration interface in service node editing interface；
Fig. 4 be one exemplary embodiment of this specification shown in configuration interface in service node incidence relation selection circle
Face；
Fig. 5 is mapped to the mapping result schematic diagram of model for the service node shown in one exemplary embodiment of this specification；
Fig. 6 is the verification abnormal data output interface shown in one exemplary embodiment of this specification；
Fig. 7 is a kind of architecture logic block diagram of account fund checking device shown in one exemplary embodiment of this specification；
Fig. 8 is a kind of architecture logic block diagram of account fund checking apparatus shown in one exemplary embodiment of this specification.
Specific embodiment
Example embodiments are described in detail here, and the example is illustrated in the accompanying drawings.Following description is related to
When attached drawing, unless otherwise indicated, the same numbers in different drawings indicate the same or similar elements.Following exemplary embodiment
Described in embodiment do not represent all embodiments consistented with the present invention.On the contrary, they be only with it is such as appended
The example of device and method being described in detail in claims, some aspects of the invention are consistent.
It is only to be not intended to limit the invention merely for for the purpose of describing particular embodiments in terminology used in the present invention.
It is also intended in the present invention and the "an" of singular used in the attached claims, " described " and "the" including majority
Form, unless the context clearly indicates other meaning.It is also understood that term "and/or" used herein refers to and wraps
It may be combined containing one or more associated any or all of project listed.
It will be appreciated that though various information, but this may be described using term first, second, third, etc. in the present invention
A little information should not necessarily be limited by these terms.These terms are only used to for same type of information being distinguished from each other out.For example, not departing from
In the case where the scope of the invention, the first information can also be referred to as the second information, and similarly, the second information can also be referred to as
One information.Depending on context, word as used in this " if " can be construed to " ... when " or " when ...
When " or " in response to determination ".
Bank, enterprise and some third-party platforms etc. require to check the fund to circulate daily, for example pay
Treasured has thousands of a business transition families, and circulation and surplus budgetary funds number are up to hundred billion daily, these transition families are occurred daily
The verification of volume and remaining sum is most important.Since the number of account is more, and the import/export business of account and cash flow are all extremely complex,
Currently, mostly using sql like language as tool when carrying out account fund verification, being input by the business datum of account fund, lead to
It crosses SQL query statement the data filtering of risk will be present and come out.Briefly, the process of verification be exactly assemble object module and from
There are problems that the process of risk data in middle filtering, during this it is most important be exactly this object module assembling；Mesh
Preceding way be by manually going to write SQL, it is mutual according to the table structure of the business datum table of account fund and tables of data
Incidence relation, using SQL join, union combination where filter, step by step construct specific account fund business number
According to " target Data " wide table screened for verification.But this method for writing the verification of SQL script manually can compare difficult reason
Solution, also bad maintenance, and each verification personnel oneself go to write verification script, it is difficult to and specification verification script checks content matter
Measure also bad control.
To solve the above-mentioned problems, present description provides a kind of checking method of account fund, the method pass through by
Interface configurations and SQL verification script combine so that the verification of account fund is more intuitive and simply, detailed process as shown in Figure 1,
Including step S102-S108:
S102, configuration interface is generated, so that user configures in the configuration interface according to the business of verification account fund
Querying condition, wherein the querying condition be used to describe the verification account fund business each service node for including and
Incidence relation between the service node；
The service node is mapped to model by S104, the querying condition according to user configuration, and by the business section
Incidence relation between point is mapped to the incidence relation between the model；
S106, the business that the verification account fund is generated according to the incidence relation between the model and the model
SQL script；
S108, the account fund is checked by the SQL script of the business of the verification account fund.
SQL is a kind of structured query language, common a kind of language tool when being account fund verification, account fund
Audit process is exactly the business datum table for inquiring account fund to be removed by SQL query language and therefrom filter screen is selected and deposited in fact
It in the process of risk and the data of problem, before screening by SQL, needs first to have configured querying condition, so that SQL is according to looking into
Inquiry condition goes to filter out problematic data.In order to allow user to be more clear when checking account fund and intuitively deallocation
Set querying condition, the checking method that this specification provides can be realized based on interface configurations, user after entering check system,
System can generate a configuration interface, and user can inquire item according to the business configuration of verification account fund in configuration interface
Part, the querying condition of user configuration can be used for describing checking account fund business each service node for including and these
Incidence relation between node.For example, the querying condition of user configuration can be indicated in the form of node diagram, entire node
Figure represents the business of verification account fund, and each node in node diagram indicates each industry that the business of verification account fund includes
It is engaged in node, is connected by certain incidence relation between node.Fig. 2 is inquiry of the user according to the red packet business configuration of Alipay
Condition, the fund of some bill payment treasured red packet business is by 21, neck red packet 22 and the cash flow for moving back 23 three parts of red packet of giving bonus
It determines, so red packet business includes sending packet 21, neck red packet 22, moving back 23 3 service nodes of red packet, wherein moving back this industry of red packet
The data of business node need by money transfer table and underlying table of transferring accounts do Join operation can just obtain moving back red packet this
The data of node, that fund table 24 and underlying table 25 are exactly two business child nodes.And in node diagram between two service nodes
Association, can be by marking the incidence relation between them, clearly to describe on the connecting line of two service nodes in node diagram
The relationship of each service node.For example, needing to carry out a Join operation between money transfer table and underlying table of transferring accounts could obtain
To moving back red packet data, thus the incidence relation between them is Inner Join.And red packet business data need to give bonus,
The data of neck red packet and three service nodes of accepting covert payment carry out Union all operation, thus the incidence relation between them
For Union all.Certainly, node diagram is a kind of manifestation mode of configuration querying condition in this specification, and user can also lead to
The option and installment option in interface is crossed, these options are combined to be configured to final querying condition, this specification is not made
Limitation.
In one embodiment, user can perform the following operation in configuration interface carrys out configuration querying condition, for example adds
Add service node, delete the incidence relation between service node, editing affairs node and/or selection service node.Such as Fig. 2,
There are some control icons in configuration interface, such as add service node control icons 26, delete service node control icons 27, compile
It collects service node control icons 28 and service node incidence relation selection control icons 29 can after clicking these icons
Corresponding operation is carried out, for example user can be added service node by clicking addition service node control icons 26
Operation, three service nodes " send packet, lead red packet, move back red packet " in red packet business are added, naturally it is also possible to logical
It crosses deletion service node control icons 27 to delete some service node, can also click on editing affairs node 28 and edit industry
Some fields of business cleaning.Fig. 3 is the editing interface of " neck red packet " this service node, can be inputted by editing interface user
Wash out the field such as biz_id (business id) of the corresponding some needs of this business, actual_amount (amount of money),
Direction (fund inflow and outflow direction), biz_time (business time of origin).Incidence relation between each service node is then
Control icons 29 can be selected to go to select by the service node incidence relation clicked in configuration interface.It is closed in click-to-call service node
After connection relationship selects control icons 29, it may appear that interface as shown in Figure 4 is shown between the service node that can choose to user
Incidence relation, so that user selects according to the relationship between service node.
In configuration querying condition, the incidence relation between each service node is the connection sentence corresponded in SQL.One
In a embodiment, the incidence relation between service node includes lateral connection and longitudinally connected.Due to generating SQL verification script
When, service node first can be mapped to model, the incidence relation between service node is mapped to the incidence relation between model,
And model can be according to the predefined tables of data of service node, so being mapped by the incidence relation between service node
Relationship between the incidence relation between model arrived namely these tables of data.In sql like language, by lateral connection and it can indulge
Processing is merged to multiple tables of data to connection, to obtain final data.
Lateral connection includes: left outside connection (Left outer join), right outer connection (Right in some embodiments
Outer join), complete outer connection (Full outer join) and/or equivalent connection (inner join).Wherein, these are associated with
Relationship can be corresponding with the connection sentence in SQL, is all some operations for indicating to execute tables of data.In SQL, left outside connection
The result set of (Left outer join) includes all rows for the left-handed watch specified in Left outer clause, rather than just even
Connect the matched row of column institute, if certain row of left-handed watch does not have matching row in right table, the right table in associated result set row
All selective listing column are null value.Right outer connection (Right outer join) is the Opposite direction connection of left outside connection, result
Collection includes all rows for returning to right table.If certain row of right table does not have matching row in left-handed watch, null value is returned for left-handed watch.It is complete outer
The result set of connection (Full outer join) includes all rows returned in left-handed watch and right table, when certain row is in another table
When not having matching row, then the selective listing column of another table include null value, if there is matching row between table, entire result set
Row includes the data value of base table.Equivalence connection (inner join) refers to using comparison operator according to the shared column of each table
Row in value two tables of matching, for example, the identical all rows of retrieval students and courses table middle school student's identification number.
In some examples, longitudinally connected between service node includes: Union all and/or Union.Likewise, this
A little incidence relations can be corresponding with the connection sentence in SQL, indicates some operations and operation executed to tables of data.In SQL language
It calls the turn, mainly by select selection target column, from inquiry target, (this target can be that table, to be also possible to subquery embedding
Set), where filter condition to inquire filter out abnormal data.If we need to make the result of two select sentences
As soon as showing for entirety, we need to use Union Union all operations, and wherein Union, which refers to, ties two
Fruit collection carries out union operation, does not include repeating to go, while carrying out the sequence of default rule.Union all refers to two results
Collection carries out union operation, including repeats to go, without sequence；For example the last checked result of red packet business is exactly to need each industry
The checked result that business point sends packet, leads red packet, moves back red packet is integrated and is shown as a whole, thus is needed to three business
Node carries out a union operation, i.e. Union Union all operations.
In moving back this service node of red packet comprising two business child node fund tables and underlying table need to pass through one
Join operation can just obtain the final data for moving back this service node of red packet, thus fund table and underlying table the two business
Relationship between node is Inner join.Likewise, the data of red packet business need to send packet, lead red packet, move back red packet three
The data of service node pass through operation of Union all, thus, the association for sending packet, leading red packet, moving back three service nodes of red packet
Relationship is Union all.By operation between these bivariate tables, each service node of the business of account fund can will be checked
It is spliced and combined to obtain the business of final verification account fund.It in this way can be by a complicated verification business step by step
Ground resolves into simple service node, after the processing of these service nodes, splices these service nodes according still further to service logic
Get up.
After the good querying condition of user configuration, according to the querying condition of user configuration, service node is mapped to model, so
The incidence relation incidence relation between service node being mapped to afterwards between model.Wherein, model be will be different types of
A set of model that can be shared that account abstracts, model can be a tables of data, contain in this tables of data to industry
The information for needing to use when business is checked.For example, account may include many information, including account attributes, the amount of money,
The information such as fund inflow and outflow direction, account, business time of origin, business-account association, can be necessary verification account fund
The some information for including extract, and some unnecessary information such as account attributes are given up to fall, and then define one to all
The blanket model of account.
It in one embodiment, include the field for screening the query result of service node in model.Such as it is certain checking
When account data, the content for needing to check includes the information such as the amount of money, account, then model may include these screening service nodes
The field of query result.In one embodiment, screen the query result of service node field may include: account, the amount of money,
Fund inflow and outflow direction, business-account association, service identification and/or business time of origin.These fields are all at some
The field that service node must be used in verification can filter out abnormal data by inquiring these fields.
Since the field in model pre-defines, but the mode how each account obtains these fields is not
It is the same, for example, the business of different accounts and the associate field of account it is all different, it may be necessary to some splicings or processing are
These information can be obtained, are equally this field of the amount of money for another example, identifying the field of the amount of money in A account is amount, and B account
In may be trans_amount, in order to which the field in the information and model of each account is united, user can configured
These good information of interface configurations, then the information good further according to user configuration, is mapped to model for each service node.Fig. 5 is to use
Family is mapped to a schematic diagram of the mapping result in model after each service node has configured querying condition.By by account
In information MAP be field in model, one-to-one correspondence gets up.
After each service node is mapped to model again, it can be mapped between model according to the relationship between service node
Incidence relation, the incidence relation between service node, user is in configuration querying condition according between service node
Association chooses, and the incidence relation between these service nodes, the incidence relation namely between model, that is, correspond to SQL in fact
In connection sentence.Since model is the tables of data of the business datum of corresponding service node, so by the association of service node
Operation relation after relationship map to model, that is, between tables of data, for example, red packet business includes hair in red packet business
Red packet leads red packet, moves back these three service nodes of red packet, and the incidence relation between three service nodes is Union all, then by three
After a service node is mapped to model, three tables of data can be obtained, that is, the business datum table to give bonus leads the business datum of red packet
Incidence relation between node is mapped to after the incidence relation between model to get to three by table, the business datum table for moving back red packet
Incidence relation between a tables of data is Union all, that is, needs to carry out Union all operations to these three tables of data, obtain
The data of whole red packet business.
Service node is being mapped to the association that the incidence relation between model and service node is mapped between model
After relationship, verification business SQL script can be automatically generated according to the incidence relation between model and model, then pass through verification industry
Business SQL script checks account fund.
For SQL as a kind of structured query language, all operations can be abstracted as the mistake to data table row column
Filter and the calculating between table and table.The SQL verification script of one verification business often all has the spy of " layering, nested, association "
Point, and can preferably be abstracted and correspond to the verification script of each service node and the association between them in verification business.
That is, the SQL of a verification business checks script, it can be by by the verification script of service node each in verification business
Combine to obtain through certain incidence relation splicing.So script is checked in order to generate the SQL of final entire verification business,
The script of each service node in this verification business can be first generated, is then spliced into the SQL script of final verification business again.
In one embodiment, a service node SQL script first can be generated according to model, is then closed further according to the association between model
System, service node SQL script is stitched together automatically generate verification business SQL verification script account fund is checked.
The position placed after automatically generating verification business SQL verification script due to the subquery of SQL or screening item
The factors such as the sequence of part and screening conditions can all cause the difference of execution efficiency to mention to further speed up the rate of verification
High account fund checks efficiency, can also advanced optimize processing to the SQL script of the business of verification account fund.At one
In embodiment, since the screening field for including in model is extracted from various types of accounts, all to all accounts
It is applicable, thus these fields may be fewer, the range that the script of generation needs to inquire when verification is very wide, efficiency ratio
It is lower.So the SQL foot of the business of verification account fund can be shortened by adding some preset fields in SQL script
This time that account fund is checked, for example, the field that can add an account time of origin either adds a note
The a series of fields such as the field of last modification time of record go to limit the range checked, to reduce Run Script stoning to account
The time of fund.For example, check range can be limited to account time of origin in 8:00~12 according to actual verification demand:
00 business datum, or only business datum of the verification modification time after 12:00.Preset rules are added according to actual needs
After limiting check range, verification efficiency can be greatly improved.
In one embodiment, in order to improve the verification efficiency of script, according to the pass between the model and model
It, can also be in the SQL of the business of verification account fund after connection relationship generates the SQL verification script of the business of verification account fund
It checks and adds mapjoin function in script, mapjoin all can read in small table in memory, directly take other one in the map stage
Table data match in the data and memory of a table, due to being to have carried out join operation in map, eliminate reduce operation, effect
Rate also can be much higher.In addition, mapjoin be there are one very big benefit be able to carry out the join operation of not equal connections, if
Conditions will not be waited to write in where, then will do it cartesian product during mapreduce, operational efficiency is especially low, if made
It is operated with mapjoin, the join operation of non-equivalence is just completed during map, efficiency can be much higher.
Since when configuration querying condition, the function that duplication is pasted can be used in configuration interface in user, thus system can
With the configuration condition repeated when initiative recognition configuration querying condition, the part of multiplexing is recorded, in verification account
When the SQL script of the business of fund checks the account fund, system can create an interim offline table, by the meeting weight of record
The query result of existing subquery of appearing again stores, when encountering identical subquery next time, to call directly storage
Query result of the query result as identical subquery.The efficiency of script verification can be greatly improved in this way.
In one embodiment, it is necessary to which the business of the account fund of verification includes amount incurred detail verification business, amount incurred
Summarize verification business and/or balance check business.Under normal conditions, the verification of account fund includes three parts, and first part is
Amount incurred detail verification, by having configured querying condition in configuration interface, by querying condition business and account be mapped to industry
Business model and financial model, and the incidence relation of business and account is mapped to the incidence relation between model, so that it may it is automatic raw
Each inflow and outflow is all carried out to the amount of money of business and account and the detail core in inflow and outflow direction at SQL verification script
It is right.Second part is that amount incurred summarizes verification, and the business model and incidence relation mapped by configured querying condition can
Summarized with the transaction to all same directions in one day, cuts amount incurred the day on the amount of money and account after summarizing and carry out core
It is right.Part III is balance check, is not carried down the expression formula of state by how to clean in user configuration querying condition, so that it may
To wash out all amount of money that do not carry down on this account historical with full dose table, checked with the remaining sum of account table.
Due in audit process, often there are some abnormal data, at this time need that user is prompted to there is appearance different
Normal data, and these data are exported.In one embodiment, script reconciliation is checked in the verification business SQL by generating
After family fund is checked, it is also necessary to the data for occurring abnormal in audit process are output to user interface according to preset format,
The output format of abnormal data can specifically be set based on verification business, and different verification business department uses different output formats,
For example, the verification of amount incurred detail business, amount incurred summarize verification business and balance check business, they last need to export
The information of abnormal data may be different, it is possible to specific setting according to actual needs.
In order to be explained further in this explanation account fund verification method, below again with a specific embodiment into
One step explanation.
Since Alipay is more more and more universal, the user of Alipay is also more and more, Alipay red packet use also very frequency
It is numerous, since Alipay red packet business circulates and surplus budgetary funds number is more daily, the amount incurred detail of red packet business, amount incurred are converged
Total and remaining sum verification is also most important.In order to allow user can be more intuitive and conveniently in verification, account be checked in user
When fund, a configuration interface may provide the user with, as shown in Fig. 2, configuration interface includes different control icons, such as add
Node control icons 26, deletion of node control icons 27, editor's node icon 28, node incidence relation select icon 29, pass through
These icons are clicked, user is in the process configuration querying condition specifically checked in configuration interface according to red packet business, Yong Hupei
The querying condition set can be indicated in the form of node diagram, and each service node that red packet business includes is indicated by node diagram
And the incidence relation of each service node.Since red packet business includes giving bonus 21, neck red packet 22, moving back 23 three parts industry of red packet
Business, i.e. therefore three service nodes can add this service node in configuration interface figure, and give bonus, lead red packet, move back it is red
Wrapping three business may also include subservice, i.e., the available incidence relation for passing through addition business child node and child node is by three
Service node further refines, and is clearly depicted and, such as moving back 23 node of red packet business includes business child node money transfer table
It 24 and transfers accounts underlying table 25.After having added node, node can be edited, according to the option input nucleus pair of configuration interface
Some necessary information that business needs.Incidence relation between node can be selected by the node incidence relation clicked in interface
It selects control icons 29 to be selected, the incidence relation between node is corresponding with the connection sentence in SQL, including lateral connection and vertical
To connection, wherein lateral connection includes four kinds of relationships, i.e., left outside connection (Left outer join), right outer connection (Right
Outer join), complete outer connection (Full outer join) and/or equivalent connection (inner join), longitudinally connected includes two
Kind connection relationship, it may be assumed that Union all and/or Union.Wherein, it gives bonus, leads red packet, moves back between three service nodes of red packet
Incidence relation is Union all, therefore Union all is selected in selection, and the business child node in three service nodes
Incidence relation can select according to the actual situation.After the node diagram for having configured Alipay red packet business, system can be according to node
Each node is mapped to model by figure, and by the relationship map between node at the relationship of model, the service node that such as gives bonus is mapped to
Give bonus business model, and neck red packet service node is mapped to neck red packet business model, moves back red packet service node and is mapped to and moves back red packet
Business model.Wherein, these business models are a tables of data predetermined, and tables of data contains service node screening inquiry
As a result the field needed, for example it is biz_id (business that this service node screening query result that gives bonus, which needs the field for including,
Id), actual_amount (amount of money), direction (fund inflow and outflow direction), biz_time (business time of origin), then
It needs to include these fields in tables of data.User can input the information of these fields when configuration section point diagram, then system
In the information MAP to model of user's input, and the incidence relation between model is the incidence relation between node, with
Connection in SQL is corresponding with sentence.Such as giving bonus and lead the incidence relation between the two service nodes of red packet is Union
All, the i.e. incidence relation of the model of the two service nodes are also Union all, refer to the mould needed to two service nodes
The tables of data of type carries out Union all and operates to obtain the data of red packet business.Before obtaining model and model
After incidence relation, system can automatically generate the SQL script for checking the business that gives bonus according to the business model that gives bonus, according to neck red packet
Business model automatically generates the SQL script of verification neck red packet business, moves back red packet according to moving back red packet business model and automatically generating verification
The SQL script of business will check the SQL script for the business that gives bonus, verification is led then according to the incidence relation of three service nodes
The SQL script that red packet business is moved back in the SQL script of red packet business and verification is stitched together to obtain the SQL of final verification red packet business
Script.After the SQL script for generating verification red packet business, some screening words are added in script further according to practical verification demand
Section, for example the data that account time of origin is 8:00-12:00 need to be only checked, verification this word of account time of origin can be added
Section.The verification time of SQL script can be shortened in this way, improve verification efficiency.As shown in fig. 6, such as occurring abnormal in audit process
Data, then these abnormal datas are exported and are displayed in the user interface according to certain format, with remind user occur
It is abnormal.By this method, family can be used to be more clear and intuitively when helping configuration querying condition according to verification business, then
In conjunction with the design of user interface interaction, unfolding and folding for service node may be implemented, help user preferably from different levels
Thinking business association logic etc. is gone with dimension, and automatically generates verification script, without writing manually, guarantees the specification of verification script
Property, and be that checking work is more convenient.
Corresponding with the embodiment of the checking method in this specification, this specification additionally provides a kind of account fund verification
Device.As shown in fig. 7, described device 700 includes:
Configuration module 701 generates configuration interface, so that user is according to the business of verification account fund in the configuration interface
Middle configuration querying condition, wherein the querying condition is used to describe each business section that the business of the verification account fund includes
Incidence relation between point and the service node；
The service node is mapped to model according to the querying condition of user configuration by mapping block 702, and by institute
State the incidence relation that the incidence relation between service node is mapped between the model；
Script generation module 703 generates the verification account according to the incidence relation between the model and the model
The SQL script of the business of family fund；
Module 704 is checked, the account fund is checked by the SQL script of the business of the verification account fund.
In one embodiment, configuration querying condition includes following operation in the configuration interface: addition service node,
Delete the incidence relation between service node, editing affairs node and/or selection service node.
In one embodiment, the incidence relation between the service node includes lateral connection and longitudinally connected.
In one embodiment, the lateral connection include: left outside connection, right outer connection, complete outer connection and/or it is equivalent even
It connects.
In one embodiment, it is described it is longitudinally connected include: Union and/or Union all.
In one embodiment, the model includes the field of the query result of the screening service node.
In one embodiment, the field includes: account, the amount of money, fund inflow and outflow direction, service identification, business-
Account association, and/or business time of origin.
In one embodiment, the business of the verification account fund includes: amount incurred detail verification business, amount incurred remittance
Total verification business and/or balance check business.
In one embodiment, verification account fund is generated according to the incidence relation between the model and the model
The SQL script of business specifically include:
The SQL script of the business of verification service node is generated according to the model；
The SQL script of the business of the verification service node is spliced according to the incidence relation between the model, with life
At the SQL script of the verification business of the verification account fund；
In one embodiment, the method also includes, the abnormal data of verification are exported according to preset format, it is described pre-
If format is arranged based on the verification business.
In one embodiment, according between the model incidence relation generate verification business SQL verification script it
Afterwards, further includes:
Preset screening field is added in verification business SQL verification script.
In one embodiment, verification account fund is being generated according to the incidence relation between the model and model
After the SQL verification script of business, further includes:
Mapjoin function is added in the SQL verification script of the business of the verification account fund.
In one embodiment, the account fund packet is checked by the SQL script of the business of the verification account fund
It includes:
The query result of the interim offline table storage subquery of creation；
Use the query result as the query result of identical subquery.
The function of each unit and the realization process of effect are specifically detailed in the above method and correspond to step in above-mentioned apparatus
Realization process, details are not described herein.
For device embodiment, since it corresponds essentially to embodiment of the method, so related place is referring to method reality
Apply the part explanation of example.The apparatus embodiments described above are merely exemplary, wherein described be used as separation unit
The unit of explanation may or may not be physically separated, and component shown as a unit can be or can also be with
It is not physical unit, it can it is in one place, or may be distributed over multiple network units.It can be according to actual
The purpose for needing to select some or all of the modules therein to realize application scheme.Those of ordinary skill in the art are not paying
Out in the case where creative work, it can understand and implement.
In addition, such as Fig. 8, the equipment 800 can be used for account fund verification present invention also provides a kind of equipment, comprising:
Memory 801, for storing executable computer instruction；
Processor 802 realizes claim following steps when for executing the computer instruction:
Generate configuration interface so that user according to verification account fund business in the configuration interface configuration querying item
Part, wherein the querying condition is used to describe each service node and the industry that the business of the verification account fund includes
Incidence relation between business node；
According to the querying condition of user configuration, the service node is mapped to model, and by the service node it
Between incidence relation be mapped to the incidence relation between the model；
The SQL of the business of the verification account fund is generated according to the incidence relation between the model and the model
Script；
The account fund is checked by the SQL script of the business of the verification account fund.
Since all or part of the application the part that contributes to existing technology or the technical solution can be with soft
The form of part product embodies, which is stored in a storage medium, including some instructions are to make
Obtain all or part of the steps that a terminal device executes each embodiment method of the application.And storage medium above-mentioned includes: U
Disk, mobile hard disk, read-only memory (Read-Only Memory, ROM), random access memory (Random Access
Memory, RAM), the various media that can store program code such as magnetic or disk.
The foregoing is merely the preferred embodiments of the application, not to limit the application, all essences in the application
Within mind and principle, any modification, equivalent substitution, improvement and etc. done be should be included within the scope of the application protection.
Claims (15)
1. a kind of account fund checking method, which comprises
Generate configuration interface so that user according to verification account fund business in the configuration interface configuration querying condition,
Wherein, the querying condition is used to describe each service node and the business section that the business of the verification account fund includes
Incidence relation between point；
According to the querying condition of user configuration, the service node is mapped to model, and will be between the service node
Incidence relation is mapped to the incidence relation between the model；
The SQL script of the business of verification account fund is generated according to the incidence relation between the model and the model；
The account fund is checked by the SQL script of the business of the verification account fund.
2. a kind of account fund checking method as described in claim 1, configuration querying condition includes in the configuration interface
Operate below: addition service node, the association deleted between service node, editing affairs node and/or selection service node are closed
System.
3. a kind of account fund checking method as described in claim 1, the incidence relation between the service node includes cross
To connection and it is longitudinally connected.
4. a kind of account fund checking method as claimed in claim 3, the lateral connection includes: left outside connection, right outer connects
It connects, complete outer connection and/or equivalence connect.
5. a kind of account fund checking method as claimed in claim 3, it is described it is longitudinally connected include: Union and/or Union
all。
6. a kind of account fund checking method as described in claim 1, the model includes the inquiry knot for screening service node
The field of fruit.
7. a kind of account fund checking method as claimed in claim 6, the field includes: that account, the amount of money, cash flow become a mandarin
Direction, service identification and/or business time of origin out.
8. the business of a kind of account fund checking method as described in claim 1, the verification account fund includes: amount incurred
Detail verification business, amount incurred summarize verification business and/or balance check business.
9. a kind of account fund checking method as described in claim 1, according to the pass between the model and the model
The SQL script that connection relationship generates the business of verification account fund specifically includes:
The SQL script of the business of verification service node is generated according to the model；
The SQL script of the business of the verification service node is spliced according to the incidence relation between the model, to generate
State the SQL script of the business of verification account fund.
10. a kind of account fund checking method as described in claim 1, the method also includes by the data that verification is abnormal
It is exported according to preset format.
11. a kind of account fund checking method as described in claim 1, according to the association between the model and model
Relationship generates after the SQL verification script of the business of verification account fund, further includes:
The field of preset screening query result is added in the SQL verification script of the business of the verification account fund.
12. a kind of account fund checking method as described in claim 1, according to the association between the model and model
Relationship generates after the SQL verification script of the business of verification account fund, further includes:
Mapjoin function is added in the SQL verification script of the business of the verification account fund.
13. a kind of account fund checking method as described in claim 1 passes through the SQL of the business of the verification account fund
Script checks the account fund
The query result of the interim offline table storage subquery of creation；
Use the query result as the query result of identical subquery.
14. a kind of account fund checking device, comprising:
Configuration module generates configuration interface, so that user configures in the configuration interface according to the business of verification account fund
Querying condition, wherein the querying condition be used to describe the verification account fund business each service node for including and
Incidence relation between the service node；
The service node is mapped to model according to the querying condition of user configuration by mapping block, and by the business section
Incidence relation between point is mapped to the incidence relation between the model；
Script generation module generates the verification account fund according to the incidence relation between the model and the model
The SQL script of business；
Module is checked, the account fund is checked by the SQL script of the business of the verification account fund.
15. a kind of equipment, the equipment include:
Memory, for storing executable computer instruction；
Processor, the step of claim 1 to 13 any the method is realized when for executing the computer instruction.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811374743.XA CN110046153B (en) | 2018-11-19 | 2018-11-19 | Account fund checking method, device and equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811374743.XA CN110046153B (en) | 2018-11-19 | 2018-11-19 | Account fund checking method, device and equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110046153A true CN110046153A (en) | 2019-07-23 |
| CN110046153B CN110046153B (en) | 2023-09-05 |
Family
ID=67273231
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811374743.XA Active CN110046153B (en) | 2018-11-19 | 2018-11-19 | Account fund checking method, device and equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110046153B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110781184A (en) * | 2019-09-16 | 2020-02-11 | 平安科技（深圳）有限公司 | Data table construction method, device, equipment and storage medium |
| CN111476659A (en) * | 2020-04-13 | 2020-07-31 | 浙江网商银行股份有限公司 | Business data processing method, system, component, computing device and storage medium |
| CN111639910A (en) * | 2020-05-27 | 2020-09-08 | 中国建设银行股份有限公司 | Standing book generation method, device, equipment and storage medium |
Citations (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040068489A1 (en) * | 2002-10-03 | 2004-04-08 | International Business Machines Corporation | SQL query construction using durable query components |
| CN101631041A (en) * | 2009-07-29 | 2010-01-20 | 中兴通讯股份有限公司 | Service configuration processing method and configuration relation management module |
| CN101872449A (en) * | 2010-06-25 | 2010-10-27 | 南京联创科技集团股份有限公司 | Customer information screening method |
| CN101894348A (en) * | 2010-07-20 | 2010-11-24 | 中兴通讯股份有限公司 | Self-expanded online transaction system and implementing method thereof |
| CN102693295A (en) * | 2012-05-15 | 2012-09-26 | 北京天威诚信电子商务服务有限公司 | Database record data query system based on record logical representation |
| CN103577590A (en) * | 2013-11-12 | 2014-02-12 | 北京润乾信息系统技术有限公司 | Data query method and system |
| CN104991975A (en) * | 2015-07-30 | 2015-10-21 | 广东电网有限责任公司佛山供电局 | Data query method and system of electric power business systems |
| CN105808413A (en) * | 2016-03-02 | 2016-07-27 | 上海新炬网络信息技术有限公司 | Business process visualization based SQL performance monitoring method |
| CN106874183A (en) * | 2016-07-05 | 2017-06-20 | 阿里巴巴集团控股有限公司 | Service exception detection method and device |
| CN107665181A (en) * | 2016-07-27 | 2018-02-06 | 中兴通讯股份有限公司 | A kind of method and system of centralized configuration equipment |
| CN107784003A (en) * | 2016-08-26 | 2018-03-09 | 阿里巴巴集团控股有限公司 | Data query method for detecting abnormality, device, equipment and system |
| CN108241624A (en) * | 2016-12-23 | 2018-07-03 | 北京国双科技有限公司 | The generation method and device of a kind of query script |
| US20180293277A1 (en) * | 2017-04-05 | 2018-10-11 | Sap Se | Explicit declaration of associations to optimize grouping of elements by large data objects |
| CN108733713A (en) * | 2017-04-21 | 2018-11-02 | 阿里巴巴集团控股有限公司 | Data query method and device in data warehouse |
-
2018
- 2018-11-19 CN CN201811374743.XA patent/CN110046153B/en active Active
Patent Citations (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040068489A1 (en) * | 2002-10-03 | 2004-04-08 | International Business Machines Corporation | SQL query construction using durable query components |
| CN101631041A (en) * | 2009-07-29 | 2010-01-20 | 中兴通讯股份有限公司 | Service configuration processing method and configuration relation management module |
| CN101872449A (en) * | 2010-06-25 | 2010-10-27 | 南京联创科技集团股份有限公司 | Customer information screening method |
| CN101894348A (en) * | 2010-07-20 | 2010-11-24 | 中兴通讯股份有限公司 | Self-expanded online transaction system and implementing method thereof |
| CN102693295A (en) * | 2012-05-15 | 2012-09-26 | 北京天威诚信电子商务服务有限公司 | Database record data query system based on record logical representation |
| CN103577590A (en) * | 2013-11-12 | 2014-02-12 | 北京润乾信息系统技术有限公司 | Data query method and system |
| CN104991975A (en) * | 2015-07-30 | 2015-10-21 | 广东电网有限责任公司佛山供电局 | Data query method and system of electric power business systems |
| CN105808413A (en) * | 2016-03-02 | 2016-07-27 | 上海新炬网络信息技术有限公司 | Business process visualization based SQL performance monitoring method |
| CN106874183A (en) * | 2016-07-05 | 2017-06-20 | 阿里巴巴集团控股有限公司 | Service exception detection method and device |
| CN107665181A (en) * | 2016-07-27 | 2018-02-06 | 中兴通讯股份有限公司 | A kind of method and system of centralized configuration equipment |
| CN107784003A (en) * | 2016-08-26 | 2018-03-09 | 阿里巴巴集团控股有限公司 | Data query method for detecting abnormality, device, equipment and system |
| CN108241624A (en) * | 2016-12-23 | 2018-07-03 | 北京国双科技有限公司 | The generation method and device of a kind of query script |
| US20180293277A1 (en) * | 2017-04-05 | 2018-10-11 | Sap Se | Explicit declaration of associations to optimize grouping of elements by large data objects |
| CN108733713A (en) * | 2017-04-21 | 2018-11-02 | 阿里巴巴集团控股有限公司 | Data query method and device in data warehouse |
Non-Patent Citations (2)
| Title |
|---|
| COEN DE ROOVER等: "The SOUL tool suit for querying programs in symbiosis with Eclipse", 《PPPJ 11:PROCEEDINGS OF THE 9TH INTERNATIONAL CONFERENCE ON PRINCIPLES AND PRACICE OF PROGRAMMING IN JAVA》, pages 71 - 80 * |
| 赵桥: "面向汽车产业链协同SaaS平台的报表定制与管理系统研发", 《中国优秀硕士学位论文全文数据库信息科技辑》, no. 01, pages 138 - 70 * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110781184A (en) * | 2019-09-16 | 2020-02-11 | 平安科技（深圳）有限公司 | Data table construction method, device, equipment and storage medium |
| CN110781184B (en) * | 2019-09-16 | 2023-06-16 | 平安科技（深圳）有限公司 | Data table construction method, device, equipment and storage medium |
| CN111476659A (en) * | 2020-04-13 | 2020-07-31 | 浙江网商银行股份有限公司 | Business data processing method, system, component, computing device and storage medium |
| CN111476659B (en) * | 2020-04-13 | 2023-08-15 | 浙江网商银行股份有限公司 | Service data processing method, system, component, computing device and storage medium |
| CN111639910A (en) * | 2020-05-27 | 2020-09-08 | 中国建设银行股份有限公司 | Standing book generation method, device, equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110046153B (en) | 2023-09-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11714792B2 (en) | Creating data in a data store using a dynamic ontology | |
| US5195178A (en) | Adaptive window system for dynamically modeling information systems | |
| US5212771A (en) | System for establishing concurrent high level and low level processes in a diagram window through process explosion and implosion subsystems | |
| US8024373B2 (en) | Computer-implemented system for producing, processing and managing structured data sets | |
| US8020144B2 (en) | Metadata-based application deployment | |
| CN102754072B (en) | Regulation user interface element | |
| US5193182A (en) | Computer system for defining logical operations on design data including retrieve entity-set, send, receive, signal, when, reference to entity-set, reference to entity method, connect and disconnect | |
| US7822795B2 (en) | Apparatus and methods for displaying and determining dependency relationships among subsystems in a computer software system | |
| US5146591A (en) | Dynamic information management system utilizing entity-relationship information model in which the attribute is independent of an entity | |
| CN107894953A (en) | A kind of generation method and device of Bank application test data | |
| CN108600148B (en) | Transaction message processing method and device | |
| CN110046153A (en) | A kind of method, device and equipment of account fund verification | |
| US20060282400A1 (en) | Apparatus, system, and method for encapsulating logical units of work using business objects | |
| KR20030074647A (en) | A method of configuring a product | |
| CN102341781A (en) | Software test bed generation | |
| CN101617292A (en) | Programming and execution towards producer graph | |
| JP2003500748A (en) | Method and apparatus for selecting aggregate level and cross-product level in a data warehouse | |
| CN107644286A (en) | Workflow processing method and device | |
| CN107665171A (en) | Automatic regression test method and device | |
| CN108921600A (en) | Realize the device and method and storage medium of information classification | |
| CN107562459A (en) | Management system, interface generation/display/operation/display methods, end-of-medium | |
| US20070156742A1 (en) | Visual modeling method and apparatus | |
| CN103778154B (en) | The retrography method and device of form attributes | |
| CN116627418B (en) | Multi-level form interface visual generation method and device based on recursion algorithm | |
| CN110209744A (en) | Relevant database and its operating method and device based on alliance's chain |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20200923 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant after: Innovative advanced technology Co.,Ltd. Address before: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant before: Advanced innovation technology Co.,Ltd. Effective date of registration: 20200923 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant after: Advanced innovation technology Co.,Ltd. Address before: A four-storey 847 mailbox in Grand Cayman Capital Building, British Cayman Islands Applicant before: Alibaba Group Holding Ltd. |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |