基于oracle数据仓库的BI数据展示平台的设计与实现
发布时间：2018-12-10 17:17
【摘要】：近几年随着物流成本的降低,网上购物的人数迅速增加,电子商务行业快速发展。人们开始重视持续性发展,对决策的制定有了更高的要求,要求有更合理有效的数据支持,这就需要对大量的销售数据进行分析。数据仓库就是在这样的大环境下出现并且得到快速发展。使用数据仓库,如何对数据分析,分析到如何程度的BI(Business Intelligence)系统,对企业的作用至关重要。BI系统可以帮助企业建立一个清晰、准确的决策支持系统,可以实现真正意义上的商务智能,而且利用存储的公司日常运营所产生的销售数据、采购数据、仓库库存等内容,帮助公司实现更有效的资源配备和渠道管理。本系统首先使用ETL工具Kettle从各种数据源(如多个服务器上的MySQL数据库、SQL Server数据库、各种excel表格)抽取数据聚合到一个Oracle数据库里,然后在Oracle中将数据按照粒度层级不同整合到CDC层、ODS层和DW层。在这三层之间通过调动存储过程来转化,对于不同的需求定制不同的存储过程定时调用,将数据写到结果表中,供前端数据展示模块调用。平台展示模块使用兼容性较好的B/S架构,网站使用PHP语言进行开发,页面数据展示使用ExtJS。前端页面能够动态变化,以多种样式展示数据,包括折线图、饼状图和柱状图等等,并且能够对某一特定数据在不同时间的数值进行对比展示。经过严格的测试表明,该系统提供的数据仓库设计合理,能够让业务和管理人员和方便的获取想要的数据,可以极大地提高公司管理层的工作效率,具有较好的用户体验,为企业提供了较好的决策支持,具有良好的使用价值。
[Abstract]:In recent years, with the decrease of logistics cost, the number of online shopping has increased rapidly, and the e-commerce industry has developed rapidly. People begin to pay more attention to sustainable development, have higher requirements for decision-making, and demand more reasonable and effective data support, which requires the analysis of a large number of sales data. Data warehouse is in this kind of big environment appearance and get rapid development. Using the data warehouse, how to analyze the data, how to analyze the degree of BI (Business Intelligence) system is very important to the enterprise. BI system can help the enterprise to establish a clear and accurate decision support system. It can realize real business intelligence, and make use of the sales data, purchasing data, warehouse inventory and so on, which can help the company achieve more effective resource allocation and channel management. This system first uses the ETL tool Kettle to extract data from various data sources (such as MySQL database, SQL Server database on multiple servers, various excel tables) and aggregates the data into a Oracle database. Then the data is integrated into CDC layer, ODS layer and DW layer according to granularity level in Oracle. Through transferring the stored procedure between the three layers, different stored procedure timing calls are customized for different requirements, and the data is written to the result table for the front-end data display module to call. The platform display module uses the compatible B / S architecture, the website uses PHP language to develop, and the page data display uses ExtJS.. The front page can change dynamically, displaying data in a variety of styles, including line, pie, bar, and so on, and can compare the values of a particular data at different times. The strict test shows that the data warehouse provided by the system is reasonably designed, and can make the business and management personnel and convenient access to the desired data, can greatly improve the efficiency of the company's management, and has a better user experience. For the enterprise to provide better decision support, has good use value.
【学位授予单位】：北京工业大学
【学位级别】：硕士
【学位授予年份】：2015
【分类号】：TP311.13
本文编号：2370938
[Abstract]:In recent years, with the decrease of logistics cost, the number of online shopping has increased rapidly, and the e-commerce industry has developed rapidly. People begin to pay more attention to sustainable development, have higher requirements for decision-making, and demand more reasonable and effective data support, which requires the analysis of a large number of sales data. Data warehouse is in this kind of big environment appearance and get rapid development. Using the data warehouse, how to analyze the data, how to analyze the degree of BI (Business Intelligence) system is very important to the enterprise. BI system can help the enterprise to establish a clear and accurate decision support system. It can realize real business intelligence, and make use of the sales data, purchasing data, warehouse inventory and so on, which can help the company achieve more effective resource allocation and channel management. This system first uses the ETL tool Kettle to extract data from various data sources (such as MySQL database, SQL Server database on multiple servers, various excel tables) and aggregates the data into a Oracle database. Then the data is integrated into CDC layer, ODS layer and DW layer according to granularity level in Oracle. Through transferring the stored procedure between the three layers, different stored procedure timing calls are customized for different requirements, and the data is written to the result table for the front-end data display module to call. The platform display module uses the compatible B / S architecture, the website uses PHP language to develop, and the page data display uses ExtJS.. The front page can change dynamically, displaying data in a variety of styles, including line, pie, bar, and so on, and can compare the values of a particular data at different times. The strict test shows that the data warehouse provided by the system is reasonably designed, and can make the business and management personnel and convenient access to the desired data, can greatly improve the efficiency of the company's management, and has a better user experience. For the enterprise to provide better decision support, has good use value.
【学位授予单位】：北京工业大学
【学位级别】：硕士
【学位授予年份】：2015
【分类号】：TP311.13
【参考文献】
相关期刊论文 前1条
1 刘志超;陈勇;姚志立;;大数据时代的电子商务服务模式革新[J];科技管理研究;2014年01期
，本文编号：2370938
本文链接：https://www.wllwen.com/guanlilunwen/wuliuguanlilunwen/2370938.html
