Ofbiz data model
Locked
 
|
Can someone please point me to the complete set of data model diagrams that
used to be easy to find? Thanks, Chris |
Administrator
|
I guess you are thinking about this page
https://cwiki.apache.org/confluence/display/OFBTECH/Data+Model Jacques Le 01/03/2014 20:24, Chris Perry a écrit : > Can someone please point me to the complete set of data model diagrams that > used to be easy to find? > > > > Thanks, > > Chris > > |
|
|
Hats off to David E Jones (and others) who created such an amazing
framework. On Sat, Mar 1, 2014 at 12:56 PM, Jacques Le Roux < [hidden email]> wrote: > I guess you are thinking about this page > https://cwiki.apache.org/confluence/display/OFBTECH/Data+Model > > Jacques > > Le 01/03/2014 20:24, Chris Perry a écrit : > > Can someone please point me to the complete set of data model diagrams >> that >> used to be easy to find? >> >> >> Thanks, >> >> Chris >> >> >> |
|
|
In reply to this post by Jacques Le Roux
Hi Jacques,
I did see those diagrams. Is that the complete data model? I thought there was another set of diagrams in the older user documentation that was (possibly) more complete. Thanks, Chris -----Original Message----- From: Jacques Le Roux [mailto:[hidden email]] Sent: Saturday, March 01, 2014 2:57 PM To: [hidden email] Subject: Re: Ofbiz data model I guess you are thinking about this page https://cwiki.apache.org/confluence/display/OFBTECH/Data+Model Jacques Le 01/03/2014 20:24, Chris Perry a écrit : > Can someone please point me to the complete set of data model diagrams > that used to be easy to find? > > > > Thanks, > > Chris > > |
|
|
Originally, the data model was based on the The Data Model Resource
Book. But the project has deviated from that model a lot since then. The diagrams you are looking at are quite old, and they demonstrate a fundamental flaw in documentation of that sort - the data model continues to evolve and any attempt to document it is obsolete soon after it is created. Adrian Crum Sandglass Software www.sandglass-software.com On 3/1/2014 5:36 PM, Chris Perry wrote: > Hi Jacques, > I did see those diagrams. Is that the complete data model? I thought there > was another set of diagrams in the older user documentation that was > (possibly) more complete. > > Thanks, > Chris > > -----Original Message----- > From: Jacques Le Roux [mailto:[hidden email]] > Sent: Saturday, March 01, 2014 2:57 PM > To: [hidden email] > Subject: Re: Ofbiz data model > > I guess you are thinking about this page > https://cwiki.apache.org/confluence/display/OFBTECH/Data+Model > > Jacques > > Le 01/03/2014 20:24, Chris Perry a écrit : >> Can someone please point me to the complete set of data model diagrams >> that used to be easy to find? >> >> >> >> Thanks, >> >> Chris >> >> > |
|
Administrator
|
The data model illustration by David at https://cwiki.apache.org/confluence/display/OFBTECH/Data+Model+Diagrams was done in Fall 2008.
The data model has not changed much since and you can safely refer to it. At least it's IMO the better illustration we have... AFAIK it's complete, well organised and easy to read (as can be: though there are "only" 800+ tables in OFBiz, against for instance 3500+ in Adempiere, it's still a BIG data model) I personally renamed the PDFs to have the page numbers in names. It's then easier to know which file to open when looking at the TOC. There were some other efforts, some are older but could be interesting also in some cases (not arranged the same way). https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Packages https://cwiki.apache.org/confluence/display/OFBIZ/Key+data+model+reference When I began to work with OFBiz (ten years ago) I looked for a graphic tool to dynamically represent the data model. I tried some then but nothing was really useful. Maybe there are appropriate tools now... HTH Jacques Le 02/03/2014 07:58, Adrian Crum a écrit : > Originally, the data model was based on the The Data Model Resource Book. But the project has deviated from that model a lot since then. > > The diagrams you are looking at are quite old, and they demonstrate a fundamental flaw in documentation of that sort - the data model continues to > evolve and any attempt to document it is obsolete soon after it is created. > > Adrian Crum > Sandglass Software > www.sandglass-software.com > > On 3/1/2014 5:36 PM, Chris Perry wrote: >> Hi Jacques, >> I did see those diagrams. Is that the complete data model? I thought there >> was another set of diagrams in the older user documentation that was >> (possibly) more complete. >> >> Thanks, >> Chris >> >> -----Original Message----- >> From: Jacques Le Roux [mailto:[hidden email]] >> Sent: Saturday, March 01, 2014 2:57 PM >> To: [hidden email] >> Subject: Re: Ofbiz data model >> >> I guess you are thinking about this page >> https://cwiki.apache.org/confluence/display/OFBTECH/Data+Model >> >> Jacques >> >> Le 01/03/2014 20:24, Chris Perry a écrit : >>> Can someone please point me to the complete set of data model diagrams >>> that used to be easy to find? >>> >>> >>> >>> Thanks, >>> >>> Chris >>> >>> >> > |
|
|
Perhaps look toward presenting the data model with one of those
Prezi/Sozi poster-zoom thingies. If the data model changes frequently, I'd recommend Sozi because at the end of the day Sozi presentations are merely SVG files (which are of course XML files that can be spun-up from various editable source files). On 14-03-02 01:33 AM, Jacques Le Roux wrote: > The data model illustration by David at > https://cwiki.apache.org/confluence/display/OFBTECH/Data+Model+Diagrams > was done in Fall 2008. > The data model has not changed much since and you can safely refer to > it. At least it's IMO the better illustration we have... > AFAIK it's complete, well organised and easy to read (as can be: though > there are "only" 800+ tables in OFBiz, against for instance 3500+ in > Adempiere, it's still a BIG data model) > I personally renamed the PDFs to have the page numbers in names. It's > then easier to know which file to open when looking at the TOC. > There were some other efforts, some are older but could be interesting > also in some cases (not arranged the same way). > https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Packages > https://cwiki.apache.org/confluence/display/OFBIZ/Key+data+model+reference > > When I began to work with OFBiz (ten years ago) I looked for a graphic > tool to dynamically represent the data model. I tried some then but > nothing was really useful. > Maybe there are appropriate tools now... > > HTH > > Jacques > > > Le 02/03/2014 07:58, Adrian Crum a écrit : >> Originally, the data model was based on the The Data Model Resource >> Book. But the project has deviated from that model a lot since then. >> >> The diagrams you are looking at are quite old, and they demonstrate a >> fundamental flaw in documentation of that sort - the data model >> continues to evolve and any attempt to document it is obsolete soon >> after it is created. >> >> Adrian Crum >> Sandglass Software >> www.sandglass-software.com >> >> On 3/1/2014 5:36 PM, Chris Perry wrote: >>> Hi Jacques, >>> I did see those diagrams. Is that the complete data model? I thought >>> there >>> was another set of diagrams in the older user documentation that was >>> (possibly) more complete. >>> >>> Thanks, >>> Chris >>> >>> -----Original Message----- >>> From: Jacques Le Roux [mailto:[hidden email]] >>> Sent: Saturday, March 01, 2014 2:57 PM >>> To: [hidden email] >>> Subject: Re: Ofbiz data model >>> >>> I guess you are thinking about this page >>> https://cwiki.apache.org/confluence/display/OFBTECH/Data+Model >>> >>> Jacques >>> >>> Le 01/03/2014 20:24, Chris Perry a écrit : >>>> Can someone please point me to the complete set of data model diagrams >>>> that used to be easy to find? >>>> >>>> >>>> >>>> Thanks, >>>> >>>> Chris >>>> >>>> >>> >> |
|
|
Considering both Jacques' and Adrian's comments, would it be correct to
continue to rely on the basic model as presented in the Data Model Resource Book (and the 2008 ofbiz docs) but with the understanding that there have been additions - not significant modifications - to that model? Thanks all, this has been very helpful. And thanks Todd for the Sozi suggestion. Chris -----Original Message----- From: Todd Thorner [mailto:[hidden email]] Sent: Sunday, March 02, 2014 9:22 AM To: [hidden email] Subject: Re: Ofbiz data model Perhaps look toward presenting the data model with one of those Prezi/Sozi poster-zoom thingies. If the data model changes frequently, I'd recommend Sozi because at the end of the day Sozi presentations are merely SVG files (which are of course XML files that can be spun-up from various editable source files). On 14-03-02 01:33 AM, Jacques Le Roux wrote: > The data model illustration by David at > https://cwiki.apache.org/confluence/display/OFBTECH/Data+Model+Diagram > s > was done in Fall 2008. > The data model has not changed much since and you can safely refer to > it. At least it's IMO the better illustration we have... > AFAIK it's complete, well organised and easy to read (as can be: > though there are "only" 800+ tables in OFBiz, against for instance > 3500+ in Adempiere, it's still a BIG data model) I personally renamed > the PDFs to have the page numbers in names. It's then easier to know > which file to open when looking at the TOC. > There were some other efforts, some are older but could be interesting > also in some cases (not arranged the same way). > https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Packages > https://cwiki.apache.org/confluence/display/OFBIZ/Key+data+model+refer > ence > > When I began to work with OFBiz (ten years ago) I looked for a graphic > tool to dynamically represent the data model. I tried some then but > nothing was really useful. > Maybe there are appropriate tools now... > > HTH > > Jacques > > > Le 02/03/2014 07:58, Adrian Crum a écrit : >> Originally, the data model was based on the The Data Model Resource >> Book. But the project has deviated from that model a lot since then. >> >> The diagrams you are looking at are quite old, and they demonstrate a >> fundamental flaw in documentation of that sort - the data model >> continues to evolve and any attempt to document it is obsolete soon >> after it is created. >> >> Adrian Crum >> Sandglass Software >> www.sandglass-software.com >> >> On 3/1/2014 5:36 PM, Chris Perry wrote: >>> Hi Jacques, >>> I did see those diagrams. Is that the complete data model? I thought >>> there was another set of diagrams in the older user documentation >>> that was >>> (possibly) more complete. >>> >>> Thanks, >>> Chris >>> >>> -----Original Message----- >>> From: Jacques Le Roux [mailto:[hidden email]] >>> Sent: Saturday, March 01, 2014 2:57 PM >>> To: [hidden email] >>> Subject: Re: Ofbiz data model >>> >>> I guess you are thinking about this page >>> https://cwiki.apache.org/confluence/display/OFBTECH/Data+Model >>> >>> Jacques >>> >>> Le 01/03/2014 20:24, Chris Perry a écrit : >>>> Can someone please point me to the complete set of data model >>>> diagrams that used to be easy to find? >>>> >>>> >>>> >>>> Thanks, >>>> >>>> Chris >>>> >>>> >>> >> |
|
Administrator
|
Yes I think we can say that. At least that's what I'm doing, because I don't see better ways.
For instance, I suggested to add a geo location data model around Summer 2009. This is not in the book, have been discussed thoroughly with the community and even slightly amended since then. So it follows the way things are done in the OFBiz data model. This is the most important aspect IMO, to continue in the same spirit and methods used in the existing data model. Jacques Le 02/03/2014 17:27, Chris Perry a écrit : > Considering both Jacques' and Adrian's comments, would it be correct to > continue to rely on the basic model as presented in the Data Model Resource > Book (and the 2008 ofbiz docs) but with the understanding that there have > been additions - not significant modifications - to that model? > > Thanks all, this has been very helpful. And thanks Todd for the Sozi > suggestion. > > Chris > > > -----Original Message----- > From: Todd Thorner [mailto:[hidden email]] > Sent: Sunday, March 02, 2014 9:22 AM > To: [hidden email] > Subject: Re: Ofbiz data model > > Perhaps look toward presenting the data model with one of those Prezi/Sozi > poster-zoom thingies. If the data model changes frequently, I'd recommend > Sozi because at the end of the day Sozi presentations are merely SVG files > (which are of course XML files that can be spun-up from various editable > source files). > > > > On 14-03-02 01:33 AM, Jacques Le Roux wrote: >> The data model illustration by David at >> https://cwiki.apache.org/confluence/display/OFBTECH/Data+Model+Diagram >> s >> was done in Fall 2008. >> The data model has not changed much since and you can safely refer to >> it. At least it's IMO the better illustration we have... >> AFAIK it's complete, well organised and easy to read (as can be: >> though there are "only" 800+ tables in OFBiz, against for instance >> 3500+ in Adempiere, it's still a BIG data model) I personally renamed >> the PDFs to have the page numbers in names. It's then easier to know >> which file to open when looking at the TOC. >> There were some other efforts, some are older but could be interesting >> also in some cases (not arranged the same way). >> https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Packages >> https://cwiki.apache.org/confluence/display/OFBIZ/Key+data+model+refer >> ence >> >> When I began to work with OFBiz (ten years ago) I looked for a graphic >> tool to dynamically represent the data model. I tried some then but >> nothing was really useful. >> Maybe there are appropriate tools now... >> >> HTH >> >> Jacques >> >> >> Le 02/03/2014 07:58, Adrian Crum a écrit : >>> Originally, the data model was based on the The Data Model Resource >>> Book. But the project has deviated from that model a lot since then. >>> >>> The diagrams you are looking at are quite old, and they demonstrate a >>> fundamental flaw in documentation of that sort - the data model >>> continues to evolve and any attempt to document it is obsolete soon >>> after it is created. >>> >>> Adrian Crum >>> Sandglass Software >>> www.sandglass-software.com >>> >>> On 3/1/2014 5:36 PM, Chris Perry wrote: >>>> Hi Jacques, >>>> I did see those diagrams. Is that the complete data model? I thought >>>> there was another set of diagrams in the older user documentation >>>> that was >>>> (possibly) more complete. >>>> >>>> Thanks, >>>> Chris >>>> >>>> -----Original Message----- >>>> From: Jacques Le Roux [mailto:[hidden email]] >>>> Sent: Saturday, March 01, 2014 2:57 PM >>>> To: [hidden email] >>>> Subject: Re: Ofbiz data model >>>> >>>> I guess you are thinking about this page >>>> https://cwiki.apache.org/confluence/display/OFBTECH/Data+Model >>>> >>>> Jacques >>>> >>>> Le 01/03/2014 20:24, Chris Perry a écrit : >>>>> Can someone please point me to the complete set of data model >>>>> diagrams that used to be easy to find? >>>>> >>>>> >>>>> >>>>> Thanks, >>>>> >>>>> Chris >>>>> >>>>> > > |
|
|
That sounds very reasonable, otherwise chaos prevails.
Thanks, Chris -----Original Message----- From: Jacques Le Roux [mailto:[hidden email]] Sent: Sunday, March 02, 2014 12:58 PM To: [hidden email] Subject: Re: Ofbiz data model Yes I think we can say that. At least that's what I'm doing, because I don't see better ways. For instance, I suggested to add a geo location data model around Summer 2009. This is not in the book, have been discussed thoroughly with the community and even slightly amended since then. So it follows the way things are done in the OFBiz data model. This is the most important aspect IMO, to continue in the same spirit and methods used in the existing data model. Jacques Le 02/03/2014 17:27, Chris Perry a écrit : > Considering both Jacques' and Adrian's comments, would it be correct > to continue to rely on the basic model as presented in the Data Model > Resource Book (and the 2008 ofbiz docs) but with the understanding > that there have been additions - not significant modifications - to that model? > > Thanks all, this has been very helpful. And thanks Todd for the Sozi > suggestion. > > Chris > > > -----Original Message----- > From: Todd Thorner [mailto:[hidden email]] > Sent: Sunday, March 02, 2014 9:22 AM > To: [hidden email] > Subject: Re: Ofbiz data model > > Perhaps look toward presenting the data model with one of those > Prezi/Sozi poster-zoom thingies. If the data model changes > frequently, I'd recommend Sozi because at the end of the day Sozi > presentations are merely SVG files (which are of course XML files that > can be spun-up from various editable source files). > > > > On 14-03-02 01:33 AM, Jacques Le Roux wrote: >> The data model illustration by David at >> https://cwiki.apache.org/confluence/display/OFBTECH/Data+Model+Diagra >> m >> s >> was done in Fall 2008. >> The data model has not changed much since and you can safely refer to >> it. At least it's IMO the better illustration we have... >> AFAIK it's complete, well organised and easy to read (as can be: >> though there are "only" 800+ tables in OFBiz, against for instance >> 3500+ in Adempiere, it's still a BIG data model) I personally renamed >> the PDFs to have the page numbers in names. It's then easier to know >> which file to open when looking at the TOC. >> There were some other efforts, some are older but could be >> interesting also in some cases (not arranged the same way). >> https://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Packages >> https://cwiki.apache.org/confluence/display/OFBIZ/Key+data+model+refe >> r >> ence >> >> When I began to work with OFBiz (ten years ago) I looked for a >> graphic tool to dynamically represent the data model. I tried some >> then but nothing was really useful. >> Maybe there are appropriate tools now... >> >> HTH >> >> Jacques >> >> >> Le 02/03/2014 07:58, Adrian Crum a écrit : >>> Originally, the data model was based on the The Data Model Resource >>> Book. But the project has deviated from that model a lot since then. >>> >>> The diagrams you are looking at are quite old, and they demonstrate >>> a fundamental flaw in documentation of that sort - the data model >>> continues to evolve and any attempt to document it is obsolete soon >>> after it is created. >>> >>> Adrian Crum >>> Sandglass Software >>> www.sandglass-software.com >>> >>> On 3/1/2014 5:36 PM, Chris Perry wrote: >>>> Hi Jacques, >>>> I did see those diagrams. Is that the complete data model? I >>>> thought there was another set of diagrams in the older user >>>> documentation that was >>>> (possibly) more complete. >>>> >>>> Thanks, >>>> Chris >>>> >>>> -----Original Message----- >>>> From: Jacques Le Roux [mailto:[hidden email]] >>>> Sent: Saturday, March 01, 2014 2:57 PM >>>> To: [hidden email] >>>> Subject: Re: Ofbiz data model >>>> >>>> I guess you are thinking about this page >>>> https://cwiki.apache.org/confluence/display/OFBTECH/Data+Model >>>> >>>> Jacques >>>> >>>> Le 01/03/2014 20:24, Chris Perry a écrit : >>>>> Can someone please point me to the complete set of data model >>>>> diagrams that used to be easy to find? >>>>> >>>>> >>>>> >>>>> Thanks, >>>>> >>>>> Chris >>>>> >>>>> > > |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |