IRMA-International.org: Creator of Knowledge
Information Resources Management Association
Advancing the Concepts & Practices of Information Resources Management in Modern Organizations

Enforcing Data Integrity in Pharmacy

Enforcing Data Integrity in Pharmacy
View Sample PDF
Author(s): C. David Butler (Teradata, Inc., USA)
Copyright: 2012
Pages: 20
Source title: Pharmacoinformatics and Drug Discovery Technologies: Theories and Applications
Source Author(s)/Editor(s): Tagelsir Mohamed Gasmelseid (King Faisal University, Kingdom of Saudi Arabia)
DOI: 10.4018/978-1-4666-0309-7.ch015

Purchase

View Enforcing Data Integrity in Pharmacy on the publisher's website for pricing and purchasing information.

Abstract

Data integrity is essential to every organization and to every healthcare practitioner in order to ensure the correct use of patient information to optimize care. It provides the assurance that the data you see every day is the same as it was the day before. It assures you that the drug dosage regimen “QID,” whether you define it as four times daily or four times daily with meals and at bedtime, is applied using the same parameters for every patient, as you define a patient, across every day (or any time period), as you define day in your health care setting. Definitions about data must be made by the business person (the practitioner), rather than by Information Technology (IT). Only by doing this can appropriate business rules by applied by a database, which manages the information used in electronic medical records. Once a decision is made about what a datum represents, whether by an individual or a group, it is imperative that the decision remain consistent over time. Should the definition evolve, it is also imperative that that evolution be tracked. Thus, organizations must establish governance committees to maintain consistency both across an organization and across time. Governance committees must have the highest level of authority to ensure that rules are not overridden on a casual, intermittent basis. Once business rules for data have been established, use of a relational database provides one of the strongest tools for ensuring that data integrity is maintained. This chapter explores the concepts serving as the foundation for today’s relational database management systems. A top-down approach is described using an Entity-Relationship diagram that can be used to create a relational model for implementation in a relational database management system. A bottom-up approach is described using functional dependencies and normalization. A pharmacist should be able to apply these concepts in corporation with a database architect to ensure the appropriate, consistent use of drug data within an organization. A pharmacist must be able to validate all drug information being used across the organization in order to minimize medication errors and optimize patient care. Only by being the subject matter expert on governance committees and working closely with IT and quality assurance can pharmacy maintain appropriate control over the use of drug information by healthcare technology.

Related Content

Linkon Chowdhury, Md Sarwar Kamal, Shamim H. Ripon, Sazia Parvin, Omar Khadeer Hussain, Amira Ashour, Bristy Roy Chowdhury. © 2024. 20 pages.
Mousomi Roy. © 2024. 21 pages.
Nassima Dif, Zakaria Elberrichi. © 2024. 20 pages.
Pyingkodi Maran, Shanthi S., Thenmozhi K., Hemalatha D., Nanthini K.. © 2024. 16 pages.
Mohamed Nadjib Boufenara, Mahmoud Boufaida, Mohamed Lamine Berkane. © 2024. 16 pages.
Meroua Daoudi, Souham Meshoul, Samia Boucherkha. © 2024. 25 pages.
Zhongyu Lu, Qiang Xu, Murad Al-Rajab, Lamogha Chiazor. © 2024. 56 pages.
Body Bottom