db table design

  • cole-p

    SSC Rookie

    Points: 32

    Hi guys and gals. forgive me if this questions is in the wrong place, new to the forum and sql development in general.

    what I am wondering is how the design of a database schema (logical design of tables and queries)  is affected by horizontal scaling given the constraint that the data being stored is unique. what i mean by this is that each server is not a mirror of a master server. an example would be a database like facebook.

    thanks for taking the time to read, looking forward to your replies!!

  • scdecade

    Say Hey Kid

    Points: 710

    cole-p wrote:

    ...how the design of a database schema (logical design of tables and queries)  is affected by horizontal scaling...

    Primarily through indexing.  Indexes are logical objects which exist for purely physical reasons.  They're the gerunds of the data world.  The physical model uses partitioning and other techniques.  There are a whole bunch of recipes.

    Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können

  • MVDBA (Mike Vessey)

    SSC-Insane

    Points: 21757

    This sounds like a NoSQL situation - basically "eventual consistency"  across many nodes????

    am I correct ?

    MVDBA

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply