雲端運算的SaaS通常會提供給成千上萬的用戶共同使用，且彼此之間不會互相干擾。對於軟體廠商來說，每個用戶都共用一整套完整的軟硬體設施，不須擔負額外的成本以提供不同的實體給不同的用戶所使用。鑒於SaaS已是IT行業中的趨勢，在軟體市場具有相當大的潛力。多租戶技術使大量用戶共同使用相同的軟硬體資源，有效增加資源利用率，並可降低營運成本而提高收益。但將軟體移植到雲端時，必須克服軟體本身的限制和環境因素。本論文為了能夠快速將傳統軟體轉換為多租戶架構，解決多租戶資料隔離的問題，讓開發人員仍然可以使用傳統關聯式資料庫的寫法來開發應用程式，同時能夠支持跨多重租戶查詢，基於Chunk Table的資料結構，透過SQL語句轉換機制，將程式內的傳統關聯式SQL語句自動改寫成符合Chunk Table的SQL語句。我們以一個查詢範例成功地完成了Chunk Table即時性跨多重租戶的查詢實作，也額外以Materialized View做了非即時性跨多重租戶的查詢實作。

SaaS cloud computing provides thousands of users to operate without interfering with one another. From the software supplier’s point of view, each user sharing the same package of hardware and software, extra expense can be exempted from providing each user a different entity.With great potentials in software market, it is foreseen that the SaaS will become the trend of IT business. Multi-tenant technology increases resource utilization and reduces operational cost by using majority users’ software/hardware resources to create profits. However, transplanting software to the cloud requires overcoming the software limitation as well as the environment factors.To quickly convert from the traditional software to the multi-tenant structure and solve the data isolation issues, this research allows the developers to program using the traditional relational database and in the meantime support queries across multiple tenants. Based on the Chunk Table data structure and through the SQL statements conversion mechanism, the traditional relational SQL statements were automatically converted into the Chunk Table conformable SQL statements. We have also completed the tenant queries across multiple implementations. We have an example of a query successfully completed Chunk Table real-time queries across multiple tenants implemented. We also do extra to Materialized View non-real time queries across multiple tenants implemented.

摘要 I
Abstract II
誌謝 III
目錄 V
表目錄 VII
圖目錄 VIII
第一章 簡介 1
第一節 研究動機 1
第二節 研究貢獻 5
第三節 研究限制 5
第四節 論文章節結構 5
第二章 文獻探討 7
第一節 資料隔離架構 7
第二節 動態View 9
第三節 Chunk Table Layout 11
第四節 SQL語句轉換機制 13
第三章 系統實作 18
第一節 系統概述 18
第二節 系統架構 19
第四章 模擬實驗 22
第一節 實驗環境 22
第二節 模擬情境 22
第三節 實驗結果 28
第四節 非即時性查詢實驗 32
第五章 結論和未來工作 40
第一節 結論 40
第二節 未來工作 41
參考文獻 42
附錄 45
附錄一 系統安裝 45
附錄二 新建Chunk Table資料的程式 50
附錄三 模擬實驗的測試主程式 59
附錄四 測試Chunk Table的程式 62

