SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast
    Join Date
    Jul 2001
    Location
    Ireland
    Posts
    90
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How is an email database structured?

    Hi everyone,

    Would anyone have an idea how Hotmail (or indeed any email service provider) structure its database?

    Particular attention should be paid to:
    User name, password and email address;
    Mail folders (e.g. inbox, sent items, custom folders);
    Email subject header, date and sender;
    Email message text.

    Would I be correct for instance in assuming that there is one database of all emails, with a user id associated with each email, and that when a user clicks on the inbox, SQL (or in my case MySQL) will select from this database. This database obviously has the potential of getting enormous so how is that managed?

    Looking forward to hearing your views.

    Willie

  2. #2
    SitePoint Enthusiast
    Join Date
    Jul 2001
    Posts
    86
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Willie,
    Noooooooooooo, i would say its way more complicated than that. Hotmail would be running several thousand web servers each connected using load balancing to various sql server 200 warehoused systems. these database would be replicated over tcp/ip and backed up to offsite co-located servers for redundancy.

    i would assume that all of these machines are the same and the databases too. the tables would be really complex, containing dozens of constraints, triggers, keys, etc, etc, etc...
    Get ConMan and run your own web site!

    Want free programming eBooks? http://www.devarticles.com/ebooks.php

  3. #3
    SitePoint Enthusiast
    Join Date
    Jul 2001
    Location
    Ireland
    Posts
    90
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks Mytch,

    Perhaps Hotmail is too large an example to choose! What if we were looking at an email application with say max 10,000 accounts within it? Would that be a simple exercise in MySQL and any views on design?

    Willie


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •