Edith A Kanyock

Title: **Innovative Contributions of Edith A. Kanyock in SQL Statement Rewriting**

Introduction

Edith A. Kanyock, a talented inventor based in Sloatsburg, NY, has made significant contributions to the field of database management through her innovative patents. With a total of two patents to her name, Kanyock's work focuses primarily on enhancing the efficiency of Structured Query Language (SQL) statements, a critical component in database interactions.

Latest Patents

Kanyock's latest patents involve a method, system, and program product for rewriting SQL statements. The first patent outlines a process wherein a SQL statement is received that includes search criteria tied to fields in database tables. From this, a comprehensive table is created that lists all possible combinations of the defined search criteria. By identifying patterns among these combinations, Kanyock's method enables the sorting of this information into temporary tables. Each temporary table is then joined with the original SQL statement, leading to the generation of results through separate searches. Ultimately, all results are compiled into a single, cohesive result table.

The second patent provides further refinement of this process, reiterating the need for efficient sorting and the generation of temporary tables based on identified patterns. This innovative approach not only optimizes the querying process but also enhances the performance and speed of database transactions.

Career Highlights

Edith A. Kanyock is known for her role at IBM, where she has leveraged her expertise to innovate solutions that significantly advance the capabilities of database management systems. Her patents reflect a commitment to improving how SQL statements are processed, ultimately benefiting a wide range of applications utilized in the industry today.

Collaborations

Throughout her career, Kanyock has collaborated with esteemed colleagues such as Howard S. Bloom and Roy Froehlich. These partnerships have helped shape her innovative ideas, leading to the development of pioneering technologies in database management.

Conclusion

Edith A. Kanyock's contributions to the field of SQL statement rewriting demonstrate the impact of her innovative thinking and collaborative efforts. As a prominent inventor at IBM, her patents offer solutions that not only enhance database functionality but also represent a crucial step forward in database management technology. Her work continues to inspire future innovations within the industry.