{"id":1067,"date":"2019-04-11T06:56:56","date_gmt":"2019-04-11T13:56:56","guid":{"rendered":"https:\/\/www.kenwalger.com\/blog\/?p=1067"},"modified":"2019-04-11T08:23:58","modified_gmt":"2019-04-11T15:23:58","slug":"building-with-patterns-the-preallocation-pattern","status":"publish","type":"post","link":"https:\/\/www.kenwalger.com\/blog\/nosql\/mongodb\/building-with-patterns-the-preallocation-pattern\/","title":{"rendered":"Building with Patterns: The Preallocation Pattern"},"content":{"rendered":"\n

One of the great things about MongoDB is the document<\/a> data model. It provides for a lot of flexibility not only in schema design but in the development cycle as well. Not knowing what fields will be required down the road is easily handled with MongoDB documents. However, there are times when the structure is known and being able to fill or grow the structure makes the design much simpler. This is where we can use the Preallocation Pattern.<\/p>\n\n\n\n

Memory allocation is often done in blocks to avoid performance issues. In the earlier days of MongoDB (prior to MongoDB version 3.2), when it used the MMAPv1<\/a> storage engine, a common optimization was to allocate in advance the memory needed for the future size of a constantly growing document. Growing documents in MMAPv1 needed to be relocated at a fairly expensive cost by the server. With its lock-free and rewrite on update algorithms, WiredTiger<\/a> does not require this same treatment. <\/p>\n\n\n\n

With the deprecation of MMAPv1 in MongoDB 4.0, the Preallocation Pattern appeared to lose some of its luster and necessity. However, there are still use cases for the Preallocation Pattern with WiredTiger. As with the other patterns we’ve discussed in the Building with Patterns<\/em> series, there are a few application considerations to think about.<\/p>\n\n\n\n

The Preallocation Pattern<\/h4>\n\n\n\n

This pattern simply dictates to create an initial empty structure to be filled later. It may sound trivial, however, you will need to balance the desired outcome in simplification versus the additional resources that the solution may consume. Bigger documents will make for a larger working set resulting in more RAM to contain this working set.<\/p>\n\n\n\n

If the code of the application is much easier to write and maintain if it uses a structure that is not completed filled, it may easily outweigh the cost of the RAM. Let’s say there is a need to represent a theater room as a 2-dimensional array where each seat has a “row” and “number”, for example, the seat “C7”. Some rows may have fewer seats, however finding the seat “B3” is faster and cleaner in a 2-dimensional array, than having a complicated formula to find a seat in a one-dimensional array that has only cells for the existing seats. Being able to identify accessible seating is also easier as a separate array can be created for those seats.<\/p>\n\n\n\n

\"Seating<\/figure>\n\n\n\n

Two dimensional representation of venue, valid seats available in green. Accessible seating notated with a blue outline.<\/em><\/p>\n\n\n\n

\"One-dimensional<\/figure>\n\n\n\n

One dimensional representation of venue, accessible seats shown in blue.<\/em><\/p>\n\n\n\n

Sample Use Case<\/h4>\n\n\n\n

As seen earlier, representing a 2 dimension structure, like a venue, is a good use case. Another example could be a reservation system where a resource is blocked or reserved, on a per day basis. Using one cell per available day would likely make computations and checking faster than keeping a list of ranges.
<\/p>\n\n\n\n

\"Image<\/figure>\n\n\n\n

The month of April 2019 with an array of U.S. work days.<\/em><\/p>\n\n\n\n

\"Image<\/figure>\n\n\n\n

The month of April 2019 with an array of U.S. work days as a list of ranges.<\/em>
\n<\/p>\n\n\n\n

Conclusion<\/h4>\n\n\n\n

This pattern may be one of the most used when using the MMAPv1 storage engine with MongoDB. However due to the depreciation of this storage engine, it has lost its generic use case, but it is still useful in some situations. And like other patterns, you have a trade-off between “simplicity” and “performance”.<\/p>\n\n\n\n

The next post in this series will look at the Document Versioning Pattern<\/em>.<\/p>\n\n\n\n

If you have questions, please leave comments below. <\/p>\n\n\n\n

Previous Parts of Building with Patterns:<\/h4>\n\n\n\n