摘要
在充分分析基金管理公司估值系统、交易系统、外部资讯数据和用户需求的前提下,自主研发了一套适合基金管理公司业务需求的ETL(extract transform load)程序,将各相关业务系统和资讯系统的数据加载到数据仓库中,并开发了一套基于oracle的存储过程以实现数据的清洗和数据质量控制工作。通过在某基金管理公司投资研究系统的运用,证明该设计方式在满足业务需求并保证系统可扩展性的同时,能简化ETL程序开发的复杂度,提高系统的可维护性。其所使用的数据清洗和核对方式对银行、保险等金融机构类似应用的开发有较高的参考价值。
A system of cleaning and quality control of data in investment research system was built after investigating the estimation system,trade agent system,external information data of fund management company and analysis of the requirements of users.The system consists of an ETL program,and other products such as oracle,oracle stored procedures.Data of related business system and information system were uploaded to data warehouse.An oracle-based storing process was developed to realize data cleaning and data quality control.This design approach can meet business requirements,ensure system scalability,simplify the complexity of the development of ETL program and improve the maintainability of the system.The used approach has a high reference value for design and develop the application systems in financial institutions such as banks and insurance agents.
出处
《武汉理工大学学报（信息与管理工程版）》
CAS
2011年第5期725-727,734,共4页
Journal of Wuhan University of Technology：Information & Management Engineering
基金
国家自然科学基金资助项目(60802030)
山东省中青年科学家科研奖励基金资助项目(BS2009DX0036)
