Docs Home → Develop Applications → MongoDB Manual

Build Materialized Views on Top of Time Series Data

This version of the documentation is archived and no longer supported. View the current documentation to learn how to upgrade your version of MongoDB server.

Materialized views on time series data are useful for:

archiving
analytics
facilitating data access for teams that cannot access the raw data

To create an On-Demand Materialized view, use the $merge aggregation pipeline stage to transform and store your data:

db.weather.aggregate([
  {
     $project: {
        date: {
           $dateToParts: { date: "$timestamp" }
        },
        temp: 1
     }
  },
  {
     $group: {
        _id: {
           date: {
              year: "$date.year",
              month: "$date.month",
              day: "$date.day"
           }
        },
        avgTmp: { $avg: "$temp" }
     }
  }, {
     $merge: { into: "dailytemperatureaverages", whenMatched: "replace" }
  }
])

The preceding pipeline, will create or update the dailytemperatureaverages collection with all daily temperature averages based on the weather collection.

Note

It is not possible to natively schedule the refreshing of these materialized views.

For more information on materialized views, see On-Demand Materialized Views.

← Migrate Data into a Time Series Collection Shard a Time Series Collection →