34 Application(s) results for #sql
Filter
Show only
Last release on OEX
Categories
Works with
Industry
Application NameDeveloperMade withRatingLast updatedViewsInstalls

IRIS-Test-Data-Generator

Used to generate test data

D
Dylan Cole
Docker
IPM
3.0 (1)22 Sep, 2024 102

BridgeWorks VDM

BridgeWorks VDM is an ad hoc reporting and graphical SQL query application.

Tony Coffman
0.0 (0)26 Aug, 2024 460

InterSystems Ideas Waiting to be Implemented

RPMShare - Database solution for remote patient monitoring (RPM) datasets of high density vitals

Why Currently, patient home monitoring is a megatrend, promising to reduce readmission, and emergency visits and globally add years of health. Owing to US 21st Century act and Reimbursement Schedule from Medicare (up to 54 USD per month per patient) US market is flooded with RPM companies (over 100 for sure) providing primary physicians and hospitals the possibility to collect data from patients' homes, including blood pressure, blood sugar, weight, heart rate, and others. Most companies collect and store the data in free formats, creating an "unholy mess" of data, which has a very limited chance to be ever reused. The hospital only gets insights from single patient results as a dashboard concentrating on cases showing vitals going out of normal range. While research by scientific groups and several advanced companies shows that even data of medium accuracy could predict adverse events like heart failure weeks before happening. A project which is able to provide a federated environment for these new types of data, allowing patients and hospitals truly own data, connecting it to classic EHR, and making data readily available for AI/ML, a project like this is poised to conquer the US maket, with other markets following the trend. Who RPM Companies collecting the data will love the solution which will transfer the data from devices using FHIR, provide full security and compliance, and will include a multitude of routine functions for data analysis, and even data representation. They will stop creating hundreds of repositories of similar software code and concentrate on patient success. Hospitals will be able to have their own structured and standardized silos of data, they will have a chance to change RPM providers, and have a history of patient vitals. They will have EHR data and RPM data connected. Dashboards could be integrated into existing EMRs much easier and finally, they will be precious sources of integrated data for research. Patients will be able to reuse their data, have it analyzed by leading health tech companies, and enrich their vitals with even more data from wearables and other devices. Researchers will be able to analyze the data in the same cloud as it is stored, and by anonymizing datasets, with integrated EMR and RPM data, they could potentially assemble unprecedented volumes of data. AI/ML-ready datasets will boost the predictive power of digital health in only a few years from the first implementations of data collection. How HealthShare is already able to store and receive data in FHIR format, minor additions for hl7 standards are to be implemented and accepted by the community. In a way, RPMshare is a mini-version of HealthShare, if designed using an interoperability framework it could even have universal connection standards for existing devices. A secret sauce could be made from the integration of InterSystems solutions in anonymization and the IntegratedML package with RPMshare. To create immediate value and populate cloud service a consortium or partnership with existing RPM companies could be developed, where they will receive benefits of instrumentation and standardization and InterSystems will populate hundreds of thousands of years of observations (assuming companies already have tens of thousands of clients). In simple words, it is an Uber for RPM data.

D
by Dmitry Alexeev

6

Votes

0

Comments
Vote

SQL DATA LENS

DB Tool with special features for IRIS & Caché

A
Andreas Schneider
5.0 (1)10 Aug, 2024 959

geo-vector-search

mathematical use of vector search

Robert Cemper
Docker
IPM
5.0 (3)26 Apr, 2024 245

ObjectScript-Over-ODBC

Allow running ObjectScript and especially Global copy over ODBC

Robert Cemper
Docker
IPM
4.5 (1)25 Mar, 2024 341 18

sql-rest-api

Simple REST API web app which accepts SQL and returns the result in JSON

Evgeny Shvarov
Docker
IPM
5.0 (1)25 Mar, 2024 529 34

SQL-for-ERRORS-Global

Map ^ERRORS Global and have a custom query for full content

Robert Cemper
Docker
IPM
5.0 (1)25 Mar, 2024 338 69

The adopted Bitmap

How to enable Bitmaps for nonstandard IDs

