MongoDB Database

  1. The Aggregation Framework
    1. Introduction to Data Aggregation
      1. Aggregation vs Simple Queries
        1. Aggregation vs MapReduce
          1. Use Cases for Aggregation
            1. Performance Characteristics
            2. The Aggregation Pipeline
              1. Pipeline Concept and Architecture
                1. Stage-by-Stage Processing
                  1. Document Flow Through Pipeline
                    1. Pipeline Syntax and Structure
                      1. Pipeline Optimization
                      2. Common Pipeline Stages
                        1. $match Stage
                          1. Document Filtering
                            1. Query Operator Usage
                              1. Early Filtering Benefits
                              2. $project Stage
                                1. Field Selection and Exclusion
                                  1. Field Transformation
                                    1. Computed Fields
                                      1. Nested Field Handling
                                      2. $group Stage
                                        1. Grouping Documents by Fields
                                          1. Accumulator Expressions
                                            1. Group Key Specifications
                                              1. Memory Usage Considerations
                                              2. $sort Stage
                                                1. Document Ordering
                                                  1. Sort Key Specifications
                                                    1. Index Usage in Sorting
                                                      1. Memory Limitations
                                                      2. $limit Stage
                                                        1. Result Set Limitation
                                                          1. Pagination Strategies
                                                            1. Performance Optimization
                                                            2. $skip Stage
                                                              1. Document Skipping
                                                                1. Pagination Implementation
                                                                  1. Offset Considerations
                                                                  2. $unwind Stage
                                                                    1. Array Deconstruction
                                                                      1. Preserving Empty Arrays
                                                                        1. Index Preservation
                                                                        2. $lookup Stage
                                                                          1. Left Outer Join Operations
                                                                            1. Cross-Collection References
                                                                              1. Pipeline-Based Lookups
                                                                                1. Performance Considerations
                                                                                2. $out Stage
                                                                                  1. Writing Results to Collections
                                                                                    1. Collection Replacement Behavior
                                                                                      1. Atomicity Guarantees
                                                                                      2. $merge Stage
                                                                                        1. Flexible Output Options
                                                                                          1. Upsert and Update Behaviors
                                                                                            1. Target Collection Handling
                                                                                          2. Advanced Pipeline Stages
                                                                                            1. $addFields Stage
                                                                                              1. $replaceRoot Stage
                                                                                                1. $facet Stage
                                                                                                  1. $bucket Stage
                                                                                                    1. $bucketAuto Stage
                                                                                                      1. $sample Stage
                                                                                                        1. $count Stage
                                                                                                        2. Aggregation Expressions and Accumulators
                                                                                                          1. Arithmetic Expressions
                                                                                                            1. String Expressions
                                                                                                              1. Date Expressions
                                                                                                                1. Conditional Expressions
                                                                                                                  1. Array Expressions
                                                                                                                    1. Accumulator Operators
                                                                                                                      1. $sum
                                                                                                                        1. $avg
                                                                                                                          1. $min
                                                                                                                            1. $max
                                                                                                                              1. $first
                                                                                                                                1. $last
                                                                                                                                  1. $push
                                                                                                                                    1. $addToSet
                                                                                                                                      1. $stdDevPop
                                                                                                                                        1. $stdDevSamp
                                                                                                                                      2. Building and Optimizing Aggregation Pipelines
                                                                                                                                        1. Pipeline Design Principles
                                                                                                                                          1. Stage Order Optimization
                                                                                                                                            1. Index Usage in Aggregation
                                                                                                                                              1. Memory Management
                                                                                                                                                1. Handling Large Data Sets
                                                                                                                                                  1. Pipeline Performance Tuning
                                                                                                                                                    1. Aggregation Explain Plans