oracle - Column Store Strategies -
we have app requires fast access columns delimited flat files, whithout knowing in advance columns in files. initial approach store each column in mongodb document array, not scale files bigger hit 16mb document limit.
my second approach split file columnwise , treat them blobs can served off disk client app. i'd intuitively think storing location in database , files on disk best approach, , storing them in database blobs (or in mongo gridfs) adding unnessasary overhead, there may advatages not apparant me @ moment. question is: advantage storing them blobs in database such (oracle/mongo) , there databases particularly suited task.
thanks, vackar
Comments
Post a Comment