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

SQL DATA LENS

Fast database sql tool with special features for IRIS & Caché

A
Andreas Schneider
5.0 (1)23 Feb, 2025 1.1k

bdb-sql-utils

Various utilities from the SQL cookbook

B
Benjamin De Boe
Docker
IPM
4.5 (2)04 Feb, 2025 754 82

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

ObjectScript-Over-ODBC

Allow running ObjectScript and especially Global copy over ODBC

Robert Cemper
Docker
IPM
4.5 (1)26 Nov, 2024 398 18

Global-dump-to-SQL

Show Global by SQL SELECT

Robert Cemper
Docker
IPM
5.0 (1)26 Nov, 2024 580 24

IRIS-Test-Data-Generator

Used to generate test data

D
Dylan Cole
Docker
IPM
3.0 (1)29 Sep, 2024 144

BridgeWorks VDM

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

Tony Coffman
0.0 (0)26 Aug, 2024 513

geo-vector-search

mathematical use of vector search

Robert Cemper
Docker
IPM
5.0 (3)27 Apr, 2024 283

Collection-Indexing-and-Query

How to get correct index for SQL query generator

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

HL7-FHIR-Cohort-Population

HL7 to FHIR Cohort Population

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

openflights_dataset

Openflights demo dataset, datamodel for InterSystems IRIS

A
Andreas Schneider
Docker
3.0 (1)18 Sep, 2023 663

password-app-iris-db

Application for storing passwords

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

Global-Scan-to-SQL

Analyze Globals by Subscript-Level

Robert Cemper
Docker
IPM
4.5 (1)16 Sep, 2023 370 24

SQL-for-ERRORS-Global

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

Robert Cemper
Docker
IPM
5.0 (1)16 Sep, 2023 367 69

The adopted Bitmap

How to enable Bitmaps for nonstandard IDs

Robert Cemper
Docker
IPM
5.0 (1)16 Sep, 2023 233 33

DBeaver

Universal Database Manager and SQL Client

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

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 457

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 260

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 319 40

GoSelector

See Column Selectivity Vs Ratio of Distinct Values

A
Alex Woodhead
IPM
4.0 (1)14 Oct, 2022 168 5

CoffeeCo Full Stack Tutorial

IRIS Coffee Company tutorial

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

Python IRIS SQL Procedures Sample

Samples of python running inside SQL InterSystems IRIS Database

Yuri Marx Pereira Gomes
Docker
IPM
5.0 (1)20 Jul, 2022 279 7

sql-rest-api

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

Evgeny Shvarov
Docker
IPM
5.0 (1)07 Nov, 2021 583 34

csv2table

Example on how to import CSV to any existing table

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

Caché Monitor

Works with many of your databases but is specifically optimized for unique InterSystems Caché and InterSystems IRIS features. It combines many tools with a smart sql editor to provide easy access to your databases. Caché Monitor is like a swiss knife for InterSystems Caché \ IRIS, fast and very easy

A
Andreas Schneider
0.0 (0)15 Aug, 2021 1.8k

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)30 May, 2021 362

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 504

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 198

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)26 Feb, 2021 542

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 378 13

sqltools-intersystems-driver

InterSystems support for SQL in the SQLTools extension to Visual Studio Code

Dmitry Maslennikov
Docker
5.0 (1)08 Sep, 2020 619