问题描述
还有其他方法/技巧可以将深度图存储在数据库中吗?基本上,我们正在尝试存储 300000 个双精度值.如果它有帮助,我们可以将数组转换为 NSMutableArray 或类似的,以便我们可以序列化它.我还不知道该怎么做.我试图找到一种方法将其转换为二进制文件而不是 ASCII 但还没有运气.
推荐答案
您可以通过将原始二进制数据存储在 BLOB 中来节省大量内存.
如果您的矩阵没有固定的行和列,您可以在文件的开头放置行和列的两个整数.
我将添加一个关于如何保存和加载矩阵数据的简单示例,前面是行和列.
#include <opencv2/opencv.hpp> #include <fstream> using namespace cv; using namespace std; int main() { Mat1d m = (Mat1d(3, 3) << 1, 2, 3, 4, 5, 6, 7, 8, 9); Mat1d n; { ofstream ofs("test.bin", fstream::binary); ofs.write((char*)&m.rows, sizeof(int)); // Save rows ofs.write((char*)&m.cols, sizeof(int)); // Save cols ofs.write((char*)m.data, m.total()*sizeof(double)); // Save data } { ifstream ifs("test.bin", fstream::binary); int rows, cols; ifs.read((char*)&rows, sizeof(int)); // Load rows ifs.read((char*)&cols, sizeof(int)); // Load cols n = Mat1d(rows, cols); // Resize the matrix according to rows, cols ifs.read((char*)n.data, rows*cols*sizeof(double)); // Load data } // Now m and n are equal return 0; }
如果您需要进一步压缩,您可以使用 gzstream
问题描述
There is any other way/trick to store the depth map in the database? Basically, we are trying to store 300000 double values. If it helps we can convert the array into a NSMutableArray or similar so that we can serialize it. I don’t know yet how to do it. I tried to find a way to convert it to a binary file instead of ASCII but no luck yet.
推荐答案
You can save a lot of memory by storing the raw binary data in a BLOB.
If you don't have fixed rows and cols of your matrix, you can put at the beginning of the file two integers for rows and cols.
I'll add a simple example on how to save and load the data of matrix, preceded by rows and cols.
#include <opencv2/opencv.hpp> #include <fstream> using namespace cv; using namespace std; int main() { Mat1d m = (Mat1d(3, 3) << 1, 2, 3, 4, 5, 6, 7, 8, 9); Mat1d n; { ofstream ofs("test.bin", fstream::binary); ofs.write((char*)&m.rows, sizeof(int)); // Save rows ofs.write((char*)&m.cols, sizeof(int)); // Save cols ofs.write((char*)m.data, m.total()*sizeof(double)); // Save data } { ifstream ifs("test.bin", fstream::binary); int rows, cols; ifs.read((char*)&rows, sizeof(int)); // Load rows ifs.read((char*)&cols, sizeof(int)); // Load cols n = Mat1d(rows, cols); // Resize the matrix according to rows, cols ifs.read((char*)n.data, rows*cols*sizeof(double)); // Load data } // Now m and n are equal return 0; }
If you need further compression you can read and write the stream using gzstream