304. Range Sum Query 2D - Immutable


Problem Description

We are given a 2D matrix matrix, and our task is to design a data structure that can efficiently calculate the sum of the elements within a rectangle defined by its upper-left and lower-right corners. The corner coordinates are given to us as (row1, col1) for the upper-left corner and (row2, col2) for the lower-right corner. This should be done for multiple queries and the data structure has to be efficient enough to provide the sum in constant time (O(1)).

Intuition

The key to solving this problem efficiently lies in preprocessing the matrix in such a way that it allows us to perform queries in O(1) time. This is achieved by computing a prefix sum matrix which is essentially a preprocessing step that facilitates quick sum retrieval.

The intuition behind using a prefix sum is that we can calculate the sum of a certain rectangle by combining the sums of different regions which are precomputed. The sum of elements inside the rectangle can be determined by adding and subtracting certain sums at key points that represent the corners of the rectangle.

To compute the prefix sum, we follow these steps:

  1. Initialize an auxiliary matrix s with dimensions (m+1)x(n+1), where m is the number of rows in the input matrix and n is the number of columns. We use an extra row and column to handle zero scenarios without special cases.

  2. We iterate through each element (i, j) of the original matrix and calculate s[i + 1][j + 1] as the sum of elements above and to the left including matrix[i][j]. This sum is computed by adding the sum up to the previous row (s[i][j + 1]), the sum up to the previous column (s[i + 1][j]), and then subtracting the sum that is double-counted (s[i][j]) because it was included in both previous sums, and finally adding the current element (matrix[i][j]).

  3. Once the prefix sum matrix is created in the initialization process, the sum region can be computed by using the formula derived from the properties of the prefix sum matrix. The sum of a rectangle from (row1, col1) to (row2, col2) is computed by summing the cumulative sum at (row2 + 1, col2 + 1) and subtracting the areas that extend beyond the target rectangle (cumulative sum at (row2 + 1, col1), (row1, col2 + 1)), and adding back the area that was subtracted twice, which is at (row1, col1).

This technique harnesses the power of cumulative sums to facilitate rapid sum queries of rectangular submatrices and is particularly useful when there are multiple queries on the same initial matrix, greatly reducing the time complexity from O(m*n) to O(1) for each query after an O(m*n) preprocessing time.

Learn more about Prefix Sum patterns.

Not Sure What to Study? Take the 2-min Quiz to Find Your Missing Piece:

Which of the following is equvalent to O(3*2^n + n^3 + n!+ log n)?

Solution Approach

The implementation of the solution is straightforward once we understand the concept of a prefix sum matrix. Let's break down the approach and the pattern used in the given solution:

  1. Construction of the Prefix Sum Matrix:

    • We start by creating a 2D array self.s which will store the prefix sums. Notice that this array has an extra row and column (m + 1 and n + 1), this is done to accommodate sums of submatrices that may include the first row or column without having to handle special cases.
    • We iterate through the original matrix, and for each element at (i, j) in matrix, we compute the prefix sum using:
      1self.s[i + 1][j + 1] = self.s[i][j + 1] + self.s[i + 1][j] - self.s[i][j] + matrix[i][j]
      In this formula:
      • self.s[i][j + 1] represents the sum of elements above the current element (up to the previous row).
      • self.s[i + 1][j] represents the sum of elements to the left of the current element (up to the previous column).
      • self.s[i][j] is the area that was added twice (once in above sum and once in left sum) and needs to be subtracted out.
      • matrix[i][j] is the value of the current element which needs to be added to complete the sum of the submatrix that ends at (i, j).
  2. Sum Region Query:

    • Once the prefix sum matrix is constructed, we can answer any sum region query in O(1) time. The function sumRegion(row1, col1, row2, col2) computes the sum of the elements inside the rectangle using:
      1return (self.s[row2 + 1][col2 + 1] - self.s[row2 + 1][col1] - self.s[row1][col2 + 1] + self.s[row1][col1])
      Here's how the terms of the formula correspond to the regions:
      • self.s[row2 + 1][col2 + 1] gives the sum of all elements up to (row2, col2).
      • self.s[row2 + 1][col1] subtracts out the area to the left of col1 since it's not part of the desired rectangle.
      • self.s[row1][col2 + 1] subtracts out the area above row1.
      • self.s[row1][col1] adds back the area that was subtracted out twice (once for left and once for top).

