1. NCCU Academic Hub
  2. 學術產出
  3. College of Informatics
  4. Proceedings
  5. Item

學術產出-Proceedings

Article View/Open

Publication Export

Google ScholarTM

政大圖書館

Citation Infomation

題名 Toward a tenant-aware query rewriting engine for Universal Table schema-mapping
作者 Liao, C.-F.;Chen, Kung;Chen, J.-J.
陳恭;陳俊傑
貢獻者 資科系
關鍵詞 Data architectures; Design and analysis; General approach; Multi tenants; Non-trivial tasks; Performance analysis; Query rewritings; Cloud computing; Engines; Mapping; Middleware; Query processing
日期 2012
上傳時間 10-Apr-2015 16:38:33 (UTC+8)
摘要 In software as a service (SaaS) environments, designing a multi-tenant data architecture that supports shared database with custom extension is a non-trivial task. A general approach to support such an architecture is a middleware-level facility that supports the mapping of multiple single-tenant logical schemas in the application to one multi-tenant physical schema in the database. In this paper we follow this approach and report our preliminary results on the design and analysis of a query rewriting engine that can transparently transform tenant-specific logical queries into corresponding physical queries for Universal Table, a widely adopted and industry verified schema-mapping technique. A prototype and a sample SaaS application are implemented to verify the feasibility of the design of the query rewriting engine. Besides, performance analysis results that can be used to predict the overhead of schema-mapping in the engine are also reported. © 2012 IEEE.
關聯 CloudCom 2012 - Proceedings: 2012 4th IEEE International Conference on Cloud Computing Technology and Science
10.1109/CloudCom.2012.6427562
資料類型 conference
DOI http://dx.doi.org/10.1109/CloudCom.2012.6427562
dc.contributor 資科系
dc.creator (作者) Liao, C.-F.;Chen, Kung;Chen, J.-J.
dc.creator (作者) 陳恭;陳俊傑zh_TW
dc.date (日期) 2012
dc.date.accessioned 10-Apr-2015 16:38:33 (UTC+8)-
dc.date.available 10-Apr-2015 16:38:33 (UTC+8)-
dc.date.issued (上傳時間) 10-Apr-2015 16:38:33 (UTC+8)-
dc.identifier.uri (URI) http://nccur.lib.nccu.edu.tw/handle/140.119/74481-
dc.description.abstract (摘要) In software as a service (SaaS) environments, designing a multi-tenant data architecture that supports shared database with custom extension is a non-trivial task. A general approach to support such an architecture is a middleware-level facility that supports the mapping of multiple single-tenant logical schemas in the application to one multi-tenant physical schema in the database. In this paper we follow this approach and report our preliminary results on the design and analysis of a query rewriting engine that can transparently transform tenant-specific logical queries into corresponding physical queries for Universal Table, a widely adopted and industry verified schema-mapping technique. A prototype and a sample SaaS application are implemented to verify the feasibility of the design of the query rewriting engine. Besides, performance analysis results that can be used to predict the overhead of schema-mapping in the engine are also reported. © 2012 IEEE.
dc.format.extent 176 bytes-
dc.format.mimetype text/html-
dc.relation (關聯) CloudCom 2012 - Proceedings: 2012 4th IEEE International Conference on Cloud Computing Technology and Science
dc.relation (關聯) 10.1109/CloudCom.2012.6427562
dc.subject (關鍵詞) Data architectures; Design and analysis; General approach; Multi tenants; Non-trivial tasks; Performance analysis; Query rewritings; Cloud computing; Engines; Mapping; Middleware; Query processing
dc.title (題名) Toward a tenant-aware query rewriting engine for Universal Table schema-mapping
dc.type (資料類型) conferenceen
dc.identifier.doi (DOI) 10.1109/CloudCom.2012.6427562en_US
dc.doi.uri (DOI) http://dx.doi.org/10.1109/CloudCom.2012.6427562en_US