Patents Assigned to Teradata US, Inc.
  • Patent number: 11681675
    Abstract: A data store system may include a storage device configured to store a plurality of data store tables. The data store may further include a plurality of processing units. At least one processing unit from the plurality of processing units may receive an analytic function call. The at least one processing unit may further identify, in the analytic function call, at least one column of a data store table on which to execute an analytic function in the analytic function call and may further identify, in the analytic function call, an identifier column of the data store table. Each row of the at least one column may be associated with a common row value of the identifier column. The at least one processing unit may further identify, in the analytic function call, at least one index column of the data store table. Each value in each at the least one index column may identify an index value on which to index each value of the at least one column with respect to each value of the identifier column.
    Type: Grant
    Filed: December 31, 2020
    Date of Patent: June 20, 2023
    Assignee: Teradata US, Inc.
    Inventor: Gregory Howard Milby
  • Patent number: 11675792
    Abstract: In some examples, a database system receives data relating to plural micro-models that apply respective analytics, and distributes a plurality of data segments of the received data across the plurality of processing engines based on values of a segmentation key included in the received data. A plurality of processing engines, performs in parallel, operations associated with the plural micro-models using respective data segments of the plurality of data segments, where different processing engines of the plurality of processing engines perform operations associated with respective micro-models of the plural micro-models.
    Type: Grant
    Filed: December 28, 2020
    Date of Patent: June 13, 2023
    Assignee: Teradata US, Inc.
    Inventors: Maria Guadalupe Castellanos, Xiang Zuo, Faraz Ahmad, Awny Kayed Al-Omari
  • Patent number: 11645280
    Abstract: A function reference for a function is identified in a query. A plurality of processing environments that can provide the function is identified. Function costs for the function to process in the processing environments are obtained. Input data transfer costs are acquired for providing input data identified in the query to each of the functions. A specific one of the functions from a specific processing environment is selected based on the function costs and the input data transfer costs. A query execution plan for executing the query with the specific function is generated. The query execution plan is provided to a database engine for execution.
    Type: Grant
    Filed: December 20, 2017
    Date of Patent: May 9, 2023
    Assignee: Teradata US, Inc.
    Inventors: John Mark Morris, Bhashyam Ramesh
  • Patent number: 11640399
    Abstract: In some examples, a database system identifies a plurality of query portions in a database query that contain references to a first external table, the first external table being based on data from a remote data store coupled to the database system over a network. The database system creates a common spool portion that includes projections and selections of the plurality of query portions, and rewrites the plurality of query portions into rewritten query portions that refer to a spool containing an output of the common spool portion. For execution of the database query, the database system determines, as part of optimizer planning, whether to use the plurality of query portions or the common spool portion and the rewritten query portions.
    Type: Grant
    Filed: December 9, 2020
    Date of Patent: May 2, 2023
    Assignee: Teradata US, Inc.
    Inventors: Naveen Jaiswal, Kishore Chilagani, Vivek Kumar, Sanjib Kumar Mishra
  • Patent number: 11625403
    Abstract: In some examples, a database system includes a memory to store a predicate-object name cache, where the predicate-object name cache contains predicates mapped to respective object names. The database system further includes at least one processor to receive a query containing a given predicate, identify, based on accessing the predicate-object name cache, one or more object names indicated by the predicate-object name cache as being relevant for the given predicate, retrieve one or more objects identified by the one or more object names from a remote data store, and process the query with respect to data records of the one or more objects retrieved from the remote data store.
    Type: Grant
    Filed: October 30, 2020
    Date of Patent: April 11, 2023
    Assignee: Teradata US, Inc.
    Inventors: Rangavajjula K N Sai Krishna, Chandrasekhar Tekur, Bhashyam Ramesh
  • Patent number: 11625398
    Abstract: A cardinality of a query is estimated by creating a join plan for the query. The join plan is converted to a graph representation. A subtree graph kernel matrix is generated for the graph representation of the join plan. The subtree graph kernel matrix is submitted to a trained model for cardinality prediction which produces a predicted cardinality of the query.
    Type: Grant
    Filed: December 12, 2018
    Date of Patent: April 11, 2023
    Assignee: Teradata US, Inc.
    Inventor: Dhiren Kumar Bhuyan
  • Patent number: 11593335
    Abstract: A determination is made that a database system is resource bound resulting in a resource bound condition. Signals for the resources being bound in the database system are identified. Events associated with the signals are extracted. Events are correlated temporally to identify a time interval for which an arrival rate meter (ARM) is helpful. Database system segments are selected that effect key performance indicators associated with the identified time interval. Parameters for the selected database system segments to be deferred by the database system are estimated. The estimated parameters are incorporated into an arrival rate meter (ARM). The ARM is put into effect.
    Type: Grant
    Filed: December 30, 2019
    Date of Patent: February 28, 2023
    Assignee: Teradata US, Inc.
    Inventors: Kristi O'Grady, Modie Christon Smith, Ruth Gladys Fenwick, Douglas P. Brown, Ryan Speed
  • Patent number: 11593371
    Abstract: A relational database management system (RDBMS) accepts a workload comprised of one or more queries against a relational database. The RDBMS evolves a default cost profile into a plurality of cost profiles using fixed or dynamic evolution, wherein each of the cost profiles captures one or more cost parameters for the workload. The cost profiles are represented by a multi-dimensional matrix that has one or more dimensions, and each of the dimensions represents one of the cost parameters. The RDBMS dynamically determines which of the cost profiles is an optimal cost profile for the workload by mapping the cost profiles to the workload using a random walk scoring algorithm or a biased walk scoring algorithm that searches the multi-dimensional matrix to identify the optimal cost profile. The RDBMS selects and performs one or more query execution plans for the workload based on the optimal cost profile for the workload.
    Type: Grant
    Filed: August 18, 2020
    Date of Patent: February 28, 2023
    Assignee: Teradata US, Inc.
    Inventors: Wellington Marcos Cabrera Arevalo, Kassem Awada, Mahbub Hasan, Allen N. Diaz, Mohammed Al-Kateb, Awny Kayed Al-Omari
  • Patent number: 11593334
    Abstract: An apparatus, method and computer program product for physical database design and tuning in relational database management systems. A relational database management system executes in a computer system, wherein the relational database management system manages a relational database comprised of one or more tables storing data. A Deep Reinforcement Learning based feedback loop process also executes in the computer system for recommending one or more tuning actions for the physical database design and tuning of the relational database management system, wherein the Deep Reinforcement Learning based feedback loop process uses a neural network framework to select the tuning actions based on one or more query workloads performed by the relational database management system.
    Type: Grant
    Filed: December 27, 2019
    Date of Patent: February 28, 2023
    Assignee: Teradata US, Inc.
    Inventors: Louis Martin Burger, Emiran Curtmola, Sanjay Nair, Frank Roderic Vandervort, Douglas P. Brown
  • Patent number: 11593366
    Abstract: A query with a UNION ALL (UA) view is detected by a query optimizer. A query execution plan and cost for the query is obtained. The query is rewritten to push aggregates of the original query into the view. A query execution plan is generated for the rewritten query and a cost for executing the rewritten query is obtained. The lowest cost execution plan is selected for execution by a database engine of a database.
    Type: Grant
    Filed: December 22, 2017
    Date of Patent: February 28, 2023
    Assignee: Teradata US, Inc.
    Inventors: Angela Maduko, Nelly Korenevsky
  • Patent number: 11582393
    Abstract: An imaging system may include a housing having shape and size sufficient to receive an industrial tool inserted into the housing. The imaging system may further include a plurality of cameras and a plurality of light sources positioned within the housing in a manner to surround the industrial tool upon insertion of the industrial tool into the housing. The imaging system may include a processing unit to control operation of the cameras and light sources and adjust relative positions of the cameras and light sources in relation to the industrial tool to capture a plurality of images of relevant portions of the industrial tool. The plurality of images collectively reveals substantially all of the relevant portions of the industrial tool. A method and computer-readable medium are also disclosed.
    Type: Grant
    Filed: June 23, 2020
    Date of Patent: February 14, 2023
    Assignee: Teradata US, Inc.
    Inventors: Nathan Zenero, Eric van Oort, Ysabel Witt-Doerring, Jacob Lubecki
  • Patent number: 11567941
    Abstract: A database system receives a query and determines that the query includes an inner join between a parent table and a child table. The database system determines that the following relationships exists between the parent table and the child table: referential integrity (“RI”) between a primary key attribute (pk) in the parent table and a foreign key attribute (fk) in the child table and a temporal relationship constraint (“TRC”) between a period attribute in the parent table and a TRC-attribute in the child table. The database system determines that the query satisfies non-temporal join elimination conditions and temporal join elimination conditions and that the query contains no other qualification conditions on the parent table's period attribute and eliminates the inner join when planning execution of the query.
    Type: Grant
    Filed: October 23, 2020
    Date of Patent: January 31, 2023
    Assignee: Teradata US, Inc.
    Inventors: Jaiprakash G Chimanchode, Bhashyam Ramesh, Stephen A Brobst, Pratik Patodi, Dhrubajyoti Roy, Sai Pavan Kumar Pakala
  • Patent number: 11567954
    Abstract: Seed patterns are derived from a sequence database. Execution costs for types of seed patterns are computed. Each seed pattern is iteratively distributed to distributed nodes along with that seed pattern's assigned execution cost. The distributed nodes processing in parallel to mine the sequence database for super patterns found in the sequence database. When a distributed node exhausts its execution budget, any remaining mining needed for the seed pattern being mined is reallocated to another distributed node having remaining execution budget.
    Type: Grant
    Filed: March 21, 2019
    Date of Patent: January 31, 2023
    Assignee: Teradata US, Inc.
    Inventors: Tao Li, Lijun Zhao, Yu Wang, Wenjie Wu, Qian Zhang, Shaoming Li
  • Patent number: 11544236
    Abstract: A machine-learning driven Database Management System (DBMS) is provided. One or more machine-learning algorithms are trained on the database constructs and execution plans produced by a database optimizer for queries. The trained machine-learning algorithms provide predictors when supplied the constructs and plans for a given query. The predictors are processed by the DBMS to make resource, scheduling, and Service Level Agreement (SLA) compliance decisions with respect to the given query.
    Type: Grant
    Filed: December 28, 2018
    Date of Patent: January 3, 2023
    Assignee: Teradata US, Inc.
    Inventors: Douglas Paul Brown, Preeti Javaji
  • Patent number: 11531657
    Abstract: A data store system may include at least one storage device to store a plurality of data and at least one processor with access to the storage device. The at least one processor may receive a plurality of features associated with an environment. The at least one processor may further generate a state representation of the environment based on the plurality of features. The at least one processor may further generate a plurality of predicted future states of the environment based on the state representation. The at least one processor may further generate at least one action to be performed by the environment based on the plurality of predicted future states. The at least one processor may provide the at least one action to the environment to be performed. A method and computer-readable medium are also disclosed.
    Type: Grant
    Filed: November 13, 2019
    Date of Patent: December 20, 2022
    Assignee: Teradata US, Inc.
    Inventors: Naveen Thaliyil Sankaran, Lovlean Arora, Sourabh Maity, Jaiprakash G. Chimanchode, Stephen Andrew Brobst, Bhashyam Ramesh, Douglas P. Brown
  • Patent number: 11526505
    Abstract: A database system receives a request from a user. The request invokes a data set function (DSF) and uses a property to be provided by the DSF. The database system determines that a function descriptor is available for the DSF. The function descriptor is expressed as markup language instructions. The function descriptor defines the property of the DSF. The database system uses the function descriptor to define a property for the DSF.
    Type: Grant
    Filed: December 5, 2019
    Date of Patent: December 13, 2022
    Assignee: Teradata US, Inc.
    Inventors: B. Anantha Subramanian, Mohamed Yassin Eltabakh, Mahbub Hasan, Robert Matthew Wehrmeister, Awny Kayed Al-Omari, Sanjay Sukumaran Nair, Kashif Abdullah Siddiqui, Mohammed Yassin Al-Kateb
  • Patent number: 11520789
    Abstract: In some examples, a database management node updates object metadata with indicators of access frequencies of a plurality of objects in a data store that is remotely accessible by the database management node over a network. The database management node selects a subset of the plurality of objects based on the indicators, and caches the subset in the local storage.
    Type: Grant
    Filed: July 1, 2020
    Date of Patent: December 6, 2022
    Assignee: Teradata US, Inc.
    Inventor: Yang Xiang
  • Patent number: 11520756
    Abstract: Improved techniques for processing large-scale data and various large-scale data applications (e.g., large-scale Data Mining (DM), large-scale data analysis (LSDA)) in computing systems (e.g., Data Information Systems, Database Systems) are disclosed. Redundancy-reduced data (RRDS) can be provided as data that can be used more efficiently by various applications, especially, large-scale data applications. In doing so, at least one assumption about the distribution of a multi-dimensional data set (MDDS) and its corresponding set of responses (Y) can be made in order to reduce the multi-dimensional data set (MDDS). For example, a normal distribution (e.g.
    Type: Grant
    Filed: December 23, 2019
    Date of Patent: December 6, 2022
    Assignee: Teradata US, Inc.
    Inventors: Choudur K. Lakshminarayan, Thiagarajan Ramakrishnan, Awny Kayed Al-Omari
  • Patent number: 11514070
    Abstract: An Application Programming Interface (API) processes object storage requests in an object storage format that are received from client applications. A mapper maps the object storage formatted requests into database statements and executes the statements within a database management system. Results returned from the statements are mapped by the mapper to object-storage constructs and provided to the API in object storage format. The object storage formatted requests are provided from the API to the client applications to satisfy the original client applications' requests.
    Type: Grant
    Filed: December 28, 2018
    Date of Patent: November 29, 2022
    Assignee: Teradata US, Inc.
    Inventors: Awny Al-Omari, Louis Benton Landry, Stephen Andrew Brobst, Donald Raymond Pederson, Todd Walter, Oliver Ratzesberger
  • Publication number: 20220360575
    Abstract: A security mechanism, e.g., a computing system, security server, can effectively serve as a centralized security mechanism, e.g., a computing system, security server, for an ecosystem that can include diverse clients and servers. The security mechanism can obtain redirected requests for services, authenticate credentials of a client and generate a (client-side) token that can be provided by the client to the server for verification of the identity of the client. The security mechanism can also obtain a token from a server that can be similar to a (client-side) token provided to a client and then generate a (server-side) token that can be provided to a server. The server-side token can include authorization information that allows access to one or more services of one or more other servers.
    Type: Application
    Filed: July 13, 2022
    Publication date: November 10, 2022
    Applicant: Teradata US, Inc.
    Inventors: Vikkal Gupta, Ram Reddy