For some reason, short names are popular as computer languages. Think of “C”. Another example is “R”.
\nR reminds me a bit of Matlab; it is an easy to learn language with immense statistical possibilities. It is compared to nowadays giants like SAS.
\nThe advantage of R is that it is widely accepted by the academic community. This community contributes to R by adding new components to it. As R is open source, such additions can then be integrated into the R programme.<\/p>\n
To test R, I tested how much time it took me to install R, set up a connection to Oracle and retrieve data from it.
\n<\/p>\n
It took me about an hour to install R and to write a Hello World programme. In the second hour, I tried to access an Oracle database. The problem I encountered that the Oracle database was based on a 32 bit architecture and my R installation was a 64 bit programme. That proved to be an issue.
\nI circumvented this by using JDBC. The script I used was:<\/p>\n
\nlibrary(RJDBC)
\ndrv <- JDBC(\"oracle.jdbc.OracleDriver\",classPath=\"D:\/Users\/tmaanen\/app\/tmaanen\/product\/11.2.0\/client_1\/jdbc\/lib\/ojdbc5.jar\", \" \")\ncon <- dbConnect(drv, \"jdbc:oracle:thin:@192.168.2.26:1521:xe\", \"scott\", \"password\")\ndbGetQuery(con, \"select * from scott.EMPLOYEES\")\ndbDisconnect(con)\n\nIt took me about an hour to figure this out. But then I had it. \nThe nice thing about it, is that the script is very comparable to similar programmes. Nothing really special about it. \n\n<\/p>\n","protected":false},"excerpt":{"rendered":"For some reason, short names are popular as computer languages. Think of “C”. Another example is “R”. R reminds me a bit of Matlab; it is an easy to learn language with immense statistical possibilities. It is compared to nowadays giants like SAS. The advantage of R is that it is widely accepted by the […]<\/p>\n","protected":false},"author":1,"featured_media":827,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-826","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/826","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=826"}],"version-history":[{"count":0,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/826\/revisions"}],"wp:attachment":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=826"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=826"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=826"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}