Please use this identifier to cite or link to this item:
https://ah.lib.nccu.edu.tw/handle/140.119/77423
題名: | Automatic query rewriting schemes for multitenant SaaS applications | 作者: | Liao, Chun-Feng 廖峻鋒 Chen, Kung 陳恭 Chen, Jiu-Jye 陳俊傑 Tan, Deik Hoong |
貢獻者: | 資訊科學系 | 關鍵詞: | Schema-mapping;SaaS;Query rewriting;Multitenant | 日期: | Mar-2015 | 上傳時間: | 5-Aug-2015 | 摘要: | In Software as a Service (SaaS) environments, designing and realizing multitenant schema-mapping that supports a shared database with custom extensions is a non-trivial task. Universal Table is one promising schema-mapping technique that is commonly used. However, there has been little research devoted to the design and realization of a query rewriting scheme for Universal Table. In this paper, we present a collection of general query rewriting schemes for Universal Table that can transparently transform tenant-specific logical queries into corresponding physical queries. Based on the design, we have developed a Java-based schema-mapping and query rewriting middleware for Universal Table and a sample online shopping SaaS application to verify its feasibility. Additionally, analytical results that can be used to predict the overhead of our schemes are also reported. Finally, we conduct a series of experiments and find that the results not only agree well with our analytical predictions but also show that our schemes are scalable to the number of tenants and the number of concurrent database connections. | 關聯: | Automated Software Engineering | 資料類型: | article | DOI: | http://dx.doi.org/10.1007/s10515-015-0178-2 |
Appears in Collections: | 期刊論文 |
Files in This Item:
File | Description | Size | Format | |
---|---|---|---|---|
s10515-015-0178-2.pdf | 1.36 MB | Adobe PDF2 | View/Open |
Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.