Teradata Us, Inc.

Mohan Kumar Kj

Bhashyam Ramesh

Tirupathi Prabhu Bellapukonda

Karan Kaur Phull

J Venkata Ramana

Vamshi Krishna Vangapalli

Anitha G

Techniques for improving the execution of database queries in a multi-processor system or distributed processing system environment are provided. In a database system including multiple parsing engines (PEs) for parsing database queries, or requests, received by the system and generating execution plans for the requests, execution plans generated for requests can be saved in a global request cache accessible to each of the parsing engines. Requests which have been parsed and cached by a PE can be retrieved for use by other PEs, thereby avoiding unnecessarily parsing the same database request in multiple PEs. The global request cache may be a distributed cache consisting of request caches local to each parsing engine, with execution plans allocated to the local request caches using hashing techniques applied to the database requests associated with the execution plans.

System and method for sharing database query execution plans between multiple parsing engines

A method for performing row qualification in database table retrieval and join operations. This method, referred to as bulk qualification, evaluates conditions on multiple rows in a database table at the same time, providing more efficient utilization of memory bandwidth and CPU throughput.

Method for predicate evaluation in relational database systems

Growing community of inventors

Hyderabad Telangana, India

Mohan Kumar Kj