Yiu Woon Lau

Title: Yiu Woon Lau: Innovator in Database Management Systems

Introduction

Yiu Woon Lau is a notable inventor based in New York, NY (US). He has made significant contributions to the field of database management systems, holding a total of 4 patents. His work focuses on enhancing the efficiency and effectiveness of data processing and evaluation.

Latest Patents

One of Yiu Woon Lau's latest patents is titled "Methods and apparatus of shared expression evaluation across RDBMS and storage layer." This patent outlines techniques for sharing expression evaluation across a database management system (RDBMS) and a storage layer. In this embodiment, a computer identifies a plurality of target operators within a query execution plan that includes an expression computing a common value. The storage layer evaluates this expression during a table scan of the stored data. For at least one target operator, the computer modifies the row input to include a column that receives the evaluation result of the common value from the storage layer. This innovative approach allows for more efficient query execution by sharing evaluation results among target operators.

Another patent under the same title further elaborates on the techniques for sharing expression evaluation. It describes how a plurality of target operators are identified, each corresponding to a step that evaluates a common expression during query execution. The target operators are modified to enable sharing of the evaluation result, which is then retrieved from the storage layer during query execution. This advancement significantly optimizes the performance of database management systems.

Career Highlights

Yiu Woon Lau is currently employed at Oracle International Corporation, where he continues to develop innovative solutions in database technology. His expertise in shared expression evaluation has positioned him as a key contributor to advancements in the field.

Collaborations

Yiu Woon Lau has collaborated with notable coworkers, including Dmitry Mikhailovich Potapov and Hakan Jakobsson. Their combined efforts have led to significant advancements in database management technologies.

Conclusion

Yiu Woon Lau's contributions to the field of database management systems through his innovative patents demonstrate his commitment to enhancing data processing efficiency. His work at Oracle International Corporation continues to influence the industry positively.