Guy HarrisonMongoDB Windows function and time-series performanceIn this blog post, I worked out a simple example of using the new MongoDB windowing aggregation capabilities to produce moving averages…5 min read·Feb 14, 2022----
Guy HarrisonExplaining Aggregation PipelinesThe MongoDB find() command is versatile and easy to use, but the aggregation framework allows you to take it to the next level. Aggregation…3 min read·Sep 18, 2021----
Guy HarrisonGetting started with MongoDB 5.0 window functionsWindow or “analytic” functions are one of the most powerful, yet hard to learn, parts of the SQL language.3 min read·Aug 17, 2021--1--1
Guy HarrisonTuning MongoDB transactionsTransactions are new in MongoDB but have been existed in SQL databases for more than 30 years. Transactions are used to maintain…5 min read·Apr 22, 2021--1--1
Guy HarrisonOptimizing the MongoDB DataLake (Pt 1)The idea of the “Data Lake” became popular following the explosion of interest in Big Data and Hadoop. The Data Lake was seen as a modern…5 min read·Nov 25, 2019----
Guy HarrisonSystematic MongoDB performance tuningA major website backed by a MongoDB database is experiencing unsatisfactory performance. As an experienced MongoDB professional, you are…5 min read·May 30, 2018----
Guy HarrisonStudies in mongoDB schema design — Pt 1Anyone who has spent anytime working with MongoDB knows that designing your document structure — your schema is critical to application…6 min read·Feb 15, 2018--2--2
Guy HarrisonOptimising graph lookups in MongoDBGraph databases such as Neo4J specialise in traversing graphs of relationships — such as those you might find in a social network. Many…3 min read·Feb 1, 2018--1--1
Guy HarrisonEffective MongoDB indexing (part 2)In Part one of this blog series we looked at the structure and behaviour of MongoDB B-tree indexes and how to create concatenated indexes…8 min read·Dec 15, 2017--1--1