Utilizing the prefix sum method provides a powerful way to carry out cumulative sum operations both efficiently and swiftly, thus making it a preferred approach for this type of problem.

Discover Your Strengths and Weaknesses: Take Our 2-Minute Quiz to Tailor Your Study Plan:

Problem: Given a list of tasks and a list of requirements, compute a sequence of tasks that can be performed, such that we complete every task once while satisfying all the requirements.

Which of the following method should we use to solve this problem?

Example Walkthrough

Let's walk through a small example to illustrate the solution approach to the described problem. Assume we have the following 2D matrix:

1matrix = [
2  [3, 0, 1, 4, 2],
3  [5, 6, 3, 2, 1],
4  [1, 2, 0, 1, 5],
5  [4, 1, 0, 1, 7],
6  [1, 0, 3, 0, 5]
7]
  1. Construction of the Prefix Sum Matrix:
    • We initiate an auxiliary array self.s with an extra row and column. Initially, it will look like this (we fill the extra row and column with 0s):
1self.s = [
2  [0, 0, 0, 0, 0, 0],
3  [0, 0, 0, 0, 0, 0],
4  [0, 0, 0, 0, 0, 0],
5  [0, 0, 0, 0, 0, 0],
6  [0, 0, 0, 0, 0, 0],
7  [0, 0, 0, 0, 0, 0]
8]
  • We proceed to calculate the prefix sums for each cell based on the elements of the original matrix. For the first element (at 0, 0 in the original matrix), the sum will just be the element itself:
1self.s[1][1] = matrix[0][0] = 3
2
3// The matrix self.s would look like this after this step:
4self.s = [
5  [0, 0, 0, 0, 0, 0],
6  [0, 3, 0, 0, 0, 0],
7  ...
8]
  • We fill in the rest of self.s using the formula detailed earlier. The fully filled prefix sum matrix would look like this:
1self.s = [
2  [0, 0,  0,  0,  0, 0],
3  [0, 3,  3,  4,  8, 10],
4  [0, 8, 14, 18, 24, 27],
5  [0, 9, 17, 21, 28, 36],
6  [0, 13,22, 26, 34, 49],
7  [0, 14,23, 30, 38, 58]
8]
  1. Sum Region Query:
    • Let's say we wish to get the sum of elements within the rectangle defined by the corners (row1, col1) = (2, 1) and (row2, col2) = (4, 3). Following the formula provided, we calculate this as follows:
1sum = self.s[4 + 1][3 + 1] - self.s[4 + 1][1] - self.s[2][3 + 1] + self.s[2][1]
2    = self.s[5][4] - self.s[5][1] - self.s[2][4] + self.s[2][1]
3    = 38 - 14 - 24 + 8
4    = 8

This gives us the sum of elements in the rectangle defined from (2, 1) to (4, 3) which includes the values [2, 0, 1], [1, 0, 1], [0, 3, 0] from the original matrix.

This example demonstrates the efficiency of the prefix sum matrix in answering sum region queries in constant time after the preprocessing step has been completed.

Solution Implementation

