This inventor holds 3 USPTO granted patents and 1 published patent application, plus 2 CIPO patents. Top assignee: International Business Machines Corporation. Active years: 2001-2004.
Company Filing History:
Years Active: 2001-2004
Title: John E Lumby: Innovator in Database Performance Evaluation
Introduction
John E Lumby is a notable inventor based in Toronto, Canada. He has made significant contributions to the field of database systems, particularly in performance evaluation and query processing. With a total of 3 patents to his name, Lumby continues to push the boundaries of innovation in technology.
Latest Patents
One of Lumby's latest patents is focused on "Selectivity estimation for processing SQL queries containing having clauses." This invention provides a method for estimating the selectivity of a HAVING clause in an SQL query within a specified time constraint. It utilizes a probabilistic model based on an assumed value distribution to determine selectivity estimates for each member in a sample set of group sizes. The estimates are then interpolated for all possible group sizes, allowing for efficient query processing.
Another significant patent is titled "System and process for evaluating the performance of a database system." This invention describes a method for assessing the performance of an operational database system without disrupting its normal operations. By creating a test database that simulates the system catalogs of the operational database, Lumby’s process enables the evaluation of query performance through generated access plans.
Career Highlights
John E Lumby is currently associated with International Business Machines Corporation (IBM), where he applies his expertise in database technologies. His work has been instrumental in enhancing the efficiency and effectiveness of database systems.
Collaborations
Throughout his career, Lumby has collaborated with notable colleagues, including Calisto Paul Zuzarte and John Frederick Hornibrook. These partnerships have contributed to the advancement of innovative solutions in the field of database management.
Conclusion
John E Lumby stands out as a key figure in the realm of database innovation. His patents reflect a deep understanding of database performance and query optimization, making him a valuable contributor to the technology landscape.