Patents by Inventor Douglas P. Brown

Douglas P. Brown has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • Publication number: 20210406967
    Abstract: An apparatus, method and computer program product for estimating as-a-Service (aaS) query prices in a relational database management system (RDBMS). An optimizer of the RDBMS inserts an EXPLAIN modifier into a query, wherein the EXPLAIN modifier results in the optimizer generating a summary of a query execution plan for the query that includes one or more cost estimates for the RDBMS to perform the query. A price estimate for the query is then generated based on the cost estimates, wherein the price estimate is generated using one or more configurable pricing formulae. The price estimate is merged into the summary of the query execution plan for the query. Moreover, a price guarantee may be generated for the price estimate, wherein the price guarantee is honored when the query is subsequently invoked for execution by the RDBMS.
    Type: Application
    Filed: December 16, 2020
    Publication date: December 30, 2021
    Applicant: Teradata US, Inc.
    Inventors: Frank Roderic Vandervort, Louis Martin Burger, Douglas P. Brown
  • Publication number: 20210089534
    Abstract: A computer running a database system receives one or more queries, each query comprised of parallel threads of execution working towards the common goal of completing a user request. These threads are grouped into a schedulable object called a task group. The task groups are placed within a specific multiple tier hierarchy, and database system resources and service level goals (SLGs) allocated to the task groups according to their placement within the hierarchy. The execution of requests/tasks is monitored, and resource allocations temporarily increased to critical requests that are unlikely to meet execution goals (SLGs).
    Type: Application
    Filed: August 21, 2020
    Publication date: March 25, 2021
    Applicant: Teradata US, Inc.
    Inventors: Venu Gopal Joshi, Douglas P. Brown
  • Publication number: 20210034588
    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: Application
    Filed: December 27, 2019
    Publication date: February 4, 2021
    Applicant: Teradata US, Inc.
    Inventors: Louis Martin Burger, Emiran Curtmola, Sanjay Nair, Frank Roderic Vandervort, Douglas P. Brown
  • Publication number: 20210004675
    Abstract: A method is provided for predicting workload group metrics of a workload management system of a database system. The method comprises predicting a future workload group metric for a plurality of workload groups based upon historical user-load patterns. Each workload group has a priority that is different from priority of other workload groups.
    Type: Application
    Filed: December 30, 2019
    Publication date: January 7, 2021
    Applicant: Teradata US, Inc.
    Inventors: Bhashyam Ramesh, Naveen Thaliyil Sankaran, Lovlean Arora, Sourabh Maity, Jaiprakash G. Chimanchode, Douglas P. Brown
  • Publication number: 20200379964
    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: Application
    Filed: December 30, 2019
    Publication date: December 3, 2020
    Applicant: Teradata US, Inc
    Inventors: Kristi O'Grady, Modie Christon Smith, Ruth Gladys Fenwick, Douglas P. Brown, Ryan Speed
  • Patent number: 10366057
    Abstract: Data or one or more operations can be provided, based on one or more characteristics associated with the data and/or operations, to a designated computing group or pool of computing resources designated for handling the data and/or operations with the particular data characteristic(s). The designated computing group can, for example, be one of multiple computing groups in the same system or device. As such, all of the computing groups can still function together in the same system or device, for example, in parallel. However, each one of the multiple computing groups can, for example, be defined or predefined to include one or more computing resources that are more suitable for storing and/or processing data with one or more data characteristics or handle operations with one or more determined characteristics.
    Type: Grant
    Filed: May 24, 2013
    Date of Patent: July 30, 2019
    Assignee: Teradata US, Inc.
    Inventors: John Mark Morris, Donald Raymond Pederson, Douglas P. Brown
  • Patent number: 10261888
    Abstract: A test system receives environment information of a target database system, where the environment information includes information relating to hardware and software components of the target database system, and one or more of: definitions of workloads in the target database system, and settings of a scheduler in the target database system. The test system emulates an environment of the target database system using the received environment information, and database software is executed in the emulated environment in the test system.
    Type: Grant
    Filed: October 12, 2012
    Date of Patent: April 16, 2019
    Assignee: Teradata US, Inc.
    Inventors: Douglas P. Brown, Anita Richards, James Peter Colby, Jr., Jeffrey S. Shelton
  • Publication number: 20180329747
    Abstract: Capacity of a database system and/or a computing system that includes a database can be effectively changed from a current computing capacity to another computing capacity. This can be achieved by causing usage capacity of at least one of resource to be changed when the database is active. By way of example, capacity of a database system can be regulated by delaying the execution of the database work based on a target capacity. As a result, database work can take relatively longer to complete when the capacity of a database is effectively regulated to be below its full capacity. In effect, a portion of available capacity (excess capacity) can be made inaccessible to the database. However, excess capacity can be used to manage various services of the database in accordance with one or more service criteria (e.g., Service Level Goals or Agreements).
    Type: Application
    Filed: July 24, 2018
    Publication date: November 15, 2018
    Applicant: Teradata US, Inc.
    Inventors: Douglas P. Brown, Thomas Patrick Julien, Anita Richards, Louis Martin Burger
  • Patent number: 10089208
    Abstract: A data store system may include a storage array comprising a plurality of storage devices configured to store data. The data store may further include a processor array comprising a plurality of processors. The processor array may be in communication with the storage array. The processor array may receive workloads to be performed on the data. The processor may further process the workloads at a processing resource usage level of processing resources that is less than maximum available processing resources. The processing resource usage level may be associated with completion of at least a predetermined number of received workloads in accordance with the level of performance that is less than a total number of received workloads. The processor may further process the workloads at the processing resource level in response to presence of predetermined operating conditions. A method and computer-readable medium may also be implemented.
    Type: Grant
    Filed: March 14, 2014
    Date of Patent: October 2, 2018
    Assignee: Teradata US, Inc.
    Inventors: John Mark Morris, Anita Richards, Douglas P. Brown
  • Patent number: 10042674
    Abstract: Capacity of a database system and/or a computing system that includes a database can be effectively changed from a current computing capacity to another computing capacity. This can be achieved by causing usage capacity of at least one of resource to be changed when the database is active. By way of example, capacity of a database system can be regulated by delaying the execution of the database work based on a target capacity. As a result, database work can take relatively longer to complete when the capacity of a database is effectively regulated to be below its full capacity. In effect, a portion of available capacity (excess capacity) can be made inaccessible to the database. However, excess capacity can be used to manage various services of the database in accordance with one or more service criteria (e.g., Service Level Goals or Agreements).
    Type: Grant
    Filed: September 30, 2011
    Date of Patent: August 7, 2018
    Assignee: Teradata US, Inc.
    Inventors: Douglas P. Brown, Thomas Julien, Anita Richards, Louis Burger
  • Patent number: 9875146
    Abstract: A database system monitors a metric for a Workload Definition (WD) and adjusts a metric throttle for the WD to a new metric throttle level Cn, computed as the average of a theoretical metric level Cc that would drive a metric to a target T and a theoretical metric level Cr that would drive a rolling average of the metric to the target T.
    Type: Grant
    Filed: December 16, 2015
    Date of Patent: January 23, 2018
    Assignee: Teradata US, Inc.
    Inventors: Douglas P. Brown, Thomas Patrick Julien
  • Publication number: 20170357681
    Abstract: Various embodiments herein each include at least one of systems, methods and software for dynamic in-flight database request throttling. One such embodiment includes monitoring a database or multi-database system Workload Definition (WD) to identify queuing of a higher priority request while the database system is processing requests of a lower priority and when queuing of a higher priority request is identified, adjusting a metric throttle for the WD to a new metric throttle level Cn, computed as the average of a metric level Cc that would drive the metric to a target T and a metric level Cr that would drive a rolling average of the metric to the target T. This embodiment further includes evaluating lower priority in-flight requests for the current workload to identify abort candidate requests to abort and aborting the identified abort candidate requests and place the aborted requests in a delay queue for later execution.
    Type: Application
    Filed: December 21, 2016
    Publication date: December 14, 2017
    Inventors: Douglas P. Brown, Thomas Julien, Frank Roderic Vandervort
  • Patent number: 9805121
    Abstract: A database request can be processed at least partly based on one or more differences between multiple database systems and/or environments. The differences can, for example, include differences between one or more database capabilities respectively provided by the multiple database systems, differences between the representation of data in the multiple database systems, and differences in the interfaces for accessing the multiple database systems.
    Type: Grant
    Filed: February 18, 2014
    Date of Patent: October 31, 2017
    Assignee: Teradata US, Inc.
    Inventors: Douglas P. Brown, Michael G. Coutts, Sergio Ferragut
  • Patent number: 9766933
    Abstract: Computing capacity of a computing environment can be managed by controlling it associated processing capacity based on a target (or desired) capacity. In addition, fine-grained control over the processing capacity can be exercised. For example, a computing system can change the processing capacity (e.g., processing rate) of at least one processor operating based on a target capacity. The computing system may also be operable to change the processing capacity based on a measured processing capacity (e.g., a measured average of various processing rates of a processor taken over a period of time when a processor may have been operating at different processing rates over that period). By way of example, the processing rate of a processor can be switched between 1/8 and 2/8 of a maximum processing rate to achieve virtually any effective processing rates between them.
    Type: Grant
    Filed: December 2, 2011
    Date of Patent: September 19, 2017
    Assignee: Teradata US, Inc.
    Inventors: John Mark Morris, P. Keith Muller, Douglas P. Brown
  • Patent number: 9747334
    Abstract: Excess capacity available to a database system in a capacity controlled environment can be effectively managed. In particular, excess capacity that is not made available for normal operations of a database system can be used to manage errors, especially situations that may hinder expected performance of the database system. In addition, excess capacity can be used to optimize or further optimize database queries, especially those that meet a criterion (e.g., not fully optimize, not optimized as expected).
    Type: Grant
    Filed: September 30, 2011
    Date of Patent: August 29, 2017
    Assignee: Teradata US, Inc.
    Inventors: Louis Burger, Douglas P. Brown, Thomas Julien, Frank Roderic Vandervort
  • Patent number: 9418092
    Abstract: A system includes a multi-system database management system having a plurality of database systems. An index selection subsystem combines sets of query information from respective ones of the plurality of database systems into a workload. The index selection subsystem then generates candidate indexes from the workload, and selects recommended indexes from the candidate indexes based on one or more criteria.
    Type: Grant
    Filed: May 24, 2013
    Date of Patent: August 16, 2016
    Assignee: Teradata US, Inc.
    Inventors: John Mark Morris, Douglas P. Brown
  • Patent number: 9244793
    Abstract: A method, system, and computer program are disclosed. Statistics are read from a data dictionary on a target system. The statistics include statistics for a table in a database in the target system. The statistics are exported to a test system separate from the target system. A command is received to use the statistics in emulation. In response the statistics are copied to a cache in the test system and the target system is emulated on the test system using the statistics in the test system's cache.
    Type: Grant
    Filed: November 4, 2008
    Date of Patent: January 26, 2016
    Assignee: Teradata US, Inc.
    Inventors: Douglas P. Brown, Jeffrey S Shelton
  • Patent number: 9213741
    Abstract: A computer-implemented method, apparatus and article of manufacture for optimizing a database query. Resource usage of one or more resources of the computer system are monitored. A condition code representative of the monitored resource usage is stored. A cost model is modified using the stored condition code. A query execution plan is generated for the database query using the modified cost model. The query execution plan is then executed in order to retrieve data from a database stored on the computer system, wherein the retrieved data is presented to a user for subsequent use and analysis.
    Type: Grant
    Filed: March 28, 2013
    Date of Patent: December 15, 2015
    Assignee: Teradata US, Inc.
    Inventors: Louis Burger, Douglas P. Brown, Thomas Patrick Julien
  • Patent number: 9183255
    Abstract: A query is executed on a multi-database system. The multi-database system includes a first system database and a second system database. The query is partially executed on a first system database by generating a spool. It is determined that it is more efficient to store the spool on the second system database than to store the spool on the first system database, and in response the spool is stored on the second system database. The query execution is continued by accessing the spool on the second system database, completing execution of the query to produce a result, and storing the result.
    Type: Grant
    Filed: December 30, 2009
    Date of Patent: November 10, 2015
    Assignee: Teradata US, Inc.
    Inventors: Douglas P. Brown, Scott E. Gnau, John M. Morris
  • Patent number: 9116929
    Abstract: A system and method for managing one or more database systems, wherein the database systems perform database queries to retrieve data stored by the database systems. One or more regulators are used for managing the database systems, wherein the regulators monitor workload priority influenced data temperature in order to allocate resources for the systems. The data temperature is a measure of physical accesses to logical data, and the workload priority is used to further define data temperature, in order to optimize data storage placement and data access decisions.
    Type: Grant
    Filed: March 12, 2007
    Date of Patent: August 25, 2015
    Assignee: Teradata US, Inc.
    Inventors: John Mark Morris, Anita Richards, Douglas P. Brown