Tag - aggregation

MongoDB 3.6 Aggregation and Array Improvements

Running MongoDB

In this blog, we’ll look at MongoDB 3.6 aggregation and array improvements.
With MongoDB 3.6 out, and us having talked about security, transactions, and sessions, we can now start to talk about something much more fun. This blog is centered on the improvements around arrays, dates and aggregations. My goal here is two parts: first […]

Read more

Advanced JSON to MySQL indexing

This post will discuss some excellent methods of getting JSON to MySQL indexing to work smoothly.
What is JSON
JSON is an text based, human readable format for transmitting data between systems, for serializing objects and for storing document store data for documents that have different attributes/schema for each document. Popular document store databases use JSON […]

Read more

Parallel Query for MySQL with Shard-Query

While Shard-Query can work over multiple nodes, this blog post focuses on using Shard-Query with a single node.  Shard-Query can add parallelism to queries which use partitioned tables.  Very large tables can often be partitioned fairly easily. Shard-Query can leverage partitioning to add paralellism, because each partition can be queried independently. Because MySQL 5.6 supports […]

Read more