Blpapi would be pretty slow for a lot of this stuff.
Sorry for the late revival, but if you have any experience with design/deployment of a database in context of minimizing cost to maintain blackbox+db in "the cloud" versus an in-house server, could you comment? I'm looking to store 3 months' worth of tick data across 30 US futures instruments, plus 8-10 years of 1-hour OHLC bar data past that, and the overall storage capacity projected plus the monthly transfer limits between a cloud solution like, say, Amazon, and my colo'd server to Chicago gets costs over $400/mo quickly. Versus going with a home server for the db, where speed will suffer, but then again, such a thing can be scheduled to occur in the after-hours.
Also, if you're using a home server, what's your hardware specs (HDD capacity total, RAM, CPU)?