公开(公告)号：US10678757B2

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

申请号：US15093920

申请日：2016-04-08

Applicant: salesforce.com, inc.

Inventor： Aakash Pradeep ,  Abhishek Bangalore Sreenivasa ,  Adam Torman ,  Alex Warshavsky ,  Ivan Daya Weiss ,  Samarpan Jain ,  Somesh Sasalatti ,  Soumen Bandyopadhyay ,  Choapet Oravivattanakul

IPC: G06F16/182 ,  G06F16/27 ,  G06F16/28 ,  G06F16/13 ,  G06F16/25

Abstract: A database system may determine that a database is unavailable to generate an identifier for an event or that events may not be written to the database. As a result, the database system may write the event to a low-latency, supplementary file system. The database system may determine that the database is available at a later time, and read the event from the supplementary file system, store the event in a memory component, and then delete the event from the supplementary file system. The database system may then access the database to generate an identifier for the event, write the event to the database, and then delete the event from the memory component.

公开(公告)号：US20200097373A1

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

申请号：US16222925

申请日：2018-12-17

Applicant: salesforce.com, inc.

Inventor： Yingwu Zhao ,  Samarpan Jain ,  Hal Scott HILDEBRAND ,  Alexey Syomichev ,  Emin Eliot Gerba ,  Igor Pesenson ,  David William Spragg ,  Jay Hurst ,  Soumen BANDYOPADHYAY

IPC: G06F11/14

Abstract: A method and apparatus for a mechanism of disaster recovery and instance refresh in an event recordation system are described. A first request for events associated with a first topic is received. A first set of events associated with the first topic are retrieved from a primary event recordation system. Each event from the first set of events includes a first commit identifier indicating the order with which each event is stored in the primary event recordation system. For each event from the first set of events a first replay identifier is determined based on the first commit identifier and a first value of a low commit identifier. The first replay identifier is exposed to event consumers for identifying the event. In response to the first request each event from the first set of events is transmitted with the replay identifier.

公开(公告)号：US10452462B2

公开(公告)日：2019-10-22

申请号：US15481641

申请日：2017-04-07

Applicant: salesforce.com, inc.

Inventor： Choapet Oravivattanakul ,  Alex Warshavsky ,  Samarpan Jain

IPC: G06F17/30 ,  G06F11/07

Abstract: System parses fields in a log entry, corresponding to a system user event, to identify a log code for a first and second log entry types. System identifies a common schema for the first and second log entry types. System identifies a schema identifier by applying the common schema to the log entry. The schema identifier corresponds to a schema in a container for the first log entry type or a container for the second log entry type. The container for the first log entry type includes the common schema and a first schema that is specific to the first log entry type. The container for the second log entry type includes the common schema and a second schema that is specific to the second log entry type. System identifies log data by using the corresponding schema to parse fields in the log entry, and outputs the log data.

公开(公告)号：US20190095532A1

公开(公告)日：2019-03-28

申请号：US15717772

申请日：2017-09-27

Applicant: salesforce.com, inc.

Inventor： Eli Levine ,  Samarpan Jain ,  James Ferguson ,  Jan Asita Fernando

IPC: G06F17/30 ,  G06F21/62

Abstract: Disclosed are examples of systems, apparatus, methods and computer program products for providing run-time querying of muli-tenant non-relational database objects. A database system maintains a multi-tenant non-relational database associated with a number of enterprises, a number of records, and a number of data objects for each of the enterprises, each data object having at least one composite key field. A request is received during runtime to query data related to a data object, and the system determines that the data object is defined to be used in associated with a non-relational database. The system then retrieves a metadata model of the data object, determines that the request includes at least one composite key field for the data object, and processes the requery to query data in synchronous fashion. Finally, a query response is provided to the user.

公开(公告)号：US10185603B2

公开(公告)日：2019-01-22

申请号：US15946596

申请日：2018-04-05

Applicant: salesforce.com, inc.

Inventor： Aakash Pradeep ,  Adam Torman ,  Alex Warshavsky ,  Samarpan Jain

IPC: G06F9/54 ,  H04L29/06 ,  H04L29/08 ,  G06F3/06 ,  G06F17/30

Abstract: Computer-implemented methods and systems are provided. The system includes a data store that is configured to store events in an event table, a temporary events file storage system (TEFSS), and a cluster of application servers. The cluster includes a first application server that generates events, and a second application server that includes an events file uploader service. When the first application server is unable to directly write events to the data store, an indirect events writer generates events file(s), and writes the events file(s) to the TEFSS. Each events file includes a plurality of events flushed from an in-memory buffer service at the first application server. When the events file uploader service determines that the first application server is inactive, it reads the events file(s) from the TEFSS, and writes the events from each of the events files to the data store.

公开(公告)号：US10178156B2

公开(公告)日：2019-01-08

申请号：US14688917

申请日：2015-04-16

Applicant: salesforce.com, inc.

