The Joomla! Forum ™






Post new topic Reply to topic  [ 20 posts ] 
Author Message
PostPosted: Thu Mar 29, 2007 7:33 am 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat Oct 14, 2006 7:45 am
Posts: 32
I'm not sure whether this is the right forum to put this. If so pls feel free to remove it.

Is there a place where i can find a diagram of the Joomla Architecture. How the components & modules fit in to the core system.


Top
 Profile  
 
PostPosted: Thu Mar 29, 2007 8:10 am 
User avatar
Joomla! Master
Joomla! Master

Joined: Thu Aug 18, 2005 8:55 pm
Posts: 19956
Location: Nijmegen, The Netherlands
For Joomla 1.0.x there's a Joomla Enhanced Entity Relationship Diagram (ERD) in PDF available at: http://help.joomla.org/content/view/1570/125/

_________________
Kind Regards,
Peter Martin, Global Moderator - Community Leadership Team
http://www.db8.nl - Joomla specialist, Nijmegen, Nederland
Joomla 2.5 multilanguage in 10 steps: http://www.db8.nl/en/joomla-presentatio ... ge-website


Top
 Profile  
 
PostPosted: Thu Mar 29, 2007 10:35 am 
User avatar
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat Oct 14, 2006 7:45 am
Posts: 32
thanks.
wel i went through it. Its the entitity relation diagram . But what i realy want is a diagram to which will show the modeling part. How different componets are fixed to the core library. A box diagram kind of thing.


Top
 Profile  
 
PostPosted: Sat Oct 06, 2007 3:03 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sat Oct 06, 2007 1:14 pm
Posts: 2
Location: INDIA
pe7er wrote:
For Joomla 1.0.x there's a Joomla Enhanced Entity Relationship Diagram (ERD) in PDF available at: http://help.joomla.org/content/view/1570/125/


When trying to download that link it ask me username and password , my joomla forum username and password is accept ,
pl give me link where i can download ER DIAGRAM or u have laster 1.5  E R Diagram , pl email me on
webmaster@shreekailash.com
Thanks in Advance

PIYUSH PATEL


Last edited by ooffick on Thu Apr 08, 2010 8:04 pm, edited 1 time in total.
Mod Note: Deleted Manual Signature. Please read the Forum Rules for details


Top
 Profile  
 
PostPosted: Sat Oct 06, 2007 4:21 pm 
User avatar
Joomla! Ace
Joomla! Ace

Joined: Thu Aug 18, 2005 8:57 am
Posts: 1382
Location: Shrewsbury, Shropshire, United Kingdom
A case of link rot I think.  I think this is the file you are looking for: http://joomlacode.org/gf/project/joomla/scmsvn/?action=browse&path=%2F%2Acheckout%2A%2Fdocumentation%2Ftrunk%2Flibraries%2Fjoomla%2Ftutorials%2Fjoomla.database%2Fjoomlaerd_combined.pdf

It is probably well out-of-date though.  As far as I know there isn't anything more recent.

Regards,
Chris.

_________________
Chris Davenport - Joomla Production Leadership Team

Lion Coppice http://www.lioncoppice.org/
Davenport Technology Services http://www.davenporttechnology.com/


Top
 Profile  
 
PostPosted: Wed Apr 02, 2008 2:04 am 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Wed Nov 21, 2007 7:31 pm
Posts: 51
Location: Pune
The ERD and data flow diagram for joomla 1.0.x is at http://amiworks.co.in/talk/joomla-10x-how-it-works/ it based on the joomla version 1.0.11 so it is the most recent one i know

_________________
Do Something. Prioritize and focus

Have you checked out my blog today?.... No, do it now http://amiworks.co.in/talk/category/joomla

Join Joomla User Group Pune discussion group http://groups.google.com/group/jugpune


Top
 Profile  
 
PostPosted: Wed Aug 27, 2008 9:10 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Thu Sep 06, 2007 5:14 pm
Posts: 37
Entity Relationship Diagram for Joomla 1.5

Based on: Joomla 1.5.6.
Copyright (c) Jason A. Luttrell, 2008.
Also incorporates some elements from a diagram by Torkil Johnsen.

REVISION HISTORY

