SQL

See the following -

A List of Open Source Tools for College

I've used Linux now for 3 1/2 years, which to me is a substantial period of time. In that time, I have gone from only using LibreOffice to expanding into a purely Linux and open source workflow. I have built my workflow around only using open source software if at all possible, although I am required to use a couple of proprietary tools sparingly. I'd like to share my own philosophy regarding open source. I was first introduced to Linux by my programming teacher; he is a passionate believer in FLOSS and he converted me. I have a passionate belief in the technical superiority of open source tools over proprietary ones because they allow me the freedom to use them however I wish...

A New Meaning for Connected Health at 2016 Symposium (Part 3)

Andy Oram | EMR & HIPPA | October 7, 2016

The previous section of this article paused during a discussion of the accuracy and uses of devices. At a panel on patient generated data, a speaker said that one factor holding back the use of patient data was the lack of sophistication in EHRs. They must be enhanced to preserve the provenance of data: whether it came from a device or from a manual record by the patient, and whether the device was consumer-grade or a well-tested medical device. Doctors invest different levels of trust in different methods of collecting data: devices can provide more objective information than other ways of asking patients for data. A participant in the panel also pointed out that devices are more reliable in the lab than under real-world conditions. Consumers must be educated about the proper use of devices, such as whether to sit down and how to hold their arms when taking their blood pressure...

Read More »

DARPA Offers Free Watson-Like Artificial Intelligence

R. Colin Johnson | EE Times | December 10, 2014

If you wonder what the government has done for you lately, take a look at DeepDive. DeepDive is a free version of IBM's Watson developed in the same Defense Advanced Research Projects Agency (DARPA), but now available free and open-source...

Read More »

Data Science Jobs Report 2019: Python Way Up, Tensorflow Growing Rapidly, R Use Double SAS

In my ongoing quest to track The Popularity of Data Science Software, I've just updated my analysis of the job market. To save you from reading the entire tome, I'm reproducing that section here.One of the best ways to measure the popularity or market share of software for data science is to count the number of job advertisements that highlight knowledge of each as a requirement. Job ads are rich in information and are backed by money, so they are perhaps the best measure of how popular each software is now. Plots of change in job demand give us a good idea of what is likely to become more popular in the future. Read More »

Top 7 Open Source Business Intelligence and Reporting Tools

In this article, I review some of the top open source business intelligence (BI) and reporting tools. In economies where the role of big data and open data are ever-increasing, where do we turn in order to have our data analysed and presented in a precise and readable format? This list covers tools which help to solve this problem. Two years ago I wrote about the top three. In this article, I will expand that list with a few more tools that were suggested by our readers. Note that this list is not exhaustive, and it is a mix of both business intelligence and reporting tools...

Why Your Organization Needs to Tap Health Data Analytics

Staff Writer | Health Data Management | January 14, 2016

If there were any doubts about the value of data analytics for healthcare organizations to turn data into actionable insights, a new book from the American Health Information Management Association attempts to put those doubts to rest and provide step-by-step instructions for analyzing data and using statistical techniques. The co-authors of the book—David Marc and Ryan Sandefer, faculty members at the College of St. Scholastica in Duluth, Minn.—argue that proficiency in data analytics is increasingly important for all health information managers and health informaticians as the industry embraces quality improvement initiatives...

Read More »

OSEHRA Innovation Webinar - SQL Access to VistA

Event Details
Type: 
Seminar/Webinar
Date: 
May 28, 2019 - 3:00pm - 4:00pm

SQL access to VistA for reporting and analytics requires two core technologies: (a) an SQL engine; and (b) mapping Fileman files to SQL tables that the SQL engine can use to access data. Although there are many SQL engines, there are few combinations of (a) and (b) that work well, and none that both work well and are free/open source software (FOSS). YottaDB is developing Octo, an SQL engine, and %VISTAOCTO, an adaptable tool, that generates an SQL Schema from Fileman tables. Both are FOSS.

Read More »