John Francis O'Brien

Title: John Francis O'Brien: Innovator in Database Query Optimization

Introduction

John Francis O'Brien is a notable inventor based in San Francisco, CA. He has made significant contributions to the field of database systems, particularly in optimizing query execution plans. His innovative approach has led to the development of techniques that enhance the efficiency of database query optimizers.

Latest Patents

O'Brien holds a patent for "Query plan overrides," which discloses techniques related to database query optimizers. In this patent, 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. This override indicates 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, 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. O'Brien's innovative work in this area has the potential to significantly improve database performance.

Career Highlights

John Francis O'Brien is currently employed at Salesforce, Inc., where he continues to develop and refine his expertise in database technologies. His work has been instrumental in advancing the capabilities of database systems, making them more efficient and user-friendly.

Collaborations

O'Brien has collaborated with notable colleagues, including Rama Krishna Korlapati and William J McKenna. These partnerships have fostered a collaborative environment that encourages innovation and the sharing of ideas.

Conclusion

John Francis O'Brien is a distinguished inventor whose contributions to database query optimization have made a lasting impact on the field. His patent on query plan overrides exemplifies his commitment to enhancing database performance and efficiency.