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

English | 正體中文 | 简体中文 | Post-Print筆數 : 27 | 全文筆數/總筆數 : 113656/144643 (79%)
造訪人次 : 51733722 線上人數 : 599

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

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

請使用永久網址來引用或連結此文件: https://nccur.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
日期:	2015-03
上傳時間:	2015-08-05 14:29:37 (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
DOI:	10.1007/s10515-015-0178-2
顯示於類別:	[資訊科學系] 期刊論文

文件中的檔案:

檔案	描述	大小	格式	瀏覽次數
s10515-015-0178-2.pdf		1363Kb	Adobe PDF2	881	檢視/開啟

在政大典藏中所有的資料項目都受到原著作權保護.

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

資料載入中.....