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.
Oracle Highest Ranked DB Engine?
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
NFL Nerds 2013 : Week 2
NFL Nerds 2013 : Week 1
12c Marketing Slideshows
These 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…