Offers data federation to disparate data stores while giving high performance
Use Cases and Deployment Scope
We were evaluating database platforms to replace a seven database instance of Sybase which was being used by our application. Our goal was to collapse the data and consolidate it into a single instance. IBM DB2 Big SQL was one of the platforms we did an extensive evaluation of. We were excited about this platform because it gave us the ability to have a single database connection to connect to multiple disparate data stores. Our goal was to simplify our environment, our application and improve our performance. This was just being evaluated by our department and was not in use elsewhere at the time we did the evaluation.
Pros
- SQL compatibility.
- High performance.
Cons
- Cloud readiness.
- Ease of implementation.
Likelihood to Recommend
My recommendation obviously would depend on the application. But I think given the right requirements, IBM DB2 Big SQL is definitely a contender for a database platform. Especially when disparate data and multiple data stores are involved. I like the fact I can use the product to federate my data and make it look like it's all in one place. The engine is high performance and if you desire to use Hadoop, this could be your platform.