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 there was not a measurable time penalty about the query speed. Instead all 3rd normal form of databases would rise up speed penalties and this is not the case.
More difficulty is the kind of queries you will need to answer a simple question. For the moment you just need one key and you'll get the correct row in one line for that result. That's quits simple and very easy to understand. But if you have a kind of hierarchical tree, then you maybe need one complex query or maybe two of them (depending what you want to know). Other much more relevant point is that we will loose all kind of column data types, the content is represented by a global column. Maybe we should think about a combination of my idea and the idea of Amel. Then we could keep most of the existing table structure. Other issue is that for the moment the PID is a primary master key and the database keeps care that this key is unique. For my idea there must be a programmed php class taking care about and this could be risky. Maybe we should follow the idea of Amel. Any other ideas? Reinier, I want to avoid giving attachments to the mailing list when there is an alternative way in a simple text mode. It would fill up the inboxes of that developers using quite poor bandwidth for internet... Sorry that you had some troubles by reading it. (I gave it as plain text and used spaces instead of TAB commands - tested it by outlook and firefox and looks well in booth email clients). So sorry about it but in spite of that I think you got my point. Robert > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] [mailto:care2002- > [EMAIL PROTECTED] Im Auftrag von Reinier > Gesendet: Montag, 10. Juli 2006 12:46 > An: care2002-developers@lists.sourceforge.net > Betreff: Re: [Care2002-developers] Registration Page / Admission data > > 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 diagram with the tables that you propose and the > links between them in a graphic program? > > > rgds, > > reinier > > > On Monday 10 July 2006 12:19, Robert Meggle wrote: > > 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 > > demographic data. > > > > What is the situation right now? The situation is that every programmer > what > > have the aim of integration taking the table care_person and add their > own > > columns. Or even misusing given ones for their own use. > > For a wider perspective I will suggest an idea. An idea of having a > better > > data structure... Please let's talk about it and give your comments to > it: > > > > What is the requirement for a patient Table: > > -> The PID must be unique (is now realized of having an auto-increment > > primary key column) > > -> The date-field of the creation date (date_reg) > > -> Optional fields... First name, last name, phone number, street, PO- > Box, > > ZIP.... > > > > What do you think about having now following structure? > > > > care_person: > > ID | date_reg | parent | value | data > > 1 | 1998-01-01 00:00:00 | -1 | PID | 1 > > 2 | NULL | 1 | firstname | test > > 3 | NULL | 1 | lastname | nobody > > .. | ... | ... | ... | ... > > 10 | 1998-01-01 00:00:00 | -1 | PID | 1 > > 11 | NULL | 10 | firstname | test person 2 > > 12 | NULL | 10 | lastname | nobody 2 > > ... > > > > > > -> The content (firstname, lastname ...) will be described in an > > additionally table. > > > > Basic idea of this hierarchical structure: A non auto increment- > identifier > > (column: PID) will point to the primary key (column: ID) of the table. > If > > the parent has the value -1 it will describe the root. If you want all > > datas of this value pid 1 then you have to select this table to > > ID=parent. > > The last table it is not clear for me (for the moment). Idea is that > every > > adaptation can insert there the possible values of the content table. > > Additionally to that even the attribute value like checkbox, input > > field, select box->and their possible values of it (maybe). > > > > This is quite an idea. Let me know what you think about. This change > will > > affect nearly all kind of modules of care2x (my hope: basically the > > class_core -> but it is quite a lot of work to be done when it should > work!) > > > > What I do not like in my idea are following issues: > > -> The primary key-value points to an key (It´s might be okay, but:) > > -> the data column should have a global data type and I do not like that > > idea. > > > > Any suggestions or ideas? > > Robert > > > > > > > > > > ------------------------------------------------------------------------ > - > > Using Tomcat but need to do more? Need to support web services, > security? > > Get stuff done quickly with pre-integrated technology to make your job > easier > > Download IBM WebSphere Application Server v.1.0.1 based on Apache > Geronimo > > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > > _______________________________________________ > > Care2002-developers mailing list > > Care2002-developers@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > > > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job > easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Care2002-developers mailing list > Care2002-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/care2002-developers ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
