Key data model relationship pages in Wiki

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
50 messages Options
123
Reply | Threaded
Open this post in threaded view
|

Key data model relationship pages in Wiki

bsreekanth
CONTENTS DELETED
The author has deleted this message.
Reply | Threaded
Open this post in threaded view
|

Re: Key data model relationship pages in Wiki

Adrian Crum-2
It would be better to use the data type in those diagrams instead of the SQL type. For example, instead of partyId being VARCHAR(20) make it id-ne.

-Adrian

--- On Sun, 2/7/10, bsreekanth <[hidden email]> wrote:

> From: bsreekanth <[hidden email]>
> Subject: Key data model relationship pages in Wiki
> To: [hidden email]
> Date: Sunday, February 7, 2010, 10:23 AM
>
> Hello,
>    I added few of the data model
> relationship diagrams to the Wiki (up to
> Example, in alphabetical order). Please know if it is any
> help. I don't know
> much about the data model, but anyone may edit the page to
> add details to
> it. Once I read the data model book, I may contribute as
> well.
>
> Link:
> http://cwiki.apache.org/confluence/display/OFBIZ/Key+data+model+reference
>
> (Available through Documentation Overview)
>
> thanks,
> Babu.
> --
> View this message in context: http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472177.html
> Sent from the OFBiz - User mailing list archive at
> Nabble.com.
>



Reply | Threaded
Open this post in threaded view
|

Re: Key data model relationship pages in Wiki

Bruno Busco
In reply to this post by bsreekanth
Thank you Babu for this effort.
The charts are jpg files. How do you think people can help updating it?

-Bruno

2010/2/7 bsreekanth <[hidden email]>:

>
> Hello,
>   I added few of the data model relationship diagrams to the Wiki (up to
> Example, in alphabetical order). Please know if it is any help. I don't know
> much about the data model, but anyone may edit the page to add details to
> it. Once I read the data model book, I may contribute as well.
>
> Link:
> http://cwiki.apache.org/confluence/display/OFBIZ/Key+data+model+reference
> (Available through Documentation Overview)
>
> thanks,
> Babu.
> --
> View this message in context: http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472177.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
Reply | Threaded
Open this post in threaded view
|

Re: Key data model relationship pages in Wiki

Miles Huang
In reply to this post by Adrian Crum-2
Or just keep both.
For newbies including me, they may not familiar that VARCHAR(20) equals
to "id-ne" in entity definition, or vise-versa.

thanks,
Miles.

在 2010-02-07日的 10:56 -0800,Adrian Crum写道:

> It would be better to use the data type in those diagrams instead of the SQL type. For example, instead of partyId being VARCHAR(20) make it id-ne.
>
> -Adrian
>
> --- On Sun, 2/7/10, bsreekanth <[hidden email]> wrote:
>
> > From: bsreekanth <[hidden email]>
> > Subject: Key data model relationship pages in Wiki
> > To: [hidden email]
> > Date: Sunday, February 7, 2010, 10:23 AM
> >
> > Hello,
> >    I added few of the data model
> > relationship diagrams to the Wiki (up to
> > Example, in alphabetical order). Please know if it is any
> > help. I don't know
> > much about the data model, but anyone may edit the page to
> > add details to
> > it. Once I read the data model book, I may contribute as
> > well.
> >
> > Link:
> > http://cwiki.apache.org/confluence/display/OFBIZ/Key+data+model+reference
> >
> > (Available through Documentation Overview)
> >
> > thanks,
> > Babu.
> > --
> > View this message in context: http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472177.html
> > Sent from the OFBiz - User mailing list archive at
> > Nabble.com.
> >
>
>
>      


Reply | Threaded
Open this post in threaded view
|

Re: Key data model relationship pages in Wiki

Adrian Crum-2
The problem with using the SQL type is that it varies depending upon the database being used.

-Adrian

--- On Sun, 2/7/10, [hidden email] <[hidden email]> wrote:

