English  |  正體中文  |  简体中文  |  Post-Print筆數 : 27 |  Items with full text/Total items : 113303/144284 (79%)
Visitors : 50812166      Online Users : 640
RC Version 6.0 © Powered By DSPACE, MIT. Enhanced by NTU Library IR team.
Scope Tips:
  • please add "double quotation mark" for query phrases to get precise results
  • please goto advance search for comprehansive author search
  • Adv. Search
    HomeLoginUploadHelpAboutAdminister Goto mobile version
    政大機構典藏 > 資訊學院 > 資訊科學系 > 學位論文 >  Item 140.119/63216
    Please use this identifier to cite or link to this item: https://nccur.lib.nccu.edu.tw/handle/140.119/63216


    Title: 以關聯式代數設計多租戶應用程式之SQL轉換規則
    Design and Implementation of SQL Rewriting Rules for Multitenant Applications Based on Relational Algebra
    Authors: 周榆澤
    Contributors: 陳恭
    周榆澤
    Keywords: 軟體即服務
    多租戶
    關聯式代數
    SaaS
    Multi-tenant
    Relational Algebra
    Date: 2013
    Issue Date: 2014-01-02 14:07:08 (UTC+8)
    Abstract: 隨著雲端運算的服務租用理念越來越受到重視,SaaS 服務供應商在提供服務的時候無不希望可以以最少的成本服務最多的客戶,於是吸引了許多的研究者投入精力以及時間,希望可以設計出讓租戶們共享資源又能夠有客製化空間的解決方案。服務供應商為了順利推廣多租戶軟體開發,其中一項關鍵技術是支援 SQL 語句自動轉換機制,目的是協助 SQL 語句轉換成以多租戶資料架構邏輯表達的 SQL 語句,讓租戶應用程式的軟體開發人員能夠專注在自身的應用程式開發。
    開發 SQL 語句自動轉換機制,必須先選定資料庫的資料架構,本論文採用 Universal Table Layout 這個 SaaS 多租戶資料共享常見的資料架構。 我們參考知名 SaaS 廠商 Force.com 的 Universal Table Layout 資料架構,並提出一些修正。其次,我們應用關聯式代數抽象化來設計 SQL 語句的轉換規則,這些理論結果不僅在表達轉換機制上更具有一般性,並且讓轉換規則的理解也變得更加容易。我們以這些理論推導為基礎實現一個實驗的工具,最後透過幾個實驗,觀察及探討實驗數據所呈現的意義。
    Reference: [1] S. Aulbach, T. Grust, D. Jacobs, A. Kemper and J. Rittinger, “Multi-Tenant Databases for Software as a Service: Schema-Mapping Techniques,” in Proc. ACM International Conference on Management of Data, 2008
    [2] C. D. Weissman and S. Bobrowski, “The design of the Force.com multitenant internet application development platform,” in Proc. ACM SIGMOD International Conference on Management of Data, 2009.
    [3] The NIST Definition of Cloud Computing, ser. 800-145. NIST Special Publication, 2011
    [4] F. Chong, G. Carraro, (2006) Multi-tenant data architecture. [Online]. Available: http://msdn.microsoft.com/en-us/library/aa470986.aspx
    [5] F. Chong and G. Carraro. (2006) Architecture strategies for catching the long tail. [Online]. Available: http://msdn.microsoft.com/en-us/library/aa479069.aspx
    [6] C. F. Liao, J. J. Chen and K. Chen, “Toward a tenant-aware query rewriting engine for universal table shcema-mapping.” Proc. of the IEEE International Conference on Cloud Computing Technology and Science (IEEE CloudCom’12), 833-838, presented in 2012 International Workshop on SaaS (Software-as-a-Service) Architecture and Engineering., 2012
    [7] G. P. Copeland and S. N. Khoshafian, “A decomposition storage model.” Proc. ACM International Conference on Management of data (SIGMOD), pp. 268-279, 1985.
    [8] F. S. Foping, I. M. Dokas, J, Feehan, and S. Imaran, “A new hybrid scheme-sharing technique for multitenant applications.” Proc. 4th International Conference on Digital Information of Management, 2009.
    [9] J. Du, H. Y. Wen, and Z. J. Yang, “Research on data layer structure of multi-tenant e-commerce system.” Proc. 17th International Conference on Industrial Engineering and Engineering Management, 2010.
    [10] D. Maier and J. D. Ullman, “Maximal objects and the semantics of universal relation databases.” ACM Transaction on Database Systems, vol. 8, no. 11, pp. 1-14, 1983.
    [11] “The force.com multitenant architecture,” Force.com, Tech.Rep.
    [12] J. Pereira and T. C. Chiueh, “SQL rewriting engine and its applications.” Stony Brook University, Tech. Rep., 2007
    [13] C. F. Liao, K. Chen, and J. J. Chen, “Automatic query rewriting schemes for multi-tenant SaaS applications,” Unpublished Technical Report, 2013.
    [14] Apache JMeter http://jmeter.apache.org
    Description: 碩士
    國立政治大學
    資訊科學學系
    100753029
    102
    Source URI: http://thesis.lib.nccu.edu.tw/record/#G0100753029
    Data Type: thesis
    Appears in Collections:[資訊科學系] 學位論文

    Files in This Item:

    File SizeFormat
    302901.pdf2262KbAdobe PDF2344View/Open


    All items in 政大典藏 are protected by copyright, with all rights reserved.


    社群 sharing

    著作權政策宣告 Copyright Announcement
    1.本網站之數位內容為國立政治大學所收錄之機構典藏,無償提供學術研究與公眾教育等公益性使用,惟仍請適度,合理使用本網站之內容,以尊重著作權人之權益。商業上之利用,則請先取得著作權人之授權。
    The digital content of this website is part of National Chengchi University Institutional Repository. It provides free access to academic research and public education for non-commercial use. Please utilize it in a proper and reasonable manner and respect the rights of copyright owners. For commercial use, please obtain authorization from the copyright owner in advance.

    2.本網站之製作,已盡力防止侵害著作權人之權益,如仍發現本網站之數位內容有侵害著作權人權益情事者,請權利人通知本網站維護人員(nccur@nccu.edu.tw),維護人員將立即採取移除該數位著作等補救措施。
    NCCU Institutional Repository is made to protect the interests of copyright owners. If you believe that any material on the website infringes copyright, please contact our staff(nccur@nccu.edu.tw). We will remove the work from the repository and investigate your claim.
    DSpace Software Copyright © 2002-2004  MIT &  Hewlett-Packard  /   Enhanced by   NTU Library IR team Copyright ©   - Feedback