Re: xplmedianet database

[Tom Van den Panhuyzen <tomvdp@xxxxxxxxx>]

Hi Tony,

How complex are those queries ?  How does your relational model look
like ?  Maybe you need to de-normalize a bit to simplify the queries.
Or pre-aggregrate some data.
You may end up with 2 models that co-exist: one that is best for the
feeding of the data (track scanning etc) and one that is best for
answering queries that select data.  Moving data from the first to the
second is done by a seperate process (called at the end of track
scanning?).

I am not sure if it is clear what I am trying to say here... :-/

Tom




On Thu, 17 Mar 2005 08:19:12 -0000, Tony Tofts <tony@xxxxxxx> wrote:
> > From a lurker on this board.
>
> Welcome Neil :-)
>
> > Compatibility with mysql should be an option as I think mysql
> > will be a powerful player in the future, as it the open
> > source database.
> >
> > Even if other people are using different protocols for
> > control and general automation they will still be able to get
> > involved with an xpl application because they have a remote
> > or local database in common.
> >
> > Just a thought.
>
> Makes sense
>
> (oops, nearly missed off the 's' from makes! Would have put a totally
> different meaning to my reply!)
>
> Regards
> Tony
>
>
>
> xPL Links: http://www.xplproject.org.uk http://www.xplhal.com
> http://www.xpl.myby.co.uk
> To Post a Message: ukha_xpl@xxxxxxx
> To Subscribe:  ukha_xpl-subscribe@xxxxxxx
> To Unsubscribe:  ukha_xpl-unsubscribe@xxxxxxx
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
> ________________________________
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/ukha_xpl/
>
> To unsubscribe from this group, send an email to:
> ukha_xpl-unsubscribe@xxxxxxx
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


xPL Links: http://www.xplproject.org.uk http://www.xplhal.com http://www.xpl.myby.co.uk
To Post a Message: ukha_xpl@xxxxxxx
To Subscribe:  ukha_xpl-subscribe@xxxxxxx
To Unsubscribe:  ukha_xpl-unsubscribe@xxxxxxx