Systems and methods for exporting and/or importing data

A computer processing system comprising:

• a processing unit;
• a communication interface;
• and
• a non-transitory computer-readable storage medium storing instructions, which when executed by the processing unit, cause the processing unit to:
• receive a plurality of event records, each event record including information about changes to application data, the application data comprising content managed by an application;
• store the plurality of event records in near real-time in a predefined storage location;
• receive a client export request for a backup of the application data;
• and
• in response to the client export request:
• determine if a client export request has been previously requested for the application data;
• if there has been at least one previous client export, determine whether a most recent previous client export request was received less than a threshold period of time ago;
• upon determining that the most recent previous client export request was received less than the threshold period of time ago, create one or more backup files based on a subset of the stored event records in the predefined storage location, wherein the subset of the stored event records includes event records received since the most recent previous client export request;
• and
• allow export of the one or more backup files to a local client storage location.

A computer-implemented method, comprising:

• receiving a backup from a local client storage location;
• generating, based on the received backup, a plurality of event records, wherein each event record comprises information used to restore application data managed by an application;
• creating a plurality of write requests based on the plurality of event records, wherein each write request includes information about an object including the object identifier, content of the object, and a sequence number indicating a version of the object;
• communicating the plurality of write requests to a database application for restoring one or more objects in a storage database;
• locking access to the storage database;
• comparing, by the database application and for each write request, the sequence number received in the write request with a sequence number of a corresponding object stored in the storage database;
• upon determining, for each write request, that the sequence number received in the write request is higher than the corresponding sequence number of the corresponding object stored in the storage database, writing the content of the object to the storage database and updating the sequence number of the object in the storage database to match the sequence number received in the write request;
• receiving confirmation message from the database application, once the one or more objects are restored in the storage database;
• and
• unlocking access to the storage database in response to the confirmation message.