Steven John Gansemer

Title: Innovations of Steven John Gansemer

Introduction

Steven John Gansemer is an accomplished inventor based in Rochester, MN (US). He has made significant contributions to the field of database management through his innovative patents. With a total of 2 patents, Gansemer has developed methods that enhance the efficiency of object persistence in relational databases.

Latest Patents

Gansemer's latest patents include "Default schema mapping" and "Schema mapping to a legacy table with primary and foreign key support." The "Default schema mapping" patent describes a method and system for persisting an object in a relational database schema by creating a new relational table at application program run-time for each class of objects to be persisted. This method generates a schema map object for each class, which remains in memory for various operations such as persisting, querying, restoring, or deleting objects. The schema map object determines the fields of each class and controls the data flow between the table and the object fields.

The second patent, "Schema mapping to a legacy table with primary and foreign key support," outlines a method for mapping an object and its associated handle between the object-oriented schema of an application and the relational schema of a database. This mapping preserves the relationships afforded by primary and foreign keys in a legacy relational database, ensuring that data integrity is maintained.

Career Highlights

Gansemer is currently employed at International Business Machines Corporation (IBM), where he continues to innovate in the field of database technologies. His work has had a profound impact on how applications interact with relational databases, making data management more efficient and reliable.

Collaborations

Some of Gansemer's notable coworkers include Tracy Kim Burroughs and Wilson D Lee. Their collaborative efforts contribute to the advancement of technology within their organization.

Conclusion

Steven John Gansemer is a notable inventor whose work in database management has led to significant advancements in the field. His innovative patents reflect his commitment to improving data persistence and integrity in relational databases.