Patents by Inventor Bhashyam Ramesh
Bhashyam Ramesh has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Publication number: 20240143589Abstract: A method, apparatus and computer program product for estimating resource consumption for steps in a query execution plan for a query performed by a relational database management system (RDBMS) in a computer system. Past execution data for the steps are used to train a machine learning (ML) model and its model parameters to predict execution times for the steps. A prediction module comprised of the ML model configured by the model parameters predicts an execution time for a current step of the query execution plan for the query, based on current step information and current system load. A boosting module boosts the current step either up or down for processing by the RDBMS to meet a service level goal (SLG) for the query, based on the predicted execution time for the current step, as well as an elapsed query time, a query SLG time, and/or a query CPU time.Type: ApplicationFiled: October 27, 2022Publication date: May 2, 2024Applicant: Teradata US, Inc.Inventors: Bhashyam Ramesh, Douglas P. Brown, Vijayasaradhi Indurthi
-
Patent number: 11874811Abstract: Control versioning of records in a temporal table is provided to reduce data redundancy. New Data Definition Language (DDL) syntax is provided to make individual columns within a table sensitive or insensitive to whether new row versions are generated when Database Manipulation Language (DML) statements operate on the table. The database parser and back-end data processors are configured to create the table with the user-defined versioning attributes and to manage versioning of the rows without requiring additional programming.Type: GrantFiled: December 28, 2018Date of Patent: January 16, 2024Assignee: Teradata US, Inc.Inventors: Stephen Molini, Bhashyam Ramesh, Jaiprakash Ganpatrao Chimanchode, Sai Pavan Kumar Pakala, Pratik Patodi, Dhrubajyoti Roy, Todd Walter
-
Publication number: 20230350864Abstract: A database system includes a storage medium to store a semi-materialized view (MV) defined on an MV condition, the semi-MV including metadata containing references to objects containing data of one or more tables that satisfy the MV condition, the objects stored in a remote data store that is coupled to the database system over a network. The database system includes at least one processor to receive a query including a query condition, determine that the semi-MV can be used to satisfy the query based on the MV condition and the query condition, and use the metadata in the semi-MV to retrieve data of the objects in the remote data store for the query.Type: ApplicationFiled: April 28, 2022Publication date: November 2, 2023Inventors: Rangavajjula K N Sai Krishna, Chandrasekhar Tekur, Bhashyam Ramesh, Shambhu Sree Vegunta, Venkata Ramana Jyothula
-
Patent number: 11775523Abstract: An improved hash table structure compatible with in-memory processing for increasing cache efficiency during hash join processing of a small and large table in a relational database system. The hash table, residing in processor memory, includes a first partition containing a join condition column providing best selectivity for joining the small table with the large table, at least one additional partition containing additional join condition columns for joining the small table with the large table; and an array of hash values, the array of hash values providing an index into the hash table partitions.Type: GrantFiled: June 23, 2017Date of Patent: October 3, 2023Assignee: Teradata US, Inc.Inventors: Bhashyam Ramesh, Sai Pavan Kumar Pakala, Muthukumaran Raveendiran
-
Publication number: 20230205596Abstract: A data store system may include at least one storage device to store a plurality of data and at least one processor with access to the storage device. The at least one processor may receive a plurality of features associated with an environment. The at least one processor may further generate a state representation of the environment based on the plurality of features. The at least one processor may further generate a plurality of predicted future states of the environment based on the state representation. The at least one processor may further generate at least one action to be performed by the environment based on the plurality of predicted future states. The at least one processor may provide the at least one action to the environment to be performed. A method and computer-readable medium are also disclosed.Type: ApplicationFiled: November 17, 2022Publication date: June 29, 2023Applicant: Teradata US, Inc.Inventors: Naveen Thaliyl Sankaran, Lovlean Arora, Sourabh Maity, Stephen Andrew Brobst, Bhashyam Ramesh, Douglas P. Brown
-
Patent number: 11645280Abstract: A function reference for a function is identified in a query. A plurality of processing environments that can provide the function is identified. Function costs for the function to process in the processing environments are obtained. Input data transfer costs are acquired for providing input data identified in the query to each of the functions. A specific one of the functions from a specific processing environment is selected based on the function costs and the input data transfer costs. A query execution plan for executing the query with the specific function is generated. The query execution plan is provided to a database engine for execution.Type: GrantFiled: December 20, 2017Date of Patent: May 9, 2023Assignee: Teradata US, Inc.Inventors: John Mark Morris, Bhashyam Ramesh
-
Patent number: 11625403Abstract: In some examples, a database system includes a memory to store a predicate-object name cache, where the predicate-object name cache contains predicates mapped to respective object names. The database system further includes at least one processor to receive a query containing a given predicate, identify, based on accessing the predicate-object name cache, one or more object names indicated by the predicate-object name cache as being relevant for the given predicate, retrieve one or more objects identified by the one or more object names from a remote data store, and process the query with respect to data records of the one or more objects retrieved from the remote data store.Type: GrantFiled: October 30, 2020Date of Patent: April 11, 2023Assignee: Teradata US, Inc.Inventors: Rangavajjula K N Sai Krishna, Chandrasekhar Tekur, Bhashyam Ramesh
-
Patent number: 11567941Abstract: A database system receives a query and determines that the query includes an inner join between a parent table and a child table. The database system determines that the following relationships exists between the parent table and the child table: referential integrity (“RI”) between a primary key attribute (pk) in the parent table and a foreign key attribute (fk) in the child table and a temporal relationship constraint (“TRC”) between a period attribute in the parent table and a TRC-attribute in the child table. The database system determines that the query satisfies non-temporal join elimination conditions and temporal join elimination conditions and that the query contains no other qualification conditions on the parent table's period attribute and eliminates the inner join when planning execution of the query.Type: GrantFiled: October 23, 2020Date of Patent: January 31, 2023Assignee: Teradata US, Inc.Inventors: Jaiprakash G Chimanchode, Bhashyam Ramesh, Stephen A Brobst, Pratik Patodi, Dhrubajyoti Roy, Sai Pavan Kumar Pakala
-
Patent number: 11531657Abstract: A data store system may include at least one storage device to store a plurality of data and at least one processor with access to the storage device. The at least one processor may receive a plurality of features associated with an environment. The at least one processor may further generate a state representation of the environment based on the plurality of features. The at least one processor may further generate a plurality of predicted future states of the environment based on the state representation. The at least one processor may further generate at least one action to be performed by the environment based on the plurality of predicted future states. The at least one processor may provide the at least one action to the environment to be performed. A method and computer-readable medium are also disclosed.Type: GrantFiled: November 13, 2019Date of Patent: December 20, 2022Assignee: Teradata US, Inc.Inventors: Naveen Thaliyil Sankaran, Lovlean Arora, Sourabh Maity, Jaiprakash G. Chimanchode, Stephen Andrew Brobst, Bhashyam Ramesh, Douglas P. Brown
-
Patent number: 11423002Abstract: In some examples, a database system includes a plurality of processing engines to process data for database operations, and instructions executable on at least one processor to insert first data into first objects stored in a remote data store coupled to the database system over a network, and select, based on a size of the first data, a first partition level from a plurality of different partition levels to associate with the first objects. Different partition levels define different quantities of hash buckets that correspond to different distributions of objects across the plurality of processing engines. The first partition level is associated with the first objects.Type: GrantFiled: December 31, 2020Date of Patent: August 23, 2022Assignee: Teradata US, Inc.Inventors: Michael Warren Watzke, Bhashyam Ramesh
-
Publication number: 20220207014Abstract: In some examples, a database system includes a plurality of processing engines to process data for database operations, and instructions executable on at least one processor to insert first data into first objects stored in a remote data store coupled to the database system over a network, and select, based on a size of the first data, a first partition level from a plurality of different partition levels to associate with the first objects. Different partition levels define different quantities of hash buckets that correspond to different distributions of objects across the plurality of processing engines. The first partition level is associated with the first objects.Type: ApplicationFiled: December 31, 2020Publication date: June 30, 2022Inventors: Michael Warren Watzke, Bhashyam Ramesh
-
Publication number: 20220197902Abstract: In some examples, a database system includes a plurality of processing engines to access data over a network from a data store. In response to a join query to join a plurality of tables, a first processing engine retrieves tuples of a first table from a subset of objects of the data store, and adds content of the retrieved tuples to an in-memory table, where the objects are range partitioned across the plurality of processing engines based on respective ranges of values of at least one join attribute in the join query. The first processing engine retrieves, from the data store, tuples of a second table of the plurality of tables based on a range of values of the at least one join attribute in the retrieved tuples of the first table. The first processing engine performs an in-memory join of the plurality of tables based on the retrieved tuples of the second table and the in-memory table.Type: ApplicationFiled: December 21, 2020Publication date: June 23, 2022Inventors: Michael Warren Watzke, Bhashyam Ramesh
-
Publication number: 20220138200Abstract: In some examples, a database system includes a memory to store a predicate-object name cache, where the predicate-object name cache contains predicates mapped to respective object names. The database system further includes at least one processor to receive a query containing a given predicate, identify, based on accessing the predicate-object name cache, one or more object names indicated by the predicate-object name cache as being relevant for the given predicate, retrieve one or more objects identified by the one or more object names from a remote data store, and process the query with respect to data records of the one or more objects retrieved from the remote data store.Type: ApplicationFiled: October 30, 2020Publication date: May 5, 2022Inventors: Rangavajjula K N Sai Krishna, Chandrasekhar Tekur, Bhashyam Ramesh
-
Patent number: 11275737Abstract: In some examples, a system stores data in a logically disconnected data store. In response to a query for data in the data store, the system accesses metadata of objects stored in the data store, the metadata including information of a respective range of values of at least one clustering attribute in data contained in each respective object of the objects. The system partitions the objects across the plurality of processing engines based on the information of the respective ranges of values of the at least one clustering attribute in the data contained in the objects. The system assigns, based on the partitioning, the objects to respective processing engines of the plurality of processing engines.Type: GrantFiled: December 19, 2019Date of Patent: March 15, 2022Assignee: Teradata US, Inc.Inventors: Michael Warren Watzke, Bhashyam Ramesh
-
Patent number: 11023469Abstract: A database includes a Value List Compression (VLC) predicate evaluator. A table identified in a query that is being processed is identified as having compressed data values. The predicate evaluator compares a query predicate of the query against actual decompressed values noted in a dictionary for the table and the predicate evaluator maintains a bitmap for selective ones of the actual values that satisfy the query predicate. The matched bitmap positions are processed against an index maintained in the table for the actual values to provide selective decompressed table entries as results for the query.Type: GrantFiled: November 29, 2017Date of Patent: June 1, 2021Assignee: Teradata US, Inc.Inventors: Bhashyam Ramesh, Tirupathi Prabhu Bellapukonda, Philip Jason Benton, Donald Raymond Pederson
-
Patent number: 10997175Abstract: 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.Type: GrantFiled: June 26, 2017Date of Patent: May 4, 2021Assignee: Teradata US, Inc.Inventors: Bhashyam Ramesh, Tirupathi Prabhu Bellapukonda, Mohan Kumar KJ, Vamshi Krishna Vangapalli
-
Publication number: 20210034626Abstract: In some examples, a system stores data in a logically disconnected data store. In response to a query for data in the data store, the system accesses metadata of objects stored in the data store, the metadata including information of a respective range of values of at least one clustering attribute in data contained in each respective object of the objects. The system partitions the objects across the plurality of processing engines based on the information of the respective ranges of values of the at least one clustering attribute in the data contained in the objects. The system assigns, based on the partitioning, the objects to respective processing engines of the plurality of processing engines.Type: ApplicationFiled: December 19, 2019Publication date: February 4, 2021Inventors: Michael Warren Watzke, Bhashyam Ramesh
-
Patent number: 10891290Abstract: Search spaces for obtaining query execution plans for a query are identified. The search spaces are subdivided into sub-search spaces. Searches are initiated within the sub search spaces and plan costs for competing query execution plans are noted along with search costs associated with continuing to search the sub-search spaces. A decision is made based on the plan costs and search costs for utilizing search resources as to when to terminate the searching and to select the then-existing lowest cost query execution plan as an optimal query execution plan for executing the query.Type: GrantFiled: December 22, 2017Date of Patent: January 12, 2021Assignee: Teradata US, Inc.Inventors: John Mark Morris, Bhashyam Ramesh, Donald Raymond Pederson, Kuorong Chiang
-
Publication number: 20210004675Abstract: A method is provided for predicting workload group metrics of a workload management system of a database system. The method comprises predicting a future workload group metric for a plurality of workload groups based upon historical user-load patterns. Each workload group has a priority that is different from priority of other workload groups.Type: ApplicationFiled: December 30, 2019Publication date: January 7, 2021Applicant: Teradata US, Inc.Inventors: Bhashyam Ramesh, Naveen Thaliyil Sankaran, Lovlean Arora, Sourabh Maity, Jaiprakash G. Chimanchode, Douglas P. Brown
-
Patent number: 10713255Abstract: A method for spooling data for use in joining a small table with a large table in a relational database system. The method analyzes a join condition for combining records from the small and large tables, selects qualified rows from the large table, and writes the qualified rows to a spool file. The spool file includes a first partition containing hash values of all bind terms for the join condition; a second partition including a join column with a best selective bind term; and at least one additional partition including additional join columns used in bind terms. The partitions are grouped together within a container row in the spool file, and multiple container rows are written together within a super-container row in the spool file.Type: GrantFiled: June 23, 2017Date of Patent: July 14, 2020Assignee: Teradata US, Inc.Inventors: Bhashyam Ramesh, Venkata Ramana Jyothula, Muthukumaran Raveendiran, Jaya Saxena, Michael Warren Watzke