Patents Assigned to Teradata US, Inc.
-
Patent number: 7979394Abstract: A technique for managing storage of a data object in a storage device involves receiving the data object (A) to store in the storage device, where the data object has an indicator bit pattern (P). Successive compression data transformations are applied to data object A to obtain respective corresponding compressed data objects, and one of these compressed data objects is selected, such that the selected compressed data object (C) has the shortest length with respect to the remaining compressed data objects. Compression information (I) is then associated with the compression data transformation used to generate data object C, and a threshold value T is calculated at least partly from the length of compression information I. If length (C)+T?length (A), then the indicator bit pattern of data object A is reset and the data object A is written to the storage device.Type: GrantFiled: September 19, 2006Date of Patent: July 12, 2011Assignee: Teradata US, Inc.Inventors: John Mark Morris, Criselda Carrillo, P. Keith Muller
-
Patent number: 7979431Abstract: A query enhancer module providing a unique method to modify user submitted queries within a web-based, multi-tier enterprise solution. The user submitted query specifies data to be retrieved from a database. Without any user interaction the query enhancer module rewrites the query to specify a subset of the data specified in the user submitted query. This rewritten query is then executed against the database to retrieve the subset of the data. Generally, the subset set of the data comprises the amount of data that can be displayed on a single web page.Type: GrantFiled: July 2, 2007Date of Patent: July 12, 2011Assignee: Teradata US, Inc.Inventors: Farhan Qazi, Siamak Safarian, YanJun An, Galina Modilevski
-
Publication number: 20110167055Abstract: Embodiments of the present invention provide a hardware accelerator that assists a host database system in processing its queries. The hardware accelerator comprises special purpose processing elements that are capable of receiving database query/operation tasks in the form of machine code database instructions, execute them in hardware without software, and return the query/operation result back to the host system. For example, table and column descriptors are embedded in the machine code database instructions. For ease of installation, the hardware accelerators employ a standard interconnect, such as a PCle or HT interconnect. The processing elements implement a novel dataflow design and Inter Macro-Op Communication (IMC) data structures to execute the machine code database instructions. The hardware accelerator may also comprise a relatively large memory to enhance the hardware execution of the query/operation tasks requested.Type: ApplicationFiled: March 15, 2011Publication date: July 7, 2011Applicant: TERADATA US, INC.Inventors: JEREMY BRANSCOME, MICHAEL CORWIN, LIUXI YANG, JOSEPH I. CHAMDANI
-
Publication number: 20110167083Abstract: Embodiments of the present invention provide a hardware accelerator that assists a host database system in processing its queries. The hardware accelerator comprises special purpose processing elements that are capable of receiving database query/operation tasks in the form of machine code database instructions, execute them in hardware without software, and return the query/operation result back to the host system. For example, table and column descriptors are embedded in the machine code database instructions. For ease of installation, the hardware accelerators employ a standard interconnect, such as a PCle or HT interconnect. The processing elements implement a novel dataflow design and Inter Macro-Op Communication (IMC) data structures to execute the machine code database instructions. The hardware accelerator may also comprise a relatively large memory to enhance the hardware execution of the query/operation tasks requested.Type: ApplicationFiled: March 15, 2011Publication date: July 7, 2011Applicant: TERADATA US, INC.Inventors: JEREMY BRANSCOME, MICHAEL CORWIN, LIUXI YANG, JOSEPH I. CHAMDANI
-
Publication number: 20110161401Abstract: Techniques for dynamic resource management are presented. A World-Wide Web (WWW) page is acquired on first access to a WWW site and rendered with a script tag. When a browser loads the WWW page, the script tag is processed to remotely execute a script on the WWW site. The script produces a single file having code for the resources that are referenced in the WWW page. The single file is provided back to the browser where it is cached so that when any of the resources are accessed via the WWW page, the needed code for those resources are available for execution within the cache of the browser.Type: ApplicationFiled: December 30, 2009Publication date: June 30, 2011Applicant: Teradata US, Inc.Inventor: Charles Douthart
-
Publication number: 20110161135Abstract: Methods and systems for processing collaterals are described. A method may include receiving qualifying criteria from a client. The qualifying criteria may define assignments of one or more collaterals. An assignment tool may be generated based on the qualifying criteria. The assignment tool may include a number of stored attributes and one or more interaction attribute to be determined based on a customer interaction. The assignment tool may be used to assign a collateral to a customer. Additional methods and systems are disclosed.Type: ApplicationFiled: December 30, 2009Publication date: June 30, 2011Applicant: Teradata US, Inc.Inventors: Harold Lee, Alexander Chapman
-
Publication number: 20110154254Abstract: Methods and systems for setting goals and modifying segment criteria counts are described. A method may include displaying to a user a graphical user interface (GUI) to enable the user to combine multiple search criteria having variable parameters, used in searching of a database, to produce a predefined count of search results. User selections of the multiple search criteria, values for the variable parameters, and Boolean operations to combine the search criteria may be received from the user. As the received user selections change, a count of search results retrieved from the database, based on the user selections, may be dynamically displayed. Additional methods and systems are disclosed.Type: ApplicationFiled: December 21, 2009Publication date: June 23, 2011Applicant: TERADATA US, INC.Inventor: MONA SINGH
-
Publication number: 20110153270Abstract: 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: ApplicationFiled: December 21, 2009Publication date: June 23, 2011Applicant: Teradata US, Inc.Inventor: Daniel Hoffman
-
Patent number: 7966343Abstract: Embodiments of the present invention provide one or more hardware-friendly data structures that enable efficient hardware acceleration of database operations. In particular, the present invention employs a column-store format for the database. In the database, column-groups are stored with implicit row ids (RIDs) and a RID-to-primary key column having both column-store and row-store benefits via column hopping and a heap structure for adding new data. Fixed-width column compression allow for easy hardware database processing directly on the compressed data. A global database virtual address space is utilized that allows for arithmetic derivation of any physical address of the data regardless of its location. A word compression dictionary with token compare and sort index is also provided to allow for efficient hardware-based searching of text. A tuple reconstruction process is provided as well that allows hardware to reconstruct a row by stitching together data from multiple column groups.Type: GrantFiled: April 7, 2008Date of Patent: June 21, 2011Assignee: Teradata US, Inc.Inventors: Liuxi Yang, Kapil Surlaker, Ravi Krishnamurthy, Michael Corwin, Jeremy Branscome, Krishnan Meiyyappan, Joseph I. Chamdani
-
Patent number: 7966312Abstract: A technique for providing an updatable result set from multiple joined tables derived from a plurality of databases includes testing for at least one unique index from each of the multiple joined tables. A technique for providing an updatable result set from multiple joined tables that may include null values for outer-joined tables includes testing for a connection to the unique indexes and the null values.Type: GrantFiled: October 10, 2007Date of Patent: June 21, 2011Assignee: Teradata US, Inc.Inventors: Thomas C. Nolan, Jack Yuan
-
Publication number: 20110145297Abstract: Methods and systems that implement enhanced user interactions with a grid are described. A method may include generating a grid of cells arranged in a number of rows and columns. Each row may correspond to a data record of a database. The grid may be displayed to a user while identifying one or more cells as editable cells. Input data may be received from the user for each of the editable cells. The input data may be validated using predefined criteria to identify incorrect input data and errors associated with the incorrect input data may be displayed to the user. Additional methods and systems are disclosed.Type: ApplicationFiled: December 16, 2009Publication date: June 16, 2011Applicant: Teradata US, Inc.Inventor: Mona Singh
-
Publication number: 20110145200Abstract: Techniques for precedence based storage are presented. Storage for a database is organized into storage pools; collections of pools form storage classes. The storage pools within a particular class are organized in a precedence-based order so that when storage for the database is needed, the storage pools are used in the defined order of precedence. Additionally, each storage pool or storage class can be circumscribed by security limitations, quality of service limitations, and/or backup procedures.Type: ApplicationFiled: December 16, 2009Publication date: June 16, 2011Applicant: Teradata US, Inc.Inventor: Gregory Howard Milby
-
Publication number: 20110145699Abstract: Techniques for annotation driven Representational State Transfer (REST) web services are presented. A platform-independent World-Wide Web application is annotated to expose the methods of the application when accessed via a WWW site. The methods are described when rendered via a WWW site in a REST compliant format (RESTful).Type: ApplicationFiled: December 15, 2009Publication date: June 16, 2011Applicant: Teradata US, Inc.Inventors: Haseem ul Haq Kheiri, Michael Chaves
-
Patent number: 7962521Abstract: An index selection mechanism allows for efficient generation of index recommendations for a given workload of a database system. The workload includes a set of queries that are used to access tables in a database system. The index recommendations are validated to verify improved performance, followed by application of the indexes. Graphical user interface screens are provided to receive user input as well as to present reports to the user.Type: GrantFiled: March 2, 2009Date of Patent: June 14, 2011Assignee: Teradata US, Inc.Inventors: Douglas P. Brown, Jeetendra Chaware, Manjula Koppuravuri
-
Publication number: 20110137961Abstract: Techniques for cross referencing data are presented. A first database object and a second database object are linked together. The linkage is automatically cross referenced to a third database object. Access to any of the database objects can be achieved via any of the remaining database objects and vice versa. Additionally, the link and cross reference can be visualized and visually manipulated and modified.Type: ApplicationFiled: December 8, 2009Publication date: June 9, 2011Applicant: Teradata US, Inc.Inventors: Thomas Kevin Ryan, Carl Lewis Christofferson, Neelesh Bansode, Santosh Kumar Singh, Latesh Pant, Ankit Khare
-
Publication number: 20110137957Abstract: Techniques for managing data relationships are presented. A database element from a first database table is linked with a database element of a second database table via a Graphical User Interface as directed by a user. The link establishes a data relationship having attributes and properties. The relationship along with the attributes and properties are graphically presented to the user for inspection and analysis.Type: ApplicationFiled: December 8, 2009Publication date: June 9, 2011Applicant: Teradata US, Inc.Inventors: Thomas Kevin Ryan, Carl Lewis Christofferson, Neelesh Bansode, Santosh Kumar Singh, Latesh Pant
-
Patent number: 7958159Abstract: In a database system, a database request is received, and database software dispatches steps associated with the database request to plural access modules of a database system for execution. Statistics are collected regarding execution of each step by a respective access module in response to receiving an indication of completion by the respective access module. It is determined whether statistics relating to execution of the database request violate one or more predefined rules, and in response to determining that the statistics relating to execution of the database request violate one or more predefined thresholds, one or more actions are performed by the database software.Type: GrantFiled: December 19, 2005Date of Patent: June 7, 2011Assignee: Teradata US, Inc.Inventors: Hoa Thu Tran, Choung H. Kim
-
Patent number: 7958084Abstract: A system, method, and computer readable medium that facilitate operation of a file system capable of dividing an existing homogeneous file system into a series of regions, with each region accommodating storage devices having compatible characteristics are provided. The file system is divided into logical regions, with each region containing a particular class of storage devices possessing a particular set of common storage traits. The regionalization of the file system provides for all cylinders of storage devices sharing a common storage characteristic to be contained within a single region, and dedicated file system logic can be written to service that region. A master index configuration implemented in accordance with disclosed embodiments includes a region descriptor construct that enables cylinder index descriptors associated with cylinders of storage devices sharing a common storage characteristic to be grouped into regions.Type: GrantFiled: May 12, 2008Date of Patent: June 7, 2011Assignee: Teradata US, Inc.Inventor: Gregory Milby
-
Patent number: 7953925Abstract: A method of selecting candidates for data cluster duplication that can be used as an alternative or as an addition to existing duplication techniques. The method determines a read temperature of a data cluster. If the read temperature of the data cluster exceeds a threshold value, a write temperature of the data cluster is determined. If the write temperature of the data cluster is below a threshold value the cluster is selected for duplication.Type: GrantFiled: December 10, 2007Date of Patent: May 31, 2011Assignee: Teradata US, Inc.Inventor: John Mark Morris
-
Patent number: 7949846Abstract: A method and system for allocating storage space on a storage device to a requesting entity. The storage device includes a set of extents. An allocation map is maintained in computer memory. The allocation map has a plurality of map blocks, the map blocks each having a plurality of map entries. The map entries include respective logical extent identifiers, physical extent information and obsolete indicators. An invalid extent logical identifier represents a free extent and a valid extent identifier represents a prior allocated extent. An obsolete indicator marks a map entry as either current or obsolete. In one technique an extent allocation request is received from the requesting entity. A first map block is selected having a first map entry marked as obsolete. A second map block is selected having a second map entry not marked as obsolete. Physical extent information is copied from the second map entry to the first map entry. The logical extent identifier is assigned to the first map entry.Type: GrantFiled: November 30, 2006Date of Patent: May 24, 2011Assignee: Teradata US, Inc.Inventors: Gary L. Boggs, John Mark Morris