Revision history for WikkaPhysicalDataModel


Revision [22942]

Last edited on 2016-05-20 07:38:43 by JavaWoman [Replaces old-style internal links with new pipe-split links.]
Additions:
With the nice **DB Designer 4** tool from [[http://fabforce.net/ | fabFORCE.net]] one can "reverse engineer" a model directly from the data base quite easily. That worked well provided I didn't let it try to guess relationships: data names and keys just don't make this possible. So then I started to model the relationships in the tool ... and ran into some problems: not all tables have a primary key, and in some cases there is no primary key to match up with a foreign key. In other words: I could not draw all the lines. That also implies the code does some of what the database could do.
If you're interested in a more detailed look at the model, you can download {{files download="physical_current.xml" text="the XML file with the model"}} that you can load into **[[http://www.fabforce.net/dbdesigner4/ | DB Designer 4]]**: it's a free application that is available for Windows and Linux, and released under GPL: well worth a look.
Deletions:
With the nice **DB Designer 4** tool from [[http://fabforce.net/ fabFORCE.net]] one can "reverse engineer" a model directly from the data base quite easily. That worked well provided I didn't let it try to guess relationships: data names and keys just don't make this possible. So then I started to model the relationships in the tool ... and ran into some problems: not all tables have a primary key, and in some cases there is no primary key to match up with a foreign key. In other words: I could not draw all the lines. That also implies the code does some of what the database could do.
If you're interested in a more detailed look at the model, you can download {{files download="physical_current.xml" text="the XML file with the model"}} that you can load into **[[http://www.fabforce.net/dbdesigner4/ DB Designer 4]]**: it's a free application that is available for Windows and Linux, and released under GPL: well worth a look.


Revision [18287]

Edited on 2008-01-28 00:10:58 by JavaWoman [Modified links pointing to docs server]

No Differences

Revision [5917]

Edited on 2005-02-11 17:58:41 by JavaWoman [layout]
Additions:
=====Wikka Physical Data Model=====

>>See also:
~-WikkaTableStructure
~-WikkaLogicalDataModel
~-WikkaResources
>>In order to understand how Wikka stores and retrieves its data it would be helpful to have a model of the database - so I set out to create one.

===Creating the model===
With the nice **DB Designer 4** tool from [[http://fabforce.net/ fabFORCE.net]] one can "reverse engineer" a model directly from the data base quite easily. That worked well provided I didn't let it try to guess relationships: data names and keys just don't make this possible. So then I started to model the relationships in the tool ... and ran into some problems: not all tables have a primary key, and in some cases there is no primary key to match up with a foreign key. In other words: I could not draw all the lines. That also implies the code does some of what the database could do.

Now while older versions of MySQL don't support foreign keys, with the current physical model it's not even **possible** to store the relationships that way without actually changing the table structure. Not that it doesn't work - Wikka very obviously does work - but it's possible that with a cleaner physical data structure Wikka might be even more efficient than it is already.

So apart from documenting the current physical data model, I also spent some time creating a (half-way) **logical data model** to show what I think the structure actually should be, and which (I think) clarifies the data structure and how it functions better than the actual physical model. This (somewhat) **logical data model** can be found on its own WikkaLogicalDataModel page. You may want to look at that to better understand what the data model below //actually represents//.

===The current physical data model===
Below is a (slightly reduced) image of the physical data model. In the downloads section below you'll find a download link for the full-size image.

{{image src="images/models/physical_current_s.png" alt="physical model of Wikka's database showing the various tables and their relationships"}}

===Downloads===
You can also download a {{files download="physical_current_x.png" text="full-size version of the image"}}.

If you're interested in a more detailed look at the model, you can download {{files download="physical_current.xml" text="the XML file with the model"}} that you can load into **[[http://www.fabforce.net/dbdesigner4/ DB Designer 4]]**: it's a free application that is available for Windows and Linux, and released under GPL: well worth a look.

--JavaWoman

----
Deletions:
=====Wikka Physical Data Model=====

>>See also:
~-WikkaTableStructure
~-WikkaLogicalDataModel
~-WikkaResources
>>
In order to understand how Wikka stores and retrieves its data it would be helpful to have a model of the database - so I set out to create one.

===Creating the model===
With the nice **DB Designer 4** tool from [[http://fabforce.net/ fabFORCE.net]] one can "reverse engineer" a model directly from the data base quite easily. That worked well provided I didn't let it try to guess relationships: data names and keys just don't make this possible. So then I started to model the relationships in the tool ... and ran into some problems: not all tables have a primary key, and in some cases there is no primary key to match up with a foreign key. In other words: I could not draw all the lines. That also implies the code does some of what the database could do.

Now while older versions of MySQL don't support foreign keys, with the current physical model it's not even **possible** to store the relationships that way without actually changing the table structure. Not that it doesn't work - Wikka very obviously does work - but it's possible that with a cleaner physical data structure Wikka might be even more efficient than it is already.

So apart from documenting the current physical data model, I also spent some time creating a (half-way) **logical data model** to show what I think the structure actually should be, and which (I think) clarifies the data structure and how it functions better than the actual physical model. This (somewhat) **logical data model** can be found on its own WikkaLogicalDataModel page. You may want to look at that to better understand what the data model below //actually represents//.

===The current physical data model===
Below is a (slightly reduced) image of the physical data model. In the downloads section below you'll find a download link for the full-size image.

{{image src="images/models/physical_current_s.png" alt="physical model of Wikka's database showing the various tables and their relationships"}}

===Downloads===
You can also download a {{files download="physical_current_x.png" text="full-size version of the image"}}.

If you're interested in a more detailed look at the model, you can download {{files download="physical_current.xml" text="the XML file with the model"}} that you can load into **[[http://www.fabforce.net/dbdesigner4/ DB Designer 4]]**: it's a free application that is available for Windows and Linux, and released under GPL: well worth a look.

--JavaWoman

----


Revision [5913]

Edited on 2005-02-11 16:38:53 by DarTar [Layout]
Additions:
~-WikkaResources
>>
Deletions:
~-WikkaResources>>


Revision [5900]

Edited on 2005-02-10 23:12:14 by JavaWoman [adding references]
Additions:
>>See also:
~-WikkaTableStructure
~-WikkaLogicalDataModel
~-WikkaResources>>


Revision [5897]

Edited on 2005-02-10 22:45:30 by JavaWoman [adding files]
Additions:
{{image src="images/models/physical_current_s.png" alt="physical model of Wikka's database showing the various tables and their relationships"}}
You can also download a {{files download="physical_current_x.png" text="full-size version of the image"}}.
If you're interested in a more detailed look at the model, you can download {{files download="physical_current.xml" text="the XML file with the model"}} that you can load into **[[http://www.fabforce.net/dbdesigner4/ DB Designer 4]]**: it's a free application that is available for Windows and Linux, and released under GPL: well worth a look.
CategoryWikkaArchitecture
Deletions:
[image here]
[image link]
If you're interested in a more detailed look at the model, you can [model link] download the XML file with the model that you can load into **[[http://www.fabforce.net/dbdesigner4/ DB Designer 4]]**: it's a free application that is available for Windows and Linux, and released under GPL: well worth a look.
CategoryWikkaArchitecture {{files}}


Revision [5894]

The oldest known version of this page was created on 2005-02-10 22:16:10 by JavaWoman [adding files]
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki