This is the from a discussion shared in techrepublic. It helps in improving IT guy’s CV effectively.
Tag Archives: Oracle
Install ROracle for R-2.1
As our current R environment still uses R-2.1, the latest ROracle-0.5.8 can not be installed (minimal requirement is 2.3+). Instead, we tried to install ROracle-0.5.5.
ZT: .net 和 j2ee的区别
From: 骆驼空间站
关于.NET技术与Sun公司的Java2企业版(J2EETM)相比较,许多客户都想了解Microsoft公司的观点。由于以下的几个原因,.NET和JEE的比较有点棘手:
Fixed “man/groff” error in RHAS3.0
On Redhat AS3.0 environment, the “man” command fails with error:
/usr/bin/gtblgroff: /informatics/tools/Linux/lib/libgcc_s.so.1:
version `GCC_4.2.0′ not found (required by /usr/lib/libstdc++.so.5)
: /informatics/tools/Linux/lib/libgcc_s.so.1:
version `GCC_4.2.0′ not found (required by /usr/lib/libstdc++.so.5)
ZT: 国内IT工资探讨
From: wenxuecity
也是从网上找到的,作为以后拿Offer的参考,就我了解的而言,里面有一定的水分,可能是作者夸大了,BEA和Oracle的平均工资没那么高,因为我曾经就在这2家公司呆过.
ZT: SELECT TOP N in ORACLE and MySQL
A colleague asked me if I know how to limit the return data set in SQL (Oracle and MySQL). I did a search for Oracle, ya, it is correct to use ROWNUM internal variable to achieve that.
About puzzlebird
So, here is something about me.
Expertises:
HPC Architecutre, Performance tuning (system/program profile),
Linux/Unix, Mac osX, Oracle, MySQL, Perl, C, SHELL, PHP, XML, Joomla
varchar(byte) vs. varchar(char)
In oracle, varchar2 is widely used to hold variable length string. For varchar data type, there are two minor variants: varchar(byte) and varchar(char). Usually developer does not care about and uses the default from the system. We found that in some situation there may be performance issues for varchar(char) vs varchar(byte).
ensembl+DAS deployment
I have migrated “ensembl + DAS” from Marie’s linux workstation to Kampen and Genesis successfully. Marie has helped me to do everything from scratch (including hacks on ensembl web codes), so that we can track on the changes made. Below is the draft I sent to Ramneek/Neal/Kevin/Tim for review. I also proposed having all these discussed in CMAB meeting when Ramneek is back.
moving Marie’s DAS code to kampen
Marie has developed as few DAS service for Ensembl web. Previously the DAS ran on Marie’s own machine and the support team is requried to move this to production. Before I move it, it will be set up on kampen as a testing environment.