Desktop Survival Guide
by Graham Williams

Obtaining Data

Data can be sourced from many diverse repositories. Data is often stored today in relational databases like Oracle, MySQL, and SQLite, and accessed by the structured query language (SQL). It could be stored in systems like SAS and many other alternative proprietary systems. Many such systems provide access to the data in a number of forms and have particularly well tuned and efficient procedures for accessing the data. Such access is fine for many applications, but the user tends to be limited to the functionality provided by the particular application environment.

R provides a wealth of tools for importing data. In this section we overview the functions used to access common data formats. For a more complete exposition see 05:r_data_impor_expor.

Data warehouses

OLTP systems such as billing systems

Special databases, such as marketing and sales

Excel, Access

Flat files

External data sources, e.g., demographic data, market survey data

Describe output variable and input variables.

> library(help="foreign")

Copyright © 2004-2006 [email protected]
Support further development through the purchase of the PDF version of the book.
Brought to you by Togaware.