CN105354743A - Data processing method and device - Google Patents
Data processing method and device Download PDFInfo
- Publication number
- CN105354743A CN105354743A CN201510889299.5A CN201510889299A CN105354743A CN 105354743 A CN105354743 A CN 105354743A CN 201510889299 A CN201510889299 A CN 201510889299A CN 105354743 A CN105354743 A CN 105354743A
- Authority
- CN
- China
- Prior art keywords
- product
- information
- camel
- subscription
- client
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
-
- 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
-
- 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/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- 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/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Probability & Statistics with Applications (AREA)
- Technology Law (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Economics (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Development Economics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a data processing method and device. The method comprises the following steps of receiving a product subscription information search request comprising a product subscription information search condition; searching a data table corresponding to the product subscription information search condition from a preset database, wherein the data table comprises a client detail information table/network statistical information table; and searching product subscription information corresponding to the product subscription information search condition from the searched data table and determining the product subscription information as a search result of the product subscription information search request. By adopting the method, the product subscription information can be searched, and an administrator can make an effective operating management decision according to the search result conveniently.
Description
Technical field
The application relates to technical field of data processing, particularly relates to a kind of data processing method and device.
Background technology
Cash management business plays vital effect in banking industry evolution.Concrete, with regard to the means of services and product, cash management business comprises cash management payment, gathering, budget management, bill pool, the management of inner account, timing cash pooling, multiple product such as intelligence financing cash pooling, information reporting etc.
Along with growth in the living standard, people more and more rely on trust to the cash management business that bank provides, and the quantity of the product in signing cash management business also gets more and more.Especially in recent years, in cash management business the signing total quantity of each product reached tens billion of more than.But; exactly because the increasing of signing quantity of product in also cash management business; so usually the CAMEL-Subscription-Information of product in cash management business can effectively can not be grasped because of supvr, and cause supvr can not carry out the problem of efficient management management decision according to signing product information.
Therefore, providing a kind of data processing method and device, realize the inquiry to product CAMEL-Subscription-Information, so that supvr carries out efficient management management decision according to Query Result, is problem demanding prompt solution.
Summary of the invention
In view of this, the embodiment of the present application provides a kind of data processing method and device, to realize the inquiry to product CAMEL-Subscription-Information, and then is convenient to supvr and carries out efficient management management decision according to Query Result.
To achieve these goals, the technical scheme that provides of the embodiment of the present application is as follows:
A kind of data processing method, comprising:
Receive product CAMEL-Subscription-Information inquiry request, described product CAMEL-Subscription-Information inquiry request comprises product CAMEL-Subscription-Information querying condition;
In the database pre-set, search the tables of data corresponding with described product CAMEL-Subscription-Information querying condition, described tables of data comprises client's managing detailed catalogue table/site Statistics table, wherein, the product that described client's managing detailed catalogue table comprises each client of the cash management business of signing bank is contracted managing detailed catalogue; The product of each site that described site Statistics table comprises under described bank is contracted statistical information;
From the described tables of data found, inquire about the product CAMEL-Subscription-Information corresponding with described product CAMEL-Subscription-Information querying condition, and described product CAMEL-Subscription-Information is defined as the Query Result of described product CAMEL-Subscription-Information inquiry request.
Preferably, the generative process of described client's managing detailed catalogue table comprises:
When detecting that present system time meets condition at end day, obtain the product basis CAMEL-Subscription-Information of each client for its signing each product of the cash management business of the described bank that contracted day on the whole same day respectively;
For each described product basis CAMEL-Subscription-Information, obtain the indication information corresponding with the product that described product basis CAMEL-Subscription-Information indicates pre-set, and search the product CAMEL-Subscription-Information meeting described indication information from the CAMEL-Subscription-Information of described product basis;
The each described product CAMEL-Subscription-Information will got respectively, is stored into the relevant position in the client's managing detailed catalogue table template pre-set, to generate described client's managing detailed catalogue table.
Preferably, when detecting that present system time meets condition at end day, client's detail letter of generation
When breath table is called client's managing detailed catalogue table at end day,
Described client's managing detailed catalogue table also comprises client's managing detailed catalogue table and/or year-end client's managing detailed catalogue table at the end of the month.
Preferably, the generative process of described site Statistics table comprises:
After detecting that described day, whole client's managing detailed catalogue table generated, utilize the product CAMEL-Subscription-Information in whole client's managing detailed catalogue table of described day, the product adding up each site under described bank is respectively contracted statistical information;
Respectively each described product counted on to be contracted statistical information, be stored into the relevant position in the site Statistics table template pre-set, to generate described site Statistics table.
Preferably, after the whole client's managing detailed catalogue table generation of described day being detected, when the site Statistics table of generation is called site Statistics table at end day,
Described site Statistics table also comprises site Statistics table and/or year-end site Statistics table at the end of the month.
Preferably, also comprise:
The Query Result receiving user's input shows request, and described Query Result shows that request comprises displaying pattern information;
Show the Query Result corresponding with described product CAMEL-Subscription-Information inquiry request according to described displaying pattern information, wherein, described displaying pattern information comprises the form to be presented of Query Result.
A kind of data processing equipment, comprising:
Inquiry request receiving element, for receiving product CAMEL-Subscription-Information inquiry request, described product CAMEL-Subscription-Information inquiry request comprises product CAMEL-Subscription-Information querying condition;
Tables of data searches unit, for in the database pre-set, search the tables of data corresponding with described product CAMEL-Subscription-Information querying condition, described tables of data comprises client's managing detailed catalogue table/site Statistics table, wherein, the product that described client's managing detailed catalogue table comprises each client of the cash management business of signing bank is contracted managing detailed catalogue; The product of each site that described site Statistics table comprises under described bank is contracted statistical information;
Result queries unit, for from the described tables of data found, inquires about the product CAMEL-Subscription-Information corresponding with described product CAMEL-Subscription-Information querying condition, and described product CAMEL-Subscription-Information is defined as the Query Result of described product CAMEL-Subscription-Information inquiry request.
Preferably, also comprise client's managing detailed catalogue table generation unit, wherein, described client's managing detailed catalogue table generation unit comprises:
The signing information acquisition unit in product basis, for when detecting that present system time meets condition at end day, obtains the product basis CAMEL-Subscription-Information of each client for its signing each product of the cash management business of the described bank that contracted day on the whole same day respectively;
Product CAMEL-Subscription-Information searches unit, for for each described product basis CAMEL-Subscription-Information, obtain the indication information corresponding with the product that described product basis CAMEL-Subscription-Information indicates pre-set, and search the product CAMEL-Subscription-Information meeting described indication information from the CAMEL-Subscription-Information of described product basis;
Client's managing detailed catalogue table generates subelement, for each described product CAMEL-Subscription-Information will got respectively, is stored into the relevant position in the client's managing detailed catalogue table template pre-set, to generate described client's managing detailed catalogue table.
Preferably, when detecting that present system time meets condition at end day, when client's managing detailed catalogue table of generation is called client's managing detailed catalogue table at end day,
This device also comprises site Statistics table generation unit, and wherein, described site Statistics table generation unit comprises:
Product is contracted statistical information statistic unit, for after detecting that described day, whole client's managing detailed catalogue table generated, utilizes the product CAMEL-Subscription-Information in whole client's managing detailed catalogue table of described day, and the product adding up each site under described bank is respectively contracted statistical information;
Site Statistics table generates subelement, for statistical information of being contracted by each described product counted on respectively, is stored into the relevant position in the site Statistics table template pre-set, to generate described site Statistics table.
Preferably, also comprise Query Result display unit, wherein, described Query Result display unit comprises:
Show request reception unit, show request for the Query Result receiving user's input, described Query Result shows that request comprises displaying pattern information;
Query Result shows subelement, and for showing the Query Result corresponding with described product CAMEL-Subscription-Information inquiry request according to described displaying pattern information, wherein, described displaying pattern information comprises the form to be presented of Query Result.
The application provides a kind of data processing method and device, by receiving the product CAMEL-Subscription-Information inquiry request comprising product CAMEL-Subscription-Information querying condition, and in the database pre-set, search the tables of data corresponding with product CAMEL-Subscription-Information querying condition (wherein, tables of data comprises client's managing detailed catalogue table/site Statistics table), and then from the tables of data found, inquire about the product CAMEL-Subscription-Information corresponding with product CAMEL-Subscription-Information querying condition, and mode product CAMEL-Subscription-Information being defined as the Query Result of product CAMEL-Subscription-Information inquiry request achieves the inquiry to product CAMEL-Subscription-Information, and then supvr can be convenient to carry out efficient management management decision according to Query Result.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present application or technical scheme of the prior art, be briefly described to the accompanying drawing used required in embodiment or description of the prior art below, apparently, the accompanying drawing that the following describes is only some embodiments recorded in the application, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to these accompanying drawings.
A kind of data processing method process flow diagram that Fig. 1 provides for the embodiment of the present application one;
The generation method flow diagram of a kind of client's detail list that Fig. 2 provides for the embodiment of the present application one;
The generation method flow diagram of a kind of site Statistics table that Fig. 3 provides for the embodiment of the present application one;
The structural representation of a kind of data processing equipment that Fig. 4 provides for the embodiment of the present application two;
The detailed construction schematic diagram of a kind of client's managing detailed catalogue table generation unit that Fig. 5 provides for the embodiment of the present application two;
The detailed construction schematic diagram of a kind of site Statistics table generation unit that Fig. 6 provides for the embodiment of the present application two;
The detailed construction schematic diagram of a kind of query structure display unit that Fig. 7 provides for the embodiment of the present application two.
Embodiment
Technical scheme in the application is understood better in order to make those skilled in the art person, below in conjunction with the accompanying drawing in the embodiment of the present application, technical scheme in the embodiment of the present application is clearly and completely described, obviously, described embodiment is only some embodiments of the present application, instead of whole embodiments.Based on the embodiment in the application, those of ordinary skill in the art are not making the every other embodiment obtained under creative work prerequisite, all should belong to the scope of the application's protection.
Embodiment one:
A kind of data processing method process flow diagram that Fig. 1 provides for the embodiment of the present application one.
As shown in Figure 1, the method comprises:
S101, reception product CAMEL-Subscription-Information inquiry request, product CAMEL-Subscription-Information inquiry request comprises product CAMEL-Subscription-Information querying condition;
In the embodiment of the present application, preferably, supvr is in order to carry out efficient management management decision according to signing product information, the product information often needing client and bank to contract is inquired about, as: when inquiry obtains the client of site A, use the trading frequency of bill pool product more than other sites, bill pool product can be promoted the use of at site A emphasis like this; Supvr A can inquire about the trading frequency of each product of site A, and emphasis promotes the high product of trading frequency in the A of site; Supvr B can inquire about the account balance of the user of each product of site B, and then the product etc. that emphasis promoted account remaining sum is high in the B of site.
Below be only the optimal way of the embodiment of the present application, inventor can according to the demand of oneself arrange arbitrarily supvr inquiry bank cash management business in product CAMEL-Subscription-Information and the operation control decision-making carried out between corresponding relation, do not limit at this.
In the embodiment of the present application, preferably, the product CAMEL-Subscription-Information inquiry request received comprises product CAMEL-Subscription-Information querying condition.
In the embodiment of the present application, preferably, product CAMEL-Subscription-Information querying condition comprises the type of product CAMEL-Subscription-Information to be checked.
In the embodiment of the present application, preferably, the type of product CAMEL-Subscription-Information to be checked indicates product CAMEL-Subscription-Information to be checked to be to contract detailed inquiry to client, or, the inquiry of statistical information that the product of site is contracted.
Below be only the optimal way of the embodiment of the present application, inventor can arrange arbitrarily according to the demand of oneself content that product CAMEL-Subscription-Information querying condition comprises, and does not limit at this.
S102, in the database pre-set, search the tables of data corresponding with product CAMEL-Subscription-Information querying condition, tables of data comprises client's managing detailed catalogue table/site Statistics table, wherein, the product that client's managing detailed catalogue table comprises each client of the cash management business of signing bank is contracted managing detailed catalogue; The product of each site that site Statistics table comprises under bank is contracted statistical information;
In the embodiment of the present application, preferably, be previously provided with database, in database, be provided with tables of data.
In the embodiment of the present application, preferably, tables of data comprises client's managing detailed catalogue table/site Statistics table.Wherein, the product that client's managing detailed catalogue table comprises each client of the cash management business of signing bank is contracted managing detailed catalogue; The product of each site that site Statistics table comprises under bank is contracted statistical information.
In the embodiment of the present application, preferably, the product being comprised each client of the cash management business of signing bank from client's managing detailed catalogue table is contracted managing detailed catalogue, specifically comprise in client's managing detailed catalogue table: for each client with the cash management service contracting of bank, the product of the cash management service contracting of each and bank of this client is contracted managing detailed catalogue.
In the embodiment of the present application, preferably, the product of each site comprised under bank from site Statistics table is contracted statistical information, specifically comprises: for each site under bank in the Statistics table of site, and the product of each product of each site is contracted statistical information.
In the embodiment of the present application, preferably, when product CAMEL-Subscription-Information querying condition comprises the type of product CAMEL-Subscription-Information to be checked, comprise the type of product CAMEL-Subscription-Information to be checked according to product CAMEL-Subscription-Information querying condition, the tables of data corresponding with product CAMEL-Subscription-Information querying condition can be determined.
Concrete, when the type of the product CAMEL-Subscription-Information to be checked that product CAMEL-Subscription-Information querying condition comprises be to the product of site contract the inquiry of statistical information time, the site Statistics table in database is defined as the tables of data corresponding with product CAMEL-Subscription-Information querying condition; When the product that the type of the product CAMEL-Subscription-Information to be checked that product CAMEL-Subscription-Information querying condition comprises is the client of cash management business to signing bank contract managing detailed catalogue inquire about time, the client's managing detailed catalogue table in database is defined as the tables of data corresponding with product CAMEL-Subscription-Information querying condition.
S103, from the tables of data found, inquire about the product CAMEL-Subscription-Information corresponding with product CAMEL-Subscription-Information querying condition, and product CAMEL-Subscription-Information is defined as the Query Result of product CAMEL-Subscription-Information inquiry request.
In the embodiment of the present application, preferably, after inquiring the tables of data corresponding with product CAMEL-Subscription-Information querying condition, need from the tables of data found, inquire about the product CAMEL-Subscription-Information corresponding with product CAMEL-Subscription-Information querying condition, and the product CAMEL-Subscription-Information corresponding with product CAMEL-Subscription-Information querying condition inquired is defined as the Query Result of product CAMEL-Subscription-Information inquiry request.
In order to setting forth a kind of data processing method that the embodiment of the present application one provides clearly, a kind of generation method flow diagram of client's detail list is provided at this, refer to Fig. 2, so that the generative process of the setting tables of data in a database in the technical scheme provided the embodiment of the present application one is described in detail.
As shown in Figure 2, the method comprises:
S201, when detecting that present system time meets day whole condition, obtain the product basis CAMEL-Subscription-Information of each client for its signing each product of the cash management business of the bank that contracted day on the whole same day respectively;
In the embodiment of the present application, preferably, after day, whole condition was the 22:00 of every day.That is, when detect present system time be 22:00 after time, namely start to perform the generative process that the embodiment of the present application provides a kind of client's managing detailed catalogue table.
Below be only the optimal way that the embodiment of the present application provides, concrete, inventor can arrange arbitrarily day whole condition according to the demand of oneself, as long as after ensureing to start to perform client's managing detailed catalogue table generative process, Zhong bank on the same day no longer works, and completes the generative process of client's managing detailed catalogue table of the previous day before starting working in bank one day after.
In the embodiment of the present application, preferably, when being checked through present system time and meeting condition at end day, day on the whole same day is obtained respectively, for each client of the cash management business of signing bank, the product basis CAMEL-Subscription-Information that this client is signing with each product of the cash management business of bank respectively.
In the embodiment of the present application, preferably, be previously provided with indication information corresponding with each product respectively, concrete, each product self comprises several attributes, at least one attribute in several attributes that indication information instruction product self comprises.Such as, for bill pool product, it comprises fund variation attribute (payment, gathering etc.) and non-fund variation attribute, and indication information just refers to the fund variation attribute in bill pool product here.
In the embodiment of the present application, preferably, need for each product basis CAMEL-Subscription-Information got, obtain the indication information corresponding with the product that this product basis CAMEL-Subscription-Information indicates pre-set, and then according to the indication information got, the product CAMEL-Subscription-Information (namely or, extract, each attribute information meeting the attribute of indication information instruction in the CAMEL-Subscription-Information of product basis as product CAMEL-Subscription-Information) meeting indication information is searched from the CAMEL-Subscription-Information of this product basis.
S202, for each product basis CAMEL-Subscription-Information, obtain the indication information corresponding with the product that product basis CAMEL-Subscription-Information indicate pre-set, and search the product CAMEL-Subscription-Information meeting indication information from the basic CAMEL-Subscription-Information of product;
S203, each product CAMEL-Subscription-Information will got respectively, be stored into the relevant position in the client's managing detailed catalogue table template pre-set, to generate client's managing detailed catalogue table.
In the embodiment of the present application, preferably, be previously provided with client's managing detailed catalogue table template, at least comprise in this client's managing detailed catalogue template: the field identical with the number of the attribute that indication information indicates, wherein, the field that each attribute of indication information instruction is all unique with in client's managing detailed catalogue template is corresponding with it.
Concrete, after getting product CAMEL-Subscription-Information, need for each information in product CAMEL-Subscription-Information, this information is stored into relevant position in client's managing detailed catalogue table template (relevant position here refers to: the information filling position of the field that the attribute of indication information corresponding with this information in client's managing detailed catalogue table template is corresponding), to generate client's managing detailed catalogue table.
Further, in the embodiment of the present application, preferably, when detecting that present system time meets condition at end day, when the client's managing detailed catalogue table generated is called day whole client's managing detailed catalogue table, client's managing detailed catalogue table also comprises client's managing detailed catalogue table and/or year-end client's managing detailed catalogue table at the end of the month.
In the embodiment of the present application, preferably, in order to when carrying out data processing, improve efficiency data query further, when day whole client's managing detailed catalogue table is set in tables of data, client's managing detailed catalogue table and/or year-end client's managing detailed catalogue table at the end of the month is set further.
In the embodiment of the present application, preferably, the end of the month, client's managing detailed catalogue table was: the end of the month, and combining according to of that month each day whole client's managing detailed catalogue table generates; Year-end end of the month, client's managing detailed catalogue table was: whenever year terminal hour, is combined in one generates according to each end of the month then client's managing detailed catalogue table.
In the embodiment of the present application, preferably, product CAMEL-Subscription-Information querying condition also can comprise the product date of contract.When tables of data comprise day whole client's managing detailed catalogue table, the end of the month client's managing detailed catalogue table, and year-end client's managing detailed catalogue table, and, after determining to utilize client's managing detailed catalogue table to carry out data query by the type of product CAMEL-Subscription-Information to be checked; Also by Selection utilization day product date of contract whole client's managing detailed catalogue table, the end of the month client's managing detailed catalogue table, or year-end client's managing detailed catalogue table completes query script.
In order to setting forth a kind of data processing method that the embodiment of the present application one provides clearly, the generation method flow diagram of a kind of site Statistics table is provided at this, refer to Fig. 3, so that the generative process of the setting tables of data in a database in the technical scheme provided the embodiment of the present application one is described in detail.
As shown in Figure 3, the method comprises:
S301, after detecting that day, whole client's managing detailed catalogue table generated, utilize the product CAMEL-Subscription-Information in day whole client's managing detailed catalogue table, the product adding up each site under bank is respectively contracted statistical information;
In the embodiment of the present application, preferably, wherein, the product of site statistical information of contracting comprises the signing frequency etc. of the signing remaining sum of each product of site and/or each product of site.
Below be only the optimal way of the embodiment of the present application, inventor can arrange arbitrarily according to the demand of oneself the product CAMEL-Subscription-Information utilized in day whole client's managing detailed catalogue table, the product of each site under the bank added up is contracted the particular content of statistical information, does not limit at this.
S302, each product counted on to be contracted statistical information respectively, be stored into the relevant position in the site Statistics table template pre-set, to generate site Statistics table.
In the embodiment of the present application, the execution thought of step S302 is identical with the execution thought of above-mentioned steps S203, and the execution thought of connection with step S302 refers to the description of the above-mentioned execution thought to step S203, is not described in detail at this.
The Query Result inquired in order to a kind of data processing method the embodiment of the present application provided is supplied to user's viewing, so that user carries out efficient management management decision according to its Query Result seen, further, on the basis of a kind of data processing method provided at above-described embodiment, a kind of Query Result methods of exhibiting is also set.
In the embodiment of the present application, preferably, Query Result methods of exhibiting comprises: the Query Result receiving user's input shows request, and Query Result shows that request comprises displaying pattern information; And, according to showing that pattern information shows the Query Result corresponding with product CAMEL-Subscription-Information inquiry request.
In the embodiment of the present application, preferably, show that pattern information comprises the form to be presented of Query Result.
In the embodiment of the present application, preferably, the form to be presented of Query Result comprises XML format, TXT form etc.
Below be only the optimal way of the embodiment of the present application, inventor can arrange arbitrarily the concrete mode of the form to be presented of Query Result according to the demand of oneself, do not limit at this.
The application provides a kind of data processing method, by receiving the product CAMEL-Subscription-Information inquiry request comprising product CAMEL-Subscription-Information querying condition, and in the database pre-set, search the tables of data corresponding with product CAMEL-Subscription-Information querying condition (wherein, tables of data comprises client's managing detailed catalogue table/site Statistics table), and then from the tables of data found, inquire about the product CAMEL-Subscription-Information corresponding with product CAMEL-Subscription-Information querying condition, and mode product CAMEL-Subscription-Information being defined as the Query Result of product CAMEL-Subscription-Information inquiry request achieves the inquiry to product CAMEL-Subscription-Information, and then supvr can be convenient to carry out efficient management management decision according to Query Result.
Embodiment two:
The structural representation of a kind of data processing equipment that Fig. 4 provides for the embodiment of the present application two.
As shown in Figure 4, this device comprises:
Inquiry request receiving element 41, for receiving product CAMEL-Subscription-Information inquiry request, product CAMEL-Subscription-Information inquiry request comprises product CAMEL-Subscription-Information querying condition;
Tables of data searches unit 42, for in the database pre-set, search the tables of data corresponding with product CAMEL-Subscription-Information querying condition, tables of data comprises client's managing detailed catalogue table/site Statistics table, wherein, the product that client's managing detailed catalogue table comprises each client of the cash management business of signing bank is contracted managing detailed catalogue; The product of each site that site Statistics table comprises under bank is contracted statistical information;
Result queries unit 43, for from the tables of data found, inquires about the product CAMEL-Subscription-Information corresponding with product CAMEL-Subscription-Information querying condition, and product CAMEL-Subscription-Information is defined as the Query Result of product CAMEL-Subscription-Information inquiry request.
Further, in a kind of data processing equipment that the embodiment of the present application provides, also comprise client's managing detailed catalogue table generation unit, the detailed construction schematic diagram of a kind of client's managing detailed catalogue table generation unit that Fig. 5 provides for the embodiment of the present application two.
As shown in Figure 5, client's managing detailed catalogue table generation unit comprises:
The signing information acquisition unit 51 in product basis, for when detecting that present system time meets condition at end day, obtains the product basis CAMEL-Subscription-Information of each client for its signing each product of the cash management business of the bank that contracted day on the whole same day respectively;
Product CAMEL-Subscription-Information searches unit 52, for for each product basis CAMEL-Subscription-Information, obtain the indication information corresponding with the product that product basis CAMEL-Subscription-Information indicates pre-set, and search the product CAMEL-Subscription-Information meeting indication information from the CAMEL-Subscription-Information of product basis;
Client's managing detailed catalogue table generates subelement 53, for each product CAMEL-Subscription-Information will got respectively, is stored into the relevant position in the client's managing detailed catalogue table template pre-set, to generate client's managing detailed catalogue table.
Further, in a kind of data processing equipment that the embodiment of the present application provides, when detecting that present system time meets condition at end day, when client's managing detailed catalogue table of generation is called client's managing detailed catalogue table at end day, this device will also comprise site Statistics table generation unit.
The detailed construction schematic diagram of a kind of site Statistics table generation unit that Fig. 6 provides for the embodiment of the present application two.
As shown in Figure 6, this site Statistics table generation unit comprises:
Product is contracted statistical information statistic unit 61, for after detecting that day, whole client's managing detailed catalogue table generated, utilizes the product CAMEL-Subscription-Information in day whole client's managing detailed catalogue table, and the product adding up each site under bank is respectively contracted statistical information;
Site Statistics table generates subelement 62, for statistical information of being contracted by each product counted on respectively, is stored into the relevant position in the site Statistics table template pre-set, to generate site Statistics table.
Further, in a kind of data processing equipment that the embodiment of the present application two provides, also comprise: query structure display unit.The detailed construction schematic diagram of a kind of query structure display unit that Fig. 7 provides for the embodiment of the present application two.
As shown in Figure 7, this query structure display unit comprises:
Show request reception unit 71, show request for the Query Result receiving user's input, Query Result shows that request comprises displaying pattern information;
Query Result shows subelement 72, for according to showing that pattern information shows the Query Result corresponding with product CAMEL-Subscription-Information inquiry request, wherein, shows that pattern information comprises the form to be presented of Query Result.
The application provides a kind of data processing equipment, this device comprises the product CAMEL-Subscription-Information inquiry request of product CAMEL-Subscription-Information querying condition by receiving, and in the database pre-set, search the tables of data corresponding with product CAMEL-Subscription-Information querying condition (wherein, tables of data comprises client's managing detailed catalogue table/site Statistics table), and then from the tables of data found, inquire about the product CAMEL-Subscription-Information corresponding with product CAMEL-Subscription-Information querying condition, and mode product CAMEL-Subscription-Information being defined as the Query Result of product CAMEL-Subscription-Information inquiry request achieves the inquiry to product CAMEL-Subscription-Information, and then supvr can be convenient to carry out efficient management management decision according to Query Result.
In this instructions, each embodiment adopts the mode of going forward one by one to describe, and what each embodiment stressed is the difference with other embodiments, between each embodiment identical similar portion mutually see.For device disclosed in embodiment, because it corresponds to the method disclosed in Example, so description is fairly simple, relevant part illustrates see method part.
Below be only the preferred implementation of the application, those skilled in the art understood or realizes the application.To be apparent to one skilled in the art to the multiple amendment of these embodiments, General Principle as defined herein when not departing from the spirit or scope of the application, can realize in other embodiments.Therefore, the application can not be restricted to these embodiments shown in this article, but will meet the widest scope consistent with principle disclosed herein and features of novelty.
Claims (10)
1. a data processing method, is characterized in that, comprising:
Receive product CAMEL-Subscription-Information inquiry request, described product CAMEL-Subscription-Information inquiry request comprises product CAMEL-Subscription-Information querying condition;
In the database pre-set, search the tables of data corresponding with described product CAMEL-Subscription-Information querying condition, described tables of data comprises client's managing detailed catalogue table/site Statistics table, wherein, the product that described client's managing detailed catalogue table comprises each client of the cash management business of signing bank is contracted managing detailed catalogue; The product of each site that described site Statistics table comprises under described bank is contracted statistical information;
From the described tables of data found, inquire about the product CAMEL-Subscription-Information corresponding with described product CAMEL-Subscription-Information querying condition, and described product CAMEL-Subscription-Information is defined as the Query Result of described product CAMEL-Subscription-Information inquiry request.
2. method according to claim 1, is characterized in that, the generative process of described client's managing detailed catalogue table comprises:
When detecting that present system time meets condition at end day, obtain the product basis CAMEL-Subscription-Information of each client for its signing each product of the cash management business of the described bank that contracted day on the whole same day respectively;
For each described product basis CAMEL-Subscription-Information, obtain the indication information corresponding with the product that described product basis CAMEL-Subscription-Information indicates pre-set, and search the product CAMEL-Subscription-Information meeting described indication information from the CAMEL-Subscription-Information of described product basis;
The each described product CAMEL-Subscription-Information will got respectively, is stored into the relevant position in the client's managing detailed catalogue table template pre-set, to generate described client's managing detailed catalogue table.
3. method according to claim 2, is characterized in that, when detecting that present system time meets condition at end day, when client's managing detailed catalogue table of generation is called client's managing detailed catalogue table at end day,
Described client's managing detailed catalogue table also comprises client's managing detailed catalogue table and/or year-end client's managing detailed catalogue table at the end of the month.
4. method according to claim 3, is characterized in that, the generative process of described site Statistics table comprises:
After detecting that described day, whole client's managing detailed catalogue table generated, utilize the product CAMEL-Subscription-Information in whole client's managing detailed catalogue table of described day, the product adding up each site under described bank is respectively contracted statistical information;
Respectively each described product counted on to be contracted statistical information, be stored into the relevant position in the site Statistics table template pre-set, to generate described site Statistics table.
5. method according to claim 4, is characterized in that, after the whole client's managing detailed catalogue table generation of described day being detected, when the site Statistics table of generation is called site Statistics table at end day,
Described site Statistics table also comprises site Statistics table and/or year-end site Statistics table at the end of the month.
6. the method according to claim 1-5 any one, is characterized in that, also comprises:
The Query Result receiving user's input shows request, and described Query Result shows that request comprises displaying pattern information;
Show the Query Result corresponding with described product CAMEL-Subscription-Information inquiry request according to described displaying pattern information, wherein, described displaying pattern information comprises the form to be presented of Query Result.
7. a data processing equipment, is characterized in that, comprising:
Inquiry request receiving element, for receiving product CAMEL-Subscription-Information inquiry request, described product CAMEL-Subscription-Information inquiry request comprises product CAMEL-Subscription-Information querying condition;
Tables of data searches unit, for in the database pre-set, search the tables of data corresponding with described product CAMEL-Subscription-Information querying condition, described tables of data comprises client's managing detailed catalogue table/site Statistics table, wherein, the product that described client's managing detailed catalogue table comprises each client of the cash management business of signing bank is contracted managing detailed catalogue; The product of each site that described site Statistics table comprises under described bank is contracted statistical information;
Result queries unit, for from the described tables of data found, inquires about the product CAMEL-Subscription-Information corresponding with described product CAMEL-Subscription-Information querying condition, and described product CAMEL-Subscription-Information is defined as the Query Result of described product CAMEL-Subscription-Information inquiry request.
8. device according to claim 7, is characterized in that, also comprises client's managing detailed catalogue table generation unit, and wherein, described client's managing detailed catalogue table generation unit comprises:
The signing information acquisition unit in product basis, for when detecting that present system time meets condition at end day, obtains the product basis CAMEL-Subscription-Information of each client for its signing each product of the cash management business of the described bank that contracted day on the whole same day respectively;
Product CAMEL-Subscription-Information searches unit, for for each described product basis CAMEL-Subscription-Information, obtain the indication information corresponding with the product that described product basis CAMEL-Subscription-Information indicates pre-set, and search the product CAMEL-Subscription-Information meeting described indication information from the CAMEL-Subscription-Information of described product basis;
Client's managing detailed catalogue table generates subelement, for each described product CAMEL-Subscription-Information will got respectively, is stored into the relevant position in the client's managing detailed catalogue table template pre-set, to generate described client's managing detailed catalogue table.
9. device according to claim 8, is characterized in that, when detecting that present system time meets condition at end day, when client's managing detailed catalogue table of generation is called client's managing detailed catalogue table at end day,
This device also comprises site Statistics table generation unit, and wherein, described site Statistics table generation unit comprises:
Product is contracted statistical information statistic unit, for after detecting that described day, whole client's managing detailed catalogue table generated, utilizes the product CAMEL-Subscription-Information in whole client's managing detailed catalogue table of described day, and the product adding up each site under described bank is respectively contracted statistical information;
Site Statistics table generates subelement, for statistical information of being contracted by each described product counted on respectively, is stored into the relevant position in the site Statistics table template pre-set, to generate described site Statistics table.
10. the device according to claim 7-9 any one, is characterized in that, also comprises Query Result display unit, and wherein, described Query Result display unit comprises:
Show request reception unit, show request for the Query Result receiving user's input, described Query Result shows that request comprises displaying pattern information;
Query Result shows subelement, and for showing the Query Result corresponding with described product CAMEL-Subscription-Information inquiry request according to described displaying pattern information, wherein, described displaying pattern information comprises the form to be presented of Query Result.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510889299.5A CN105354743A (en) | 2015-12-07 | 2015-12-07 | Data processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510889299.5A CN105354743A (en) | 2015-12-07 | 2015-12-07 | Data processing method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105354743A true CN105354743A (en) | 2016-02-24 |
Family
ID=55330710
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510889299.5A Pending CN105354743A (en) | 2015-12-07 | 2015-12-07 | Data processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105354743A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106776885A (en) * | 2016-11-29 | 2017-05-31 | 盐城工学院 | A kind of data export method and device |
| CN108335215A (en) * | 2017-06-26 | 2018-07-27 | 平安科技（深圳）有限公司 | Case Claims Resolution method, server and computer readable storage medium |
| CN108985855A (en) * | 2018-08-01 | 2018-12-11 | 中国建设银行股份有限公司 | A kind of determination method and system of contract information |
| CN109936466A (en) * | 2017-12-15 | 2019-06-25 | 广州帷策智能科技有限公司 | The comprehensive positioning system of customer information |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104462222A (en) * | 2014-11-11 | 2015-03-25 | 安徽四创电子股份有限公司 | Distributed storage method and system for checkpoint vehicle pass data |
| CN104571057A (en) * | 2015-01-21 | 2015-04-29 | 山东大学 | Method for designing warning system database |
| CN105096061A (en) * | 2015-08-31 | 2015-11-25 | 深圳市潮务搬运有限公司 | Integrated management system of logistics enterprise |
| CN105095224A (en) * | 2014-04-25 | 2015-11-25 | 阿尔卡特朗讯 | Method, apparatus and system for carrying out OLAP analysis in mobile communication network |
-
2015
- 2015-12-07 CN CN201510889299.5A patent/CN105354743A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105095224A (en) * | 2014-04-25 | 2015-11-25 | 阿尔卡特朗讯 | Method, apparatus and system for carrying out OLAP analysis in mobile communication network |
| CN104462222A (en) * | 2014-11-11 | 2015-03-25 | 安徽四创电子股份有限公司 | Distributed storage method and system for checkpoint vehicle pass data |
| CN104571057A (en) * | 2015-01-21 | 2015-04-29 | 山东大学 | Method for designing warning system database |
| CN105096061A (en) * | 2015-08-31 | 2015-11-25 | 深圳市潮务搬运有限公司 | Integrated management system of logistics enterprise |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106776885A (en) * | 2016-11-29 | 2017-05-31 | 盐城工学院 | A kind of data export method and device |
| CN108335215A (en) * | 2017-06-26 | 2018-07-27 | 平安科技（深圳）有限公司 | Case Claims Resolution method, server and computer readable storage medium |
| CN109936466A (en) * | 2017-12-15 | 2019-06-25 | 广州帷策智能科技有限公司 | The comprehensive positioning system of customer information |
| CN108985855A (en) * | 2018-08-01 | 2018-12-11 | 中国建设银行股份有限公司 | A kind of determination method and system of contract information |
| CN108985855B (en) * | 2018-08-01 | 2023-03-28 | 中国建设银行股份有限公司 | Method and system for determining contract information |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108280365B (en) | Data access authority management method, device, terminal device and storage medium | |
| CN104915398B (en) | A kind of webpage buries method and device a little | |
| CN105354743A (en) | Data processing method and device | |
| US20130167199A1 (en) | On-Demand Authorization Management | |
| US20110313847A1 (en) | Mapping identifiers | |
| CN104199849A (en) | Advertisement injecting method and device | |
| CN106250303A (en) | Business diary collection and early warning system and business diary collection and method for early warning | |
| CN108920607B (en) | Method and device for discovering field and electronic equipment | |
| CN103473238B (en) | Dispense address location system and method | |
| CN103473230A (en) | Service range determining method, logistics service provider recommending method and corresponding device | |
| CN102411615A (en) | Identifying Physical Locations Of Entities | |
| US20160196319A1 (en) | Multi-dimensional data analysis | |
| CN109639750A (en) | Business data processing method and equipment | |
| CN105354256A (en) | Data pagination query method and apparatus | |
| CN104283975A (en) | File distribution method and device | |
| CN104346371A (en) | Business integration system report driven by in-memory database | |
| CN105335850A (en) | Network payment control method and apparatus | |
| CN103678624A (en) | Searching method, searching server, and searching request executing method and terminal | |
| CN105630995A (en) | Method and system for querying credit | |
| CN104156375A (en) | Message inputting method and system based on crowdsourcing | |
| CN110008211A (en) | Data query method, apparatus, electronic equipment and storage medium | |
| TW201445341A (en) | System and method for searching based on selected area | |
| CN106469175A (en) | Data processing method and device | |
| WO2017128681A1 (en) | Member management system suitable for transaction processing | |
| JP6267398B2 (en) | Service design support system and service design support method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160224 |
|
| RJ01 | Rejection of invention patent application after publication |