Patents Assigned to Teradata US, Inc.
  • System and method for managing spool space in a mixed SSD and HDD storage environment
    Patent number: 9037622
    Abstract: A system and method for managing soft reserve space within a database system including fast solid state storage devices (SSDs) and traditional hard drive storage device (HDDs). The system and method monitors actual spool use within the database system and dynamically modifies the soft-reserve space as a percentage of total storage space in response to changes in spool use.
    Type: Grant
    Filed: December 6, 2012
    Date of Patent: May 19, 2015
    Assignee: Teradata US, Inc.
    Inventor: Paul Rubio
  • Time-bound batch status rollup for logged events
    Patent number: 9015108
    Abstract: Techniques for time-bound batch status rollup for logged events are provided. A status for each action defined in a database log is resolved during a configured interval of time. The statuses for the actions are aggregated at the end of the interval of time and then joined back into the log.
    Type: Grant
    Filed: August 31, 2012
    Date of Patent: April 21, 2015
    Assignee: Teradata US, Inc.
    Inventors: Guy Ken Ishimoto, Lucy Wanda Loftin, Minhhang Thi Le
  • Mapping table rows to characters
    Patent number: 9015187
    Abstract: Table rows are mapped to corresponding characters, where the mapping produces a collection of the characters. A query is received to identify a pattern in the table rows. The collection of the characters is accessed to process the query.
    Type: Grant
    Filed: November 8, 2007
    Date of Patent: April 21, 2015
    Assignee: Teradata US, Inc.
    Inventor: Ambuj Shatdal
  • Managing access to data in a multi-temperature database
    Patent number: 9015146
    Abstract: An optimization technique is provided that optimizes data access by mapping each table, or row and/or column in a table, to a particular query, depending on whether the data in said table, row or column is ‘hot’ or ‘cold’ data. In one aspect, the invention features a method for optimizing the access time of an SQL query to a database including data. The method includes receiving, for each query type, a data frequency access measure and associating each query type with a processing rule set, according to the received data frequency access measure.
    Type: Grant
    Filed: December 1, 2006
    Date of Patent: April 21, 2015
    Assignee: Teradata US, Inc.
    Inventors: Anita Richards, Douglas P. Brown
  • Database query table substitution
    Patent number: 9002827
    Abstract: The subject mater herein relates to requesting data from a database and, more particularly, to database query table substitution. Various embodiments provide systems, methods, and software to evaluate requests for data from a database and make table substitutions in the request to reduce a number of tables queried. Some embodiments include receiving a data request including data from two or more database table columns and building a list of all database tables specified in the data request. Some such embodiments further include, for each column in the data request, identifying each table from the list of all tables within which the column is present and identifying a least number of one or more tables that together include all of the columns of the data request. The data request may then be modified by changing the table of one or more of the columns in the received data requests.
    Type: Grant
    Filed: July 11, 2007
    Date of Patent: April 7, 2015
    Assignee: Teradata US, Inc.
    Inventors: Michael Chaves, Jason Figge, Harold Lee
  • 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
  • System and method for allocating resources in a mixed SSD and HDD storage environment
    Patent number: 8996450
    Abstract: A system and method for allocating storage devices within a database system including fast solid state storage devices (SSDs) and traditional hard drive storage device (HDDs). The method repetitively collects temperature and queue depth data for each storage device, and determines from the collected data points a service time for each storage device. The method then selects, in response to an allocation request, a storage device having a minimum total wait time determined from the current queue depth and service time for each storage device.
    Type: Grant
    Filed: December 30, 2012
    Date of Patent: March 31, 2015
    Assignee: Teradata US, Inc.
    Inventor: Paul Anthony Rubio
  • 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 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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