Hearing the Oracle

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. Advertisements

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.

Oracle Highest Ranked DB Engine?

DB-engines.com database buzz ranking for march 2014 -- click to enlarge

DB-engines.com database buzz ranking for march 2014

The DB-engines.com 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…

R with Oracle

The data presentation graphic at right, and many of those sprinkled throughout this article (click them for better resolutions), are highlights from an enthusiast’s gallery which have been produced by the R statistical software package. R is an open-source programming language and environment which has gained much popularity among academics who want to apply statistical … Continue reading

Deletion Insurance

If you have some experience, the topic of deleting consequential data automatically brings to mind optional safety measures in case things go wrong. The recent article concerning data deduplication is a good example. What if — I didn’t test my DELETE code enough and a snafu occurs? What if — I have to retrieve some or all of the deleted rows after the fact? What if — I want to keep the deleted rows (or partial rows) available on the side for inspection for awhile?     Continue…

NFL Nerds 2013 : Week 3

speedy & elusive. credit: tim hawk/south jersey times

speedy & elusive. credit: tim hawk/south jersey times

My imagination as to how a weekly tracking of the course of the 2013 NFL (American football) season, in graphics, analytics, and R code, might look — in my imaginary copious spare time. The data is stored in one or more simple Oracle database tables. New visualizations will be added as the season progresses.     Continue…

NFL Nerds 2013 : Week 2

inverted td catch - credit: anthony souffle / chicago tribune

inverted td catch! check out the right hand of #15.          credit: anthony souffle / chicago tribune

My imagination as to how a weekly tracking of the course of the 2013 NFL (American football) season, in graphics, analytics, and R code, might look — in my imaginary copious spare time. The data is stored in one or more simple Oracle database tables. New visualizations will be added as the season progresses.     Continue…

NFL Nerds 2013 : Week 1

credit: tim rasmussen/the denver post

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

My imagination as to how a weekly tracking of the course of the 2013 NFL (American football) season, in graphics, analytics, and R code, might look — in my imaginary copious spare time. The data is stored in one or more simple Oracle database tables. New visualizations will be added as the season progresses.     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…

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…