When working with BSON/JSON data modeling, adhere to best practices for schema design, document structure, indexing, data integrity, versioning, performance, security, and documentation. MongoDB-specific patterns include approximation, attribute, bucket, computed, document versioning, extended reference, outlier, preallocated, polymorphic, schema versioning, subset, tree and graph models for efficient, scalable, and maintainable data schemas. BSON, or Binary JSON,... Continue reading →

Data modeling is the systematic process of defining the structure, relationships, and constraints of a database. Through entity-relationship diagrams, it captures entities, attributes, and connections to mirror real-world scenarios. The resulting design ensures data accuracy, enhances query efficiency, and supports decision-making by transforming complex information into a structured and accessible format. Continue reading →

In this post I’ve put together some of the naming conventions, rules, and ideas that I tend to follow when creating database schemas to work with. This also applies to schema-less databases, distributed systems databases, graph, time series, or whatever else I am working with. It’s always good to have some good conventions to work... Continue reading →

I dig through a lot of internet results and blog entries that show CRUD data modeling all the time. A lot of these blog entries and documentation are pretty solid. Unfortunately, rarely do we end up with data that is accurately or precisely modeled the way it ought to be or the way we would... Continue reading →

Another flight down to the bay area. Today it was Alaska Air Flight 330 from Seattle to San Jose. It was mostly a clear day at start, with a solid layer of bright cloud cover exiting Washington on the way down to Oregon. As we crossed over that arbitrary human defined line of Oregon and... Continue reading →