Hello Xinhuan, Happy to see that you choose Apache OFBiz for your business needs. Based on the overall outline of the business you are thinking of, the OFBiz has OOTB capabilities to fulfil all your requirements.
The question about party data model is little unclear to me but I will recommend you to go with MySQL database for storing the data. MySQL integration is seamless with Apache OFBiz and a lot of live projects on top of Apache OFBiz are using MySQL from years. Kind Regards, -- Pritam Kute On Thu, Jan 7, 2021 at 10:46 PM Xinhuan Zheng <[email protected]> wrote: > I am reviewing Apache OFbiz Data Model book - > https://cwiki.apache.org/confluence/download/attachments/13271792/OFBizDatamodelBook_Combined_20171001.pdf?api=v2, > Page 8 - 9, the Party, Contact, Communication, and Security data model. One > question just comes up into my mind. > > Suppose this is a Catalog Order business. It has products of books, DVDs, > supplies (for example, certain cups used in certain ceremony) that are all > not perishable. When catalogs are printed and sent to prospects, the > business takes the order, fulfills the order from inventoried product > items. Obviously, the business needs to store product items before orders > come in. This will involve in purchase orders from suppliers. This is an > outline of the business. > > The goal is to keep business process consistent, efficient, and obviously, > with limited budget of finance and human resources. So technology is > carefully compared, and Apache OFBiz comes out as a potential candidate. > > By analyzing the Apache OFbiz Party data model, as the link referenced > above, combining with the outlined business process and the goal, what > technology do you choose just for Party data model (including Party, > Contact, Communication, Security)? I am listing below potential > technologies: > > 1. Microsoft Excel Spreadsheet > 2. Microsoft Exchange Database > 3. MySQL Database > 4. Mongo Database > 5. Oracle Database > > Thanks! > >
