> My company is starting a project in wich we will have to process > large amounts of data and save the results to a db2 database. > Because this data process needs to be very fast, the idea is to load > the data in memory and apply the transformations in C++. I think that > sqlite inmemory databases could be a good alternative to this, but > when I proposed this solution to my boss, he asked if someone has > already used sqlite for this purpose. I found that this use of sqlite > is cited in the wiki, but I can't find any concrete examples. If any > of you can share some success histories with me, I will be very > grateful.
The data warehouse for Sprint cellular phone networks is similar to that model. They simply store the data in flat files which is backed up for reporting purposes then loaded to the relational database. I like sqlite, and use it, but I'm not sure it's right for that application unless you need to summarize or process the data before it's loaded to db2. I'm sorry your boss is afraid to think for himself. :(
