Emaranhados: uma história de remodelagem de dados e redução de armazenamento 10x

1
const { Schema, model } = require("mongoose");
2
3
const hourlyMetricSchema = new Schema({
4
    user: { type: Schema.Types.ObjectId, ref: "Users" },
5
    total_sum: { type: Number },
6
    generated_at: { type: Date },
7
    data_file: { type: Schema.Types.ObjectId, ref: "DataFiles" }
8
});
9
10
// Compound index forr "user" (ascending) and "generated_at" (descending) fields
11
hourlyMetricSchema.index({ user: 1, generated_at: -1 });
12
13
const HourlyMetrics = model("HourlyMetrics", hourlyMetricSchema);
14
15
module.exports = HourlyMetrics;

1
const { Schema, model } = require("mongoose");
2
3
const dailyMetricSchema = new Schema({
4
    user: { type: Schema.Types.ObjectId, ref: "Users" },
5
    date: { type: Date },
6
    samples: [
7
        {
8
            total_sum: { type: Number },
9
            generated_at: { type: Date },
10
            data_file: { type: Schema.Types.ObjectId, ref: "DataFiles" }
11
        }
12
    ]
13
});
14
15
// Compound index forr "user" (ascending) and "date" (descending) fields
16
hourlyMetricSchema.index({ user: 1, date: -1 });
17
18
const DailyMetrics = model("DailyMetrics", dailyMetricSchema);
19
20
module.exports = DailyMetrics;

1
const { Schema, model } = require("mongoose");
2
3
const monthlyMetricSchema = new Schema({
4
    user: { type: Schema.Types.ObjectId, ref: "Users" },
5
    date: { type: Date },
6
    samples: [
7
        {
8
            total_sum: { type: Number },
9
            generated_at: { type: Date },
10
            data_file: { type: Schema.Types.ObjectId, ref: "DataFiles" }
11
        }
12
    ]
13
});
14
15
// Compound index forr "user" (ascending) and "date" (descending) fields
16
monthlyMetricSchema.index({ user: 1, date: -1 });
17
18
const MonthlyMetrics = model("MonthlyMetrics", monthlyMetricSchema);
19
20
module.exports = MonthlyMetrics;