Solution Videos

EsgynDB can be used to build powerful operational reporting, Business Intelligence, and transactional solutions.  These solution examples show how you and your organization can gain business insights from Big Data with the All-in-One SQL capabilities of EsgynDB.

CrunchBase Documents

  • Based on the the CrunchBase 2013 Snapshot data set, with almost 1.5 million entries
  • Showcases EsgynDB management of semi-structured data in JSON (JavaScript Object Notation) format, a widely used document format
  • Shows how standard open source tools like Apache Zeppelin can be used to query and visualize the data
  • See the quick response time EsgynDB delivers for interactive, complex BI queries
  • Learn how a User Defined Function (UDF) written in JAVA can be used to help process the JSON documents, enabling schema-on-demand

Internet Classifieds

  • Based on Craigslist.org internet classified advertisements for used cars, combined with structured commerical data
  • Combines unstructured and structured data in the same query
  • Shows data management capabilities of EsgynDB Manager
  • Implements search through Apache Solr
  • Uses Hue for the search dashboard and Apache Zeppelin for interactive queries

Public Medical Data

  • Based on public medical data: 36 million prescription drug transactions and 230,000 clinical trials.
  • Highlights what pharmaceutical companies can learn from public data to guide business decisions
  • Combines unstructured and structured data in the same query
  • Shows data management capabilities of EsgynDB Manager
  • Implements search through Apache Solr
  • Uses Hue for the search dashboard and Tableau and Apache Zeppelin for interactive queries