Patents by Inventor Liam LOUCKS

Liam LOUCKS 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).

  • Optimizing query performance in virtual database
    Patent number: 11893015
    Abstract: Methods, computer program products, and systems are presented. The methods include, for instance: collecting real time system statistics on a system environment in a remote platform running a remote data source amongst a plurality of remote data sources of a virtual database. Real time data source statistics on one or more data source objects from the remote data source of the virtual database is also gathered. A global catalog of the virtual database is updated with the real time system statistics and the real time data source statistics. An access plan to process a query to the virtual database is optimized based on the real time system statistics and the real time data source statistics and a response is produced based on the access plan, with improved performance and reduced cost.
    Type: Grant
    Filed: November 18, 2021
    Date of Patent: February 6, 2024
    Assignee: International Business Machines Corporation
    Inventors: Hai Jun Shen, Chang Sheng Liu, Ying Qi Pan, Liam Loucks
  • OPTIMIZING QUERY PERFORMANCE IN VIRTUAL DATABASE
    Publication number: 20230153302
    Abstract: Methods, computer program products, and systems are presented. The methods include, for instance: collecting real time system statistics on a system environment in a remote platform running a remote data source amongst a plurality of remote data sources of a virtual database. Real time data source statistics on one or more data source objects from the remote data source of the virtual database is also gathered. A global catalog of the virtual database is updated with the real time system statistics and the real time data source statistics. An access plan to process a query to the virtual database is optimized based on the real time system statistics and the real time data source statistics and a response is produced based on the access plan, with improved performance and reduced cost.
    Type: Application
    Filed: November 18, 2021
    Publication date: May 18, 2023
    Inventors: Hai Jun SHEN, Chang Sheng LIU, Ying Qi PAN, Liam LOUCKS