Results 1 to 13 of 13

Thread: Medical Database Design

  1. #1
    Member
    Real Name
    Alpha User
    Join Date
    Aug 2008
    Posts
    4

    Default Medical Database Design

    I'm currently designing a medical records application and have some questions as to how to store large amounts of data (physical exam, for example) in a table. The program also needs to handle intra-office communications and communications with patients via a portal so I'm unsure how to structure this in the backend table(s).

    I'm using SQL Server 2005 and would like to get this done before utilizing Alpha to build the interface.

    Thanks.

  2. #2
    "Certified" Alphaholic NoeticCC's Avatar
    Real Name
    Andrea Gill
    Join Date
    Nov 2007
    Location
    Holmfirth, West Yorkshire, UK
    Posts
    2,039

    Default Re: Medical Database Design

    Quote Originally Posted by washim View Post
    I'm currently designing a medical records application and have some questions as to how to store large amounts of data (physical exam, for example) in a table. The program also needs to handle intra-office communications and communications with patients via a portal so I'm unsure how to structure this in the backend table(s).

    I'm using SQL Server 2005 and would like to get this done before utilizing Alpha to build the interface.

    Thanks.
    Try some of the sample apps in Alpha, they are dbf tables but the structure might help you make up your mind...

  3. #3
    Member DaveM's Avatar
    Real Name
    David Mason
    Join Date
    Jul 2000
    Location
    Hudson, FL
    Posts
    4,419

    Default Re: Medical Database Design

    Kirk,

    Welcome to Alpha!

    May I suggest you post this in the appropriate forum relating to your version of a5. You may get a lot more responses.

    One of the users on here has developed a whole system for a hospital and could certainly be of help. Just can't remember which one.

    A few more have done some doctors ofice software and related.


    .
    Dave Mason
    car_man46@yahoo.com

    The one who thinks outside the box(cheats) the most wins the race. Ask any racer.

  4. #4
    Member
    Real Name
    Omar Garcia
    Join Date
    Jun 2006
    Location
    Alamo, Texas
    Posts
    540

    Default Re: Medical Database Design

    Quote Originally Posted by washim View Post
    I'm currently designing a medical records application and have some questions as to how to store large amounts of data (physical exam, for example) in a table. The program also needs to handle intra-office communications and communications with patients via a portal so I'm unsure how to structure this in the backend table(s).

    I'm using SQL Server 2005 and would like to get this done before utilizing Alpha to build the interface.

    Thanks.
    Storing text should not be an issue; Images will be. Some vendors choose to "link" to an image and others put binary data into the table. Some of this is for CCHIT certification and other is just for security.

    You will be using several tables that will relate/link. You're probably better off starting on v9 as it affords better tools for connecting/updating sql engines.

    You will also need to be familiar with the different column types of your sql backend so as to determine the best type for storing "chunks" of data; you'll also need to store formatting codes for say underlining; bold, etc.
    Last edited by omagarc; 09-01-2008 at 10:08 PM.

  5. #5
    Member
    Real Name
    Alpha User
    Join Date
    Aug 2008
    Posts
    4

    Default Re: Medical Database Design

    Thanks guys.

    What I really need is an ERD showing how one would store elements of an encounter. I know the components but exactly how to store them in tables is the question.

    My rationale for using SQL Server is that it will allow future development with whatever front end I decide to use if ultimately Alpha Five does not accomplish my goals. From what I've seen, however, I don't think that will be the case.

    I already know how I want the interface to function. How this is represented in the back-end is currently my sticking point.

  6. #6
    Member
    Real Name
    Alpha User
    Join Date
    Aug 2008
    Posts
    4

    Default Re: Medical Database Design

    Also, would one of you be amenable to a private e-mail whereby I show you the specific problem I'm having? Thanks.

  7. #7
    Member DaveM's Avatar
    Real Name
    David Mason
    Join Date
    Jul 2000
    Location
    Hudson, FL
    Posts
    4,419

    Default Re: Medical Database Design

    First:

    What version of Alphga are you using? If you have a specific problem in how to accomplish it, you would do much better to post it in the forum for the product you are using. It will get much more help in general.

    Once you know what your user screens should look like, the rest is somewhat easier. It just depends on what you want it to do.

    I do not mind if you private me or email me at car_man46@yahoo.com. You will be limiting your available knowledge this way, because none of us have as much knowledge as all combined. There are a bunch of people on here that are better versed on sql than I am and there are also a bunch on here better in other areas.

    There are some basics to this RAD that cn be very helpful and if several people join in, the basics will get easier for you even if they disagree.

    .
    Dave Mason
    car_man46@yahoo.com

    The one who thinks outside the box(cheats) the most wins the race. Ask any racer.

  8. #8
    Member
    Real Name
    Roman Rapido
    Join Date
    Nov 2011
    Posts
    103

    Default Re: Medical Database Design

    Can someone show a complete dbf tables designed for a small/medium sized hospital.I'l try to build the interface based on the tables.e.g Patient dbf, Inpatient dbf,Outpatient dbf, Diagnosis.db etcThanks!

  9. #9
    Member
    Real Name
    Alpha User
    Join Date
    Aug 2008
    Posts
    4

    Default Re: Medical Database Design

    I have since paid a group to develop this software for me given lack of time to devote to the project. I still have the Alpha software that I've never used. If anyone is interested in purchasing at a significantly reduced rate please let me know.

  10. #10
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    22,907

    Default Re: Medical Database Design

    Roman,

    You might find something to work with, or at least get started with, at the following web site:

    http://www.databaseanswers.org/data_models/index.htm

  11. #11
    Member
    Real Name
    Roman Rapido
    Join Date
    Nov 2011
    Posts
    103

    Default Re: Medical Database Design

    Thank you so much for this very useful info.

  12. #12
    Moderator Peter.Greulich's Avatar
    Real Name
    Peter Greulich
    Join Date
    Apr 2000
    Location
    Boston, MA
    Posts
    10,578

    Default Re: Medical Database Design

    Quote Originally Posted by Tom Cone Jr View Post
    Roman,

    You might find something to work with, or at least get started with, at the following web site:
    Tom,

    The page you are referencing apparently contains malware. BEWARE!

  13. #13
    Member
    Real Name
    Roman Rapido
    Join Date
    Nov 2011
    Posts
    103

    Default Re: Medical Database Design

    Oh no, I'm so sorry, the first time i visited the site was Okey, but now i tried to open but it really informed me that it is an attack site.Maybe the admins can delete my post, I can't edit it. Thank you!

