Just some updates on PLSQL
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.…
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.…
Oracle has a wonderful spatial module. The spatial data are stored in a database as so-called SDO_GEOMETRY data type. The data in such field look like: (MDSYS.SDO_GEOMETRY(2001,90112,MDSYS.SDO_POINT_TYPE(121235,484926,NULL),NULL,NULL)). In this structure,…
A few days ago, I had to write a Python script that would enable us to write some data to an Oracle database. At first, I had no idea how…
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 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…
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…
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…
As we have seen in a previous post, we communicate with the ElasticSearch server via messages that are sent to a server. On the other hand, the server responds in…
One of the most useful utilities is “curl”. This wonderful tool can be used to transfer data from one platform to another. It is relatively easy to install in Windows,…
A new and popular nosql database is the Elastic Search database. This database is easy to install en easy to run. But is it easy to insert data and extract…