Patents Assigned to Teradata US, Inc.
  • Patent number: 8359495
    Abstract: A system and method for using failure casting to manage failures in a computer system. In accordance with an embodiment, the system uses a failure casting hierarchy to cast failures of one type into failures of another type. In doing this, the system allows incidents, problems, or failures to be cast into a (typically smaller) set of failures, which the system knows how to handle. In accordance with a particular embodiment, failures can be cast into a category that is considered reboot-curable. If a failure is reboot-curable then rebooting the system will likely cure the problem. Examples include hardware failures, and reboot-specific methods that can be applied to disk failures and to failures within clusters of databases. The system can even be used to handle failures that were hitherto unforeseen—failures can be cast into known failures based on the failure symptoms, rather than any underlying cause.
    Type: Grant
    Filed: March 27, 2007
    Date of Patent: January 22, 2013
    Assignee: Teradata US, Inc.
    Inventors: George Candea, Mayank Bawa, Anastasios Argyros
  • Patent number: 8359229
    Abstract: An improved method for forecasting and modeling product demand for a product during promotional periods. The forecasting methodology employs information about prior promotional demand forecasts, prior product sales, and the data dispersion and the number of data samples in a product class hierarchy to dynamically determine the optimal level at which to compute promotional uplift coefficients. The methodology calculates confidence values for promotional uplift coefficients for products at each level in a merchandise product hierarchy, and uses the confidence values as a filter to determine the optimal level for promotional uplift aggregation.
    Type: Grant
    Filed: September 28, 2007
    Date of Patent: January 22, 2013
    Assignee: Teradata US, Inc.
    Inventors: Arash Bateni, Edward Kim, Philip Liew, Jean-Philippe Vorsanger
  • Patent number: 8352911
    Abstract: Techniques for constructing and using run-time JAVA Archive (JAR) files for JAVA Stored Procedures (JSPs) are provided. JSP methods referenced by an application via a plurality of different JAR files are extracted and packed into a single packed JAR file. When the application tries to execute a JSP, the attempt to process the JSP methods is redirected to a new JSP that calls the single packed JAR file.
    Type: Grant
    Filed: November 21, 2007
    Date of Patent: January 8, 2013
    Assignee: Teradata US, Inc.
    Inventors: John Douglas Frazier, Like Gao, Yu Long, Michael Leon Reed
  • Patent number: 8335783
    Abstract: Techniques for collecting statistics of column data or R-Tree indexes are provided. A distributed database system includes a plurality of processing nodes controlling portions of spatial data. The nodes are instructed to create minimum bounding rectangles (MBR's) for their spatial data or R-Trees. The individual MBR's are merged and reformatted into a grid of equally sized cells. Each processing node is provided a copy of the grid to update based on statistics of each processing node's spatial data for a target table. The updated grids are then merged into a single grid and used by an optimizer to evaluate queries before the queries are executed.
    Type: Grant
    Filed: December 28, 2010
    Date of Patent: December 18, 2012
    Assignee: Teradata US, Inc.
    Inventor: Gregory Howard Milby
  • 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: 8332373
    Abstract: A database system constructs representation for predicate expressions invoking user-defined routines. A first representation is constructed if an indicator has a first value, and a second representation is constructed if the indicator has a second value. Based on which representation is used, an optimizer in the database system selects use of indexing and/or statistics and/or other performance-enhancement features in generating a query plan.
    Type: Grant
    Filed: December 18, 2002
    Date of Patent: December 11, 2012
    Assignee: Teradata US, Inc.
    Inventor: Gregory H. Milby
  • Patent number: 8321420
    Abstract: A method, computer program, and database system for performing a request on a table associated with an index are disclosed. A database contains a table, an index, and a partition elimination list and accepts a query. A table has one or more rows stored in one or more partitions. The index contains index entries, each of which references a row in a partition, where the row is in the table. The query has a first and a second condition. The partition elimination list is populated with partitions based on the first condition of the query. Only index entries that are identified by the request because of the second condition and that reference partitions that are not eliminated by the partition elimination list are read.
    Type: Grant
    Filed: December 10, 2003
    Date of Patent: November 27, 2012
    Assignee: Teradata US, Inc.
    Inventors: Paul L. Sinclair, Ganesan Gopal
  • Patent number: 8311772
    Abstract: Apparatus, systems, and methods may operate to acquire an original data set comprising a series of data points having an independent portion and a dependent portion, the dependent portion representing a measure of device performance that depends on at least one device characteristic represented by the independent portion. Additional activity may include identifying outlier data points in the series by determining, in comparison with all other members of the series, whether the outlier data points conform to a known trend of the series; transforming the original data set into a transformed data set by removing the outlier data points from the series; and publishing the transformed data set. Other apparatus, systems, and methods are disclosed.
    Type: Grant
    Filed: December 21, 2009
    Date of Patent: November 13, 2012
    Assignee: Teradata US, Inc.
    Inventor: Daniel Hoffman
  • Patent number: 8312000
    Abstract: For a given pool of database requests, a database system generates an integrated execution plan for multiple ones of the database requests in the pool. The database system determines whether to execute the integrated execution plan or individual execution plans corresponding to the respective multiple database queries. The determining is based on one or more criteria including performance goals corresponding to the respective multiple database requests.
    Type: Grant
    Filed: October 20, 2010
    Date of Patent: November 13, 2012
    Assignee: Teradata US, Inc.
    Inventors: Louis M. Burger, Thomas P. Julien
  • Patent number: 8311989
    Abstract: Query processing statistics are logged in a multi-database system containing a plurality of system databases. A plurality of query log entries generated using information regarding the execution of a plurality of queries are temporarily stored in a database query log (DBQL). The information is received from a plurality of system databases. Each query log entry is generated using information regarding execution of one query by the plurality of system databases. Each query log entry includes a field identifying a system database that was the source of the information in that entry. An express request is created upon occurrence of a triggering event. The express request contains a subset of the query log entries temporarily stored in the DBQL cache. The created express request is transmitted to a plurality of system databases and the contents of the transmitted express request are stored in each of plurality of system databases to which it was transmitted.
    Type: Grant
    Filed: December 29, 2008
    Date of Patent: November 13, 2012
    Assignee: Teradata US, Inc.
    Inventors: John Mark Morris, Douglas P. Brown
  • Patent number: 8307017
    Abstract: Methods, computer programs, and database systems for protecting one or more database objects are disclosed. The methods include designating one or more database objects for protection and characterizing one or more data storage units by a set of dimensions. The method include, for one or more database objects designated for protection: selecting one or more data storage units to store protection information for the database object based on one or more dimensions, and storing protection information in the one or more selected data storage units.
    Type: Grant
    Filed: December 7, 2004
    Date of Patent: November 6, 2012
    Assignee: Teradata US, Inc.
    Inventor: J. Mark Morris
  • Patent number: 8306946
    Abstract: A method, apparatus, and article of manufacture provide the ability to deploy a data management application to a target computer system. Metadata for a master data management (MDM) application is stored in a deployment database. The metadata is representative of business rules and process workflows that manage business data from multiple sources and a model definition for a model for a central business database. Configuration settings for the MDM application are stored in the deployment database. The metadata and configuration settings are retrieved from the deployment database. Installation instructions of the MDM application are confirmed based on input into a graphical user interface. The master data management application is installed on the target computer system based on the installation instructions, metadata, and configuration settings.
    Type: Grant
    Filed: September 10, 2009
    Date of Patent: November 6, 2012
    Assignee: Teradata US, Inc.
    Inventors: Neelesh V. Bansode, Santosh K. Singh, Carl L. Christofferson, Thomas K. Ryan, Brian J. Wasserman
  • Patent number: 8301652
    Abstract: A method executed by a plurality of processors in a database system to implement temporal aggregate queries. The database system has a temporal table. A plurality of consecutive temporal partitions are defined and allocated to the respective processors. A query is received to aggregate at least one attribute of the temporal table. In response to the query, a plurality of timestamps are identified in the temporal table, the respective timestamps are allocated to the respective temporal partitions, the value changes in the at least one attribute at the plural timestamps are computed within each partition using the respective processors to which each partition is allocated, and the value changes within each partition are aggregated using the respective processors to which each partition is allocated to produce an aggregate value for the query.
    Type: Grant
    Filed: September 3, 2008
    Date of Patent: October 30, 2012
    Assignee: Teradata US, Inc.
    Inventor: Xin Zhou
  • 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: 8301657
    Abstract: A method and computer program are disclosed for increasing the efficiency of a row sequential database operation by transforming procedural logic, which applies serially to one row at a time, into set logic, which applies in parallel to many rows or all rows at once. The method includes dividing the row sequential operation into a plurality of portions. A hierarchy is determined for the portions. A set level operation is generated in accordance with the portion hierarchy.
    Type: Grant
    Filed: May 9, 2002
    Date of Patent: October 30, 2012
    Assignee: Teradata US, Inc.
    Inventor: George J. Coleman
  • Patent number: 8290913
    Abstract: Techniques for multi-variable analysis at an aggregate level are provided. Two or more datasets having different statistical data distributions and which are not capable of being aggregated are acquired. The values for variables in the two or more datasets are normalized to produce a single integrated dataset of normalized values. The normalized values are then used to produce a demand model that represents and integrates multiple disparate products or services from the two or more datasets into a single demand model.
    Type: Grant
    Filed: December 31, 2007
    Date of Patent: October 16, 2012
    Assignee: Teradata US, Inc.
    Inventors: Arash Bateni, Edward Kim
  • Patent number: 8290935
    Abstract: A method, computer program, and database system are disclosed for optimizing a query of a table based on one or more values in one or more columns of the table. The method includes repeating the following steps for a series of rows in the table and optimizing an execution plan for the query based at least in part on a calculated number of rows per unique value. One or more values for the one or more columns are read. The read values are determined to be different from all previously read values in some cases. When the read values are different, the one or more values are recorded in a data structure corresponding to the result of applying a hash function to the one or more values.
    Type: Grant
    Filed: May 27, 2004
    Date of Patent: October 16, 2012
    Assignee: Teradata US, Inc.
    Inventors: Arthur Vargas Lopes, Pradeep Sathyanarayan
  • Publication number: 20120259892
    Abstract: A vendor is authenticated for use of a retailer's data warehouse and limited access rights are assigned to the vendor for access. The vendor accesses a graphical user interface (GUI) to select an available analysis module for execution against the data warehouse. Schemas are presented in the GUI based on the access rights, and specific schema selections are made by the vendor. The analysis module is then configured and executed against the data warehouse and filtered results are presented to the vendor; the results filtered based on the access rights assigned to the vendor.
    Type: Application
    Filed: April 6, 2011
    Publication date: October 11, 2012
    Applicant: Teradata US, Inc.
    Inventors: Rajeswara Rao Kottu, Corey Antwan Parham, Sreenath Madasu, Jason Keith Figge
  • Patent number: 8285582
    Abstract: A forecast response factor (RF) determines how quickly product demand forecasts should react to recent changes in demand. When a product sales pattern changes (e.g., a sudden increase in product demand), RF is adjusted accordingly to adjust the forecast responsiveness. The present subject matter provides automatic calculation of the RF, based at least in part on the nature of the product sales (autocorrelation) and the status of recent forecasts (bias).
    Type: Grant
    Filed: December 16, 2008
    Date of Patent: October 9, 2012
    Assignee: Teradata US, Inc.
    Inventors: Arash Bateni, Edward Kim, Philippe Hamel, Stephen Szu Chang
  • Patent number: 8285709
    Abstract: In one embodiment, a method includes concurrently executing a set of multiple queries, through a processor, to improve a resource usage within a data warehouse system. The method also includes permitting a group of users of the data warehouse system to simultaneously run a set of queries. In addition, the method includes applying a high-concurrency query operator to continuously optimize a large number of concurrent queries for a set of highly concurrent dynamic workloads.
    Type: Grant
    Filed: May 12, 2010
    Date of Patent: October 9, 2012
    Assignee: Teradata US, Inc.
    Inventors: George Candea, Neoklis Polyzotis