My journey into the GIS world
Most people in software development are familiar with time-aspect of data. Data can have a certain time, like events or a certain period. By now there are good tools and…
Tag: sql
Transformation in your stages are just functions
An often used concept in data warehouses is the concept of ‘stages’, where data moves from one stage to another. Stages are called often called ‘bronze’, ‘silver’ and ‘gold’. Data…
Something wrong with your data warehouse?
Why do data-teams struggle to add value? Why do so many data warehouses and data initiatives fail to add value? Want to know more? Or a more nuanced view? Use…
Snowflake primary keys woes
In my work I have used Snowflake quite a lot. The so called Data Cloud is very popular. Getting started is easy.One of the issues I have with Snowflake, it’s…
SQL Performance
If you have to access persisted data, of course, you do not have to necessarely use SQL. But in case you do, knowing something about SQL-performance helps. I just did…
Databases on SSD
SSD disk are becoming increasingly popular. As they read faster, you might consider running databases such as Oracle DBMS, MySQL or non-sql databases. However, interestingly, originally databases are optimized for…
Proxying authentication using JBoss
Wouldn’t it be nice if the connection to the database is done using the same username as the username used to login to a (JEE) application? Oracle has a solution…
Alternative to SQL
Database alternative, for people just browsing and scanning, I’ll write in staccato. Relational model pretty good, but we need a better implementation of the relational model, SQL, at least the…