> From: [hidden email] <[hidden email]>
> Subject: Re: Key data model relationship pages in Wiki
> To: [hidden email]
> Date: Sunday, February 7, 2010, 11:13 AM
> Or just keep both.
> For newbies including me, they may not familiar that
> VARCHAR(20) equals
> to "id-ne" in entity definition, or vise-versa.
>
> thanks,
> Miles.
>
> 在 2010-02-07日的 10:56 -0800,Adrian Crum写道:
> > It would be better to use the data type in those
> diagrams instead of the SQL type. For example, instead of
> partyId being VARCHAR(20) make it id-ne.
> >
> > -Adrian
> >
> > --- On Sun, 2/7/10, bsreekanth <[hidden email]>
> wrote:
> >
> > > From: bsreekanth <[hidden email]>
> > > Subject: Key data model relationship pages in
> Wiki
> > > To: [hidden email]
> > > Date: Sunday, February 7, 2010, 10:23 AM
> > >
> > > Hello,
> > >    I added few of the data model
> > > relationship diagrams to the Wiki (up to
> > > Example, in alphabetical order). Please know if
> it is any
> > > help. I don't know
> > > much about the data model, but anyone may edit
> the page to
> > > add details to
> > > it. Once I read the data model book, I may
> contribute as
> > > well.
> > >
> > > Link:
> > > http://cwiki.apache.org/confluence/display/OFBIZ/Key+data+model+reference
> > >
> > > (Available through Documentation Overview)
> > >
> > > thanks,
> > > Babu.
> > > --
> > > View this message in context: http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472177.html
> > > Sent from the OFBiz - User mailing list archive
> at
> > > Nabble.com.
> > >
> >
> >
> >       
>
>
>



Reply | Threaded
Open this post in threaded view
|

Re: Key data model relationship pages in Wiki

Jacques Le Roux-2-2
In reply to this post by Miles Huang
+1, but be explicit about what they are both

Jacques

From: <[hidden email]>


> Or just keep both.
> For newbies including me, they may not familiar that VARCHAR(20) equals
> to "id-ne" in entity definition, or vise-versa.
>
> thanks,
> Miles.
>
> 在 2010-02-07日的 10:56 -0800,Adrian Crum写道:
>> It would be better to use the data type in those diagrams instead of the SQL type. For example, instead of partyId being
>> VARCHAR(20) make it id-ne.
>>
>> -Adrian
>>
>> --- On Sun, 2/7/10, bsreekanth <[hidden email]> wrote:
>>
>> > From: bsreekanth <[hidden email]>
>> > Subject: Key data model relationship pages in Wiki
>> > To: [hidden email]
>> > Date: Sunday, February 7, 2010, 10:23 AM
>> >
>> > Hello,
>> >    I added few of the data model
>> > relationship diagrams to the Wiki (up to
>> > Example, in alphabetical order). Please know if it is any
>> > help. I don't know
>> > much about the data model, but anyone may edit the page to
>> > add details to
>> > it. Once I read the data model book, I may contribute as
>> > well.
>> >
>> > Link:
>> > http://cwiki.apache.org/confluence/display/OFBIZ/Key+data+model+reference
>> >
>> > (Available through Documentation Overview)
>> >
>> > thanks,
>> > Babu.
>> > --
>> > View this message in context: http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472177.html
>> > Sent from the OFBiz - User mailing list archive at
>> > Nabble.com.
>> >
>>
>>
>>
>
>

Reply | Threaded
Open this post in threaded view
|

Re: Key data model relationship pages in Wiki

Matt Warnock
In reply to this post by Miles Huang
+1

I suspect a lot more newbies understand SQL than OFBiz, but we need to
learn the new lingo too.

On Mon, 2010-02-08 at 03:13 +0800, [hidden email] wrote:

