某烟草公司数据中心系统设计

发布时间：2019-01-12 17:49

【摘要】：近几年,随着计算机技术和网络技术的飞速发展,及在各行业的应用推广,数据业务的增长速度已经比以往任何一个年代都要快。这些数据的特点是杂乱、条块分割和非常多,通过正常的手段要从这些数据提取有用的信息非常困难。随着数据库技术的发展,出现了数据中心技术,这在某种程度上使从庞大的数据中提取对组织有用的信息成为可能。烟草商业企业大多都先后有了营销、财务、专卖和物流等业务管理系统,这些业务系统相对独立,数据标准也没有相对统一。各业务系统之间很难共享彼此的数据信息,造成了数据库重复建设且标准各不相同,工作效率低下,数据的利用率也有待提高,数据的分析功能也仅限于一些简单的分析,不能为企业决策提供全面的数据分析。为了提高某烟草公司在市场中的竞争力,有必要整合各业务管理系统,制定统一的数据标准,使各业务系统之间能共享数据,能为公司各管理阶层提供相对应的数据分析以供其决策之用。要实现这一目标,某烟草公司就必须建立公司数据中心。本文以某烟草公司为研究对象,首先简要的介绍了本文的研究背景及意义,并阐述了企业数据模型、操作型存储、企业数据仓库及OLAP和ETL技术,再对此烟草公司数据中心建设的目标及原则进行了定位,然后对数据中心的需求进行了详细地讨论。接着对数据中心的总体架构、数据架构和应用架构进行了分析。在数据中心的系统设计中,对系统的业务功能、信息资源标准和企业的数据仓库进行了设计,采用了ER图对实体进行分析,采用了多维数据模型对数据报表建模,最后阐述了此烟草公司数据中心的应用功能,如基本数据分析、卷烟销售营销分析、进销存和专卖内管等分析。本文的研究有利于某烟草公司重构企业数据环境,实现数据的集成和共享,有利于建立信息畅通渠道和为公司提供辅助决策。
[Abstract]:In recent years, with the rapid development of computer technology and network technology, as well as the application and promotion in various industries, the growth rate of data services has been faster than any previous era. The characteristics of these data are clutter, fragmentation and a lot of them. It is very difficult to extract useful information from these data by normal means. With the development of database technology, data center technology has emerged, which to some extent makes it possible to extract useful information from large data. Most of the tobacco commercial enterprises have business management systems such as marketing, finance, monopoly and logistics. These business systems are relatively independent, and the data standards are not relatively uniform. It is very difficult to share each other's data information among the business systems, which results in the repeated construction of the database and the different standards, the low efficiency of work, the need to improve the utilization rate of the data, and the analysis function of the data is limited to some simple analysis. Can not provide comprehensive data analysis for enterprise decision-making. In order to improve the competitiveness of a tobacco company in the market, it is necessary to integrate various business management systems and develop uniform data standards so that data can be shared among business systems. Can provide the corresponding data analysis for the management of the company for its decision-making. To achieve this, a tobacco company must set up a corporate data center. In this paper, a tobacco company is taken as the research object. Firstly, the research background and significance of this paper are briefly introduced, and the enterprise data model, operational storage, enterprise data warehouse, OLAP and ETL technology are described. The aim and principle of the construction of the data center of tobacco company are defined, and the demand of the data center is discussed in detail. Then, the overall architecture, data architecture and application architecture of the data center are analyzed. In the system design of the data center, the business function of the system, the information resource standard and the data warehouse of the enterprise are designed. The entity is analyzed by ER diagram, and the data report is modeled by the multidimensional data model. Finally, the application functions of the data center of the tobacco company are described, such as basic data analysis, cigarette sales and marketing analysis, purchase, storage and exclusive management, etc. The research in this paper is helpful for a tobacco company to reconstruct the enterprise data environment, realize the data integration and share, establish the information unblocked channel and provide the assistant decision for the company.
【学位授予单位】：江西财经大学
【学位级别】：硕士
【学位授予年份】：2016
【分类号】：TP311.52

【相似文献】