By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
Health Works CollectiveHealth Works Collective
  • Health
    • Mental Health
    Health
    Healthcare organizations are operating on slimmer profit margins than ever. One report in August showed that they are even lower than the beginning of the…
    Show More
    Top News
    stress management for healthcare workers
    3 Tips For Healthcare Professionals: How To Stay Beautiful, Healthy, and Happy
    November 2, 2021
    importance of relaxing on the weekend for your health
    Importance of Relaxing During the Weekend for Optimal Health
    March 25, 2022
    LASIK Eye Surgery
    What Is LASIK Eye Surgery?
    May 16, 2022
    Latest News
    6 Essential Strategies for Improving Your Medical Practice
    January 25, 2023
    Staying Positive While Living with Mesothelioma
    January 24, 2023
    The Many Health Benefits of Being Outdoors
    January 17, 2023
    How to Assess a Safe Placement of a Nasogastric or Nasoenteric Tube and Its Complications
    January 19, 2023
  • Policy and Law
    • Global Healthcare
    • Medical Ethics
    Policy and Law
    Get the latest updates about Insurance policies and Laws in the Healthcare industry for different geographical locations.
    Show More
    Top News
    Massachusetts Gets Ready to Tame HealthCare Costs
    April 14, 2013
    ObamaCare and Tax Evasion
    August 14, 2013
    Maslow
    Improving Clinical Outcomes by Addressing Social and Basic Needs
    April 17, 2014
    Latest News
    Simplifying the Genetic Testing Process: How At-Home Kits are Changing the Game
    January 25, 2023
    9 Hospitals That Have Introduced Green Initiatives
    January 25, 2023
    Why a Health Retreat Can Be the Best Medicine
    January 12, 2023
    Best Money-Saving Tips for Health Managers
    January 12, 2023
  • Medical Innovations
  • News
  • Wellness
  • Tech
Search
© 2023 HealthWorks Collective. All Rights Reserved.
Reading: Consider MySQL ‘Archive’ Storage Engine to Store Large Amounts of Med Device Structured or Waveform Data
Share
Sign In
Notification Show More
Latest News
Personal Injury Healing Tips and Strategies
Personal Injury Healing Tips and Strategies
Health
ABA therapist
Everything You Need to Know About Applied Behavior Analysis
Health
Small Lifestyle Changes That Can Have A Big Impact On Your Well-Being
lifestyle Wellness
The Future Of Medicine: How Immunotherapy Is Saving Lives
The Future Of Medicine: How Immunotherapy Is Saving Lives
Technology
medical practice and technology advancement
6 Essential Strategies for Improving Your Medical Practice
Technology
Aa
Health Works CollectiveHealth Works Collective
Aa
Search
Have an existing account? Sign In
Follow US
  • About
  • Contact
  • Privacy
© 2023 HealthWorks Collective. All Rights Reserved.
Health Works Collective > eHealth > Consider MySQL ‘Archive’ Storage Engine to Store Large Amounts of Med Device Structured or Waveform Data
eHealth

Consider MySQL ‘Archive’ Storage Engine to Store Large Amounts of Med Device Structured or Waveform Data

ShahidShah
Last updated: 2017/08/24 at 12:48 PM
ShahidShah
Share
4 Min Read
SHARE

I’ve been working on med device integrations for the many years now and one of the most common questions that arises when doing those integrations is “what’s the best way to save sensor waveform and analog to digital values?” Given the complexity of medical devices, there’s no single or simple answer but one approach that’s worked well for me in the past is to assume that whatever the data is, when it comes into digital format, it’s likely structured in some manner. If so, putting it into a database probably makes more sense in many cases than just dropping it into flat files (which is a common and very reasonable approach). If you want to store your data easily and without much hassle, give (free) open source MySQL a shot. Most of us who have been in the medical device world for even a little while tend to think that SQL is too heavyweight, but MySQL supports various storage engines that have different behaviors and storage goals. For instance, the standard InnoDB storage engine is an ACID compliant engine that allows full CRUD operations and is actually good when data integrity is crucial. Another storage engine is the ‘Archive’ engine — this is very useful when you want to just insert compressed, structured, data into the database and you want to pull data out at some point through a SQL SELECT clause. Archive engines do not have the ability to update or delete data but that’s OK for most of our med device data storage needs where we want continuously store and monitor data coming in through the system but won’t be modifying it. To learn more about MySQL’s Archive engine, check out the documentation on the MySQL site. Here is some relevant detail from that page that might save you some reading time:

Storage: Rows are compressed as they are inserted. The ARCHIVE engine uses zlib lossless data compression (see http://www.zlib.net/). There are several types of insertions that are used: An INSERT statement just pushes rows into a compression buffer, and that buffer flushes as necessary. The insertion into the buffer is protected by a lock. A SELECT forces a flush to occur, unless the only insertions that have come in were INSERT DELAYED (those flush as necessary). A bulk insert is visible only after it completes, unless other inserts occur at the same time, in which case it can be seen partially. A SELECT never causes a flush of a bulk insert unless a normal insert occurs while it is loading.
Retrieval: On retrieval, rows are uncompressed on demand; there is no row cache. A SELECT operation performs a complete table scan: When a SELECT occurs, it finds out how many rows are currently available and reads that number of rows. SELECT is performed as a consistent read. Note that lots of SELECT statements during insertion can deteriorate the compression, unless only bulk or delayed inserts are used. To achieve better compression, you can use OPTIMIZE TABLE or REPAIR TABLE. The number of rows in ARCHIVE tables reported by SHOW TABLE STATUS is always accurate.

TAGGED: HIT

Sign Up For Daily Newsletter

Be keep up! Get the latest breaking news delivered straight to your inbox.
By signing up, you agree to our Terms of Use and acknowledge the data practices in our Privacy Policy. You may unsubscribe at any time.
ShahidShah March 3, 2011
Share this Article
Facebook Twitter Copy Link Print
Share
Previous Article Largest One-YearJump in Health Spending
Next Article How the Ipad is Changing Medicine-Apple Endorsement from Dr. Halamka At Harvard Medical With Real Time Applications and User Information

Stay Connected

1.5k Followers Like
4.5k Followers Follow
2.8k Followers Pin
136k Subscribers Subscribe

Latest News

Personal Injury Healing Tips and Strategies
Personal Injury Healing Tips and Strategies
Health January 28, 2023
ABA therapist
Everything You Need to Know About Applied Behavior Analysis
Health January 26, 2023
Small Lifestyle Changes That Can Have A Big Impact On Your Well-Being
lifestyle Wellness January 26, 2023
The Future Of Medicine: How Immunotherapy Is Saving Lives
The Future Of Medicine: How Immunotherapy Is Saving Lives
Technology January 26, 2023

You Might also Like

healthcare video marketing
MarketingSocial Media

How to Maintain a Successful YouTube Channel as a Healthcare Organization: Advantages of Video Marketing for your Medical Practice

November 9, 2022
Electronic Health Records
BusinesseHealthHospital AdministrationMedical Records

Top Benefits of Electronic Health Records for Psychiatrists and Psychologists

August 15, 2022
tips to design a health app
eHealth

How To Improve Patient Access Metrics

April 5, 2022
social media addiction is harming teenage mental health
eHealthMental HealthSocial Media

5 Ways Social Media Affects Teen Mental Health

April 4, 2022
//

We influence million of users and is the most authentic source of information on healthcare business and technology news.

Quick Links

  • About
  • Contact
  • Privacy
Subscribe

Subscribe to our newsletter to get our newest articles instantly!

Follow US

© 2008-2023 HealthWorks Collective. All Rights Reserved.

Removed from reading list

Undo
Welcome Back!

Sign in to your account

Lost your password?