Patents Assigned to Teradata
  • SUMMARIZING STATISTICAL DATA FOR DATABASE SYSTEMS AND/OR ENVIRONMENTS
    Publication number: 20150149508
    Abstract: Database values and their associated indicators can be arranged in multiple “buckets.” Adjacent buckets can be combined into a single bucket successively based one or more criteria associated with the indicators to effectively reduce the number of buckets until a desired number is reached.
    Type: Application
    Filed: November 22, 2013
    Publication date: May 28, 2015
    Applicant: Teradata Corporation
    Inventors: Congnan Luo, Heng Yuan, Guillian Wang
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • DESIGNATED MEMORY SUB-CHANNELS FOR COMPUTING SYSTEMS AND ENVIRONMENTS
    Publication number: 20150055391
    Abstract: A memory channel can be divided into two or more memory sub-channels, wherein each one of the memory sub-channels includes two or more memory components configured to store data made accessible on that memory sub-channel, and wherein the two or more memory components in each one of the memory sub-channels are respectively connected via at least one transmission line and can be individually accessed (addressed) on their associated sub-channel.
    Type: Application
    Filed: August 20, 2013
    Publication date: February 26, 2015
    Applicant: Teradata Corporation
    Inventors: Norm Wayne Smith, Michael Paul Corwin, Liuxi Lang, Jeremy Branscome
  • 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
  • OPTIMIZATION OF DATABASE QUERIES FOR DATABASE SYSTEMS AND ENVIRONMENTS
    Publication number: 20150032722
    Abstract: As an abstract representation, a set of equivalent logical structures representative of multiple execution plans for execution of a database query can be used to optimize a database query. A logical structure can include one or more logical operators each representing multiple physical operators for executing the database query. Group and Operator Rules can be applied as rules to the set of equivalent logical structures to obtain additional equivalent logical structures and logical operator until no additional logical operators can be obtained. A set of possible implementation plans for the total number of the obtained logical operators can be obtained, for example, based on physical and/or implementation context.
    Type: Application
    Filed: March 12, 2014
    Publication date: January 29, 2015
    Applicant: Teradata Corporation
    Inventors: Awny Kayed Al-Omari, Robert Matthew Wehrmeister, Kashif Abdullah Siddiqui
  • 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
  • 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 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