CN109299065A - Generate processing method, system and the storage medium of asset-liabilities unified view - Google Patents

Generate processing method, system and the storage medium of asset-liabilities unified view Download PDF

Info

Publication number
CN109299065A
CN109299065A CN201810813084.9A CN201810813084A CN109299065A CN 109299065 A CN109299065 A CN 109299065A CN 201810813084 A CN201810813084 A CN 201810813084A CN 109299065 A CN109299065 A CN 109299065A
Authority
CN
China
Prior art keywords
data
liabilities
asset
newly
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
Application number
CN201810813084.9A
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.)
China Construction Bank Corp
Original Assignee
China Construction Bank Corp
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 China Construction Bank Corp filed Critical China Construction Bank Corp
Priority to CN201810813084.9A priority Critical patent/CN109299065A/en
Publication of CN109299065A publication Critical patent/CN109299065A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/12Accounting
    • G06Q40/125Finance or payroll

Landscapes

  • Business, Economics & Management (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Engineering & Computer Science (AREA)
  • Development Economics (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Strategic Management (AREA)
  • Technology Law (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)

Abstract

The present invention provides a kind of processing method for generating asset-liabilities unified view, which is characterized in that the described method includes: each collect components initial data of banking system, and the initial data is summarized into viewdata library;Data cleansing and data loading processing are carried out to the initial data, and according to preset subject template generation balance sheet;And data mart modeling processing is carried out according to the balance sheet, generate asset-liabilities unified view.By the collection working process to initial data, to generate asset-liabilities view, it can be achieved that the subsequent processing for asset-liabilities data provides accurate comprehensive data support, while having the advantages that safe and practical and save the cost.

Description

Generate processing method, system and the storage medium of asset-liabilities unified view
Technical field
The present invention relates to data processing fields, in particular to a kind of processing side for generating asset-liabilities unified view Method, system and storage medium.
Background technique
Balance sheet is also financial standing table, indicates the financial shape that enterprise fixes the date (usually each accounting end of term) one Main accounting statement, the balance sheet of condition (i.e. assets, the situation of debt and business creditor's equity) utilize accounting equation principle, will It is divided into " assets " and " debt and stockholder's equity " Liang great Qu in accordance with assets, debt, owner's equity the transaction subject of principle of accounting Block, by recording separately, transferring accounts, ledger, tentative calculation, after adjustment etc. accounting procedure, be with the static conditions of the enterprise of specific date Benchmark is condensed into a report, reader's shortest time is allowed to understand enterprise management condition.
Bank provides many services, including service for corporate customers for client, and to private business, debit card, credit card finances and pledges group Part, fund security component etc..Client is completed using the different types of business that the component of these all multiple types of bank provides Various businesses, the various accounts of client, financial relevant information distribution record are in the database of this all multicomponent, these data are very To being deployed in the computer room of the different production centers.In addition under the complicated market background of current economic relation, a visitor For the data at family not only in a bank, the asset-liabilities of client are also distributed about different banks, in different economic entities.
Common asset-liabilities need to carry out statistics by asset-liabilities of the corporate client to dispersion and summarize, by time-consuming Statistics calculates, and can just obtain an asset-liabilities statistical form, and often timeliness has already fallen behind the statistical form obtained.The present invention converges Collect client in the financial information of same bank's difference component, different product or even other banks or economic entity, by default And the balance sheet account ownership that can be adjusted flexibly process the balance sheet on the day of client.
There are shortcomings for existing invention: (1) covering product is few, and asset-liabilities integrality is insufficient, is embodied in two o'clock: cannot Bank's various assemblies are completely covered, data of the client except bank cannot be included in scope of statistics, only client is in current row Assets and liabilities partial view.(2) historical view deficient function, existing function often only provide one day number of views According to being unable to any one day in query history asset-liabilities view.(3) scalability has limitation, and existing capability product limits to body Now both ways, first is that the supportive difference to external data modifies historical view second is that historical external data cannot be supplemented.(4) At high cost, the system that marquee account often utilizes itself records client's major part transaction data, forms asset-liabilities unified view, The system is suitable only for large enterprise client, and cost is too high for medium-sized and small enterprises.
Summary of the invention
In order to solve the above technical problems, the present invention provides a kind of processing method for generating asset-liabilities unified view, being System and storage medium solve current asset liability account data and analyze incomplete problems, pass through the collection to initial data Working process solves few product-laden in current techniques, deficient function, scalability limitation to generate asset-liabilities view With problems at high cost.The present invention mainly utilizes client in the product data of bank, provides the service of low cost for visitor.
According to a first aspect of the embodiments of the present invention, a kind of processing method for generating asset-liabilities unified view is provided, The described method includes:
Each collect components initial data of banking system, and the initial data is summarized into viewdata library;
Data cleansing and data loading processing are carried out to the initial data, and according to preset subject template generation assets Liability account;And
Data mart modeling processing is carried out according to the balance sheet, generates asset-liabilities unified view.
According to a second aspect of the embodiments of the present invention, a kind of processing system generating asset-liabilities unified view, institute are provided The system of stating includes:
Collection module is used for each collect components initial data of banking system, and the initial data is summarized to number of views According in library;
Processing module, for carrying out data cleansing and data loading processing to the initial data, and according to preset section Mesh template generation balance sheet;And
Generation module generates asset-liabilities unified view for carrying out data mart modeling processing according to the balance sheet.
According to a third aspect of the embodiments of the present invention, a kind of computer readable storage medium, the computer storage are provided Medium includes computer program, wherein the computer program makes described one when being executed by one or more computers A or multiple computers perform the following operations:
The operation includes the steps that the processing method for generating asset-liabilities unified view as described above is included.
Implement a kind of processing method for generating asset-liabilities unified view, system and storage provided in an embodiment of the present invention to be situated between Matter has the advantage that can be achieved to provide accurate comprehensive data for the subsequent processing of asset-liabilities data supports have simultaneously The advantages of safe and practical and save the cost
Detailed description of the invention
Fig. 1 is a kind of flow chart of the processing method of generation asset-liabilities unified view of the embodiment of the present invention;
Fig. 2 is the flow chart of step S3 in the method for the embodiment of the present invention;
Fig. 3 is a kind of structural schematic diagram of the processing system 1 of generation asset-liabilities unified view of the embodiment of the present invention;
Fig. 4 is the structural schematic diagram of behavior generation module 300 described in system 1 described in the embodiment of the present invention.
Specific embodiment
To keep the purposes, technical schemes and advantages of the embodiment of the present invention clearer, below in conjunction with attached drawing to this hair It is bright to be described in further detail.
Fig. 1 is a kind of flow chart of the processing method of generation asset-liabilities unified view of the embodiment of the present invention;Referring to figure 1, which comprises
Step S1, each collect components initial data of banking system, and the initial data is summarized into viewdata library;
Step S2 carries out data cleansing and data loading processing to the initial data, and according to preset subject template Generate balance sheet;And
Step S3 carries out data mart modeling processing according to the balance sheet, generates asset-liabilities unified view.
In embodiments of the present invention, the initial data includes: leading outside the real time data of bank product and client Enter data.Wherein, most of initial data is to be summarized data-pushing to assets by client master's bank's other assemblies to be used Debt unified view product, the data of a part of dynamic change, such as fund, national debt security class product are counting newest gold Real-time query is needed to obtain when volume.To guarantee data integrity, some data source imports outside client, such as its The data such as his deposit at bank, loan.(1) timeliness of data summarization: the data that different components generate inside banking system, The data big for data volume at regular intervals according to setting summarize to the data warehouse of asset-liabilities unified view product, The data small for data volume can real-time query to viewdata warehouse, to guarantee client it can be seen that newest asset-liabilities View.(2) integrality of data source: having a many different systems, component inside bank, established in the present invention with it is all can The data path of the component of client's account information can be stored, guarantees the integrality of bank's interior views data;In addition it is supplied to visitor Family external data introducting interface, batch import the financial data in other banks or economic entity, to guarantee view reflection visitor User data integrality;The present invention is not only merely to have calculated the asset-liabilities view information of section, and pass through preservation again Original accounting data, can be for managing detailed catalogue corresponding to each view subitem of user query.
It is in embodiments of the present invention, described that summarize the initial data into viewdata library include: using cutting The form of piece table summarizes the initial data into viewdata library.(1) initial data stores.It is processed using raw information For that can not be abandoned after viewdata, to guarantee that client can be in debt by supplementing the method for historical data to modify historic asset View, the function that this product supports historical view to regenerate, it is therefore desirable to save history initial data in the database.For Database pressure is reduced, big table is done mostly in the form of zipper table for data volume and is saved, is opened when re-working Chain is read.Less still more table is accessed for data volume to save in the form of slice table.(2) viewdata stores.This Current asset-liabilities situation section information is not only supported in invention, and supports the inquiry of historical view data, guarantees that client can To inquire the asset-liabilities view of history some day according to inputting date.Viewdata is saved in the form of being sliced table.
The present invention is by the collection working process to initial data, to generate asset-liabilities view, it can be achieved that for assets The subsequent processing of debt data provides accurate comprehensive data and supports, while having the advantages that safe and practical and save the cost.Tool For body including the following three aspects: (1) flexibility of balance sheet item: having preset 62 kinds in systems commonly Balance sheet item item, such as enterprise's current deposit, short term loan etc..Meet the asset-liabilities view demand of most of clients. For the demand of certain Customer Personality China, customized balance sheet account item is supported.For newly using the client of this product, system Read preset subject template, in process data, by various assets of the client in bank, debt data such as deposit, fund, Loan etc. is matched to corresponding subject according to conventional financial rule, and the balance sheet of standard is processed for client.(2) client can not Correspond to incidence relation using the subject data of default, can be modified by hand on the basis of master die version, by its arbitrary data such as some The deposit of account, certain fund held belong to oneself desired section now, will be according to new section's eye diagram when processing again Asset-liabilities tabular views are provided for client.Accounting data ownership section purpose flexibility: for client in different bank product group Accounting data such as current under part, subject ownership periodically etc., some common ownership of system default, as current belongs to client Assets, loan belong to the debt etc. of client.The adjustment for some specialities attribution data types, client Ke Gen are supported simultaneously Certain a kind of or some account is classified as in a certain scarabaeidae mesh of asset-liabilities view according to the individual demand of oneself.(3) outside The flexibility that portion's data import: client often not only has accounting data in a bank, and not only has asset-liabilities in bank Data, the present invention are to support client to import the batch data of other banks or economic entity, and belonged to according to client's setting In scarabaeidae mesh in asset-liabilities view, the different data of different components wants inductive statistics into unified financial statement system, A complete balance sheet is processed, provides asset-liabilities unified view for client.
Fig. 2 is the flow chart of step S3 in the method for the embodiment of the present invention;Referring to fig. 2, the step S3 includes:
Step S31 identifies newly-increased client according to the balance sheet, traverses banking component data and calculates newly-increased visitor The family amount of money;
Step S32, the newly-increased data class of processing bank, and establish and the incidence relation of view properties and the new volume increase of calculating The product amount of money;
Step S33 increases client's amount of money and the newly-increased product value described in Classifying Sum newly, generates the money of multidisciplinary level Produce debt unified view.
In embodiments of the present invention, the step S3 can realize following effect: (1) data mart modeling logic: the present invention When generating asset-liabilities unified view when processing initial data, it is divided into three parts, first is that the meter of newly-increased client's existing procucts It calculates, second is that the calculating of newly-increased product information generates final asset-liabilities unified view third is that each product summarizes.It is specific and Speech: the first step identifies newly-increased client, traverses each bank's difference group without historic asset debt general view data for newly-increased client The data that part provides such as deposit data, loan data, fund treasuries data, by each of them data summarization to corresponding In bank product, as current deposit and fixed deposit all import in deposit product.And section is established according to normal view configuration The relationship of mesh and product, and calculate the amount of money and scarabaeidae purpose amount of money value of every kind of product.Second step, processing bank are newly-increased Data class, i.e., new bank product data.The data that client belongs to new product category are mapped to corresponding subject, are established With the incidence relation of view properties, the amount information of every kind of product is calculated.Third step, each product value of Classifying Sum, each layer The grade subject amount of money, generates the asset-liabilities unified view of complete multidisciplinary level.(2) supplement of historical data and again processing: The present invention supports that client can handle the supplement of historical data again after supplementing historical data, opens from the date of supplement Beginning re-works all historical datas, generates new asset-liabilities view.To guarantee the asset-liabilities number of views generated According to correctness.
Fig. 3 is a kind of structural schematic diagram of the processing system 1 of generation asset-liabilities unified view of the embodiment of the present invention;Ginseng See Fig. 3, the system 1 includes:
Collection module 100 is used for each collect components initial data of banking system, and the initial data is summarized to view In database;
Processing module 200, for carrying out data cleansing and data loading processing to the initial data, and according to preset Subject template generation balance sheet;And
Generation module 300 generates the unified view of asset-liabilities for carrying out data mart modeling processing according to the balance sheet Figure.
In embodiments of the present invention, the initial data includes: leading outside the real time data of bank product and client Enter data.
It is in embodiments of the present invention, described that summarize the initial data into viewdata library include: using cutting The form of piece table summarizes the initial data into viewdata library.
Fig. 4 is the structural schematic diagram of behavior generation module 300 described in system 1 described in the embodiment of the present invention.Referring to fig. 4, The generation module 300 includes:
Newly-increased client's computing unit 310, for identifying newly-increased client, traversing banking component according to the balance sheet Data simultaneously calculate newly-increased client's amount of money;
Newly-increased Data Computation Unit 320, the data class increased newly for handling bank, and foundation are associated with view properties Relationship simultaneously calculates newly-increased product value;
View generation unit 330 generates more for increasing client's amount of money and the newly-increased product value described in Classifying Sum newly The asset-liabilities unified view of subject level.
In addition, the computer storage medium includes to calculate the present invention also provides a kind of computer readable storage medium Machine program, which is characterized in that the computer program makes one or more of when being executed by one or more computers Computer performs the following operations: the operation includes that the processing method as described above for generating asset-liabilities unified view is included The step of, details are not described herein.
Through the above description of the embodiments, those skilled in the art can be understood that the present invention can be by The mode of software combination hardware platform is realized.Based on this understanding, technical solution of the present invention makes tribute to background technique That offers can be embodied in the form of software products in whole or in part, which can store is situated between in storage In matter, such as ROM/RAM, magnetic disk, CD, including some instructions use is so that a computer equipment (can be individual calculus Machine, server or network equipment etc.) execute method described in certain parts of each embodiment of the present invention or embodiment.
The above disclosure is only a preferred embodiment of the invention, cannot limit protection of the invention certainly with this Range, therefore is still fallen within by right of the present invention and is wanted for equivalent variations made by above-described embodiment according to the introduction of the claims in the present invention It asks in the range of being covered.

Claims (9)

1. a kind of processing method for generating asset-liabilities unified view, which is characterized in that the described method includes:
Each collect components initial data of banking system, and the initial data is summarized into viewdata library;
Data cleansing and data loading processing are carried out to the initial data, and according to preset subject template generation asset-liabilities Table;And
Data mart modeling processing is carried out according to the balance sheet, generates asset-liabilities unified view.
2. method as described in claim 1, which is characterized in that the initial data includes:
Data are imported outside the real time data of bank product and client.
3. method as described in claim 1, which is characterized in that described to summarize the initial data to viewdata library Zhong Bao It includes:
The initial data is summarized into viewdata library using the form of slice table.
4. method as described in claim 1, which is characterized in that it is described that data mart modeling processing is carried out according to the balance sheet, Generating asset-liabilities unified view includes:
According to the balance sheet, newly-increased client is identified, traverse banking component data and calculate newly-increased client's amount of money;
The newly-increased data class of bank is handled, and is established and the incidence relation of view properties and the newly-increased product value of calculating;
It increases client's amount of money and the newly-increased product value described in Classifying Sum newly, generates the unified view of asset-liabilities of multidisciplinary level Figure.
5. a kind of processing system for generating asset-liabilities unified view, which is characterized in that the system comprises:
Collection module is used for each collect components initial data of banking system, and the initial data is summarized to viewdata library In;
Processing module, for carrying out data cleansing and data loading processing to the initial data, and according to preset subject mould Plate generates balance sheet;And
Generation module generates asset-liabilities unified view for carrying out data mart modeling processing according to the balance sheet.
6. system as claimed in claim 5, which is characterized in that the initial data includes:
Data are imported outside the real time data of bank product and client.
7. system as claimed in claim 5, which is characterized in that described to summarize the initial data to viewdata library Zhong Bao It includes:
The initial data is summarized into viewdata library using the form of slice table.
8. system as claimed in claim 5, which is characterized in that the generation module includes:
Newly-increased client's computing unit traverses banking component data and counts for identifying newly-increased client according to the balance sheet Calculate newly-increased client's amount of money;
Newly-increased Data Computation Unit for handling the newly-increased data class of bank, and is established with the incidence relation of view properties simultaneously Calculate newly-increased product value;
View generation unit generates multidisciplinary layer for increasing client's amount of money and the newly-increased product value described in Classifying Sum newly The asset-liabilities unified view of grade.
9. a kind of computer readable storage medium, the computer storage medium includes computer program, which is characterized in that institute Stating computer program performs the following operations one or more of computers when being executed by one or more computers:
The operation includes that the processing method of the generation asset-liabilities unified view as described in any one of claim 5-8 includes The step of.
CN201810813084.9A 2018-07-23 2018-07-23 Generate processing method, system and the storage medium of asset-liabilities unified view Pending CN109299065A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201810813084.9A CN109299065A (en) 2018-07-23 2018-07-23 Generate processing method, system and the storage medium of asset-liabilities unified view

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201810813084.9A CN109299065A (en) 2018-07-23 2018-07-23 Generate processing method, system and the storage medium of asset-liabilities unified view

Publications (1)

Publication Number Publication Date
CN109299065A true CN109299065A (en) 2019-02-01

Family

ID=65167848

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201810813084.9A Pending CN109299065A (en) 2018-07-23 2018-07-23 Generate processing method, system and the storage medium of asset-liabilities unified view

Country Status (1)

Country Link
CN (1) CN109299065A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111538732A (en) * 2020-05-11 2020-08-14 甘肃省地质调查院 Natural resource asset liability management system based on big data

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104392291A (en) * 2014-09-05 2015-03-04 宁波和佳软件技术有限公司 Financial service management information platform
CN105631745A (en) * 2015-12-31 2016-06-01 北京神州绿盟信息安全科技股份有限公司 Asset view construction method and device
CN105931114A (en) * 2016-04-18 2016-09-07 中国建设银行股份有限公司 Centralized monitoring and analysis method and system for multi-application transaction information logic paths of bank
CN106022908A (en) * 2016-05-17 2016-10-12 中国建设银行股份有限公司 Method and system for querying information of assets and liabilities
CN106209444A (en) * 2016-06-29 2016-12-07 浙江理工大学 A kind of IT assets synergic monitoring system based on unified view

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104392291A (en) * 2014-09-05 2015-03-04 宁波和佳软件技术有限公司 Financial service management information platform
CN105631745A (en) * 2015-12-31 2016-06-01 北京神州绿盟信息安全科技股份有限公司 Asset view construction method and device
CN105931114A (en) * 2016-04-18 2016-09-07 中国建设银行股份有限公司 Centralized monitoring and analysis method and system for multi-application transaction information logic paths of bank
CN106022908A (en) * 2016-05-17 2016-10-12 中国建设银行股份有限公司 Method and system for querying information of assets and liabilities
CN106209444A (en) * 2016-06-29 2016-12-07 浙江理工大学 A kind of IT assets synergic monitoring system based on unified view

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111538732A (en) * 2020-05-11 2020-08-14 甘肃省地质调查院 Natural resource asset liability management system based on big data

Similar Documents

Publication Publication Date Title
US20180158146A1 (en) Financial Operating Platform For Autonomous And Semi-Autonomous Cash Forecasting And Projecting Financial Results
US8065227B1 (en) Method and system for producing custom behavior scores for use in credit decisioning
TW200411455A (en) System and method for managing bad debts of account receivable
US20130073518A1 (en) Integrated transactional and data warehouse business intelligence analysis solution
US20210125272A1 (en) Using Inferred Attributes as an Insight into Banking Customer Behavior
Bataev Analysis of the application of big data technologies in the financial sphere
US11551230B2 (en) Security attack detections for transactions in electronic payment processing networks
CN111444248A (en) Method for checking and analyzing enterprise operation data
KR20170094935A (en) System for providing enterprise information and method
CN109299065A (en) Generate processing method, system and the storage medium of asset-liabilities unified view
CN102722810A (en) Small-scale payment system
CN111400272B (en) Dynamic cost allocation method and system thereof
CN109409650A (en) A kind of ERP management system of corporate resources
US9529860B2 (en) Keyword frequency analysis system
CN114049213A (en) Informatization financial data analysis system and analysis method
US20140278751A1 (en) System and method for identifying rapidly-growing business customers
CN112053217A (en) Financial valuation statement generation method and device
JP6121017B2 (en) Financial institution management support system and program
KR20200134816A (en) Product LifeCycle Management System
Karmańska Business Intelligence in consolidation of financial statements
Ruldeviyani et al. Design and implementation of merchant acquirer data warehouse at PT. XYZ
Minh et al. Designing a Data Warehouse Framework for Business Intelligence
JP6188849B2 (en) Financial institution management support system and program
Azretbergenova et al. Application of Big Data in the Banking Sector of Kazakhstan
US20140279305A1 (en) Operational reporting for financial systems

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

Application publication date: 20190201