Data Reporting in Real-Time via Drupal

Do your clients want more data analysis, but your reporting is too slow? Are you wondering how to extend Drupal’s schema structure and data storage to boost performance? Have your Drupal installations become unwieldy?

Attend this session and learn what it takes to improve Drupal real-time performance by creating more efficient queries and extending Drupal with denormalized schemas and NoSQL options.

We'll explore:

  • Reporting and Dashboarding is resource intensive.
  • Traditional performance improvements are not sufficient for real-time results.
  • Performance steps.
    • Query enhancements
    • Manage Normalized data sets.
    • Point Reports and Dashboard to specific Database servers.
  • Integrate Solr for read heavy solutions.
    • Extend Drupal with Solr using soft commits for near real-time results.
    • Extended Solr as a storage solution with a dynamic fields.
    • Replicate Solr and run in multi-core to manage different namespaces and schemas
    • Write custom queries parsing JSON, or use ApacheSolr Views to create reports and dashboards.
  • Alternative NoSQL options.
    • Column storage solutions: Cassandra, HBase, Hypertable, etc.
    • Document storage solution: CouchDB, MongoDB, Couchbase, etc.
    • Benefits and disadvantages for each.
Schedule info
Status: 
Proposed
Session Info
Track: 
Coding + Development
Experience level: 
Intermediate