中國人壽it戰(zhàn)略規(guī)劃項目數(shù)據(jù)架構(gòu)規(guī)劃(文件)
【正文】 ensing/Registration Expense Payment Investment Liabilities Distributor Main Entities and their relationships 16 Data Architecture Logical Model ? Information: ? Identifiers ( name, ID...) ? Basic Information( address, telephone number…) ? Type ( Corp, person…) ? Demographics ( age, nationality, marriage status…) ? Contact history … ? Relationship to: ? Contract( . owner, payer, benefit….) ? Agent (Primary…) ? Other customers (spouse, child, business rep, etc) … Customer Individual or corporate entities who own or is associated with contracts 17 Data Architecture Logical Model ? Information: ? Benefit Information (sum insured, type of benefit…) ? Supplementary benefit information ? Product type ? Payment information (mode, premium, account…) ? Status (inforce, lapsed…) ? Transaction history ? Claim information… ? Relationship to: ? Customer ? Payment ? Claim ? Distributor Contracts ? Product/Plan ? Commission ? Reinsurance 18 Data Architecture Logical Model ? Information: ? Identifier Information ? Type of distributor (. agent, bank, broker…) ? Demographics ? Registration information amp。 Head Office Transaction data in a normalized relational format replicated from OLTP sources using an Extract, Transform and Load (ETL) process. Ambiguities are resolved and data hygiene applied during migration. Data Warehouse Optional Group amp。s data resources and provide information about the structure of the source data feeds, data extraction, integration and transformation rules, data quality assurance processes, and database structures, including business terms, definitions and business rules. Main Components 27 Data Architecture – Data Tools Component Description Options RDBMS A program that lets you create, update, and administer a relational database Oracle, DB2 Query tools applications that provide basic language constructs for defining and manipulating tables of data RDBMS’s have their own tools (DB2, Oracle, etc.), TOAD, SQL Studio, Web SQL Studio etc ETL A configurable application for Extracting data from data sources, Transforming (Cleansing, Standardizing etc.) data, if applicable, and Loading it into the target data store Ascential, Informatica, Data Junction, Data Mirror etc OLAP Tools OLAP primarily involves aggregating large amounts of diverse data. OLAP can involve millions of data items with plex relationships. Its objective is to analyse these relationships and look for patterns, trends, and exceptions Oracle, Visual SQL Designer, Hyperion, BRIO, Crystal, Business Objects, Microstrategy, Essbase, Informatica etc Data Tools 28 Burning Timeline ? December 2020: No vendor support of Informix after then DBMS evaluation criteria ? Performance ? Cost ? Compatibility ? Management ? Skilled resource availability Timing relative to system replacements / upgrades ? Migration from Informix will require at least some data cleansing activities ? Migration from Informix to the new platform should be performed in conjunction with the migration to new applications. Data Architecture – DBMS Migration Consider
教學課件相關(guān)推薦
鄂ICP備17016276號-1