Patents by Inventor QI RONG WANG
QI RONG WANG has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 10152577Abstract: Cross tenant data access is provided by creating a logic view in a meta database with respect to at least a first tenant of a group of tenants and according to metadata about the respective tenants. The logic view is based upon first data owned by the first tenant as well as second data that is owned and authorized by at least another tenant of the group of tenants for the first tenant to access. The logic view in the meta database is accessed in response to a cross tenant data access request from an application of the first tenant.Type: GrantFiled: February 24, 2015Date of Patent: December 11, 2018Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Lei Li, Ning Wang, Qi Rong Wang, Xiao Feng Wang, Lei Zhi, Ying Hua Zhou
-
Patent number: 9483503Abstract: A method and system for placing database. The method includes: receiving a request of creating a new database; determining whether there is a need to migrate current database among current virtual machines based on resource demand and free resource in the current virtual machines; determining database placement plan based on the resource demand, migration strategy and migration cost associated with the migration strategy in response to whether there is a need to migrate the database; and executing the database placement plan. The invention can help a database service provider to optimize database layout in database provision through database migration.Type: GrantFiled: May 24, 2013Date of Patent: November 1, 2016Assignee: International Business Machines CorporationInventors: Jie Qiu, Berthold Reinwald, Qi Rong Wang, Tao Yu, Lei Zhi
-
Patent number: 9372883Abstract: Embodiments relate to manipulating a multi-tenant database, wherein the multi-tenant database comprises one or more source databases for storing tenant data. An aspect includes receiving a database operation request for one or more tenant-specific logic views, wherein the tenant-specific logic views are created for respective tenants based on mapping information pointing to the one or more source databases included in the multi-tenant database and multi-tenant metadata. Another aspect includes acquiring the mapping information related to the database operation request and pointing to the one or more source databases included in the multi-tenant database. Yet another aspect includes performing a database operation corresponding to the database operation requested for the one or more source databases based on the acquired mapping information.Type: GrantFiled: July 30, 2013Date of Patent: June 21, 2016Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Wen Hao An, Bo Gao, Chang Jie Guo, Ning Wang, Qi Rong Wang, Xiao Feng Wang, Zhi Hu Wang, Lei Zhi
-
Publication number: 20150242520Abstract: Cross tenant data access is provided by creating a logic view in a meta database with respect to at least a first tenant of a group of tenants and according to metadata about the respective tenants. The logic view is based upon first data owned by the first tenant as well as second data that is owned and authorized by at least another tenant of the group of tenants for the first tenant to access. The logic view in the meta database is accessed in response to a cross tenant data access request from an application of the first tenant.Type: ApplicationFiled: February 24, 2015Publication date: August 27, 2015Inventors: Lei Li, Ning Wang, Qi Rong Wang, Xiao Feng Wang, Lei Zhi, Ying Hua Zhou
-
Publication number: 20140040294Abstract: Embodiments relate to manipulating a multi-tenant database, wherein the multi-tenant database comprises one or more source databases for storing tenant data. An aspect includes receiving a database operation request for one or more tenant-specific logic views, wherein the tenant-specific logic views are created for respective tenants based on mapping information pointing to the one or more source databases included in the multi-tenant database and multi-tenant metadata. Another aspect includes acquiring the mapping information related to the database operation request and pointing to the one or more source databases included in the multi-tenant database. Yet another aspect includes performing a database operation corresponding to the database operation requested for the one or more source databases based on the acquired mapping information.Type: ApplicationFiled: July 30, 2013Publication date: February 6, 2014Applicant: International Business Machines CorporationInventors: Wen Hao An, Bo Gao, Chang Jie Guo, Ning Wang, Qi Rong Wang, Xiao Feng Wang, Zhi Hu Wang, Lei Zhi
-
Publication number: 20130325906Abstract: A method and system for placing database. The method includes: receiving a request of creating a new database; determining whether there is a need to migrate current database among current virtual machines based on resource demand and free resource in the current virtual machines; determining database placement plan based on the resource demand, migration strategy and migration cost associated with the migration strategy in response to whether there is a need to migrate the database; and executing the database placement plan. The invention can help a database service provider to optimize database layout in database provision through database migration.Type: ApplicationFiled: May 24, 2013Publication date: December 5, 2013Applicant: International Business Machines CorporationInventors: Jie Qiu, Berthold Reinwald, Qi Rong Wang, Tao Yu, Lei Zhi
-
Patent number: 8495080Abstract: 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.Type: GrantFiled: August 14, 2012Date of Patent: July 23, 2013Assignee: International Business Machines CorporationInventors: Bo Gao, Chang Jie Guo, Ning Wang, Qi Rong Wang, Xiao Feng Wang, Zhi Hu Wang, Zhen Chun Xiao, Chun Lin Zhang
-
Patent number: 8495079Abstract: 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.Type: GrantFiled: March 28, 2012Date of Patent: July 23, 2013Assignee: International Business Machines CorporationInventors: Bo Gao, Chang Jie Guo, Zhen Chun Xiao, Ning Wang, Qi Rong Wang, Xiao Feng Wang, Zhi Hu Wang, Chun Lin Zhang
-
Publication number: 20120310965Abstract: 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.Type: ApplicationFiled: August 14, 2012Publication date: December 6, 2012Applicant: International Business Machines CorporationInventors: Bo Gao, Chang Jie Guo, Zhen Chun Xiao, Ning Wang, Qi Rong Wang, Xiao Feng Wang, Zhi Hu Wang, Chun Lin Zhang
-
Publication number: 20120254258Abstract: 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.Type: ApplicationFiled: March 28, 2012Publication date: October 4, 2012Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: BO GAO, CHANG JIE GUO, ZHEN CHUN XIAO, NING WANG, QI RONG WANG, XIAO FENG WANG, ZHI HU WANG, CHUN LIN ZHANG