From: Christiaan K. <c.k...@li...> - 2006-11-23 05:28:56
|
Hi William On the surface that looks pretty accurate except I would put fez_xsd_display_matchfields in the middle and there are a few more links from it to the other tables. Eg fez_xsd_display_mf_option, fez_search_key etc. Basically any of the fields in that xsdmf table that are like 'xsdmf_cvo_id' will link to the table with the same column id eg 'cvo_id'. The same goes for most tables - which explains or mysql field naming conventions. Cheers, Christiaan -----Original Message----- From: fez...@li... [mailto:fez...@li...] On Behalf Of Guillaume Rosquin Sent: Thursday, 23 November 2006 7:15 AM To: Fez developers Subject: [Fez-developers] Fez/Fedora database documentation Hi all, I have made a first draft of MySQL tables diagrams. But I still miss of knowledge to establish all existing links. Obviously, as MySQL doesn't support real relational constraints, those links are purely logical/conceptual and not enforced by embedded DB controls. As I have built those diagrams only by deducting relations from fields names and alternate keys, I would be glad if you can have a look on it and tell me the misses and errors. These documents would help developers to take care of proper controls to be done when adding/deleting records.=20 Because it is very easy with MySQL to loose the relationship's integrity. In particular when series of updates incurs in one user action and PHP execution is cancelled before the end. :-( Cheers, William |
From: Matthew S. <yo....@gm...> - 2006-11-23 23:33:49
|
Hi William, Which software did you use to make those diagrams? I could edit it and send it back to you. Is it an open source tool? Otherwise, we can make similar diagrams in Visio. Matt On 11/23/06, Christiaan Kortekaas <c.k...@li...> wrote: > Hi William > > On the surface that looks pretty accurate except I would put > fez_xsd_display_matchfields in the middle and there are a few > more links from it to the other tables. Eg fez_xsd_display_mf_option, > fez_search_key etc. > > Basically any of the fields in that xsdmf table that are like > 'xsdmf_cvo_id' will link to the table with the same > column id eg 'cvo_id'. The same goes for most tables - which explains or > mysql field naming conventions. > > Cheers, > Christiaan > > > > -----Original Message----- > From: fez...@li... > [mailto:fez...@li...] On Behalf Of > Guillaume Rosquin > Sent: Thursday, 23 November 2006 7:15 AM > To: Fez developers > Subject: [Fez-developers] Fez/Fedora database documentation > > Hi all, > > I have made a first draft of MySQL tables diagrams. > But I still miss of knowledge to establish all existing links. > Obviously, as MySQL doesn't support real relational constraints, those > links are purely logical/conceptual and not enforced by embedded DB > controls. > > As I have built those diagrams only by deducting relations from fields > names and alternate keys, I would be glad if you can have a look on it > and tell me the misses and errors. > > These documents would help developers to take care of proper controls to > be done when adding/deleting records. > Because it is very easy with MySQL to loose the relationship's > integrity. In particular when series of updates incurs in one user > action and PHP execution is cancelled before the end. :-( > > Cheers, > > William > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Fez-developers mailing list > Fez...@li... > https://lists.sourceforge.net/lists/listinfo/fez-developers > |
From: Guillaume R. <gui...@ca...> - 2006-11-24 02:37:33
Attachments:
Fez subset.pdf
|
Hi Christiaan & Matt, Here attached is a 'B' version of Fez 1.2 Database map. I have temporary separated Users Management & Authors Management in sub-packages because I didn't see links with documents. Aren't there some? 'fez_xsd_display_mf_option', 'fez_auth_index' and 'fez_status' still stay unlinked. Is it normal? The tables describing Parent/Child relationships, as they all use an internal id, could cause existence of dual Parent-Child links. It would be better to use the two fields Parent-Child as primary keys, or at least to be set those couples as unique keys. The links to 'fez_xsd_loop_subelement' are unusual (from & to 'fez_xsd_display_matchfields') and I think they should benefit to be more compliant with normal forms. Shouldn't they? I will look next week at your modifications for 1.3 and propagate them in the schema. I use PowerDesigner to setup/draw such schema and unfortunately Sybase charges for the licence. Perhaps Educational Institution may benefit of special discounts? I would have liked to use DBDesigner4 but it seems to be under a huge upgrade process by MySQL AB at the moment. :-( Have a good week-end, Cheers, William On Fri, 2006-11-24 at 09:33 +1000, Matthew Smith wrote: > Hi William, > > Which software did you use to make those diagrams? I could edit it > and send it back to you. Is it an open source tool? Otherwise, we > can make similar diagrams in Visio. > > Matt > > On 11/23/06, Christiaan Kortekaas <c.k...@li...> wrote: > > Hi William > > > > On the surface that looks pretty accurate except I would put > > fez_xsd_display_matchfields in the middle and there are a few > > more links from it to the other tables. Eg fez_xsd_display_mf_option, > > fez_search_key etc. > > > > Basically any of the fields in that xsdmf table that are like > > 'xsdmf_cvo_id' will link to the table with the same > > column id eg 'cvo_id'. The same goes for most tables - which explains or > > mysql field naming conventions. > > > > Cheers, > > Christiaan > > > > > > > > -----Original Message----- > > From: fez...@li... > > [mailto:fez...@li...] On Behalf Of > > Guillaume Rosquin > > Sent: Thursday, 23 November 2006 7:15 AM > > To: Fez developers > > Subject: [Fez-developers] Fez/Fedora database documentation > > > > Hi all, > > > > I have made a first draft of MySQL tables diagrams. > > But I still miss of knowledge to establish all existing links. > > Obviously, as MySQL doesn't support real relational constraints, those > > links are purely logical/conceptual and not enforced by embedded DB > > controls. > > > > As I have built those diagrams only by deducting relations from fields > > names and alternate keys, I would be glad if you can have a look on it > > and tell me the misses and errors. > > > > These documents would help developers to take care of proper controls to > > be done when adding/deleting records. > > Because it is very easy with MySQL to loose the relationship's > > integrity. In particular when series of updates incurs in one user > > action and PHP execution is cancelled before the end. :-( > > > > Cheers, > > > > William > > > > ------------------------------------------------------------------------- > > Take Surveys. Earn Cash. Influence the Future of IT > > Join SourceForge.net's Techsay panel and you'll get the chance to share your > > opinions on IT & business topics through brief surveys - and earn cash > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > _______________________________________________ > > Fez-developers mailing list > > Fez...@li... > > https://lists.sourceforge.net/lists/listinfo/fez-developers > > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Fez-developers mailing list > Fez...@li... > https://lists.sourceforge.net/lists/listinfo/fez-developers > |
From: Matthew S. <yo....@gm...> - 2006-11-24 04:36:13
|
the workflow_state_link table stores the edges between workflow states. wfsl_from and wfsl_to are references to wfs_id in workflow_state table. I'm not sure why i kept the wfl_id there too - maybe to make it easier to delete them. I think the xsd_display_mf_option.mfo_fld_id is referenced by xsd_display_matchfields.selected_option fez_auth index is a lookup table for the FezACML datastreams so we can query by security without having to try and work out the inheritance from parent objects on the fly. It has been rewritten in svn and superceded by auth_index2 and some other tables. We join it on fez_record_matching_field which is an index of metadata values for running queries against. The join is on rmf_rec_pid and authi_pid. Matt On 11/24/06, Guillaume Rosquin <gui...@ca...> wrote: > Hi Christiaan & Matt, > > Here attached is a 'B' version of Fez 1.2 Database map. > I have temporary separated Users Management & Authors Management in > sub-packages because I didn't see links with documents. Aren't there > some? > > 'fez_xsd_display_mf_option', 'fez_auth_index' and 'fez_status' still > stay unlinked. Is it normal? > > The tables describing Parent/Child relationships, as they all use an > internal id, could cause existence of dual Parent-Child links. > It would be better to use the two fields Parent-Child as primary keys, > or at least to be set those couples as unique keys. > > The links to 'fez_xsd_loop_subelement' are unusual (from & to > 'fez_xsd_display_matchfields') and I think they should benefit to be > more compliant with normal forms. Shouldn't they? > > I will look next week at your modifications for 1.3 and propagate them > in the schema. > > I use PowerDesigner to setup/draw such schema and unfortunately Sybase > charges for the licence. Perhaps Educational Institution may benefit of > special discounts? > I would have liked to use DBDesigner4 but it seems to be under a huge > upgrade process by MySQL AB at the moment. :-( > > Have a good week-end, > Cheers, > William > > > On Fri, 2006-11-24 at 09:33 +1000, Matthew Smith wrote: > > Hi William, > > > > Which software did you use to make those diagrams? I could edit it > > and send it back to you. Is it an open source tool? Otherwise, we > > can make similar diagrams in Visio. > > > > Matt > > > > On 11/23/06, Christiaan Kortekaas <c.k...@li...> wrote: > > > Hi William > > > > > > On the surface that looks pretty accurate except I would put > > > fez_xsd_display_matchfields in the middle and there are a few > > > more links from it to the other tables. Eg fez_xsd_display_mf_option, > > > fez_search_key etc. > > > > > > Basically any of the fields in that xsdmf table that are like > > > 'xsdmf_cvo_id' will link to the table with the same > > > column id eg 'cvo_id'. The same goes for most tables - which explains or > > > mysql field naming conventions. > > > > > > Cheers, > > > Christiaan > > > > > > > > > > > > -----Original Message----- > > > From: fez...@li... > > > [mailto:fez...@li...] On Behalf Of > > > Guillaume Rosquin > > > Sent: Thursday, 23 November 2006 7:15 AM > > > To: Fez developers > > > Subject: [Fez-developers] Fez/Fedora database documentation > > > > > > Hi all, > > > > > > I have made a first draft of MySQL tables diagrams. > > > But I still miss of knowledge to establish all existing links. > > > Obviously, as MySQL doesn't support real relational constraints, those > > > links are purely logical/conceptual and not enforced by embedded DB > > > controls. > > > > > > As I have built those diagrams only by deducting relations from fields > > > names and alternate keys, I would be glad if you can have a look on it > > > and tell me the misses and errors. > > > > > > These documents would help developers to take care of proper controls to > > > be done when adding/deleting records. > > > Because it is very easy with MySQL to loose the relationship's > > > integrity. In particular when series of updates incurs in one user > > > action and PHP execution is cancelled before the end. :-( > > > > > > Cheers, > > > > > > William > > > > > > ------------------------------------------------------------------------- > > > Take Surveys. Earn Cash. Influence the Future of IT > > > Join SourceForge.net's Techsay panel and you'll get the chance to share your > > > opinions on IT & business topics through brief surveys - and earn cash > > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > > _______________________________________________ > > > Fez-developers mailing list > > > Fez...@li... > > > https://lists.sourceforge.net/lists/listinfo/fez-developers > > > > > > > ------------------------------------------------------------------------- > > Take Surveys. Earn Cash. Influence the Future of IT > > Join SourceForge.net's Techsay panel and you'll get the chance to share your > > opinions on IT & business topics through brief surveys - and earn cash > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > _______________________________________________ > > Fez-developers mailing list > > Fez...@li... > > https://lists.sourceforge.net/lists/listinfo/fez-developers > > > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > _______________________________________________ > Fez-developers mailing list > Fez...@li... > https://lists.sourceforge.net/lists/listinfo/fez-developers > > > > |
From: Matthew S. <yo....@gm...> - 2006-11-24 04:48:34
|
I lied, the xsd_display_mf_option.mfo_fld_id is a reference to an xsdmf_id in fez_xsd_display_matchfields On 11/24/06, Matthew Smith <yo....@gm...> wrote: > the workflow_state_link table stores the edges between workflow > states. wfsl_from and wfsl_to are references to wfs_id in > workflow_state table. I'm not sure why i kept the wfl_id there too - > maybe to make it easier to delete them. > > I think the xsd_display_mf_option.mfo_fld_id is referenced by > xsd_display_matchfields.selected_option > > fez_auth index is a lookup table for the FezACML datastreams so we can > query by security without having to try and work out the inheritance > from parent objects on the fly. It has been rewritten in svn and > superceded by auth_index2 and some other tables. We join it on > fez_record_matching_field which is an index of metadata values for > running queries against. The join is on rmf_rec_pid and authi_pid. > > Matt > > > On 11/24/06, Guillaume Rosquin <gui...@ca...> wrote: > > Hi Christiaan & Matt, > > > > Here attached is a 'B' version of Fez 1.2 Database map. > > I have temporary separated Users Management & Authors Management in > > sub-packages because I didn't see links with documents. Aren't there > > some? > > > > 'fez_xsd_display_mf_option', 'fez_auth_index' and 'fez_status' still > > stay unlinked. Is it normal? > > > > The tables describing Parent/Child relationships, as they all use an > > internal id, could cause existence of dual Parent-Child links. > > It would be better to use the two fields Parent-Child as primary keys, > > or at least to be set those couples as unique keys. > > > > The links to 'fez_xsd_loop_subelement' are unusual (from & to > > 'fez_xsd_display_matchfields') and I think they should benefit to be > > more compliant with normal forms. Shouldn't they? > > > > I will look next week at your modifications for 1.3 and propagate them > > in the schema. > > > > I use PowerDesigner to setup/draw such schema and unfortunately Sybase > > charges for the licence. Perhaps Educational Institution may benefit of > > special discounts? > > I would have liked to use DBDesigner4 but it seems to be under a huge > > upgrade process by MySQL AB at the moment. :-( > > > > Have a good week-end, > > Cheers, > > William > > > > > > On Fri, 2006-11-24 at 09:33 +1000, Matthew Smith wrote: > > > Hi William, > > > > > > Which software did you use to make those diagrams? I could edit it > > > and send it back to you. Is it an open source tool? Otherwise, we > > > can make similar diagrams in Visio. > > > > > > Matt > > > > > > On 11/23/06, Christiaan Kortekaas <c.k...@li...> wrote: > > > > Hi William > > > > > > > > On the surface that looks pretty accurate except I would put > > > > fez_xsd_display_matchfields in the middle and there are a few > > > > more links from it to the other tables. Eg fez_xsd_display_mf_option, > > > > fez_search_key etc. > > > > > > > > Basically any of the fields in that xsdmf table that are like > > > > 'xsdmf_cvo_id' will link to the table with the same > > > > column id eg 'cvo_id'. The same goes for most tables - which explains or > > > > mysql field naming conventions. > > > > > > > > Cheers, > > > > Christiaan > > > > > > > > > > > > > > > > -----Original Message----- > > > > From: fez...@li... > > > > [mailto:fez...@li...] On Behalf Of > > > > Guillaume Rosquin > > > > Sent: Thursday, 23 November 2006 7:15 AM > > > > To: Fez developers > > > > Subject: [Fez-developers] Fez/Fedora database documentation > > > > > > > > Hi all, > > > > > > > > I have made a first draft of MySQL tables diagrams. > > > > But I still miss of knowledge to establish all existing links. > > > > Obviously, as MySQL doesn't support real relational constraints, those > > > > links are purely logical/conceptual and not enforced by embedded DB > > > > controls. > > > > > > > > As I have built those diagrams only by deducting relations from fields > > > > names and alternate keys, I would be glad if you can have a look on it > > > > and tell me the misses and errors. > > > > > > > > These documents would help developers to take care of proper controls to > > > > be done when adding/deleting records. > > > > Because it is very easy with MySQL to loose the relationship's > > > > integrity. In particular when series of updates incurs in one user > > > > action and PHP execution is cancelled before the end. :-( > > > > > > > > Cheers, > > > > > > > > William > > > > > > > > ------------------------------------------------------------------------- > > > > Take Surveys. Earn Cash. Influence the Future of IT > > > > Join SourceForge.net's Techsay panel and you'll get the chance to share your > > > > opinions on IT & business topics through brief surveys - and earn cash > > > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > > > _______________________________________________ > > > > Fez-developers mailing list > > > > Fez...@li... > > > > https://lists.sourceforge.net/lists/listinfo/fez-developers > > > > > > > > > > ------------------------------------------------------------------------- > > > Take Surveys. Earn Cash. Influence the Future of IT > > > Join SourceForge.net's Techsay panel and you'll get the chance to share your > > > opinions on IT & business topics through brief surveys - and earn cash > > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > > _______________________________________________ > > > Fez-developers mailing list > > > Fez...@li... > > > https://lists.sourceforge.net/lists/listinfo/fez-developers > > > > > > > > > ------------------------------------------------------------------------- > > Take Surveys. Earn Cash. Influence the Future of IT > > Join SourceForge.net's Techsay panel and you'll get the chance to share your > > opinions on IT & business topics through brief surveys - and earn cash > > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > > > _______________________________________________ > > Fez-developers mailing list > > Fez...@li... > > https://lists.sourceforge.net/lists/listinfo/fez-developers > > > > > > > > > |