How SQL-on-JSON Analytics Bolstered a Business
Running Punchtab's multi-channel loyalty and engagement platform requires a lot of data. From an operational point of view, MongoDB, a document-based NoSQL database, was an excellent choice for hosting this workload, but analyzing the data was a challenge. Punchtab turned to BitYota's data warehouse in the cloud to load and analyze their JSON documents from MongoDB. BitYota's ability to use SQL directly over JSON was critical for PunchTab as they needed to allow their customers to query their own data. Asking their brand and agency clients to write MapReduce jobs was not an option. applies SQL to MongoDB data to uncover social media trends
Despite a host of new big data innovations, including Hadoop, MapReduce and NoSQL databases such as MongoDB, some familiar and trusted technologies hang on — one being SQL. That is because the job of uncovering important business patterns doesn’t become easier as companies collect data in more varied formats, especially if those new formats don’t have familiar SQL support.