Similar Threads

  1. Database design issue
    By mitch in forum Database Design
    Replies: 3
    Last Post: 05-05-2008, 09:29 AM
  2. New database design
    By Marcel Kollenaar in forum Database Design
    Replies: 1
    Last Post: 04-19-2008, 12:36 AM
  3. Database design - Form Design
    By Larpup in forum Alpha Five Version 8
    Replies: 2
    Last Post: 06-11-2007, 11:45 AM
  4. Database Design Guidance
    By Graham Wickens in forum Alpha Five Version 6
    Replies: 2
    Last Post: 12-10-2005, 07:12 AM
  5. Database design question
    By Ronald Anusiewicz in forum Alpha Five Version 5
    Replies: 10
    Last Post: 09-02-2003, 01:04 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

The Reviews Are In...

It just is revolutionary and reminds me of VB and how it changed the world.
quote Robert Scoble, Scobleizer

...Version 10 is a turning point on how developers will be writing applications for the web
quote Alan Ashendorf, Lets Talk Computers

Alpha Five version 10... this version is really a break-through for web developers.
quote The Wall Street Journal, Digital Network

Our Professional Services Division

Training and Mentoring - Alpha Software's Professional Services division is here to help. We offer mentoring and training services, for those who need guidance or advice building their own applications.

Development Services - Need someone to build your application? We'll get the job done right. We have an in-house team of Alpha Five developers and a network of carefully selected artists, designers and IT professionals ready to handle projects of any size. Read more .

submit a project request

Alpha Five Awards & Press
awards
Products Store Support Services About Cart Site Map Resources Home
© Copyright 2000-2011 Alpha Software, Inc. 70 Blanchard Road Burlington, MA 01803 781.229.4500
more