| 基金管理投资研究系统数据清洗及质量控制 |
| |
| 引用本文： | 王立荣,郭强,付冉冉.基金管理投资研究系统数据清洗及质量控制[J].武汉理工大学学报(信息与管理工程版),2011(5):725-727,734. |
| |
| 作者姓名： | 王立荣 郭强 付冉冉 |
| |
| 作者单位： | 山东经济学院信息管理学院;山东经济学院会计学院; |
| |
| 基金项目： | 国家自然科学基金资助项目(60802030); 山东省中青年科学家科研奖励基金资助项目(BS2009DX0036) |
| |
| 摘 要： | 在充分分析基金管理公司估值系统、交易系统、外部资讯数据和用户需求的前提下,自主研发了一套适合基金管理公司业务需求的ETL(extract transform load)程序,将各相关业务系统和资讯系统的数据加载到数据仓库中,并开发了一套基于oracle的存储过程以实现数据的清洗和数据质量控制工作。通过在某基金管理公司投资研究系统的运用,证明该设计方式在满足业务需求并保证系统可扩展性的同时,能简化ETL程序开发的复杂度,提高系统的可维护性。其所使用的数据清洗和核对方式对银行、保险等金融机构类似应用的开发有较高的参考价值。
|
| 关 键 词： | 基金管理公司 估值系统 数据清洗 数据质量控制 ETL |
Cleaning and Quality Control of Data in Investment Research System of Fund Management |
| |
| WANG Lirong,GUO Qiang,FU Ranran :Postgraduate,School of Information Management,Sh,ong Economic University,Jinan ,China..Cleaning and Quality Control of Data in Investment Research System of Fund Management[J].Journal of Wuhan University of Technology(Information & Management Engineering),2011(5):725-727,734. |
| |
| Authors: | WANG Lirong GUO Qiang FU Ranran :Postgraduate School of Information Management Sh ong Economic University Jinan China |
| |
| Affiliation: | WANG Lirong,GUO Qiang,FU Ranran :Postgraduate,School of Information Management,Shandong Economic University,Jinan 250014,China. |
| |
| Abstract: | 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 qua... |
| |
| Keywords: | fund management company estimation system data cleaning data quality control ETL |
| 本文献已被 CNKI 等数据库收录！ |
|
