Fu-Chen Pan

Title: The Innovations of Fu-Chen Pan

Introduction

Fu-Chen Pan is an accomplished inventor based in Endicott, NY (US). He has made significant contributions to the field of database management through his innovative patent. His work focuses on improving the efficiency of reporting data that does not adhere to referential constraints in databases.

Latest Patents

Fu-Chen Pan holds a patent for an "Automated report of broken relationships between tables." This invention provides a method for reporting data loaded to a database that does not comply with referential constraints that are not enforced. The process involves a computer receiving a file of Data Definition Language (DDL) statements for creating a database. The computer identifies statements that indicate referential constraints that are not to be enforced and converts these statements into create view statements. Ultimately, the computer generates a file that includes the create view statements, which are utilized to create database views during the database build. Additionally, the computer generates a file that comprises the received DDL statements without the unenforced referential constraints. When new data is loaded into the database, the computer creates a report that includes data from the database views. Fu-Chen Pan has 1 patent to his name.

Career Highlights

Fu-Chen Pan is associated with the International Business Machines Corporation (IBM), where he has contributed to various projects related to database technology. His expertise in this area has allowed him to develop innovative solutions that enhance data management processes.

Collaborations

Throughout his career, Fu-Chen Pan has worked alongside notable colleagues, including Kathleen F. Hills and Thomas Kersjes. Their collaborative efforts have further advanced the field of database management.

Conclusion

Fu-Chen Pan's contributions to database technology through his patent demonstrate his innovative spirit and commitment to improving data management practices. His work continues to influence the industry and pave the way for future advancements.