Edward Shaw-Lee Suen

Title: Edward Shaw-Lee Suen: Innovator in Query Processing Technologies

Introduction

Edward Shaw-Lee Suen is a notable inventor based in San Francisco, CA. He has made significant contributions to the field of query processing technologies, holding a total of 5 patents. His work focuses on improving the efficiency and performance of database queries, which is crucial in today's data-driven world.

Latest Patents

One of his latest patents is titled "Detecting and processing cache hits for queries with aggregates." This invention introduces techniques to enhance query caching performance by efficiently selecting queries stored in a cache for evaluation. It increases the cache hit rate by allowing for inexact matches. The process begins with determining a list of candidate queries that could potentially answer a new query. This list may include all cached queries or those containing exact and/or inexact matches. Each candidate query is evaluated to determine if there is a cache hit, indicating its potential to answer the new query. The evaluation employs a set of rules that accommodate inexact matches of aggregates, if applicable. A query plan is then generated based on a specific candidate query that has a cache hit.

Another significant patent is "Multi-user system with dynamic data source selection." This invention outlines techniques for dynamically selecting data sources for users and directing their queries to the appropriate data sources. Initially, user information is received and used to determine a designated data source for each user. This can be achieved through a look-up table or by executing a query with the user information. A data source variable is then set to the identity of the designated data source, allowing queries to be directed accordingly.

Career Highlights

Edward has worked with prominent companies such as Siebel Systems, Inc. and Oracle International Corporation. His experience in these organizations has contributed to his expertise in database technologies and query optimization.

Collaborations

Throughout his career, Edward has collaborated with talented individuals, including Sunil Prabhakar Dixit and Donovan Schneider. These collaborations have likely enriched his work and led to innovative solutions in the field.

Conclusion

Edward Shaw-Lee Suen is a distinguished inventor whose work in query processing technologies has made a significant impact. His patents reflect his commitment to enhancing database performance and efficiency. His contributions continue to influence the way data is managed and accessed in various applications.