CN107491563A - Towards the data processing method and system of settlement for account - Google Patents

Towards the data processing method and system of settlement for account Download PDF

Info

Publication number
CN107491563A
CN107491563A CN201710894355.3A CN201710894355A CN107491563A CN 107491563 A CN107491563 A CN 107491563A CN 201710894355 A CN201710894355 A CN 201710894355A CN 107491563 A CN107491563 A CN 107491563A
Authority
CN
China
Prior art keywords
data
account
layer
transaction details
towards
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
Application number
CN201710894355.3A
Other languages
Chinese (zh)
Inventor
丘越崑
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
SHENZHEN AIBEI INFORMATION TECHNOLOGY Co Ltd
Original Assignee
SHENZHEN AIBEI INFORMATION TECHNOLOGY Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by SHENZHEN AIBEI INFORMATION TECHNOLOGY Co Ltd filed Critical SHENZHEN AIBEI INFORMATION TECHNOLOGY Co Ltd
Priority to CN201710894355.3A priority Critical patent/CN107491563A/en
Publication of CN107491563A publication Critical patent/CN107491563A/en
Pending legal-status Critical Current

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/25—Integrating or interfacing systems involving database management systems
    • G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
    • 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/21—Design, administration or maintenance of databases
    • G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
    • 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/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
    • 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/12—Accounting

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • Business, Economics & Management (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Quality & Reliability (AREA)
  • Development Economics (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Strategic Management (AREA)
  • Technology Law (AREA)
  • General Business, Economics & Management (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention belongs to technical field of data processing, there is provided a kind of data processing method and system towards settlement for account.This method includes pulling transaction details data, according to different dimensions table, transaction details data are filled, form the wide table of data, according to different times account phase, the wide table of data is calculated, obtains the account phase tables of data towards different themes, from the wide table of data or account phase tables of data, collect the data with business meaning.The present invention can calculate the data of different account phases exactly, realize quick clearing, reduce hardware cost towards the data processing method and system of settlement for account.

Description

Towards the data processing method and system of settlement for account
Technical field
The present invention relates to technical field of data processing, and in particular to a kind of data processing method towards settlement for account and is System.
Background technology
At present, with internet+, the new trade mode such as Alipay, wechat emerge, corporate business trading volume drastically increases Length, weak tendency of traditional relevant database in terms of storage is with computing highlight, and quasi- production environment produces sometimes can not run knot Calculate data cases.
Data processing amount is big, to hardware device, the computing capability of such as server, internal memory, disk I/O, Single Point of Faliure requirement More and more higher, enterprise are needed with high hardware cost, to support up to ten million DBMS amounts to handle and storage.Meanwhile overseas trip Swim it is hot, trade company wish to it is domestic, abroad support same service, requirement is proposed to the scalability of hardware structure.Majority It will be considered that, only big data Hadoop or MongoDB etc., such issues that could solve, the system framework that is shown such as accompanying drawing 1.
With reference to Fig. 2, traditional settlement for account process is as follows：
First pulling qualified transaction details data in the account phase, to account phase transaction details table, may there is up to ten million data Amount；
Then calculate passage from account phase transaction details meter again to take, be stored to account phase trading channel detail list；
Service charge is calculated from account phase trading channel detail list again, is stored to account phase settlement of transactions detail list.
Then using account phase settlement of transactions detail list as foundation, the form and settlement data of various different statistics granularities are generated.
Assuming that transaction details have 1000W data volume, then needing to inquire about and store three times, inquiry detail collects and several times, Such settlement process performance well imagines, during along with reaching certain big data quantity, time conditions can be caused to inquire about database Index failure and full table scan, so as to occur blocking motionless situation, if quasi- production environment is fast, it is also desirable to more than ten hour Settlement data can just be run out of.
The data of different account phases how are calculated exactly, are realized quick clearing, are those skilled in the art's urgent need to resolve Problem.
The content of the invention
For in the prior art the defects of, the invention provides a kind of data processing method towards settlement for account and be System, the data of different account phases can be calculated exactly, realize quick clearing, reduce hardware cost.
In a first aspect, the present invention provides a kind of data processing method towards settlement for account, this method includes：Pull transaction Detailed data；
According to different dimensions table, transaction details data are filled, form the wide table of data；
According to different times account phase, the wide table of data is calculated, obtains the account phase tables of data towards different themes；
From the wide table of data or account phase tables of data, collect the data with business meaning.
Further, transaction details data are pulled, are specifically included：
Transaction details data periodically are pulled, and carry out Bedding storage.
Based on above-mentioned arbitrarily towards the data processing method embodiment of settlement for account, further, during according to the different account phases Between, the wide table of data is calculated, the account phase tables of data towards different themes is obtained, specifically includes：
According to different times account phase, the wide table of data in corresponding time account phase is pulled；
According to operation rule, to the wide table parallel computation of data in corresponding time account phase, cost information, operation rule are obtained Including passage expense operation rule, service charge operation rule and ladder of sharing in the benefit expense operation rule；
The cost information involved by data or the wide table of data in the wide table of combined data, obtains the account phase towards different themes Tables of data.
Further, according to different times account phase, the wide table of data in corresponding time account phase is pulled, is specifically included：
According to the monthly account phase, the corresponding monthly interior wide table of data is pulled；
Or according to the account phase in season, pull the wide table of data in corresponding season.
Further, after periodically pulling transaction details data, before being filled to transaction details data, this method is also Including：
According to the transaction details data periodically pulled, the dimension table of regular time period is obtained；
According to different dimensions table, transaction details data are filled, specifically included：
According to existing dimension table and the dimension table of regular time period, transaction details data are filled.
Further, transaction details data are periodically pulled, and carry out Bedding storage, are specifically included：
Periodic data needed for being extracted from data source；
Data cleansing is carried out to the data of extraction, obtains the transaction details data of regular time period；
By the transaction details data of regular time period, according to pre-defined hierarchy, stored.
Second aspect, the present invention provide a kind of data handling system towards settlement for account, and the system includes initial data Layer, data warehouse layer, account phase data Layer, report data layer and dimension table layer, original data layer, data warehouse layer, account phase data Layer It is sequentially connected with report data layer, dimension table layer is also connected with data warehouse layer, and it is bright that original data layer is used for the transaction that storage pulls Count evidence accurately；Data warehouse layer is used to, according to different dimensions table, be filled transaction details data, forms the wide table of data；The account phase Data Layer was used for according to different times account phase, and the wide table of data is calculated, obtains the account phase tables of data towards different themes；Report Table data Layer is used for from the wide table of data or account phase tables of data, collects the data with business meaning；Dimension table layer is used to store not Same dimension table.
Further, the data handling system of the present embodiment towards settlement for account also includes ETL layers, ETL layers and original number Connected according to layer, ETL layers are used to extract required periodic data from data source, carry out data cleansing to the data of extraction, it is fixed to obtain The transaction details data of period phase, and according to pre-defined hierarchy, store to original data layer.
As shown from the above technical solution, the data processing method and system towards settlement for account that the present embodiment provides, lead to Cross and pull pending transaction details data, huge compression data volume, transaction details data are filled, obtaining has most Fine-grained basic data, it is easy to subsequently be directed to different themes, collects corresponding data.Meanwhile this method can also combine The wide table of data, count in different times account phase towards the account phase tables of data of different themes, the wide table of most fine-grained data is carried out Statistics, avoids repeatedly inquiring about, helps quickly to collect the data with different business meaning, improves settlement for account efficiency, section Save hardware cost.
Therefore, the present embodiment can calculate the different account phases exactly towards the data processing method and system of settlement for account Data, realize quick clearing, reduce hardware cost.
Brief description of the drawings
, below will be to specific in order to illustrate more clearly of the specific embodiment of the invention or technical scheme of the prior art The required accompanying drawing used is briefly described in embodiment or description of the prior art.In all of the figs, similar element Or part is typically identified by similar reference.In accompanying drawing, each element or part might not be drawn according to the ratio of reality.
Fig. 1 shows the system framework schematic diagram that conventional method is applied；
Fig. 2 shows the method flow diagram that traditional settlement for account method is applied；
Fig. 3 shows a kind of method flow diagram of data processing method towards settlement for account provided by the present invention；
Fig. 4 shows a kind of structural representation of data handling system towards settlement for account provided by the present invention；
Fig. 5 shows the data processing method of the data handling system provided by the present invention based on towards settlement for account Method flow diagram.
Embodiment
The embodiment of technical solution of the present invention is described in detail below in conjunction with accompanying drawing.Following examples are only used for Clearly illustrate technical scheme, therefore be intended only as example, and the protection of the present invention can not be limited with this Scope.
It should be noted that unless otherwise indicated, technical term or scientific terminology used in this application should be this hair The ordinary meaning that bright one of ordinary skill in the art are understood.
In a first aspect, a kind of data processing method towards settlement for account that the embodiment of the present invention is provided, with reference to Fig. 3, This method includes：
Step S1, pull transaction details data.
Step S2, according to different dimensions table, transaction details data are filled, name of firm, canal as corresponding to filling The information such as road title, Apply Names, form the wide table of data.
Step S3, according to different times account phase, the wide table of data is calculated, obtain the account issue evidence towards different themes Table.
Step S4, from the wide table of data or account phase tables of data, collect the data with business meaning, such as count various dimensions Form and settlement data.
Using the above-mentioned data processing method towards settlement for account, it is only necessary to more than ten minutes can run out of settlement data, from And more massive operation expanding after adapting to.
As shown from the above technical solution, the data processing method towards settlement for account that the present embodiment provides, by pulling Transaction details data are filled by pending transaction details data, huge compression data volume, and acquisition has a most fine granularity Basic data, be easy to subsequently be directed to different themes, collect corresponding data.Meanwhile this method can also be wide with reference to data Table, count in different times account phase towards the account phase tables of data of different themes, the most fine-grained wide table of data is counted, kept away Exempt from repeatedly to inquire about, help quickly to collect the data with different business meaning, improve settlement for account efficiency, save hardware into This.
Therefore, the present embodiment can calculate the data of different account phases exactly towards the data processing method of settlement for account, Quick clearing are realized, reduce hardware cost.
In order to further improve the present embodiment towards the accuracy of the data processing method of settlement for account, in data pull side Face, when pulling transaction details data, specific implementation process is：Transaction details data periodically are pulled, and carry out Bedding storage, that is, are deposited It is stored in original data layer.For example, periodically pulling daily transaction details data, data volume is greatly reduced.
When periodically pulling transaction details data, and carrying out Bedding storage, specific implementation process is as follows：
Periodic data needed for being extracted from data source.
Data cleansing is carried out to the data of extraction, obtains the transaction details data of regular time period.
By the transaction details data of regular time period, according to pre-defined hierarchy, stored, such as stored to original Data Layer, in order to data of the compatibility from different data sources, the accuracy of data is improved, is easy to the processing subsequently to data.
In terms of the data summarization of application-oriented theme, according to different times account phase, the wide table of data is calculated, obtained Towards different themes account phase tables of data when, specific implementation process is：
According to different times account phase, the wide table of data in corresponding time account phase is pulled.I.e. according to the monthly account phase, pull correspondingly The wide table of data in monthly, or according to the account phase in season, pull the wide table of data in corresponding season.For example, according to the monthly account phase, draw The corresponding monthly interior wide table of daily data is taken, according to the account phase in season, pulls the wide table of data monthly in corresponding season.
The present embodiment, when equally calculating passage takes with ladder service charge, enters towards the data processing method of settlement for account Row depth optimization.According to operation rule, to the wide table parallel computation of data in corresponding time account phase, cost information, computing are obtained Rule includes passage expense operation rule, service charge operation rule and ladder of sharing in the benefit expense operation rule.
The cost information involved by data or the wide table of data in the wide table of combined data, obtains the account phase towards different themes Tables of data.
Here, data processing method of the present embodiment towards settlement for account, can count number corresponding to corresponding account phase content According to the data of wide table, with reference to the wide table of data, take operation rule, service charge operation rule and ladder of sharing in the benefit expense computing rule according to passage Then, parallel computation passage expense, service charge and ladder of sharing in the benefit expense etc. cost information, greatly settlement process is optimized with again Structure, good readability and maintainability are realized, without repeatedly inquiry, calculate with storing, substantially increase the clearing of account issue evidence Efficiency.
After periodically pulling transaction details data, before being filled to transaction details data, the present embodiment is towards the account phase The data processing method of clearing also includes：According to the transaction details data periodically pulled, the dimension table of regular time period is obtained.Example Such as, according to the transaction details data pulled daily, the dimension table on the same day is obtained.
According to different dimensions table, when being filled to transaction details data, specific implementation process is：According to existing dimension The dimension table of table and regular time period, transaction details data are filled, in order to according to the dimension table after real-time update, carry out Data are filled.
Here, the data processing method of the present embodiment towards settlement for account can be bright to merchandising according to newest dimension table Count accurately according to data filling is carried out, comprehensive and extensive associated data is obtained, in order to obtain the most fine-grained wide table of data.
The data processing method of the present embodiment towards settlement for account can also the correctness of regular check day data and complete Property, for different scenes, there is provided different compensation mechanism processing, finding and repair early problem reduces risk.
Second aspect, a kind of data handling system towards settlement for account that the embodiment of the present invention is provided, with reference to Fig. 4, The system includes original data layer 1, data warehouse layer 2, account phase data Layer 3, report data layer 4 and dimension table layer 5, original data layer 1st, data warehouse layer 2, account phase data Layer 3 and report data layer 4 are sequentially connected, and dimension table layer 5 is also connected with data warehouse layer 2.
Original data layer 1 is used to store the transaction details data pulled.Original data layer 1 stores consumer sale detail list, Specifying information includes：Order number, dealing money, trade company's numbering, application numbers, channel number, exchange hour etc..
Data warehouse layer 2 is used to, according to different dimensions table, be filled transaction details data, forms the wide table of data.Number DW consumer sales detail list, DW consumer sales most fine granularity statistical form etc. are stored according to depot layer 2, wherein, DW consumer sales are detailed The specifying information of table includes：When pulling date, order number, dealing money, trade company's numbering, application numbers, channel number, transaction Between, passage major class, main trade company numbering etc., the specifying information of DW consumer sales most fine granularity statistical form includes：Pull date, transaction The amount of money, trade company's numbering, application numbers, Apply Names, channel number, tunnel name, passage major class, name of firm, main trade company compile Number.
Account phase data Layer 3 was used for according to different times account phase, and the wide table of data is calculated, obtained towards different themes Account phase tables of data.Account phase data Layer 3, which stores BD consumer sales most fine granularity statistical form, specifying information, to be included：DW consumer sales are most Fine granularity statistics literary name section, DIM trade companies contract passage take literary name section, DIM trade companies contract service expense literary name section, passage expense, service Take, the information such as settlement amounts.
Report data layer 4 is used for from the wide table of data or account phase tables of data, collects the data with business meaning.Dimension table layer 5 are used to store different dimension tables.The memory channel information table of report data layer 4, merchant information table, trade company's contracts card, trade company close Take table with channel table and trade company's contract service, wherein, the information of channel information table storage includes：Channel number, tunnel name, lead to The information such as road major class, passage rate, passage single service charge, the information of merchant information table storage include：Trade company's numbering, trade company's name The information such as title, merchant type, main trade company numbering, the information of trade company contracts card storage include main trade company numbering, the Office Of Contract Settlements cycle, The information such as contract time started, contract end time, modification of contract time, the information of trade company's contract channel table storage include：It is main The information such as trade company's numbering, passage major class, passage rate, the minimum service charge of passage, trade company's contract service take the packet of table storage Include：The information such as main trade company's numbering, amount of money scope, service rate.
As shown from the above technical solution, the data handling system towards settlement for account that the present embodiment provides, by pulling Pending transaction details data, huge compression data volume, original data layer 1 can be in operation systems and data warehouse layer 2 Between form separation layer, the details query function of transfer part operation system.Transaction details data are filled, acquisition has Most fine-grained basic data, it is easy to subsequently be directed to different themes, collects corresponding data.Meanwhile the system can also be tied The wide table of data is closed, counts in different times account phase towards the account phase tables of data of different themes, the most fine-grained wide table of data is entered Row statistics, avoids repeatedly inquiring about, helps quickly to collect the data with different business meaning, improves settlement for account efficiency, Save hardware cost.
Therefore, the present embodiment can calculate the data of different account phases exactly towards the data handling system of settlement for account, Quick clearing are realized, reduce hardware cost.
The data handling system of the present embodiment towards settlement for account also includes ETL layers, and ETL layers are connected with original data layer 1, ETL layers are used to extract required periodic data from data source, carry out data cleansing to the data of extraction, obtain the friendship of regular time period Easy detailed data, and according to pre-defined hierarchy, store to original data layer 1.Here, using ETL layers from different numbers Extracted, changed and loaded according to source, improved data compatibility, be easy to clean data and stored.
In actual application, with reference to Fig. 5, the data handling system using the present embodiment towards settlement for account, held Capable business main flow is described as follows：
It is daily concurrently to pull transaction details, and per diem table most fine granularity statistical summaries store, and such as store trade company, application, canal The information such as road, passage, date.
When going out bill, the day of trade combined data that clearing are participated in time account phase is pulled.
Settlement amounts and service charge are calculated by program, wherein, settlement amounts can be passage rate and the minimum expense of single Value, service charge can be ladder rates.
Generate combined data.
Account phase relevant information is filled, for example, filling trade company, application, tunnel name in summary sheet.
By the storage of settlement for account combined data into database.
The form and settlement data of various dimensions are counted according to clearing combined data.
In the description of this specification, reference term " one embodiment ", " some embodiments ", " example ", " specifically show The description of example " or " some examples " etc. means specific features, structure, material or the spy for combining the embodiment or example description Point is contained at least one embodiment or example of the present invention.In this manual, to the schematic representation of above-mentioned term not Identical embodiment or example must be directed to.Moreover, specific features, structure, material or the feature of description can be with office Combined in an appropriate manner in one or more embodiments or example.In addition, in the case of not conflicting, the skill of this area Art personnel can be tied the different embodiments or example and the feature of different embodiments or example described in this specification Close and combine.
It should be noted that the flow chart and block diagram in accompanying drawing show the service of multiple embodiments according to the present invention Architectural framework in the cards, function and the operation of device, method and computer program product.At this point, flow chart or block diagram In each square frame can represent the part of a module, program segment or code, the module, one of program segment or code Subpackage is containing one or more executable instructions for being used to realize defined logic function.It should also be noted that at some as replacement Realization in, the function that is marked in square frame can also be to occur different from the order marked in accompanying drawing.For example, two continuous Square frame can essentially perform substantially in parallel, they can also be performed in the opposite order sometimes, and this is according to involved work( Depending on energy.It is also noted that each square frame and block diagram in block diagram and/or flow chart and/or the square frame in flow chart Combination, function or the special hardware based server of action it can be realized as defined in execution, or can be with special The combination of hardware and computer instruction is realized.
The unit illustrated as separating component can be or may not be physically separate, show as unit The part shown can be or may not be physical location, you can with positioned at a place, or can also be published to multiple On NE.Some or all of unit therein can be selected to realize the mesh of this embodiment scheme according to the actual needs 's.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, can also That unit is individually physically present, can also two or more units it is integrated in a unit.
If the function is realized in the form of SFU software functional unit and is used as independent production marketing or in use, can be with It is stored in a computer read/write memory medium.Based on such understanding, technical scheme is substantially in other words The part to be contributed to prior art or the part of the technical scheme can be embodied in the form of software product, the meter Calculation machine software product is stored in a storage medium, including some instructions are causing a computer equipment (can be People's computer, server, or network equipment etc.) perform all or part of step of each embodiment methods described of the present invention. And foregoing storage medium includes：USB flash disk, mobile hard disk, read-only storage (ROM, Read-Only Memory), arbitrary access are deposited Reservoir (RAM, Random Access Memory), magnetic disc or CD etc. are various can be with the medium of store program codes.
Finally it should be noted that：Various embodiments above is merely illustrative of the technical solution of the present invention, rather than its limitations；To the greatest extent The present invention is described in detail with reference to foregoing embodiments for pipe, it will be understood by those within the art that：Its according to The technical scheme described in foregoing embodiments can so be modified, either which part or all technical characteristic are entered Row equivalent substitution；And these modifications or replacement, the essence of appropriate technical solution is departed from various embodiments of the present invention technology The scope of scheme, it all should cover among the claim of the present invention and the scope of specification.

Claims (8)

  1. A kind of 1. data processing method towards settlement for account, it is characterised in that including：
    Pull transaction details data；
    According to different dimensions table, the transaction details data are filled, form the wide table of data；
    According to different times account phase, the wide table of the data is calculated, obtains the account phase tables of data towards different themes；
    From the wide table of the data or the account phase tables of data, collect the data with business meaning.
  2. 2. according to claim 1 towards the data processing method of settlement for account, it is characterised in that
    Transaction details data are pulled, are specifically included：
    Transaction details data periodically are pulled, and carry out Bedding storage.
  3. 3. according to claim 1 towards the data processing method of settlement for account, it is characterised in that
    According to different times account phase, the wide table of the data is calculated, obtains the account phase tables of data towards different themes, specifically Including：
    According to different times account phase, the wide table of data in corresponding time account phase is pulled；
    According to operation rule, to the wide table parallel computation of data in corresponding time account phase, cost information, the operation rule are obtained Including passage expense operation rule, service charge operation rule and ladder of sharing in the benefit expense operation rule；
    Collect the data in the wide table of the data or the cost information involved by the wide table of the data, obtain towards different themes Account phase tables of data.
  4. 4. according to claim 3 towards the data processing method of settlement for account, it is characterised in that
    According to different times account phase, the wide table of data in corresponding time account phase is pulled, is specifically included：
    According to the monthly account phase, the corresponding monthly interior wide table of data is pulled；
    Or according to the account phase in season, pull the wide table of data in corresponding season.
  5. 5. according to claim 2 towards the data processing method of settlement for account, it is characterised in that
    After periodically pulling transaction details data, before being filled to the transaction details data, this method also includes：
    According to the transaction details data periodically pulled, the dimension table of regular time period is obtained；
    According to different dimensions table, the filling data associated with the transaction details data, specifically include：
    According to existing dimension table and the dimension table of regular time period, the filling data associated with the transaction details data.
  6. 6. according to claim 2 towards the data processing method of settlement for account, it is characterised in that
    Transaction details data periodically are pulled, and carry out Bedding storage, are specifically included：
    Periodic data needed for being extracted from data source；
    Data cleansing is carried out to the data of extraction, obtains the transaction details data of regular time period；
    By the transaction details data of regular time period, according to pre-defined hierarchy, stored.
  7. A kind of 7. data handling system towards settlement for account, it is characterised in that including：
    Original data layer, data warehouse layer, account phase data Layer, report data layer and dimension table layer,
    The original data layer, the data warehouse layer, the account phase data Layer and the report data layer are sequentially connected,
    The dimension table layer is also connected with the data warehouse layer,
    The original data layer, for storing the transaction details data pulled；
    The data warehouse layer, for according to different dimensions table, being filled to the transaction details data, it is wide forming data Table；
    The account phase data Layer, for according to different times account phase, calculating the wide table of the data, obtaining towards different masters The account phase tables of data of topic；
    The report data layer, for from the wide table of the data or the account phase tables of data, collecting the number with business meaning According to；
    The dimension table layer, for storing different dimension tables.
  8. 8. according to claim 7 towards the data handling system of settlement for account, it is characterised in that described also including ETL layers ETL layers are connected with the original data layer,
    The ETL layers, for extracting required periodic data from data source, data cleansing is carried out to the data of extraction, it is fixed to obtain The transaction details data of period phase, and according to pre-defined hierarchy, store to the original data layer.
CN201710894355.3A 2017-09-28 2017-09-28 Towards the data processing method and system of settlement for account Pending CN107491563A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710894355.3A CN107491563A (en) 2017-09-28 2017-09-28 Towards the data processing method and system of settlement for account

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710894355.3A CN107491563A (en) 2017-09-28 2017-09-28 Towards the data processing method and system of settlement for account

Publications (1)

Publication Number Publication Date
CN107491563A true CN107491563A (en) 2017-12-19

Family

ID=60653339

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710894355.3A Pending CN107491563A (en) 2017-09-28 2017-09-28 Towards the data processing method and system of settlement for account

Country Status (1)

Country Link
CN (1) CN107491563A (en)

Cited By (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108648092A (en) * 2018-05-16 2018-10-12 中国平安人寿保险股份有限公司 Loss ratio computational methods, device, equipment and computer readable storage medium
CN109034910A (en) * 2018-08-16 2018-12-18 中国建设银行股份有限公司 A kind of fee calculation procedure and device
CN110019561A (en) * 2018-05-14 2019-07-16 网联清算有限公司 Transaction data method of summary, device and computer equipment
CN110060118A (en) * 2019-02-27 2019-07-26 浙江执御信息技术有限公司 A kind of order is honoured an agreement full link method for real-time monitoring, device and computer equipment
CN111930760A (en) * 2020-07-21 2020-11-13 银盛支付服务股份有限公司 Transaction flow distributed batch processing method and system
CN112100264A (en) * 2020-09-16 2020-12-18 国网辽宁省电力有限公司电力科学研究院 Power project contract monitoring system and method
CN112418807A (en) * 2020-11-30 2021-02-26 国网重庆市电力公司物资分公司 Contract settlement method

Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101075304A (en) * 2006-05-18 2007-11-21 河北全通通信有限公司 Method for constructing decision supporting system of telecommunication industry based on database
CN102236851A (en) * 2010-04-21 2011-11-09 百度在线网络技术（北京）有限公司 Real-time computation method and system of multi-dimensional credit system based on user empowerment
CN104036088A (en) * 2014-06-23 2014-09-10 国网山东省电力公司 Method and system for generating equity curves of group enterprise in real time
CN104915456A (en) * 2015-07-03 2015-09-16 宁夏隆基宁光仪表有限公司 Mass power utilization data mining method on the basis of data analysis system
CN106202081A (en) * 2015-04-30 2016-12-07 阿里巴巴集团控股有限公司 Real-time data processing method and device
CN106332052A (en) * 2016-08-30 2017-01-11 上海新炬网络技术有限公司 Micro-regional public security early-warning method based on mobile communication terminal
CN106709652A (en) * 2016-12-27 2017-05-24 中国建设银行股份有限公司 Multi-dimensional metering system and method for employee performances
CN107016501A (en) * 2017-03-28 2017-08-04 浙江力太科技有限公司 A kind of efficient industrial big data multidimensional analysis method

Patent Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101075304A (en) * 2006-05-18 2007-11-21 河北全通通信有限公司 Method for constructing decision supporting system of telecommunication industry based on database
CN102236851A (en) * 2010-04-21 2011-11-09 百度在线网络技术（北京）有限公司 Real-time computation method and system of multi-dimensional credit system based on user empowerment
CN104036088A (en) * 2014-06-23 2014-09-10 国网山东省电力公司 Method and system for generating equity curves of group enterprise in real time
CN106202081A (en) * 2015-04-30 2016-12-07 阿里巴巴集团控股有限公司 Real-time data processing method and device
CN104915456A (en) * 2015-07-03 2015-09-16 宁夏隆基宁光仪表有限公司 Mass power utilization data mining method on the basis of data analysis system
CN106332052A (en) * 2016-08-30 2017-01-11 上海新炬网络技术有限公司 Micro-regional public security early-warning method based on mobile communication terminal
CN106709652A (en) * 2016-12-27 2017-05-24 中国建设银行股份有限公司 Multi-dimensional metering system and method for employee performances
CN107016501A (en) * 2017-03-28 2017-08-04 浙江力太科技有限公司 A kind of efficient industrial big data multidimensional analysis method

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110019561A (en) * 2018-05-14 2019-07-16 网联清算有限公司 Transaction data method of summary, device and computer equipment
CN108648092A (en) * 2018-05-16 2018-10-12 中国平安人寿保险股份有限公司 Loss ratio computational methods, device, equipment and computer readable storage medium
CN108648092B (en) * 2018-05-16 2023-07-21 中国平安人寿保险股份有限公司 Insurance odds ratio calculating method, apparatus, device and computer readable storage medium
CN109034910A (en) * 2018-08-16 2018-12-18 中国建设银行股份有限公司 A kind of fee calculation procedure and device
CN110060118A (en) * 2019-02-27 2019-07-26 浙江执御信息技术有限公司 A kind of order is honoured an agreement full link method for real-time monitoring, device and computer equipment
CN111930760A (en) * 2020-07-21 2020-11-13 银盛支付服务股份有限公司 Transaction flow distributed batch processing method and system
CN112100264A (en) * 2020-09-16 2020-12-18 国网辽宁省电力有限公司电力科学研究院 Power project contract monitoring system and method
CN112418807A (en) * 2020-11-30 2021-02-26 国网重庆市电力公司物资分公司 Contract settlement method

Similar Documents

Publication Publication Date Title
CN107491563A (en) Towards the data processing method and system of settlement for account
CN103853820B (en) Data processing method and data processing system
CN109544316B (en) Method and system for urging collection of real-time case division according to proportion
CN106844682B (en) Method for interchanging data, apparatus and system
CN102024062B (en) Device and method for realizing data dynamic cache
CN105446990B (en) A kind of business data processing method and equipment
CN104636338B (en) A kind of data cleansing storage method for the monitoring of value-added tax negative and positive ticket
WO2014159296A1 (en) A method, system and program product for matching of transaction records
CN102651008A (en) Method and equipment for organizing data records in relational data base
US20160085832A1 (en) System and method of analyzing data using bitmap techniques
CN107832463A (en) A kind of finance data service platform
CN107729448A (en) A kind of data handling system based on data warehouse
CN107977855A (en) A kind of method and device of managing user information
CN107480235A (en) A kind of database framework of data platform
US20170061347A1 (en) Computerized system and method for predicting quantity levels of a resource
CN109582476A (en) Data processing method, apparatus and system
CN112184416B (en) Service processing method, device, equipment and storage medium of judicial freezing system
CN117350880A (en) Full-link account checking method, device, equipment and medium based on snowflake algorithm
CN107977892A (en) Bank's position real-time statistical method and system
CN112035681A (en) Credit card rate information determination method and device based on knowledge graph
CN102354277A (en) Data storage method and device
CN108256816A (en) A kind of commission data processing method, device and equipment
Burdick et al. Data science challenges in real estate asset and capital markets
Siripongvakin et al. Infrastructure project investment decision timing using a real options analysis framework with Rainbow option
Lv et al. Classification of data granularity in data warehouse

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
RJ01 Rejection of invention patent application after publication

Application publication date: 20171219

RJ01 Rejection of invention patent application after publication