臺灣博碩士論文加值系統

建全的企業營運在業績成長及長期經營之下，系統資料量越來越大，以及面對資料探勘技術與敏捷式決策系統開發方法的發展，如何從原有的線上運作系統調整為敏捷式的軟體系統，已成為目前企業重要的議題。
本論文提出以DevOps（Development and Operations）模型開發商業智慧系統，具有下列的特性：以WebUI動態建置自訂模組、動態OLAP資料預處理、模組化的DevOps。實驗結果顯示，本系統比原有的線上運作系統，在系統查詢效能方面提升約4.56倍；在系統橫向擴展(Scale out) 方面，可以降低資料庫伺服器的負載，以及彈性擴增應用層的服務承載量。

Over many years of business operations and expansions, a company may accumulate huge amount of data in its legacy information systems. Those legacy systems are usually not flexible to adopt new technologies such as data mining and agile decision support systems. It is thus an important issue for companies to transform operational information systems to agile information systems.
In this thesis, we design and develop business intelligence system based on DevOps (Development and Operations) model. The proposed system has the following modules: WebUI-based Dynamic User-Defined Module, Preprocessing Module for Online Analytic Processing, and DevOps Module. The experimental results show that the proposed system has 4.56 speedup in query performance, and it also has merits in terms of reducing database server workload and scale-out capability.

誌謝 i
摘要 ii
Abstract iii
目錄 iv
表目錄 vi
圖目錄 vii
第1章 緒論 1
1.1 研究背景及動機 1
1.2 研究目的 2
1.3 主要貢獻 2
1.4 論文架構 5
第2章 相關研究 6
2.1 DevOps開發維運 6
2.2 商業智慧模型 8
2.3 線上分析處理 9
2.3.1 Cube的資料結構 9
2.3.2 鑽研的報表設計 11
2.4 資料定義語言運用 13
2.4.1 資源描述架構 13
2.4.2 結構化查詢語言 14
第3章 系統架構與方法 15
3.1 系統架構 15
3.2 WebUI操作處理模組 16
3.3 定義應用資料模組 19
3.4 資料預處理模組 20
3.5 DevOps處理模組 21
3.5.1 資料橫向擴展Scale-Out 21
3.5.2 數據定義-後端建制 22
3.5.3 數據定義-自定函數 23
3.5.4 應用程序各MVC組件 25
3.5.5 應用執行的資料匯集 26
3.6 交付顯示輸出 27
3.6.1 商業報表相連 27
3.6.2 商業活動區域 28
第4章 系統實作與實驗結果 29
4.1 開發工具與實驗環境 29
4.2 測試結果 30
4.2.1 回應次數 30
4.2.2 負載狀況 32
4.2.3 回應時間 34
4.3 系統實作驗証 35
第5章 結論與未來研究方向 36
5.1 結論 36
5.2 未來研究方向 37
參考文獻 38

[1]Peter Purcell &Allen Bernard &Bask lyer &Client Boulton, 2017年7月,<雙模式 IT:邁向敏捷之路的墊腳石>, 台北市,CIO IT經理人
[2]Amazon ,”What is DevOps”, [Online]
https://aws.amazon.com/devops/what-is-devops/?nc1=f_ls (Accessed:June 2017)
[3]耐特普羅資訊, 「商業智慧 (Business Intelligence) 簡介」, [Online].http://www.netpro.com.tw/?FID=23&CID=158&category=1 (Accessed:June 2017)
[4]Jack,「企業資料倉儲DWH」, [Online].
http://blog.xuite.net/jack101257/twblog/138494904-企業資料倉儲DWH簡介 (Accessed:June 2017)
[5]jb51.net,「DDL、DML和DCL的區別與理解」, [Online].
http://www.jb51.net/article/40359.htm (Accessed:June 2017)
[6]王梅玲,「資源描述架構/資源描述綱要」, [Online].http://techserviceslibrary.blogspot.tw/2011/04/rdf-resource-description.html (Accessed:June 2017)
[7]施曉貞,<植基於MapReduce的可延展性XML索引方法>,國立中興大學 資訊科學與工程學系碩士論文,2014
[8]trifork.com,” INTRODUCTION TO HADOOP”, [Online]. http://blog.trifork.com/2009/08/04/introduction-to-hadoop/ (Accessed:June 2017)
[9]phpini.com ,「Load Average 負載解讀」,[Online].https://www.phpini.com/linux/linux-load-average (Accessed:June 2017)
[10]Microsoft ,”What is Power BI”, [Online].
https://powerbi.microsoft.com/en-us/what-is-power-bi/ (Accessed:June 2017)
[11]Microsoft ,” Drillthrough, Drilldown, Subreports, and Nested Data Regions”, [Online].https://technet.microsoft.com/en-us/library/dd207141(v=sql.120).aspx (Accessed:June 2017)
[12]Microsoft ,” Understanding OLAP Cubes”, [Online]. https://msdn.microsoft.com/en-US/library/hh916543(v=sc.12).aspx (Accessed:June 2017)
[13]OLAP.com. , [Online].
http://olap.com/olap-definition/ (Accessed:June 2017)
[14]Using Replication for Scale-Out , [Online].
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-scaleout.html (Accessed:June 2017)
[15]A Touch-Optimized Web Framework, [Online].
https://jquerymobile.com (Accessed:June 2017)
[16]Highcharts, [Online].
http://api.highcharts.com/highmaps (Accessed:June 2017)
[17]Microsoft ,”MVC Overview”, [Online].
https://msdn.microsoft.com/en-us/library/dd381412(v=vs.108).aspx (Accessed:June 2017)
[18]JSON – Introduction, [Online].
https://www.w3schools.com/js/js_json_intro.asp (Accessed:June 2017)
[19]Chen, L. (2015). Continuous Delivery Huge Benefits, but Challenges Too. IEEE Software, pp.50 - 54.
[20]Lai, S.-T., & Leu, F.-Y. (2015). Applying Continuous Integration for Reducing Web Applications Development Risks. 2015 10th International Conference on Broadband and Wireless Computing, Communication and Applications, 386-391.
[21]Humble, J., & Farley, D. (2011). Continuous Delivery: Reliable Software Releases through Build, Test, and Deployment Automation, Addison-Wesley.
[22]Mikowski, M. S., & Powell, J. C., Single Page Web Applications, Scotland: B and W, 2013.
[23]Kemper, C., & Oxley, I., Foundation Version Control for Web Developers, New York: Apress, 2012.
[24]H. Jerbi, F. Rava, O. Teste, and G. Zurfluh, “Applying Recommendation Technology in OLAP Systems,” in Proc. of International Conference on Enterprise Information Systems (ICEIS2009), 2009.
[25]W.D. Nooy, Exploratory Network Analysis with Pajek, New York: Cambridge University Press, 2005.
[26]J. Dean and S. Ghemawat, "Mapreduce: Simpli ed data processing on large clusters", OSDI, 2004.