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.
Return on Investment
- Performance gains were positive.
- Finding resources on the street with knowledge at the time was hard.
Alternatives Considered
Oracle Exadata Database Machine, SAP HANA and Microsoft SQL Server
Other Software Used
MongoDB Atlas, Atlassian Jira Align (formerly AgileCraft), Atlassian Confluence
