Announcement

Collapse
No announcement yet.

Needed - ready-to-use database for HL7

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Needed - ready-to-use database for HL7

    Hello,

    I need a sollution to store incoming HL7-feeds. I'd like to use Mirth as the entrance-point, because of its flexibility and scalability, but I need a database behind. Because I'm to treat my HL7 messages and the target-store-system as closed black-boxies I would need a ready-tu-use package so that I don't have to go in details. I've been googling the net for a few hours, but I have not found any out-of-the-box database sollution. Can you recommend me something or just give a hint? I don't want to do it from scratch, I'd like to install the free database and load the HL7-store-scheme from a script. I supposed it would be the most obvious way to do it... but unfortunately I cannot find anything...

    Cheers,
    tmcc1

  • #2
    Re: Needed - ready-to-use database for HL7

    I haven't seen an HL7 schema or script. When you make one I'd be really grateful if you share it here.

    As for 'black-box' datbases you probably want to use something like Derby. Thats what Mirth uses as its own internal database and you'd never know it unless you dug around in the forums or the config files. It just works. The downside is that Derby can get really slow if you're shoving a lot of data through it.

    I don't know if its possible, or even a good idea, to piggyback off of the Derby DB in Mirth and use it for your production needs.

    You may be better off writing Mirth channels and schema-scripts for a few of the major databases, DB2, Postgres, MySQL, and SQL Server then finding out what server your customers already have installed and then just set your database and tables on their server.

    If you and your customers are willing to just let you install whatever I'd use Postgres and make your installer unpack and configure it.

    If you are able to, can you better describe what you mean by a 'black-box' install?
    Jon Bartels

    Zen is hiring!!!!
    http://consultzen.com/careers/
    Talented healthcare IT professionals wanted. Engineers to sales to management.
    Good benefits, great working environment, genuinely interesting work.

    Comment


    • #3
      Re: Needed - ready-to-use database for HL7

      Hi,

      thanks for your comments and ideas.

      With the "black-box-solution" I meant something that would be ready to use - I don't want to spend time analyzing the HL7-data model (in all its versions...) and building a database. So, recapitulating - I'd like to use some kind of a free database - as you mentioned like postgres, mysql, etc - and load on it a ready DB-schema from a SQL-script. Whereas the DB itself is not an issue, the problems beginns with the schema...

      My task is just to store the HL7-message-flow, I don't even have to understand this data at this point, just to log it. But the next step will be to respond some requests, so I cannot just store it into a file or "as it is" to the DB... I thought I can find some freeware package with the ready database - there are so many HL7-tools, but there is just nothing on this field... Many programs serve with the DB-interfaces, but where can I get the DB itself?!

      Cheers,
      tmcc1

      Comment


      • #4
        Re: Needed - ready-to-use database for HL7

        If I understand your requirement right I think you get this out-of-the-box from Mirth.

        I know Mirth comes with postgres-database.sql which could be used to create the required schema in the Postgres database. You need to change the configuration to make Mirth use the database in Postgres (and not the default Derby DB). I haven't tried this but anyone who is using Mirth with Postgres database might be able to help.

        You could then setup a channel with no filter/transformer like the File to file sample in the File Repository
        http://www.mirthproject.org/index.ph...d=26&Itemid=43

        You could set the channel to store the incoming messages and Mirth will save all the messages in the MESSAGE table (in the Mirth database in Postgres).

        Hope it helps!

        Comment


        • #5
          Re: Needed - ready-to-use database for HL7

          Following what Nazir said - it would be hard to find a data model that had the specifics for EVERY possible message type. Usually you are only after patient information, transcription data or lab results. If you need all the data in an easy to re-use and parse format, it is best to store the data as XML (transformed data in Mirth). Store the XML in the DB and you can later retrieve and parse as needed.

          -Chris
          Chris Lang

          Comment


          • #6
            Please Help

            Originally posted by tmcc1 View Post
            Hello,

            I need a sollution to store incoming HL7-feeds. I'd like to use Mirth as the entrance-point, because of its flexibility and scalability, but I need a database behind. Because I'm to treat my HL7 messages and the target-store-system as closed black-boxies I would need a ready-tu-use package so that I don't have to go in details. I've been googling the net for a few hours, but I have not found any out-of-the-box database sollution. Can you recommend me something or just give a hint? I don't want to do it from scratch, I'd like to install the free database and load the HL7-store-scheme from a script. I supposed it would be the most obvious way to do it... but unfortunately I cannot find anything...

            Cheers,
            tmcc1
            I have developed a laboratoty module..It is based on asp.net MVC framework with sql 2012 as database..Now I want my module(software)to be hl7 complaince..can you please provide me detail steps to be followed to make a product hl7 complaint...

            Like whta will be my first step in the process.
            My database is sql how i will be able to create database for hl7 etc..

            Please support..

            Regards

            Comment


            • #7
              Please help

              Originally posted by jbartels View Post
              I haven't seen an HL7 schema or script. When you make one I'd be really grateful if you share it here.

              As for 'black-box' datbases you probably want to use something like Derby. Thats what Mirth uses as its own internal database and you'd never know it unless you dug around in the forums or the config files. It just works. The downside is that Derby can get really slow if you're shoving a lot of data through it.

              I don't know if its possible, or even a good idea, to piggyback off of the Derby DB in Mirth and use it for your production needs.

              You may be better off writing Mirth channels and schema-scripts for a few of the major databases, DB2, Postgres, MySQL, and SQL Server then finding out what server your customers already have installed and then just set your database and tables on their server.

              If you and your customers are willing to just let you install whatever I'd use Postgres and make your installer unpack and configure it.

              If you are able to, can you better describe what you mean by a 'black-box' install?
              I have developed a laboratoty module..It is based on asp.net MVC framework with sql 2012 as database..Now I want my module(software)to be hl7 complaince..can you please provide me detail steps to be followed to make a product hl7 complaint...

              Like what will be my first step in the process.
              My database is sql how i will be able to create database for hl7 etc..

              Please support..

              Regards

              Comment


              • #8
                Is there a reference database schema available in DDL for any Mirth supported database for HL7 v2 and CCD?

                Thanks!

                Andrew

                Comment

                Working...
                X