Just some updates on PLSQL
tom
From time to time, I just repeat old exercises. I do this to maintain my knowledge before it gets lost in the mist of time. One such areas is PLSQL.…
Swaps: currency swap and foreign exchange swap
A little note from the area of financial economics. When going through the databases of a financial institution, one often encounters terms like foreign exchange swap, currency swap, interest swap.…
the Zachman framework
The Zachman framework is a nice example of so-called “IT Entreprise Architecture”. Such approach is directed at a comprehensive approach to the design, implementation and execution of IT strategy within…
Using IDA
IBM launched InfoSphere Data Architect (IDA). This is a data modelling tool that acts as a competitor with Erwin and PowerDesigner. I played a bit with this tool to see…
Create a description of a system
From time to time, I must provide a scheme on how a system works. It is not really to find a technique in which all details can be shown. I…
Network reaction from Python
I have a php script that runs as cgi on a webserver. The programme is quite simple. First is asks for a userid and password. The userid and password are…
With Python in Hive
In this small note, it is described how an HDFS file can be stored in a Hive context. In it stored in a Hive context, it can be accessed from…
Connect from 32 bit environment to 64 Oracle instance
One may retrieve the version of Oracle with a simple command: “select * from v$version;”. One may then see that the Oracle instance is a 64 bit version. In my…
Create a report with BI Publisher
One could create reports within the OBIEE sphere with the analytics. Another possibility is to use the BI Publisher. This option has several advantages. One advantage is that one choose…
Reading XML in Oracle -2
Loading XML into Oracle might require some SQLLDR code. Of course, the standard insert is a possibility, but this might be slow if many XML files are to be loaded.…