search for: dbms

Hi R users, I am new to using DBMS with R for large datasets. Thanks to all who responded with useful suggestion to my earlier postings about using large datasets and DBMS with R. I am writing to get some help about how to design good tables in DBMS to take full advantage of the wonderful built-in facilities in R, like labels....

I'm using Samba to allow my users to store their database on a Redhat 6.1 file server. I've got some who want to shift to using Linux instead of Windows but the DBMS they use is not supported (yet... I'm told) on Linux and I'm afraid that multi-user access on different OS's are going to screw things all to high heck anyways... But that being said... Are there existing DBMS's out there that can co-exist on Windows and Linux using Samba as th...

I'm currently trying to do analysis on a 565k record database of Philadelphia's property assessments. I read the Data Import/Export .pdf and am still conflicted about which DBMS I should use to maintain reliability and ensure I don't crash while trying to do my calculations. Should I go with PostgreSQL for the option of Proxy Data Frames or should I go with MySQL for the "lean and mean" approach? Note that'd I'd be using it on a Windows 98 OS. Any i...

...be to format, query and make subsets of large datafiles for use in R. I recall reading a comparative write-up either in the newsletter, in the mails or someone's webpage last summer, but cant seem to find it now. I will be thankful if someone can help in locating such a document. For the DBMS it will be nice if it is a good database system to learn independent of its integration with R. My preference will be something that also works under Linux and has a user-friendly interface.

In a RoR application, is it possible to have individual userids associated with particular sessions employed to establish their related connections to the postgresql DBMS backend and, if so, is this design desireable? What are the implications for performance and future deployment limitations? The idea behind this question is that in our application certain tables require that the last accessor to a row be positively identified along with the date/time stamp....

I am seeking to hire a hardware/software consultant to help me build a stem with a 64 bit OS, R, and a SQL-compatible DBMS. Please contact me if you know of anyone qualified. Details: I am in need of a robust system that will run R, and a SQL compatible database. I will be working with large datasets, and wish to take advantage of as much RAM as possible, and therefore think I should use a 64 bit OS. Finally, I wil...

...9;m a new user with Asterisk Realtime. I'm trying to write a web application in PHP that will show me asterisk *conf files configuration and that can help me to add/remove users/peers etc... I know that from asterisk 1.0.7 on (with cvs upload) asterisk configuration files can be managed trough aDBMS in my case Mysql. I'd want to know if someone knows how can I "map" configuration files in database's tables: in example if I have a sip conf how can I create a table in my database whose contents are informations stored in sip.conf? Have I to manually insert all my peers in my da...

Can somebody provide me with a code example of how to tell a migration to add a sequence other than the default? I have been floundering around with the books and online resources but cannot find a clear example. I anticipate that some sort of option hash is invloved but I cannot determin the correct syntax. I imagine that it would go something like this: ... t.column :my_sequence_name

http://www.regdeveloper.co.uk/2008/02/18/stonebraker_dbms_outdated/ <quote> Stonebraker and his group also advocate abandoning SQL because they see no need for a separate data manipulation language. Data manipulation, they said, can be performed with other tasks using languages such as Ruby. </quote> -- There is nothing wrong with America t...

...over the communications protocol, but I would like to keep it to a standardised protocol, such as SOAP, CORBA, etc. What I would like to know is, what do other people use to do this? The nature of the communications will be low bandwidth procedure calls, with little data. (The data is stored in a DBMS). To date I have tried the RCORBA and SSOAP packages. Corba I couldn't get to compile, and soap I couldn't get to talk properly to soapanywhere (the embedded soap implementation I am trialing). I'm sure with persistence I can get both working, but I would like to hear others experienc...

...need to address some of the problems we get into when we use data.frames inappropriately due to lack of other/better data structures. But I don't think that one single class can truthfully and completely represent all "tabular data". For instance, interfaces to XML, spreadsheets, DBMS, etc., will further expose some of the limitations of these existing objects. Tables holding data from relational DBMS are an easy case: this class should preserve the original data as much as possible, i.e., no coercing into factors, no changing column names, no row names, but otherwise very...

I've been putting together a package that defined generic methods for database access. The packages is called "Rdbi." It borrows as much as possible from existing database packages / proposals. I'd like to start a discussion about the proposed interface. Here's what I've come up with so far: # # Rdbi: connectionMethods.R # dbConnect <- function(dbObj, ...)

Hi, i found tis message in the archive and have got the same problems ? John, perhaps you have found now a way install RPgSQL for windows2000, or anybody other ? many thanks for advance christian [SNIP] I wonder whether anyone has succeeded in building either the RPgSQL or the Rdbi.PGSQL and Rdbi packages for Windows. If so, would you be willing to share either the binary package(s) or

I''ve found vague mentions of various attempts at creating an ActiveRecord adapter for the KirbyBase pure Ruby DBMS, but nothing which looks like it''s actually working. Anyone know of such an adapter that is functional and available? b

i have a client application building power builder 11.5, i want connect with a server sql2008 I cant make this connection, i need help please... I have other application building power builder 9 and no have problem connection with sql2000 because use a driver odbc old

I need help. I'm trying to connect with an Oracle DBMS and MySQL DBMS, I'm using RJDBC package. My code is the next: library('rJava') library('DBI') library('RJDBC') //Mysql drv <- JDBC("com.mysql.jdbc.Driver","C:\\Temporal\\mysql-connector-java-3.0.9-stable-bin.jar","'") conn <-...

...T a.field from table WHERE (table."ID" = ? ) prepare the statement and keep the statement handle, with metadata so we can apply parameters on demand c. Apply parameters to the prepared statement and execute it On 2nd and subsequent invocations, the prepare phase within the DBMS (determining access paths) is sidestepped, the bandwidth usage is reduced to only parameters, scalability is improved enormously,and the security hole is plugged so special characters cannot cause undesired behavior. Thanks, David Johnson

Dear Friends Greetings, i have a question for you, i am sure someone can help. The pfsense captive portal is up and running. Time countdown vouchers are working without issue, such as 30m, 45m, 1h & so on. However, I'd like to set up a download quota of 200MB per voucher. but then you need to login with a username and password, instead of vouchers. but I haven't found a way to

Is there any way of preserving order of ordered factors when storing a table in PostgreSQL? I have been using PostgreSQL and the RPgSQL package to store a large table with answers such as "Strong disagreement", "Strong agreement", "Mild disagreement". "Mild agreement". When reading the table, such answers are turned into factors, apparently in

I''m a little confused as to how booleans work in Rails. Which is better in the database? boolean or int(1)? True == 1 and False == 0, right? Using SQLite, I tried to set a value to true inside the database but it gave me an error. MySql didn''t, so I had to switch to int(1) for it to work. Is this just how it is? --~--~---------~--~----~------------~-------~--~----~ You received