Cyril Plisko wrote: > 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 ? >
Yes, we looked at SQLite but did not want to get half way into it and realize we really needed a full blown database. We also looked at other Sun products like the Sun ESM (Enterprise Storage Manager) which is based on Postgres and checked with the Sun Database Group to ensure the database would fit our needs. -David _______________________________________________ storage-discuss mailing list [email protected] http://mail.opensolaris.org/mailman/listinfo/storage-discuss