> Or just keep both.
> For newbies including me, they may not familiar that VARCHAR(20) equals
> to "id-ne" in entity definition, or vise-versa.
>
> thanks,
> Miles.
>
> 在 2010-02-07日的 10:56 -0800,Adrian Crum写道:
> > It would be better to use the data type in those diagrams instead of the SQL type. For example, instead of partyId being VARCHAR(20) make it id-ne.
> >
> > -Adrian
> >
> > --- On Sun, 2/7/10, bsreekanth <[hidden email]> wrote:
> >
> > > From: bsreekanth <[hidden email]>
> > > Subject: Key data model relationship pages in Wiki
> > > To: [hidden email]
> > > Date: Sunday, February 7, 2010, 10:23 AM
> > >
> > > Hello,
> > >    I added few of the data model
> > > relationship diagrams to the Wiki (up to
> > > Example, in alphabetical order). Please know if it is any
> > > help. I don't know
> > > much about the data model, but anyone may edit the page to
> > > add details to
> > > it. Once I read the data model book, I may contribute as
> > > well.
> > >
> > > Link:
> > > http://cwiki.apache.org/confluence/display/OFBIZ/Key+data+model+reference
> > >
> > > (Available through Documentation Overview)
> > >
> > > thanks,
> > > Babu.
> > > --
> > > View this message in context: http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472177.html
> > > Sent from the OFBiz - User mailing list archive at
> > > Nabble.com.
> > >
> >
> >
> >      
>


--
Matt Warnock <[hidden email]>
RidgeCrest Herbals, Inc.

Reply | Threaded
Open this post in threaded view
|

Re: Key data model relationship pages in Wiki

bsreekanth
In reply to this post by Adrian Crum-2
CONTENTS DELETED
The author has deleted this message.
Reply | Threaded
Open this post in threaded view
|

Re: Key data model relationship pages in Wiki

bsreekanth
In reply to this post by Bruno Busco
CONTENTS DELETED
The author has deleted this message.
Reply | Threaded
Open this post in threaded view
|

Re: Key data model relationship pages in Wiki

BJ Freeman
In reply to this post by bsreekanth
I think that a explanation about db and where the db info for ofbiz can
be found would be appropiate.
If you want to use SQL varchar(20) then make sure is modeled for the db
that has the least. So someone does not ask why there db can not handle
larger values of varchar


Adrian Crum sent the following on 2/7/2010 11:28 AM:

> The problem with using the SQL type is that it varies depending upon the database being used.
>
> -Adrian
>
> --- On Sun, 2/7/10, [hidden email] <[hidden email]> wrote:
>
>> From: [hidden email] <[hidden email]>
>> Subject: Re: Key data model relationship pages in Wiki
>> To: [hidden email]
>> Date: Sunday, February 7, 2010, 11:13 AM
>> Or just keep both.
>> For newbies including me, they may not familiar that
>> VARCHAR(20) equals
>> to "id-ne" in entity definition, or vise-versa.
>>
>> thanks,
>> Miles.
>>
>> 在 2010-02-07日的 10:56 -0800,Adrian Crum写道:
>>> It would be better to use the data type in those
>> diagrams instead of the SQL type. For example, instead of
>> partyId being VARCHAR(20) make it id-ne.
>>> -Adrian
>>>
>>> --- On Sun, 2/7/10, bsreekanth <[hidden email]>
>> wrote:
>>>> From: bsreekanth <[hidden email]>
>>>> Subject: Key data model relationship pages in
>> Wiki
>>>> To: [hidden email]
>>>> Date: Sunday, February 7, 2010, 10:23 AM
>>>>
>>>> Hello,
>>>>     I added few of the data model
>>>> relationship diagrams to the Wiki (up to
>>>> Example, in alphabetical order). Please know if
>> it is any
>>>> help. I don't know
>>>> much about the data model, but anyone may edit
>> the page to
>>>> add details to
>>>> it. Once I read the data model book, I may
>> contribute as
>>>> well.
>>>>
>>>> Link:
>>>> http://cwiki.apache.org/confluence/display/OFBIZ/Key+data+model+reference
>>>>
>>>> (Available through Documentation Overview)
>>>>
>>>> thanks,
>>>> Babu.
>>>> --
>>>> View this message in context: http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472177.html
>>>> Sent from the OFBiz - User mailing list archive
>> at
>>>> Nabble.com.
>>>>
>>>
>>>        
>>
>>
>
>
>
>

