dhis2-devs team mailing list archive

[Murod Latifov <mlatifov@xxxxxxxxx>]

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 <olati@xxxxxxxxxx>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" <riddyndoma@xxxxxxxxx> 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 <knutst@xxxxxxxxx>
>>
>>> One place to start is the *generated* table (resource table) called
>>> _orgunitstructure
>>>
>>> Knut
>>>
>>>
>>> On Thu, Nov 14, 2013 at 2:43 PM, riddy ndoma <riddyndoma@xxxxxxxxx>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     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>> 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     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>