Module - 5 Report Final
Module - 5 Report Final
Digital clinical records are essential for supporting healthcare organizations in order to facilitate
patient management, diagnosis, and treatment planning. Accessing pertinent patient data fast,
precisely, and efficiently is becoming more and more crucial as the amount of healthcare data
keeps growing. ever-more important. Modern healthcare apps must guarantee accessibility in
addition to retrieval efficiency so that users with a variety of skills can successfully interact with
the system.
The proposed system includes a retrieval pipeline that is organized, processes medical data,
indexes records, and rapidly retrieves relevant information. Benchmarking techniques and
performance evaluation metrics, such as retrieval latency, are employed to assess performance,
while recognized accessibility principles are utilized to assess accessibility compliance. The
system aims to achieve a balance between retrieval efficiency and accessibility criteria in order to
make healthcare information more accessible and usable for a larger number of users.
Experimental results indicate that the proposed approach can retrieve clinical records effectively
while adhering to accessibility standards. The project sets up a platform that will enable the
creation of more inclusive and user-friendly healthcare technology in the future, and highlights
the importance of incorporating accessibility into healthcare information systems.
ACKNOWLEDGEMENT
First and the foremost, I am highly grateful to Dr. S R Shankapal, Vice Chancellor GM
UNIVERSITY for providing an opportunity of fulfill the partial requirement towards obtaining
my master degree by accomplishing the assignment.
AMRUTHA M KOTI
TABLE OF CONTENTS
CHAPTER TITLE PAGE
NO. ABSTRACT 1
ACKNOWLEDGEMENT 2
ASSIGNMENT 1
1 INTRODUCTION
1.1 Prelude 1
1.2 Problem Statement 2
1.3 Objectives 3-4
1.4 Scope and Limitations 5-6
1.5 Organization of Report 7-8
1.6 Tools/Language Used 8-10
2 LITERATURE SURVEY
2.1 Introduction 11
2.2 Literature Survey 11-13
2.3 Comparative Analysis of Existing system 13-14
2.4 Identification of Gaps 15-16
ASSIGNMENT 2
3 PROPOSED SYSTEM
3.1 Introduction 17
3.2 Workflow of system 17-21
3.3 Algorithm 22-24
3.4 Summary 24-25
4 SOFTWARE IMPLEMENTATION
4.1 Introduction 26
4.2 Operating System 26
4.3 Python Programming Language 27
4.4 MySQL and PostgreSQL 27
4.5 Visual Studio Code 27
4.6 MySQL Workbench and PgAdmin 28
4.7 Pandas 28
4.8 Sqlite3 28
4.9 MySQL Connection System 28
4.10 Matplotlib 28
4.11 Code Implementation 29-34
5 ASSIGNMENT 3
EXPERIMENTAL RESULTS
5.1 Introduction 35
5 .2 Experimental Results 36-40
6.1 Conclusion 41
6.2 Future Scope 41-43
REFERENCES
LIST OF FIGURES
1.1 Prelude
The rapid digital transformation of the healthcare industry has led to the creation of substantial
amounts of clinical data, including patient records, lab reports, prescriptions, diagnostic results,
and treatment histories. Healthcare practitioners must effectively manage and retrieve this data in
order to make timely and well-informed decisions. Traditional retrieval methods often struggle to
provide quick and accurate access to relevant information as healthcare data continues to expand.
Along with retrieval efficiency, accessibility has grown to be a crucial demand in contemporary
healthcare systems. Users with different abilities, including those who rely on assistive
technologies like screen readers, keyboard navigation, and visual accessibility features, should
be included in the design of healthcare apps. Current healthcare retrieval systems frequently
place a higher priority on performance and usefulness than they do on accessibility
requirements.
To solve these issues, this research suggests the Accessible Healthcare Record Retrieval System
(MedReach), which integrates effective record retrieval with accessibility-aware design
principles. Users can test accessibility compliance, add healthcare data, search and retrieve
patient records, and evaluate retrieval efficiency.
By integrating accessibility features into the retrieval process, the framework seeks to make
healthcare information accessible and useable for a wider variety of users.
The suggested system places equal emphasis on efficiency and inclusion. To evaluate response
times and overall system performance, the system uses organized retrieval pipelines,
accessibility-compliant interfaces, and benchmarking techniques. Through these elements, the
project helps create a healthcare information environment that is effective, user-friendly, and
available to everyone.
This work demonstrates how healthcare information retrieval systems can integrate accessibility
factors without compromising usability and performance. The resulting framework offers a
practical means to advance equitable healthcare information management and improve access to
clinical records. Index Recommendation System offers a completely.
Page | 1
1.2 Problem Statement
To store, manage, and access patient-related data, the healthcare sector mostly depends on digital
information systems. Patient demographics, medical histories, diagnostic reports, prescriptions,
treatment plans, and test results are just a few of the crucial details that are stored in electronic
health records. In order to provide prompt and efficient medical care, healthcare providers rely on
this information. medication. As healthcare facilities continue to produce significant volumes of
Clinical data retrieval has become a major concern, as has the capacity to swiftly and reliably
obtain pertinent clinical records. problem as long as medical facilities continue to generate a lot
of clinical data.
These days, the majority of healthcare information systems are focused on data storage and
simple retrieval features. As the amount of data increases, these systems, which are capable of
storing enormous databases of patient data, frequently run into issues with effectively retrieving
records. Clinical workflows, decision-making procedures, and the general effectiveness of
healthcare services can all be negatively impacted by slow retrieval times. Small delays in
obtaining patient data can have a direct impact on the standard of care given to patients, even in
emergency situations.
The disregard for accessibility in healthcare retrieval systems is another significant problem. The
design of software programs such that all users, including those with disabilities, can successfully
engage with the system is known as accessibility. Patients and healthcare providers may have a
variety of accessibility needs, including cognitive difficulties, movement impairments, hearing
impairments, and visual impairments. Nevertheless, a lot of the healthcare applications that are
now in use are not entirely compatible with assistive technology like keyboard navigation tools
and screen readers. Because of this, some users could have difficulties when trying to obtain
crucial medical information.
This project's main goal is to provide an accessible healthcare record retrieval system that
facilitates effective, dependable, and universal access to clinical data. The goal of the system is to
make it easier to find patient records while maintaining the usability of healthcare apps for people
with various accessibility needs. To develop a system for retrieving medical records that
enhances clinical data accessibility and promotes inclusive healthcare information management
by fusing effective search capabilities with accessibility-focused design principles.
Page | 2
1.3 Objectives
Reducing patient information access delays requires effective retrieval of medical records.
The implementation of search and indexing techniques that allow the system to swiftly find
pertinent records is the main emphasis of this goal. Faster retrieval increases the overall
efficacy of healthcare information management and assists medical practitioners in making
prompt judgments.
Page | 3
This goal entails tracking query execution times and evaluating the retrieval process's
effectiveness under various circumstances. Improved user experience and more efficient
healthcare processes are facilitated by lower latency.
The goal of the project is to determine whether the created system complies with accepted
accessibility standards and guidelines. An evaluation of accessibility compliance aids in
determining the system's strong points and regions in need of development. Through
accessibility assessments, the project guarantees that the healthcare retrieval platform
facilitates inclusive information access for all users.
The project's main goal is to lower obstacles that keep people from getting healthcare
information. The system encourages equitable access to patient records and healthcare
services by integrating accessibility-focused features. This goal advances the more general
purpose of developing technological solutions that people of all physical and mental
capacities can utilize.
Page | 4
integration, and real-time healthcare database connectivity are just a few of the capabilities
that could be added to the system in the future. The project's continued relevance as
healthcare technology advance is ensured by a flexible basis.
Summary
Enhancing accessibility and retrieval efficiency are the main goals of the Accessible
Healthcare Record Retrieval System. The project's goal is to develop a healthcare information
system that is inclusive, dependable, and able to meet the demands of a variety of users by
incorporating effective search mechanisms, accessibility-aware design principles, compliance
evaluation, and performance benchmarking.
Scope:
The creation of an accessible healthcare record retrieval framework that facilitates inclusive
user interaction and rapid access to clinical information is the main goal of this research. The
technology is intended to help administrators, academics, and medical practitioners quickly
and efficiently retrieve patient-related records from structured healthcare datasets.
The project involves designing and implementing a healthcare retrieval pipeline that uses an
accessible user interface to handle patient data and offer search capabilities. Users can search
for patient records, upload healthcare datasets, and obtain pertinent data using predetermined
search parameters. Additionally, the system has accessibility features that make it easier for
people with varying abilities to use.
The project's main goal is to include accessibility principles into the retrieval of medical
information. Keyboard navigation, understandable interface layouts, adaptable text display,
and assistive technology compliance are only a few of the characteristics that the system
supports. Access to healthcare information is made more inclusive with the aid of these
characteristics.
Performance review is a significant component of the project's scope. The system analyzes
how effectively medical records can be retrieved by measuring retrieval latency and
Page | 5
benchmark parameters. In order to ascertain whether the program respects usability standards
and accessibility criteria, accessibility compliance evaluation is also included.
The project also facilitates the creation of reports summarizing the results of accessibility
assessments and retrieval performance. These reports can be used to track the efficacy of the
system and spot areas that could use improvement. Overall, the study shows how accessibility
and healthcare information retrieval may be combined into a single framework to enhance
clinical record access while preserving system usability and efficiency.
Limitations:
Although the suggested method provides a workable option for retrieving medical records
it currently has certain drawbacks.
CSV and JSON files are the main structured healthcare datasets that the system uses.
Multimedia healthcare data, handwritten notes, scanned reports, and unstructured medical
documents are currently not supported by the system. Retrieval is therefore limited to data
that is contained in the supported data formats.
For installation and testing, the project makes use of sample or demonstration datasets. The
technology is not directly connected to live Electronic Health Record (EHR) platforms or real
hospital data systems. Instead of being used in an actual clinical context, the technology is
meant to be used for research and teaching purposes.
Specific accessibility features and compliance indicators are the main emphasis of the
accessibility evaluation component. Although the system satisfies common accessibility
requirements, it is outside the purview of this project to conduct a thorough accessibility audit
that takes into account all international standards and assistive technology.
Basic security and privacy measures are put in place, appropriate for project demonstration.
The present version lacks advanced healthcare security features including biometric
authentication, encryption-based access control, and regulatory compliance monitoring.
The retrieval process does not use sophisticated artificial intelligence or machine learning
algorithms for intelligent recommendations, semantic comprehension, or predictive search;
Page | 6
instead, it depends on traditional search methods. As a result, the query matching procedure
and the accessible dataset structure determine the search results.
Furthermore, comparatively small datasets have been used to assess system performance.
When managing enormous healthcare databases with millions of patient records, performance
behavior may change.
Introduction in Chapter 1
The notion of accessibility-aware healthcare record retrieval is introduced in the first chapter,
which also provides an introduction of the project. The background of healthcare information
systems, the problem statement, project objectives, scope and limitations, report
organization, and the tools and technology used for development are all covered. This
chapter explains the purpose and importance of the suggested work.
The proposed Accessible Healthcare Record Retrieval System's architecture and design are
covered in this chapter. It describes how the system operates, including data gathering,
preparation, retrieval methods, accessibility integration, and performance assessment. The
algorithms and techniques utilized to accomplish effective and accessible healthcare record
retrieval are also covered in this chapter.
Page | 7
Software Implementation in Chapter Four
The fourth chapter is devoted to the project's actual execution. It offers information on the
system's databases, libraries, programming languages, development tools, and hardware and
software requirements. Relevant code snippets and system operations are explained, along
with the development of several modules, such as dataset management, patient search,
accessibility evaluation, and report production.
Page | 8
was chosen because to its ease of use, wide library support, and appropriateness for data-
driven applications.
SQLite3Database
The backend database for storing medical records and data pertaining to accessibility is
SQLite3. It offers quick and easy database administration without the need for a separate
database server.
Library of Pandas
The system uses Pandas to handle healthcare datasets that are uploaded. The library makes
dataset preprocessing easier and offers robust data manipulation capabilities.
Matplotlib Software
Retrieval performance and accessibility evaluation results are displayed using Matplotlib.
Charts and graphs that aid in the analysis of benchmark measures are produced by the system.
Summary
Python is used as the primary programming language, Visual Studio Code is used as the
development environment, SQLite3 is used for data storage, Pandas is used to process
healthcare datasets, and Matplotlib is used to visualize results in the MedReach system.
Additional features facilitate report preparation, dataset management, retrieval
benchmarking, and accessibility assessment. When combined, these tools offer a thorough
framework for creating an effective and accessible healthcare record retrieval system.
Page | 10
CHAPTER 2
LITERATURE SURVEY
2.1 Introduction
Page | 11
Paper 2: Abdullah Khalili, Maryam Arabi, Aamenah Sattar, Abdullah Hosseini,
Ahmed Serag, and Ahmed Ibrahim (2025)
Based on Retrieval-Augmented Generation technology, Ahmed Ibrahim and his
colleagues created MERA (Medical Electronic Records Assistant), an intelligent
healthcare information retrieval system. The suggested approach enhances access to
electronic health records by combining artificial intelligence with information retrieval
methods. The system helps medical practitioners easily retrieve patient data, create
summaries, and respond to clinical inquiries. Intelligent retrieval systems can greatly
improve healthcare information accessibility and decision-making, as the study showed.
This article offers insightful information about the sophisticated healthcare record
retrieval methods employed in the project under consideration.
Deyi Li, Aditi Shukla, Sravani Chandaka, Bradley Taylor, Jie Xu, and Mei Liu
(2025) are the authors of Paper Three.
To retrieve comparable patient records from electronic health records, Deyi Li and
associates developed a machine learning-based method. In order to learn meaningful
patient representations and increase retrieval accuracy, their research used autoencoder
models. Compared to traditional search methods, the suggested approach was more
successful in finding clinically related patients. According on experimental findings,
retrieval efficiency in big healthcare databases can be greatly increased using
representation learning. The goals of the MedReach system are in line with this study's
emphasis on the value of effective retrieval methods.
Paper 4: Yue Zhong, Zhengyun Zhao, Huaiyuan Ying, and Sheng Yu (2025)
[Link], a rich retrieval framework created especially for electronic health data, was
presented by Zhengyun Zhao and his research team. The system incorporates synthetic
healthcare data and medical knowledge injection to enhance search relevance and
retrieval accuracy. The approach improves access to patient records and offers more
significant search results by resolving semantic distinctions in healthcare inquiries. The
study showed how sophisticated retrieval methods can enhance the management of
healthcare data and facilitate effective clinical decision-making. The results support the
suggested project's retrieval optimization component.
Page | 12
Rianne Beckers and Birgitte Schoenmakers (2025) in Paper 5
A research by Rianne Beckers and Birgitte Schoenmakers assessed how patient-friendly
healthcare websites are. They looked at things including user satisfaction, readability,
navigation layout, and content accessibility. The findings showed that accessible
healthcare systems enhance user experience and make healthcare information more
accessible. The study underlined the necessity of inclusive services and adherence to
accessibility guidelines in healthcare applications. The accessibility-aware design
principles integrated into the MedReach system are supported by this study.
Iannuzzi, Marco Manca, Fabio Paternò, and Carmen Santoro (2025) in Paper 6
Nicola Iannuzzi and colleagues put up a thorough methodology for digital system
accessibility monitoring and evaluation. The study's main goal was to employ ongoing
compliance review to find accessibility problems in electronic documents and websites.
Mechanisms for identifying accessibility issues and producing compliance reports were
made available by the framework. In order to sustain inclusive digital environments, the
authors came to the conclusion that regular accessibility monitoring is necessary. The
accessibility compliance evaluation and reporting modules included in the suggested
MedReach system are directly connected to this study.
Methodology /
Author(s) & Year Title of the Work Key Contributions Limitations
Approach
Automated Focuses only on
Improved healthcare
Amandeep Kaur, Framework for Automated web accessibility
website usability
Jaswinder Singh, Comprehensive parsing and
and accessibility
evaluation;
Usability Analysis accessibility does not
Satinder Kaur assessment;
of Healthcare evaluation support
(2025) identified
Websites Using techniques healthcare
accessibility barriers
Web Parsing record retrieval
Page | 13
Methodology /
Author(s) & Year Title of the Work Key Contributions Limitations
Approach
Hosseini, Ahmed
Serag (2025)
Combines
healthcare record
Accessibility- retrieval,
Currently tested
aware retrieval accessibility
on sample
Accessible framework with support, retrieval
Proposed System healthcare
Healthcare Record benchmark latency
(MedReach) datasets and
Retrieval System analysis and measurement,
prototype-scale
compliance compliance
implementation
evaluation assessment, and
report generation in
a single platform
Page | 14
2.4 Identification of Gaps
Upon examining the current research and healthcare information retrieval systems, a
number of constraints and unresolved problems were found. These gaps show that a
more complete and accessible healthcare record retrieval system is required.
Page | 15
Healthcare retrieval systems and accessibility assessment tools are often created as stand-
alone programs. Users frequently need to use various platforms in order to conduct
accessibility tests and retrieve healthcare information, which increases complexity.
Page | 16
ASSIGNMENT 2
CHAPTER 3
PROPOSED SYSTEM
3.1 Introduction
In order to ensure that healthcare information can be accessed by a wide range of users,
including those who rely on assistive technologies, MedReach incorporates
accessibility-aware design principles. It also measures retrieval latency and benchmark
metrics to assess search efficiency and overall system performance. By integrating
healthcare record retrieval, accessibility evaluation, benchmark analysis, and report
generation, the proposed system, MedReach – Accessible Healthcare Record Retrieval
System, is designed to provide efficient and accessible access to clinical records.
MedReach offers a comprehensive solution for managing and accessing healthcare information
in an inclusive and efficient manner.
Page | 17
Fig 3.2.1 System Architecture Overview
Page | 18
1. Upload the dataset
The process starts with the uploading of healthcare datasets, which include clinical
documentation, diagnoses, medical histories, and patient records. The format of the
dataset is checked by the system before to processing. This phase ensures that the system
only receives structured, legitimate healthcare data.
3. Indexing Data
The system creates indexes for important characteristics including patient ID, name,
diagnosis, and medical history after the records are saved. Efficient data organization is
made possible by indexing, which also significantly reduces the time required to retrieve
entries during search operations.
5. Evaluation of Accessibility
In order to verify adherence to accessibility guidelines, the accessibility evaluation
module examines the user interface. It evaluates aspects including assistive technology
assistance, readability, keyboard accessibility, and navigation. An accessibility score is
produced based on the examination.
6. Analyzing Benchmarks
The retrieval system's performance is gauged by the benchmark analysis module. To
assess the effectiveness of the search process, it computes retrieval delay, response time,
and other performance indicators. This aids in determining where performance has to be
improved
Page | 19
7. Dashboard and Report Creation
The system produces comprehensive reports whenever accessibility and performance
assessments are finished. Retrieval statistics, performance metrics, benchmark analysis
results, and accessibility compliance results are all included in these reports. For ease of
understanding, the data is shown via dashboards, graphs, and charts.
8. Final Result
Accessibility compliance reports, benchmark reports, performance visualizations, and
retrieved patient records make up the system's ultimate output. These outputs guarantee
system efficacy and accessibility while assisting users in effectively accessing healthcare
information
Page | 20
Fig 3.2.2 Sequence Diagram
Page | 21
3.3 Algorithm
A healthcare dataset that includes clinical records, diagnosis, medical history, and patient
data is uploaded by the user. The dataset is approved for additional processing by the
system.
The uploaded dataset is examined to make sure all of the records are accurate,
comprehensive, and free of significant mistakes. This validation procedure aids in
preserving the accuracy of the data.
Step 4: Data Cleaning and Preparation
The system fixes errors in the dataset, resolves missing values, and eliminates duplicate
entries. Data cleansing enhances the precision and quality of retrieval outcomes.
Step 5: Maintain Documents in the Archive
Following preprocessing, the cleaned medical records are safely kept in the database
repository. This repository is where patient data is centrally stored.
Step 6 : Establish Search Indexes
Important fields like Patient ID, Name, Diagnosis, and Medical History have indexes.
Indexing speeds up searches and makes it possible to get records more quickly.
Step 7: Get the search request
The patient search interface allows the user to input a search query. Names, identifiers,
diagnoses, and other health-related data may be included in the inquiry.
Step 8: Handle Search Terms
The criteria needed to find the pertinent records in the database are determined by the
retrieval engine after analyzing the search request.
Step 9: Find Records That Match
The system looks through the database and finds records that match the user's query
using the indexed data. The pertinent medical data is then obtained.
Page | 22
Step 10: Show the information that was retrieved
Quick access to healthcare information is made possible by the user interface's ordered
and readable display of the retrieved patient records.
Step 11: Assess Features of Accessibility
The interface's compliance with accessibility standards is assessed by the accessibility
module. It evaluates usability elements that cater to a variety of users, including those
who use assistive technology.
Compute the Compliance Score in Step 12
The system determines a compliance score based on the accessibility evaluation. This
rating shows how well the system complies with WCAG principles and other
accessibility standards.
Step 13: Assess the Performance of Retrieval
Key performance metrics including retrieval latency, response time, and query processing
speed are measured by the benchmark module. These measures aid in assessing system
effectiveness.
Step 14: Conduct a Benchmark Assessment
To evaluate the retrieval framework's efficacy, the gathered performance indicators are
examined. This assessment assists in locating optimization potential.
Page | 23
Pseudo Code
BEGIN
Validate Dataset
Preprocess Data
ENDIF
Display Results
END
3.4 Summary
The suggested MedReach—Accessible Healthcare Record Retrieval System—was
introduced in this chapter. Its goal is to make healthcare records accessible and effective for
all. Within a single framework, the suggested solution combines patient record retrieval,
performance benchmarking, accessibility assessment, healthcare data management, and
report production.
Page | 24
The system architecture shows how various modules—such as dataset management, data
storage and indexing, retrieval processing, accessibility evaluation, and benchmark
analysis—interact with one another. The system workflow shows how healthcare data is
uploaded, processed, stored, and retrieved in response to user inquiries. Indexing strategies
that boost search effectiveness and shorten response times enhance the retrieval process.
Furthermore, the accessibility evaluation module guarantees that the system complies with
accessibility standards and encourages equitable access to healthcare information for all
users.
The benchmark analysis component allows for ongoing system effectiveness assessment by
measuring retrieval latency and other performance indicators. For improved analysis and
decision-making, the report generating module also offers comprehensive compliance
reports, benchmark outcomes, retrieval data, and dashboard visualizations.
Page | 25
CHAPTER 4
SOFTWARE IMPLEMENTATION
4.1 Introduction
One of the most important stages in the creation of the MedReach-Accessible Healthcare
Record Retrieval System is software implementation. During this stage, the suggested design is
transformed into a functional application using appropriate software tools, databases,
programming languages, and development environments. The creation of an effective
healthcare record retrieval system that includes accessibility assessment, benchmark analysis,
compliance reporting, and patient record administration is given top priority during the
framework's implementation.
Python and related technologies are used in the system's development to provide a scalable and
user-friendly solution. Database management systems are used to process, store, and retrieve
healthcare datasets. Specific modules are utilized to evaluate performance metrics and
accessibility. To help users analyze retrieval efficiency and accessibility compliance, the system
also includes dashboard visualization and report production.
The software solutions used for this project offer adaptability, simplicity in development,
effective data management, and powerful visualization features. Together, these technologies
enable the suggested healthcare retrieval system to be successfully implemented.
Page | 26
4.3 Programming Language: Python
The main programming language used to put the suggested system into practice is Python.
Because of its ease of use, readability, and broad library support, it is frequently utilized in
healthcare and data processing applications.
Function in the Project:
Handling and Preparation of data.
Retrieving medical records.
Evaluation of accessibility.
Benchmark evaluation.
Creating reports.
Page | 27
Graphical database management tools like PgAdmin and MySQL Workbench are used for
database administration and monitoring.
Part of the Project:
Building and configuring databases.
Testing and query execution.
Management of tables.
Performance tracking.
Libraries Used
4.7 Pandas
A Python package called Pandas is used to manipulate and analyze data. It is essential for
managing healthcare datasets prior to storage and retrieval
Function in the Project:
examining medical data.
preprocessing and data cleansing.
handling values that are missing.
Data analysis and transformation.
4.8 sqlite3
Basic database connectivity is provided by the sqlite3 module for early project deployments and
local testing. It makes it possible to save experimental datasets without requiring a specific
database server.
4.9 The Python application and the database server communicate over the
MySQL connection system.
Activities:
database accessibility.
executing a query.
data extraction.
updates and addition of records.
4.10Matplotlib
Charts and graphical depictions of system performance and accessibility outcomes can be made
using Matplotlib, a visualization library.
Page | 28
Function in the Project:
Visualizing performance.
Charts of accessibility scores.
Analysis of benchmark outcomes.
Creating a dashboard.
import pandas as pd
Page | 29
import sqlite3
# Connect to database
conn = [Link]("[Link]")
# Store dataset
df.to_sql("patients", conn, if_exists="replace", index=False)
search_term = "Diabetes"
query = """
SELECT * FROM patients
WHERE conditions LIKE ?
"""
result = pd.read_sql_query(
query,
conn,
params=[f"%{search_term}%"]
)
print([Link]())
Page | 30
import time
start_time = [Link]()
query = """
SELECT * FROM patients
WHERE conditions LIKE '%Diabetes%'
"""
pd.read_sql_query(query, conn)
end_time = [Link]()
latency = (end_time - start_time) * 1000
print("Retrieval Latency:", latency, "ms")
import [Link] as plt
metrics = ["Latency", "Throughput"]
values = [0.64, 1549]
[Link](metrics, values)
[Link]("System Performance Metrics")
[Link]("Values")
[Link]()
@import "tailwindcss" ;
@source "../src";
@import "tw-animate-css";
@custom-variant dark (&:is(.dark *));
@theme inline {
--radius-sm: calc(var(--radius) - 4px);
--radius-md: calc(var(--radius) - 2px);
--radius-lg: var(--radius);
--radius-xl: calc(var(--radius) + 4px);
--color-background: var(--background);
--color-foreground: var(--foreground);
--color-card: var(--card);
--color-card-foreground: var(--card-foreground);
--color-popover: var(--popover);
--color-popover-foreground: var(--popover-foreground);
--color-primary: var(--primary);
--color-primary-foreground: var(--primary-foreground);
--color-secondary: var(--secondary);
--color-secondary-foreground: var(--secondary-foreground);
--color-muted: var(--muted);
--color-muted-foreground: var(--muted-foreground);
--color-accent: var(--accent);
--color-accent-foreground: var(--accent-foreground);
--color-destructive: var(--destructive);
--color-destructive-foreground: var(--destructive-foreground);
--color-success: var(--success);
--color-success-foreground: var(--success-foreground);
--color-warning: var(--warning);
--color-warning-foreground: var(--warning-foreground);
--color-border: var(--border);
--color-input: var(--input);
--color-ring: var(--ring);
--color-ring-offset-background: var(--background);
Page | 31
--color-chart-1: var(--chart-1);
--color-chart-2: var(--chart-2);
--color-chart-3: var(--chart-3);
--color-chart-4: var(--chart-4);
--color-chart-5: var(--chart-5);
--color-sidebar: var(--sidebar);
--color-sidebar-foreground: var(--sidebar-foreground);
--color-sidebar-primary: var(--sidebar-primary);
--color-sidebar-primary-foreground: var(--sidebar-primary-foreground);
--color-sidebar-accent: var(--sidebar-accent);
--color-sidebar-accent-foreground: var(--sidebar-accent-foreground);
--color-sidebar-border: var(--sidebar-border);
--color-sidebar-ring: var(--sidebar-ring);
--font-display: "Outfit", ui-sans-serif, system-ui, sans-serif;
--font-sans: "Inter", ui-sans-serif, system-ui, sans-serif;
}
:root {
--radius: 0.5rem;
--background: oklch(0.985 0.005 230);
--foreground: oklch(0.20 0.04 250);
--card: oklch(1 0 0);
--card-foreground: oklch(0.20 0.04 250);
--popover: oklch(1 0 0);
--popover-foreground: oklch(0.20 0.04 250);
--primary: oklch(0.50 0.10 220);
--primary-foreground: oklch(0.99 0.005 230);
--secondary: oklch(0.93 0.025 230);
--secondary-foreground: oklch(0.25 0.05 250);
--muted: oklch(0.95 0.015 230);
--muted-foreground: oklch(0.42 0.03 245);
--accent: oklch(0.90 0.04 230)
--accent: oklch(0.90 0.04 230);
--ring: oklch(0.50 0.10 220);
--chart-1: oklch(0.50 0.10 220);
--chart-2: oklch(0.55 0.14 155);
--chart-3: oklch(0.65 0.15 70);
--chart-4: oklch(0.55 0.22 27);
--chart-5: oklch(0.35 0.08 250);
--sidebar: oklch(0.97 0.01 230);
--sidebar-foreground: oklch(0.20 0.04 250);
--sidebar-primary: oklch(0.50 0.10 220);
--sidebar-primary-foreground: oklch(0.99 0.005 230);
--sidebar-accent: oklch(0.93 0.025 230);
--sidebar-accent-foreground: oklch(0.22 0.05 250);
--sidebar-border: oklch(0.85 0.02 230);
--sidebar-ring: oklch(0.50 0.10 220);
}
Page | 32
--accent-foreground: oklch(0.22 0.05 250);
--destructive: oklch(0.55 0.22 27);
--destructive-foreground: oklch(0.99 0.005 230);
--success: oklch(0.55 0.14 155);
--success-foreground: oklch(0.99 0.005 230);
--warning: oklch(0.65 0.15 70);
--warning-foreground: oklch(0.15 0.04 250);
--border: oklch(0.85 0.02 230);
--input: oklch(0.85 0.02 230);
--ring: oklch(0.50 0.10 220);
--chart-1: oklch(0.50 0.10 220);
--chart-2: oklch(0.55 0.14 155);
--chart-3: oklch(0.65 0.15 70);
--chart-4: oklch(0.55 0.22 27);
--chart-5: oklch(0.35 0.08 250);
--sidebar: oklch(0.97 0.01 230);
--sidebar-foreground: oklch(0.20 0.04 250);
--sidebar-primary: oklch(0.50 0.10 220);
--sidebar-primary-foreground: oklch(0.99 0.005 230);
--sidebar-accent: oklch(0.93 0.025 230);
--sidebar-accent-foreground: oklch(0.22 0.05 250);
--sidebar-border: oklch(0.85 0.02 230);
--sidebar-ring: oklch(0.50 0.10 220);
}
@layer base {
*{
border-color: var(--color-border);
}
html {
font-family: var(--font-sans);
}
body {
background-color: var(--color-background);
color: var(--color-foreground);
font-feature-settings: "cv02", "cv03", "cv04", "cv11";
}
h1, h2, h3, h4 {
font-family: var(--font-display);
letter-spacing: -0.02em;
}
}
:focus-visible {
outline: 3px solid var(--color-ring);
outline-offset: 2px;
border-radius: 4px;
}
.skip-link {
position: absolute;
left: -9999px;
top: 0;
Page | 33
z-index: 100;
padding: 0.75rem 1.25rem;
background: var(--color-primary);
color: var(--color-primary-foreground);
font-weight: 600;
border-radius: 0 0 0.5rem 0;
}
.skip-link:focus {
left: 0;
}
}
[Link]
.hc-mode
{
--background: oklch(1 0 0);
--foreground: oklch(0 0 0);
--card: oklch(1 0 0);
--card-foreground: oklch(0 0 0);
--primary: oklch(0.30 0.20 260);
--primary-foreground: oklch(1 0 0);
--muted-foreground: oklch(0.20 0 0);
--border: oklch(0 0 0);
--ring: oklch(0.30 0.20 260);
--secondary: oklch(0.95 0 0);
--secondary-foreground: oklch(0 0 0);
}
Page | 34
ASSIGNMENT 3
CHAPTER 5
EXPERIMENTAL RESULTS
5.1 Introduction
The outcomes of experiments are essential for assessing the performance and efficacy of the
suggested system. The findings of the implementation and testing of the MedReach-Accessible
Healthcare Record Retrieval System are presented in this chapter. Analyzing the system's
capacity to effectively extract medical records while upholding accessibility criteria and
offering a user-friendly experience is the major goal of the assessment.
The system's uploaded healthcare datasets were used for the trials. To confirm their
performance, a number of features were examined, including dataset management, patient
record retrieval, accessibility evaluation, benchmark analysis, and report preparation. Retrieval
accuracy, response time, retrieval latency, accessibility compliance, and overall system
usability are the main metrics of the assessment. To determine if the system facilitates inclusive
access to healthcare information, the accessibility evaluation module was utilized. In a similar
vein, the benchmark analysis module assessed performance metrics like retrieval efficiency and
query processing time.
The system's behavior under various circumstances is clearly depicted via the dashboards,
charts, and reports that are produced. The experimental results show how the suggested
framework effectively combines performance monitoring, accessibility compliance assessment,
and healthcare record retrieval. The results in this chapter support the MedReach system's
efficacy and demonstrate its capacity to deliver dependable, effective, and easily accessible
healthcare information retrieval services.
Page | 35
5.2 Experimental Results
The MedReach system's primary dashboard is illustrated in Figure 5.2.1. This interface is used
by users to access the platform for retrieving healthcare records. The dashboard allows for
uploading datasets, searching patient records, assessing retrieval efficiency, and exporting
reports. Summary information, including the quantity of active records, average retrieval
latency, and recent query performance, is also displayed. The user-friendly design ensures easy
navigation and facilitates the handling of healthcare data in an accessibility-conscious manner.
Page | 36
The dataset upload module of the proposed system is illustrated in Figure 5.2.2. The upload
interface enables users to import medical records in CSV, JSON, or FHIR file formats. After a
successful upload, the system checks the dataset's format and displays information such as the
total number of entries, accessibility metadata, and sample patient records. This module acts as
the foundation of the retrieval system by preparing healthcare data for storage and subsequent
retrieval operations.
Page | 37
The patient search module created with accessibility in mind is shown in Figure 5.2.3. Using
patient names, medical record numbers (MRN), ailments, allergies, and healthcare providers, the
interface lets users search clinical records. Users can tailor searches to meet specific accessibility
needs with accessibility filters like high contrast mode, captioned telehealth, voice navigation,
screen reader assistance, and large print. Effective record retrieval performance is demonstrated
by the instantaneous display of the recovered patient details and retrieval latency measures.
Page | 38
The MedReach system's report export and benchmark analysis features are displayed in Figure
5.2.4. The benchmark module measures latency-related parameters and runs several artificial
queries to assess retrieval performance. For performance evaluation, metrics including median
reaction time, average latency, throughput, P95 latency, and P99 latency are shown.
Comprehensive patient reports and compliance documentation in PDF format are produced by
the export module. This feature facilitates accessibility assessment, performance tracking, and
thorough documenting of medical records.
Page | 39
The report on patient records produced by the MedReach Healthcare Record Retrieval System is
shown in Figure 5.2.5. Medical Record Number (MRN), patient name, date of birth, gender,
healthcare provider, and information about recent visits are all included in the report's structured
summary of patient data. Metrics related to retrieval performance, like query latency and average
response time, are also shown. In order to facilitate healthcare documentation, record keeping, and
information sharing, the report is automatically generated in PDF format. The well-organized
tabular structure preserves a clear and expert display of healthcare data while enhancing readability
and facilitating users' rapid access to patient information.
Page | 40
CHAPTER 6
The healthcare datasets, and assess accessibility compliance using predetermined evaluation
criteria. By measuring retrieval delay and system performance, the benchmark analysis module
allows for ongoing evaluation of retrieval efficacy. Additionally, the dashboards and reports
that are generated offer valuable insights into retrieval statistics, accessibility status, and
general system efficiency.
The outcomes of the experiment show that the suggested system can reliably retrieve medical
records while upholding usability and accessibility requirements. Users with a variety of needs
are supported by the accessibility-aware design, which encourages equitable access to
healthcare information. All things considered, the MedReach framework offers a dependable,
approachable, and performance-focused method for retrieving medical records, enhancing
healthcare information management and accessibility.
Page | 41
1. The ability to search intelligently
Intelligent search algorithms that comprehend user intent and deliver more precise retrieval
may be incorporated into future iterations of the system. This will shorten search times and
enhance user satisfaction.
8. Interactive Multilingual
Page | 42
Healthcare information can be made available to people with diverse linguistic backgrounds
by expanding the system to handle numerous languages.
Page | 43
REFERENCES
[1] M. Abo El-Enen, S. Saad, and T. Nazmy, “A Survey on Retrieval-Augmented Generation (RAG)
Models for Healthcare Applications,” Neural Computing and Applications, vol. 37, pp. 28191–28267,
2025.
[2] A. Ibrahim, A. Khalili, M. Arabi, A. Sattar, A. Hosseini, and A. Serag, “MERA: Medical Electronic
Records Assistant,” Machine Learning and Knowledge Extraction, vol. 7, no. 3, 2025.
[3] D. Li, A. Shukla, S. Chandaka, B. Taylor, J. Xu, and M. Liu, “Autoencoder-Based Representation
Learning for Similar Patients Retrieval From Electronic Health Records: Comparative Study,” JMIR
Medical Informatics, vol. 13, 2025.
[4] Z. Zhao, H. Ying, Y. Zhong, and S. Yu, “[Link]: Dense Retrieval for Electronic Health Record
with Knowledge Injection and Synthetic Data,” arXiv, 2025.
[5] Z. Zhao, H. Yuan, J. Liu, H. Chen, H. Ying, Y. Zhong, and S. Yu, “CliniQ: A Multi-faceted
Benchmark for Electronic Health Record Retrieval with Semantic Match Assessment,” 2025.
[7] A. M. Tawfik, A. Al-Ahwal, A. S. Tag Eldien, and H. H. Zayed, “Blockchain-Based Access Control
and Privacy Preservation in Healthcare: A Comprehensive Survey,” Cluster Computing, vol. 28, 2025.
[8] A. Bracken, C. Reilly, A. Feeley, E. Sheehan, K. Merghani, and I. Feeley, “Artificial Intelligence-
Powered Documentation Systems in Healthcare: A Systematic Review,” Journal of Medical Systems,
vol. 49, no. 28, 2025.
[9] E. A. Pineo, “Discoverability, Usability, and Readability: A Framework for Assessing Accessibility
for Disabled Users of Online Archives,” Archival Science, vol. 25, 2025.
[10] M. A. Saberi, H. Mcheick, and M. Adda, “From Data Silos to Health Records Without Borders: A
Systematic Survey on Patient-Centered Data Interoperability,” Information, vol. 16, no. 2, 2025.
[11] A. Chouhan and M. Gertz, “heiDS at ArchEHR-QA 2025: From Fixed-k to Query-dependent-k for
Retrieval Augmented Generation,” arXiv, 2025.