Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124
Zone Maps
The fastest query is the one you don’t need to make. Zone maps are a lightweight indexing technique that lets the query engine skip large chunks of data by storing…
Data Governance
As your organisation grows, so does the overhead of managing and controling the data. In large organisations, it is one of the most complex and time consuming activities, requiring teams…
Data Modeling for BI – Best Practices
Most business intelligence (BI) initiatives fail not because of bad technology choices or insufficient data, but because the underlying data model doesn’t align with how business users think about their…
Slowly Changing Dimensions
In the world of analytics and data warehousing, one of the trickiest challenges is keeping track of how things change over time. In operational systems, these changes often overwrite the…
Data Skipping
In large-scale analytics systems, scanning every record to answer a query is a recipe for slow performance and high cost.Data skipping is the technique that lets the engine read only…
Spatial Databases
Spatial databases are designed to store, query, and manipulate data that represents objects in space — from cities and roads to oceans and underground utility lines. Unlike traditional databases that…
Lance Tables
Now for something a bit different. In a world where data is no longer just rows in a database, the rise of vector databases and machine learning pipelines has pushed…
Spatial Indexing
When you query a traditional (relational) database column, a B-tree index usually handles the search efficiently.Spatial data, however, is not just a single dimension; it’s at least two (latitude, longitude)…
What Will Replace SQL?
Nothing. Ok, I should probably write a bit more than that. Nothing replaces SQL outright. Instead, three complementary layers are emerging around SQL. It will likely be with us forever,…
Rise and Fall(?) of the Data Warehouse
For nearly three decades, the enterprise data warehouse reigned supreme. It was the single source of truth, the vault where all valuable corporate data lived, cleaned, and neatly structured for…
From Tape to Terabytes
We don’t really think about where the data is physically stored. In the digital world, storage is the unsung hero. Data scientists, AI models and analytics tools often take centre…
Data Literacy
Every software project begins with someone deciding how to structure data. A developer creates database tables. An analyst designs a dimensional model. A product manager sketches entities and relationships on…
You must be logged in to post a comment.