Thomas Kersjes

Title: Thomas Kersjes: Innovator in Database Management

Introduction

Thomas Kersjes is an accomplished inventor based in Arlington Heights, IL (US). He has made significant contributions to the field of database management through his innovative patent. His work focuses on improving the efficiency and reliability of data reporting in databases.

Latest Patents

Kersjes holds a patent for an "Automated report of broken relationships between tables." This invention addresses a method for reporting data loaded to a database that does not adhere to 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 comprises the create view statements, which are used to create database views during the database build. Additionally, the computer generates a file containing the original 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.

Career Highlights

Kersjes is currently employed at International Business Machines Corporation, commonly known as IBM. His role at IBM allows him to work on cutting-edge technologies and contribute to advancements in database management systems. His innovative approach has garnered attention within the industry.

Collaborations

Throughout his career, Kersjes has collaborated with notable colleagues, including Mark Anthony Musa and Fu-Chen Pan. These collaborations have further enriched his work and contributed to the development of innovative solutions in the field.

Conclusion

Thomas Kersjes is a notable inventor whose work in database management has led to significant advancements in the industry. His patent for automated reporting of broken relationships between tables exemplifies his innovative spirit and dedication to improving data management practices.