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)05 May, 2025 1.2k

openflights_dataset

Openflights demo dataset, datamodel for InterSystems IRIS

A
Andreas Schneider
3.0 (1)22 Apr, 2025 737

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

bdb-sql-utils

Various utilities from the SQL cookbook

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

ObjectScript-Over-ODBC

Allow running ObjectScript and especially Global copy over ODBC

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

Global-dump-to-SQL

Show Global by SQL SELECT

Robert Cemper
Docker
IPM
5.0 (1)26 Nov, 2024 593 25

IRIS-Test-Data-Generator

Used to generate test data

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

BridgeWorks VDM

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

Tony Coffman
0.0 (0)26 Aug, 2024 545

geo-vector-search

mathematical use of vector search

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

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 606 34

The adopted Bitmap

How to enable Bitmaps for nonstandard IDs

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

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

Global-Scan-to-SQL

Analyze Globals by Subscript-Level

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

sql-builder

A flexible and powerful SQL query string builder for InterSystems IRIS

Henry Pereira
Docker
IPM
3.0 (1)25 Mar, 2024 570 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 607 22

Collection-Indexing-and-Query

How to get correct index for SQL query generator

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

HL7-FHIR-Cohort-Population

HL7 to FHIR Cohort Population

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

password-app-iris-db

Application for storing passwords

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

DBeaver

Universal Database Manager and SQL Client

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

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 462

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 275

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

GoSelector

See Column Selectivity Vs Ratio of Distinct Values

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

CoffeeCo Full Stack Tutorial

IRIS Coffee Company tutorial

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

Python IRIS SQL Procedures Sample

Samples of python running inside SQL InterSystems IRIS Database

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

csv2table

Example on how to import CSV to any existing table

Evgeny Shvarov
Docker
IPM
4.5 (1)29 Sep, 2021 264 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 369

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 522

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 202

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 552