On Feb 5, 2008 10:33 PM, David Major <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > > We're done drafting the Media Management System
> > (MMS) functional
> > > specification
> > > and thought it would be nice to post for community
> > feedback. Consider
> > > it out for your
> > > review. Appreciate the hard work by the MMS team,
> > especially Paul Cheng.
> > >
> > > http://www.opensolaris.org/os/project/mms/docs/
> >
> > Some little queries:
> >
> > Why postgres? Not that I've anything against
> > postgres, but I wonder
> > why there's a need for a database at all, let alone
> > that it be a particular
> > brand?
>
> The IEEE 1244.1-2000 spec suggests using a relational database for the
> MMS data model. The advantages to using a relational database are data
> integrity (field, table, and relationships between objects),
> transactions, ability to map MMP match and report statements onto SQL
> queries, and its a well documented and understood technology. Basically we
> off loaded the MMS data model complexity onto a relation database which
> is well suited for the task.
>
> Postgres was chosen because of the BSD license, Solaris availability,
> recommended internally as a good database for C applications, and Sun
> has 24x7 support for it.
>
> At the time MMS was started we looked at using MySQL but the cost
> prevented us from using it. We also looked at using a ODBC (Open
> DataBase Connectivity) driver but could not find a free one at the time
> to embed into an appliance. Now that Sun owns MySQL we will revisit the
> issues in a future release.
>
Have you considered an embedded SQL engine like SQLite, instead of
fully blown database server ?
--
Regards,
Cyril
_______________________________________________
storage-discuss mailing list
[email protected]
http://mail.opensolaris.org/mailman/listinfo/storage-discuss
