Welcome to Unit 3: Writing Data in Batches. In this lesson, we'll explore how to efficiently handle large datasets by writing data in batches. This technique is invaluable when managing substantial amounts of data where handling the entire dataset at once is impractical. By the end of this lesson, you will be able to write data in batches to manage and handle large datasets effectively.

Before diving into code, let's briefly review the CSV file format and how to work with it using C++ standard libraries. CSV (Comma-Separated Values) files are plain text files where data is separated by commas. Each line of the file is a data record, and each record consists of one or more fields separated by commas. Here is a short example:

csv
Copy to clipboard
1A,B,C
21,2,3

In C++, we can handle CSV files using the <fstream> library. This allows us to manipulate file streams to read from or write to CSV files. Here's a simple example of opening a file and writing headers to it:

C++
Copy to clipboard
1#include <fstream>
2#include <iostream>
3
4int main() {
5    std::ofstream file("example.csv");
6    if (file.is_open()) {
7        file << "Header1,Header2\n";
8        file.close();
9    } else {
10        std::cerr << "Unable to open file";
11    }
12    return 0;
13}

This code snippet opens a CSV file in write mode and writes a header row. The file is then closed, securing any writes to disk.

Batching is the process of dividing a large amount of data into smaller, manageable chunks or batches. This practice is crucial in data handling as it offers several advantages:

• Memory Efficiency: Smaller chunks can be processed more efficiently than large datasets, reducing memory usage.
• Performance Improvement: Writing and reading smaller sets of data can enhance performance, especially in I/O operations.

Batching is particularly useful when dealing with data that simply cannot fit into memory all at once or when you are working with streaming data.

Let's break down one example of writing data in batches with C++ step by step. First, we need to include the required headers: <fstream> for handling CSV files and <random> to generate sample data.

C++
Copy to clipboard
1#include <fstream>
2#include <iostream>
3#include <random>

These libraries facilitate file handling and random number generation in C++.

We will generate random arrays of numbers to represent an example of data that comes in batches. In reality, this data can come from different sources:

• Databases: Data can be extracted in batches from SQL or NoSQL databases using queries.
• APIs: APIs often provide data in paginated responses, allowing for batch retrieval.
• Sensors or IoT Devices: Continuous streams of data from sensors or IoT devices can be collected in batches.
• Log Files: System or application logs can be parsed and processed in batches.
• Data Streams: Data streaming platforms like Apache Kafka or AWS Kinesis can provide real-time data that is processed in batches.

Next, we define the file path and establish parameters for batch writing, such as the number of batches and the batch size.

C++
Copy to clipboard
1const std::string file_path = "large_data.csv";
2const int num_batches = 5;
3const int batch_size = 200;

Here, file_path is the destination for our data, num_batches is the number of data chunks, and batch_size is the number of records in each batch.

Random data generation is essential for testing data handling techniques. In C++, we use the <random> library. We can generate random numbers within a specified range using classes such as std::mt19937 and std::uniform_real_distribution.

C++
Copy to clipboard
1std::random_device rd;
2std::mt19937 gen(rd());
3std::uniform_real_distribution<> dis(0.0, 1.0);
4
5std::vector<std::vector<double>> data_batch(batch_size, std::vector<double>(10));
6
7for (auto& row : data_batch) {
8    for (auto& value : row) {
9        value = dis(gen);
10    }
11}

This snippet sets up random number generation for a vector of batches, with each batch containing vectors of random values.

Now, let's implement the loop for writing data in batches:

C++
Copy to clipboard
1for (int batch = 0; batch < num_batches; ++batch) {
2    std::ofstream file(file_path, std::ios::app);
3
4    for (int i = 0; i < batch_size; ++i) {
5        for (int j = 0; j < 10; ++j) {
6            file << data_batch[i][j];
7            if (j < 9) file << ",";
8        }
9        file << "\n";
10    }
11
12    file.close();
13    std::cout << "Written batch " << (batch + 1) << " to " << file_path << ".\n";
14}

• Appending Data: We open the file in append mode (std::ios::app) to add new data without overwriting existing data.
• Writing Data: The data vectors are written to the file with comma separators and newline termination for each row.

This way, when each new batch comes, we append it to the file, and close it to wait for the next batch.

Note that if you run a code that appends data to the file multiple times in a row, you will end up with more data than you intended to have, as each run would append data to the existing file. So, once we have written the data, it's crucial to ensure that our file contains the expected number of rows.

C++
Copy to clipboard
1std::ifstream read_file(file_path);
2std::string line;
3int line_count = 0;
4
5while (std::getline(read_file, line)) {
6    ++line_count;
7}
8read_file.close();
9
10std::cout << "The file " << file_path << " has " << line_count << " lines.\n";

We open the file and count the lines to verify the writing operation. There are multiple ways to handle problem with multiple append. There are some to consider:

• You can manually remove the file or return it to its original state before running the code
• You can update your code to remove the file or return it to its original state before appending anything

Consider using the first option in the practices of this unit.

In this lesson, we've covered the essentials of writing data in batches to efficiently manage large datasets using C++. You've learned how to generate data, write it in batches, and verify the integrity of the written files. This technique is crucial for handling large datasets effectively, ensuring memory efficiency and improved performance.

As you move on to the practice exercises, take the opportunity to apply what you've learned and solidify your understanding of batch processing. These exercises are designed to reinforce your knowledge and prepare you for more complex data handling tasks. Good luck and happy coding!