search for: rdbms

Hi I've experienced some unpleasant behaviour while attempting to connect to an Empress 8.6.2 RDBMS via RODBC 1.2-3 and a freshly minted R 2.6.2.pat on a SLED linux system where a call to odbcConnect() to initiate the odbc connection causes R 2.6.2.pat to segfault. The odbcConnect call is CHANNEL <- odbcConnect("myEmpressDB", uid="myusername", pwd="mysecurepassword&q...

This may seem off the wall, but can dovecot be configured to support a connection to a database server and use the database server to store the e-mail message and its attachments? While you can use Postgres and MySQL for storing and authenticating users, there is a possibility to use an RDBMs to control the mail itself. Thoughts? -- Michael Segel Principal MSCC

...unctions use the very fast BDB, not a relational one, that has very different (better) scaling profiles than running those calls over a database driver, especially across a network. Having all those BDB data available in the relational DB for joins and other integrated queries (and backup and other RDBMS features) would be great, but there is danger in switching from the simple and high performance BDB into a more complex RDBMS. One way to do it is to leave the native BDB system, but interface a replica in the RDBMS to it. A polling process that replicates the BDB data into the RDBMS, and (if not n...

Have been looking into using rails but am finding the "Composite Primary Keys are Bad" thing a tad disturbing (to put it mildly). I have been working with RDBMS systems for over fifteen years and this is the first time I have herd the idea questioned. I have cone across using surrogate keys which mirror the composite key for performance reasons in VERY big databases but I have never herd the idea questioned from a logical database design point of view. A...

Hi, I''m seriously considering using Rails to develop several internal corporate web apps that will need to interact with well-established database systems (3 systems running SQL Server, Oracle, and PostgreSQL). The schema on these systems are basically set in stone. Can a Rails application interact with an existing schema without serious Rails modification? From what I''ve

I have this somewhat large data set that is given to me in a fixed width format. The file itself is already 100MB (Maybe R can actually handle this but I am trying to gain some experience in postgres and RODBC). I am using postgres to preprocess the file and connect to the database through the RODBC package. My question is much before the processing of the database in R (Iknow this is somewhat

We are using dbox with lz4 compression and dovecot-lda + sieve for delivery. Mail recieved: Mar 16 06:27:55 mail2 dovecot: lda(svs at example.com): sieve: msgid=<20160316032754.4C89D2C4 at rdbms.oldstable.office.example.com>: stored mail into mailbox 'INBOX' Around 08:14:00 user start his thunderbird with local filters. He found one mail without headers. Around that time user do repair folder in thunderbird: Mar 16 10:14:44 mail2 dovecot: imap(svs at example.com): Error: read(...

...********************************************************* I have a 2 node CentOS 4.5 86_64 system (kernel 2.6.9-55.EL). On this I installed Oracle OCFS2 1.2.7-1 (with exact kernel matching). After this I installed Oracle CRS 10.2.0.1 and that installation went fine. Then I tried to install Oracle RDBMS 10.2.0.1 and all the problems started from there. The /var/log/messages file got filled up with messages (giving some to avoid confusion): ocfs2_read_locked_inode: .. : ERROR: Invalid dinode #0 signature = ocfs2_lookup: .. : ERROR: Unable to create inode .... Then OUI gave several error messages,...

...s to load. So the 100% file I would think would load in < 15 minutes. But it grinds for about 15 mins and then seg faults instead. I don't think there's really very special about my data. Just several columns by ~5M rows. The same thing happens when I read the 100% sample in from an RDBMS with RODBC. For the time being I have worked around by feeding in small cross sections 100% from the RDBMS, and storing a 10% whole sample in RAM. But in the future it would be nice if I could just use the RAM in my box. Jeff Henrikson

We are new to R and evaluating if we can use it for a project we need to do. We have read that R is not well suited to handle very large data sets. Assuming we have the data prepped and stored in an RDBMS (Oracle, Teradata, SQL Server), what can R reasonably handle from a volume perspective? Are there some guidelines on memory/machine sizing based on data volume? We need to be able to handle Millions of Rows from several sources. Any advice is much appreciated. Thanks. [[alternative HTML ve...

Hey Guys, I have a network of windows clients with a couple of linux servers for various tasks. What I would like to do is have some form of antivirus on the clients that will log alerts to something on a linux server and store the info in sql. Anybody have any idea on something that can do this? I tried asking on the securityfocus virus list and I emailed grisoft about their network product.

Hi... I have a strange problem with my Private NIC Channel, here is my environment details : 1. RHAS 2.1 with kernel 2.4.9-e.27 Enterprise 2. OCFS version : 2.4.9-e-enterprise-1.0.9-6 3. Oracle RDBMS : 9.2.0.4 RAC with 5 Nodes 4. Private NIC Channel: Broadcom BCM5700 My Private NIC channel is down intermittently, we just tracing the root of the problems by identify each product installed the server, including OCFS. But there is no problem with my Public NIC Channel, which is having deferent ma...

Hi folks, I need your opinions on a basic design issue. I''ve seen the light of RoR and have replaced my Perl (DBI/CGI) based web server <-> RDBMS communication with RoR, but I still have a whole host of users (other servers/OS''s etc) out there wanting to talk to my RDBMS and they only talk Perl. Also they don''t want to talk Perl/DBI directly (they are not allowed to connect to the RDBMS directly). What I did in the "ol...

Hey folks, am hoping someone can set me straight with a solution to an issue that has come up involving the timing of rendered page elements in relation to the completion of an action''s execution. I have an ror search app which searches through two tables consisting of 7,000 page urls and a table w/ 87,000 related keyphrases within those pages. Search results can take anywhere from 2

R-help users, Thanks in advance for any assistance ... I truly appreciate your expertise. I searched help and could not figure this out, and think you can probably offer some helpful tips. I apologize if I missed something, which I'm sure I probably did. I have data for many "samples". (e.g. 1950, 1951, 1952, etc.) For each "sample", I have many data-frames.

Hi. I get some strange results when using rename_column on a primary key in a migration. It seems like the migration script removes the auto-increment property if you rename a column. This is a minimal example. create_table :foo, :primary_key => :foo_id do |t| t.column "name", :string end # renaming the primary key makes auto-increment disappear. rename_column

Is a RDBMS required for Dovecot to run in small (SOHO) environments? (Does it store indexes to the mail, etc.?) Or is it strictly leveraged for larger-scale environments? I'm asking, because the INSTALL says ./configure and make is enough for most...but as my previous post requested...there isn't a...

...is done in projection/planning of wind power stations? If not, would it be of interest to use R for this, and therefore adapt data-logger output to R (by providing certain data formats) or by providing R-modules for parsing of the data-logger files? Or would that better be done by connection to a RDBMS? Ciao, Oliver

I am trying to validate an integer field called quantity. I don''t know how to chack if it has gone beyond or below the maximum or minimum value allowed by the Firebird RDBMS. I tired adding this code to the validate method in the model: if (quantity > -2147483648) and (quantity < 2147483648) errors.add("quantity", "is out of range (must be between -2147483648 and 2147483648)") end But when I try entering a big value for examp...

Dear All... I need some information regarding OCFS performance in my Linux Box, herewith is my environment details : 1. We are using RHAS 2.1 with kernel 2.4.9-e.27 Enterprise 2. OCFS version : 2.4.9-e-enterprise-1.0.9-6 3. Oracle RDBMS : 9.2.0.4 RAC with 5 Nodes 4. Storage = EVA 6000 with 8 TB SIZE 5. We have 1 DiskGroup and 51 LUNs configured in EVA6000. My Question is : 1. It takes arround 15 minutes to mount arround 51 ocfs file system, is this a normal situation? 2. I monitor the OS using VMSTAT without starting the RAC serve...