Oracle Highest Ranked DB Engine? database buzz ranking for march 2014 -- click to enlarge database buzz ranking for march 2014

The website, which measures how germane almost 200 separate databases are in the current marketplace (including the market of ideas) has had Oracle ranked #1 for many consecutive months now. Their online graphic seems to depict a world in which Oracle is dominant, and by a large margin. What is even more impressive is that the #2-ranked engine is MySQL, also an Oracle product these days, followed by #3-ranked SQL Server from Microsoft. The gap between these three front-runners and the rest of the pack is considerable.     Continue…

12c Marketing Slideshows

CaptureCapture4These gallery images are taken from a series of seven slide shows accompanying the recent Oracle IOUG marketing tour introducing the design intentions for the new 12c database release. The slideshows are viewable as PDFs below; the seven topics are as follows:     Continue…

NFL Nerds 2013 : Week 1

credit: tim rasmussen/the denver post

credit: tim rasmussen/the denver post. click me!

A weekly tracking of the course of the 2013 NFL (American football) season, in graphics and R code. The data is stored in one or more simple Oracle database tables. New visualizations will be added as the season progresses.     Continue…

12c Debut Impressions

12c dog & pony show freebie

12c dog & pony show freebie

June 25 was the official first availability day for Oracle’s new multi-tenant release of it’s database. The slogan for this release is “Plug into the Cloud”. The companion enterprise manager, EM 12c, became available one week later. Oracle is conducting a multicity user group tour of one day marketing shows to unveil 12c consisting of a half dozen or so slick slide presentations given mostly by longtime Oracle hands. I attended the recent one in Ottawa and this post details some of my impressions.     Continue…

Probing Oracle’s NoSQL Agenda

There’s been media noise of late around the question of Oracle’s intentions (some would say laziness) concerning keeping it’s acquired MySQL database product relevant within the BD website backend niche. Two topics of conversation arise: the contest between MySQL and newcomer MariaDB in this arena, and the re-positioning going on concerning Oracle’s own flagship database … Continue reading

Will the real Data Scientist please stand up?

guess my bi job

guess my bi job

When fresh buzz is still shaking out around a trend in IT, e.g. now, things like job descriptions and resumes and internal hot project hype can distort to the max. Roles and expectations are well solidified for something like an operational grid DBA, but during this wild and woolly shakeout period for dataists, everyone has their own shtick approach.     Continue…

Medical Advances via the Semantic Web

I attended a product demo given by IO Informatics, the semantic health care analytics company, last month. The most intriguing service showcased was their Sentient Server and Knowledge Explorer tool. It can integrate with Oracle 11g (and other databases such as MySQL) as the backend data warehouse supporting typically billions of medical assertions.

GGPLOT Graphics for NFL Stats

GGPLOT2 is a package developed for producing graphics within the R statistical tool. It utilizes a layering metaphor for gradually adding visual details to the desired output. R can support datasets with millions of rows for various aggregation and analysis operations, but it can be slow, unwieldy to code in, and has memory limitations.

Layering in R for Oracle Data

The GGPLOT2 package for R, developed by Hadley Wickham, is preferred by many for it’s greater flexibility and range of graphing options. Here’s a tutorial explaining it’s capabilities and here’s the online documentation for the package.

Visualizing Oracle data: Tree Maps

I recently wrote about the R statistics and graphics platform, and introduced it as a way to do further analytics or visualizations for data from Oracle databases. This article will take a look at a graphical idea called tree maps. They are an extension of the more basic visualization technique: heat maps.


Get every new post delivered to your Inbox.