Patents Assigned to Teradata US, Inc.
  • Test scheduling based on historical test information
    Patent number: 8997061
    Abstract: Systems and methods are described that schedule tests based on historical test information, such as tests that validate developed or changed code. For example, the system may review the results of previously used tests, order the tests based on the results, such as based on the performance of the code during the test, and apply the tests during a testing cycle based on the order.
    Type: Grant
    Filed: May 2, 2008
    Date of Patent: March 31, 2015
    Assignee: Teradata US, Inc.
    Inventor: Steven John Davison
  • Techniques for updating join indexes
    Patent number: 8990186
    Abstract: Techniques for updating join indexes are provided. A determination is made to update date criteria in a join index query statement. The join index is parsed for current date and current time criteria. The join index is revised based on the location of the current date and current time criteria as they appear in the original join index. The revisions include new criteria that minimize the effort in maintaining and using the join index.
    Type: Grant
    Filed: December 28, 2011
    Date of Patent: March 24, 2015
    Assignee: Teradata US, Inc.
    Inventors: Xiaobin Ma, Grace Kwan-On Au, Lu Ma
  • Implementation of an extranet server from within an intranet
    Patent number: 8977691
    Abstract: A request for information or services available on an intranet may be made by users on an extranet outside the intranet. An email is generated in an external server on the extranet in response to the request for information or services, and then sent from the external server to an internal server inside the intranet. The email comprises one or more approved forms based on the request, wherein specifics of the request are embedded into the body of the email. The email is processed at the internal server, in order to generate a response to the request, wherein the response is returned by the internal server to the external server in a reply email. The reply email includes an attachment containing the results of the processing performed by the internal server. The external server allows the user to access these results via an external graphical user interface.
    Type: Grant
    Filed: June 28, 2006
    Date of Patent: March 10, 2015
    Assignee: Teradata US, Inc.
    Inventor: Ronald Fink
  • Techniques for three-step join processing on column partitioned tables
    Patent number: 8972381
    Abstract: Techniques for processing joins on column partitioned tables are provided. A query includes a first-Column Partition (CP) table joined with a second-CP table. The query is decomposed into a three-step process and rewritten and processed.
    Type: Grant
    Filed: December 26, 2012
    Date of Patent: March 3, 2015
    Assignee: Teradata US, Inc.
    Inventors: Mohammed Al-Kateb, Grace Kwan-On Au, Sanjay Sukumaran
  • Managing execution of multiple requests in a job using overall deadline for the job
    Patent number: 8966493
    Abstract: A database system receives information relating to a job requested by a requestor, where the job includes a plurality of requests. Execution of the requests of the job is managed using the received information, where managing the requests includes adjusting one or more of priority settings and resource estimates for the requests.
    Type: Grant
    Filed: November 9, 2010
    Date of Patent: February 24, 2015
    Assignee: Teradata US, Inc.
    Inventors: Anita Richards, Douglas P. Brown
  • Techniques for discovering database connectivity leaks
    Patent number: 8949421
    Abstract: Techniques for discovering database connectivity leaks are presented. Each connection made by an application to a database is monitored. When the application is shut down, if information regarding a particular connection remains in memory, then that connection is reported as a potential database connectivity leak.
    Type: Grant
    Filed: December 16, 2009
    Date of Patent: February 3, 2015
    Assignee: Teradata US, Inc.
    Inventor: Dennis Avery Tackett
  • Techniques for join processing on column partitioned tables
    Patent number: 8949218
    Abstract: Techniques for processing joins on column partitioned tables are provided. A join operation having a column partitioned table within a query is decomposed into a two-step process. The first process performs the join condition on the column portioned table with optional filtering conditions and a non-column partitioned table and spools the resulting columns to a spooled table. The spooled table is then rowid joined back to the column partitioned table to acquire remaining columns not present in the spooled table. Both the first and second steps can be separately resolved for costs when determining a query execution plan.
    Type: Grant
    Filed: December 26, 2012
    Date of Patent: February 3, 2015
    Assignee: Teradata US, Inc.
    Inventors: Grace Kwan-On Au, Mohammed Al-Kateb
  • Database compression analyzer
    Patent number: 8943028
    Abstract: Apparatus, systems, and methods may operate to receive requests to execute a plurality of compression and/or decompression mechanisms on one or more database objects; to execute each of the compression and/or decompression mechanisms, on a sampled basis, on the database objects; to determine comparative performance characteristics associated with each of the compression and/or decompression mechanisms; and to record at least some of the performance characteristics and/or derivative characteristics derived from the performance characteristics in a performance summary table. The table may be published to a storage medium or a display screen. Other apparatus, systems, and methods are disclosed.
    Type: Grant
    Filed: June 29, 2010
    Date of Patent: January 27, 2015
    Assignee: Teradata US, Inc.
    Inventors: Congnan Luo, Like Gao, Yu Long, Judy Wu, Michael Leon Reed
  • Calculating aggregates of multiple combinations of a given set of columns
    Patent number: 8943058
    Abstract: In a database system having processing units, a request is received to calculate aggregates of multiple combinations of a given set of columns. The processing units are divided into multiple groups, where each of the multiple groups includes a corresponding subset of the processing units. Within each of the groups, data of each processing unit in the group is replicated to other one or more processing units in the group. Within each of the groups, aggregates of at least some of the multiple combinations of the given set of columns are calculated by the processing units in the group using the replicated data.
    Type: Grant
    Filed: December 14, 2009
    Date of Patent: January 27, 2015
    Assignee: Teradata US, Inc.
    Inventor: Ambuj Shatdal
  • Query execution plan revision for error recovery
    Patent number: 8938644
    Abstract: A computer-implemented method, apparatus and article of manufacture for performing an automatic error recovery in a database system. Automatic error recovery is performed for a query execution plan, following errors, problems or failures that occur during execution, by automatically or manually deactivating and/or activating components, features or code paths, and then re-submitting the query execution plan for execution in the computer system.
    Type: Grant
    Filed: December 3, 2010
    Date of Patent: January 20, 2015
    Assignee: Teradata US, Inc.
    Inventors: Arthur Clark, Douglas P. Brown, Anita Richards, Donald R. Pederson
  • Techniques for external application-directed data partitioning in data exporting from a database management system
    Patent number: 8938444
    Abstract: Techniques for external application-directed data partitioning in data exported from a parallel database management system (DBMS) are provided. An external application sends a query, a total number of requested access module processors (AMPs), and an application-defined data partitioning expression to the DBMS. The DBMS executes the query with the results vertical partitioned on the identified number of AMPs. Individual external mappers access their assigned AMPs asking for specific partitions that they are assigned to process the query results.
    Type: Grant
    Filed: December 29, 2011
    Date of Patent: January 20, 2015
    Assignee: Teradata US, Inc.
    Inventors: Yu Xu, Olli Pekka Kostamaa
  • Techniques for fast loading of data from an external distributed file system to a database management system
    Patent number: 8938480
    Abstract: Techniques for fast loading data from an external distributed file system (DFS) to a database management system (DBMS) are provided. Assigning a portion of data from a file located in the DFS to each of a plurality of DFS clients. Configuring each DFS client to interact with a specific gateway from a plurality of gateways associated with the DBMS. Each gateway configured to send its portion of the file received from its designated client to every access module processor (AMP) controlled by that gateway. Each AMP processes a portion of the data received from the gateway to load the data into a table of the DBMS.
    Type: Grant
    Filed: December 29, 2011
    Date of Patent: January 20, 2015
    Assignee: Teradata US, Inc.
    Inventor: Yu Xu
  • Method of performing snap imaging using data temperature for making anticipatory copies
    Patent number: 8924441
    Abstract: A technique for use in performing snap imaging of a plurality of data objects and associated metadata involves placing the plurality of data objects in a consistent state. While the data objects are in a consistent state, a copy is created of the metadata associated with the plurality of data objects. The data objects are then taken out of the consistent state. The temperature value associated with one or more of the data objects is/are compared with a threshold value. A copy is created of at least some of the data objects for which the associated temperature value exceeds the threshold value.
    Type: Grant
    Filed: September 6, 2006
    Date of Patent: December 30, 2014
    Assignee: Teradata US, Inc.
    Inventor: John Mark Morris
  • Cardinality and selectivity estimation using a single table join index
    Patent number: 8914354
    Abstract: A method for estimating the selectivity of a database base table predicate, the cardinality of a join, and the cardinality of an aggregation. The method includes receiving a database query, the query comprising one or more query predicates and referencing one or more database tables. One or more join indexes are identified, the join index(es) defined on respective database tables referenced by the database query. The join index(es) comprises one or more join index predicates, and includes one or more join columns in its select list. The row count selected by the query predicates is calculated at least partly using the row count or statistics of the one or more join indexes. The selectivity of the base table predicate is calculated at least partly from the calculated row count. The cardinality of the join is estimated at least partly from the row count and statistics of the identified join index(es).
    Type: Grant
    Filed: July 28, 2009
    Date of Patent: December 16, 2014
    Assignee: Teradata US, Inc.
    Inventors: Grace Au, Rama Krishna Korlapati, Haiyan Chen
  • Non-equijoin metadata
    Patent number: 8914352
    Abstract: The subject mater herein relates to database management and, more particularly, to non-equijoin metadata. Various embodiments described herein provide systems, methods, software, and data structures to facilitate non-equijoins of data. Some such embodiments include a data store to hold metadata describing relationships between database tables. The relationships between database tables may include one or more non-equijoins of tables in the form of one or more table-column pairs of a first table being non-equal to one or more table-column pairs of a second table. In some embodiments, the metadata may be used by a query generator to build query statements including one or more non-equijoin.
    Type: Grant
    Filed: July 10, 2007
    Date of Patent: December 16, 2014
    Assignee: Teradata US, Inc.
    Inventors: Michael Chaves, Kasturi Belur, Scott Shelton, Henry Fu
  • System and method of massively parallel data processing
    Patent number: 8903841
    Abstract: A system and method of massively parallel data processing are disclosed. In an embodiment, a method includes generating an interpretation of a customizable database request which includes an extensible computer process and providing an input guidance to available processors of an available computing environment. The method further includes automatically distributing an execution of the interpretation across the available computing environment operating concurrently and in parallel, wherein a component of the execution may be limited to at least a part of an input data. The method also includes automatically assembling a response using a distributed output of the execution.
    Type: Grant
    Filed: May 21, 2010
    Date of Patent: December 2, 2014
    Assignee: Teradata US, Inc.
    Inventors: Eric Friedman, Peter Pawlowski
  • Determining a condition of a system based on plural measurements
    Patent number: 8892389
    Abstract: To determine a system condition, temperature information from at least one temperature sensor in the system is received, along with second information from at least a second type of sensor in the system. An out-of-range temperature condition is detected according to the received temperature information. According to the second information, one of plural potential causes of the out-of-range temperature condition is selected.
    Type: Grant
    Filed: March 31, 2008
    Date of Patent: November 18, 2014
    Assignee: Teradata US, Inc.
    Inventors: P. Keith Muller, David G. Wang
  • Executing a join plan using data compression
    Patent number: 8886614
    Abstract: A join plan creates an intermediate table from two or more database tables within a database. In doing so, at least one projected and compressible column within one of the database tables is identified, where the column contains data values to which the application of a compression data transformation results in a reduction in the size of the data values. The frequency of occurrences of at least some unique values in the compressible column is identified, and then the two or more database tables are joined. The results of the join are then stored in the intermediate table such that the compression data transformation is applied to at least some of the unique values in the compressible column for which the frequency has been identified.
    Type: Grant
    Filed: November 27, 2006
    Date of Patent: November 11, 2014
    Assignee: Teradata US, Inc.
    Inventors: John Mark Morris, Todd A Walter
  • Graphical user interfaces for custom lists and labels
    Patent number: 8880569
    Abstract: Graphical User Interfaces for custom lists and labels are provided. A database includes fields that define views when processed by an application server on behalf of a user. At least one view permits the user to supply criteria for custom defining lists or sets of labels, which are also retrieved from the database by the application server.
    Type: Grant
    Filed: April 17, 2007
    Date of Patent: November 4, 2014
    Assignee: Teradata US, Inc.
    Inventors: Linette Draper, Thomas Kevin Ryan, Brian J. Wasserman, Paul H. Phibbs
  • System and method for data compression using multiple small encoding tables
    Patent number: 8872679
    Abstract: A system and method for compressing and decompressing multiple types of character data. The system and method employ multiple encoding tables, each designed for encoding a subset of character data, such as numeric data, uppercase letters, lowercase letters, Latin, or UNICODE data, to perform compressions and decompression of character data, and. The compression solution also provides for the creation of new encoding tables on the fly, and accommodates the compression of lengthy character streams using multiple different general compression algorithms, automatically choosing a suitable general compression algorithm for specific input data.
    Type: Grant
    Filed: December 5, 2012
    Date of Patent: October 28, 2014
    Assignee: Teradata US, Inc.
    Inventors: Gary Roberts, Guilian Wang