Healthcare providers compare trial results against existing treatments, striving to identify superior options. Their research team evaluates the new treatment vis-à-vis the standard one, investigating the impact of different dosages and combinations on diverse populations (e.g., men, women, various age groups, and ethnicities).

At HCLTech, we've structured clinical trial studies data (de-normalized) and populated it with sample data. Our task involves aligning source attributes in the customer landscape with pre-established model attributes (target). The resulting model and attributes are seamlessly integrated and published as a web service.

Leveraging Denodo data virtualization product, we've integrated and published the data as a service to enable accessibility for patients and healthcare providers. This consolidated view encompasses comprehensive clinical study details, including status, conditions/diseases, interventions, study type, phase, sponsors/collaborators, funder type, study design, outcome measures, enrolment numbers, demographics (gender, age), identification numbers (NCT, other IDs), study titles, acronyms, study commencement, completion dates, and posting dates. Accessible via URL/web link on any browser, users can effortlessly retrieve related attributes for reporting and analytics without the need for additional client software installation.

The offering is powered by Denodo. Below are the key features of developing this offering with Denodo:

• Connects to data (structured, semi-structured and unstructured) without collecting or copying it, leading to significant cost savings in data storage and saving time in creating new datasets.

• Centralizes data model creation and displays all data assets across projects in a single platform.

• Utilizes data abstraction for enhanced security and coverage of underlying configurations.

• Decouples sources and consumers, minimizing the impact on business reporting during upgrades and migrations.

• Implements a central security and governance model for strong control over data management. It also provides granular cell-level security, supporting custom data masking to row and cell levels.

• Features a state-of-the-art Data Catalog powered by AI, acting as a single marketplace for all data needs. Denodo platform is a low-code and no-code platform for rapid development and user-friendly operations.

• Denodo Data Services capability facilitates providing data sets in required formats (e.g., Rest API, SOAP) with just a few clicks.

• Advanced performance optimization engine supports quick resolution of queries.