Robert Cemper
Docker
IPM
5.0 (1)25 Mar, 2024 217 33

Global-dump-to-SQL

Show Global by SQL SELECT

Robert Cemper
Docker
IPM
5.0 (1)25 Mar, 2024 518 24

Global-Scan-to-SQL

Analyze Globals by Subscript-Level

Robert Cemper
Docker
IPM
4.5 (1)25 Mar, 2024 346 24

sql-builder

A flexible and powerful SQL query string builder for InterSystems IRIS

Henry Pereira
Docker
IPM
3.0 (1)25 Mar, 2024 514 22

IRIS External Table

IRIS External Table allows you to access files in the local filesystem and cloud BLOB storage such as AWS S3 and Azure BLOB Storage as regular IRIS SQL tables.

A
Anton Umnikov
Docker
IPM
4.3 (2)25 Mar, 2024 529 22

Collection-Indexing-and-Query

How to get correct index for SQL query generator

Robert Cemper
Docker
IPM
4.0 (2)03 Feb, 2024 248 29

HL7-FHIR-Cohort-Population

HL7 to FHIR Cohort Population

M
Momeena Ali
5.0 (1)25 Jan, 2024 181

bdb-sql-utils

Various utilities from the SQL cookbook

B
Benjamin De Boe
Docker
IPM
4.5 (2)17 Jan, 2024 611 74

openflights_dataset

Openflights demo dataset, datamodel for InterSystems IRIS

A
Andreas Schneider
3.0 (1)18 Sep, 2023 589

password-app-iris-db

Application for storing passwords

O
Oleksandr Zaitsev
Docker
Python
4.5 (2)17 Sep, 2023 298

DBeaver

Universal Database Manager and SQL Client

S
Serge Rider
4.9 (15)29 May, 2023 2.4k

Sheep’s Galaxy

Example of using InterSystems IRIS Cloud SQL and IntegratedML

M
Maria Gladkova
Docker
Python
ML
ML
2.0 (1)21 Apr, 2023 416

isc-cloud-sql-python-demo

A simple python and flask app with IRIS Cloud SQL on back

Evgeny Shvarov
Python
5.0 (1)23 Mar, 2023 239

NY Taxi Demo

A simple guide to NY taxi business, leveraging Columnar Storage

B
Benjamin De Boe
Docker
Python
IPM
5.0 (1)10 Jan, 2023 284 38

GoSelector

See Column Selectivity Vs Ratio of Distinct Values

A
Alex Woodhead
IPM
4.0 (1)13 Oct, 2022 152 5

CoffeeCo Full Stack Tutorial

IRIS Coffee Company tutorial

R
Raj Singh
Python
3.0 (1)12 Aug, 2022 265

Python IRIS SQL Procedures Sample

Samples of python running inside SQL InterSystems IRIS Database

Yuri Marx
Docker
IPM
5.0 (1)20 Jul, 2022 253 7

csv2table

Example on how to import CSV to any existing table

Evgeny Shvarov
Docker
IPM
4.5 (1)29 Sep, 2021 225 11

irisdemo-demo-restsql

Simple demo of IRIS exposing REST APIs created based on Swagger that have a SQL database as the backend.

A
Amir Samary
Docker
4.3 (2)04 May, 2021 460

Create a unified hospital data extraction scheme based on IRIS for Health

Create a unified hospital data extraction scheme based on IRIS for Health

D
Deming Xu
0.0 (0)04 Mar, 2021 341

Integration scheme for heterogeneous messages in heterogeneous systems

Integration scheme for heterogeneous messages in heterogeneous systems

D
Deming Xu
0.0 (0)28 Feb, 2021 178

HealthInfoQueryLayer

The application use generic interface to perform query on data schema and used globals as configuration. At run time, the program will implement the query referring to configurations. It's working as a prototype ObjectScript MyBatis Template.

B
Botai Zhang
0.0 (0)24 Jan, 2021 512

iris-multi-model-api-template

a simple demo of InterSystems IRIS multi-model data management via REST API

Evgeny Shvarov
Docker
IPM
5.0 (1)11 Jan, 2021 346 13