Using closure tables to enable cross-querying of ontologies in database-driven applications

Daniel R. Harris; Darren W. Henderson; Jeffery C. Talbert

doi:10.1109/BHI.2017.7897313

Using closure tables to enable cross-querying of ontologies in database-driven applications

Daniel R. Harris, Darren W. Henderson, Jeffery C. Talbert

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › peer-review

Abstract

We demonstrate that closure tables are an effective data structure for developing database-driven applications that query biomedical ontologies and that require cross-querying between multiple ontologies. A closure table stores all available paths within a tree, even those without a direct parent-child relationship; additionally, a node can have multiple ancestors which gives the foundation for supporting linkages between controlled ontologies. We augment the meta-data structure of the ICD9 and ICD10 ontologies included in i2b2, an open source query tool for identifying patient cohorts, to utilize a closure table. We describe our experiences in incorporating existing mappings between ontologies to enable clinical and health researchers to identify patient populations using the ontology that best matches their preference and expertise.

Original language	English
Title of host publication	2017 IEEE EMBS International Conference on Biomedical and Health Informatics, BHI 2017
Pages	493-496
Number of pages	4
ISBN (Electronic)	9781509041794
DOIs	https://doi.org/10.1109/BHI.2017.7897313
State	Published - Apr 11 2017
Event	4th IEEE EMBS International Conference on Biomedical and Health Informatics, BHI 2017 - Orlando, United States Duration: Feb 16 2017 → Feb 19 2017

Publication series

Name	2017 IEEE EMBS International Conference on Biomedical and Health Informatics, BHI 2017

Conference

Conference	4th IEEE EMBS International Conference on Biomedical and Health Informatics, BHI 2017
Country/Territory	United States
City	Orlando
Period	2/16/17 → 2/19/17

Bibliographical note

Publisher Copyright:
© 2017 IEEE.

ASJC Scopus subject areas

Health Informatics
Computer Science Applications
Biomedical Engineering

Access to Document

10.1109/BHI.2017.7897313

Cite this

Harris, D. R., Henderson, D. W., & Talbert, J. C. (2017). Using closure tables to enable cross-querying of ontologies in database-driven applications. In 2017 IEEE EMBS International Conference on Biomedical and Health Informatics, BHI 2017 (pp. 493-496). Article 7897313 (2017 IEEE EMBS International Conference on Biomedical and Health Informatics, BHI 2017). https://doi.org/10.1109/BHI.2017.7897313

@inproceedings{f2e146888fba40099c48c0e61f827c8f,

title = "Using closure tables to enable cross-querying of ontologies in database-driven applications",

abstract = "We demonstrate that closure tables are an effective data structure for developing database-driven applications that query biomedical ontologies and that require cross-querying between multiple ontologies. A closure table stores all available paths within a tree, even those without a direct parent-child relationship; additionally, a node can have multiple ancestors which gives the foundation for supporting linkages between controlled ontologies. We augment the meta-data structure of the ICD9 and ICD10 ontologies included in i2b2, an open source query tool for identifying patient cohorts, to utilize a closure table. We describe our experiences in incorporating existing mappings between ontologies to enable clinical and health researchers to identify patient populations using the ontology that best matches their preference and expertise.",

author = "Harris, {Daniel R.} and Henderson, {Darren W.} and Talbert, {Jeffery C.}",

note = "Publisher Copyright: {\textcopyright} 2017 IEEE.; 4th IEEE EMBS International Conference on Biomedical and Health Informatics, BHI 2017 ; Conference date: 16-02-2017 Through 19-02-2017",

year = "2017",

month = apr,

day = "11",

doi = "10.1109/BHI.2017.7897313",

language = "English",

series = "2017 IEEE EMBS International Conference on Biomedical and Health Informatics, BHI 2017",

pages = "493--496",

booktitle = "2017 IEEE EMBS International Conference on Biomedical and Health Informatics, BHI 2017",

}

Harris, DR, Henderson, DW & Talbert, JC 2017, Using closure tables to enable cross-querying of ontologies in database-driven applications. in 2017 IEEE EMBS International Conference on Biomedical and Health Informatics, BHI 2017., 7897313, 2017 IEEE EMBS International Conference on Biomedical and Health Informatics, BHI 2017, pp. 493-496, 4th IEEE EMBS International Conference on Biomedical and Health Informatics, BHI 2017, Orlando, United States, 2/16/17. https://doi.org/10.1109/BHI.2017.7897313

Using closure tables to enable cross-querying of ontologies in database-driven applications. / Harris, Daniel R.; Henderson, Darren W.; Talbert, Jeffery C.
2017 IEEE EMBS International Conference on Biomedical and Health Informatics, BHI 2017. 2017. p. 493-496 7897313 (2017 IEEE EMBS International Conference on Biomedical and Health Informatics, BHI 2017).

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution › peer-review

TY - GEN

T1 - Using closure tables to enable cross-querying of ontologies in database-driven applications

AU - Harris, Daniel R.

AU - Henderson, Darren W.

AU - Talbert, Jeffery C.

PY - 2017/4/11

Y1 - 2017/4/11

N2 - We demonstrate that closure tables are an effective data structure for developing database-driven applications that query biomedical ontologies and that require cross-querying between multiple ontologies. A closure table stores all available paths within a tree, even those without a direct parent-child relationship; additionally, a node can have multiple ancestors which gives the foundation for supporting linkages between controlled ontologies. We augment the meta-data structure of the ICD9 and ICD10 ontologies included in i2b2, an open source query tool for identifying patient cohorts, to utilize a closure table. We describe our experiences in incorporating existing mappings between ontologies to enable clinical and health researchers to identify patient populations using the ontology that best matches their preference and expertise.

AB - We demonstrate that closure tables are an effective data structure for developing database-driven applications that query biomedical ontologies and that require cross-querying between multiple ontologies. A closure table stores all available paths within a tree, even those without a direct parent-child relationship; additionally, a node can have multiple ancestors which gives the foundation for supporting linkages between controlled ontologies. We augment the meta-data structure of the ICD9 and ICD10 ontologies included in i2b2, an open source query tool for identifying patient cohorts, to utilize a closure table. We describe our experiences in incorporating existing mappings between ontologies to enable clinical and health researchers to identify patient populations using the ontology that best matches their preference and expertise.

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

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

U2 - 10.1109/BHI.2017.7897313

DO - 10.1109/BHI.2017.7897313

M3 - Conference contribution

AN - SCOPUS:85018391767

T3 - 2017 IEEE EMBS International Conference on Biomedical and Health Informatics, BHI 2017

SP - 493

EP - 496

BT - 2017 IEEE EMBS International Conference on Biomedical and Health Informatics, BHI 2017

T2 - 4th IEEE EMBS International Conference on Biomedical and Health Informatics, BHI 2017

Y2 - 16 February 2017 through 19 February 2017

ER -

Using closure tables to enable cross-querying of ontologies in database-driven applications

Abstract

Publication series

Conference

Bibliographical note

ASJC Scopus subject areas

Access to Document

Other files and links

Fingerprint

Cite this