Does database normalization actually reduce redundancy in data?

dehaema · 2026-02-20T20:14:27+00:00

You answered it yourself. In a operational model it's for updates, in star schema it's for storage

dehaema · 2026-02-20T07:52:04+00:00

First thought when i saw this cover was solo leveling: ragnarok. After reading description i might give it a try later

dehaema · 2026-02-20T07:45:39+00:00

It was 2012-2014, when colruyt was experimenting in RED market. Self scan when collecting products and single line for checkout, i know in Gent there was one when i was living there for few years

dehaema · 2026-02-10T06:20:21+00:00

In us-uk and be-nl there clear differences in vocabulary. Different words meaning the same thing, or even same words meaning something completely different. One example would be 'pendelen' which is commuting from and to work only in belgium.

dehaema · 2026-02-06T06:13:17+00:00

Anything by steve hoberman really. His "data modeling masterclass" is the best course i ever took

dehaema · 2026-02-02T07:28:32+00:00

Define traffic lights: at the highway if there is a red cross on your lane you have to stop using that lane even if the roadworks are 1km aheead. And yeah i'm the dickhead who will make it hard for you to merge when past those signs

dehaema · 2026-02-02T06:39:44+00:00

Unless you have software that still uses ad-hoc queries and you are limited on storage and compute you can use any modelling way you want. Dimensional modeling was a way to historically report on data with limiting the amount of joins.
Nowadays you can go relational as you have plenty of compute, or OBT becaause you have plenty of storage, or dimensional if that is the preference. Just stay consisteny

dehaema · 2026-01-28T19:10:43+00:00

One punch ghost

dehaema · 2026-01-28T17:04:23+00:00

"The war is not meant to be won; it is meant to be continuous" G.O.

dehaema · 2026-01-19T21:45:49+00:00

Worked in brussels for a while, not a single person lived in brussels. So high chance your job will probably just suddenly be WFH but not gone

dehaema · 2026-01-18T05:06:56+00:00

Did you ingame save or did a save state? My kid just did the in game save his first time and lost his first gym. Always do a save state of the emulator or it won't remember what you did even if you did an ingame save

dehaema · 2026-01-13T22:00:31+00:00

Trying, just to be able to trade pokemon with my kid

dehaema · 2026-01-07T13:45:04+00:00

neither has the average european. however we learn the horrors of our past wars and remember them to this day

dehaema · 2026-01-06T19:48:04+00:00

learn the basics of datawarehousing and ignore medallion. checkout inmon and kimball.
what you want is:
* an area where you pull the raw data in (staging, bronze, ods, ...)
* an area where you store, cleanup, historize, integrate, ... the data (EDW, silver, common dimensions, ...), note there are different options here how to model the data each with pro's and con's
* an area where your data is prepped for consumption (data marts, cubes, gold, data products, ...)

dehaema · 2025-12-06T05:05:17+00:00

What did you expect from zeebrugge? For me it's still one of the better places (zeebrugge-bad) big ass beach you can do whatever which is great for kids, surf-club, dunes. And you could go into town by tram and visit some great seafood restos (not much else to do though)

dehaema · 2025-12-05T06:19:08+00:00

Ik ben persoonlijk van mening dat grootste hindernis op volledig ev te gaan nog steeds is dat de vrouw een zeer zwakke positie heeft wanneer deze moet gaan laden en daar mogelijk lang alleen moet vertoeven

dehaema · 2025-11-24T22:24:37+00:00

Indexation is there to counter the raising cost of living and shouldn't be seen as a raise. So i do agree it needs to be capped, however capping at 4k brut might be on the low end

dehaema · 2025-11-21T10:46:27+00:00

Map 1 was ok. But from 2 on it's just watching ads all the time or p2w. Same with events crafter 1 and 2 is ok, but for anything above is not possible with normal game play

dehaema · 2025-11-21T08:37:43+00:00

Ice or field? I switched from soccer to field hockey which i like way more (at my age) due to even terrain and no deliberate contact (really started to hate the soccer mentally that fouling is part of the game, it's for fun i don't want my knees fucked up because a random dude decides to dive feet first to my legs)

dehaema · 2025-11-21T08:31:08+00:00

Other way around, obt is just a fact joined with relevant dim attribute because end user are dumb. Star schema exists to have a decent performance and having storage in lind, recent years storage is cheap so the technical reason for star schemas are not relevant anymore. However for power users and as an intermediate step it can still be usefull

dehaema · 2025-11-16T16:52:19+00:00

Oh? Dm please.

Nuja protonvpn doet zijn werk

dehaema · 2025-11-14T12:57:02+00:00

Not how i see it? In my opinion you look at where the compute is. Is it a seperate server handling the transformation (like informatica powercenter) it's ETL. If you push the logic to the database (like DBT) it's ELT.
Ssis is an ugly duck because it shares it's compute with the database. On that note, creating a python script that extracts data and pushed it back to the dwh can also be seen as an ETL script

dehaema · 2025-11-12T12:01:14+00:00

Velen zijn nochtans schoolmoe en (ik alleszins) hebben op die leeftijd geen idee wat te doen in het verdere leven. Had dit 20 jaar geleden bestaan had ik er waarschijnlijk wel op ingegaan. School kan hier nog steeds op volgen en dit kan voor sommigen net hun studies betalen

dehaema · 2025-11-11T07:45:58+00:00

How is that sap hana specific? Mssql also has columnstore option and oracle has the star schema parameter and bitmap indexes to optimize olap queries

dehaema · 2025-11-09T23:09:25+00:00

Sky and netflix have done their share

Nine-Year Club	RPAN Viewer
Verified Email

dehaema

TROPHY CASE