04/30/2006, Torkil Johnsen - Created an ER diagram for Joomla 1.5
8/27/2008, Jason Luttrell - Created an Entity Relationship Diagram independently, but incorporated some concepts from Johnsen’s. Updated for Joomla 1.5.6.

Attachment:
Download the PDF file here.


COPYRIGHT NOTICE

Since I was not a contributor in Joomla's development, and would not, therefore, understand all the decisions involved in the database's design, I suspect that there may be one or two mistakes in the schema that I developed. Thus, I compared mine with others, such as Torkil Johnsen’s. However, since it appears that there are no current schemas, I have made mine available here for public use and/or modifications, as long as you cite me as an author. Although I have decided to share this, it took awhile to create this version, so I would appreciate getting some credit for my work.

Please refer to the Creative Commons Attribution-Noncommercial-share Alike license:

http://creativecommons.org/licenses/by-nc-sa/3.0/us/

You are free to share and make derivatives (i.e. corrections or updates), as long as you include the above Revision History, attribute the aforementioned contributors as authors, you do not use it for commercial purposes, and you freely share the document.

HOW TO EDIT THE E.R. DIAGRAM

This ER Diagram was created using the free DBDesigner 4 (which is now replaced by MySQL Workbench 5.0), which can be downloaded from the fabFORCE.net Web site at... http://www.fabforce.net/dbdesigner4/

Under the Display sub-menu, I opted to turn on Crow's Foot notation, turn off Table Indices, and disable Relationship Names. I also had to adjust page setup so that the diagram would properly span six pages.

Attachment:
Download the MS Word documentation here.


Attachment:
Download the original DBDesigner 4 source file here.


You do not have the required permissions to view the files attached to this post.


Top
 Profile  
 
PostPosted: Wed Jun 03, 2009 1:38 pm 
User avatar
Joomla! Guru
Joomla! Guru

Joined: Wed Aug 24, 2005 9:34 am
Posts: 726
Location: Rørvik, Norway
Great work :D

I can recommend moving from FabForce DB Designer to MySQL Workbench, for this kind of work!

_________________
Torkil Johnsen
http://torkiljohnsen.com
http://twitter.com/torkilj


Top
 Profile  
 
PostPosted: Wed Nov 10, 2010 3:45 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Wed Sep 08, 2010 12:50 pm
Posts: 2
nice work chris


Top
 Profile  
 
PostPosted: Mon Jan 17, 2011 11:10 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Mon Jan 17, 2011 11:08 am
Posts: 1
i need the 1.6 ERD


Top
 Profile  
 
PostPosted: Thu Jan 20, 2011 8:22 am 
User avatar
Joomla! Guru
Joomla! Guru

Joined: Wed Aug 24, 2005 9:34 am
Posts: 726
Location: Rørvik, Norway
http://www.torkiljohnsen.com/2010/07/11 ... se-schema/

_________________
Torkil Johnsen
http://torkiljohnsen.com
http://twitter.com/torkilj


Top
 Profile  
 
PostPosted: Sun Feb 13, 2011 12:34 am 
User avatar
Joomla! Hero
Joomla! Hero

Joined: Fri Aug 12, 2005 2:45 am
Posts: 2281
Location: Brisbane, Australia
Torkil, there's no difference between an INT and INT(11) or INT(10). For an INT the (X) is the width of the print column when you show results in the command line.

_________________
Andrew Eddie - Tweet @AndrewEddie
<><
http://learn.theartofjoomla.com - Expert videos and tutorials.
http://www.kiva.org/team/joomla - Got Joomla for free? Pay it forward and help fight poverty.


Top
 Profile  
 
PostPosted: Sun Feb 13, 2011 9:00 am 
User avatar
Joomla! Guru
Joomla! Guru

Joined: Wed Aug 24, 2005 9:34 am
Posts: 726
Location: Rørvik, Norway
Yes, I've also noticed that the database works fine in spite of the inconsistencies. When trying to document it however, it poses some problems.

Stricter tools, like MySQL's own MySQL Workbench, will just wave big red flags in your face if you have an INT(3) that references a column that's an INT(10). Since I used MySQL Workbench to set up the schema, I had to manually change a lot of the column definitions merely to be allowed to set up the correct table relations.

