Database Driven Mail Server - Benjamin Arai

outstandingmaskData Management

Nov 29, 2012 (4 years and 8 months ago)

204 views

Computer Science 183

Summer 2005



-

1

-

Database Driven Mail Server

Version 1.0.0

By: Benjamin Arai


Abstract:

Mail is one of the most important forms of communication used by
commercial and non
-
commercial entities today. Due to the high demand
for

real
-
time
communication and
fast online stor
age

it has become essential for email systems to not
only be
quick
and reliable but also have the capabilities to store large amounts of
data

in
a fast and efficient
manor
.

For the purpose of this project, we will be implementing a fully database driven em
ail
system. The project will include the usage of the following packages:



DBMAIL


.::.

http://www.dbmail.org/



PostgreSQL


.::.

http://www.postgresql.org
/



Postfix



.::.

http://www.postfix.org/



DBMAIL Admin

.::.

http://library.mobrien.com/dbmailadministrator/

The
first
three packages
(DBMAIL, PostgreSQL, and P
ostfix)
will be used to create a
mail storag
e system for receiving, processing, and storing emails via a DBMS storage
system. Below is a general schematic of how the email system will be setup.


The glue that will be
connecting

the database

(PostgreSQL)

and the
mail
(Postfix) system
is DBMAIL. The

combination of the
se

packages allow for individual
emails and user
accounts

to be stored in the database as records

as apposed to standard files in the file
Computer Science 183

Summer 2005



-

2

-

system
.

Notice that the database system replaces the file co
mponent commonly used in
mail systems by default.

Server Requirements

For completion of the project, each of the following components must be completed:



All emails must be stored in a PostgreSQL database



User account

must be stored in a PostgreSQL data
base



The email server must function to send and receive emails



Extra Credit: Supply a utility to import Washington IMAP or Cyrus mailboxes to
DBMAIL

Benefits

of Database Driven Systems

Some of the benefits of using a database driven
mail system
s

include a
controlled m
ethod
of storage and indexing

data (emails & user accounts)
.
For email systems databases
allow

easy access
and searching abilities

otherwise not available using standard file based
email systems.


By including a pure database driven core, sc
alability is no longer an issue because
the database system can be replaced or upgraded separately from the email server system.
This requires little configuration since the database system is separate from the entire
email system.


Performance of large s
erver systems including email servers quickly become
degraded as the number of users out way the abilities of the machine. By expanding an
email system to include an enterprise class storage system, performance can be increased
according to the needs whil
e traditional localized storage cannot.

Final Paper Requirements

If any of the following
requirements for the paper are not met,
all group member will
receive a zero for the project
.



Each paper is to follow the IEEE conference paper format



A complete

d
escription of the how the issues we accomplished



A step by step walk
-
through describing exactly
how
the email server

system

has
been setup

and configured



Must be s
ubmitted in PDF format

Each of the above items is required for completion of the project. Th
ere will be one
check
-
point before the final paper is due to comment on any changes or modification that
is required for completion of the paper.

Computer Science 183

Summer 2005



-

3

-

Sub
mission Requirements

Each submitt
ed project must include a compressed (ZIP, RAR, or TGZ)

file

in addition t
o
the final paper

containing all of the files used to setup and run the database driven email
server (This includes the PostgreSQL database contents and all configuration scripts).