Reply | Threaded
Open this post in threaded view
|

Re: Key data model relationship pages in Wiki

Adrian Crum-2
In reply to this post by bsreekanth
If you look at the entity reference page in Webtools, you will see all of the entity information in a convenient table format. So, the code already exists to gather the entity information, you just need to output it in another format.

-Adrian

--- On Sun, 2/7/10, bsreekanth <[hidden email]> wrote:

> From: bsreekanth <[hidden email]>
> Subject: Re: Key data model relationship pages in Wiki
> To: [hidden email]
> Date: Sunday, February 7, 2010, 12:35 PM
>
> Adrian,
> thanks for the feedback. the graph is generated from the
> database tables,
> and may have to look at how to do the same from xml schema
> definitions. the
> easiest to do would be explaining the sql and ofbiz data
> types, and how they
> maps. I can point to the configuration where it also shows
> how it differ for
> different databasses.
> thanks,
> babu
> --
> View this message in context: http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472302.html
> Sent from the OFBiz - User mailing list archive at
> Nabble.com.
>


     
Reply | Threaded
Open this post in threaded view
|

Data Model Diagrams (was Re: Key data model relationship pages in Wiki)

David E. Jones-2
In reply to this post by bsreekanth

If people are interested in making diagrams there is some stuff build into OFBiz to export "eomodeld" files. That particular file format can be imported by a few tools, but mostly on the Mac (my preferred tool being OmniGraffle). Unfortunately the weeks I put into that code, organizing the entities into groups, and then creating and organizing diagrams for the groups, was done while I was part of Hotwax Media so I don't actually have any rights to the diagrams any more, and I'm not sure what the situation is with them (a Hotwax rep would have to answer that I guess).

I've thought about doing a new export and creating a new set of diagrams, but the amount of work required to layout all of the diagrams again is well beyond what this is worth to me... :)

It would be great to see another pass at this be done fully open so that various people could participate and share the load. To do so would require agreeing on some file formats at least, and possibly tools as well (which makes it difficult, at best). The eomodeld files that OFBiz exports are NOT diagram files, but can be imported into a diagramming tool. From there a diagram file can be exported and maintained going forward.

BTW, for new and changed entities it is probably more work to redo the export and layout than it is to modify the diagram files, so creating the diagram file from the eomodeld files probably only needs to be done once. The output formats that I can do easily with OmniGraffle include: Visio XML, PICT Vector, SVG, EPS Vector, PDF Vector, and various rendered pixel/bit-map formats that are probably not of much use. BTW, just to note Visio XML is only supported by a limited number of tools and is not the same as the Visio binary files. The alternative would be to write some other export code to write the model in a different format.

On a side note, there is some stuff to write eomodeld files for services as well (with ECAs joining the services together).

-David


On Feb 7, 2010, at 2:35 PM, bsreekanth wrote:

> Adrian,
> thanks for the feedback. the graph is generated from the database tables,
> and may have to look at how to do the same from xml schema definitions. the
> easiest to do would be explaining the sql and ofbiz data types, and how they
> maps. I can point to the configuration where it also shows how it differ for
> different databasses.
> thanks,
> babu
> --
> View this message in context: http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472302.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.

Reply | Threaded
Open this post in threaded view
|

Re: Key data model relationship pages in Wiki

bsreekanth
In reply to this post by Jacques Le Roux-2-2
CONTENTS DELETED
The author has deleted this message.
Reply | Threaded
Open this post in threaded view
|

