學術產出-Theses

Article View/Open

Publication Export

Google ScholarTM

政大圖書館

Citation Infomation

  • No doi shows Citation Infomation
題名 基於.NET平台之可調性多租戶軟體框架
An Adaptable Multi-Tenant Application Framework Based on .Net Platform
作者 莊偉瓏
Chuang, Wei-Lung
貢獻者 陳恭
Chen, Kung
莊偉瓏
Chuang, Wei-Lung
關鍵詞 軟體即服務
多租戶
綱要映射技術
SaaS
Multi-Tenant
Schema Mapping Technology
日期 2016
上傳時間 20-Sep-2016 11:42:17 (UTC+8)
摘要 近年來雲端運算蓬勃發展,為資訊系統的建置與服務帶來巨大的改變,其中一個重要趨勢為軟體即服務,並透過多租戶共享資源達到降低成本的優勢。因此如何讓服務可以共享資源,又能兼顧各租戶的客製化需求,這將會是軟體即服務關鍵成功因素。
      為了讓租戶客製化自己的綱要,在多租戶的相關研究中,發展出各種綱要映射技術,各適用不同的狀況,但在開發應用程式時候往往無法預估租戶適合使用何種綱要映射技術。本研究提出可以讓多租戶軟體框架具有綱要映射技術的可調性,應用程式開發時候毋需考慮使用何種綱要映射技術,等租用時候再依據應用程式及租戶的特性決定。本研究將以小量租戶效能最佳的Private Table Layout與適合用於大量租戶的Universal Table Layout為例,提出的可調性多租戶實體模式來建構具有可調性的多租戶軟體框架。此外本研究提出的軟體框架經過技術的封裝,開發者不需要了解多租戶的相關技術,就能完成多租戶應用程式的開發。
Software as a service (SaaS) is an emerging service model of cloud computing. Its central defining characteristic is the ability for clients to use a software application on a pay-as-you-go subscription basis. However, to be economically sustainable, a SaaS application must leverage resource sharing to a large degree by accommodating different clients of the application while making it appear to each that they have the application all to themselves. In other words, a SaaS application must be a multi-tenant application.
      An important multi-tenant research topic is the various kinds of schema mapping technology have been developed in order for our tenants to customize their schema. However, it is hard to determine tenants’ need for particular schema mapping technology in different circumstances. This thesis proposes an adaptable schema mapping technology for a multi-tenant application (MTA) framework. The application and tenants’ characteristics do not need to be considered while applications developers are developing their schema mapping technology. This approach will take examples from the Private Table Layout mapping and the Universal Table Layout mapping to illustrate the features of this adaptable multi-tenant software framework. Furthermore, this thesis argues that, with the approach packaged as a software framework, developers are able to complete the development of a multi-tenant application without full understanding of the underlying technologies.
參考文獻 【1】 AlAlwan, M. H., & Zaghloul, S. (2013). ANALYSIS OF SaaS MULTI-TENANT DATABASE IN A CLOUD ENVIRONMENT. In The Third International Conference on Digital Information Processing and Communications (pp. 523-528). The Society of Digital Information and Wireless Communication.
     【2】 Aulbach, S., Grust, T., Jacobs, D., Kemper, A., & Rittinger, J. (2008, June). Multi-tenant databases for software as a service: schema-mapping techniques. In Proceedings of the 2008 ACM SIGMOD international conference on Management of data (pp. 1195-1206). ACM.
     【3】 Weissman, C. D., & Bobrowski, S. (2009, June). The design of the force. com multitenant internet application development platform. In SIGMOD Conference(pp. 889-896).
     【4】 Liao, C. F., Chen, K., & Chen, J. J. (2012, December). Toward a tenant-aware query rewriting engine for universal table schema-mapping. In Cloud Computing Technology and Science (CloudCom), 2012 IEEE 4th International Conference on (pp. 833-838). IEEE.
     【5】 Multi-Tenant Data Architecture (2015)
     https://msdn.microsoft.com/en-us/library/aa479086.aspx
     【6】 LINQ 和 ADO.NET (2016)
     https://msdn.microsoft.com/zh-tw/library/bb399365(v=vs.110).aspx
     【7】 Entity Framework 概觀 (2016)
     https://msdn.microsoft.com/zh-tw/library/bb399567(v=vs.110).aspx
     【8】 用Repository Pattern抽離對Entity Framework的依賴
      http://ithelp.ithome.com.tw/articles/10157484
     【9】 反映 (C# 和 Visual Basic)
     https://msdn.microsoft.com/zh-tw/library/ms173183.aspx
描述 碩士
國立政治大學
資訊科學系碩士在職專班
103971008
資料來源 http://thesis.lib.nccu.edu.tw/record/#G0103971008
資料類型 thesis
dc.contributor.advisor 陳恭zh_TW
dc.contributor.advisor Chen, Kungen_US
dc.contributor.author (Authors) 莊偉瓏zh_TW
dc.contributor.author (Authors) Chuang, Wei-Lungen_US
dc.creator (作者) 莊偉瓏zh_TW
dc.creator (作者) Chuang, Wei-Lungen_US
dc.date (日期) 2016en_US
dc.date.accessioned 20-Sep-2016 11:42:17 (UTC+8)-
dc.date.available 20-Sep-2016 11:42:17 (UTC+8)-
dc.date.issued (上傳時間) 20-Sep-2016 11:42:17 (UTC+8)-
dc.identifier (Other Identifiers) G0103971008en_US
dc.identifier.uri (URI) http://nccur.lib.nccu.edu.tw/handle/140.119/102052-
dc.description (描述) 碩士zh_TW
dc.description (描述) 國立政治大學zh_TW
dc.description (描述) 資訊科學系碩士在職專班zh_TW
dc.description (描述) 103971008zh_TW
dc.description.abstract (摘要) 近年來雲端運算蓬勃發展,為資訊系統的建置與服務帶來巨大的改變,其中一個重要趨勢為軟體即服務,並透過多租戶共享資源達到降低成本的優勢。因此如何讓服務可以共享資源,又能兼顧各租戶的客製化需求,這將會是軟體即服務關鍵成功因素。
      為了讓租戶客製化自己的綱要,在多租戶的相關研究中,發展出各種綱要映射技術,各適用不同的狀況,但在開發應用程式時候往往無法預估租戶適合使用何種綱要映射技術。本研究提出可以讓多租戶軟體框架具有綱要映射技術的可調性,應用程式開發時候毋需考慮使用何種綱要映射技術,等租用時候再依據應用程式及租戶的特性決定。本研究將以小量租戶效能最佳的Private Table Layout與適合用於大量租戶的Universal Table Layout為例,提出的可調性多租戶實體模式來建構具有可調性的多租戶軟體框架。此外本研究提出的軟體框架經過技術的封裝,開發者不需要了解多租戶的相關技術,就能完成多租戶應用程式的開發。
zh_TW
dc.description.abstract (摘要) Software as a service (SaaS) is an emerging service model of cloud computing. Its central defining characteristic is the ability for clients to use a software application on a pay-as-you-go subscription basis. However, to be economically sustainable, a SaaS application must leverage resource sharing to a large degree by accommodating different clients of the application while making it appear to each that they have the application all to themselves. In other words, a SaaS application must be a multi-tenant application.
      An important multi-tenant research topic is the various kinds of schema mapping technology have been developed in order for our tenants to customize their schema. However, it is hard to determine tenants’ need for particular schema mapping technology in different circumstances. This thesis proposes an adaptable schema mapping technology for a multi-tenant application (MTA) framework. The application and tenants’ characteristics do not need to be considered while applications developers are developing their schema mapping technology. This approach will take examples from the Private Table Layout mapping and the Universal Table Layout mapping to illustrate the features of this adaptable multi-tenant software framework. Furthermore, this thesis argues that, with the approach packaged as a software framework, developers are able to complete the development of a multi-tenant application without full understanding of the underlying technologies.
en_US
dc.description.tableofcontents 第一章 緒論 1
     1.1 研究背景與動機 1
     1.2 研究目的 2
     1.3 研究貢獻 2
     第二章 相關研究與技術背景 3
     2.1 多租戶資料層級 3
     2.1.1 多租戶資料架構分類 3
     2.2 綱要映射技術 4
     2.2.1 Basic Layout 4
     2.2.2 Private Table Layout 4
     2.2.3 Extension Table Layout 5
     2.2.4 Universal Table Layout 5
     2.2.5 Pivot Table Layout 6
     2.2.6 Chunk Table Layout 6
     2.2.7 Chunk Folding Layout 7
     2.3 Force.com Universal Table資料架構 7
     2.3.1 Objects、Fields、Data資料表 10
     2.3.2 Indexes、UniqueFields資料表 10
     2.4 LINQ 11
     2.5 Entity Framework 14
     2.6 Reflection 15
     2.7 Emit 15
     第三章 可調性軟體框架之設計 16
     3.1 Model 16
     3.1.1 Entity與實體資料表對映 16
     3.1.2 Entity與實體資料表欄位型態不同的轉換 26
     3.1.3 動態技術 28
     3.1.4 封裝MTA技術 32
     3.2 強化Force.com Universal Table關聯效能 34
     3.3 Controller 38
     3.4 View 39
     3.4.1 接收Tenant-Entity 39
     3.4.2 客製化View 39
     3.5 租戶識別 41
     第四章 可調式多租戶軟體框架使用探討 43
     4.1 Model 43
     4.1.1 撰寫Domain-Entity POCO 44
     4.1.2 撰寫Domain-Entity Repository 44
     4.1.3 於系統中建立Tenant-Entity相關資訊 46
     4.2 Controller 47
     4.3 View 55
     4.4 效能測試 55
     4.4.1 測試環境 55
     4.4.2 Web效能測試 57
     4.4.3 壓力測試 58
     第五章 結論與未來研究方向 59
     5.1 結論 59
     5.2 未來研究方向 59
     5.2.1 客製化商業邏輯 59
     5.2.2 特定View語言轉換技術 59
     參 考 文 獻 61
zh_TW
dc.format.extent 2360673 bytes-
dc.format.mimetype application/pdf-
dc.source.uri (資料來源) http://thesis.lib.nccu.edu.tw/record/#G0103971008en_US
dc.subject (關鍵詞) 軟體即服務zh_TW
dc.subject (關鍵詞) 多租戶zh_TW
dc.subject (關鍵詞) 綱要映射技術zh_TW
dc.subject (關鍵詞) SaaSen_US
dc.subject (關鍵詞) Multi-Tenanten_US
dc.subject (關鍵詞) Schema Mapping Technologyen_US
dc.title (題名) 基於.NET平台之可調性多租戶軟體框架zh_TW
dc.title (題名) An Adaptable Multi-Tenant Application Framework Based on .Net Platformen_US
dc.type (資料類型) thesisen_US
dc.relation.reference (參考文獻) 【1】 AlAlwan, M. H., & Zaghloul, S. (2013). ANALYSIS OF SaaS MULTI-TENANT DATABASE IN A CLOUD ENVIRONMENT. In The Third International Conference on Digital Information Processing and Communications (pp. 523-528). The Society of Digital Information and Wireless Communication.
     【2】 Aulbach, S., Grust, T., Jacobs, D., Kemper, A., & Rittinger, J. (2008, June). Multi-tenant databases for software as a service: schema-mapping techniques. In Proceedings of the 2008 ACM SIGMOD international conference on Management of data (pp. 1195-1206). ACM.
     【3】 Weissman, C. D., & Bobrowski, S. (2009, June). The design of the force. com multitenant internet application development platform. In SIGMOD Conference(pp. 889-896).
     【4】 Liao, C. F., Chen, K., & Chen, J. J. (2012, December). Toward a tenant-aware query rewriting engine for universal table schema-mapping. In Cloud Computing Technology and Science (CloudCom), 2012 IEEE 4th International Conference on (pp. 833-838). IEEE.
     【5】 Multi-Tenant Data Architecture (2015)
     https://msdn.microsoft.com/en-us/library/aa479086.aspx
     【6】 LINQ 和 ADO.NET (2016)
     https://msdn.microsoft.com/zh-tw/library/bb399365(v=vs.110).aspx
     【7】 Entity Framework 概觀 (2016)
     https://msdn.microsoft.com/zh-tw/library/bb399567(v=vs.110).aspx
     【8】 用Repository Pattern抽離對Entity Framework的依賴
      http://ithelp.ithome.com.tw/articles/10157484
     【9】 反映 (C# 和 Visual Basic)
     https://msdn.microsoft.com/zh-tw/library/ms173183.aspx
zh_TW