Applying temporal joins to clinical databases
Clinical databases typically contain a significant amount of temporal information, information that is often crucial in medical decision-support systems. Most recent clinical information systems use the relational model when working with this information. Although these systems have reasonably well-...
Gespeichert in:
| Veröffentlicht in: | Proceedings - AMIA Symposium 1999, p.335-339 |
|---|---|
| Hauptverfasser: | , , |
| Format: | Artikel |
| Sprache: | eng |
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| container_end_page | 339 |
|---|---|
| container_issue | |
| container_start_page | 335 |
| container_title | Proceedings - AMIA Symposium |
| container_volume | |
| creator | O'Connor, M J Tu, S W Musen, M A |
| description | Clinical databases typically contain a significant amount of temporal information, information that is often crucial in medical decision-support systems. Most recent clinical information systems use the relational model when working with this information. Although these systems have reasonably well-defined semantics for temporal queries on a single relational table, many do not fully address the complex semantics of operations involving multiple temporal tables. Such operations can arise frequently in queries on clinical databases. This paper describes the issues encountered when joining a set of temporal tables, and outlines how such joins are far more complex than non-temporal ones. We describe the semantics of temporal joins in a query management system called Chronus II, a system we have developed to assist in evaluating patients for clinical trials. |
| format | Article |
| fullrecord | <record><control><sourceid>proquest_pubme</sourceid><recordid>TN_cdi_pubmedcentral_primary_oai_pubmedcentral_nih_gov_2232759</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>69281073</sourcerecordid><originalsourceid>FETCH-LOGICAL-p262t-d7913ffc4f976d70601db4cf2e06f1ef8e552e7053f0acf49a1cf256e5635bf23</originalsourceid><addsrcrecordid>eNpVkE1LxDAQhnNQ3HX1L0hP3gr5aJLmIiyLHwsLXhS8hTSdrFnaJjapsP_egqvoaWDel-cZ5gwtCWekFJi_LdBlSgeMBVY1vkALgrkQTIolKtcxdkc_7IsMfQyj6YpD8EMqcihs5wdv501rsmlMgnSFzp3pElyf5gq9Pty_bJ7K3fPjdrPelZEKmstWKsKcs5VTUrRy1pK2qayjgIUj4GrgnILEnDlsrKuUIXPIBXDBeOMoW6G7b26cmh5aC0OeL9Nx9L0ZjzoYr_8ng3_X-_CpKWVUcjUDbk-AMXxMkLLufbLQdWaAMCUtFK0Jlmwu3vw1_Sp-PsS-AAKaYnk</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>article</recordtype><pqid>69281073</pqid></control><display><type>article</type><title>Applying temporal joins to clinical databases</title><source>PubMed Central Free</source><source>MEDLINE</source><creator>O'Connor, M J ; Tu, S W ; Musen, M A</creator><creatorcontrib>O'Connor, M J ; Tu, S W ; Musen, M A</creatorcontrib><description>Clinical databases typically contain a significant amount of temporal information, information that is often crucial in medical decision-support systems. Most recent clinical information systems use the relational model when working with this information. Although these systems have reasonably well-defined semantics for temporal queries on a single relational table, many do not fully address the complex semantics of operations involving multiple temporal tables. Such operations can arise frequently in queries on clinical databases. This paper describes the issues encountered when joining a set of temporal tables, and outlines how such joins are far more complex than non-temporal ones. We describe the semantics of temporal joins in a query management system called Chronus II, a system we have developed to assist in evaluating patients for clinical trials.</description><identifier>ISSN: 1531-605X</identifier><identifier>PMID: 10566376</identifier><language>eng</language><publisher>United States: American Medical Informatics Association</publisher><subject>Database Management Systems ; Databases as Topic - organization & administration ; Hospital Information Systems - organization & administration ; Humans ; Medical Records Systems, Computerized - organization & administration ; Time</subject><ispartof>Proceedings - AMIA Symposium, 1999, p.335-339</ispartof><lds50>peer_reviewed</lds50><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktopdf>$$Uhttps://www.ncbi.nlm.nih.gov/pmc/articles/PMC2232759/pdf/$$EPDF$$P50$$Gpubmedcentral$$H</linktopdf><linktohtml>$$Uhttps://www.ncbi.nlm.nih.gov/pmc/articles/PMC2232759/$$EHTML$$P50$$Gpubmedcentral$$H</linktohtml><link.rule.ids>230,314,727,780,784,885,4024,53791,53793</link.rule.ids><backlink>$$Uhttps://www.ncbi.nlm.nih.gov/pubmed/10566376$$D View this record in MEDLINE/PubMed$$Hfree_for_read</backlink></links><search><creatorcontrib>O'Connor, M J</creatorcontrib><creatorcontrib>Tu, S W</creatorcontrib><creatorcontrib>Musen, M A</creatorcontrib><title>Applying temporal joins to clinical databases</title><title>Proceedings - AMIA Symposium</title><addtitle>Proc AMIA Symp</addtitle><description>Clinical databases typically contain a significant amount of temporal information, information that is often crucial in medical decision-support systems. Most recent clinical information systems use the relational model when working with this information. Although these systems have reasonably well-defined semantics for temporal queries on a single relational table, many do not fully address the complex semantics of operations involving multiple temporal tables. Such operations can arise frequently in queries on clinical databases. This paper describes the issues encountered when joining a set of temporal tables, and outlines how such joins are far more complex than non-temporal ones. We describe the semantics of temporal joins in a query management system called Chronus II, a system we have developed to assist in evaluating patients for clinical trials.</description><subject>Database Management Systems</subject><subject>Databases as Topic - organization & administration</subject><subject>Hospital Information Systems - organization & administration</subject><subject>Humans</subject><subject>Medical Records Systems, Computerized - organization & administration</subject><subject>Time</subject><issn>1531-605X</issn><fulltext>true</fulltext><rsrctype>article</rsrctype><creationdate>1999</creationdate><recordtype>article</recordtype><sourceid>EIF</sourceid><recordid>eNpVkE1LxDAQhnNQ3HX1L0hP3gr5aJLmIiyLHwsLXhS8hTSdrFnaJjapsP_egqvoaWDel-cZ5gwtCWekFJi_LdBlSgeMBVY1vkALgrkQTIolKtcxdkc_7IsMfQyj6YpD8EMqcihs5wdv501rsmlMgnSFzp3pElyf5gq9Pty_bJ7K3fPjdrPelZEKmstWKsKcs5VTUrRy1pK2qayjgIUj4GrgnILEnDlsrKuUIXPIBXDBeOMoW6G7b26cmh5aC0OeL9Nx9L0ZjzoYr_8ng3_X-_CpKWVUcjUDbk-AMXxMkLLufbLQdWaAMCUtFK0Jlmwu3vw1_Sp-PsS-AAKaYnk</recordid><startdate>1999</startdate><enddate>1999</enddate><creator>O'Connor, M J</creator><creator>Tu, S W</creator><creator>Musen, M A</creator><general>American Medical Informatics Association</general><scope>CGR</scope><scope>CUY</scope><scope>CVF</scope><scope>ECM</scope><scope>EIF</scope><scope>NPM</scope><scope>7X8</scope><scope>5PM</scope></search><sort><creationdate>1999</creationdate><title>Applying temporal joins to clinical databases</title><author>O'Connor, M J ; Tu, S W ; Musen, M A</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-p262t-d7913ffc4f976d70601db4cf2e06f1ef8e552e7053f0acf49a1cf256e5635bf23</frbrgroupid><rsrctype>articles</rsrctype><prefilter>articles</prefilter><language>eng</language><creationdate>1999</creationdate><topic>Database Management Systems</topic><topic>Databases as Topic - organization & administration</topic><topic>Hospital Information Systems - organization & administration</topic><topic>Humans</topic><topic>Medical Records Systems, Computerized - organization & administration</topic><topic>Time</topic><toplevel>peer_reviewed</toplevel><toplevel>online_resources</toplevel><creatorcontrib>O'Connor, M J</creatorcontrib><creatorcontrib>Tu, S W</creatorcontrib><creatorcontrib>Musen, M A</creatorcontrib><collection>Medline</collection><collection>MEDLINE</collection><collection>MEDLINE (Ovid)</collection><collection>MEDLINE</collection><collection>MEDLINE</collection><collection>PubMed</collection><collection>MEDLINE - Academic</collection><collection>PubMed Central (Full Participant titles)</collection><jtitle>Proceedings - AMIA Symposium</jtitle></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext</fulltext></delivery><addata><au>O'Connor, M J</au><au>Tu, S W</au><au>Musen, M A</au><format>journal</format><genre>article</genre><ristype>JOUR</ristype><atitle>Applying temporal joins to clinical databases</atitle><jtitle>Proceedings - AMIA Symposium</jtitle><addtitle>Proc AMIA Symp</addtitle><date>1999</date><risdate>1999</risdate><spage>335</spage><epage>339</epage><pages>335-339</pages><issn>1531-605X</issn><abstract>Clinical databases typically contain a significant amount of temporal information, information that is often crucial in medical decision-support systems. Most recent clinical information systems use the relational model when working with this information. Although these systems have reasonably well-defined semantics for temporal queries on a single relational table, many do not fully address the complex semantics of operations involving multiple temporal tables. Such operations can arise frequently in queries on clinical databases. This paper describes the issues encountered when joining a set of temporal tables, and outlines how such joins are far more complex than non-temporal ones. We describe the semantics of temporal joins in a query management system called Chronus II, a system we have developed to assist in evaluating patients for clinical trials.</abstract><cop>United States</cop><pub>American Medical Informatics Association</pub><pmid>10566376</pmid><tpages>5</tpages></addata></record> |
| fulltext | fulltext |
| identifier | ISSN: 1531-605X |
| ispartof | Proceedings - AMIA Symposium, 1999, p.335-339 |
| issn | 1531-605X |
| language | eng |
| recordid | cdi_pubmedcentral_primary_oai_pubmedcentral_nih_gov_2232759 |
| source | PubMed Central Free; MEDLINE |
| subjects | Database Management Systems Databases as Topic - organization & administration Hospital Information Systems - organization & administration Humans Medical Records Systems, Computerized - organization & administration Time |
| title | Applying temporal joins to clinical databases |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2024-12-20T10%3A30%3A30IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-proquest_pubme&rft_val_fmt=info:ofi/fmt:kev:mtx:journal&rft.genre=article&rft.atitle=Applying%20temporal%20joins%20to%20clinical%20databases&rft.jtitle=Proceedings%20-%20AMIA%20Symposium&rft.au=O'Connor,%20M%20J&rft.date=1999&rft.spage=335&rft.epage=339&rft.pages=335-339&rft.issn=1531-605X&rft_id=info:doi/&rft_dat=%3Cproquest_pubme%3E69281073%3C/proquest_pubme%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_pqid=69281073&rft_id=info:pmid/10566376&rfr_iscdi=true |