联机在个人财务数据库方面的和应用_new教程.doc

J I A N G S U U N I V E R S I T Y 本 科 毕 业 论 文 联机分析在个人财务数据库方面的分析和应用 Analysis and Application of OLAP in Personal Financial Database 专业名称： 计算机科学与技术 班 级： 02级本科（3）班 学生姓名： 徐 昌 吉 指导教师姓名： 王月敏 朱玉全 指导教师职称： 2006年4月 联机分析在个人财务数据库方面的分析和应用 专业班级：计算机（3）班 学生姓名：徐昌吉 指导教师：王月敏 朱玉全 职称：系主任 教授 摘要 联机事务处理(OLTP)系统已被广泛用于处理企业的日常业务如果加以保留随着时间的推移OLTP系统可以累积大量的历史数据有效组织和存储这类海量历史数据提供分析和决策支持能力成为数据仓库、联机分析处理(OLAP)的任务本文首先讨论了OLAP的概念和特点、数据仓库的设计方法和存储结构、数据清理技术并以为背景实际设计和建立了数据仓库在设计上数据仓库以为度量以、、为主要的维建立数据立方体采用了流行的星形结构实现平台采用了SQL Server2000数据库管理系统数据清理采用了手工、SQL命令、程序相结合的方式从数据库到数据仓库的数据加载使用了数据转换服务DTS基于数据仓库的OLAP使用了Analysis and Application of OLAP in Personal Financial Database Abstract: OLTP systems have been widely used in the daily operations of processing enterprises. If it was retained, with the passage of time, OLTP system can accumulate considerable amount of historical data. To effectively organize, store such historical data to provide analysis and decision support capabilities is the main mission to a data warehouse and OLAP.  This paper first discussed the concept and features of OLAP, data warehouse design methods and storage structures and data clean-up technologies. Then take the consumption of a person in 2004 as a background to design and build a personal financial data warehouse. It can answer the certain questions through the OLAP or by the system implementation such as the following questions: Every person has his own consumption everyday, but very few people are concerning whether their own consumption is scientific and rational, and doubts always arose at the end of the mouth. How I spend my money? Is this consumption scientific and rational?  In the design, personal financial data warehouse, which is introduced by the star shape structure, take the price and quantity for measurement; take the date, temperature layers and the main venue distribution for the data c