Received: by 10.100.20.39 with SMTP id 39mr2155405ant.6.1251750220875; Mon, 31 Aug 2009 13:23:40 -0700 (PDT)Date: Mon, 31 Aug 2009 13:23:40 -0700 (PDT)X-IP: 171.161.160.10User-Agent: G2/1.0X-Google-Token: aWpRzAwAAAAX8qM9ooDvA7ii-3MAdMkcX-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 1.0.3705; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; MS-RTC S; InfoPath.2; MS-RTC LM 8; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022),gzip(gfe),gzip(gfe)Message-ID: <9277a599-033e-4c1e-8e47-30ba883e391a@r33g2000vbp.googlegroups.com>Subject: KDB+ to Oracle?From: Richard Last <richard_ln>To: “Kdb+ Personal Developers” X-Google-Approved: charlie@kx.com via web at 2009-08-31 20:34:22Hello,I have an app that will be connecting to KDB+ and continuallyinserting data. As the data is inserted I need to persist it toOracle. Somewhere in the neighborhood of 300 million rows a day. I’mnew to KDB+ and am having difficulty finding a good starting point.What options are availble for doing this? What are the pros/cons?Any personal experience with this, and performance, would be greatlyappreciated.Oh, it’s running on Linux.Thanks in advance</richard_ln>
Hello Richard,
Here are my 2 cents.
The first option would be to use kdb+ as your historical database!
If you need to use Oracle then perhaps use the odbc interface provided by Kx might be a good option, however ODBC is deperecated in q as they prefer to use the native APIs (Java, C, C# etc.). This could be used in conjunction with unixODBC to hook up to Oracle. As you seem to be transferring quite a large number of rows I’m not 100% sure how this will perform.
However, I would highly recommend keeping the data in kdb+ if at all possible & use the native APIs to retrieve any data.
Regards,
Fintan.