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

[YANG Lin RD-ILAB-PEK]

Hi, 

>-----Original Message-----
>From: Florian Boor [mailto:florian.boor at kernelconcepts.de] 
>
>it depends a little bit on the total amount of data and on how 
>many different
>data types you expect.

Yes, I agree.
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.

> I suppose a single table would work 

What do you mean by single table?

>pretty well for this
>purpose.
>

Following is a example of a event component: 
     BEGIN:VEVENT
     DTSTAMP:19980309T231000Z
     UID:guid-1.host1.com
     ORGANIZER;ROLE=CHAIR:MAILTO:mrbig at host.com
     ATTENDEE;RSVP=TRUE;ROLE=REQ-PARTICIPANT;CUTYPE=GROUP:
      MAILTO:employee-A at host.com
     DESCRIPTION:Project XYZ Review Meeting
     CATEGORIES:MEETING
     CLASS:PUBLIC
     CREATED:19980309T130000Z
     SUMMARY:XYZ Project Review
     DTSTART;TZID=US-Eastern:19980312T083000
     DTEND;TZID=US-Eastern:19980312T093000
     LOCATION:1CP Conference Room 4350
     END:VEVENT


lin