Hong Gui

Title: The Innovations of Hong Gui

Introduction

Hong Gui is a notable inventor based in Madison, WI (US). He has made significant contributions to the field of database systems, holding a total of 6 patents. His work focuses on enhancing the efficiency and functionality of database management through innovative solutions.

Latest Patents

One of Hong Gui's latest patents is titled "Determining materialized view coverage for join transactions." This patent describes a database system that includes software capable of receiving a query specifying a join of multiple base tables. The system determines whether a foreign key and primary key relationship exists between the join columns specified by the query and a materialized view definition. Based on this relationship, the database software can compute a result for the received query from the materialized view.

Another significant patent is "Deferred maintenance of sparse join indexes." This invention outlines a system and method for defining a snapshot join index using a sparse condition in a join index definition. The new sparse condition of the snapshot join index is compared with an old sparse condition, allowing the identification of rows in a base table as a function of this comparison. Consequently, the join index table is updated using the identified rows.

Career Highlights

Throughout his career, Hong Gui has worked with prominent companies such as Teradata US, Inc. and NCR Corporation. His experience in these organizations has allowed him to develop and refine his innovative ideas in database technology.

Collaborations

Hong Gui has collaborated with several talented individuals, including Grace K. Au and Curt J. Ellmann. These partnerships have contributed to the advancement of his projects and patents.

Conclusion

Hong Gui's contributions to database systems through his patents demonstrate his innovative spirit and technical expertise. His work continues to influence the field, showcasing the importance of advancements in technology.