Hi Ola, Doesn't it mean that using parent/child hierarchy one has to compute the level, which is already known and is not subject for change during the long run? Computing level from parent/child hierarchy is costly and should be avoided. And what is wrong with storing just a column of level ids in orgunit table for easy reference? Taking into account the fact that DHIS2 is data warehousing tool at large and data redundancy and denormalized tables are the rule.
regards, murod On Thu, Nov 14, 2013 at 7:07 PM, Ola Hodne Titlestad <[email protected]>wrote: > Hi Riddy, > > The resource tables are not part of the schema or data model as such, but > generated by the system (from data administration) to make it easier for db > people to make select queries for reports etc. One example is the > hierarchical listing of orgunits in the _orgunitstructure table. This table > is updated by the nightly scheduling job, if that is enabled, or manually > from Data Administration. So that table might be out of sync with the > orgunit table, if you do not make sure it is re-generated. > > The levels/hierarchy of orgunits are managed through the parent reference > in the organisationunit table. > > The orgunitlevel table is just to store labels for each level, e.g. used > in the level selector in GIS. > > Ola > ------ > On 14 Nov 2013 14:54, "riddy ndoma" <[email protected]> wrote: > >> It is managed from the resource table _orgunitstructure. Since according >> to the diagram you gave me the orgunitlevel table is connected only with >> the Map table >> >> >> 2013/11/14 Knut Staring <[email protected]> >> >>> One place to start is the *generated* table (resource table) called >>> _orgunitstructure >>> >>> Knut >>> >>> >>> On Thu, Nov 14, 2013 at 2:43 PM, riddy ndoma <[email protected]>wrote: >>> >>>> Hello, >>>> I am trying to explore the structure of the database administrator >>>> entant that perfect mastery of queries that the GUI does not allow dhis2, I >>>> wanted to know the table that connects organisationunit table and >>>> organitlevel table? >>>> >>>> -- >>>> Riddy NDOMA >>>> Software Developer >>>> *Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma >>>> *Twitter:* riddyndoma, *LinkedIn:* riddy ndoma >>>> *Blog:* http://riddyndoma.blogspot.com/ >>>> >>>> Vous servir est mon désire (Serving you is my desire) >>>> >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~dhis2-devs >>>> Post to : [email protected] >>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >>> >>> >>> -- >>> Knut Staring >>> Dept. of Informatics, University of Oslo >>> +4791880522 >>> http://dhis2.org >>> >> >> >> >> -- >> Riddy NDOMA >> Software Developer >> *Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma >> *Twitter:* riddyndoma, *LinkedIn:* riddy ndoma >> *Blog:* http://riddyndoma.blogspot.com/ >> >> Vous servir est mon désire (Serving you is my desire) >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
