Application: Planning a Database

Lead-in

We live in a world where technology is key to finding and utilizing information quickly. Healthcare has traditionally lagged behind the rest of the world in embracing technology. For this industry, technology is important in the management of health information. Although paper-based solutions are still prevalent and work efficiently in some contexts, they are limited in important functionality.

The healthcare industry, as it recognizes the need for technology, more frequently relies upon systems, such as clinical and administrative information systems, to manage and provide needed information.

At the heart of these systems are databases, which are structured collections of data. Databases allow for the easy retrieval of stored data and the capability to efficiently manage large volumes of data. Since important health-related information is derived from data, the electronic storage and easy retrieval of data can ultimately impact the quality of care and coordination of services.

Directions

Refer to the various case studies presented in this week's readings showcasing how electronic health records and health technology (HITECH) are improving patient and community health. Now imagine your own health scenario in which a database could be used to improve the quality of care and the coordination of healthcare and services.

Briefly describe your scenario and how your database will be used .

What type of data would be collected and stored?

What are 2-3 elements of design that are important to consider when designing your database? Be sure to use your readings and the media for added support.

Readings

Centers for Medicare & Medicaid Services (2012).Electronic Health Records.

Retrieved from https://www.cms.gov/Medicare/E-Health/EHealthRecords/index.html?redirect=/EHealthRecords/

Meaningful Use Case Studies (n.d.). In HealthIT.gov.

Retrieved from http://www.healthit.gov/providers-professionals/meaningful-use-case-studies

Campbell, R. J. (n.d.). Database Design: What HIM Professionals Need to Know. Perspectives in Health Information Management.

Retrieved from http://library.ahima.org/xpedio/groups/public/documents/ahima/bok1_024637.hcsp?dDocName=bok1_024637

eHealth Initiative. (2011). Health Information Exchange: From meaningful use to personalized health. Oracle Health Sciences. Retrieved from:

http://www.oracle.com/us/industries/healthcare/health-meaningful-use-wp-497850.pdf

AHIMA e-HIM Workgroup on HIM in Health Information Exchange. (2007). HIM Principles in Health Information Exchange. Journal of AHIMA78(8).

Retrieved from http://library.ahima.org/xpedio/groups/public/documents/ahima/bok1_030532.hcsp?dDocName=bok1_030532

Wilkins, M. A. (2009). Factors influencing acceptance of electronic health records in hospitals. Perspectives in Health Information Management, (Fall 2009), 1-20.

Blumenthal, D. (2009). Stimulating the adoption of health information technology. New England Journal of Medicine 360(15),1477-1479.

The National Alliance for Health Information Technology (2008). Defining Key Health Information Technology Terms (Report to the Office of the National Coordinator for Health Information Technology, April 28 2008). Retrieved from U.S. National Library of Medicine website:

http://www.nlm.nih.gov/hsrinfo/informatics.html.

Optional Resources

Readings

Brown, S. H., Fischetti, L. F., Graham, G., et al. (2007). Use of electronic health records in disaster response: The experience of department of veterans affairs after Hurricane Katrina. American Journal of Public Health, 97(S1), 136-1 41.

National eHealth Collaborative. (2010, February 22). NHIN 101: An introduction to the nationwide health information network. Retrieved from

http://www.nationalehealth.org/nhin-100-series-spring-semester-2010

Websites

The eHealth Initiative

http://www.ehidc.org/

The eHealth Initiative is an organization that provides advocacy and resources for health information exchanges.

Microsoft HealthVault

https://www.healthvault.com/us/en

The HealthVault is a product developed by Microsoft that allows people to consolidate their personal health information online.

Media

Course Media: Laureate Education, Inc. (Executive Producer). (2009). Designing a database. Baltimore: Author.

The approximate length of this media piece is 7 minutes.

This media provides a simple example of how an effective relational database can be designed. The example shows the relationships between each element in the sample database.

Note: As a reminder, additional Learning Resources for the week are listed below the Media Player. Be sure to scroll to the bottom of the web page to view the complete list of Required and Optional Resources.

If you experience technical difficulties viewing the Course Media through the Media Player, please contact your Student Support Team at 1-800-WALDENU or [email protected].