Prateek Swamy

Title: Innovations by Prateek Swamy

Introduction

Prateek Swamy is an accomplished inventor based in Livermore, California. He has made significant contributions to the field of database technology, holding a total of 3 patents. His work focuses on enhancing query performance and optimizing database operations.

Latest Patents

One of Prateek's latest patents is titled "Synthetic data generation for query plans." This invention discloses techniques related to database query optimizers. In this system, a query optimizer receives multiple query plans for a database. The system retrieves a set of database statistics and generates synthetic datasets based on these statistics and the query plans. This process aims to improve query performance by selecting more efficient query plans for executing requested queries.

Another notable patent is "Database like peeking." This invention involves techniques for query planning and execution. The computer system receives a database statement with a LIKE predicate that defines a set of pattern parameters. It generates two query paths for the associated query plan, one utilizing an index and the other not. The system evaluates the provided values to determine if they are prefix constants, executing the more efficient query path when applicable.

Career Highlights

Prateek Swamy is currently employed at Salesforce, Inc., where he continues to innovate in the field of database technology. His work has been instrumental in developing solutions that enhance the efficiency of database operations.

Collaborations

Prateek has collaborated with notable coworkers, including Yi Xia and Colm McHugh, contributing to a dynamic and innovative work environment.

Conclusion

Prateek Swamy's contributions to database technology through his patents demonstrate his commitment to innovation and efficiency in query optimization. His work continues to impact the field positively.