Applications around Mobile devices are becoming increasingly important in large enterprises with requirement of storing JSON in database. This presentation will illustrate the JSON storage model and SQL APIs to manipulate JSON data. Tips and pitfalls will be shared to ensure a successful JSON soluti
Analytics using R is often driven from client side applications such as RStudio and generally involves transmission of the large amounts of data from the database server to the clients for analysis. This method of doing the analysis can be slow given the limited resources on database client machines
DB2 is rich with built-in functions. There are simple scalar functions (LENGTH, SQRT, ABS), functions that deal with columns of data and grouping (AVG, SUM, OVER), row functions and specialized statistical functions (CORRELATION, STDDEV).
DB2 for LUW V11.1 introduced a number of important upgrade and recovery enhancements. This article describes each of these enhancements and then provides recipes for tasks which take advantage of these new features.