【作者】 李帅；

【导师】 毛华扬；

【作者基本信息】 重庆工学院 ， 会计学， 2007， 硕士

【摘要】 随着经济发展对会计信息化的新的需求,如何通过科学、有效的手段,对行业会计报表数据进行高效的收集与利用,以此来掌握企业的经营和管理现状,发现企业经营管理中存在的问题,预测企业未来的发展前景,已受到了社会各界的普遍关注。将报表技术和数据仓库技术结合起来,利用基于B/S构架的报表对会计报表数据进行收集,并将收集的数据构建入数据仓库,不仅可以将行业会计报表数据统一管理起来,还可以在此基础上进一步对报表数据进行OLAP(联机分析处理,On-line Analytical Processing)和DM(数据挖掘,Data Mining),从多角度、多侧面观察和分析数据,将是一种极佳的解决方案。本论文第一章提出问题,分析国内外发展、提出本课题主要研究内容以及所采用的研究方法、技术路线等。第二章对本论文涉及的主要理论问题如网络体系结构、软件层次结构、XBRL(可扩展商业报告语言,eXtensible Business Reporting Language)、及数据仓库等进行论述,为整个课题提供理论基础。第三章从管理的角度,对行业会计报表的组织构架设计、报表业务逻辑、XBRL导入导出、数据库设计等方面进行研究。设计一个行业通用的组织架构模型,将组织实体统一抽象为组织构架元素,而各元素之间的联系与元素本身分离开来,联系定义更加灵活。设计了一个的会计报表定义模型,采用报表格式、结构、与报表数据相互分离的思想,报表整体结构更加清晰,报表定义更加灵活,满足了行业内不同类型企业、报表格式跨年度变化对会计报表格式的复杂需求。将目前会计信息化领域较推崇的XBRL技术引入行业会计报表系统,提供XBRL实例文档的导入导出功能。第四章以数据仓库的建模为主线,从行业会计报表数据仓库的整体设计、模型设计及多维数据集的创建等方面进行研究,最终构建出行业会计报表数据仓库。引入雪花型模型对行业会计报表数据仓库模型进行设计,突破了大多数类似研究用星型模型局限性。采用多事实表设计,将行业会计报表和财务分析指标数据按主题构建入数据仓库,为后续研究可能对传统财务分析方法产生突破打下基础。采用多重粒度划分的策略,数据仓库的数据组织更加灵活。第五章是综合案例,根据第三章、第四章的设计,以一个典型的集团企业进行实现,包括行业会计报表的实现到数据仓库构建,编写程序代码两万余行。第六章进行总结,对本课题的前景进行展望。更多还原

【Abstract】 With the new demands of economic development for accounting informationization, it has already attracted the attentions of people in all circles that is how to through scientific and efficient means collect and use the Industrial Accounting Statement (IAS) data to control the operation and management situation of an enterprise, find the existing problems and predict the development of this enterprise.It will be an extremely wonderful solution that we combine the statements technology with the Data Warehousing (DW) technology, collect the IAS data by using the statements basing on the B/S framework and put the collected data into the DW. This can not only manage the IAS data but also make further research of these data and observe and analyze data from different dimensions and profiles.Chapter One: Put forward the problems, analyze the development at home and abroad and expound the tasks of this article.Chapter Two: Explain the principal rationales that serve as the theoretical bases of this article, such as: network structure, software hierarchy, XBRL, Data Warehousing and so on.Chapter Three: From the management perspective, study the framework design of IAS, the operational logic of the Accounting Statements (AS), the input and output of XBRL and the database design. Make out a universal organization structure model for one kind of industry, in which every organization entity becomes an abstract element of the organization framework. As the links among various elements are separate with every element, the definitions of connections among elements will be more flexible. In this chapter the author provides a model for the definition of AS form, in which the format and the structure of AS are separated with the data so that the whole structure of an AS becomes clearer and the definition becomes more flexible. All of these meets the complicated needs of different types of enterprises.Introduce the XBRL into the IAS system and provide examples of the XBRL input and output;Chapter Four: Take the DW modeling as the main line and research from the overall design of IAS, model design and the creation of the multi-dimensional data set, and eventually build the IAS DW. Design the model of the IAS DW by introducing the“Snowflake Form”model, which is a great breakthrough comparing with the traditional“Star Form”one. By using the multi-fact-table, absorb the IAS data and the Financial Analysis Index data according to the respective themes, which ground the foundation for the breakthroughs during the following research in traditional financial analysis methods. Adopting the multi-granularity division strategy makes the data organization of DW more flexible.Chapter Five: Case study. Take a typical industrial group as an example to realize the previous design, including the realization of the IAS to the DW construction and write the programmer codes about nearly 20,000 lines.Chapter Six: Summary. Make prospect of this article.更多还原