Qi Rong Wang’s scientific contributions

A method and system for initializing a multi-tenant database. The method includes the steps of: executing a trial of a legacy initialization tool on a trial database; capturing database statements issued by the legacy initialization tool during the step of executing a trial; capturing trial execution results of the database statements; executing the legacy initialization tool on a multi-tenant database; intercepting the database statements issued by the legacy initialization tool during the step of executing the legacy initialization tool on the multi-tenant database; and executing a mock of intercepted database statements corresponding to types of the database statements, types of tables involved in the database statements, and the trial execution results of the database statements, where at least one of the steps is carried out using a computer device.

A method and system for initializing a multi-tenant database. The method includes the steps of: executing a trial of a legacy initialization tool on a trial database; capturing database statements issued by the legacy initialization tool during the step of executing a trial; capturing trial execution results of the database statements; executing the legacy initialization tool on a multi-tenant database; intercepting the database statements issued by the legacy initialization tool during the step of executing the legacy initialization tool on the multi-tenant database; and executing a mock of intercepted database statements corresponding to types of the database statements, types of tables involved in the database statements, and the trial execution results of the database statements, where at least one of the steps is carried out using a computer device.

DB2MMT is a massive multi-tenant database platform for ISVs and Service Providers to gain business agility and maturity, to reduce time to market, to reduce CAPEX and OPEX and to provide competitive price for end users. This paper introduces isolation model, each model's security, scalability, SLA and these models' performance comparison, then introduces DB2MMT high level architecture and key technical challenges addressed, including resource, tenant and offering management, monitor, scalability and security. Experiments based on RUB is application which compared the economics of DB2MMT versus traditional solution with precise data showed acceptable performance, it also proved that fine grained multi tenant model provided by DB2MMT has significant economy advantage.