[Gpephone-devel] Which database is better to store tree structure?

[Florian Boor]

Hi,

YANG Lin RD-ILAB-PEK schrieb:
> A calendar is a collection of components which can be events, 
> tasks, journal entries or alarms.A component is a collection of 
> properties.More than 40 types of properties are defined.
> There're 7 value types for the properties. Some of the property
> may have multiple values. Properties may have one or more
> parameters. There're 20 types of parameters.
> 

Do we actually have that many different value types? Currently we have five
fundamental data types in SQL, so it should be possible to reduce the amount of
   value types to these five. The only case where this would not make sense if
if we have fields where it is useful to entrust the data validation to the database.
Me might want to take a look at the libeventdb implementation in GPE which needs
to do provide the same.

> What do you mean by single table?
A single table for the data covering all data types.

Greetings

Florian

-- 
The dream of yesterday                  Florian Boor
is the hope of today                    Tel: +49 271-771091-14
and the reality of tomorrow.            Fax: +49 271-771091-19
[Robert Hutchings Goddard, 1904]        florian.boor at kernelconcepts.de

1D78 2D4D 6C53 1CA4 5588  D07B A8E7 940C 25B7 9A76