Inventor： Aakash Pradeep ,  Adam Torman ,  Alex Warshavsky ,  Samarpan Jain ,  Soumen Bandyopadhyay ,  Thomas William D'Silva

IPC: G06F15/177 ,  H04L29/08 ,  G06F17/30 ,  G06F11/00

Abstract: A database system captures custom information of a header section associated with a logged interaction of a user. The database system may receive a hypertext transfer protocol (http) message including the header section and determine whether the header section includes a predetermined data pattern associated with the custom information added by a second application that is different than a first application which initiated the http message. The database system may extract the custom information from the header section in response to determining that the header section includes the predetermined data pattern. The custom information and event data extracted from the logged interaction of the user may be stored on the database system as a storage element.

公开(公告)号：US10037233B2

公开(公告)日：2018-07-31

申请号：US15443219

申请日：2017-02-27

Applicant: salesforce.com, inc.

Inventor： Aakash Pradeep ,  Adam Torman ,  Alex Warshavsky ,  Samarpan Jain

IPC: G06F3/00 ,  G06F9/44 ,  G06F9/46 ,  G06F13/00 ,  G06F9/54 ,  G06F17/30 ,  G06F3/06 ,  H04L29/08 ,  H04L29/06

CPC classification number: G06F9/542 ,  G06F3/061 ,  G06F3/0619 ,  G06F3/0643 ,  G06F3/0656 ,  G06F3/067 ,  G06F16/13 ,  G06F16/16 ,  G06F16/183 ,  G06F16/955 ,  H04L47/50 ,  H04L67/02 ,  H04L67/06 ,  H04L67/1004 ,  H04L67/2842 ,  H04L67/42

Abstract: Computer-implemented methods and systems are provided for writing events to a data store. An application server generates events, the data store that stores the events, and a temporary events file storage system (TEFSS) temporarily stores groups of events as events files. When events are unable to be written directly to the data store, an indirect events writer is invoked that includes event capture threads each being configured to generate a particular events file, and write it to the TEFSS. Each events file includes a plurality of events flushed from an in-memory buffer service. An events file uploader service reads the events file(s) from the TEFSS, and then writes the events from each of the events files to the data store.

公开(公告)号：US20180096012A1

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

申请号：US15283119

申请日：2016-09-30

Applicant: salesforce.com, inc.

Inventor： Alex Warshavsky ,  Adam Torman ,  Eli Levine ,  Jan Asita Fernando ,  Samarpan Jain

IPC: G06F17/30

CPC classification number: G06F16/2282

Abstract: Disclosed are examples of systems, apparatus, methods and computer program products for updating and managing multi-tenant non-relational database schemas. A database system maintains a multi-tenant non-relational database associated with multiple enterprises. A number of records are stored for each of the enterprises. The system also maintains a dynamic virtual table storing a number of records. A request is received from a user of the database system to define a data object within the database system. The request is processed, and an object script is generated based on the request, the object script defining one or more database columns in the database system that are associated with the data object. The dynamic virtual table is updated such that one or more virtual columns match the database column definitions in the object script. Existing columns of a shared table in the multi-tenant non-relational database are then updated to match the virtual columns in the dynamic virtual table.

公开(公告)号：US20180095790A1

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

申请号：US15281559

申请日：2016-09-30

Applicant: salesforce.com, inc.

Inventor： Aakash Pradeep ,  Abhishek Sreenivasa ,  Adam Torman ,  Alex Warshavsky ,  Samarpan Jain ,  Soumen Bandyopadhyay

IPC: G06F9/48 ,  G06F17/30

CPC classification number: G06F9/4887 ,  G06F17/30115

Abstract: Disclosed are some examples of systems, methods, apparatus and computer program products for scheduling jobs to process log files. In some implementations, a scheduler can be configured to identify a final state of a previously scheduled first job as a failure in execution by one or more processors. For instance, the first job may have been defined to process a first input log file saved to a database during a first timeframe of a sequence of timeframes of a designated interval. The scheduler can detect a second input log file saved to the database. The scheduler can then define a second job to process the first input log file and the second input log file and schedule the second job in association with a second timeframe of the sequence.

公开(公告)号：US20180025113A1

公开(公告)日：2018-01-25

申请号：US15218468

申请日：2016-07-25

Applicant: salesforce.com, Inc.

Inventor： Adam Torman ,  Abhishek Bangalore Sreenivasa ,  Aakash Pradeep ,  Ivan Daya Weiss ,  Soumen Bandyopadhyay ,  Alex Warshavsky ,  Samarpan Jain

IPC: G06F19/00 ,  G06F17/30

CPC classification number: G16H10/60 ,  G06F16/211 ,  G06F16/2471

Abstract: Disclosed are some examples of database systems, methods, and computer program products for run-time schema for event records. In some implementations, event records satisfying a query can be identified. Attribute-value pairs of data of those identified event records can be stored in an unstructured data field of an event record.