John Richard Lyle

Title: John Richard Lyle: Innovator in Database Management

Introduction

John Richard Lyle is a notable inventor based in Morgan Hill, CA (US). He has made significant contributions to the field of database management, particularly in the area of DB2 technology. With a total of 3 patents to his name, Lyle has demonstrated a commitment to innovation and efficiency in database operations.

Latest Patents

One of Lyle's latest patents is a method for changing the page size of a DB2 table space while keeping the object available. This innovative method allows for online reorganization and the increase of the page size of a DB2 object. The process involves reorganizing a base table and its related auxiliary table spaces concurrently using the DB2 REORG utility. The utility identifies related auxiliary tables and includes them in the same operation. The reorganization utilizes allocated shadow data sets, with the page size dynamically updated during the process. Once the reorganization is complete, the original data sets are replaced with the newly built shadow data sets, and the DB2 catalog values and control blocks are updated accordingly.

Career Highlights

Lyle is currently employed at International Business Machines Corporation, commonly known as IBM. His work at IBM has allowed him to focus on advancing database technologies and improving operational efficiencies. His contributions have been instrumental in enhancing the capabilities of DB2 systems.

Collaborations

Throughout his career, Lyle has collaborated with notable colleagues, including William James Franklin and Jay A Yothers. These partnerships have fostered a collaborative environment that encourages innovation and the sharing of ideas.

Conclusion

John Richard Lyle is a distinguished inventor whose work in database management has led to significant advancements in the field. His innovative methods and dedication to improving technology continue to impact the industry positively.