Running into performance / memory problems for your queries as your collections grow? Even with sharding and indexing? Do you need complex analytics such as joins across collections or aggregations on multiple keys? Run adhoc queries with multiple values, conditions and ranges where you don’t yet know the arguments for querying?
Keep your analytics system close to your database and app server – BitYota’s Data Warehouse Service is available on Rackspace and Amazon. Load, explore and analyze your fast-changing JSON data from multiple sources on BitYota, without sacrificing agility or existing knowledge/ investment in SQL
Use BitYota’s free MongoDB oplog tool or our upcoming streaming events service to collect and load data in native JSON/BSON format as it is generated from your database or mobile/web app. Or load files one-time and on a schedule from AWS S3 or Rackspace cloud files, all from within our service. No need for a complex ETL and no need to modify anything, even if you change attributes.
Load your JSON documents directly into tables into BitYota’s semi-structured data types (JSON, XML, key-value). No need to do any upfront data modeling. Once loaded, you can directly access the attributes within that JSON document using standard SQL as if they were regular columns, even if they are nested within arrays. Fire up your favorite BI tool to visualize JSON data with our drill through capability. Use your script-based UDFs written in Python, perl, or JS from within SQL for advanced analysis.