Alfresco search engine and reporting based on jOOQ and relational database

We will show how to manage complex document registers or generate reports from huge amounts of documents with attributes in a simple way using Java Object Oriented Querying.

• automatic denormalization of the Alfresco database to flat tables using jOOQ • which elements of the system works better using relational database and why • denormalization Alfresco data - how it works, possibility of dynamic modification of the scheme, performance, synchronization, etc. • what is the difference between Solr and Denormalization • confronting the Solr JDBC capabilities with a relational database • how to transfer system elements to a denormalized database • generating huge reports with Alfresco documents metadata using Pentaho • Pentaho dashboard and ADF integration

Lecture is based on real project experience and we will show working solution available in github.