My schema also goes a long way to try to illustrate table relations, while Joomla's MyISAM tables naturally do not have any table relations at all. I feel that without the table relations drawn in, then the schema would be a lot less helpful than with the imaginary relations drawn in, so that's why I've added them.

All of this and more is specified in detail in the explanation I wrote for the schema, in the blog post above.

_________________
Torkil Johnsen
http://torkiljohnsen.com
http://twitter.com/torkilj


Top
 Profile  
 
PostPosted: Sun Feb 13, 2011 9:10 am 
User avatar
Joomla! Guru
Joomla! Guru

Joined: Wed Aug 24, 2005 9:34 am
Posts: 726
Location: Rørvik, Norway
If I could I would have written some patches to fix all these inconsistencies, but I don't have as much free time to put into the project anymore. Maybe if Joomla opened a permanent paid position as a database evangelist, then I could get hired and help out, but until then I'll have to leave this to others. It's a real shame.

_________________
Torkil Johnsen
http://torkiljohnsen.com
http://twitter.com/torkilj


Top
 Profile  
 
PostPosted: Sun Feb 13, 2011 9:59 am 
User avatar
Joomla! Hero
Joomla! Hero

Joined: Fri Aug 12, 2005 2:45 am
Posts: 2281
Location: Brisbane, Australia
The inconsistency tend to come from which tool is used to dump the DB, however, good schema tools should know an INT is an INT. If you are interested in database evangelism, I recommend to talk to Mitch Pirtle. He can probably give you a pointer or two.

_________________
Andrew Eddie - Tweet @AndrewEddie
<><
http://learn.theartofjoomla.com - Expert videos and tutorials.
http://www.kiva.org/team/joomla - Got Joomla for free? Pay it forward and help fight poverty.


Top
 Profile  
 
PostPosted: Sun Feb 13, 2011 4:11 pm 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Thu May 04, 2006 9:11 am
Posts: 479
Location: Germany
I ♥ this thread... so much...

_________________
Developer of the AEC Membership Management Component: http://valanx.org
Fellow of the Free Software Foundation Europe (and so can you: http://www.fsfe.org !)


Top
 Profile  
 
PostPosted: Sun Feb 13, 2011 9:22 pm 
User avatar
Joomla! Guru
Joomla! Guru

Joined: Wed Aug 24, 2005 9:34 am
Posts: 726
Location: Rørvik, Norway
@Master Chief:

The INT column inconsistency is really the most insignificant of the issues mentioned, and so easy to remedy that it's weird you haven't fixed it yet. My blog post is 6 months old, but this stuff even dates well back to the Mambo days.

It also seems highly unlikely that a database tool should randomly alter the length on INT columns. The tool will just dump whatever schema the DB designer has set up.

Have you heard the saying "a fool with a tool is still just a fool". Fittingly enough, it's credited to Grady Booch, co-developer of the Unified Modeling Language.

But why did you decide to start discussing INT columns? And in this thread? A better place would be to comment on the blog post itself. Or, if you prefer staying in your home court, you could do it in this thread: viewtopic.php?p=2319990

_________________
Torkil Johnsen
http://torkiljohnsen.com
http://twitter.com/torkilj


Top
 Profile  
 
PostPosted: Sat Apr 02, 2011 6:39 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Feb 02, 2011 5:58 pm
Posts: 8
does anyone have the class diagram or some class diagram?


Top
 Profile  
 
PostPosted: Mon Apr 04, 2011 12:08 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Fri Mar 05, 2010 6:40 am
Posts: 6
nice,
who can help me to find the DFD for joomla 1.5 or 1.6
thanks


Top
 Profile  
 
PostPosted: Sat Apr 21, 2012 3:50 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat Apr 21, 2012 3:19 am
Posts: 13
Location: India
Thanks @pe7er it will help a newbie like me to understand Joomla well

_________________
~Aakash
A computer once beat me at chess, but it was no match for me at kick boxing
http://akashtablet.in/
Moving http://aadhaaruid.org/ from WP to Joomla


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 20 posts ] 



Who is online

Users browsing this forum: No registered users and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group