Patents by Inventor Anita Richards

Anita Richards 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).

  • Patent number: 11449502
    Abstract: In a database system, at least one metric associated with resources in a database system used by multiple classes of requests is monitored, where a first of the multiple classes is associated with a lower priority than a second of the multiple classes. A throttle limit is calculated for requests of the first class, based on the monitored metric. The calculated throttle limit is used to determine scheduling of the request of the first class for execution.
    Type: Grant
    Filed: November 12, 2010
    Date of Patent: September 20, 2022
    Assignee: Teradata US, Inc.
    Inventors: Anita Richards, 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: 9524296
    Abstract: The claimed invention provides a method for managing response time in a database system. The method includes monitoring a plurality of events that impact on the operation of the database system, identifying at least one event that impacts on at least one of the performance and availability of the database, and initiating an action in response to the identified event.
    Type: Grant
    Filed: December 6, 2007
    Date of Patent: December 20, 2016
    Assignee: Teradata US, Inc.
    Inventors: Anita Richards, Douglas Brown
  • 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
  • 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
  • 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
  • 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
  • Patent number: 8924981
    Abstract: Requests to be executed in the database system are received, where a plurality of the requests are provided in a queue for later execution. Priority indicators are calculated for assignment to corresponding ones of the plurality of requests in the queue, where the priority indicators are calculated based on delay times and predefined priority levels of the requests. The requests in the queue are executed in order according to the calculated priority indicators.
    Type: Grant
    Filed: November 12, 2010
    Date of Patent: December 30, 2014
    Assignee: Teradat US, Inc.
    Inventors: Douglas P. Brown, Thomas P. Julien, Louis M. Burger, Anita Richards
  • Patent number: 8818988
    Abstract: A database system includes an optimizer to generate resource estimates regarding execution of a request in the database system, and a regulator to monitor execution of a request and to adjust a priority level of the request based on the monitored execution and based on the resource estimates provided by the optimizer. The regulator is executable to further feed back statistics regarding execution of the request to the optimizer to improve accuracy of resource estimates provided by the optimizer.
    Type: Grant
    Filed: June 11, 2009
    Date of Patent: August 26, 2014
    Assignee: Teradata US, Inc.
    Inventors: Douglas P. Brown, Anita Richards, Louis M. Burger, Stephen A. Brobst
  • Patent number: 8775413
    Abstract: A computer-implemented method, apparatus and article of manufacture for optimizing a database query. A query execution plan is generated for the database query, which may be stored in an in-line query capture database. Execution of the query execution plan may be monitored in order to generate performance information, which also may be stored in the in-line query capture database. The data stored in in-line query capture database may be used during the initial generation of query execution plans, as well as for the re-optimization of a query execution plan, during the execution of the query execution plan.
    Type: Grant
    Filed: August 22, 2008
    Date of Patent: July 8, 2014
    Assignee: Teradata US, Inc.
    Inventors: Douglas P. Brown, Anita Richards, Thomas P. Julien, Louis M. Burger
  • Patent number: 8745032
    Abstract: A filter receives a request to perform an operation in a database system, and the filter receives a resource estimate relating to the request from an optimizer. The filter determines whether the resource estimate exceeds an available resource of the database system, and if so, the filter rejects the request prior to execution of the request.
    Type: Grant
    Filed: November 23, 2010
    Date of Patent: June 3, 2014
    Assignee: Teradata US, Inc.
    Inventors: Douglas P. Brown, Anita Richards, Thomas P. Julien, Louis M. Burger
  • Publication number: 20140108001
    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: Application
    Filed: October 12, 2012
    Publication date: April 17, 2014
    Inventors: Douglas P. Brown, Anita Richards, James Peter Colby, JR., Jeffrey S. Shelton
  • Publication number: 20140089311
    Abstract: A system, method, and computer-readable medium that facilitate classification of database requests as problematic based on estimated processing characteristics of the request are provided. Estimated processing characteristics may include estimated skew including central processing unit skew and input/output operation skew, central processing unit duration per input/output operation, and estimated memory usage. The estimated processing characteristics are made on a request step basis. The request is classified as problematic responsive to determining one or more of the estimated characteristics of a request step exceed a corresponding threshold. In this manner, mechanisms for predicting bad query behavior are provided. Workload management of those requests may then be more successfully provided through workload throttles, filters, or even a more confident exception detection that correlates with the estimated bad behavior.
    Type: Application
    Filed: September 26, 2012
    Publication date: March 27, 2014
    Inventors: Anita Richards, Douglas Brown, Bruce Britton, Todd Walter
  • Patent number: 8645425
    Abstract: A method, computer program and database system are disclosed for guiding the development of workload group definition (WD) classifications for a database system having resources. WD classification information is provided where a workload group is a set of system requests having characteristics defined by a WD and a WD classification identifies one or more WDs with similar performance requirements. If WD classification is not acceptable, one or more of the following functions is performed until WD classification is acceptable: (a) splitting one or more WDs; and (b) merging two or more WDs.
    Type: Grant
    Filed: February 25, 2004
    Date of Patent: February 4, 2014
    Assignee: Teradata US, Inc.
    Inventors: Douglas P. Brown, Anita Richards, Bhashyam Ramesh
  • Patent number: 8612989
    Abstract: A computer running a database system receives a query. The database system services a plurality of collections. Each collection includes a plurality of workload groups. Each collection is assigned a percentage of a resource for its use. A donor collection, Cdonor, is not using its assigned percentage of the resource during a time slice tJ. The length in time of time slice tJ is less than a time in which the query is expected to execute. The query is assigned to a workload group. The assignment is determined by the computer applying a workload classification and an exception criteria to parameters of the query. The workload group is part of a donee collection, Cdonee, different from the donor collection. The donor collection donates, through the computer, use of a boost percentage of the resource to the donee collection during the time slice tJ.
    Type: Grant
    Filed: December 13, 2010
    Date of Patent: December 17, 2013
    Assignee: Teradata US, Inc.
    Inventors: Anita Richards, Douglas P. Brown
  • Patent number: 8606749
    Abstract: A request is received at a computer programmed as a database system. The request is a request selected from the group consisting of a query and a utility. A business concept is associated with the request. The business concept is a business concept selected from the group consisting of “who” information defining the source of the request, “what” information defining the processing to be performed by the request, “where” information defining a database object that the request will affect. The computer maps the received request to a database feature setting by mapping the business concept associated with the request to a workload. The workload is defined by a workload definition including a workload classification attribute that maps to the business concept of the request, a workload throttling attribute that defines conditions under which requests assigned to the workload are throttled. Submission of the request to the database system for processing is delayed based on the workload definition.
    Type: Grant
    Filed: February 8, 2010
    Date of Patent: December 10, 2013
    Assignee: Teradata US, Inc.
    Inventors: Douglas P. Brown, Anita Richards, Bhashyam Ramesh
  • Patent number: 8555288
    Abstract: A method, computer program, and system are disclosed for executing a utility on a database system having a plurality of database system nodes. Each database system node has an existing load. An increased load on the database system required to execute the utility is determined. The existing load on each of the database system nodes is determined. The increased load is distributed in such a way as to balance the load among the database system nodes.
    Type: Grant
    Filed: May 17, 2006
    Date of Patent: October 8, 2013
    Assignee: Teradata US, Inc.
    Inventors: Douglas P. Brown, Anita Richards, Bruce Wayne Britton, Todd A. Walter