政大機構典藏-National Chengchi University Institutional Repository(NCCUR):Item 140.119/60259
English  |  正體中文  |  简体中文  |  Post-Print筆數 : 27 |  Items with full text/Total items : 113392/144379 (79%)
Visitors : 51198194      Online Users : 910
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
    Home ‧ Login ‧ Upload ‧ Help ‧ About ‧ Administer Goto mobile version


    Please use this identifier to cite or link to this item: https://nccur.lib.nccu.edu.tw/handle/140.119/60259


    Title: 支援多租戶應用程式的SQL語句轉換機制
    A SQL rewriting mechanism for enabling multi-tenant applications
    Authors: 吳定威
    Wu, Ding Wei
    Contributors: 陳恭
    Chen, Kung
    吳定威
    Wu, Ding Wei
    Keywords: SaaS
    Multi-tenant
    AOP
    AspectJ
    SQL Rewriting
    Date: 2011
    Issue Date: 2013-09-04 17:09:51 (UTC+8)
    Abstract: 軟體即服務（Software as a Service, SaaS）是雲端運算環境下一種新興的服務模式，它的特色是將特定的應用軟體以共享軟硬體資源的方式供眾多的租戶（tenants）使用。因此，如何提供共用且有客制化功能的應用軟體就是SaaS模式的重要成功關鍵。本研究聚焦於資料庫層提供多租戶共用表格但有客制化功能的機制。讓開發人員延續一租戶一資料表的架構為基礎設計資料庫，透過SQL語句轉換機制，將SQL語句轉換為操作共享表格的語句執行，以大幅減化開發人員的工作。本研究包含兩個部份，一是資料綱要對應表(Schema Mapping Table)，協助開發人員將單租戶資料庫架構轉換為塊狀表格(chunk table)的共用資料綱要方式；另一個是SQL語句自動轉換工具，透過剖面技術織入JDBC程式集中，在應用系統執行期間，將SQL語句，從一租戶一資料表寫法轉換為共享表格的方式執行。故只需將資料表改為共用架構即可使用，達到提升多租戶系統開發速度並提高資源使用率的目的。
    Software as a service (SaaS) is an emerging service model of cloud computing, which is characterized by providing software that charges on a usage basis over shared hardware and software resources for a large number of tenants to use. Therefore, how to provide shared tables and customization of the applications is an important key to success in the SaaS model. This study focuses on how to enable multi-tenancy on the database layer Developers can extend a private table structure-based application to a shared database one through the proposed SQL rewriting mechanism. This approach can greatly simplify the developer`s work. Our approach consists of two parts, first is Schema Mapping Table that helps developers to convert single-tenant database architecture into the chunk table schema; another is SQL statement conversion tools that works by enhancing the JDBC library as an aspect in the AspectJ language. During the execution of the application, a SQL statement is rewritten from the private table based format into chunk table based statement. In this way, we are able to enhance an application with multitenant shared tables that improve resource utilization.
    Reference: 【1】 Stefan Aulbach, Torsten Grust, Dean Jacobs, Alfons Kemper, Jan Rittinger, June 2008, Multi-Tenant Databases for Software as a Service: Schema-Mapping Techniques, ACM SIGMOD.
    【2】 Frederick Chong & Gianpaolo Carraro. 2006. Architecture Strategies for Catching the Long Tail. Microsoft Corporation.
    【3】 Multi-Tenant Data Architecture http://msdn.microsoft.com/en-us/library/aa479086.aspx
    【4】 Berthold Reinwald, 2010, Multitenancy,IBM Almaden Research Center, UW MSR Summer Institute.
    【5】 張妏瑛，「應用剖面技術實作資料庫存取應用之偵錯工具」，國立政治大學資訊科學系碩士學位論文，台北，民國98年
    【6】 陳恭，「剖面導向程式設計(AOP/AOSD)簡介」
    http://www.cs.nccu.edu.tw/~chenk/AOP-intro.pdf
    【7】 Java API 1.6
    http://download.oracle.com/javase/6/docs/
    【8】 MySQL® Connector/J
    http://www.mysql.com/products/connector/j/
    【9】 The AspectJ Project
    http://eclipse.org/aspectj/
    【10】 Eclipse
    http://www.eclipse.org/
    【11】 Java API 1.6
    http://docs.oracle.com/javase/6/docs/api/
    【12】 JSqlParser parses
    http://jsqlparser.sourceforge.net/
    【13】 Java Compiler Compiler (JavaCC) - The Java Parser Generator
    http://javacc.java.net/
    【14】 SQL語法解釋器jsqlparser
    http://www.iteye.com/topic/968200
    Description: 碩士
    國立政治大學
    資訊科學學系
    98971007
    100
    Source URI: http://thesis.lib.nccu.edu.tw/record/#G0098971007
    Data Type: thesis
    Appears in Collections:[Department of Computer Science ] Theses

    Files in This Item:

    File SizeFormat
    100701.pdf2250KbAdobe PDF2592View/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