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.…
Some spatial functions in Oracle
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,…
Oh my God: how good is open source
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…
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…
ElasticSearch: Restful services
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…
Curl and elasticSearch
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,…
ElasticSearch
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…