1. NCCU Academic Hub
  2. 學術產出
  3. 資訊學院
  4. 期刊論文
  5. Item

學術產出-期刊論文

文章檢視/開啟

書目匯出

Google ScholarTM

政大圖書館

引文資訊

TAIR相關學術產出

題名 Automatic Query Rewriting Schemes for Multi-Tenant SaaS Applications
作者 廖峻鋒
Liao, Chun-Feng
陳恭
Chen, Kung
陳德泓
Tan, Deik Hoong
陳俊傑
Chen, Jiu-Jye
貢獻者 資科系
關鍵詞 Schema-mapping; SaaS; Query rewriting; Multitenant
日期 2015-03
上傳時間 13-七月-2016 14:44:54 (UTC+8)
摘要 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
dc.contributor 資科系-
dc.creator (作者) 廖峻鋒-
dc.creator (作者) Liao, Chun-Feng-
dc.creator (作者) 陳恭zh_TW
dc.creator (作者) Chen, Kungen_US
dc.creator (作者) 陳德泓zh_TW
dc.creator (作者) Tan, Deik Hoongen_US
dc.creator (作者) 陳俊傑zh_TW
dc.creator (作者) Chen, Jiu-Jyeen_US
dc.date (日期) 2015-03-
dc.date.accessioned 13-七月-2016 14:44:54 (UTC+8)-
dc.date.available 13-七月-2016 14:44:54 (UTC+8)-
dc.date.issued (上傳時間) 13-七月-2016 14:44:54 (UTC+8)-
dc.identifier.uri (URI) http://nccur.lib.nccu.edu.tw/handle/140.119/99029-
dc.description.abstract (摘要) 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.-
dc.format.extent 1396255 bytes-
dc.format.mimetype application/pdf-
dc.relation (關聯) Automated Software Engineering,-
dc.subject (關鍵詞) Schema-mapping; SaaS; Query rewriting; Multitenant-
dc.title (題名) Automatic Query Rewriting Schemes for Multi-Tenant SaaS Applications-
dc.type (資料類型) article-
dc.identifier.doi (DOI) 10.1007/s10515-015-0178-2-
dc.doi.uri (DOI) http://dx.doi.org/10.1007/s10515-015-0178-2-