Teradata Us, Inc.

B Anantha Subramanian

Awny Kayed Al-Omari

Mohammed Yassin Al-Kateb

Robert Matthew Wehrmeister

Kashif Abdullah Siddiqui

Mahbub Hasan

Mohamed Yassin Eltabakh

Sanjay Nair

Nobul Reddy Goli

Kapil Kedar Lanka

Veerendra Kumar Achanta

Christina Pavlopoulou

Improved techniques for management of memory (or memory management) for computing systems and environments are disclosed. The improved techniques are especially well suited for computing systems that operate in highly complex and/or demanding computing environments (e.g., massively parallel database systems that may be required to process many complex database queries in parallel. Memory can be managed dynamically at run time to determine and designate one of multiple memories that are available for execution of executable components (e.g., database queries, Opcodes of a Virtual Machine). In addition, memory can be managed dynamically at run time to effectively reuse memory locations of a memory (e.g., stack memory) being used for execution of one or more executable components (e.g., Opcodes of a Virtual Machine) at run time when the memory is being actively used to execute the one or more executable components.

Run time memory management for computing systems, including massively parallel database processing systems

A database system receives a request from a user. The request invokes a data set function (DSF) and uses a property to be provided by the DSF. The database system determines that a function descriptor is available for the DSF. The function descriptor is expressed as markup language instructions. The function descriptor defines the property of the DSF. The database system uses the function descriptor to define a property for the DSF.

Enabling cross-platform query optimization via expressive markup language

Execution of a query invoking an analytical function (AF) is optimized. The query includes a join operation between an AF table and an AuxiliaryTable. A determination is made that the AF includes a plurality of AF properties. Query-level properties about the query are inferred. A determination is made to change an order of the join operation from the plurality of AF properties and query-level properties.

Optimizing the execution order between analytical functions and joins in SQL queries

Growing community of inventors

Bengaluru, India

B Anantha Subramanian