Big Data fat Brother's Way (9)-The logical model of financial industry Data Warehouse FS-LDM

Introduced:

Big data is not a mirage, from small acorn just to fantasize about the development of big data, and to start from scratch, based on big data construction country, Project-level Data center industry will be more and more, big data for technology only, not solution, Pro Data organization mode, data logic mode problem.

Its stone can attack jade, this article on data Warehouse domain data logic model construction of the most prestigious FS-LDM to introduce, aimed at. I hope we can give you enlightenment. Participation and communication please Dabigatran:347018601

I. Overview

(1) What is LDM

The logical data Model LDM is the Data Warehouse model solution, which is defined in the data construction phase of data Warehouse to solve the business requirements, it is a blueprint to instruct the Data warehouse to store data, organize the data, and how to support the application, define the important entities, attributes and relationships that need to be traced and managed.

(2) Why LDM is required

The data organization mode which both the operational database and the data warehouse need;

LDM is the first step in building a DW. is to build the basic framework of BI and provide an important basis for the analysis of value data. Provides a blueprint for the specification and infrastructure for complex DW system implementations;

LDM facilitates effective communication between business units and it analysts. Form a unified understanding of important business definitions and terminology. Have a cross-sectoral, neutral characteristics. Can express all the business.

(3) What are the major LDM

Teradata FS-LDM (Financial services Logical Data Model): is a pre-built LDM. Using it to directly start the Data Warehouse model design, it is a mature product.

IBM has BDWM (Banking Data Warehouse Model);

Ii. FS-LDM Finance 11 Thematic models

1. Group party
Refers to the random objects that banks serve as a financial institution and the various objects that are interested in analyzing them. such as individuals, corporate customers, potential customers, agencies, partners, employees, branches, departments and so on. A group can be one of many of these roles at the same time.

The creation of a group theme enables analysis based on basic customer information. is an important foundation for the realization of a variety of customer-centric analytical applications.

2. Asset ASSET
Used to describe the assets of a narrative group, with assets subject to two main categories of assets. Customer assets and CCB's own assets. An asset can be owned by multiple groups. A group can be associated with multiple assets. Assets can be divided into physical assets, financial assets and intangible assets. The source of the customer's asset information is a lot of information about the collateral and collateral information, which is provided when the customer applies for the loan.

This topic is able to store all of the customer assets or CCB's own assets that can be obtained from the business system and be able to make deposits in real estate, inventory, motor vehicles and other financial institutions.

3. Geographical location
Geographic information stores whatever area you want to see and analyze. Contains both traditional types of address information (such as county, Street). Also contains information such as telephone, e-mail address and other electronic addresses.

4. Product Products
Product: Refers to a collection of marketing-traded symbols designed to expand the market share to meet the broader needs of the customer, which is the service that the financial institution sells to the user or provides to the customer.

The assumption that it is necessary to include the products provided by the competitor

5. Protocol Agreement
is a contractual relationship between a financial institution and a group that is executed against a particular product or service, and it can be diversified. Contracts such as accounts, customers, and banks. When an agreement is reached between the financial institution and the customer regarding the terms and conditions of a particular product or service. An agreement (agreement) will be opened, so the agreement is an important vehicle for client and bank dealings.

The subject of the agreement is related to a very large number of applications, such as: Calculation of exposures, ratings of different types of agreements, analysis of the gap in asset liabilities, customer and bank transactions (customer contributions, what products the customer buys, when to buy the product), etc.

6. Event Events
is a very broad-ranging concept that can record the specifics of various banking-related activities. Can be associated with money. can also be independent of money. Be able to have customer participation, and can not participate in the customer, can be related to the account, but also to account-independent, can be initiated by the customer. can also be initiated by banks. In short, it can record a wide range of activities related to the bank can record the specific circumstances, including transaction data, such as deposits, withdrawals, payments, the collection of credit card annual fees, calculation of interest and fees, complaints, query products, query address, query the remaining amount, online transactions.

7. Marketing Campaign CAMPAIGN
Marketing activity is a series of promotional events and corresponding strategies and planning activities of the Bank, which is carried out to obtain, maintain and enhance the relationship between the financial institution and the customer, which may be aimed at promoting certain products or establishing the market image.

8. Channel Channels
Channels are the means and methods by which banks interact and engage with their customers, through which they engage with the bank, purchase products, use services, and exchange information.

Channels generally include ATMs, branch counters, telephones, POS, call centers, television, radio, newspapers, networks, letters, etc.

9. Finance FINANCE
Mainly includes the bank's general ledger information, is describes the narrative subject organization, the control, the internal accounting and so on the bank core subject account and the budget management related content.

The topic is an abstract description of the organizational model of bank internal accounts. Can adapt to different subject organization system.

10. Application for Application
An application is a group that expresses its intention to establish a relationship with a bank. Such intentions are not sufficient to establish a relationship before a group (or applicant) satisfies the bank's acceptance criteria. This topic records information about the application submitted by a group to the bank, the status of the application, the history of group and application relationships, the history of application and asset relations, and the Bank's rating of the application.

11. Model
Stores information classes related to model details, including model details (model name, creation time, and so on), model metrics, and group, channel, and product scoring and segmentation. Models can be executed multiple times, and a model can have multiple relationships with one model. The model has multiple result values.

Three, model structure diagram (7.0 version number)

Iv. Programme of work

　　Big data is not a mirage, the big Data era brought about by the technology change and data storage technology to the traditional data warehouse brings challenges and opportunities, the construction of the Data Warehouse architecture of the Big Data era will start from the data logic model, the main idea is to participate in the traditional mode, do a good data warehouse system. Based on the model of industry application, the design and reconstruction of data logic model are carried out.

I hope there are a lot of other people. Many other industries are involved. Technology Exchange Group:347018601.

Copyright notice: This article blog original articles, blogs, without consent, may not be reproduced.

Big Data fat Brother's Way (9)-The logical model of financial industry Data Warehouse FS-LDM