569 search results for "SQL"

ROracle support for TimesTen In-Memory Database

September 27, 2012
By

Today's guest post comes from Jason Feldhaus, a Consulting Member of Technical Staff in the TimesTen Database organization at Oracle.  He shares with us a sample session using ROracle with the TimesTen In-Memory database.  Beginning in ve...

Read more »

Technical Analysis of Montana Voter Registration Files

September 18, 2012
By
Technical Analysis of Montana Voter Registration Files

By Earl F Glynn | Franklin Center This article shows how to analyze Montana voter registration files using R. The Montana Secretary of State sells two files of voter registration records for a fee of $1000: Statewide Voter File Voter History File The Montana Secretary of State provides information about the two files on this

Read more »

The R-Podcast Episode 10: Adventures in Data Munging Part 2

September 16, 2012
By

I’m happy to present episode 10 of the R-Podcast! Season 1 of the R-Podcast concludes with part 2 of my series on data munging, in which I discuss issues surrounding importing data sets contained in HTML tables. I share how I used the XML and RCurl packages to validate and import data from hockey-reference.com for

Read more »

Plotting model fits

August 29, 2012
By
Plotting model fits

We all know that it is important to plot your data and explore the data visually to make sure you understand it. The same is true for your model fits. First, you want to make sure that the model is fitting...

Read more »

Open Research Data Processes: KMi Crunch – Hosted RStudio Analytics Environment

August 23, 2012
By
Open Research Data Processes: KMi Crunch – Hosted RStudio Analytics Environment

One of the possible barriers to widespread adoption of open notebook science is knowing where to start. Video reports of lab experiments hosted on Youtube can be easily embedded in a hosted WordPress blog; a MediaWiki wiki can be used to provide one page per experiment, with change tracking/history on each page and a shadow

Read more »

The Kaggle Bug

August 22, 2012
By
The Kaggle Bug

If you have any interest in data mining and machine learning, you might have already caught the Kaggle bug.I myself fairly recently got caught up in following the various contests and forums after reading a copy of "Practical Time Series Forecasting," ...

Read more »

Querying a database from within R

August 18, 2012
By
Querying a database from within R

For a while now I have been contemplating pulling data from our postgreSQL db directly from R, but just never actually pulled the trigger until today.  What I found was that it was a lot easier than I ever could have imagined.  My laptop was already on the VPN, so I decided to try it

Read more »

Experience with Oracle R Enterprise in the Oracle micro-processor tools environment

August 17, 2012
By
Experience with Oracle R Enterprise in the Oracle micro-processor tools environment

Normal 0 false false false EN-US X-NONE X-NONE ...

Read more »

Quick SAP HANA and R usecase

Quick SAP HANA and R usecase

DISCLAIMER: I'm not an SAP HANA expert or an R expert, not even a Python expert. I'm just a guy with a lot of ideas who loves to write blogs.The other day I was thinking about making some nice with SAP HANA and R, because people doesn't seem to be enou...

Read more »

Minimum Expected Shortfall Portfolio, Part 1

August 8, 2012
By

A few days ago, I wrote a piece on finding the minimum expected shortfall portfolio.  A few astute commenters quickly picked up where I was going with this -- using this as an alternative to low/minimum volatility portfolios.  What follo...

Read more »