A backend data aggregation and customer experience (CX) systems and methods for processing very-large enterprise CX data. A columnar data store has a transform processor coupled thereto via a data communication network. The transform processor is configured to receive customer experience data from a plurality of data sources and to dynamically transform the received data into a columnar data schema format for storage in the columnar data store. A dynamic Object-Relational Mapper (ORM) is configured to dynamically map the transformed data to structured data based on metadata associated therewith and to store the structured data in the columnar data store.
Legal claims defining the scope of protection, as filed with the USPTO.
2. The system of claim 1, wherein the at least one backend processor comprises a customer experience (CX) processor coupled to the columnar data store via the data communication network, and wherein the memory devices further store computer-executable instructions that, when executed by the CX processor, configure the CX processor to receive a request for a query from a user via a web application and parse the query into a structured query language.
3. The system of claim 2, wherein the at least one backend processor comprises a query processor coupled to the columnar data store via the data communication network, and wherein the memory devices further store computer-executable instructions that, when executed by the query processor, configure the query processor to execute the parsed query against the columnar data store to retrieve structured data responsive to the query.
4. The system of claim 3, further comprising a display coupled to the query processor via the data communication network, the display configured to display the retrieved structured data in an aggregated format for the user.
5. The system of claim 2, wherein the memory devices further store computer-executable instructions that, when executed by the CX processor, configure the CX processor to parse the query as a function of the metadata associated with the structured data stored in the columnar data store.
6. The system of claim 5, wherein the memory devices further store computer-executable instructions that, when executed by the CX processor, configure the CX processor to translate the query into Structured Query Language (SQL) using the metadata.
7. The system of claim 1, wherein the at least one backend processor comprises a transform processor, and wherein the memory devices further store an Extract Transform Load process that, when executed by the transform processor, configure the transform processor to dynamically transform the data into the columnar data schema format.
8. The system of claim 7, further comprising a messaging cluster coupled to the transform processor via the data communication network, the messaging cluster configured to perform stream processing on the data received from the plurality of data sources, wherein the transform processor dynamically transforms the stream processed data into the columnar data schema format.
10. The method of claim 9, further comprising receiving, by the backend processor, a request for a query from a user via a web application and parsing, by the backend processor, the query into a structured query language.
11. The method of claim 10, further comprising executing, by the backend processor, the parsed query against the columnar data store to retrieve structured data responsive to the query.
12. The method of claim 11, further comprising displaying the retrieved structured data in an aggregated format for the user.
13. The method of claim 10, wherein parsing the query comprises parsing the query as a function of the metadata associated with the structured data stored in the columnar data store.
14. The method of claim 13, further comprising translating the query into Structured Query Language (SQL) using the metadata.
15. The method of claim 9, wherein transforming the data comprises executing an Extract Transform Load process to dynamically transform the data into the columnar data schema format.
16. The method of claim 9, further comprising performing, by the backend processor, stream processing on the data received from the plurality of data sources, wherein transforming the data comprises dynamically transforming the stream processed data into the columnar data schema format.
18. The system of claim 17, wherein the computer-executable instructions, when executed by the one or more backend processors, further configure the one or more backend processors to receive a request for the query from a user via a web application, parse the query into a structured query language, execute the parsed query against the columnar data store to retrieve structured data responsive to the query, and display the retrieved structured data in the aggregated format for the user.
19. The system of claim 18, wherein the computer-executable instructions, when executed by the one or more backend processors, further configure the one or more backend processors to parse the query as a function of the metadata associated with the structured data stored in the columnar data store.
20. The system of claim 17, wherein the computer-executable instructions, when executed by the one or more backend processors, further configure the one or more backend processors to perform stream processing on the data received from the plurality of data sources and to dynamically transform the stream processed data into the columnar data schema format.
Cooperative Patent Classification codes for this invention. Click any code to explore related patents in that topic.
January 21, 2020
April 4, 2023
Browse 5M+ US patents with plain-English claim translations and AI-generated analysis.