基于数据仓库的税务风险预警系统设计与实现
摘要
近年来,国家税务部门为了不断适应税务管理新形势的要求,逐步开始采用事前预警机制来加强税务风险防范,减少偷骗税对社会经济发展的影响。为了实现税务风险预警机制,建立风险预警信息系统是十分必要的。
本文课题运用数据仓库、OLAP(联机分析处理)多种技术方法开发与实现税务风险预警系统,其主要任务为:一、建立地市级的业务数据仓库,把目前各个应用系统中的异构信息资源进行整合和重新规划,建立综合征管、防伪税控、稽核系统、出口退税、海关票据等信息系统的数据共享平台;二、在已建立的数据仓库基础之上,面向不同的业务主题,建立业务及征管信息分析应用,从而得到有价值的税务预警信息,为国家税务部门提供有效的分析决策和支持。此系统有着广泛的应用领域,在电信、烟草、电力和其它大中型企业中有很好的开发借鉴价值。
本文介绍了税务风险预警系统的设计与实现过程,详细阐述了课题涉及的软件开发技术,对税务仓库平台进行了设计,给出了系统实现方案。本文最后还展示了基于数据仓库的税务风险预警系统实现结果,并提出课题的下一步工作方向。
In recently years, in order to continually adapt demands of new situation of tax administration, the national tax department adopts the tax prevising system to strengthen risk prevention type administration to decrease infection to social economic development by tax dodging. In order to realize the tax prevising system, it is necessarily to set up information system of the tax prevising system.
The paper applies Data Warehouse, OLAP (on-line analytical processing), methods and techniques to develop and realize the tax prevising system. Main tasks are as followings: 1. setting up area and city grade business data warehouse, conforming and reforming the different configuration information resource in each application system to set up a uniform data platform including the China tax administer information system, the Golden tax audit system, the tax reimbursement for export and customs bills. 2. based on the data warehouse been set up, facing different business theme, setting up information analyzing and applying system of business and imposing and administration to acquire valuable tax prevising information to supply effective analyze, decision and support for national tax department. The system has broad application area and development and reference value in the telecommunication, tobacco, electric power etc industry and other large and middle scale enterprises.
The paper introduces designing and realizing process of the tax prevising system, elaborating software development technique concerning the theme, designing tax data warehouse platform, giving realization scheme. In the end, the paper displays the realization result of the tax prevising system based on data warehouse and put forward next working direction of the theme.
本文课题运用数据仓库、OLAP(联机分析处理)多种技术方法开发与实现税务风险预警系统,其主要任务为:一、建立地市级的业务数据仓库,把目前各个应用系统中的异构信息资源进行整合和重新规划,建立综合征管、防伪税控、稽核系统、出口退税、海关票据等信息系统的数据共享平台;二、在已建立的数据仓库基础之上,面向不同的业务主题,建立业务及征管信息分析应用,从而得到有价值的税务预警信息,为国家税务部门提供有效的分析决策和支持。此系统有着广泛的应用领域,在电信、烟草、电力和其它大中型企业中有很好的开发借鉴价值。
本文介绍了税务风险预警系统的设计与实现过程,详细阐述了课题涉及的软件开发技术,对税务仓库平台进行了设计,给出了系统实现方案。本文最后还展示了基于数据仓库的税务风险预警系统实现结果,并提出课题的下一步工作方向。
In recently years, in order to continually adapt demands of new situation of tax administration, the national tax department adopts the tax prevising system to strengthen risk prevention type administration to decrease infection to social economic development by tax dodging. In order to realize the tax prevising system, it is necessarily to set up information system of the tax prevising system.
The paper applies Data Warehouse, OLAP (on-line analytical processing), methods and techniques to develop and realize the tax prevising system. Main tasks are as followings: 1. setting up area and city grade business data warehouse, conforming and reforming the different configuration information resource in each application system to set up a uniform data platform including the China tax administer information system, the Golden tax audit system, the tax reimbursement for export and customs bills. 2. based on the data warehouse been set up, facing different business theme, setting up information analyzing and applying system of business and imposing and administration to acquire valuable tax prevising information to supply effective analyze, decision and support for national tax department. The system has broad application area and development and reference value in the telecommunication, tobacco, electric power etc industry and other large and middle scale enterprises.
The paper introduces designing and realizing process of the tax prevising system, elaborating software development technique concerning the theme, designing tax data warehouse platform, giving realization scheme. In the end, the paper displays the realization result of the tax prevising system based on data warehouse and put forward next working direction of the theme.
引文
[ 1 ] Jiawei Han,Micheline Kamber.数据挖掘概念与技术。机械工业出版社,1999
[ 2 ] J .Kleinberg , C.Papadimitriou , and P.Raghavan . Segmentation problems .Proceedings of the 30tb Annual Symposium on Theory of Computing , ACM . 1998
[ 3 ]谢榕.基于数据仓库的信息系统框架[J] .系统工程理论与实践,2000 , 12 ( 6 ) : 29-30
[ 4 ] [美]Mehmed Kantardzic.数据挖掘--概念模型、方法和算法.清华大学出版社,1995
[ 5 ]谢榕.基于数据仓库的信息系统框架.计算机与通信,2000
[ 6 ]李子木.计算机与通信.清华大学出版社,1998,9 ( 12 ) : 12 -13
[ 7 ]张斟芳.数据仓库技术在仓库管理信息系统中的应用.机械工业出版社,2000
[ 8 ] R . Agrawal . Information Discovery , Inc . OLAP and DataMining , Bridging the Gap,1998
[ 9 ]滕佳东.企业信息管理与数据仓库[ J ] .中国信息导报, 1999,23 ( 11 ) : 10 - 12
[ 10 ]李贺、王平.基于数据仓库的信息系统结构分析[J ] .情报学报,2000 , 36( 5 ) : 29- 30
[ 11 ]陈文伟、黄金才数据挖掘技术。北京工业大学出版社,1998
[ 12 ] Chuang Tatao . Decision SupPOrt Systems , 1998, 24 ( 11 ) : 27-28
[ 13 ] R . Agrawal , T . lmielinski , and A . Swami.Mining association rules between sets of items in large databases . Proceedings of the ACM SIGMOD Conference on Management of data , pp . 207 -216
[ 14 ]曹增强(译).数据仓库技术.电子工业出版社,1998
[ 15 ]夏火松主编.数据仓库与数据挖掘技术.科学出版社,2004.3
[ 16 ]陈京民等著。数据仓库与数据挖掘技术。电子工业出版社,2002.8
[ 17 ]王仲谋(译).数据仓库.客户/服务器计算指南.电子工业出版社,1997
[ 18 ] Chuang Tatao . Decision SupPOrt Systems , 1998,24 ( 10 ) : 25- 26
[ 19 ]李子森.Internet/Intranet技术及发展趋势[J ] .计算机与通信, 8 ( 11 ) : 15 -16
[ 20 ] Tom Hammergren .数据仓库技术[M ] .中国水利水电出版社,2000 , 9
[ 21 ]高凯,朱金钧。浅谈数据仓库的在线分析方法。计算机工程与应用,2003,12:202-205
[ 22 ]李静、陆菊康、汤艳艳等。基于数据仓库的销售分析系统的设计与实现。计算机工程,May 2003 Vol.29 No7:173-175
[ 23 ]张春阳、周继恩等.基于数据仓库的信息系统的构建[J] .计算机工程,2002 , 16 ( 8 ) : 9 -l0
[ 24 ]谢榕.基于数据仓库的信息系统框架[J] .系统工程理论与实践,2000 , 12 ( 6 ) : 29-30
[ 25 ]俞文彬、谢康林.基于数据仓库的信息系统框架研究[ J ] .上海交通人学学报,2000,34 ( 6 ) : 10 -12
[ 26 ]林萍、蒋波.关于数据仓库中联机分析处理的几点研究. Computer era,No.1 2002:6-8
[ 27 ]张艳肖,周大镯.联机分析处理在商业企业应用的探讨.商业研究,2003/09:151-153
[ 28 ]刘明言、张晓京等.软件技术研究与实现,电子工业出版社,2000
[ 29 ]涂杰黄志明.基于数据仓库的税务地理信息系统构建.微型电脑应用,1999,16(9):25-27
[ 30 ] [美]Tony Bain等著,邵勇译. SQL Server 2000数据仓库与Analysis Services。中国电力出版社,2003.3
[ 2 ] J .Kleinberg , C.Papadimitriou , and P.Raghavan . Segmentation problems .Proceedings of the 30tb Annual Symposium on Theory of Computing , ACM . 1998
[ 3 ]谢榕.基于数据仓库的信息系统框架[J] .系统工程理论与实践,2000 , 12 ( 6 ) : 29-30
[ 4 ] [美]Mehmed Kantardzic.数据挖掘--概念模型、方法和算法.清华大学出版社,1995
[ 5 ]谢榕.基于数据仓库的信息系统框架.计算机与通信,2000
[ 6 ]李子木.计算机与通信.清华大学出版社,1998,9 ( 12 ) : 12 -13
[ 7 ]张斟芳.数据仓库技术在仓库管理信息系统中的应用.机械工业出版社,2000
[ 8 ] R . Agrawal . Information Discovery , Inc . OLAP and DataMining , Bridging the Gap,1998
[ 9 ]滕佳东.企业信息管理与数据仓库[ J ] .中国信息导报, 1999,23 ( 11 ) : 10 - 12
[ 10 ]李贺、王平.基于数据仓库的信息系统结构分析[J ] .情报学报,2000 , 36( 5 ) : 29- 30
[ 11 ]陈文伟、黄金才数据挖掘技术。北京工业大学出版社,1998
[ 12 ] Chuang Tatao . Decision SupPOrt Systems , 1998, 24 ( 11 ) : 27-28
[ 13 ] R . Agrawal , T . lmielinski , and A . Swami.Mining association rules between sets of items in large databases . Proceedings of the ACM SIGMOD Conference on Management of data , pp . 207 -216
[ 14 ]曹增强(译).数据仓库技术.电子工业出版社,1998
[ 15 ]夏火松主编.数据仓库与数据挖掘技术.科学出版社,2004.3
[ 16 ]陈京民等著。数据仓库与数据挖掘技术。电子工业出版社,2002.8
[ 17 ]王仲谋(译).数据仓库.客户/服务器计算指南.电子工业出版社,1997
[ 18 ] Chuang Tatao . Decision SupPOrt Systems , 1998,24 ( 10 ) : 25- 26
[ 19 ]李子森.Internet/Intranet技术及发展趋势[J ] .计算机与通信, 8 ( 11 ) : 15 -16
[ 20 ] Tom Hammergren .数据仓库技术[M ] .中国水利水电出版社,2000 , 9
[ 21 ]高凯,朱金钧。浅谈数据仓库的在线分析方法。计算机工程与应用,2003,12:202-205
[ 22 ]李静、陆菊康、汤艳艳等。基于数据仓库的销售分析系统的设计与实现。计算机工程,May 2003 Vol.29 No7:173-175
[ 23 ]张春阳、周继恩等.基于数据仓库的信息系统的构建[J] .计算机工程,2002 , 16 ( 8 ) : 9 -l0
[ 24 ]谢榕.基于数据仓库的信息系统框架[J] .系统工程理论与实践,2000 , 12 ( 6 ) : 29-30
[ 25 ]俞文彬、谢康林.基于数据仓库的信息系统框架研究[ J ] .上海交通人学学报,2000,34 ( 6 ) : 10 -12
[ 26 ]林萍、蒋波.关于数据仓库中联机分析处理的几点研究. Computer era,No.1 2002:6-8
[ 27 ]张艳肖,周大镯.联机分析处理在商业企业应用的探讨.商业研究,2003/09:151-153
[ 28 ]刘明言、张晓京等.软件技术研究与实现,电子工业出版社,2000
[ 29 ]涂杰黄志明.基于数据仓库的税务地理信息系统构建.微型电脑应用,1999,16(9):25-27
[ 30 ] [美]Tony Bain等著,邵勇译. SQL Server 2000数据仓库与Analysis Services。中国电力出版社,2003.3