Patents by Inventor Jeffrey ZOCH

Jeffrey ZOCH 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: 12282475
    Abstract: Systems, devices, and techniques are disclosed for multi-threaded dynamic queries on an unpartitioned database. An instruction to perform a database operation on rows of a database may be received. Processing threads may be generated by generating three random numbers. A starting point of a processing thread may be set to a first random number, an offset may be set to a second random number, and an order may be based on a third random number. The processing threads may each generate a dynamic query. A dynamic query generated by a processing thread may include an instruction to perform the database operation on rows of the database based on the offset, starting point, and order for the processing thread. Each dynamic query may be run against the database to perform the database operation.
    Type: Grant
    Filed: November 16, 2021
    Date of Patent: April 22, 2025
    Assignee: Salesforce, Inc.
    Inventors: Karthik Mohan Subramanian, Varun Mohta, Ted Liu, Yeshwant Sai Madanagopal, Jeffrey Zoch, Bo Xia
  • Publication number: 20230153293
    Abstract: Systems, devices, and techniques are disclosed for multi-threaded dynamic queries on an unpartitioned database. An instruction to perform a database operation on rows of a database may be received. Processing threads may be generated by generating three random numbers. A starting point of a processing thread may be set to a first random number, an offset may be set to a second random number, and an order may be based on a third random number. The processing threads may each generate a dynamic query. A dynamic query generated by a processing thread may include an instruction to perform the database operation on rows of the database based on the offset, starting point, and order for the processing thread. Each dynamic query may be run against the database to perform the database operation.
    Type: Application
    Filed: November 16, 2021
    Publication date: May 18, 2023
    Inventors: Karthik Mohan Subramanian, Varun Mohta, Ted Liu, Yeshwant Sai Madanagopal, Jeffrey Zoch, Bo Xia
  • Patent number: 11593220
    Abstract: Examples include a ticketing system for managing performance of computer services. The ticketing system includes a ticket database to store a plurality of tickets, each ticket defining a job to be performed on a computing system, and a master to create a ticket, store the ticket in the ticket database, and update the ticket. The ticketing system includes a scheduler to determine whether to create the ticket based at least in part on a set of conditions, and to request the master to create the ticket when the ticket is to be created, and a worker to get the ticket from the master, perform the job defined by the ticket, and request the master to update the ticket with a status of the ticket. The ticketing system includes a supervisor to request the master to find a stale ticket, and, if found, to request the worker to abort performance of the job defined by the stale ticket.
    Type: Grant
    Filed: December 10, 2019
    Date of Patent: February 28, 2023
    Assignee: salesforce.com, inc.
    Inventors: Jeffrey Zoch, Ted Liu, Karthik Mohan Subramanian, Youngjin Yu, Bo Xia, Yeshwant Sai Madanagopal
  • Patent number: 11157314
    Abstract: Examples include a computer-implemented method for determining one or more observations about a computing system, determining a plurality of sets of one or more actions based at least in part on a plurality of policies and the one or more observations; reducing the plurality of sets of one or more actions to generate a reduced set of actions, the reduced set of actions including scheduling a computing system to execute the reduced set of actions by requesting one or more idempotent tickets to be created in a ticketing system; and performing, or causing to be performed, the reduced set of actions.
    Type: Grant
    Filed: December 10, 2019
    Date of Patent: October 26, 2021
    Assignee: salesforce.com, inc.
    Inventors: Jeffrey Zoch, Ted Liu, Karthik Mohan Subramanian, Youngjin Yu, Bo Xia, Yeshwant Sai Madanagopal
  • Publication number: 20210318935
    Abstract: System and methods are described for restoring a database by receiving a request to restore a database in a cloud computing environment, generating a restore plan for the database based at least in part on previously stored database restore outcomes and error probabilities of full backups, incremental backups, and redo logs, restoring the database from an archive according to the restore plan, and storing an outcome of the database restore.
    Type: Application
    Filed: April 8, 2020
    Publication date: October 14, 2021
    Inventors: Lawrence JACOBS, Karthik Mohan SUBRAMANIAN, Jeffrey ZOCH, Ted LIU, Youngjin YU, Yeshwant Sai MADANAGOPAL
  • Publication number: 20210216502
    Abstract: System and methods are described for synchronization of delete operations between primary a secondary databases. The method includes identifying a chunk of records in a secondary database. The method also includes sending a message to a primary database that identifies the chunk of records and asks whether any records of the chunk records are delete-able. The method also includes receiving a response to the message from the primary database. The response indicates which records of the chunk records are delete-able. The method also includes deleting each record of the chunk of records from the secondary database that the message indicated was delete-able.
    Type: Application
    Filed: January 9, 2020
    Publication date: July 15, 2021
    Inventors: Karthik Mohan SUBRAMANIAN, Ted LIU, Jeffrey ZOCH, Yeshwant Sai MADANAGOPAL, Youngjin YU
  • Publication number: 20210173745
    Abstract: Examples include a ticketing system for managing performance of computer services. The ticketing system includes a ticket database to store a plurality of tickets, each ticket defining a job to be performed on a computing system, and a master to create a ticket, store the ticket in the ticket database, and update the ticket. The ticketing system includes a scheduler to determine whether to create the ticket based at least in part on a set of conditions, and to request the master to create the ticket when the ticket is to be created, and a worker to get the ticket from the master, perform the job defined by the ticket, and request the master to update the ticket with a status of the ticket. The ticketing system includes a supervisor to request the master to find a stale ticket, and, if found, to request the worker to abort performance of the job defined by the stale ticket.
    Type: Application
    Filed: December 10, 2019
    Publication date: June 10, 2021
    Inventors: Jeffrey ZOCH, Ted LIU, Karthik Mohan SUBRAMANIAN, Youngjin YU, Bo Xia, Yeshwant Sai MADANAGOPAL
  • Publication number: 20210173703
    Abstract: Examples include a computer-implemented method for determining one or more observations about a computing system, determining a plurality of sets of one or more actions based at least in part on a plurality of policies and the one or more observations; reducing the plurality of sets of one or more actions to generate a reduced set of actions, the reduced set of actions including scheduling a computing system to execute the reduced set of actions by requesting one or more idempotent tickets to be created in a ticketing system; and performing, or causing to be performed, the reduced set of actions.
    Type: Application
    Filed: December 10, 2019
    Publication date: June 10, 2021
    Inventors: Jeffrey ZOCH, Ted LIU, Karthik Mohan SUBRAMANIAN, Youngjin YU, Bo Xia, Yeshwant Sai MADANAGOPAL