Salesforce, Inc.

Salesforce Com, Inc.

Jeffrey Zoch

Ted Liu

Youngjin Yu

Karthik Mohan Subramanian

Yeshwant Sai Madanagopal

Bo Xia

Steven Raspudic

Hefeng Yuan

Praveenkumar Bagavathiraj

Goutham Meruva

Varun Mohta

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.

System and method for synchronizing delete operations between primary and secondary databases

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.

Multi-threaded dynamic queries on an unpartitioned database

Techniques are disclosed relating to archive operations for database systems. In some embodiments, a database system initiates one or more archive operations to archive one or more data extents for a database maintained by the database system. The system may halt archive activity for the database, in response to determining that archive operations for a threshold amount of data extents are initiated but not completed. The system may cancel at least one of the one or more archive operations. The system may determine to resume activity for the database based on determining that a threshold timer interval has elapsed and determining that a threshold amount of storage space is available for the database system. Disclosed embodiments may improve database availability, relative to traditional techniques.

Archive control techniques for database systems

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.

Ticketing system for managing computing services

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.

Growing community of inventors

San Francisco, CA, United States of America

Jeffrey Zoch