Storing and processing data organized as flexible records

A computer readable medium storing instructions that, when executed by a processor, causes the processor to persist data received from different data sources, the instructions when executed cause the processor to:

• receive a first data record from a data source having a schema, the data record including data fields structured according to the schema;
• analyze the schema to identify each data field included in the data record;
• generate a flexible record identifier associated with the data record;
• extract a value from the data record associated with each identified data field included in the data record;
• store in a repository a different entry for each value, each entry including the flexible record identifier and a field name associated with the data field from which the value was extracted;
• receive a data request for accessing data associated with the data record;
• identify each entry in the local store associated with the flexible record identifier;
• and
• transmit the values included in the identified entries in response to the data request.

A method for synchronizing data between a client device and a server repository, the method comprising:

• receiving a data synchronization request from the client device;
• identifying a flexible record that was previously transmitted to the client device, the flexible record comprising a plurality of separate data store entries, each entry storing data associated with a single data field of a database record and being associated with a flexible record identifier uniquely identifying the flexible record;
• determining that the flexible record has been modified since the flexible record was previously transmitted to the client device;
• generating a delta flexible record based on the modifications to the flexible record, the delta flexible record including only data store entries associated with the flexible record identifier that were modified since the flexible record was preciously transmitted to the client device;
• and
• transmitting the delta flexible record to the client device in response to the data synchronization request.