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).

  • Patent number: 9141632
    Abstract: Demographics for data are determined. A compression ratio (“CR”) is determined for each of a plurality of compression techniques. CR is a size of the data before compression divided into a predicted size of the data after compression. The predicted size of the data after compression is determined as a function of the determined demographics. An access efficiency of each of the compression techniques is determined as a function of the determined demographics. The compression techniques are ranked by CR and access efficiency. A compression technique is selected based on the ranking. The data is compressed using the selected compression technique. The compressed data is stored.
    Type: Grant
    Filed: December 19, 2012
    Date of Patent: September 22, 2015
    Assignee: Teradata US, Inc.
    Inventor: Bhashyam Ramesh
  • Patent number: 9110947
    Abstract: A database system may process multiple column-oriented tasks in parallel for a database being stored according to a row-partitioning protocol. The database system may determine when the query should process the column-oriented task serially or in parallel. For parallel processing, the database system may generate processing tasks for each unique column-oriented task contained in the query used to retrieve column data and to process the column data according to the column-oriented tasks requested. A method of operating the database system may determine that multiple column-oriented tasks included in a query are to be processed in parallel. The method may further include generating a processing task for each unique column-oriented task included in the query. The method may further include performing the column-oriented tasks in parallel based on the processing threads. The method may implement various considerations in determining to process to the column-oriented tasks in parallel.
    Type: Grant
    Filed: September 14, 2012
    Date of Patent: August 18, 2015
    Assignee: Teradata US, Inc.
    Inventors: Michael Watzke, Bhashyam Ramesh
  • Patent number: 8725720
    Abstract: A query is received. It is determined that the query includes an inner join between a parent table and a child table. It is determined that the following relationships exist 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, where “attribute” is defined to mean one or more columns; and a temporal relationship constraint (“TRC”) between a period attribute in the parent table and a TRC-attribute in the child table, the TRC-attribute being a date or time attribute. It is determined that the query does not access any attribute in the parent table other than the pk. It is determined that the query specifies an equality predicate of the form pk=fk. It is determined that the query specifies a condition that requires the TRC-attribute value to be contained in the parent table's period attribute duration.
    Type: Grant
    Filed: November 29, 2010
    Date of Patent: May 13, 2014
    Assignee: Teradata US, Inc.
    Inventors: Bhashyam Ramesh, Jaiprakash G. Chimanchode, Michael W. Watzke
  • Patent number: 8706769
    Abstract: A temporal target table stored on a computer is scanned using the computer. The temporal target table has a ValidTime dimension and a value dimension. A qualifying-row having a value dimension having a value equal to a value of a value dimension in a row-to-be-inserted is found during the scanning. The row-to-be-inserted has a ValidTime dimension and the value dimension. The qualifying-row is processed. The row-to-be-inserted is inserted in the temporal target table. A ValidTime dimension of the inserted row-to-be-inserted is set to be as the union of the ValidTime dimension of the row-to-be-inserted and the ValidTime dimension of the qualifying-row.
    Type: Grant
    Filed: December 31, 2009
    Date of Patent: April 22, 2014
    Assignee: Teradata US, Inc.
    Inventors: Like Gao, Bhashyam Ramesh, John A. Greene, Michael Leon Reed
  • Patent number: 8666956
    Abstract: A SEQUENCED request a) to apply a temporal Source table to a temporal Target table under a predicate is received. The Source table includes a plurality of rows that qualify to apply to a single Target table row under the predicate. The predicate specifies a Source table join column. Each of the plurality of Source table rows and the single Target table row include a ValidTime dimension. The plurality of Source table rows is b) ordered by the Source table join column and a period-to-be-modified. The next of the ordered plurality of Source table rows is c) applied by determining that the Target table row has a TransactionTime and, in response, closing out the TransactionTime of the Target table row. Applying the next of the ordered plurality of Source table rows includes identifying an RDIFF range as the period-to-be-modified of the Source table row being applied that is later than the ValidTime range of the single Target table row.
    Type: Grant
    Filed: December 16, 2010
    Date of Patent: March 4, 2014
    Assignee: Teradata US, Inc.
    Inventors: Bhashyam Ramesh, Manjula Koppuravuri
  • Patent number: 8645425
    Abstract: A method, computer program and database system are disclosed for guiding the development of workload group definition (WD) classifications for a database system having resources. WD classification information is provided where a workload group is a set of system requests having characteristics defined by a WD and a WD classification identifies one or more WDs with similar performance requirements. If WD classification is not acceptable, one or more of the following functions is performed until WD classification is acceptable: (a) splitting one or more WDs; and (b) merging two or more WDs.
    Type: Grant
    Filed: February 25, 2004
    Date of Patent: February 4, 2014
    Assignee: Teradata US, Inc.
    Inventors: Douglas P. Brown, Anita Richards, Bhashyam Ramesh
  • Patent number: 8635608
    Abstract: There is provided a method, system and computer program for updating at least one component in a multi-component software application. The method includes receiving application data describing characteristics of the software application, receiving update data describing at least one update applicable to the software application and reviewing the application data and update data to determine whether the at least one update is applied to the software application.
    Type: Grant
    Filed: September 4, 2007
    Date of Patent: January 21, 2014
    Assignee: Teradata US, Inc.
    Inventors: Bhashyam Ramesh, Michael Watzke
  • Patent number: 8621482
    Abstract: A method, computer program, and database system are disclosed. A plurality of instances of a request to a database system are received. All instances of the request have a same set of variables to use in executing the request. The values of the variables are supplied by data in a data source. A specific plan for executing one instance of the request is generated. Generating the specific plan includes taking into account data in the data source. The specific plan is executed on the database system. A system run-time metric and a parsing time for executing the specific plan are captured and saved. A generic plan is generated and cached based on a comparison of the system run-time metric and the parsing time for executing the specific plan.
    Type: Grant
    Filed: September 5, 2008
    Date of Patent: December 31, 2013
    Assignee: Teradata US, Inc.
    Inventors: Bhashyam Ramesh, Donald Pederson, Manjula Koppuravuri
  • Patent number: 8606749
    Abstract: A request is received at a computer programmed as a database system. The request is a request selected from the group consisting of a query and a utility. A business concept is associated with the request. The business concept is a business concept selected from the group consisting of “who” information defining the source of the request, “what” information defining the processing to be performed by the request, “where” information defining a database object that the request will affect. The computer maps the received request to a database feature setting by mapping the business concept associated with the request to a workload. The workload is defined by a workload definition including a workload classification attribute that maps to the business concept of the request, a workload throttling attribute that defines conditions under which requests assigned to the workload are throttled. Submission of the request to the database system for processing is delayed based on the workload definition.
    Type: Grant
    Filed: February 8, 2010
    Date of Patent: December 10, 2013
    Assignee: Teradata US, Inc.
    Inventors: Douglas P. Brown, Anita Richards, Bhashyam Ramesh
  • Patent number: 8407180
    Abstract: A query is received. It is determined that the query includes an inner join between a parent table and a child table. It is determined that the following relationships exist 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, where “attribute” is defined to mean one or more columns, and a temporal relationship constraint (“TRC”) between a period attribute in the parent table and a TRC-attribute in the child table, the TRC-attribute being a date or time attribute. It is determined that the query does not access any attribute in the parent table other than the pk. It is determined that the query specifies an equality predicate of the form pk=fk. It is determined that the query selects a snapshot from the parent using a predicate of the form parent.[period attribute] contains a point in time (t1).
    Type: Grant
    Filed: November 29, 2010
    Date of Patent: March 26, 2013
    Assignee: Teradata US, Inc.
    Inventors: Bhashyam Ramesh, Stephen A. Brobst
  • Patent number: 8396860
    Abstract: A computer receives a query for optimization. The query includes a SEQUENCED join between a temporal parent table and a temporal child table. The parent table has one or more rows. The child table has one or more rows. The parent table has a Primary Key (“PK”) column having a value for each row. The parent table has a temporal dimension having a value for each row. The child table has a Foreign Key (“FK”) column having a value for each row. The child table has a temporal dimension. The child table's temporal dimension has a value for each row. The computer determines that the query, the parent table, the child table, and the join satisfy a set of CURRENT temporal join elimination criteria. The computer determines that the query, the parent table, the child table, and the join satisfy a set of SEQUENCED temporal join elimination criteria. In response, the computer eliminates the join from the query to produce an optimized form of the query.
    Type: Grant
    Filed: December 14, 2010
    Date of Patent: March 12, 2013
    Assignee: Teradata US, Inc.
    Inventors: Bhashyam Ramesh, Jalprakash G. Chimanchode, Sai Pavan Kumar Pakala
  • Patent number: 8346714
    Abstract: A temporal table is present in an active data warehouse (“ADW”) on a massively parallel processing system (“MPP system”). The MPP system includes a plurality of units of parallelism. Each of the plurality of units of parallelism maintains its own moving system time separate from that of the other units of parallelism. A load-job for the ADW is accepted. The load-job includes a requested modification to an identified row. The identified row is stored in the temporal table on a first of the MPP system's units of parallelism. The requested modification is implemented on the identified row. The identified row is timestamped with the moving system time maintained by the first of the MPP system's units of parallelism at the time of the implementation of the modification.
    Type: Grant
    Filed: December 17, 2009
    Date of Patent: January 1, 2013
    Assignee: Teradota US, Inc.
    Inventors: Bhashyam Ramesh, Donald Pederson
  • Patent number: 8335772
    Abstract: A method, system, and computer program for optimizing execution of a DML statement on a temporal database are disclosed. A first execution package is provided to an execution engine. The first execution package includes a plurality of operations to be executed if the contents of a row in a table in the temporal database indicate the row has a first temporal condition. A second execution package is provided to the execution engine. The second execution package includes a plurality of operations to be executed if the contents of the row in the table in the temporal database indicate the row has a second temporal condition. The execution engine is run to produce a result. The result is saved.
    Type: Grant
    Filed: November 12, 2008
    Date of Patent: December 18, 2012
    Assignee: Teradata US, Inc.
    Inventors: Bhashyam Ramesh, Manjula Koppuravuri
  • Patent number: 8301934
    Abstract: A base table temporal row affected by a transaction is timestamped. The temporal row has a row ID. The temporal row in the base table is modified according to the transaction. The row ID for the modified temporal row is associated with an identifier for the transaction in a temporal work table. Upon committing the transaction: the temporal work table is searched to determine the row ID of the temporal row modified by the transaction, and a commit-time is saved into the temporal row identified by the row ID.
    Type: Grant
    Filed: April 17, 2009
    Date of Patent: October 30, 2012
    Assignee: Teradata US, Inc.
    Inventors: Bhashyam Ramesh, Manjula Koppuravuri
  • Patent number: 8280867
    Abstract: A method, computer program, and database system are disclosed for identifying a second source of a request sent to a database management system by a first source. A database message is received from the first source. The database message includes a second value for a second source-identifying parameter. The second value identifies a second source. The second value for the second source-identifying parameter is stored in a log.
    Type: Grant
    Filed: October 20, 2005
    Date of Patent: October 2, 2012
    Assignee: Teradata US, Inc.
    Inventors: Douglas P. Brown, Bhashyam Ramesh, Anita Richards
  • Patent number: 8250064
    Abstract: A computer system programmed as a database receives a query Q1. Q1 includes a predicate. The predicate includes a reference to a current timestamp of time TT1. The database has R data structures. The computer system creates a plan, Plan 1, to execute Q1. Plan 1 includes the identification of a first set of data structures, P1, to be accessed in executing Plan 1, at the current timestamp of time TT1. The number of data structures in P1 is less than R. The computer system determines that Plan 1 is valid for a period of time. The computer system stores in a cache Plan 1 and an indication that Plan 1 is valid for the period of time.
    Type: Grant
    Filed: April 6, 2010
    Date of Patent: August 21, 2012
    Assignee: Teradata US, Inc.
    Inventors: Bhashyam Ramesh, Manjula Koppuravuri
  • Patent number: 8214371
    Abstract: A method, computer program, database system and data structure for indexing spatial objects are disclosed. Each spatial object has a location in an n-dimensional space. The indexing is for use in a partitioned parallel environment including P partitions. Each partition resides on one or more parallel processing systems. The n-dimensional space is divided into quad-tree cells (QTCs) in a quad-tree structure. Each spatial object is assigned to one or more QTCs based on the location of the spatial object in the n-dimensional space. A spatial object index entry is created which includes a designator for the QTC to which the spatial object is assigned and a pointer to the spatial object. The entries are sorted by their QTC numbers into a list. The list of entries is divided into P substantially equal parts. The entries associated with each part are stored in a different one of the P partitions.
    Type: Grant
    Filed: July 18, 2003
    Date of Patent: July 3, 2012
    Assignee: Teradata US, Inc.
    Inventors: Bhashyam Ramesh, Michael W. Watzke
  • Patent number: 8214408
    Abstract: A method, database system and computer program are disclosed for performing a temporal join between two temporal database tables. The method includes determining a selected table intersection between a period of interest and a time period value for a selected table row, scanning an inner table for a row that matches the selected table on the join conditions and overlaps the selected table intersection, and determining the remainder time period values from the selected table intersection.
    Type: Grant
    Filed: September 29, 2008
    Date of Patent: July 3, 2012
    Assignee: Teradata US, Inc.
    Inventors: Bhashyam Ramesh, Manjula Koppuravuri, Chandrasekhar Tekur
  • Patent number: 8005836
    Abstract: A method and system for performing logical partial declustering in a shared-nothing database environment. The solution defines a partial declustering technique that can be used to dynamically adapt the declustering of base tables or intermediate result sets. The partial declustering technique is defined to limit the number of partitions (P) involved in an operation. The technique is defined to limit the operation to a subset of the system partitioning map (SPM). There are two components: the association between the data values and partitions is altered by restricting the data values to P? partition values where P? is less than P; and the actual partitions of the SPM selected are then derived based on a seed derived from a dynamic parameter, such as a session number, or a static parameter, such as a table identifier. In the case of intermediate result sets the number of P? partitions selected is a cost based decision based on the estimated number of rows in the input intermediate result sets.
    Type: Grant
    Filed: January 12, 2007
    Date of Patent: August 23, 2011
    Assignee: Teradata US, Inc.
    Inventors: Bhashyam Ramesh, Michael Watzke
  • Patent number: 8005820
    Abstract: A SQL query that includes an IN-List is optimized by utilizing an array insert to insert the IN-List into a spool and piggybacking IN-List rows into a join step.
    Type: Grant
    Filed: September 27, 2006
    Date of Patent: August 23, 2011
    Assignee: Teradata US, Inc.
    Inventors: James Carlson, Grace Au, Bhashyam Ramesh, Haiyan Chen