公开(公告)号：US20200250155A1

公开(公告)日：2020-08-06

申请号：US16851387

申请日：2020-04-17

Applicant: salesforce.com, inc.

Inventor： Patrick James Helland

IPC: G06F16/21 ,  G06F16/25 ,  G06F16/27

Abstract: In accordance with embodiments, there are provided mechanisms and methods for facilitating dynamically unified system of record in an on-demand services environment in a multi-tenant environment according to one embodiment. In one embodiment and by way of example, a method includes integrating, by and incorporating into the database system, a plurality of subsystems into a unified system of record (“unified system), where each subsystem is independent of and incompatible with other subsystems of the plurality of subsystems, and collectively managing the plurality of subsystems, where collectively managing includes facilitating common communication within and between and uniform management of the plurality of subsystems based on common communication criteria and unified storage of data associated with the plurality of subsystems.

公开(公告)号：US10691696B2

公开(公告)日：2020-06-23

申请号：US15420342

申请日：2017-01-31

Applicant: salesforce.com, inc.

Inventor： Patrick James Helland ,  James E. Mace ,  Thomas Fanghaenel

IPC: G06F16/2455

Abstract: This disclosure provides various techniques that may allow for accessing values stored in a data structure that stores multiple values corresponding to database transactions using a skip list. A key may be used to traverse the skip list to access data associated with the key. The skip list maintains on ordering of multiple keys, each associated with a particular record in the data structure, using indirect links between data records in the data structure that reference buckets included in hash table. Each bucket includes pointers to one or more records in the skip list.

公开(公告)号：US10592353B2

公开(公告)日：2020-03-17

申请号：US15634796

申请日：2017-06-27

Applicant: salesforce.com, inc.

Inventor： Jameison Bear Martin ,  Nathaniel Wyatt ,  Patrick James Helland ,  Thomas Fanghaenel ,  Terry Chong ,  Subho Sanjay Chatterjee

IPC: G06F11/00 ,  G06F11/14 ,  G06F16/21

Abstract: Systems and methods are provided for performing a point-in-time restore of data of a first tenant of a multitenanted database system. Metadata can be located to identify an archival version of first data of the first tenant stored in immutable storage of the database system. The archival version includes a most recently committed version of each datum prior to a first point in time. By using the metadata, a restore reference set is mapped into a target database instance of the database system. The mapping can be performed when all existing data for a tenant is to be the archival version, and where versions of data and records committed after the point in time are not available to the target database instance.

公开(公告)号：US10346386B2

公开(公告)日：2019-07-09

申请号：US15343969

申请日：2016-11-04

Applicant: salesforce.com, inc.

Inventor： Subho Sanjay Chatterjee ,  Patrick James Helland ,  Nathaniel Wyatt ,  James E. Mace ,  Punit B. Shah

IPC: G06F16/23

Abstract: Systems and methods provide multi-version concurrency control of database records with uncommitted transactions. The system and methods may include receiving a query regarding a transaction counter number. When a transaction header identifying data is updated with the assigned transaction counter number, the updated transaction header may be used in identifying data as an instance of multiversion concurrency control information by the received query. A key lookup may be performed, and when the key lookup encounters an uncommitted row for a transaction number, a corresponding transaction header identifying data to identify a data array element to determine whether the transaction number is committed, and determining the transaction counter number when the transaction number is committed. The transaction counter number may be stamped on the row version record when it is determined that the row is committed.

公开(公告)号：US20180129693A1

公开(公告)日：2018-05-10

申请号：US15343969

申请日：2016-11-04

Applicant: salesforce.com, inc.

Inventor： Subho Sanjay Chatterjee ,  Patrick James Helland ,  Nathaniel Wyatt ,  James E. Mace ,  Punit B. Shah

IPC: G06F17/30

CPC classification number: G06F16/2343 ,  G06F16/2329

Abstract: Systems and methods provide multi-version concurrency control of database records with uncommitted transactions. The system and methods may include receiving a query regarding a transaction counter number. When a transaction header identifying data is updated with the assigned transaction counter number, the updated transaction header may be used in identifying data as an instance of multiversion concurrency control information by the received query. A key lookup may be performed, and when the key lookup encounters an uncommitted row for a transaction number, a corresponding transaction header identifying data to identify a data array element to determine whether the transaction number is committed, and determining the transaction counter number when the transaction number is committed. The transaction counter number may be stamped on the row version record when it is determined that the row is committed.

公开(公告)号：US20170322994A1

公开(公告)日：2017-11-09

申请号：US15148516

申请日：2016-05-06

Applicant: salesforce.com, inc.

Inventor： Venkateswararao Jujjuri ,  Sameer Tiwari ,  James John Seeger, JR. ,  Patrick James Helland

IPC: G06F17/30 ,  H04L29/06 ,  H04L29/08

CPC classification number: H04L63/102 ,  G06F17/30575 ,  H04L67/1095 ,  H04L67/1097 ,  H04L67/125 ,  H04L67/42

Abstract: Log entries are provided with unique entry identifiers, which may be sequenced in an incremental or decremental order, to create or to update a distributed log which may be replicated and distributed to multiple servers in a network. The entry identifiers may be appended to their respective log entries. Files, records or data which are identified by their respective log entries may be transmitted regardless of the sequence of the entry identifiers.