Introduction to OSFA and data warehouse in Oracle

Oracle Financial Services Application (OFSA) technical platform: includes Oracle Warehouse Builder Data Warehouse building tool, Oracle8i Database, Oracle Express multi-dimensional database, Common Warehouse Metadata Common Data Warehouse Metadata management tool, Oracle Internet Develop Suites business intelligence tool set (query, report, multi-dimensional analysis and data mining) and Oracle Data Mart Suites.

China's banking industry has gradually accumulated a large amount of customer data and business data during its development. How to use this data to discover valuable information is of widespread concern to China's banking industry today. The key to solving the problem is to establish an enterprise-level data warehouse for banks to effectively store all banking business information and customer information, and to meet the management and decision-making needs of different banking departments, multi-level data processing to meet the needs of bank management decision-making and customer analysis.

As a world-renowned database manufacturer, Oracle has been committed to providing enterprises with Data Warehouse solutions to meet their competitive needs. Oracle's data warehouse solution includes the database platform, development tools, and application systems. Oracle Data Warehouse can help enterprises access information stored in different locations in multiple ways, so as to meet the needs of information retrieval and business decision-making at many levels of the enterprise.

The Oracle Data warehouse solution consists of the following parts:

1. Technical Platform

Includes Oracle Warehouse Builder Data Warehouse building tool, Oracle8i Database, Oracle Express multi-dimensional database, Common Warehouse Metadata Common Data Warehouse Metadata management tool, Oracle Internet Develop Suites business intelligence tool set (query, report, multi-dimensional analysis and data mining) and Oracle Data Mart Suites.

2. Application of Market Development Analysis

Includes the Oracle CRM Customer Relationship Management System and Oracle Sales Analyzer Sales analysis system.

3. Enterprise Operation Analysis and Application

Including Oracle Financial Services Application (OFSA) Financial Industry Strategic management and decision support Application system, Oracle Financial Analyzer Financial analysis system.

4. Business Intelligence applications

Includes the Oracle Business Information System Enterprise Business Intelligence Application System and Oracle Balanced ScoreCard integrated Balanced ScoreCard application System.

5. Expert Services

Includes the Oracle Consulting data warehouse implementation Consulting service.

6. customer-centric partnership

Including Data Warehouse Technology Promotion Plan, system integrator Promotion Plan, and data warehouse platform market promotion plan.

Oracle Data Warehouse contains a complete set of products and services, covering the entire process of data warehouse definition, design and implementation.

At the same time, Oracle provides a comprehensive strategic enterprise management and decision support system (Oracle Financial Services Application) to address the special needs of data warehouses in the Financial industry ). Oracle's Decision Support Application Suite (OFSA) for strategic management in the financial industry is the result of Oracle's years of practical experience in many major international banks (such as Citibank, it not only provides banks with powerful asset and liability management, profit cost analysis, risk prediction and control, interest rate sensitivity analysis, customer analysis, and other ready-made application components, but more importantly, it reflects the advanced business management ideas and scientific Auxiliary Analysis Methods of major international banks, which will be of great help to the development banks in the future to develop standards for international wholesale banks and maintain international competitiveness.