Analytics of electronic content management systems using a staging area database
Event information associated with an occurrence of an event in an electronic content management system can be routed to an event information broker of an analytics engine that is configured to maintain data routing continuity by storing the event information in a system memory. The analytics engine can be logically and/or physically separate from the electronic content management system. The broker can separate event information into event topic bins. Messenger listeners can be used to obtain event information and store it in a staging area database for analysis and reporting without interfering with the operations of the electronic content management system.
1. A method implemented on an analytics engine, the analytics engine forming at least part of a computing system, the method comprising:
receiving, by the analytics engine, event information associated with an event occurring at an electronic content management system, the electronic content management system comprising data storage storing content;
routing, by the analytics engine that is logically separate from the electronic content management system, the event information associated with the event to a broker, the event information comprising one or more event topics, the broker configured to maintain data routing continuity by storing the event information in a system memory of the analytics engine;
sorting the event information received at the broker into one or more event topic bins associated with one or more attributes of the event information, the sorting being performed by one or more message listeners, the one or more message listeners directing the event information to the one or more event topic bins associated with the one or more attributes;
storing the event information in the one or more event topic bins in a staging area database disposed on electronic storage associated with the analytics engine, the staging area database being configured to facilitate analysis of the event information, in the one or more event topic bins, to analyze the electronic content management system; and
integrating, by the analytics engine and in response to the storing, the event information in the one or more event topic bins, wherein the integrating of the event information in the one or more event topic bins, is performed in accordance with a predefined integration schedule.
2. The method as in claim 1 , further comprising:
extracting, by the analytics engine, the integrated event information into an analytics cube; transforming, by the analytics engine, the integrated event information into a data format to facilitate querying of the integrated event information, the transforming comprising generating a star schema for the integrated event information, the star schema comprising the integrated event information and facilitating querying of the integrated event information.
3. The method as in claim 2 , further comprising:
generating, by a report engine, a unified view of the electronic content management system from the analytics cube, the unified view comprising a view on the event information from the electronic content management system that appears to be from a single data source.
4. The method as in claim 2 , further comprising:
generating, by a report engine, a report based on results from querying of the integrated event information facilitated by the star schema.
5. The method as in claim 4 , further comprising:
generating a recommendation for a content item based on the report.
6. The method as in claim 4 , wherein generating the report is performed without requiring the use of resources of the electronic content management system.
7. The method as in claim 1 , wherein the one or more attributes of the event information comprise one or more of an event activity, an event process, and an event task.
8. The method as in claim 1 , wherein the event information comprises one or more of a time of the event and a user associated with the event.
9. The method as in claim 1 , wherein the event information comprises serialized event data that comprises one or more of a content identification, a content type, a content size, and a content location.
10. The method as in claim 1 , wherein the one or more attributes of the event information are based on a source of the event information.
11. The method as in claim 1 , further comprising receiving the event information by the analytics engine in real or near-real time relative to when the event occurs.
12. The method as in claim 1 , wherein the one or more message listeners and the broker are implemented as part of the analytics engine.
13. A system comprising:
a programmable processor; and
a memory configured to store computer-readable instructions which, when executed by the programmable processor, cause the programmable processor to perform operations comprising:
receiving, by the analytics engine, event information associated with an event occurring at an electronic content management system, the electronic content management system comprising data storage storing content;
routing event information associated with the event to a broker, the routing being performed by an analytics engine that is logically separate from the electronic content management system, the event information comprising one or more event topics, the broker configured to maintain data routing continuity by storing the event information in a system memory of the analytics engine;
sorting the event information received at the broker into one or more event topic bins associated with one or more attributes of the event information, the sorting being performed by one or more message listeners, the one or more message listeners directing the event information to the one or more event topic bins associated with the one or more attributes;
storing the event information in the one or more event topic bins in a staging area database disposed on electronic storage associated with the analytics engine, the staging area database being configured to facilitate analysis of the event information, in the one or more event topic bins, to analyze the electronic content management system; and
integrating, by the analytics engine and in response to the storing, the event information in the one or more event topic bins, wherein the integrating of the event information in the one or more event topic bins, is performed in accordance with a predefined integration schedule.
14. The system as in claim 13 , wherein the operations further comprise:
extracting, by the analytics engine, the integrated event information into an analytics cube; transforming, by the analytics engine, the integrated event information into a data format to facilitate querying of the integrated event information, the transforming comprising generating a star schema for the integrated event information, the star schema comprising the integrated event information and facilitating querying of the integrated event information.
15. The system as in claim 14 , wherein the operations further comprise:
generating, by a report engine, a unified view of the electronic content management system from the analytics cube, the unified view comprising a view on the event information from the electronic content management system that appears to be from a single data source.
16. The system as in claim 14 , wherein the operations further comprise:
generating, by a report engine, a report based on results from querying of the integrated event information facilitated by the star schema.
17. The system as in claim 13 , wherein the one or more attributes of the event information comprise one or more of an event activity, an event process, and an event task.
18. The system as in claim 13 , wherein the event information comprises one or more of a time of the event and a user associated with the event.