MongoDB 5.3 Adds Gap Filling
Written by Kay Ewbank   
Friday, 08 April 2022

MongoDB, the NoSQL document database that stores its documents in a JSON-like format with schema, has been updated with improvements including gap filling for time series data and support for clustered indexes.


Commenting on the new features, Jane Fine, Director of Developer Experience at MongoDB, said that time series is the fastest-growing data-intensive workload for MongoDB customers, but that it’s common for time series data to have gaps, such as when an IoT sensor goes offline.

This causes problems because time series data needs to be continuous for analysis, and when creating histograms or correlating data sets.

To meet this need gap filling has been added to the MongoDB 5.3 Rapid Release. The two new aggregation stages are used to deal with missing data across time series. The $densify stage creates new documents to eliminate the gaps, and $fill sets values for the fields when a value is null or missing. Filling missing values can be done with a constant or using linear interpolation, carrying over the last observation or carrying backward the next observation.

The new release also adds the ability to create a collection with a clustered index. Collections created with a clustered index are called clustered collections, and the advantage they offer is that they enable faster queries without needing a secondary index, such as queries with range scans and equality comparisons on the clustered index key. They also have use less storage, which improves performance for queries and bulk inserts. Clustered collections can also eliminate the need for a secondary TTL (Time To Live) index.

Against these improvements, clustered collections do have additional performance improvements for inserts, updates, deletes, and queries.

MongoDB 5.3 is available now.


More Information

MongoDB Website

Related Articles

MongoDB 5 Adds Live Resharding

MongoDB Trends

MongoDB Atlas Adds MultiCloud Cluster Support

MongoDB Adds GraphQL Support

MongoDB Improves Query Language



To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.


Holiday Gifts For Programmers

As Black Friday looms, the well-organized among us are hitting the shops to be ready with our festive gifts, though I doubt many of us are as ready as the friend who told me they've already finished w [ ... ]

Windows Wallpaper Is Latest Ugly Sweater Design

Microsoft has made the classic Windows XP wallpaper the design for its shot at this year's ugly sweater options. If, like me, you're wondering how you managed to successfully avoid this as a concept,  [ ... ]

More News




or email your comment to:

Last Updated ( Tuesday, 12 April 2022 )