Krzysztof K. Zdeb

AI

Handling Hierarchies in Dimensional Modeling

There are various modeling techniques for hierarchies. Which of them performs best in dimensional modeling in Data Warehouses? And how to address various types of hierarchies with them? Let’s find out. Krzysztof K. Zdeb · Follow Published in Towards Data Science · 12 min read · 4 hours ago — Hierarchies play a crucial role in dimensional modeling for Data Warehouses, influencing both the structure and efficiency of data analysis. Drawing from my own experiences

Read More »
AI

Best Practices for Technical Columns in Database Design

When architecting a transactional database or a data warehouse, it’s important not to forget about various types of technical columns. Krzysztof K. Zdeb · Follow Published in Towards Data Science · 15 min read · 10 hours ago — Technical columns in database design | Image by DALL·E, fx by author Technical columns play a fundamental role in database design. They serve various purposes: from audit-related matters, via support in…

Read More »
AI

Towards infinite LLM context windows

It all started with GPT having an input context window of 512 tokens. After only 5 years the newest LLMs are capable of handling 1M+ context inputs. Where’s the limit? Krzysztof K. Zdeb · Follow Published in Towards Data Science · 9 min read · 13 hours ago — I like to think of the LLMs (specifically, of the models parameters, i.e., their weights of the neural network layers and…

Read More »