SAP R/3 (tutorial): a database application system
SIGMOD '98 Proceedings of the 1998 ACM SIGMOD international conference on Management of data
SIGMOD '85 Proceedings of the 1985 ACM SIGMOD international conference on Management of data
Maximal objects and the semantics of universal relation databases
ACM Transactions on Database Systems (TODS)
Optimizing object queries using an effective calculus
ACM Transactions on Database Systems (TODS)
Storage and Querying of E-Commerce Data
Proceedings of the 27th International Conference on Very Large Data Bases
Accelerating XPath evaluation in any RDBMS
ACM Transactions on Database Systems (TODS)
C-store: a column-oriented DBMS
VLDB '05 Proceedings of the 31st international conference on Very large data bases
Extending RDBMSs To Support Sparse Datasets Using An Interpreted Attribute Storage Format
ICDE '06 Proceedings of the 22nd International Conference on Data Engineering
Fundamentals of Database Systems (5th Edition)
Fundamentals of Database Systems (5th Edition)
PIVOT and UNPIVOT: optimization and execution strategies in an RDBMS
VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
Scalable semantic web data management using vertical partitioning
VLDB '07 Proceedings of the 33rd international conference on Very large data bases
On designing and deploying internet-scale services
LISA'07 Proceedings of the 21st conference on Large Installation System Administration Conference
Modeling and exploiting query interactions in database systems
Proceedings of the 17th ACM conference on Information and knowledge management
A common database approach for OLTP and OLAP using an in-memory column database
Proceedings of the 2009 ACM SIGMOD International Conference on Management of data
A comparison of flexible schemas for software as a service
Proceedings of the 2009 ACM SIGMOD International Conference on Management of data
Proceedings of the 2009 ACM SIGMOD International Conference on Management of data
Proceedings of the VLDB Endowment
IM'09 Proceedings of the 11th IFIP/IEEE international conference on Symposium on Integrated Network Management
A Mechanism of Modeling and Verification for SaaS Customization Based on TLA
WISM '09 Proceedings of the International Conference on Web Information Systems and Mining
The reservoir model and architecture for open federated cloud computing
IBM Journal of Research and Development
Native support of multi-tenancy in RDBMS for software as a service
Proceedings of the 14th International Conference on Extending Database Technology
Engineering multi-tenant software-as-a-service systems
Proceedings of the 3rd International Workshop on Principles of Engineering Service-Oriented Systems
Predicting system performance for multi-tenant database workloads
Proceedings of the Fourth International Workshop on Testing Database Systems
Workload-aware database monitoring and consolidation
Proceedings of the 2011 ACM SIGMOD International Conference on Management of data
Towards a scalable and robust multi-tenancy SaaS
Proceedings of the Second Asia-Pacific Symposium on Internetware
ActiveSLA: a profit-oriented admission control framework for database-as-a-service providers
Proceedings of the 2nd ACM Symposium on Cloud Computing
The evolving landscape of data management in the cloud
International Journal of Computational Science and Engineering
Dynamic management of resources and workloads for RDBMS in cloud: a control-theoretic approach
PhD '12 Proceedings of the on SIGMOD/PODS 2012 PhD Symposium
Database system performance evaluation models: A survey
Performance Evaluation
Future Generation Computer Systems
Adapt: adaptive database schema design for multi-tenant applications
Proceedings of the 21st ACM international conference on Information and knowledge management
Modularizing tenant-specific schema customization in SaaS applications
Proceedings of the 8th international workshop on Advanced modularization techniques
ProRea: live database migration for multi-tenant RDBMS with snapshot isolation
Proceedings of the 16th International Conference on Extending Database Technology
SWAT: a lightweight load balancing method for multitenant databases
Proceedings of the 16th International Conference on Extending Database Technology
CloudOptimizer: multi-tenancy for I/O-bound OLAP workloads
Proceedings of the 16th International Conference on Extending Database Technology
PMAX: tenant placement in multitenant databases for profit maximization
Proceedings of the 16th International Conference on Extending Database Technology
A formal model for multi-tenant software-as-a-service in cloud computing
Proceedings of the 5th ACM COMPUTE Conference: Intelligent & scalable system technologies
Parallel analytics as a service
Proceedings of the 2013 ACM SIGMOD International Conference on Management of Data
An index model for multitenant data storage in saas
WAIM'13 Proceedings of the 14th international conference on Web-Age Information Management
Monitoring and Autoscaling IaaS Clouds: A Case for Complex Event Processing on Data Streams
UCC '13 Proceedings of the 2013 IEEE/ACM 6th International Conference on Utility and Cloud Computing
Hi-index | 0.00 |
In the implementation of hosted business services, multiple tenants are often consolidated into the same database to reduce total cost of ownership. Common practice is to map multiple single-tenant logical schemas in the application to one multi-tenant physical schema in the database. Such mappings are challenging to create because enterprise applications allow tenants to extend the base schema, e.g., for vertical industries or geographic regions. Assuming the workload stays within bounds, the fundamental limitation on scalability for this approach is the number of tables the database can handle. To get good consolidation, certain tables must be shared among tenants and certain tables must be mapped into fixed generic structures such as Universal and Pivot Tables, which can degrade performance. This paper describes a new schema-mapping technique for multi-tenancy called Chunk Folding, where the logical tables are vertically partitioned into chunks that are folded together into different physical multi-tenant tables and joined as needed. The database's "meta-data budget" is divided between application-specific conventional tables and a large fixed set of generic structures called Chunk Tables. Good performance is obtained by mapping the most heavily-utilized parts of the logical schemas into the conventional tables and the remaining parts into Chunk Tables that match their structure as closely as possible. We present the re sults of several experiments designed to measure the efficacy of Chunk Folding and describe the multi-tenant database testbed in which these experiments were performed.