Introduction to OSFA and data warehousing in Oracle

Oracle Financial Services Application (OFSA) technology platform: includes Oracle Warehouse Builder Data Warehouse build tools, oracle8i database, Oracle Express multidimensional database, Common Warehouse metadata General Data Warehouse metadata management tools, Oracle Internet Develop suites business Intelligence Toolset (queries, reports, multidimensional Analysis, data mining), Oracle The Data Mart Suites Database Mart Suite.

China's banking industry in the development process, has gradually accumulated a large number of customer data and business data. How to use these data and discover valuable information is of common concern to the Chinese banking industry today. The key to solve the problem is to establish the bank's enterprise-class data warehouse, to realize the effective storage of all business information and customer information, and to carry out multi-level data processing to meet the needs of bank management decision and customer analysis according to the management decision needs of different departments of banks.

Oracle, as a world renowned database manufacturer, has been committed to providing a data warehouse solution to meet the competitive needs of enterprises. Oracle's data warehousing solutions include database platforms, development tools, and application systems. Oracle data warehouses enable organizations to access information stored in different locations in a variety of ways to meet the needs of information retrieval and business decisions at many levels of the enterprise.

The Oracle Data Warehouse solution consists of the following sections:

1. Technology Platform

Includes Oracle Warehouse Builder Data Warehouse builder, oracle8i database, Oracle Express multidimensional database, Common Warehouse metadata Universal Data Warehouse Metadata management tool, Oracle Internet Develop suites Business Intelligence Toolset (queries, reports, multidimensional Analysis, data mining), Oracle data Mart suites.

2. Market development Analysis and application

Includes Oracle CRM Customer Relationship management system and Oracle Sales Analyzer Marketing Analysis System.

3. Enterprise Operation analysis and application

Includes 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 Oracle Business Information System enterprise business intelligence applications and Oracle Balanced Scorecard Balanced Scorecard application system.

5. Expert Services

Includes Oracle Consulting Data Warehouse Implementation Consulting services.

6. Customer-centric partnerships

Includes data Warehouse Technology drive plan, System Integrator Drive plan and data Warehouse platform Market drive plan.

Oracle data warehouses contain a complete set of products and services that cover the entire process of data warehouse definition, design, and implementation.

At the same time, Oracle provides a sound strategic enterprise management and decision support System (Oracle Financial Services application) for the special needs of the financial industry Data Warehouse. Oracle's decision Support application Suite (OFSA), which specializes in strategic management of the financial industry, is the crystallization of Oracle's years of experience in many large international banks, such as Citibank, to provide banks with strong asset and liability management, profit cost analysis, risk forecasting and control, Interest rate sensitivity analysis and customer analysis, such as ready-made application components, and more importantly, it reflects the international big banks advanced business management ideas and scientific auxiliary analysis methods, the development of banks in the future to the international wholesale banking standards to develop and maintain international competitiveness is greatly helpful.