Prashanth Purnananda

Title: Prashanth Purnananda: Innovator in Database Locking Mechanisms

Introduction

Prashanth Purnananda is a notable inventor based in Bellevue, WA (US). He has made significant contributions to the field of database management through his innovative patents. With a total of 4 patents, Purnananda has focused on enhancing the efficiency of locking mechanisms in databases.

Latest Patents

One of his latest patents is titled "Granular tracking of locking queries to reduce locking." This invention discloses systems, methods, apparatuses, and program products for granular tracking of locking queries. Upon receiving a data manipulation command associated with a row of a page, a flag associated with the page is checked to determine whether a row locking query (RLQ) may be associated with the page. If no RLQ is associated with the page, the data manipulation command is executed without acquiring a lock. If an RLQ may be associated with the page, it is determined whether an active lock is associated with the page. If no active lock is associated with the page, the flag is updated to indicate that no RLQ is associated with the page, and the data manipulation command is executed without acquiring a lock. If an active lock is associated with the page, page-level and row-level locks are acquired on the page and the row, respectively, before executing the data manipulation command.

Another significant patent is "Method and system for lock after qualification for update queries." This invention includes techniques for anomaly detection via sparse judgmental samples. These techniques may involve generating a qualified timestamp corresponding to the execution of a first operation of a first transaction over a database and determining, based on the qualified timestamp, that a row of a table is not locked by a second operation of a second transaction over the database. Additionally, the techniques may include determining that the row meets a condition of the first operation and updating, based on the qualified timestamp, the row in response to the row meeting the condition, which includes acquiring a lock on the row of the table.

Career Highlights

Prashanth Purnananda is currently employed at Microsoft Technology Licensing, LLC. His work at this prestigious company has allowed him to develop and refine his innovative ideas in database technology.

Collaborations

Throughout his career, Purnananda has collaborated with talented individuals such as Hanumantha Rao Kodav