1class NumMatrix:
2    def __init__(self, matrix):
3        # First check if the matrix is empty to prevent IndexError
4        if not matrix or not matrix[0]:
5            raise ValueError("Matrix should not be empty")
6      
7        # Get the dimensions of the matrix
8        self.num_rows, self.num_cols = len(matrix), len(matrix[0])
9      
10        # Create a 2D prefix sum array with an extra row and column (for easy calculation)
11        self.prefix_sum = [[0] * (self.num_cols + 1) for _ in range(self.num_rows + 1)]
12      
13        # Calculate cumulative sum for the matrix and store it in prefix_sum array
14        for row in range(self.num_rows):
15            for col in range(self.num_cols):
16                self.prefix_sum[row + 1][col + 1] = (
17                    self.prefix_sum[row][col + 1] +        # current row prefix sum
18                    self.prefix_sum[row + 1][col] -        # current column prefix sum
19                    self.prefix_sum[row][col] +            # subtract overlapping area
20                    matrix[row][col]                       # add current matrix value
21                )
22
23    def sumRegion(self, row1, col1, row2, col2):
24        # Retrieve the sum of the desired region using the inclusion-exclusion principle
25        return (
26            self.prefix_sum[row2 + 1][col2 + 1] -        # sum of entire rectangle from (0,0) to (row2, col2)
27            self.prefix_sum[row2 + 1][col1] -            # subtract sum above the intended row range
28            self.prefix_sum[row1][col2 + 1] +            # subtract sum before the intended column range
29            self.prefix_sum[row1][col1]                  # add back the sum of the overlapping rectangle
30        )                                                # that was subtracted twice
31
32
33# How to use the NumMatrix class:
34# obj = NumMatrix(matrix)
35# sum_of_region = obj.sumRegion(row1, col1, row2, col2)
36
1class NumMatrix {
2    private int[][] prefixSumMatrix;
3
4    // Constructor initializes the NumMatrix object
5    public NumMatrix(int[][] matrix) {
6        if (matrix.length == 0 || matrix[0].length == 0) return;
7        int rows = matrix.length, cols = matrix[0].length;
8      
9        // plus one to handle the border cases without extra condition checks
10        prefixSumMatrix = new int[rows + 1][cols + 1];
11      
12        // Construct prefix sums matrix
13        for (int i = 1; i <= rows; ++i) {
14            for (int j = 1; j <= cols; ++j) {
15                // Computing the prefix sum for position (i, j)
16                prefixSumMatrix[i][j] = prefixSumMatrix[i - 1][j] + prefixSumMatrix[i][j - 1]
17                                         - prefixSumMatrix[i - 1][j - 1] + matrix[i - 1][j - 1];
18            }
19        }
20    }
21
22    // Return the sum of the elements of matrix inside the rectangle defined by its upper left corner (row1, col1) and lower right corner (row2, col2)
23    public int sumRegion(int row1, int col1, int row2, int col2) {
24        // Apply the inclusion-exclusion principle to find the sum of the region
25        return prefixSumMatrix[row2 + 1][col2 + 1] - prefixSumMatrix[row2 + 1][col1] 
26               - prefixSumMatrix[row1][col2 + 1] + prefixSumMatrix[row1][col1];
27    }
28}
29
30// This is an example usage provided for reference; actual usage may vary
31/*
32NumMatrix numMatrix = new NumMatrix(matrix);
33int param1 = numMatrix.sumRegion(row1, col1, row2, col2);
34*/
35
1#include <vector>
2using namespace std;
3
4class NumMatrix {
5private:
6    vector<vector<int>> prefixSumMatrix; // 2D vector to store the prefix sum matrx
7
8public:
9    // Constructor that pre-calculates the prefix sum for the input matrix.
10    NumMatrix(vector<vector<int>>& matrix) {
11        int rowCount = matrix.size(); // Number of rows in the matrix
12        int colCount = matrix[0].size(); // Number of columns in the matrix
13      
14        // Resize the prefixSumMatrix to accommodate the extra row and column for easier calculations.
15        prefixSumMatrix.resize(rowCount + 1, vector<int>(colCount + 1, 0));
16      
17        // Calculate the prefix sum for each cell.
18        for (int row = 0; row < rowCount; ++row) {
19            for (int col = 0; col < colCount; ++col) {
20                // Current cell's prefix sum is equal to the sum of:
21                // - Prefix sum of cell above 
22                // - Prefix sum of cell to the left
23                // - The current cell's value
24                // + Prefix sum of cell diagonally up-left (to avoid double counting)
25                prefixSumMatrix[row + 1][col + 1] = prefixSumMatrix[row + 1][col] +
26                                                    prefixSumMatrix[row][col + 1] -
27                                                    prefixSumMatrix[row][col] +
28                                                    matrix[row][col];
29            }
30        }
31    }
32
33    // Function to calculate the sum of elements in the given rectangular region.
34    int sumRegion(int row1, int col1, int row2, int col2) {
35        // Calculate the region sum using the inclusion-exclusion principle.
36        return prefixSumMatrix[row2 + 1][col2 + 1] -  // Entire rectangle sum including the region
37               prefixSumMatrix[row2 + 1][col1] -      // Exclude left strip outside of the region
38               prefixSumMatrix[row1][col2 + 1] +      // Exclude top strip outside of the region
39               prefixSumMatrix[row1][col1];           // Add back the top-left rectangle, as it was excluded twice
40    }
41};
42
43// Usage example (not part of the class definition):
44// NumMatrix* obj = new NumMatrix(matrix);
45// int sum = obj->sumRegion(row1, col1, row2, col2);
46
1// Define the prefix sum matrix as a global variable
2let prefixSumMatrix: number[][];
3
4// Initialize the prefix sum matrix using the given matrix
5function initialize(matrix: number[][]): void {
6    const rows = matrix.length;
7    const cols = matrix[0].length;
8
9    // Create the prefix sum matrix with an extra row and column (for easier calculations)
10    prefixSumMatrix = new Array(rows + 1).fill(0).map(() => new Array(cols + 1).fill(0));
11
12    // Populate the prefix sum matrix using the input matrix
13    for (let i = 0; i < rows; ++i) {
14        for (let j = 0; j < cols; ++j) {
15            // Calculate the current cell's prefix sum value
16            prefixSumMatrix[i + 1][j + 1] =
17                prefixSumMatrix[i + 1][j] + prefixSumMatrix[i][j + 1] -
18                prefixSumMatrix[i][j] + matrix[i][j];
19        }
20    }
21}
22
23// Calculate the sum of the elements in the given rectangular region
24function sumRegion(row1: number, col1: number, row2: number, col2: number): number {
25    // Return the sum of elements in the region using the inclusion-exclusion principle
26    return prefixSumMatrix[row2 + 1][col2 + 1] -
27           prefixSumMatrix[row2 + 1][col1] -
28           prefixSumMatrix[row1][col2 + 1] +
29           prefixSumMatrix[row1][col1];
30}
31
32// Example usage:
33// Initialize with a given matrix
34initialize([
35   [3, 0, 1, 4, 2],
36   [5, 6, 3, 2, 1],
37   [1, 2, 0, 1, 5],
38   [4, 1, 0, 1, 7],
39   [1, 0, 3, 0, 5]
40]);
41
42// Calculate the sum of a region between two coordinates
43const result = sumRegion(2, 1, 4, 3); // Result for sum of the region (2,1) to (4,3)
44
Not Sure What to Study? Take the 2-min Quiz:

Given an array of 1,000,000 integers that is almost sorted, except for 2 pairs of integers. Which algorithm is fastest for sorting the array?

Time and Space Complexity

The time complexity for initializing the NumMatrix object is O(m * n) where m is the number of rows and n is the number of columns in the input matrix. This is because we have two nested loops each going through m rows and n columns to compute the sum of each submatrix ending at (i, j).

The time complexity for the sumRegion query operation is O(1) because it involves a constant number of mathematical operations irrespective of the size of the input matrix or the selected region. It directly uses the precomputed sums from the self.s matrix to calculate the sum of the given region.

The space complexity of the code is also O(m * n) due to the additional space used to store the precomputed sums in the self.s matrix, which has the dimensions of (m + 1) * (n + 1) to allow for easier calculation of sums for the sumRegion method.

Learn more about how to find time and space complexity quickly using problem constraints.

Fast Track Your Learning with Our Quick Skills Quiz:

What is the running time of the following code?

1int sqrt(int n) {
2  for (int guess = 1; guess * guess <= n; guess++) {
3    if (guess * guess == n) {
4      return guess;
5    }
6  }
7  return -1;
8}

Recommended Readings


Got a question? Ask the Teaching Assistant anything you don't understand.

Still not clear? Ask in the Forum,  Discord or Submit the part you don't understand to our editors.


TA 👨‍🏫