[Care2002-developers] Registration Page / Admission data

2006-07-10 Thread Robert Meggle
Hello all, About the discussion in this list (-> patient registration and the big vision to get a very flexible structure in it). I want to talk about the data structure here, not about the GUI realisation part. Nearly all hospitals, counties, countries will have own ideas of storing demographi

Re: [Care2002-developers] [BLK_LIST] Registration Page / Admission data

2006-07-10 Thread Amel . Jakupovic
Hello to all, my proposal is: 1. care2x_persones must have columns that are used in all countries..PID, registration time, name, last name... 2. Every care2x installation (in other countries) must have tables care2x_persones_core, care2x_persones_croatia, care_2x_persones_italy... where prog

Re: [Care2002-developers] Registration Page / Admission data

2006-07-10 Thread Reinier
Hi Robert, In general, i think this would add a lot of flexibility to the Registration of patient, which is good. There might be some performace penalties, we'd have to see if they are manageble. The diagram does not come out very well in my mailclient. Maybe you could make a small ER or UML d

Re: [Care2002-developers] Registration Page / Admission data

2006-07-10 Thread Julio Bonis Sanz
I think is not a good idea at all to mix data-structure information with stored information. I think that the use of ontologies could be a solution in this issue. Maybe a central ontology repository stored in xml files and then each implementation/adaptation of Care2x using the sub-ontologies need

Re: [Care2002-developers] Registration Page / Admission data

2006-07-10 Thread Robert Meggle
Hello Reinier and Amel, Yes, maybe we'll getting some performance penalties. Maybe. My experiences about these table structure is: When you keep care about the primary key it will not affect too much the query speed, that will not be the issue. I've tested such kind of table couple of times but th

Re: [Care2002-developers] Registration Page / Admission data

2006-07-10 Thread Robert Meggle
Hello Julio, The question is using OWL instead of having all data stored in mysql? OWL is might be a good idea, but I have some doubts that this can work here without starting a new project from the scratch... I have just read something about OWL but have no experiences about that. Robert > ---

Re: [Care2002-developers] Registration Page / Admission data

2006-07-10 Thread Kaloyan Raev
Hello, Robert, your suggestion adds great flexibility to the data structure, but unfortunately this way the db schema loses all logic of the data and this has to be transferred to the php code. I don't like such approach, because in my opinion the db schema should represent the model of the data.