Re: [R] creating a database

From: jim holtman <jholtman_at_gmail.com>
Date: Mon, 17 Dec 2007 22:53:04 -0500

What are you intending to do with the data? How big is 'm'? How do you want to access the data? You can always put it in a SQL database that R can access and then pull out the rows that you are interested in. If 'm' is 100, then if you are just keeping numeric data, this will only require 16MB of memory, so you can just keep it in memory.

Some more information about the characteristics of the data and what you want to do with it are required to determine what might be the appropriate method for storing/accessing it.

On Dec 17, 2007 10:10 PM, dxc13 <dxc13_at_health.state.ny.us> wrote:
>
> useR's,
>
> I am writing a program in which the input can be multidimensional. As of
> now, to hold the input, I have created an n by m matrix where n is the
> number of observations and m is the number of variables. The data that I
> could potentially use can contain well over 20,000 observations.
>
> Can a simple matrix be used for this or would it be better and more
> efficient to create an external database to hold the data. If so, should
> the database be created using C and how would I do this (seeing as that I
> have never programmed in C)?
>
> Any help would be greatly appreciated. Thank you
>
> Derek
> --
> View this message in context: http://www.nabble.com/creating-a-database-tp14375875p14375875.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help_at_r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>

-- 
Jim Holtman
Cincinnati, OH
+1 513 646 9390

What is the problem you are trying to solve?

______________________________________________
R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Received on Tue 18 Dec 2007 - 03:55:55 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Tue 18 Dec 2007 - 04:30:20 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.