Petrus Chan

Title: Innovations by Petrus Chan

Introduction

Petrus Chan is a notable inventor based in Richmond Hill, Canada. He has made significant contributions to the field of database management systems through his innovative patent. His work focuses on optimizing database statistics to enhance performance and efficiency.

Latest Patents

Petrus Chan holds a patent titled "Automated optimization of number-of-frequent-value database statistics." This invention involves a maintenance subsystem of a database-management system (DBMS) that receives a database query requesting access to data stored in a database column. The subsystem retrieves or infers frequent-value statistics for that column, specifying the number of times distinct values are stored. The statistics are organized into Keep and Discard clusters. Using statistical or computational methods based on the column's data distribution, the subsystem determines the optimal number of statistics to retain, minimizing costs, errors, or other desired parameters. The subsystem then directs a query-optimizer component of the DBMS to consider these optimal statistics when selecting a data-access plan, which is subsequently used by the storage-manager component to access the column.

Career Highlights

Petrus Chan is associated with the International Business Machines Corporation (IBM), where he applies his expertise in database management. His innovative approach has led to advancements in how databases handle frequent-value statistics, contributing to improved data access and management.

Collaborations

Petrus has collaborated with notable colleagues, including Mohamad F Kalil and Vincent Corvinelli. Their combined efforts in the field of database management have fostered a collaborative environment that encourages innovation and development.

Conclusion

Petrus Chan's contributions to database management through his patent demonstrate his commitment to innovation in technology. His work not only enhances the efficiency of database systems but also sets a precedent for future advancements in the field.