Lowell L Baerenwald

Title: Lowell L. Baerenwald: Innovator in Data Processing Technologies

Introduction

Lowell L. Baerenwald is a notable inventor based in Eagan, Minnesota. He has made significant contributions to the field of data processing, particularly through his innovative patent related to hybrid hash join processes. His work has implications for improving the efficiency of data retrieval and management in various applications.

Latest Patents

Baerenwald holds a patent for a hybrid hash join process. This process is designed to join data rows from two tables that share at least one common data column. It achieves this by partitioning the data rows based on the values in the common data column(s). The method creates data structures that decrease search time for matching rows and employs a unique buffer management methodology to recover full data buffers. The process designates a smaller table as the outer table and a larger one as the inner table. It effectively determines which rows in both tables meet specific selection criteria, categorizing them as inner hit rows and outer hit rows.

The hybrid hash join process also addresses buffer overflow issues in both outer and inner partitions. It links empty buffers to outer partitions until all buffers are utilized. Buffer space is recovered by writing outer hit rows for a selected partition to mass storage. The process further enhances efficiency by using hashing algorithms to assign hit rows to partitions and probe data structures for matches.

Career Highlights

Baerenwald is associated with Unisys Corporation, where he has applied his expertise in data processing technologies. His innovative approach has contributed to advancements in the field, making data management more efficient and effective.

Collaborations

Throughout his career, Baerenwald has collaborated with notable colleagues, including Lee-Chin Hsu Liu and James M. Plasek. These collaborations have likely fostered an environment of innovation and creativity, leading to significant advancements in their respective fields.

Conclusion

Lowell L. Baerenwald's contributions to data processing through his hybrid hash join process patent exemplify his innovative spirit and dedication to improving technology. His work continues to influence the way data is managed and retrieved in various applications.