Fred Koo

Title: Innovations of Fred Koo

Introduction

Fred Koo is an accomplished inventor based in Thornhill, CA. He has made significant contributions to the field of database management systems, holding a total of 6 patents. His work focuses on optimizing query processing in relational databases, which is crucial for improving data retrieval efficiency.

Latest Patents

One of Fred Koo's latest patents is titled "Redundant join elimination and sub-query elimination using subsumption." This invention discloses a method, computer-readable medium, and system for optimizing a query in a relational database processing system. The present invention relates to a query rewrite optimization method for eliminating a redundant join and equivalent subquery in an SQL query before the generation and selection of the optimal query execution plan. The method includes evaluating the query to identify a join predicate joining a sub-expression of the query to itself. It also determines whether a row set producible from a first set of references of the query to the sub-expression is subsumed by a row set producible from a second set of references of the query to the sub-expression. Based on such evaluation and determination, the query may be reformed to eliminate the join predicate and the second quantifier. A further determination of the removability of the second quantifier may be required, such as by evaluating a cardinality constraint when query output cardinality is material.

Another significant aspect of his work involves optimizing database queries by generating and determining the type of derived predicates based on the monotonicity of the column generating expression for each remaining inequality predicate in the list of unexamined predicates. This innovation enhances the operational efficiency of database management systems by deriving new predicates from existing ones, thereby improving query performance.

Career Highlights

Fred Koo is currently employed at International Business Machines Corporation (IBM), where he continues to innovate in the field of database technologies. His expertise in query optimization has made him a valuable asset to the company and the industry as a whole.

Collaborations

Fred has collaborated with notable coworkers such as Ting Yu Leung and Chaitanya K Baru, contributing to various projects that enhance database management systems.

Conclusion

Fred Koo's contributions to database management through his innovative patents demonstrate his commitment to improving data processing efficiency. His work continues to influence the field and showcases the importance of innovation in technology.