Db2 12 SQL Pagination: The ability to "page" through a result set and see the next "page" of results. Db2 12 introduced support for data-dependent and numeric-based pagination.
With the SQL OLAP RANK and DENSE_RANK functions being around for a while in SQL programming, it is quite easy to query for the TOP XX from data.
Db2 Batch processing has long been considered a mainframe only domain. Many enterprise domain applications require bulk processing of large volumes of data for critical environments. But,what if we could offload some of the batch process handling of mainframe jobs to Linux servers using Java?
Diving a bit deeper into examples where an application design that used to be efficient can become overly expensive.
Microservice architectures are trending. We need to consider how this impacts the performance of our applications and the databases we build to support them.