Data, data en nog eens data

Category: nice to know

  • Just some updates on PLSQL

    —

    by

    tom
    in

    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. You never forget that PL SQL is used to maintain data on an Oracle database. But I do forget tiny details such as how to…

  • Swaps: currency swap and foreign exchange swap

    —

    by

    tom
    in

    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. What is this anyway? I understand that a foreign exchange swap is related to a situation that one has foreign currency now, while it is…

  • the Zachman framework

    —

    by

    tom
    in

    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 an enterprise. The Zachman framework has two dimensions. The first dimension is the dimension of a party. Going from top to bottom, we show the…

  • Using IDA

    —

    by

    tom
    in

    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 what the capabilities are and in which areas these products are different from Erwin and PowerDesigner. As a general remark, I must say that I…

  • Create a description of a system

    —

    by

    tom
    in

    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 was to make a differentiation between processes, like sending mail, databases and applications. I also want to indicate what techniques are used. Moreover, I would…

  • Network reaction from Python

    —

    by

    tom
    in

    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 sent as a parameter. If these value coincide with expected value, the system returns a page where the user may click on a hyperlink to…

  • With Python in Hive

    —

    by

    tom
    in

    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 outside via ODBC. It is also possible to access the data as a SQL compliant database. The idea is that an abstraction is created on…

  • Connect from 32 bit environment to 64 Oracle instance

    —

    by

    tom
    in

    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 case, the full version name is “Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production”. Once this is known, one may ask whether it…

  • Create a report with BI Publisher

    —

    by

    tom
    in

    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 between a direct query on the database or use the route via the creating of a subject area. I can see advantages using a direct…

  • Reading XML in Oracle -2

    —

    by

    tom
    in

    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. From publications, I got the idea that the SQLLDR is the most recommended tool to do it. It does require some time and tuning but…