Hi, Sorry - am preparing for some work in Swaziland so I did not see the follow up before now. But Tim is largely correct, 90% of "our" data is aggregated management data. I would not use the term "simple" about some of the querying, but the DHIS is a sort of hybrid data collection & data warehouse info system - developed for the district level but in practice used from facility up to national level. MySQL seemed a good choice - NOTE, though, that whereas we aim for DBMS independence (and platform independence - one reason for not really considering PostgreSQL up to now because it's not stable/efficient on windows) we are not MARRIED to MySQL or any other FOSS option.
If MySQL in the end don't fulfil requirements as expected, then we will seriously look into other options like MaxDB. Regards calle ----- Original Message ----- From: "Karsten Hilbert" <[EMAIL PROTECTED]> To: "openhealth-list @ minoru-development . com" <[EMAIL PROTECTED]> Sent: Tuesday, July 13, 2004 1:18 PM Subject: Re: Complete country-wide open source medical systems installation in 90 days > > > I am completely baffled as to why this makes MySQL the logical > > > FOSS option ?!? > > > > Somewhere on the MySQL web site there is a history of their product, > > which reveals that they originally built it purely for decision support > > purposes (i.e. reporting and analysis). Indeed the design and feature > > set of MySQL up to v3.x reflects this type of work, in which data is > > usually collected by other systems, and then bulk-loaded or otherwise > > assembled in batches into the decision support database. The emphasis is > > on the speed of fairly simple queries. My understanding of the Health > > (Management) Information Systems Programme with which Calle is involved > > is that it is a system which collects and aggregates summarised and unit > > record data collected by clinics, community health centres, hospitals > > and other health care facilities into a local or regional decision > > support database. Is that correct, Calle? If so, then MySQL is a good > > choice. > > Tim, thank you very much ! This makes perfect sense to me. > > Karsten > -- > GPG key ID E4071346 @ wwwkeys.pgp.net > E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 > > >