[1]Robert P. Mahowald. Worldwide Software as a Service 2010–2014 Forecast: Software Will Never Be the Same, Jun 2010. Retrieved March 18, 2014, from http://www.idc.com/research/viewdocsynopsis.jsp?containerId=223628
[2]Robert P. Mahowald, Benjamin McGrath. Market Analysis Perspective: Worldwide SaaS and Cloud Software, 2013 — Software Will Never Be the Same, Dec 2013. Retrieved March 18, 2014, from http://www.idc.com/getdoc.jsp?containerId=245047
[3]Gartner . Gartner Says Worldwide Software-as-a-Service Revenue to Reach $14.5 Billion in 2012. Retrieved March 18, 2014, from http://www.gartner.com/newsroom/id/1963815
[4]Gartner . Gartner:2013年印度公共雲服務市場將達4.43億美元. http://stor-age.zdnet.com.cn/stor-age/2013/0510/2158811.shtml(103.03.18)
[5]Peter Mell and Timothy Grance. The NIST Definition of Cloud Computing. Retrieved October 3, 2013, from http://csrc.nist.gov/publications/nistpubs/800-145/SP800-145.pdf
[6]Heyong Wang, Wu He, Feng-Kwei Wang. Enterprise cloud service architectures. In Information Technology and Management, Springer US, vol. 13, Issue 4, pages 445-454, 2012.
[7]Steven C. Markey. Extend your secure development process to the cloud and big data. Retrieved March 23, 2014, from http://www.ibm.com/developerworks/cloud/library/cl-extenddevtocloudbigdata/
[8]WeiTek Tsai,XiaoYing Bai,Yu Huang. Software-as-a-service (SaaS): perspectives and challenges. In Science China Information Sciences, Vol.57, pages 1-15, 2014.
[9]陳俊傑. 多租戶雲端運用程式之中介軟體框架. 國立政治大學資訊科學系碩士學位論文, 台北, 民國102年.
[10]陳瑩. 雲端策略:雲端運算與虛擬化技術. 天下雜誌, pages 130-134, 2010.
[11]Craig D Weissman, Steve Bobrowski. The Design of the Force.com Multitenant Internet Application Development Platform. In the proc. of International Conference on Management of Data - SIGMOD, pages 889-896, 2009.
[12]Carl Osipov, Germán Goldszmidt, Mary Taylor, Indrajit Poddar. Develop and Deploy Multi-Tenant Web-delivered Solutions using IBM middleware: Part 2: Approaches for enabling multi-tenancy. Retrieved March 25, 2014, from http://www.ibm.com/developerworks/library/ws-multitenantpart2/
[13]Thomas Kwok and Ajay Mohindra. Resource Calculations with Constraints, and Placement of Tenants and Instances for Multi-tenant SaaS Applications. In Lecture Notes in Computer Science, Vol. 5364, 6th International Conference, Sydney, Australia, December 1-5. Proceedings, pages 633-648, 2008.
[14]資策會產業情報研究所. 全球零售業IT應用趨勢剖析, 民國102 年. http://www.otc.org.tw/ch/about/publish/monthly/monthly_dl.php?DOC_ID=1138(103.12.20)
[15]James B., Mattison, Saideep Raj. Key questions every IT and business executive should ask about cloud computing and ERP, 2012. Retrieved December 20, 2013, from http://www.accenture.com/us-en/Pages/insight-key-questions-cloud-computing-erp.aspx
[16]林松輝. 移植軟體成為雲端運算下的軟體服務. 國立台北科技大學資訊工程系碩士學位論文, 台北, 民國100年.
[17]Chang Jie Guo, Wei Sun, Ying Huang, Zhi Hu Wang, Bo Gao. A Framework for Native Multi-Tenancy Application Development and Management. In E-Commerce Technology and the 4th IEEE International Conference on Enterprise Computing, E-Commerce, and E-Services, pages 551-558, July 2007.
[18]李明憲. 基於可延伸性表格的多租戶應用程式資料綱要轉換工具. 國立政治大學資訊科學系碩士學位論文, 台北, 民國101年.
[19]吳定威. 支援多租戶應用程式的SQL語句轉換機制. 國立政治大學資訊科學系碩士學位論文, 台北, 民國101年.
[20]張曉雯, 楊建. 基于原生數據庫的SaaS存儲模型①. 計算機系統應用, 22(6) , 2013.
[21]王鑫,袁曉潔,馮志勇,張坤龍,王樹義. 原生存儲方案的資料更新機制. 電腦應用,30(3), pages 821-824, 2010.
[22]周愛武, 李孫長, 程博, 夏松. XML 資料庫的研究與應用. 電腦技術與發展, 19(9), pages 218-221, 2009.
[23]劉孟俊, 鐘富國. 中國集團企業興起與其影響. 台灣國際研究季刊, 第9卷, 第3期, 頁93-114, 2013.
[24]Grund M, Schapranow M, Krueger J, et al. Shared Table Access Pattern Analysis for Multi-Tenant Applications, In AMIGE, IEEE Symposium, 2008.
[25]Frederick Chong, Gianpaolo Carraro, and Roger Wolter. Multi-Tenant Data Architecture, 2006. Retrieved October 18, 2013, from http://msdn.microsoft.com/en-us/library/aa479086.aspx
[26]黃清輝、劉信彥. 資料庫存取方法以及系統. 中華民國發明專利第TW201327235A1號, 2013.
[27]Stefan Aulbach, Torsten Grust, Dean Jacobs, Alfons Kemper, Jan Rittinger. Multi-Tenant Databases for Software as a Service : Schema-Mapping Techniques. In the proc. of International Conference on Management of Data - SIGMOD, pages 1195-1206, 2008.
[28]Stefan Aulbach, Torsten Grust, Dean Jacobs, Alfons Kemper, Jan Rittinger. A Comparison of Flexible Schemas for Software as a Service. In SIGMOD’09, June 29-July 2, 2009.
[29]鼎新電腦. TIPTOP GP 集團控管, 2014. http://tw.digiwin.biz/softwareDetail_P201404111213.html
[30]任惠蓮. 中國行銷通路策略創新之研究—以T家具公司為例. 國立政治大學經營管理碩士學程EMBA學位論文, 台北, 民國96年.
[31]Oracle9i Advanced Replication. Materialized View Concepts and Architecture, Release 2 (9.2), Part Number A96567-01. Retrieved November 18, 2013, from http://docs.oracle.com/cd/A97630_01/server.920/a96567/repmview.htm
[32]My SQL. WL#2866: Materialized Views (reduced support) . Retrieved November 18, 2013, from http://dev.mysql.com/worklog/task/?id=2866
[33]Alexander Benlian, Thomas Hess. Drivers of SaaS-Adoption – An Empirical Study of Different Application Types. In Business & Information Systems Engineering, 1(5), pages 357-369, 2009.
[34]岳昆, 王曉玲, 周傲英. Ｗｅｂ服務核心支撐技術：研究綜述. 軟件學報, 15(3), pages 428-442, 2004.
[35]楊芙青. 軟體工程技術發展思索. 軟體學報, 16(1), pages 1-7, 2005.
[36]Mark Turner, David, Budgen, et al. Turning Software into a Service. In Computer, vol.36, pages 38-44, 2003.