Patents Assigned to Teradata US, Inc.
-
Patent number: 8359495Abstract: 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: GrantFiled: March 27, 2007Date of Patent: January 22, 2013Assignee: Teradata US, Inc.Inventors: George Candea, Mayank Bawa, Anastasios Argyros
-
Patent number: 8359229Abstract: 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: GrantFiled: September 28, 2007Date of Patent: January 22, 2013Assignee: Teradata US, Inc.Inventors: Arash Bateni, Edward Kim, Philip Liew, Jean-Philippe Vorsanger
-
Techniques for constructing and using run-time JAVA archives (JAR) for JAVA Stored Procedures (JSPS)
Patent number: 8352911Abstract: 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: GrantFiled: November 21, 2007Date of Patent: January 8, 2013Assignee: Teradata US, Inc.Inventors: John Douglas Frazier, Like Gao, Yu Long, Michael Leon Reed -
Patent number: 8335783Abstract: 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: GrantFiled: December 28, 2010Date of Patent: December 18, 2012Assignee: Teradata US, Inc.Inventor: Gregory Howard Milby
-
Patent number: 8335772Abstract: 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: GrantFiled: November 12, 2008Date of Patent: December 18, 2012Assignee: Teradata US, Inc.Inventors: Bhashyam Ramesh, Manjula Koppuravuri
-
Patent number: 8332373Abstract: 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: GrantFiled: December 18, 2002Date of Patent: December 11, 2012Assignee: Teradata US, Inc.Inventor: Gregory H. Milby
-
Patent number: 8321420Abstract: 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: GrantFiled: December 10, 2003Date of Patent: November 27, 2012Assignee: Teradata US, Inc.Inventors: Paul L. Sinclair, Ganesan Gopal
-
Patent number: 8311772Abstract: 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: GrantFiled: December 21, 2009Date of Patent: November 13, 2012Assignee: Teradata US, Inc.Inventor: Daniel Hoffman
-
Patent number: 8312000Abstract: 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: GrantFiled: October 20, 2010Date of Patent: November 13, 2012Assignee: Teradata US, Inc.Inventors: Louis M. Burger, Thomas P. Julien
-
Patent number: 8311989Abstract: 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: GrantFiled: December 29, 2008Date of Patent: November 13, 2012Assignee: Teradata US, Inc.Inventors: John Mark Morris, Douglas P. Brown
-
Patent number: 8307017Abstract: 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: GrantFiled: December 7, 2004Date of Patent: November 6, 2012Assignee: Teradata US, Inc.Inventor: J. Mark Morris
-
Patent number: 8306946Abstract: 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: GrantFiled: September 10, 2009Date of Patent: November 6, 2012Assignee: Teradata US, Inc.Inventors: Neelesh V. Bansode, Santosh K. Singh, Carl L. Christofferson, Thomas K. Ryan, Brian J. Wasserman
-
Patent number: 8301652Abstract: 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: GrantFiled: September 3, 2008Date of Patent: October 30, 2012Assignee: Teradata US, Inc.Inventor: Xin Zhou
-
Patent number: 8301934Abstract: 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: GrantFiled: April 17, 2009Date of Patent: October 30, 2012Assignee: Teradata US, Inc.Inventors: Bhashyam Ramesh, Manjula Koppuravuri
-
Patent number: 8301657Abstract: 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: GrantFiled: May 9, 2002Date of Patent: October 30, 2012Assignee: Teradata US, Inc.Inventor: George J. Coleman
-
Patent number: 8290913Abstract: 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: GrantFiled: December 31, 2007Date of Patent: October 16, 2012Assignee: Teradata US, Inc.Inventors: Arash Bateni, Edward Kim
-
Patent number: 8290935Abstract: 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: GrantFiled: May 27, 2004Date of Patent: October 16, 2012Assignee: Teradata US, Inc.Inventors: Arthur Vargas Lopes, Pradeep Sathyanarayan
-
Publication number: 20120259892Abstract: 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: ApplicationFiled: April 6, 2011Publication date: October 11, 2012Applicant: Teradata US, Inc.Inventors: Rajeswara Rao Kottu, Corey Antwan Parham, Sreenath Madasu, Jason Keith Figge
-
Patent number: 8285582Abstract: 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: GrantFiled: December 16, 2008Date of Patent: October 9, 2012Assignee: Teradata US, Inc.Inventors: Arash Bateni, Edward Kim, Philippe Hamel, Stephen Szu Chang
-
Patent number: 8285709Abstract: 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: GrantFiled: May 12, 2010Date of Patent: October 9, 2012Assignee: Teradata US, Inc.Inventors: George Candea, Neoklis Polyzotis