866 search results for "sql"

The challenge of combining 176 x #otherpeoplesdata to create the Biomass And Allometry Database

June 3, 2015
By
The challenge of combining 176 x #otherpeoplesdata to create the Biomass And Allometry Database

Despite the hype around "big data", a more immediate problem facing many scientific analyses is that large-scale databases must be assembled from a collection of small independent and heterogeneous fragments -- the outputs of many and isolated scientific studies conducted around the globe. Collecting and compiling these fragments is challenging at both political and technical levels. The political challenge is...

Read more »

How To Analyze Data: Seven Modern Remakes Of The Most Famous Graphs Ever Made

June 2, 2015
By
How To Analyze Data: Seven Modern Remakes Of The Most Famous Graphs Ever Made

Graphs can be beautiful, powerful tools. Graphs help us explore and explain the world. For hundreds of years, humans have used graphs to tell stories with data. To pay homage to the history of data visualization and to the power of graphs, we’ve recreated the most iconic graphs ever made. Some are remakes of the original shown in a...

Read more »

Simple Data Science To Maximize Return On Lottery Investment

June 1, 2015
By
Simple Data Science To Maximize Return On Lottery Investment

Every finite game has an equilibrium point (John Nash, Non-Cooperative Games, 1950) I read recently this amazing book, where I discovered that we (humans) are not capable of generating random sequences of numbers by ourselves when we play lottery. John Haigh demonstrates this fact analyzing a sample of 282 raffles of 6/49 UK Lotto. Once … Continue reading...

Read more »

R #1 by Wide Margin in Latest KDnuggets Poll

May 27, 2015
By
R #1 by Wide Margin in Latest KDnuggets Poll

The results of the latest KDnuggets Poll on software for Analytics, Big Data and Data Mining are out, and R has moved into the #1 position by a wide margin. I’ve updated the Surveys of Use section of The Popularity of Data … Continue reading →

Read more »

First Day Highlights from the Extremely Large Databases Conference

May 21, 2015
By
First Day Highlights from the Extremely Large Databases Conference

by Joseph Rickert The 8th XLDB (Extremely Large Databases) Conference open at Stanford on Tuesday with an outstanding program. This conference has been providing leadership in the "Big Data" world since its first workshop which was held in 2007. For example, the summary report for that year notes: "Both communities (industry and science) are moving towards parallel ... architectures...

Read more »

Course on using Oracle R Enterprise

Course on using Oracle R Enterprise

BNOSAC will be giving from June 08 up to June 12 a 5-day crash course on the use of R using Oracle R Enterprise. The course is given together with our Oracle Partner in Leuven, Belgium. If you are interested in attending, contact us for further details. For R users who aren't aware of this yet....

Read more »

Databases – an Ideal Application for R6?

May 20, 2015
By

Over the years I have tried to simplify and streamline my access to financial historic data. All different solutions I tried (see here, for example) so far have been unsatisfactory, at least to some degree. That however changed after I started using R6. Here is an example of using the R6 class for the same The post

Read more »

Database interfaces

May 20, 2015
By
Database interfaces

There are many different databases. The most familiar are row-column SQL databases like MySQL, SQLite, or PostgreSQL. Another type of database is the key-value store, which as a concept is very simple: you save a value specified by a key, and you can retrieve a value by its key. One more type is the document database, which instead of...

Read more »

infuser: a template engine for R

May 17, 2015
By

Version 0.1 of infuser was just released on CRAN. infuser is a very basic templating engine. It allows you to replace parameters in character strings or text files with a given specified value. I would often include some SQL code in my R scripts so t...

Read more »

Getting started with MongoDB in R

May 14, 2015
By
Getting started with MongoDB in R

The first stable version of the new mongolite package has appeared on CRAN. Mongolite builds on jsonlite to provide a simple, high-performance MongoDB client for R, which makes storing and accessing small or large data as easy as converting it ...

Read more »

Sponsors

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)