Loading…

Web client and ODBC access to legacy database information: a low cost approach

A new method has been developed for the Department of Orthopaedics of Vanderbilt University Medical Center to access departmental clinical data. Previously this data was stored only in the medical center's mainframe DB2 database, it is now additionally stored in a departmental SQL database. Acc...

Full description

Saved in:
Bibliographic Details
Published in:Proceedings - AMIA Annual Fall Symposium 1997, p.799-803
Main Authors: Sanders, N W, Mann, 3rd, N H, Spengler, D M
Format: Article
Language:English
Subjects:
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
cited_by
cites
container_end_page 803
container_issue
container_start_page 799
container_title Proceedings - AMIA Annual Fall Symposium
container_volume
creator Sanders, N W
Mann, 3rd, N H
Spengler, D M
description A new method has been developed for the Department of Orthopaedics of Vanderbilt University Medical Center to access departmental clinical data. Previously this data was stored only in the medical center's mainframe DB2 database, it is now additionally stored in a departmental SQL database. Access to this data is available via any ODBC compliant front-end or a web client. With a small budget and no full time staff, we were able to give our department on-line access to many years worth of patient data that was previously inaccessible.
format article
fullrecord <record><control><sourceid>proquest_pubme</sourceid><recordid>TN_cdi_pubmedcentral_primary_oai_pubmedcentral_nih_gov_2233436</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>79382926</sourcerecordid><originalsourceid>FETCH-LOGICAL-p329t-f7ed68ab03dc44b67ff280ec16caea1199af0003823100e5fa93f67c70db33553</originalsourceid><addsrcrecordid>eNpVkD1PwzAQhj2ASin8BCRPbJHsXGPHDEhQPqWKLiBG6-LYrZEThzgF9d8TRIVguuHufZ5Xd0CmnCmelXnJjshxSm-MCc64mJCJgkJKKKbk6dVW1ARv24FiW9PVzfWCojE2JTpEGuwazY7WOGCFyVLfutg3OPjYXlCkIX5SE9MY7bo-otmckEOHIdnT_ZyRl7vb58VDtlzdPy6ullkHuRoyJ20tSqwY1GY-r4R0bixpDRcGLXKuFDrGGJQ5cMZs4VCBE9JIVlcARQEzcvnD7bZVY2sz1u8x6K73DfY7HdHr_5vWb_Q6fug8B5iDGAHne0Af37c2DbrxydgQsLVxm7RUo1zl34dnf02_iv0H4QvzXmyg</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>article</recordtype><pqid>79382926</pqid></control><display><type>article</type><title>Web client and ODBC access to legacy database information: a low cost approach</title><source>PubMed Central (Open Access)</source><creator>Sanders, N W ; Mann, 3rd, N H ; Spengler, D M</creator><creatorcontrib>Sanders, N W ; Mann, 3rd, N H ; Spengler, D M</creatorcontrib><description>A new method has been developed for the Department of Orthopaedics of Vanderbilt University Medical Center to access departmental clinical data. Previously this data was stored only in the medical center's mainframe DB2 database, it is now additionally stored in a departmental SQL database. Access to this data is available via any ODBC compliant front-end or a web client. With a small budget and no full time staff, we were able to give our department on-line access to many years worth of patient data that was previously inaccessible.</description><identifier>ISSN: 1091-8280</identifier><identifier>PMID: 9357735</identifier><language>eng</language><publisher>United States: American Medical Informatics Association</publisher><subject>Computer Communication Networks ; Computer Systems ; Databases as Topic - organization &amp; administration ; Hospital Departments ; Information Storage and Retrieval ; Methods ; Orthopedics ; Software ; User-Computer Interface</subject><ispartof>Proceedings - AMIA Annual Fall Symposium, 1997, p.799-803</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/PMC2233436/pdf/$$EPDF$$P50$$Gpubmedcentral$$H</linktopdf><linktohtml>$$Uhttps://www.ncbi.nlm.nih.gov/pmc/articles/PMC2233436/$$EHTML$$P50$$Gpubmedcentral$$H</linktohtml><link.rule.ids>230,314,723,776,780,881,4010,53766,53768</link.rule.ids><backlink>$$Uhttps://www.ncbi.nlm.nih.gov/pubmed/9357735$$D View this record in MEDLINE/PubMed$$Hfree_for_read</backlink></links><search><creatorcontrib>Sanders, N W</creatorcontrib><creatorcontrib>Mann, 3rd, N H</creatorcontrib><creatorcontrib>Spengler, D M</creatorcontrib><title>Web client and ODBC access to legacy database information: a low cost approach</title><title>Proceedings - AMIA Annual Fall Symposium</title><addtitle>Proc AMIA Annu Fall Symp</addtitle><description>A new method has been developed for the Department of Orthopaedics of Vanderbilt University Medical Center to access departmental clinical data. Previously this data was stored only in the medical center's mainframe DB2 database, it is now additionally stored in a departmental SQL database. Access to this data is available via any ODBC compliant front-end or a web client. With a small budget and no full time staff, we were able to give our department on-line access to many years worth of patient data that was previously inaccessible.</description><subject>Computer Communication Networks</subject><subject>Computer Systems</subject><subject>Databases as Topic - organization &amp; administration</subject><subject>Hospital Departments</subject><subject>Information Storage and Retrieval</subject><subject>Methods</subject><subject>Orthopedics</subject><subject>Software</subject><subject>User-Computer Interface</subject><issn>1091-8280</issn><fulltext>true</fulltext><rsrctype>article</rsrctype><creationdate>1997</creationdate><recordtype>article</recordtype><recordid>eNpVkD1PwzAQhj2ASin8BCRPbJHsXGPHDEhQPqWKLiBG6-LYrZEThzgF9d8TRIVguuHufZ5Xd0CmnCmelXnJjshxSm-MCc64mJCJgkJKKKbk6dVW1ARv24FiW9PVzfWCojE2JTpEGuwazY7WOGCFyVLfutg3OPjYXlCkIX5SE9MY7bo-otmckEOHIdnT_ZyRl7vb58VDtlzdPy6ullkHuRoyJ20tSqwY1GY-r4R0bixpDRcGLXKuFDrGGJQ5cMZs4VCBE9JIVlcARQEzcvnD7bZVY2sz1u8x6K73DfY7HdHr_5vWb_Q6fug8B5iDGAHne0Af37c2DbrxydgQsLVxm7RUo1zl34dnf02_iv0H4QvzXmyg</recordid><startdate>1997</startdate><enddate>1997</enddate><creator>Sanders, N W</creator><creator>Mann, 3rd, N H</creator><creator>Spengler, D M</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>1997</creationdate><title>Web client and ODBC access to legacy database information: a low cost approach</title><author>Sanders, N W ; Mann, 3rd, N H ; Spengler, D M</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-p329t-f7ed68ab03dc44b67ff280ec16caea1199af0003823100e5fa93f67c70db33553</frbrgroupid><rsrctype>articles</rsrctype><prefilter>articles</prefilter><language>eng</language><creationdate>1997</creationdate><topic>Computer Communication Networks</topic><topic>Computer Systems</topic><topic>Databases as Topic - organization &amp; administration</topic><topic>Hospital Departments</topic><topic>Information Storage and Retrieval</topic><topic>Methods</topic><topic>Orthopedics</topic><topic>Software</topic><topic>User-Computer Interface</topic><toplevel>peer_reviewed</toplevel><toplevel>online_resources</toplevel><creatorcontrib>Sanders, N W</creatorcontrib><creatorcontrib>Mann, 3rd, N H</creatorcontrib><creatorcontrib>Spengler, D M</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 Annual Fall Symposium</jtitle></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext</fulltext></delivery><addata><au>Sanders, N W</au><au>Mann, 3rd, N H</au><au>Spengler, D M</au><format>journal</format><genre>article</genre><ristype>JOUR</ristype><atitle>Web client and ODBC access to legacy database information: a low cost approach</atitle><jtitle>Proceedings - AMIA Annual Fall Symposium</jtitle><addtitle>Proc AMIA Annu Fall Symp</addtitle><date>1997</date><risdate>1997</risdate><spage>799</spage><epage>803</epage><pages>799-803</pages><issn>1091-8280</issn><abstract>A new method has been developed for the Department of Orthopaedics of Vanderbilt University Medical Center to access departmental clinical data. Previously this data was stored only in the medical center's mainframe DB2 database, it is now additionally stored in a departmental SQL database. Access to this data is available via any ODBC compliant front-end or a web client. With a small budget and no full time staff, we were able to give our department on-line access to many years worth of patient data that was previously inaccessible.</abstract><cop>United States</cop><pub>American Medical Informatics Association</pub><pmid>9357735</pmid><tpages>5</tpages></addata></record>
fulltext fulltext
identifier ISSN: 1091-8280
ispartof Proceedings - AMIA Annual Fall Symposium, 1997, p.799-803
issn 1091-8280
language eng
recordid cdi_pubmedcentral_primary_oai_pubmedcentral_nih_gov_2233436
source PubMed Central (Open Access)
subjects Computer Communication Networks
Computer Systems
Databases as Topic - organization & administration
Hospital Departments
Information Storage and Retrieval
Methods
Orthopedics
Software
User-Computer Interface
title Web client and ODBC access to legacy database information: a low cost approach
url http://sfxeu10.hosted.exlibrisgroup.com/loughborough?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-10T13%3A08%3A19IST&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=Web%20client%20and%20ODBC%20access%20to%20legacy%20database%20information:%20a%20low%20cost%20approach&rft.jtitle=Proceedings%20-%20AMIA%20Annual%20Fall%20Symposium&rft.au=Sanders,%20N%20W&rft.date=1997&rft.spage=799&rft.epage=803&rft.pages=799-803&rft.issn=1091-8280&rft_id=info:doi/&rft_dat=%3Cproquest_pubme%3E79382926%3C/proquest_pubme%3E%3Cgrp_id%3Ecdi_FETCH-LOGICAL-p329t-f7ed68ab03dc44b67ff280ec16caea1199af0003823100e5fa93f67c70db33553%3C/grp_id%3E%3Coa%3E%3C/oa%3E%3Curl%3E%3C/url%3E&rft_id=info:oai/&rft_pqid=79382926&rft_id=info:pmid/9357735&rfr_iscdi=true