Exploiting the user interface for tomorrow's clinical data analysis

Judith (Judy) Logan, James Terwilliger, Lois Delcambre

Research output: Contribution to journalArticle

Abstract

Clinical information systems are primary sources of data for health services and effectiveness research. Access to that data may be hampered by complex database structures, and the quality of research lessened by lack of contextual knowledge about the data. In addition, the integration of data captured in multiple information systems remains a challenge because of differences between the information systems in content and data representation. Traditional data integration uses an Extraction-Transform-Load (ETL) workflow which requires that integration of data be performed in a single defined manner. This poses problems for clinical research because the data integration decisions are typically encoded in the highly technical ETL procedures whereas different clinical analyses may require different decisions on semantic integration, which cannot be accommodated in the ETL process. We propose that the contextual information important for data retrieval and analysis resides in the information system user interface and that this interface can be exploited to improve access to single clinical databases as well as the semantic integration of data across multiple databases. The computational concepts and prototype tools presented here include automated tools for creation of databases based on user interfaces, methods for analysts to directly write queries against an interface resembling the user interface and containing contextual information, and tools that allow analysts to classify data elements from multiple sources in a dynamic manner resulting in semantic integration of those data sources.

Original languageEnglish (US)
Pages (from-to)138-149
Number of pages12
JournalJournal on Information Technology in Healthcare
Volume6
Issue number2
StatePublished - Apr 1 2008

Fingerprint

Information Systems
User interfaces
Information Storage and Retrieval
Information systems
Semantics
Databases
Data integration
Mathematical transformations
Interfaces (computer)
Workflow
Health Services Research
Research
Health

ASJC Scopus subject areas

  • Medicine (miscellaneous)
  • Computer Science Applications

Cite this

Exploiting the user interface for tomorrow's clinical data analysis. / Logan, Judith (Judy); Terwilliger, James; Delcambre, Lois.

In: Journal on Information Technology in Healthcare, Vol. 6, No. 2, 01.04.2008, p. 138-149.

Research output: Contribution to journalArticle

@article{49126649399c41ae9add6601bed27816,
title = "Exploiting the user interface for tomorrow's clinical data analysis",
abstract = "Clinical information systems are primary sources of data for health services and effectiveness research. Access to that data may be hampered by complex database structures, and the quality of research lessened by lack of contextual knowledge about the data. In addition, the integration of data captured in multiple information systems remains a challenge because of differences between the information systems in content and data representation. Traditional data integration uses an Extraction-Transform-Load (ETL) workflow which requires that integration of data be performed in a single defined manner. This poses problems for clinical research because the data integration decisions are typically encoded in the highly technical ETL procedures whereas different clinical analyses may require different decisions on semantic integration, which cannot be accommodated in the ETL process. We propose that the contextual information important for data retrieval and analysis resides in the information system user interface and that this interface can be exploited to improve access to single clinical databases as well as the semantic integration of data across multiple databases. The computational concepts and prototype tools presented here include automated tools for creation of databases based on user interfaces, methods for analysts to directly write queries against an interface resembling the user interface and containing contextual information, and tools that allow analysts to classify data elements from multiple sources in a dynamic manner resulting in semantic integration of those data sources.",
author = "Logan, {Judith (Judy)} and James Terwilliger and Lois Delcambre",
year = "2008",
month = "4",
day = "1",
language = "English (US)",
volume = "6",
pages = "138--149",
journal = "Journal on Information Technology in Healthcare",
issn = "1479-649X",
publisher = "Optimum",
number = "2",

}

TY - JOUR

T1 - Exploiting the user interface for tomorrow's clinical data analysis

AU - Logan, Judith (Judy)

AU - Terwilliger, James

AU - Delcambre, Lois

PY - 2008/4/1

Y1 - 2008/4/1

N2 - Clinical information systems are primary sources of data for health services and effectiveness research. Access to that data may be hampered by complex database structures, and the quality of research lessened by lack of contextual knowledge about the data. In addition, the integration of data captured in multiple information systems remains a challenge because of differences between the information systems in content and data representation. Traditional data integration uses an Extraction-Transform-Load (ETL) workflow which requires that integration of data be performed in a single defined manner. This poses problems for clinical research because the data integration decisions are typically encoded in the highly technical ETL procedures whereas different clinical analyses may require different decisions on semantic integration, which cannot be accommodated in the ETL process. We propose that the contextual information important for data retrieval and analysis resides in the information system user interface and that this interface can be exploited to improve access to single clinical databases as well as the semantic integration of data across multiple databases. The computational concepts and prototype tools presented here include automated tools for creation of databases based on user interfaces, methods for analysts to directly write queries against an interface resembling the user interface and containing contextual information, and tools that allow analysts to classify data elements from multiple sources in a dynamic manner resulting in semantic integration of those data sources.

AB - Clinical information systems are primary sources of data for health services and effectiveness research. Access to that data may be hampered by complex database structures, and the quality of research lessened by lack of contextual knowledge about the data. In addition, the integration of data captured in multiple information systems remains a challenge because of differences between the information systems in content and data representation. Traditional data integration uses an Extraction-Transform-Load (ETL) workflow which requires that integration of data be performed in a single defined manner. This poses problems for clinical research because the data integration decisions are typically encoded in the highly technical ETL procedures whereas different clinical analyses may require different decisions on semantic integration, which cannot be accommodated in the ETL process. We propose that the contextual information important for data retrieval and analysis resides in the information system user interface and that this interface can be exploited to improve access to single clinical databases as well as the semantic integration of data across multiple databases. The computational concepts and prototype tools presented here include automated tools for creation of databases based on user interfaces, methods for analysts to directly write queries against an interface resembling the user interface and containing contextual information, and tools that allow analysts to classify data elements from multiple sources in a dynamic manner resulting in semantic integration of those data sources.

UR - http://www.scopus.com/inward/record.url?scp=42949096564&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=42949096564&partnerID=8YFLogxK

M3 - Article

AN - SCOPUS:42949096564

VL - 6

SP - 138

EP - 149

JO - Journal on Information Technology in Healthcare

JF - Journal on Information Technology in Healthcare

SN - 1479-649X

IS - 2

ER -