Data Portability

  • Comments posted to this topic are about the item Data Portability

  • Steve thanks for a great idea ... My mother-in-law has a medical bracelet which appears to be nothing more than be a thumb nail with a form and program which can be run on any computer with Windows.

    The completed form can be saved on the computer with which it was used during the initial load and of course in the bracelet. Now to learn how to extract that to a database to track changes would be a great benefit , to her and the remainder of the family. So do not be surprised to see a forum posting if I require assistance.

    By the way this is NOT an advertisement, but the bracelets (Care Medical History Bracelet) are available from almost any Walgreens drug store, or from their web site and others may be interested in:

    1. Accepting the challenge of downloading the data to a SQL DB.

    2. Purchasing the same for their family members.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • bitbucket-25253 (10/9/2010)


    Steve thanks for a great idea ... My mother-in-law has a medical bracelet which appears to be nothing more than be a thumb nail with a form and program which can be run on any computer with Windows.

    The completed form can be saved on the computer with which it was used during the initial load and of course in the bracelet. Now to learn how to extract that to a database to track changes would be a great benefit , to her and the remainder of the family. So do not be surprised to see a forum posting if I require assistance.

    By the way this is NOT an advertisement, but the bracelets (Care Medical History Bracelet) are available from almost any Walgreens drug store, or from their web site and others may be interested in:

    1. Accepting the challenge of downloading the data to a SQL DB.

    2. Purchasing the same for their family members.

    I sure hope that stuff is encrypted or those folks stand to get sued for a giant breach of HIPAA. And - even IF the data itself is encrypted - it's not much fo a security measure if the actual program to read it is on the very same thumb drive.

    As much as I love portability, you can't sacrifice confidentiality or skimp on security in those cases.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • bitbucket-25253 (10/9/2010)


    Steve thanks for a great idea ... My mother-in-law has a medical bracelet which appears to be nothing more than be a thumb nail with a form and program which can be run on any computer with Windows.

    The completed form can be saved on the computer with which it was used during the initial load and of course in the bracelet. Now to learn how to extract that to a database to track changes would be a great benefit , to her and the remainder of the family. So do not be surprised to see a forum posting if I require assistance.

    By the way this is NOT an advertisement, but the bracelets (Care Medical History Bracelet) are available from almost any Walgreens drug store, or from their web site and others may be interested in:

    1. Accepting the challenge of downloading the data to a SQL DB.

    2. Purchasing the same for their family members.

    Ummm.... I happen to know that you're about 3 days older than dirt, Ron. 😛 How old is your mother-in-law and can I get some of whatever it is that she's on? :hehe: Or did you marry someone a whole lot younger than you?

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Actually, HIPAA only applies to medical records maintained by healthcare providers; but this device is *not* encrypted; making me extremely wary, since it also has personal information (name, address, etc.) stored in a 'read only' HTML file.

    No way would I trust this device.

  • Matt Miller (#4)

    I sure hope that stuff is encrypted or those folks stand to get sued for a giant breach of HIPAA. And - even IF the data itself is encrypted - it's not much fo a security measure if the actual program to read it is on the very same thumb drive.

    The device is meant to be read by medical care providers. For example a person wearing the device is in a automobile accident, removed unconscious from the vehicle, rushed to an Emergency Room where the medical information will then be available to appropriate personnel. Encryption/inability to read the data would be counter productive to saving that individuals life.

    My daughter is an ER nurse, and for instance, you would be surprised at the list of medications that should NOT be given to diabetics, since doing so would worsen their medical situation.

    Or being aware that a person has a heart condition and is taking nitroglycerine to alleviate a fluttering heart beat.

    All of which allows ER personnel to properly treat and perhaps save a life.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Jeff

    Ummm.... I happen to know that you're about 3 days older than dirt, Ron. How old is your mother-in-law and can I get some of whatever it is that she's on? Or did you marry someone a whole lot younger than you?

    My mother-in-law is in her late 80s. She owes her longevity to leading a clean healthy life. Born in a "holler" in West Virginia, daughter of a coal miner, and married to a coal miner (Unfortunatly now a widow). It is not "what she is on" as much as it is what she does NOT consume.

    Me married a wonderfu gal, some 16 years my junior.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • ldsudduth1

    Actually, HIPAA only applies to medical records maintained by healthcare providers; but this device is *not* encrypted; making me extremely wary, since it also has personal information (name, address, etc.) stored in a 'read only' HTML file.

    So you would rather be in my auto accident situation, unconscious in an Emergency Room, and NOT have your relatives notified. The choice is yours of course, but think might not your wife want to be at your side.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Its a bit like working with fractions - find the lowest common denominator and work with that. In the case of data, its often the csv file, and its just the format of the file that needs to be worked on. That being said though, how do you work with binary information?

    I'm specifically thinking of the .ged format for genealogical information - which is a csv file. Its great for the basic textual information, and for holding the hierarchical/relational data, but you lose the media files (pictures, documents etc).

    I suppose, for the example I'm thinking of, you could have a 'reference' file and just hold the reference to another media file (.jpg) for a person. I wonder why nobody has thought of this yet....

  • did you see what is on this? all you need to do is plug it into any USB port and instantly you have name..address..date of birth..social security number---every piece of information that can be used for identity theft.--or worse. The big issue is that this is *not* encrypted---it's not just your name and your medical information that is being seen.

  • Are we talking about data portability in realtime, or transferring data from system (a) to system (b) - if the latter, then dump the file in whatever format is the LCD, then encrypt it, then move it to system (b), decrypt and load.

    Rocket Science....

  • I think that the medical device relies on physical security, which is OK. I know I have an ICE (In case of emergency) entry on my phone so that first responders can contact my wife/home.

    I'd think that you do want this in an easy format, and HTML is pretty good right now. I'd worry that security on some machines might be an issue, but I suppose a nice text file, and maybe CSV would make sense for emergencies.

  • ldsudduth1 (10/10/2010)


    Actually, HIPAA only applies to medical records maintained by healthcare providers; but this device is *not* encrypted; making me extremely wary, since it also has personal information (name, address, etc.) stored in a 'read only' HTML file.

    No way would I trust this device.

    The idea is that this data stays updated, which unfortunately entails that the data on there would be updated by those healthcare professioanls performing the care. That is where it started falling apart, since in most cases, the local facility professionals will be disallowed from touching what is on the USB drive (since that constitutes an exachange of PHI from care provided at that facility without flowing through the facility's HIPAA process.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • Steve - I read over the facebook article you mentioned, and while I did see the parts about being able to TRANSFER your data from Facebook to other sites, there wasn't much in the way of assurances as to what happens to your data when you choose to remove your account from facebook. Meaning - there were no guarantees that Facebook would not maintain or persist your data for wahteevr purpose they choose well beyond your acocunt's timely or untimley demise.

    I'd be curious to find out what exactly they do. I've had bad experiences with other online systems and their TOS rules. One particularly obnoxious TOS I've encountered read something along the lines of: you own your own content and the content you generate while in this virtual world, BUT we get to keep a copy of anything you generate and possibly reuse it should you ever decide to leave. Meaning - they were under no obligation to remove your content and could hold onto copies of your stuff essentially forever.

    It's definitely good that they've allowed users to have control oevr moving their data around, but I think the flipside would be even more positive (i.e. the ability to control what gets KEPT on you).

    I've shied away from Facebook for years because of the confidentiality breaches they continuously seem to have, so perhaps it just wasn't mentioned.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • I don't know how long they persist data, or if you can completely remove it. I have had friends disable their accounts, and all their data disappears from viewing, but if they re-enable their account in a month, the data is there.

    I was surprised by this since there are some distributed systems being worked on that will allow the social sharing, but not having all data held by one company.

    It's something that I'm not sure how to handle. We retain all posting data here at SQLServerCental. We don't allow someone (typically) to delete all their posts on these forums as that would leave holes, or potentially ruin lots of the value that these discussions give us.

    My caution is that if you post something online, be it Facebook or elsewhere, you consider it to be in the public domain. So post things that you deem acceptable. The things you would say to friends or in a public place, the information that you would disclose in the real world to people you meet.

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply