Dean Yergens
  • Home
    • Calendar
    • Resume
    • Publications
  • Software
    • Synthesis >
      • Current Version
      • Synthesis Tutorials
    • RMail
    • Meta Data Repository
    • Patient-X
    • WebReports
    • HealthSim Calendar Gadget
    • MT4Health
    • Amazon ISBN 2 BibTex
    • ForestRanger
    • Alberta Sepsis Network
    • R Code
  • Global Health
    • Software
    • Philippines
    • Malawi
    • Zambia
    • Kenya
    • World Health Organization
    • Verbal Autopsy
    • Space Medicine
  • Computer Science
    • Robotics
    • Data Management
    • GPU Parallel Processing
    • Machine Learning
    • Visualization
    • Operating Systems
    • Programming Languages
    • Software Engineering
    • Simulations
    • Computer Configurations
    • Single Board Computers
    • IEEE RSS Feed
    • Glossary
    • Commercial Software Blog
  • Health Sciences
    • AI Walkthrough
    • Canadian Health System Books
    • Microsimulation
    • Graph Databases (Neo4J)
    • Administrative Data
    • CCHS Overview
    • Literature Reviews >
      • Newspaper Literature Reviews
      • Open Access
      • Statistics Utilization
      • Topic Modeling
      • Utilizing R for Literature Reviews
    • Statistics >
      • RMedicine (RClub) >
        • Blog
        • Forums
    • Health Informatics >
      • DataMergeR
      • Dashboards
      • Academic Software Development
      • Critical Care Systems
      • Patient Flow >
        • Patient Flow Simulations
        • Systems
      • HL7
    • Online Courses
    • Public Health Documentaries
    • Summer Institutes
    • WHO Internships
    • Conferences
  • Collection
    • Hardware
    • Software
    • Looking for
    • Analog Computers
    • Old Monitor Projects
    • Computer Books and Software
    • 3D Models
    • FrostByte
    • New Devices Vintage Computers
    • Floppy Music
    • History of Workstations
  • Other
    • Future Projects
    • Home Automation
    • Animatronics
    • Raspberry Pi
    • Deaner.AI
    • CANMAR
    • EpiComics
    • The Art of Deaner
    • LED Cube 8x8x8
    • Ambient Devices
    • EasyButton
    • African Art
    • Movie Posters
    • Wildlife Photography
    • Coursera
    • Neat Companies
  • Blog

Relational Databases

The database that I use for most of our data management needs is Postgres. 

However, I have worked with multiple relation databases such as Oracle, Microsoft SQLServer, Microsoft Access and MySQL and developed several programs to improve how novice users can work with these various databases.  Software applications include Patient-X which acts a user-friendly ETL (Extract, Transform, Load) application for transferring data between different relational databases and Meta data Repository (MDR) which helps in enhanced database documentation (including database content).

Document Indexing

We have used the Apache Lucene database for our management of text documents (medical references and PDF documents).  Lucene is an open source project for helping in the indexing and retrieval of text information.

Software Development

Meta Data Repository

A Meta Data Repository (MDR) acts a information management system for the structure and contents of a database system.  A MDR differs from a Data Dictionary in that the MDR also describes the content within the columns of the database itself.  As relational databases turn into legacy systems the content within these databases changes.  this may take the form of adding, modifying or eliminating  coded elements within the database.  Over time these changes are often lost.  

Based on previous experience from multiple database projects in multiple countries, this became a significant issue as the information about the database content was often contained by the database administrator who would need to be queried when the database was access to ensure that the right information was being asked for.  

We developed a system called the "Meta Data Repository" (MDR) that can access a variety of relational databases, queries the database schema, table and column structure and content and prepares a report that can be edited for proper documentation of the database.  

More information about MDR (version 1.0) can be found at:
http://www.healthcaresimulations.com/MetaData.html
Picture

Patient-X

Patient-X is a light-weight hetergenous database transfer application taht addresses many of the issues surrounding the transfer of patient information.  Patient-X supports the following databases: Microsoft Access, Microsoft SQL Server, Oracle, MySQL, Postgres and Excel/CSV.  

More information about Patient-X (version 3.0) can be found at:
http://www.healthcaresimulations.com/Patient-X.html
Picture

VizQL

The Visual Query Language (VizQL).  VizQL is a database query system that uses Augmented reality to query a database using cards.

The purpose of this  project was to look to see how we could work with children and have an interactive method for querying relational databases.  An Example of this might be putting the cards for "Women" and "Malawi" and the system would recognize the cards, project a 3D model above the cards and then display the results of How many Women are in Malawi (query from the database).
Picture