CN107862067A - A kind of screening technique and device of bank loan data query - Google Patents
A kind of screening technique and device of bank loan data query Download PDFInfo
- Publication number
- CN107862067A CN107862067A CN201711146368.9A CN201711146368A CN107862067A CN 107862067 A CN107862067 A CN 107862067A CN 201711146368 A CN201711146368 A CN 201711146368A CN 107862067 A CN107862067 A CN 107862067A
- Authority
- CN
- China
- Prior art keywords
- account
- screening conditions
- level
- loan
- correlation
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
- G06F16/24539—Query rewriting; Transformation using cached or materialised query results
-
- 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/03—Credit; Loans; Processing thereof
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- General Physics & Mathematics (AREA)
- Development Economics (AREA)
- Technology Law (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Marketing (AREA)
- Economics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention provides a kind of screening technique and device of bank loan data query, by receiving multiple first account correlation screening conditions in loan data inquiry request, judge whether the first account correlation screening conditions meet its corresponding constraints further according to the script file of local, so as to which the first account screening conditions are carried out level fractionation by the level according to belonging to each first account correlation screening conditions, and the progress of all first account correlation screening conditions and computing by each level, obtain the second account correlation screening conditions of each level, by the progress of the second account correlation screening conditions and computing, obtain the 3rd account correlation screening conditions, the scheme of loan account data query is finally carried out according to the 3rd account correlation screening conditions.The present invention solve complex operation in the prior art and to the direct operational risk of database it is big the problems such as, realize convenient, safety, high quality filters out bank loan data, and obtain basic data for banking business analysis support is provided.
Description
Technical field
The present invention relates to bank loan data query technique field, more particularly to a kind of screening of bank loan data query
Method and device.
Background technology
As banking system data volume is increasing, head office of bank returns to multiple one-level branch loan accounts by conditional filtering
The information of user data, basic data is obtained to banking business analysis support is provided.But technical staff is each according to customer demand
Screening conditions, complex operation are set manually in database.Because technical staff directly operates to core database, once
Operational error will cause irretrievable loss.Simultaneously as the data accuracy obtained using independent screening conditions is poor,
Influence technique personnel's decision-making.
Therefore, how convenient, safety, the bank data that filters out of high quality are current technical problems urgently to be resolved hurrily.
The content of the invention
To solve defect present in prior art, the present invention propose a kind of bank loan data query screening technique and
Device, there is convenient, safety, high quality to filter out bank data, and obtain basic data for banking business analysis and provide and prop up
The beneficial effect held.
The invention provides a kind of screening technique of bank loan data query, this method includes:
Receive loan data inquiry request;The loan data inquiry request includes the related screening bar of multiple first accounts
Part;
According to the script file of local, judge whether the first account correlation screening conditions meet constraint bar corresponding to it
Part;
If it is, the level according to belonging to each first account correlation screening conditions carries out the first account screening conditions
Level is split;The level includes:Account level and the customer level associated with account level and gage level;
All first account correlation screening conditions of each level are carried out and computing, obtain the second account of each level
Related screening conditions;
By the second account correlation screening conditions progress and computing, the 3rd account correlation screening conditions are obtained;
Loan account data query is carried out according to the 3rd account correlation screening conditions.
The screening technique of bank loan data query provided by the invention is more in loan data inquiry request by receiving
Individual first account correlation screening conditions, judge whether the first account correlation screening conditions meet it further according to the script file of local
Corresponding constraints, so as to which the level according to belonging to each first account correlation screening conditions carries out the first account screening conditions
Level is split, and all first account correlation screening conditions of each level are carried out and computing, obtains the second account of each level
Family correlation screening conditions, by the progress of the second account correlation screening conditions and computing, the 3rd account correlation screening conditions are obtained, finally
According to the 3rd account correlation screening conditions carry out loan account data query method, solve complex operation in the prior art and
The problems such as big to the direct operational risk of database, realize convenient, safety, high quality filters out bank loan data, and be
Banking business analysis obtains basic data and provides support.
The invention provides a kind of screening plant of bank loan data query, including:
Receiving unit, for receiving loan data inquiry request;The loan data inquiry request includes multiple first accounts
Family correlation screening conditions;
Judging unit, for the script file according to local, judge whether the first account correlation screening conditions meet
Its corresponding constraints;
Split cells, first account is screened into bar for the level according to belonging to each first account correlation screening conditions
Part carries out level fractionation;The level includes:Account level and the customer level associated with account level and gage level;
First arithmetic element, for all first account correlation screening conditions of each level to be carried out and computing, obtain
Second account correlation screening conditions of each level;
Second arithmetic element, for by the second account correlation screening conditions carry out and computing, obtain the 3rd account phase
Close screening conditions;
Query unit, for carrying out loan account data query according to the 3rd account correlation screening conditions.
The screening plant of bank loan data query provided by the invention, by receiving unit, judging unit, split list
Member, the first arithmetic element, the second arithmetic element and query unit, solves complex operation in the prior art and direct to database
The problems such as operational risk is big, realizes convenient, safety, high quality filters out bank loan data, and is banking business analysis
Obtain basic data and support is provided.
Present invention also offers a kind of computer equipment, including memory, processor and to be stored in storage upper and can locate
The computer program that runs on reason device, following steps are realized during the computing device described program:
Receive loan data inquiry request;The loan data inquiry request includes the related screening bar of multiple first accounts
Part;
According to the script file of local, judge whether the first account correlation screening conditions meet constraint bar corresponding to it
Part;
If it is, the level according to belonging to each first account correlation screening conditions carries out the first account screening conditions
Level is split;The level includes:Account level and the customer level associated with account level and gage level;
All first account correlation screening conditions of each level are carried out and computing, obtain the second account of each level
Related screening conditions;
By the second account correlation screening conditions progress and computing, the 3rd account correlation screening conditions are obtained;
Loan account data query is carried out according to the 3rd account correlation screening conditions.
Present invention also offers a kind of computer-readable recording medium, computer program is stored thereon with, the program is located
Reason device realizes following steps when performing:
Receive loan data inquiry request;The loan data inquiry request includes the related screening bar of multiple first accounts
Part;
According to the script file of local, judge whether the first account correlation screening conditions meet constraint bar corresponding to it
Part;
If it is, the level according to belonging to each first account correlation screening conditions carries out the first account screening conditions
Level is split;The level includes:Account level and the customer level associated with account level and gage level;
All first account correlation screening conditions of each level are carried out and computing, obtain the second account of each level
Related screening conditions;
By the second account correlation screening conditions progress and computing, the 3rd account correlation screening conditions are obtained;
Loan account data query is carried out according to the 3rd account correlation screening conditions.
The screening technique and device of bank loan data query provided by the invention, by receiving unit, receive loan number
According to multiple first account correlation screening conditions in inquiry request, then by judging unit, judged according to the script file of local
Whether the first account correlation screening conditions meet its corresponding constraints, so that by split cells, according to each first account
First account screening conditions are carried out level fractionation by the level belonging to related screening conditions, and by two arithmetic elements, will be every
All first account correlation screening conditions of individual level carry out and computing, obtain the related screening bar of the second account of each level
Part, by the progress of the second account correlation screening conditions and computing, the 3rd account correlation screening conditions are obtained, finally by cargo tracer
Cloud, the scheme of loan account data query is carried out according to the 3rd account correlation screening conditions.The present invention solves in the prior art
Complex operation and to database direct operational risk it is big the problems such as, realize convenient, safety, high quality filters out bank loan
Data, and obtain basic data for banking business analysis and support is provided.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is the required accompanying drawing used in technology description to be briefly described, it should be apparent that, drawings in the following description are only this
Some embodiments of invention, for those of ordinary skill in the art, on the premise of not paying creative work, can be with
Other accompanying drawings are obtained according to these accompanying drawings.
Fig. 1 is a kind of flow chart of the screening technique of bank loan data query of the application;
Fig. 2 is the structure chart of the hierarchical classification of the embodiment of the application one;
Fig. 3 is the flow chart of the screening technique of the bank loan data query of the embodiment of the application one;
Fig. 4 is a kind of structural representation of the screening plant of bank loan data query of the application;
Fig. 5 is the structural representation of the screening plant of the bank loan data query of the embodiment of the application one.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete
Site preparation describes, it is clear that described embodiment is only part of the embodiment of the present invention, rather than whole embodiments.It is based on
Embodiment in the present invention, those of ordinary skill in the art are obtained every other under the premise of creative work is not made
Embodiment, belong to the scope of protection of the invention.
The invention provides a kind of screening technique of bank loan data query, its flow chart is as shown in figure 1, this method bag
Include following steps:
S101:Receive loan data inquiry request;The loan data inquiry request includes the related sieve of multiple first accounts
Select condition;
S102:According to the script file of local, judge whether the first account correlation screening conditions meet corresponding to it
Constraints;
S103:If it is, first account is screened bar by the level according to belonging to each first account correlation screening conditions
Part carries out level fractionation;The level includes:Account level and the customer level associated with account level and gage level;
S104:All first account correlation screening conditions of each level are carried out and computing, obtain the of each level
Two account correlation screening conditions;
S105:By the second account correlation screening conditions progress and computing, the 3rd account correlation screening conditions are obtained;
S106:Loan account data query is carried out according to the 3rd account correlation screening conditions.
Knowable to flow as shown in Figure 1, a kind of screening technique of bank loan data query provided by the invention, by connecing
Multiple first account correlation screening conditions of the carrying in loan data inquiry request are received, are judged further according to the script file of local
Whether the first account correlation screening conditions meet its corresponding constraints, so as to according to each first account correlation screening conditions institute
First account screening conditions are carried out level fractionation by the level of category, and all first account correlation screening conditions of each level are entered
Row and computing, the second account correlation screening conditions of each level are obtained, the second account correlation screening conditions are carried out and computing,
The 3rd account correlation screening conditions are obtained, finally carry out loan account data query, solution according to the 3rd account correlation screening conditions
Complex operation in the prior art of having determined and to database direct operational risk it is big the problems such as, realize convenient, safety, high quality
Bank loan data are filtered out, and obtains basic data for banking business analysis and support is provided.Wherein, customer level and gage
Level is associated with account level, and loan account data query is carried out centered on account level, and according to three levels
First account screening conditions independent assortment, the screening technique of bank loan data query provided by the invention, which is returned only to, meets screening
Loan account data (the loan account of condition:Client establishes account of the product code for loan class in banking system).
In one embodiment, loan data inquiry request is received, can be from described in the reception of loan account query interface
Loan data inquiry request.
When it is implemented, loan account query interface is used for the friendship for providing the user the first account correlation screening conditions of selection
Mutual interface, including the selectionbar of the first account screening conditions and inquiry button.User is in loan account query interface, in selectionbar
In under each level the first account correlation screening conditions carry out unrestricted choice, by Clicks Query button, to the loan on backstage
Account inquiries system sends the first account correlation screening conditions of loan data inquiry request and selection, the present invention not as
Limit.
In one embodiment, as shown in Fig. 2 the screening technique of bank loan data query also comprises the following steps:
S201:According to the first account correlation screening conditions, the parameter area of the first account correlation screening conditions, the first account
The level of related screening conditions, the mutual exclusion screening conditions of the first account correlation screening conditions write the script file.
When it is implemented, as shown in figure 3, the level division of the first account correlation screening conditions is specific as follows:
1st, customer level:
Type of credential, represent the type of credential that client uses in core system, parameter area:It is required that user input values accord with
Close the digit and coding rule of identification card number.
Nationality, represent nationality of the client in core system, parameter area:It is required that user input values are appointed for currently known
The full name or abbreviation of one country.
Ten three-levels are classified automatically, represent automatic classification of risks of the client in core system, parameter area:It is required that user is defeated
Enter value for one of the classification automatically of ten three-levels.
Ten three-level manual sorts, represent manual classification of risks of the client in core system, parameter area:It is required that user is defeated
Enter value for one of ten three-level manual sorts.
To public Client Enterprise scale, Ministry of Industry and Information's Standard capacity, parameter area in core system are represented to public client:It is required that
User input values are positive integer.
To public client's trade classification, the trade classification in core system, parameter area to public client are represented:It is required that user is defeated
Enter value for one of currently known industry.
To private client's date of birth minimum value, typing date of birth date minimum value bar of the client in core system is represented
Part, parameter area:It is required that user input values are date information.
To private client's date of birth maximum, typing date of birth date maximum bar of the client in core system is represented
Part, parameter area:It is required that user input values are date information.
Customer credit ratings, represent credit appraisal condition of the client in core system, parameter area:It is required that user inputs
It is worth for one of known credit rating.
In the first account correlation screening conditions of customer level client certificate type, client nationality, to public Client Enterprise
Scale, it is single condition to public client's trade classification and customer credit ratings, can independently selects also may be used between each screening conditions
With simultaneous selection;Automatically classification and the three-level manual sort of client ten are mutual exclusion screening conditions to the three-level of client ten, and the three-level of client ten is certainly
Dynamic classification can only select alternative one as screening conditions with the three-level manual sort of client ten, then free with other screening conditions again
Combination;And be a pair of combination conditions to private client's date of birth minimum value and to private client's date of birth maximum, pass through setting
The value of screening conditions is combined as the screening scope in an opening and closing section, therefore constrains one another, and minimum value is certainly less than maximum,
The then incorrect data input when minimum value is more than or equal to maximum.
2nd, account level:
Account one-level branch, represent the affiliated one-level branch of loan account of the client in core system, parameter area:It is required that
User input values are one of affiliated one-level branch of loan account known to one's own profession.
Account product major class, represent loan account product category of the client in core system, parameter area:It is required that user
Input value is one of loan account product category known to one's own profession.
Account currency, represent the currency code of loan account of the client in core system, parameter area:It is required that user inputs
It is worth for one of currency code of known one's own profession loan account.
Account is made loans date minimum value, is represented loan account of the client in core system and is made loans date minimum conditions,
Parameter area:It is required that user input values are date information.
Account is made loans date maximum, is represented loan account of the client in core system and is made loans date maximum condition,
Parameter area:It is required that user input values are date information.
Expiration Date minimum value, represent loan account Expiration Date minimum conditions of the client in core system, parameter area:
It is required that user input values are date information.
Expiration Date maximum, represent loan account Expiration Date maximum condition of the client in core system, parameter area:
It is required that user input values are date information.
Financial minimum value is checked and approved, loan account of the client in core system is represented and checks and approves amount of money minimum conditions, parameter
Scope:It is required that user input values provide to meet the amount of the loan.
Amount of money maximum is checked and approved, loan account of the client in core system is represented and checks and approves amount of money maximum condition, parameter
Scope:It is required that user input values provide to meet the amount of the loan.
Account is made loans amount of money minimum value, is represented loan account of the client in core system and is made loans amount of money minimum conditions,
Parameter area:It is required that user input values provide to meet the amount of money of making loans.
Account is made loans amount of money maximum, is represented loan account of the client in core system and is made loans amount of money maximum condition,
Parameter area:It is required that user input values provide to meet the amount of money of making loans.
Principal balance minimum value, represent loan account principal balance minimum conditions of the client in core system, parameter
Scope:It is required that user input values provide to meet principal balance.
Principal balance maximum, represent loan account principal balance maximum conditional parameter model of the client in core system
Enclose:It is required that user input values provide to meet principal balance.
Interest minimum value is performed, represents loan account exercise rate minimum conditions of the client in core system, parameter
Scope:It is required that user input values perform interest regulation to meet.
Exercise rate maximum, represent loan account exercise rate maximum conditional parameter model of the client in core system
Enclose:It is required that user input values perform interest regulation to meet.
Interest rate floats than minimum value, represents loan account floating interest rate of the client in core system than minimum conditions,
Parameter area:It is required that user input values are interest rate floating ratio.
Interest rate floats than maximum, represents loan account floating interest rate of the client in core system than maximum condition,
Parameter area:It is required that user input values are interest rate floating ratio.
Interest rate float value minimum value, loan account floating interest rate value minimum conditions of the client in core system are represented,
Parameter area:It is required that user input values are interest rate float value.
Interest rate float value maximum, loan account floating interest rate value maximum condition of the client in core system is represented,
Parameter area:It is required that user input values are interest rate float value.
Floating interest rate minimum value during granting, it is minimum to represent floating interest rate when loan account of the client in core system is provided
Value condition, parameter area:It is required that user input values are floating interest rate.
Floating interest rate maximum during granting, it is maximum to represent floating interest rate when loan account of the client in core system is provided
Value condition, parameter area:It is required that user input values are floating interest rate.
In the first account correlation screening conditions of account level, one-level branch, product category, currency is single condition,
Can independently be selected between each screening conditions can also simultaneous selection;Date minimum value of making loans and date maximum of making loans, expire
Day minimum value and Expiration Date maximum, financial minimum value is checked and approved with checking and approving amount of money maximum, amount of money minimum value of making loans and gold of making loans
Volume maximum, principal balance minimum value and principal balance maximum, execution interest minimum value and exercise rate maximum, interest rate float
It is dynamic to be floated than minimum value and interest rate than profit of being floated when maximum, interest rate float value minimum value and interest rate float value maximum, granting
Floating interest rate maximum is the combination condition that maximum forms by minimum value when rate minimum value is with providing, and is screened by setting
The value of condition is combined as the screening scope in an opening and closing section, therefore constrains one another, and minimum value is certainly less than maximum, when most
Then incorrect data input when small value is more than or equal to maximum.
3rd, gage level:
Account gage major class:The major class of client's gage associated by loan account in core system, parameter area:Will
It is one of major class of gage known to one's own profession to seek user input values.
In the first account correlation screening conditions of gage level, gage type is single condition, is by selection
Or it is no come obtain association this type gage target account.
There is no restriction relation independently of one another between above layers level, can independently select to select simultaneously between each level
Select.The first all account correlation screening conditions in above layers level can all select (for mutual exclusion screening conditions then only
Can the two select one), can also screening conditions type that only selection needs (for combination condition must simultaneous selection, combination makes
With), meet target loan account information under client condition by limiting the first account correlation screening conditions to obtain, the present invention is not
As limit.Finally, according to the parameter model of known above-mentioned first account correlation screening conditions, the first account correlation screening conditions
Enclose, the mutual exclusion screening conditions of the level of the first account correlation screening conditions and the first account correlation screening conditions write script text
Part.
S202:Store and run the script file, generate the bank loan account inquiries interface.
When it is implemented, according to the above-mentioned script file write, run in the specified running environment of Bank of China's system
Above-mentioned script file, generation bank loan account inquiries interface, for user in bank loan account inquiries interface according to demand
Unrestricted choice the first account correlation screening conditions, parameter corresponding to input, and the bank loan account inquiries system hair to backstage
Send query statement.
In one embodiment, it is described to judge whether the first account screening conditions meet the first account screening bar
The constraints of part, including:
Judge whether the parameter of the first account screening conditions in the parameter area of the first account screening conditions
And the mutual exclusion screening conditions of the first account screening conditions are not present in the first account screening conditions.
Wherein, the constraints of the first account correlation screening conditions includes:
The parameter of each first account screening conditions is in the parameter area of corresponding first account screening conditions.Such as
When first account correlation screening conditions of selection are combination condition, the requirement of corresponding parameter area, which is that the first account is related, screens
Condition is that combination condition will select in pairs, it is impossible to individually selection first, and the minimum value in the combination condition that selects must be small
In maximum.
Mutual exclusion screening conditions are not present between each first account correlation screening conditions of selection.Such as in customer level
In, classification and ten three-levels are manually classified as mutual exclusion screening conditions to ten three-levels automatically, therefore can only select an account of conduct first
Related screening conditions, it is not possible to which simultaneous selection, the present invention are not limited.
When it is implemented, after inquiry request is received, multiple first account screening conditions of inquiry request selection are obtained.
According to script file, whether the parameter for each first account screening conditions for first determining whether to receive is in its corresponding first account
In the parameter area of screening conditions.If not in the parameter area of the first account screening conditions, account of getting a bank loan is looked into
Ask the prompt message that interface returns to the parameter input error of the first account screening conditions, and rebound bank loan account inquiries interface
Terminate this inquiry request;If in the parameter area of the first account screening conditions, continue to judge each the received
Whether mutual exclusion screening conditions are not present between one account screening conditions.If there is mutual exclusion screening conditions, then account of getting a bank loan
Family query interface returns to the prompt message of mutual exclusion screening conditions, and rebound bank loan account inquiries interface terminates this inquiry and asked
Ask;If there is no mutual exclusion screening conditions, then the level according to belonging to each first account correlation screening conditions is by multiple first accounts
Family screening conditions carry out level fractionation, and the present invention is not limited.
The screening technique of bank loan data query provided by the invention using loan account as goal condition, account level with
Customer level and gage level are Correlation Criteria, are set, layered shaping, obtained by the independent assortment of the first account screening conditions
Take required qualified bank loan account.The first of the screening technique of bank loan data query provided by the invention
Account screening conditions can be created flexibly, perform inquiry request according to the 3rd account screening conditions, while locally preserving the 3rd
The Query Result of account screening conditions and inquiry request, called for user and check inquiry corresponding to the 3rd account screening conditions
As a result, so as to realize user's single the first account screening conditions, the effect of Query Result is used for multiple times.Selected screening in the present invention
Condition is all the weight condition of risk control, by the various screening conditions of independent assortment, so as to accurately obtain risk partiality
Data, and the risk control of Query Result energy accurate instruction is handled.
The screening technique of bank loan data query provided by the invention is more in loan data inquiry request by receiving
Individual first account correlation screening conditions, judge whether the first account correlation screening conditions meet it further according to the script file of local
Corresponding constraints, so as to which the level according to belonging to each first account correlation screening conditions carries out the first account screening conditions
Level is split, and all first account correlation screening conditions of each level are carried out and computing, obtains the second account of each level
Family correlation screening conditions, by the progress of the second account correlation screening conditions and computing, the 3rd account correlation screening conditions are obtained, finally
Loan account data query is carried out according to the 3rd account correlation screening conditions.The present invention solve complex operation in the prior art and
The problems such as big to the direct operational risk of database, realize convenient, safety, high quality filters out bank loan data, and be
Banking business analysis obtains basic data and provides support.
Based on the screening technique identical application design with above-mentioned bank loan data query, present invention also offers one kind
The screening plant of bank loan data query, as described in example below.Due to the screening plant of the bank loan data query
The principle solved the problems, such as is similar to the screening technique of bank loan data query, therefore the screening dress of the bank loan data query
The implementation put may refer to the implementation of the screening technique of bank loan data query, repeats part and repeats no more.
Fig. 4 is the structural representation of the screening plant of the bank loan data query of the embodiment of the present application.As shown in figure 4,
A kind of screening plant of bank loan data query provided by the invention includes:Receiving unit 401, judging unit 402, split list
First 403, first arithmetic element 404, the second arithmetic element 405 and query unit 406.
Receiving unit 401, for receiving loan data inquiry request;The loan data inquiry request includes multiple first
Account correlation screening conditions;
Judging unit 402, for the script file according to local, judge whether the first account correlation screening conditions accord with
Close its corresponding constraints;
Split cells 403, first account is sieved for the level according to belonging to each first account correlation screening conditions
Condition is selected to carry out level fractionation;The level includes:Account level and the customer level and gage associated with account level
Level;
First arithmetic element 404, for all first account correlation screening conditions of each level to be carried out and computing, obtain
Obtain the second account correlation screening conditions of each level;
Second arithmetic element 405, for by the second account correlation screening conditions carry out and computing, obtain the 3rd account
Related screening conditions;
Query unit 406, for carrying out loan account data query according to the 3rd account correlation screening conditions.
In one embodiment, receiving unit 401 is specifically used for:The loan data is received from loan account query interface
Inquiry request.
In one embodiment, as shown in figure 5, a kind of screening plant of bank loan data query provided by the invention also
Including:Write unit 501 and execution unit 502
Unit 501 is write, for the parameter model according to the first account correlation screening conditions, the first account correlation screening conditions
Enclose, the level of the first account correlation screening conditions, the mutual exclusion screening conditions of the first account correlation screening conditions write the script
File;
Execution unit 502, for storing and running the script file, generate the bank loan account inquiries interface.
In one embodiment, judging unit 402 is specifically used for:
Judge whether the parameter of the first account screening conditions in the parameter area of the first account screening conditions
And the mutual exclusion screening conditions of the first account screening conditions are not present in the first account screening conditions.
The screening plant of bank loan data query provided by the invention, by receiving unit, judging unit, split list
Member, the first arithmetic element, the second arithmetic element and query unit, solves complex operation in the prior art and direct to database
The problems such as operational risk is big, realizes convenient, safety, high quality filters out bank loan data, and is banking business analysis
Obtain basic data and support is provided.
Based on the screening technique identical application design with above-mentioned bank loan data query, the application provides a kind of calculate
Machine equipment, as described in example below.Solve the principle of problem and the sieve of bank loan data query due to the computer equipment
Choosing method is similar, therefore the implementation of the computer equipment may refer to the implementation of the screening technique of bank loan data query, weight
Multiple part repeats no more.
In one embodiment, computer equipment includes:Memory, processor and to be stored in storage upper and can be in processor
The computer program of upper operation, as shown in figure 1, realizing following steps during computing device described program:
S101:Receive loan data inquiry request;The loan data inquiry request includes the related sieve of multiple first accounts
Select condition;
S102:According to the script file of local, judge whether the first account correlation screening conditions meet corresponding to it
Constraints;
S103:If it is, first account is screened bar by the level according to belonging to each first account correlation screening conditions
Part carries out level fractionation;The level includes:Account level and the customer level associated with account level and gage level;
S104:All first account correlation screening conditions of each level are carried out and computing, obtain the of each level
Two account correlation screening conditions;
S105:By the second account correlation screening conditions progress and computing, the 3rd account correlation screening conditions are obtained;
S106:Loan account data query is carried out according to the 3rd account correlation screening conditions.
Based on the screening technique identical application design with above-mentioned bank loan data query, the application provides a kind of calculate
Machine readable storage medium storing program for executing, as described in example below.Because the computer-readable recording medium solves principle and the bank of problem
The screening technique of loan data inquiry is similar, therefore the implementation of the computer-readable recording medium may refer to bank loan data
The implementation of the screening technique of inquiry, repeat part and repeat no more.
In one embodiment, computer program is stored with computer-readable recording medium, as shown in figure 1, the program
Following steps are realized when being executed by processor:
S101:Receive loan data inquiry request;The loan data inquiry request includes the related sieve of multiple first accounts
Select condition;
S102:According to the script file of local, judge whether the first account correlation screening conditions meet corresponding to it
Constraints;
S103:If it is, first account is screened bar by the level according to belonging to each first account correlation screening conditions
Part carries out level fractionation;The level includes:Account level and the customer level associated with account level and gage level;
S104:All first account correlation screening conditions of each level are carried out and computing, obtain the of each level
Two account correlation screening conditions;
S105:By the second account correlation screening conditions progress and computing, the 3rd account correlation screening conditions are obtained;
S106:Loan account data query is carried out according to the 3rd account correlation screening conditions.
The screening technique and device of bank loan data query provided by the invention, by receiving unit, receive loan number
According to multiple first account correlation screening conditions in inquiry request, then by judging unit, judged according to the script file of local
Whether the first account correlation screening conditions meet its corresponding constraints, so that by split cells, according to each first account
First account screening conditions are carried out level fractionation by the level belonging to related screening conditions, and by two arithmetic elements, will be every
All first account correlation screening conditions of individual level carry out and computing, obtain the related screening bar of the second account of each level
Part, by the progress of the second account correlation screening conditions and computing, the 3rd account correlation screening conditions are obtained, finally by cargo tracer
Cloud, loan account data query is carried out according to the 3rd account correlation screening conditions.It is multiple that the present invention solves operation in the prior art
It is miscellaneous and to database direct operational risk it is big the problems such as, realize convenient, safety, high quality filters out bank loan data,
And obtain basic data for banking business analysis and support is provided.
It should be understood by those skilled in the art that, embodiments of the invention can be provided as method, system or computer program
Product.Therefore, the present invention can use the reality in terms of complete hardware embodiment, complete software embodiment or combination software and hardware
Apply the form of example.Moreover, the present invention can use the computer for wherein including computer usable program code in one or more
The computer program production that usable storage medium is implemented on (including but is not limited to magnetic disk storage, CD-ROM, optical memory etc.)
The form of product.
The present invention is the flow with reference to method according to embodiments of the present invention, equipment (system) and computer program product
Figure and/or block diagram describe.It should be understood that can be by every first-class in computer program instructions implementation process figure and/or block diagram
Journey and/or the flow in square frame and flow chart and/or block diagram and/or the combination of square frame.These computer programs can be provided
The processors of all-purpose computer, special-purpose computer, Embedded Processor or other programmable data processing devices is instructed to produce
A raw machine so that produced by the instruction of computer or the computing device of other programmable data processing devices for real
The device for the function of being specified in present one flow of flow chart or one square frame of multiple flows and/or block diagram or multiple square frames.
These computer program instructions, which may be alternatively stored in, can guide computer or other programmable data processing devices with spy
Determine in the computer-readable memory that mode works so that the instruction being stored in the computer-readable memory, which produces, to be included referring to
Make the manufacture of device, the command device realize in one flow of flow chart or multiple flows and/or one square frame of block diagram or
The function of being specified in multiple square frames.
These computer program instructions can be also loaded into computer or other programmable data processing devices so that counted
Series of operation steps is performed on calculation machine or other programmable devices to produce computer implemented processing, so as in computer or
The instruction performed on other programmable devices is provided for realizing in one flow of flow chart or multiple flows and/or block diagram one
The step of function of being specified in individual square frame or multiple square frames.
Apply specific embodiment in the present invention to be set forth the principle and embodiment of the present invention, above example
Explanation be only intended to help understand the present invention method and its core concept;Meanwhile for those of ordinary skill in the art,
According to the thought of the present invention, there will be changes in specific embodiments and applications, in summary, in this specification
Appearance should not be construed as limiting the invention.
Claims (10)
1. a kind of screening technique of bank loan data query, it is characterised in that this method includes:
Receive loan data inquiry request;The loan data inquiry request includes multiple first account correlation screening conditions;
According to the script file of local, judge whether the first account correlation screening conditions meet its corresponding constraints;
If it is, the first account screening conditions are carried out level by the level according to belonging to each first account correlation screening conditions
Split;The level includes:Account level and the customer level associated with account level and gage level;
All first account correlation screening conditions of each level are carried out and computing, the second account for obtaining each level are related
Screening conditions;
By the second account correlation screening conditions progress and computing, the 3rd account correlation screening conditions are obtained;
Loan account data query is carried out according to the 3rd account correlation screening conditions.
2. the screening technique of bank loan data query according to claim 1, it is characterised in that described to receive loan number
According to inquiry request, including:The loan data inquiry request is received from loan account query interface.
3. the screening technique of bank loan data query according to claim 2, it is characterised in that also include:
According to the first account correlation screening conditions, the parameter area of the first account correlation screening conditions, the related screening of the first account
The level of condition, the mutual exclusion screening conditions of the first account correlation screening conditions write the script file;
Store and run the script file, generate the bank loan account inquiries interface.
4. the screening technique of bank loan data query according to claim 1, it is characterised in that described to judge described the
Whether one account screening conditions meet the constraints of the first account screening conditions, including:
Judge whether the parameter of the first account screening conditions in the parameter area of the first account screening conditions and institute
State the mutual exclusion screening conditions that the first account screening conditions are not present in the first account screening conditions.
A kind of 5. screening plant of bank loan data query, it is characterised in that including:
Receiving unit, for receiving loan data inquiry request;The loan data inquiry request includes multiple first account phases
Close screening conditions;
Judging unit, for the script file according to local, it is right to judge whether the first account correlation screening conditions meet its
The constraints answered;
Split cells, the first account screening conditions are entered for the level according to belonging to each first account correlation screening conditions
Row level is split;The level includes:Account level and the customer level associated with account level and gage level;
First arithmetic element, for the progress of all first account correlation screening conditions and computing of each level, acquisition is each
Second account correlation screening conditions of level;
Second arithmetic element, for the second account correlation screening conditions progress and computing, acquisition the 3rd account correlation to be sieved
Select condition;
Query unit, for carrying out loan account data query according to the 3rd account correlation screening conditions.
6. the screening plant of bank loan data query according to claim 5, it is characterised in that the receiving unit tool
Body is used for:The loan data inquiry request is received from loan account query interface.
7. the screening plant of bank loan data query according to claim 6, it is characterised in that also include:
Unit is write, for according to the first account correlation screening conditions, the parameter area of the first account correlation screening conditions, first
The level of account correlation screening conditions, the mutual exclusion screening conditions of the first account correlation screening conditions write the script file;
Execution unit, for storing and running the script file, generate the bank loan account inquiries interface.
8. the screening plant of bank loan data query according to claim 5, it is characterised in that the judging unit tool
Body is used for:
Judge whether the parameter of the first account screening conditions in the parameter area of the first account screening conditions and institute
State the mutual exclusion screening conditions that the first account screening conditions are not present in the first account screening conditions.
9. a kind of computer equipment, including memory, processor and the calculating that is stored in storage above and can run on a processor
Machine program, it is characterised in that realize following steps during the computing device described program:
Receive loan data inquiry request;The loan data inquiry request includes multiple first account correlation screening conditions;
According to the script file of local, judge whether the first account correlation screening conditions meet its corresponding constraints;
If it is, the first account screening conditions are carried out level by the level according to belonging to each first account correlation screening conditions
Split;The level includes:Account level and the customer level associated with account level and gage level;
All first account correlation screening conditions of each level are carried out and computing, the second account for obtaining each level are related
Screening conditions;
By the second account correlation screening conditions progress and computing, the 3rd account correlation screening conditions are obtained;
Loan account data query is carried out according to the 3rd account correlation screening conditions.
10. a kind of computer-readable recording medium, is stored thereon with computer program, it is characterised in that the program is by processor
Following steps are realized during execution:
Receive loan data inquiry request;The loan data inquiry request includes multiple first account correlation screening conditions;
According to the script file of local, judge whether the first account correlation screening conditions meet its corresponding constraints;
If it is, the first account screening conditions are carried out level by the level according to belonging to each first account correlation screening conditions
Split;The level includes:Account level and the customer level associated with account level and gage level;
All first account correlation screening conditions of each level are carried out and computing, the second account for obtaining each level are related
Screening conditions;
By the second account correlation screening conditions progress and computing, the 3rd account correlation screening conditions are obtained;
Loan account data query is carried out according to the 3rd account correlation screening conditions.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201711146368.9A CN107862067B (en) | 2017-11-17 | 2017-11-17 | Screening method and device for bank loan data query |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201711146368.9A CN107862067B (en) | 2017-11-17 | 2017-11-17 | Screening method and device for bank loan data query |
Publications (2)
Publication Number | Publication Date |
---|---|
CN107862067A true CN107862067A (en) | 2018-03-30 |
CN107862067B CN107862067B (en) | 2021-10-08 |
Family
ID=61703123
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201711146368.9A Active CN107862067B (en) | 2017-11-17 | 2017-11-17 | Screening method and device for bank loan data query |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN107862067B (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110457356A (en) * | 2018-05-02 | 2019-11-15 | 珠海金山办公软件有限公司 | A kind of data screening method, apparatus, electronic equipment and readable storage medium storing program for executing |
CN111105302A (en) * | 2018-10-29 | 2020-05-05 | 重庆小雨点小额贷款有限公司 | Data processing method, device, server and storage medium |
CN117251652A (en) * | 2023-09-18 | 2023-12-19 | 北京数方科技有限公司 | Binary data mask label construction query method and device |
Citations (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101221578A (en) * | 2008-02-01 | 2008-07-16 | 中国建设银行股份有限公司 | Data screening method and device, and securitization loan screening method and device |
KR20100006911A (en) * | 2008-07-10 | 2010-01-22 | 현대카드 주식회사 | Loan service system and method using credit card inquiry apparatus thereof |
US20100174571A1 (en) * | 2009-01-04 | 2010-07-08 | Sandra Lee Jerome | Open Dealership Management System developed in MySQL, PHP, HTML, and JavaScript |
US7908242B1 (en) * | 2005-04-11 | 2011-03-15 | Experian Information Solutions, Inc. | Systems and methods for optimizing database queries |
CN102800018A (en) * | 2012-07-09 | 2012-11-28 | 贵州摇钱树软件开发有限公司 | Credit management system and credit processing method thereof |
CN103678585A (en) * | 2013-12-11 | 2014-03-26 | 北京先进数通信息技术股份公司 | User data screening method and system |
CN104572663A (en) * | 2013-10-15 | 2015-04-29 | 镇江金软计算机科技有限责任公司 | Realizing method for intelligently searching classifiable data based on JSP |
CN105224555A (en) * | 2014-06-12 | 2016-01-06 | 北京搜狗科技发展有限公司 | A kind of methods, devices and systems of search |
CN106022908A (en) * | 2016-05-17 | 2016-10-12 | 中国建设银行股份有限公司 | Method and system for querying information of assets and liabilities |
CN106156275A (en) * | 2016-06-23 | 2016-11-23 | 上海觅星网络科技有限公司 | A kind of method and apparatus of singulated inquiry |
CN106846149A (en) * | 2016-12-27 | 2017-06-13 | 广州新博庭网络信息科技股份有限公司 | A kind for the treatment of method and apparatus of business object |
-
2017
- 2017-11-17 CN CN201711146368.9A patent/CN107862067B/en active Active
Patent Citations (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7908242B1 (en) * | 2005-04-11 | 2011-03-15 | Experian Information Solutions, Inc. | Systems and methods for optimizing database queries |
CN101221578A (en) * | 2008-02-01 | 2008-07-16 | 中国建设银行股份有限公司 | Data screening method and device, and securitization loan screening method and device |
KR20100006911A (en) * | 2008-07-10 | 2010-01-22 | 현대카드 주식회사 | Loan service system and method using credit card inquiry apparatus thereof |
US20100174571A1 (en) * | 2009-01-04 | 2010-07-08 | Sandra Lee Jerome | Open Dealership Management System developed in MySQL, PHP, HTML, and JavaScript |
CN102800018A (en) * | 2012-07-09 | 2012-11-28 | 贵州摇钱树软件开发有限公司 | Credit management system and credit processing method thereof |
CN104572663A (en) * | 2013-10-15 | 2015-04-29 | 镇江金软计算机科技有限责任公司 | Realizing method for intelligently searching classifiable data based on JSP |
CN103678585A (en) * | 2013-12-11 | 2014-03-26 | 北京先进数通信息技术股份公司 | User data screening method and system |
CN105224555A (en) * | 2014-06-12 | 2016-01-06 | 北京搜狗科技发展有限公司 | A kind of methods, devices and systems of search |
CN106022908A (en) * | 2016-05-17 | 2016-10-12 | 中国建设银行股份有限公司 | Method and system for querying information of assets and liabilities |
CN106156275A (en) * | 2016-06-23 | 2016-11-23 | 上海觅星网络科技有限公司 | A kind of method and apparatus of singulated inquiry |
CN106846149A (en) * | 2016-12-27 | 2017-06-13 | 广州新博庭网络信息科技股份有限公司 | A kind for the treatment of method and apparatus of business object |
Non-Patent Citations (2)
Title |
---|
DOMBROVSKAYA H 等: "Talking to the Database in a Semantically Rich Way", 《PROCEEDINGS OF THE 17TH INTERNATIONAL CONFERENCE ON EXTENDING DATABASE TECHNOLOGY》 * |
江能 等: "联保贷款客户自动筛选机制研究", 《金融理论与实践》 * |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110457356A (en) * | 2018-05-02 | 2019-11-15 | 珠海金山办公软件有限公司 | A kind of data screening method, apparatus, electronic equipment and readable storage medium storing program for executing |
CN111105302A (en) * | 2018-10-29 | 2020-05-05 | 重庆小雨点小额贷款有限公司 | Data processing method, device, server and storage medium |
CN117251652A (en) * | 2023-09-18 | 2023-12-19 | 北京数方科技有限公司 | Binary data mask label construction query method and device |
CN117251652B (en) * | 2023-09-18 | 2024-04-30 | 北京数方科技有限公司 | Binary data mask label construction query method and device |
Also Published As
Publication number | Publication date |
---|---|
CN107862067B (en) | 2021-10-08 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110310191A (en) | For data analysis, risk management and the distributed computing machine frame advised from dynamic circuit connector | |
Levitas et al. | A look at the value creation effects of patenting and capital investment through a real options lens: the moderating role of uncertainty | |
Kadoić | Characteristics of the analytic network process, a multi-criteria decision-making method | |
CN108596495A (en) | A kind of retail credit business points-scoring system and method | |
CN109377353A (en) | A kind of method, apparatus, storage medium and the processor of screening fund side | |
Elsayed et al. | Evaluating alternatives through the application of TOPSIS method with entropy weight | |
CN107862067A (en) | A kind of screening technique and device of bank loan data query | |
Drummond et al. | Toward a monetary union in the East African Community: asymmetric shocks, exchange rates, and risk-sharing mechanisms | |
CN106815725A (en) | A kind of transaction verification method and device | |
CN110363661A (en) | Bank liquidity prediction technique and device | |
CN110415125A (en) | A kind of method, apparatus, equipment and computer storage medium carrying out credit rating to issuing subject online | |
CN107437221A (en) | The determination method and device of floating interest rate | |
CN110363662A (en) | A kind of personal credit points-scoring system | |
Afşar et al. | Does Higher Geopolitical Risk Limits Turkish Foreign Direct Investments? | |
CN112232377A (en) | Method and device for constructing ESG (electronic service guide) three-excellence credit model of enterprise | |
CN110147388A (en) | A kind of method and device of data processing | |
Arora et al. | The nexus between financial development and trade performance: empirical evidence from India in the presence of endogenous structural breaks | |
CN113822749A (en) | Merchant settlement and payment processing method, device, equipment and medium based on RPA and AI | |
Karma et al. | Designing Application for Determining the Health Level of Village Credit Institutions with the CAMEL Method | |
EP2902950A1 (en) | Method, system and computer program product of determining a payment strategy | |
Khan | 21st Century Accelerated Dedollarization, Multipolarity and The Global South Beyond Modern Money Theory: Governance of a Complex Global Financial System in the Age of Global Instabilities | |
Hardiyanto et al. | Systemic approach to solve problem of managing zakat in contemporary muslim society in Indonesia | |
Ntirabampa et al. | The effect of interest rate differentials on exchange rate volatility of East African community currencies | |
Bing | A study of state educational loan demand diversity and its influencing paths–An empirical analysis based on SEM model | |
Karanja | Effect of financial inclusion on financial development in Kenya |
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 |