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…Feb 14, 2022Feb 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…Sep 18, 2021Sep 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.Aug 17, 20211Aug 17, 20211
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…Apr 22, 20211Apr 22, 20211
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…Nov 25, 2019Nov 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…May 30, 2018May 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…Feb 15, 20182Feb 15, 20182
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…Feb 1, 20181Feb 1, 20181
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…Dec 15, 20171Dec 15, 20171