Cloud-based crm data storage system with query support

A cloud-based (CRM) data storage system with query support, wherein the system comprises:

• a memory storing one or more processor-executable routines;
• and
• a processor communicatively coupled to the memory, the processor configured to execute the one or more processor-executable routines to facilitate data backup and data retrieval operations for customer data, wherein the processor comprises:
• a client interface configured to receive source data corresponding to one or more customers, wherein the source data comprises at least one of data schema, records/CRM data and blob data;
• a data transformation module configured to transform the received source data into a columnar storage format to generate converted source data and generate index files for the converted source data;
• a data query engine configured to receive a data query from the one or more customers, wherein the data query comprises one or more query parameters and wherein the data query engine is configured to:
• identify index files and/or data files to be scanned from the converted source data based on the one or more query parameters and versioning data;
• and
• scan the identified index files and/or data files to generate data query results.

A method of providing query support in a cloud-based (CRM) data storage system, the method comprising:

• initiating a data backup operation for one or more customers of the cloud-based data storage system,
• receiving source data corresponding to the one or more customers, wherein the source data comprises at least one of data schema, records/CRM data and blob data;
• transforming the received source data into a columnar storage format to generate converted source data;
• generating index files for the converted source data;
• storing versioning data and corresponding index files for each customer;
• receiving a data query from one or more customers, wherein the data query having one or more query parameters;
• identifying index files and/or data files to be scanned from the converted source data based on the one or more query parameters and the versioning data;
• scanning the identified index files and/or data files to generate data query results.