RexDB is an integrated registry data management platform created by Prometheus Research, LLC, aiming to facilitate data management for a wide range of research in autism and associated disorder. The platform is composed of three core component: RexPlatform, RexAcquire and RexMart. RexDB is a wrapper of PostgreSQL, utilizing most of its features while adapting it to its domain-specific purposes. [04][05][06]
- Website
- http://www.rexdb.org[01]
- Source Code
- https://bitbucket.org/rexdb/[02]
- Developer
- Country of Origin
- US
- Start Year
- 2006 [24]
- Acquired By
- Project Type
- Open Source
- Written in
- JavaScript, Python
- Derived From
- PostgreSQL
- Compatible With
- SQLite
- License
- AGPL v3
RexAcquire component applies Extract, Transform and Load (ETL) mechanism. It separates data acquisition from the transactional system. It captures data from electronic data capture systems.
RexMart allows users to manipulate data sets from central database. It separates ad hoc querying from the transactional system.
RexDB is an integrated registry data management platform created by Prometheus Research, LLC, aiming to facilitate data management for a wide range of research in autism and associated disorder. The platform is composed of three core component: RexPlatform, RexAcquire and RexMart. RexDB is a wrapper of PostgreSQL, utilizing most of its features while adapting it to its domain-specific purposes.
RexAcquire component applies Extract, Transform and Load (ETL) mechanism. It separates data acquisition from the transactional system. It captures data from electronic data capture systems.
RexMart allows users to manipulate data sets from central database. It separates ad hoc querying from the transactional system.[04][05][06]
History[07][05]
In 2005, RexDB was first released for Small Research Groups at Yale University. In 2007, RexDB was used for Simons Simplex Collection. In 2011, in order to benefit the scientific community, Prometheus Research decided to open source the RexDB platform, marking the beginning of the open source initiative. In 2012, RexDB was released open source under AGLv3 as "RexDB 3.0." In 2013, RexDB was adapted to support disease and procedure specific registries.
Foreign Keys[13][14][15]
RexDB does support the concept of foreign key constraints, shown in REX.Deploy, which is the database schema management system of RexDB. The deployment only occurs when table id a foreign key constraint are present. If they are not, then they are created. The FOREIGN KEY constraint is also created with ON DELETE SET DEFAULT if the link is not a part of the table identity, otherwise it is created with ON DELETE CASCADE.
Indexes[16]
Based on the implementation of rex.db - the database configuration and setting component of Rex.DB, it's up to the admin and user to determine what type of database server they want to use. Therefore the indexing method is determined case by case. According to the documentation, Rex.DB supports sqlite, mysql and pgsql so far. Since these databases use B+Tree, Hash Table and Inverted Index, Rex.DB also supports them.
Joins[17]
Rex.deploy wraps a number of PostgreSQL functions, and join is one of them. Since PostgreSQL supports Hash Join, Nested Loop Join and Sort-Merge Join, RexDB also utilizes those three types of join. The threshold and other configurations in RexDB's join are consistent with those in PostgreSQL.
Query Interface[18][19]
RexDB supports database access based on HTSQL. Meanwhile it also supports JSON datatype and SQL functions. Since some math functions provided by PostgreSQL are exposed to HTSQL, they are also supported.
Storage Model[20]
The storage model of RexD can be analyzed through rex.deploy component - the database schema management system. It utilizes PostgreSQL's storage model.
Citations
24 sources- Medical Specialties and Provider Associations | IQVIA rexdb.org
- https://bitbucket.org/rexdb/ bitbucket.org
- https://www.rexdb.org/documentation.html rexdb.org
- https://figshare.com/articles/A_Technical_Demonstration_of_RexDB_an_Open_Source_Integrated_Data_Management_Platform_for_Autism_Research/1054645 figshare.com
- Warning: Security Risk rexdb.org
- https://doc.rexdb.org/rex.website/0.0.0 rexdb.org
- https://www.researchgate.net/profile/Charles_Tirrell/publication/273344630_An_Open_Source_Integrated_Data_Management_System_for_Medical_Registries_A_Case_Study_using_RexDB_Informatics_to_Support_Clinical_Trials/links/54fefa040cf2741b69f1e032/An-Open-Source-Integrated-Data-Management-System-for-Medical-Registries-A-Case-Study-using-RexDB-Informatics-to-Support-Clinical-Trials.pdf researchgate.net
- Warning: Security Risk rexdb.org
- Warning: Security Risk rexdb.org
- Warning: Security Risk rexdb.org
- Warning: Security Risk rexdb.org
- https://bitbucket.org/rexdb/rex.study/src/default/doc/introduction/erds.rst bitbucket.org
- Warning: Security Risk rexdb.org
- Warning: Security Risk rexdb.org
- Warning: Security Risk rexdb.org
- https://bitbucket.org/rexdb/rex.db/src/default/src/rex/db/setting.py bitbucket.org
- https://bitbucket.org/rexdb/rex.deploy/src/default/ bitbucket.org
- Warning: Security Risk rexdb.org
- Warning: Security Risk rexdb.org
- Warning: Security Risk rexdb.org
- https://bitbucket.org/rexdb/rex.attach/src/default/#rst-header-overview bitbucket.org
- Warning: Security Risk rexdb.org
- Warning: Security Risk rexdb.org
- Warning: Security Risk rexdb.org