William J McKenna

Title: Innovations by William J McKenna

Introduction

William J McKenna is an accomplished inventor based in Boulder, CO (US). He has made significant contributions to the field of database systems, particularly in optimizing query performance. His innovative work has led to the development of a patent that enhances the efficiency of database query optimizers.

Latest Patents

William J McKenna holds a patent for "Query plan overrides." This patent discloses techniques related to database query optimizers. In some embodiments, a query parser of a database system receives a query requesting data from a multi-tenant database. The query includes a first constraint that restricts a query optimizer's selection of a set of execution plans available to implement the query. The database system determines whether an override has been specified for a particular tenant associated with the received query, indicating that the first constraint is to be replaced with a second constraint for the particular tenant. In response to determining that the override has been specified for the particular tenant, the database system replaces the first constraint in the query with the second constraint and provides the query with the second constraint to the query optimizer for selection of an execution plan in accordance with the second constraint. This innovation is crucial for improving the performance of multi-tenant database systems.

Career Highlights

William J McKenna is currently employed at Salesforce, Inc., where he continues to work on innovative solutions in the field of database technology. His expertise in query optimization has made him a valuable asset to the company.

Collaborations

Throughout his career, William has collaborated with notable colleagues, including Rama Krishna Korlapati and John Francis O'Brien. These collaborations have further enriched his work and contributed to advancements in database technologies.

Conclusion

William J McKenna's contributions to database query optimization demonstrate his innovative spirit and commitment to enhancing technology. His patent for query plan overrides is a testament to his expertise and impact in the field.