Re: Key data model relationship pages in Wiki

David E. Jones-2

Babu: could you please subscribe to the list so I don't have to moderate through every message you send? I may not always be around to do so in a timely manner...

-David


On Feb 7, 2010, at 3:32 PM, bsreekanth wrote:

>
> Jaques.. thanks for the feedback. With reference to my reply to David (in a
> different thread "nice job on keeping the download site up-to-date." ),  it
> is best if I link the documents to the main index of the wiki. I even saw a
> page there for similar effort
> http://cwiki.apache.org/confluence/display/OFBIZ/Data+Model+Packages
> couple of things..
> 1. at the latest, you added a link there, which seems broken
> 2. the entity model is from 2003, and not sure how updated it all.
>
> Do you agree to replace the content with what I added at
> http://cwiki.apache.org/confluence/display/OFBIZ/Key+data+model+reference
>
> which I would complete or you prefer to keep a link to the existing page.
>
> Babu.
>
>
> Jacques Le Roux-2-2 wrote:
>>
>> +1, but be explicit about what they are both
>>
>> Jacques
>>
>> From: <[hidden email]>
>>
>>
>>> Or just keep both.
>>> For newbies including me, they may not familiar that VARCHAR(20) equals
>>> to "id-ne" in entity definition, or vise-versa.
>>>
>>> thanks,
>>> Miles.
>>>
>>> 在 2010-02-07日的 10:56 -0800,Adrian Crum写道:
>>>> It would be better to use the data type in those diagrams instead of the
>>>> SQL type. For example, instead of partyId being
>>>> VARCHAR(20) make it id-ne.
>>>>
>>>> -Adrian
>>>>
>>>> --- On Sun, 2/7/10, bsreekanth <[hidden email]> wrote:
>>>>
>>>>> From: bsreekanth <[hidden email]>
>>>>> Subject: Key data model relationship pages in Wiki
>>>>> To: [hidden email]
>>>>> Date: Sunday, February 7, 2010, 10:23 AM
>>>>>
>>>>> Hello,
>>>>>   I added few of the data model
>>>>> relationship diagrams to the Wiki (up to
>>>>> Example, in alphabetical order). Please know if it is any
>>>>> help. I don't know
>>>>> much about the data model, but anyone may edit the page to
>>>>> add details to
>>>>> it. Once I read the data model book, I may contribute as
>>>>> well.
>>>>>
>>>>> Link:
>>>>>
>>>> http://cwiki.apache.org/confluence/display/OFBIZ/Key+data+model+reference
>>>>>
>>>>> (Available through Documentation Overview)
>>>>>
>>>>> thanks,
>>>>> Babu.
>>>>> --
>>>>> View this message in context:
>>>> http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472177.html
>>>>> Sent from the OFBiz - User mailing list archive at
>>>>> Nabble.com.
>>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>>
> --
> View this message in context: http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472354.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.

Reply | Threaded
Open this post in threaded view
|

Re: Key data model relationship pages in Wiki

bsreekanth
CONTENTS DELETED
The author has deleted this message.
Reply | Threaded
Open this post in threaded view
|

Re: Data Model Diagrams (was Re: Key data model relationship pages in Wiki)

Erwan de FERRIERES
In reply to this post by David E. Jones-2
Le 07/02/2010 22:31, David E Jones a écrit :

> -David

We've got a tool here that uses the entitymodel files to generate
diagrams :
http://labs.libre-entreprise.org/projects/ufo/


--
Erwan de FERRIERES
www.nereide.biz
Reply | Threaded
Open this post in threaded view
|

Re: Data Model Diagrams (was Re: Key data model relationship pages in Wiki)

bsreekanth
CONTENTS DELETED
The author has deleted this message.
Reply | Threaded
Open this post in threaded view
|

Re: Data Model Diagrams (was Re: Key data model relationship pages in Wiki)

