政大機構典藏-National Chengchi University Institutional Repository(NCCUR):Item 140.119/99029

English | 正體中文 | 简体中文 | Post-Print筆數 : 27 | Items with full text/Total items : 110118/141061 (78%)
Visitors : 46523444 Online Users : 1105

RC Version 6.0 © Powered By DSPACE, MIT. Enhanced by NTU Library IR team.

Home ‧ Login ‧ Upload ‧ Help ‧ About ‧ Administer

政大機構典藏 > 資訊學院 > 資訊科學系 > 期刊論文 > Item 140.119/99029

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

Title:	Automatic Query Rewriting Schemes for Multi-Tenant SaaS Applications
Authors:	廖峻鋒 Liao, Chun-Feng 陳恭 Chen, Kung 陳德泓 Tan, Deik Hoong 陳俊傑 Chen, Jiu-Jye
Contributors:	資科系
Keywords:	Schema-mapping;SaaS;Query rewriting;Multitenant
Date:	2015-03
Issue Date:	2016-07-13 14:44:54 (UTC+8)
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.
Relation:	Automated Software Engineering,
Data Type:	article
DOI 連結:	http://dx.doi.org/10.1007/s10515-015-0178-2
DOI:	10.1007/s10515-015-0178-2
Appears in Collections:	[資訊科學系] 期刊論文

Files in This Item:

File	Size	Format
1-34.pdf	1363Kb	Adobe PDF2	603	View/Open

社群 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.

Loading...