I recently wrote a blog post about Oracle's Analytic Views and how those can be used in order to provide a simple SQL interface to end users with data stored in a relational database. In today's post I'm expanding a little bit on my horizons by looking at how to effectively query data in Hadoop using SQL. The SQL-on-Hadoop interface is key for many organizations - it allows querying the Big Data world using existing (more...)
We at Rittman Mead are always helping our customer solving their problems, many times we heard them
- being unsure about the sizing of their server
- being worried about the upfront cost of the licensing
- having recurring nightmares about patching
- willing to try the cloud but couldn't find the right option to replace their on-premises system
12.2, the latest Oracle database release provides a whole set of new features enhancing various aspects of the product including JSON support, Auto-List Partitioning and APEX news among others. One of the biggest news in the Data Warehousing / Analytics area was the introduction of the Analytic Views, that as per Oracle's definition are
Metadata objects that enable the user to quickly and easily create complex hierarchical and dimensional queries on data (more...)
Last week, during a quiet working morning, my colleague Robin Moffatt sent me a link that changed my working focus for few hours.
The link was to "OBIEE 11g: Required and Recommended Bundle Patches and Patch Sets (Doc ID 1488475.1)", a document containing the latest bundle patch (patch set) available for every major OBIEE release.
He spotted that for the first time, the new bundle patch released on 17 Jan 2017 was for (more...)