bsreekanth
In reply to this post by David E. Jones-2
CONTENTS DELETED
The author has deleted this message.
Reply | Threaded
Open this post in threaded view
|

Re: Data Model Diagrams (was Re: Key data model relationship pages in Wiki)

Matthieu Bollot-4
In reply to this post by bsreekanth
Le dimanche 07 février 2010 à 14:03 -0800, Babu Sreekanth a écrit :
> Hello Erwan,
>    I can'r find any activity on the link you sent. Can you please give a link to download the tool and documentation, so I may try.
> thanks,

Hi,
you can download it with svn :
svn checkout svn://labs.libre-entreprise.org/svnroot/ufo

run 'mvn' in trunk to compile
then launch it with java -jar UFO-0.9.15-SNAPSHOT-full.jar in target
folder.

you can get some information here :
http://ufo.labs.libre-entreprise.org/UFO/index.html

It is still in developpement because it is part of a student project but
it is already quite usable. Please feel free to report or ask anything
you want to, here or in neogia mailing list
( [hidden email] )


--
Matthieu BOLLOT
www.nereide.biz

Reply | Threaded
Open this post in threaded view
|

Re: Data Model Diagrams (was Re: Key data model relationship pages in Wiki)

Shi Jinghai
In reply to this post by David E. Jones-2
There are some perfect (not very perfect :) web-based process modelers
now, for example:

http://bpt.hpi.uni-potsdam.de/Oryx

http://bxmodeller.eng.it/

Not sure whether they are useful to draw a database diagram.

Shi Jinghai/Beijing Langhua Ltd.


在 2010-02-07日的 15:31 -0600,David E Jones写道:

> If people are interested in making diagrams there is some stuff build into OFBiz to export "eomodeld" files. That particular file format can be imported by a few tools, but mostly on the Mac (my preferred tool being OmniGraffle). Unfortunately the weeks I put into that code, organizing the entities into groups, and then creating and organizing diagrams for the groups, was done while I was part of Hotwax Media so I don't actually have any rights to the diagrams any more, and I'm not sure what the situation is with them (a Hotwax rep would have to answer that I guess).
>
> I've thought about doing a new export and creating a new set of diagrams, but the amount of work required to layout all of the diagrams again is well beyond what this is worth to me... :)
>
> It would be great to see another pass at this be done fully open so that various people could participate and share the load. To do so would require agreeing on some file formats at least, and possibly tools as well (which makes it difficult, at best). The eomodeld files that OFBiz exports are NOT diagram files, but can be imported into a diagramming tool. From there a diagram file can be exported and maintained going forward.
>
> BTW, for new and changed entities it is probably more work to redo the export and layout than it is to modify the diagram files, so creating the diagram file from the eomodeld files probably only needs to be done once. The output formats that I can do easily with OmniGraffle include: Visio XML, PICT Vector, SVG, EPS Vector, PDF Vector, and various rendered pixel/bit-map formats that are probably not of much use. BTW, just to note Visio XML is only supported by a limited number of tools and is not the same as the Visio binary files. The alternative would be to write some other export code to write the model in a different format.
>
> On a side note, there is some stuff to write eomodeld files for services as well (with ECAs joining the services together).
>
> -David
>
>
> On Feb 7, 2010, at 2:35 PM, bsreekanth wrote:
>
> > Adrian,
> > thanks for the feedback. the graph is generated from the database tables,
> > and may have to look at how to do the same from xml schema definitions. the
> > easiest to do would be explaining the sql and ofbiz data types, and how they
> > maps. I can point to the configuration where it also shows how it differ for
> > different databasses.
> > thanks,
> > babu
> > --
> > View this message in context: http://n4.nabble.com/Key-data-model-relationship-pages-in-Wiki-tp1472177p1472302.html
> > Sent from the OFBiz - User mailing list archive at Nabble.com.
>

123