Patents by Inventor Lily Zhou

Lily Zhou 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: 11907220
    Abstract: A method, system and computer program product for processing queries in a hybrid database system. A database management system of the hybrid database system obtains an estimated execution time of a query by an online transaction processing engine. The database management system further obtains an estimated execution time of the query by a database accelerator. Furthermore, the database management system determines a wait time (which could be zero) for the database accelerator to process the query. The database management system then determines whether the online transaction processing engine or the database accelerator will process the query using the estimated execution time of the query by the online transaction processing engine, the estimated execution time of the query by the database accelerator and the wait time (which could be zero) for the database accelerator to process the query. In this manner, the processing of queries in hybrid database systems is optimized.
    Type: Grant
    Filed: December 18, 2020
    Date of Patent: February 20, 2024
    Assignee: International Business Machines Corporation
    Inventors: Al Chakra, Ruiping Li, Terence P. Purcell, Lily Zhou
  • Publication number: 20230082006
    Abstract: A system of racks comprising of at least two racks that can be nested together when they are not in use thereby minimizing the space required for their collective storage. Each rack is comprised of a frame having two or more frame elements linked together by at least one Z-shaped bracket. Each frame element is comprised of two vertical support members linked by a plurality of tray holders at spaced apart distances along the interior side(s) of the vertical support members. The plurality of tray holders on each of the frame elements linked by a Z-shaped bracket are substantially aligned in the vertical direction thereby forming a set of pairs of tray holders. Each pair of tray holders is configured to receive and support the placement of trays. The trays comprise of a flat base portion with upstanding side edges which may be welded to a wire element to reduce crevices where debris and contaminants may otherwise be trapped and to assist with cleaning of the trays.
    Type: Application
    Filed: May 30, 2022
    Publication date: March 16, 2023
    Inventors: ALBERT E. MITCHELL, LILY ZHOU, RYAN GU, BRYAN PAUL HUISMAN
  • Patent number: 11344115
    Abstract: A system of racks comprising of at least two racks that can be nested together when they are not in use thereby minimizing the space required for their collective storage. Each rack is comprised of a frame having two or more frame elements linked together by at least one Z-shaped bracket. Each frame element is comprised of two vertical support members linked by a plurality of tray holders at spaced apart distances along the interior side(s) of the vertical support members. The plurality of tray holders on each of the frame elements linked by a Z-shaped bracket are substantially aligned in the vertical direction thereby forming a set of pairs of tray holders. Each pair of tray holders is configured to receive and support the placement of trays. The trays comprise of a flat base portion with upstanding side edges which may be welded to a wire element to reduce crevices where debris and contaminants may otherwise be trapped and to assist with cleaning of the trays.
    Type: Grant
    Filed: November 20, 2020
    Date of Patent: May 31, 2022
    Assignee: HARVEST SUPPLY CANADA INC.
    Inventors: Albert E. Mitchell, Lily Zhou, Ryan Gu, Bryan Paul Huisman
  • Publication number: 20210191943
    Abstract: A method, system and computer program product for processing queries in a hybrid database system. A database management system of the hybrid database system obtains an estimated execution time of a query by an online transaction processing engine. The database management system further obtains an estimated execution time of the query by a database accelerator. Furthermore, the database management system determines a wait time (which could be zero) for the database accelerator to process the query. The database management system then determines whether the online transaction processing engine or the database accelerator will process the query using the estimated execution time of the query by the online transaction processing engine, the estimated execution time of the query by the database accelerator and the wait time (which could be zero) for the database accelerator to process the query. In this manner, the processing of queries in hybrid database systems is optimized.
    Type: Application
    Filed: December 18, 2020
    Publication date: June 24, 2021
    Inventors: Al Chakra, Ruiping Li, Terence P. Purcell, Lily Zhou
  • Publication number: 20210153646
    Abstract: A system of racks comprising of at least two racks that can be nested together when they are not in use thereby minimizing the space required for their collective storage. Each rack is comprised of a frame having two or more frame elements linked together by at least one Z-shaped bracket. Each frame element is comprised of two vertical support members linked by a plurality of tray holders at spaced apart distances along the interior side(s) of the vertical support members. The plurality of tray holders on each of the frame elements linked by a Z-shaped bracket are substantially aligned in the vertical direction thereby forming a set of pairs of tray holders. Each pair of tray holders is configured to receive and support the placement of trays. The trays comprise of a flat base portion with upstanding side edges which may be welded to a wire element to reduce crevices where debris and contaminants may otherwise be trapped and to assist with cleaning of the trays.
    Type: Application
    Filed: November 20, 2020
    Publication date: May 27, 2021
    Inventors: ALBERT E. MITCHELL, LILY ZHOU, RYAN GU, BRYAN PAUL HUISMAN
  • Patent number: 10909116
    Abstract: A method, system and computer program product for processing queries in a hybrid database system. A database management system of the hybrid database system obtains an estimated execution time of a query by an online transaction processing engine. The database management system further obtains an estimated execution time of the query by a database accelerator. Furthermore, the database management system determines a wait time (which could be zero) for the database accelerator to process the query. The database management system then determines whether the online transaction processing engine or the database accelerator will process the query using the estimated execution time of the query by the online transaction processing engine, the estimated execution time of the query by the database accelerator and the wait time (which could be zero) for the database accelerator to process the query. In this manner, the processing of queries in hybrid database systems is optimized.
    Type: Grant
    Filed: February 20, 2018
    Date of Patent: February 2, 2021
    Assignee: International Business Machines Corporation
    Inventors: Al Chakra, Ruiping Li, Terence P. Purcell, Lily Zhou
  • Publication number: 20190258732
    Abstract: A method, system and computer program product for processing queries in a hybrid database system. A database management system of the hybrid database system obtains an estimated execution time of a query by an online transaction processing engine. The database management system further obtains an estimated execution time of the query by a database accelerator. Furthermore, the database management system determines a wait time (which could be zero) for the database accelerator to process the query. The database management system then determines whether the online transaction processing engine or the database accelerator will process the query using the estimated execution time of the query by the online transaction processing engine, the estimated execution time of the query by the database accelerator and the wait time (which could be zero) for the database accelerator to process the query. In this manner, the processing of queries in hybrid database systems is optimized.
    Type: Application
    Filed: February 20, 2018
    Publication date: August 22, 2019
    Inventors: Al Chakra, Ruiping Li, Terence P. Purcell, Lily Zhou