August, 2009

  • Data, Design, and SQL Server

    Disjoint subtyping in SQL

    Disjoint subtyping is a scenario that is often encountered in data modeling. In one frequently used modeling approach, an entity of a certain type is represented by a database table, and each subtype of this entity is represented by another table. Subtyping...
  • Data, Design, and SQL Server

    Surrogate keys in distributed databases

    In this post, the term "distributed database" refers to a set of SQL Server databases, each managed by a SQL server running on a separate computer. All databases have identical schemas, and data that originates in one database is replicated to all other...
Page 1 of 1 (2 items)