Toon Koppelaars
@toonkoppelaars.bsky.social
Real-World Performance @oracle - ACE Director alumnus - database design - architect of SQL assertions - 📖 Applied Mathematics for Database Professionals - @TUeindhoven alumnus - Views are my own
November 21, 2025 at 7:19 PM
Also in SQL assertions, you cannot have nested ALL-SATISFY, only at top-level.
November 21, 2025 at 7:18 PM
Also in SQL assertions, you cannot have nested ALL-SATISFY, only at top-level.
For me it was other way around. The clip reminded me of the work we were doing 😀
November 19, 2025 at 9:11 AM
For me it was other way around. The clip reminded me of the work we were doing 😀
Some of it is easy to spot...
November 16, 2025 at 2:57 PM
Some of it is easy to spot...
Come to my session next week at DOAG...
November 11, 2025 at 3:21 PM
Come to my session next week at DOAG...
Oh wow. I get to eat out again this month 🤪
November 10, 2025 at 8:33 PM
Oh wow. I get to eat out again this month 🤪
That's what we have EBR for...
db-oriented.com/my-ebr-blog-...
db-oriented.com/my-ebr-blog-...
My EBR Blog Post Series - @DBoriented
This is an index to a series of posts I have been writing about Edition-Based Redefinition. New entries will be added as soon as they are published. Part 1: Overview and Setup [1-Dec-2017] Part 2: Loc...
db-oriented.com
November 1, 2025 at 6:48 PM
That's what we have EBR for...
db-oriented.com/my-ebr-blog-...
db-oriented.com/my-ebr-blog-...
My first one, and shortly thereafter the C64 ofcourse... :-)
September 1, 2025 at 5:54 AM
My first one, and shortly thereafter the C64 ofcourse... :-)
Strange pic for connection leaks...
I like the pic though :-)
Be sure to keep on the lookout for #SQLAssertions
I like the pic though :-)
Be sure to keep on the lookout for #SQLAssertions
August 20, 2025 at 7:36 AM
Strange pic for connection leaks...
I like the pic though :-)
Be sure to keep on the lookout for #SQLAssertions
I like the pic though :-)
Be sure to keep on the lookout for #SQLAssertions
Another fine what-todo-when-retired example...
August 4, 2025 at 6:29 PM
Another fine what-todo-when-retired example...
Yeah,....
Be patient, please.
Be patient, please.
July 13, 2025 at 6:50 PM
Yeah,....
Be patient, please.
Be patient, please.
The worries during retirement....
😜
😜
July 10, 2025 at 12:54 PM
The worries during retirement....
😜
😜
I read "statistics" as "patterns".
If there's dominant query-pattern now that joins data of T1+T2, then having T1+T2 data denormalized into 1 table, helps that pattern. But in-time this pattern may become irrelevant, and other patterns become dominant.
Fully normalized = neutral wrt query patterns.
If there's dominant query-pattern now that joins data of T1+T2, then having T1+T2 data denormalized into 1 table, helps that pattern. But in-time this pattern may become irrelevant, and other patterns become dominant.
Fully normalized = neutral wrt query patterns.
July 2, 2025 at 9:23 AM
I read "statistics" as "patterns".
If there's dominant query-pattern now that joins data of T1+T2, then having T1+T2 data denormalized into 1 table, helps that pattern. But in-time this pattern may become irrelevant, and other patterns become dominant.
Fully normalized = neutral wrt query patterns.
If there's dominant query-pattern now that joins data of T1+T2, then having T1+T2 data denormalized into 1 table, helps that pattern. But in-time this pattern may become irrelevant, and other patterns become dominant.
Fully normalized = neutral wrt query patterns.
1965 was an extraordinary year... ;-)
June 13, 2025 at 7:35 AM
1965 was an extraordinary year... ;-)
Been working on #10 a lot the past 2-3 years...
June 13, 2025 at 6:32 AM
Been working on #10 a lot the past 2-3 years...