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: 10152577
    Abstract: 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: Grant
    Filed: February 24, 2015
    Date of Patent: December 11, 2018
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Lei Li, Ning Wang, Qi Rong Wang, Xiao Feng Wang, Lei Zhi, Ying Hua Zhou
  • Patent number: 9483503
    Abstract: 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: Grant
    Filed: May 24, 2013
    Date of Patent: November 1, 2016
    Assignee: International Business Machines Corporation
    Inventors: Jie Qiu, Berthold Reinwald, Qi Rong Wang, Tao Yu, Lei Zhi
  • Patent number: 9372883
    Abstract: 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: Grant
    Filed: July 30, 2013
    Date of Patent: June 21, 2016
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Wen Hao An, Bo Gao, Chang Jie Guo, Ning Wang, Qi Rong Wang, Xiao Feng Wang, Zhi Hu Wang, Lei Zhi
  • Publication number: 20150242520
    Abstract: 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: Application
    Filed: February 24, 2015
    Publication date: August 27, 2015
    Inventors: Lei Li, Ning Wang, Qi Rong Wang, Xiao Feng Wang, Lei Zhi, Ying Hua Zhou
  • Publication number: 20140040294
    Abstract: 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: Application
    Filed: July 30, 2013
    Publication date: February 6, 2014
    Applicant: International Business Machines Corporation
    Inventors: Wen Hao An, Bo Gao, Chang Jie Guo, Ning Wang, Qi Rong Wang, Xiao Feng Wang, Zhi Hu Wang, Lei Zhi
  • Publication number: 20130325906
    Abstract: 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: Application
    Filed: May 24, 2013
    Publication date: December 5, 2013
    Applicant: International Business Machines Corporation
    Inventors: Jie Qiu, Berthold Reinwald, Qi Rong Wang, Tao Yu, Lei Zhi
  • Patent number: 8495079
    Abstract: 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: Grant
    Filed: March 28, 2012
    Date of Patent: July 23, 2013
    Assignee: International Business Machines Corporation
    Inventors: Bo Gao, Chang Jie Guo, Zhen Chun Xiao, Ning Wang, Qi Rong Wang, Xiao Feng Wang, Zhi Hu Wang, Chun Lin Zhang
  • Patent number: 8495080
    Abstract: 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: Grant
    Filed: August 14, 2012
    Date of Patent: July 23, 2013
    Assignee: International Business Machines Corporation
    Inventors: Bo Gao, Chang Jie Guo, Ning Wang, Qi Rong Wang, Xiao Feng Wang, Zhi Hu Wang, Zhen Chun Xiao, Chun Lin Zhang
  • Publication number: 20120310965
    Abstract: 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: Application
    Filed: August 14, 2012
    Publication date: December 6, 2012
    Applicant: International Business Machines Corporation
    Inventors: Bo Gao, Chang Jie Guo, Zhen Chun Xiao, Ning Wang, Qi Rong Wang, Xiao Feng Wang, Zhi Hu Wang, Chun Lin Zhang
  • Publication number: 20120254258
    Abstract: 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: Application
    Filed: March 28, 2012
    Publication date: October 4, 2012
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: BO GAO, CHANG JIE GUO, ZHEN CHUN XIAO, NING WANG, QI RONG WANG, XIAO FENG WANG, ZHI HU WANG, CHUN LIN ZHANG