I am totally amazed at how a few people's search for a
standard way to build SQL tables for an open source EMR has sparked
a wildfire :)
Again, dear researchers, you have to reach out to the practitioners in the
list because they are the ones who will give life to your models.
Unfortunately, (okay, I speak only for myself), the level of discussion at
the researcher-level is way, way beyond my limited knowledge in the field,
and yet, I realize that we have to work together. I am sure many of the
other practitioners in the list speak different languages, but I speak SQL
and that's is where my bias is and that is why I insist on it in previous
posts.
So again:
The list is looking for a model for an OpenEMR kernel.
There are now five models on the block: GEHR, HL7 3, VistA, CEN, and
CORBAmed.
We won't go into which is better or which is worse (and why). If there was
a definite answer to this, then there would be only one model (the best).
But now there are five which means there is no consensus as of yet.
Knowing this, I ask again:
Will the proponents of each of the models please...
show us the bridge that links their models to an actual EMR
implementation, ie, how do we use your model to build a simple primary
care record system...
....in SQL speak, how do we build standard SQL tables from your model?
I believe that the model which can give the most user-friendly (also
practitioner-friendly) response to the question deserves our utmost
attention...
Focus, focus, focus...we can do this...
Note researchers: the question is not "why your model is better
than another". It's how to migrate from your model to the implementation.
It is not necessary to reference an external model in your response. We
also have enough of the jargon in past posts. We now need operational
instructions. It is best to hear directly from you since the models are in
your domain.
Thank you.
alvin
Alvin B. Marcelo, MD
National Library of Medicine
Bethesda, Maryland
> first I think our threads could use some refreshment in subject lines.
> Second, I make the observation that there are a bunch of folks who wear
> a particular orgnizational affiliation hat and who try to pull the
> poor hungry programmers onto their railroad track. I am honest, I am
> one of the organizational folks, I'm lobbying for parts of HL7. David
> is lobbying for CORBAmed. I think, however, that we organizationals
> should better be more silent than to mess the progress of the hungry
> programmers up by our battles.
>
> If Alvin is asking for SQL tables, he has all the right asking this,
> and the question should not be put off by saying that it would violate
> some n-tier principle. This entire discussion is screwed up on a layer
> where everyone seems to work with presumptions, mostly prejudical, kind
> of buzzword-presumptions, that may be well understood myths in each organization
> but are not at all truths so general that they would not
> deserve the critique of some humble practical workers.