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

English | 正體中文 | 简体中文 | Post-Print筆數 : 27 | 全文笔数/总笔数 : 113656/144643 (79%)
造访人次 : 51718499 在线人数 : 605

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.

数据加载中.....