Data Modeling Information

Data modeling can be challenging for many reasons. Steve talks about the choices you make in how you store data should be a part of that.

Moving away from an RDBMS

Today Steve looks at an article the migrates a relational model to CosmosDB.

Data Modeling in a New World

A changing world means new data modeling considerations.

The Power of the Data Model

A data model is far more powerful than simply a set of build instructions for DBAs. It can be used to shape business thought and actions for the benefit of all.

Numeric Data Types

Antipathy for Entity Attribute Value data models

EAV models have their uses but the costs are often hidden and if not hidden, more than anticipated.

Restructure 100 Million Row (or more) Tables in Seconds. SRSLY!

Changing the structure of a very large table doesn't need to require a maintenance window.

Naturally Increasing Data Value with Hierarchical Structures

Hierarchical structures have an inherent ability for significant data value increases beyond the data collected. This will be shown to exist in hierarchical structures and even more powerfully in their natural hierarchical processing capabilities. These will demonstrate flexible and efficient ways to increase data value automatically and will be discussed in this article. SQL will be used to perform a wide range of hierarchical processing operations that easily demonstrate these increasing data value capabilities.

Extending Hierarchical Data Modeling Demonstrated in SQL

The capability of extending the limits of combining multiple node hierarchical structures has not been fully explored. Michael M. David presents a solution to advanced structure combining that is simple to use, generic and freely extends the way hierarchical structures can be semantically combined to produce advanced new hierarchical data structure mashups that dynamically increase the value of the data.

Enforcing Data Quality while using Surrogate Keys

Data quality is important in a database, but so many people fail to implement good referential integrity. New author Marvin Elder brings us an article that looks at surrogate keys for ensuring data quality.