Patents Assigned to Teradata US, Inc.
-
Patent number: 11681675Abstract: 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: GrantFiled: December 31, 2020Date of Patent: June 20, 2023Assignee: Teradata US, Inc.Inventor: Gregory Howard Milby
-
Patent number: 11675792Abstract: 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: GrantFiled: December 28, 2020Date of Patent: June 13, 2023Assignee: Teradata US, Inc.Inventors: Maria Guadalupe Castellanos, Xiang Zuo, Faraz Ahmad, Awny Kayed Al-Omari
-
Patent number: 11645280Abstract: 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: GrantFiled: December 20, 2017Date of Patent: May 9, 2023Assignee: Teradata US, Inc.Inventors: John Mark Morris, Bhashyam Ramesh
-
Patent number: 11640399Abstract: 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: GrantFiled: December 9, 2020Date of Patent: May 2, 2023Assignee: Teradata US, Inc.Inventors: Naveen Jaiswal, Kishore Chilagani, Vivek Kumar, Sanjib Kumar Mishra
-
Patent number: 11625403Abstract: 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: GrantFiled: October 30, 2020Date of Patent: April 11, 2023Assignee: Teradata US, Inc.Inventors: Rangavajjula K N Sai Krishna, Chandrasekhar Tekur, Bhashyam Ramesh
-
Patent number: 11625398Abstract: 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: GrantFiled: December 12, 2018Date of Patent: April 11, 2023Assignee: Teradata US, Inc.Inventor: Dhiren Kumar Bhuyan
-
Patent number: 11593335Abstract: 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: GrantFiled: December 30, 2019Date of Patent: February 28, 2023Assignee: Teradata US, Inc.Inventors: Kristi O'Grady, Modie Christon Smith, Ruth Gladys Fenwick, Douglas P. Brown, Ryan Speed
-
Patent number: 11593371Abstract: 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: GrantFiled: August 18, 2020Date of Patent: February 28, 2023Assignee: Teradata US, Inc.Inventors: Wellington Marcos Cabrera Arevalo, Kassem Awada, Mahbub Hasan, Allen N. Diaz, Mohammed Al-Kateb, Awny Kayed Al-Omari
-
Patent number: 11593334Abstract: 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: GrantFiled: December 27, 2019Date of Patent: February 28, 2023Assignee: Teradata US, Inc.Inventors: Louis Martin Burger, Emiran Curtmola, Sanjay Nair, Frank Roderic Vandervort, Douglas P. Brown
-
Patent number: 11593366Abstract: 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: GrantFiled: December 22, 2017Date of Patent: February 28, 2023Assignee: Teradata US, Inc.Inventors: Angela Maduko, Nelly Korenevsky
-
Patent number: 11582393Abstract: 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: GrantFiled: June 23, 2020Date of Patent: February 14, 2023Assignee: Teradata US, Inc.Inventors: Nathan Zenero, Eric van Oort, Ysabel Witt-Doerring, Jacob Lubecki
-
Patent number: 11567941Abstract: 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: GrantFiled: October 23, 2020Date of Patent: January 31, 2023Assignee: Teradata US, Inc.Inventors: Jaiprakash G Chimanchode, Bhashyam Ramesh, Stephen A Brobst, Pratik Patodi, Dhrubajyoti Roy, Sai Pavan Kumar Pakala
-
Patent number: 11567954Abstract: 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: GrantFiled: March 21, 2019Date of Patent: January 31, 2023Assignee: Teradata US, Inc.Inventors: Tao Li, Lijun Zhao, Yu Wang, Wenjie Wu, Qian Zhang, Shaoming Li
-
Patent number: 11544236Abstract: 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: GrantFiled: December 28, 2018Date of Patent: January 3, 2023Assignee: Teradata US, Inc.Inventors: Douglas Paul Brown, Preeti Javaji
-
Patent number: 11531657Abstract: 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: GrantFiled: November 13, 2019Date of Patent: December 20, 2022Assignee: Teradata US, Inc.Inventors: Naveen Thaliyil Sankaran, Lovlean Arora, Sourabh Maity, Jaiprakash G. Chimanchode, Stephen Andrew Brobst, Bhashyam Ramesh, Douglas P. Brown
-
Patent number: 11526505Abstract: 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: GrantFiled: December 5, 2019Date of Patent: December 13, 2022Assignee: 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: 11520789Abstract: 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: GrantFiled: July 1, 2020Date of Patent: December 6, 2022Assignee: Teradata US, Inc.Inventor: Yang Xiang
-
Patent number: 11520756Abstract: 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: GrantFiled: December 23, 2019Date of Patent: December 6, 2022Assignee: Teradata US, Inc.Inventors: Choudur K. Lakshminarayan, Thiagarajan Ramakrishnan, Awny Kayed Al-Omari
-
Patent number: 11514070Abstract: 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: GrantFiled: December 28, 2018Date of Patent: November 29, 2022Assignee: Teradata US, Inc.Inventors: Awny Al-Omari, Louis Benton Landry, Stephen Andrew Brobst, Donald Raymond Pederson, Todd Walter, Oliver Ratzesberger
-
Publication number: 20220360575Abstract: 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: ApplicationFiled: July 13, 2022Publication date: November 10, 2022Applicant: Teradata US, Inc.Inventors: Vikkal Gupta, Ram Reddy