Mastering Data Integrity: The Ultimate Guide to Concepts and Controls That Will Keep Your Data Safe and Secure!

My InfoTech Journal:

Mastering Data Integrity: The Ultimate Guide to Concepts and Controls That Will Keep Your Data Safe and Secure!

Data Integrity refers to the accuracy, consistency, and reliability of data throughout its life cycle. There are several types of data integrity concepts and data integrity controls that can be used to maintain data integrity. Here are some of the most common types.

Types of Data Integrity Concepts:

Entity Integrity

This refers to the concept that each row of data in a database table should be uniquely identified. It means that a primary key must be created for each row in the table.

Referential Integrity

This refers to the concept that the relationship between tables in a database must be maintained. It means that foreign keys must be used to ensure that data in one table relates to data in another table.

Domain Integrity

This refers to the concept that data entered into a database should conform to defined rules or constraints. For example, a phone number field may only allow 10 digits.

User-Defined Integrity

This refers to the concept that organizations can define their own data integrity rules that are specific to their business requirements. For example, a bank may require that all transactions over a certain amount must be approved by a manager.

Types of Data Integrity Controls:

Access Controls

Access controls limit the access to data to only those who are authorized to view or modify it. This control includes password protection, role-based access, and user permissions.

Data Validation

Data validation is the process of verifying data to ensure it is accurate and complete. This control includes data scrubbing, data verification, and data correction.

Backup and Recovery

Backup and recovery procedures are put in place to protect data in the event of a data loss. This control includes regular backups, testing of backups, and disaster recovery planning.

Change Control

Change control is the processof managing changes to data or systems. This control includes documentation of changes, testing of changes, and approval of changes.

Auditing

Auditing is the process of reviewing and monitoring data to ensure it is accurate and secure. This control includesperiodic audits, review of audit logs, and investigation of suspicious activity.

In summary, there are several types of data integrity concepts and data integrity controls that organizations can use to maintain the accuracy, consistency, and reliability of their data.

Implementing these controls can help to protect the integrity of data and ensure that it remains trustworthy throughout its life cycle.

Disclaimer

This article is a result of my personal research and is not a substitute for legal advice. Please consult your Information Security Team, Legal Team, Ethics & Compliance, or Regulatory Team for the interpretation of specific Information Security requirements.

Support My InfoTech Journal

Comments

POPULAR: My InfoTech Journal

Network Security: How to minimize the Risk of your Wireless Network

My InfoTech Journal: What you can do to minimize the risk of your wireless network? Access Points are usually targets for unauthorized access. You have to ensure that your access points are secured to prevent unauthorized access. There are several ways of securing your wireless access points. Here is a Security Tip from the US CISA. Change default password. Restrict access. Encrypt the data on your network. Protect your Service Set Identifier (SSID). Install a Firewall. Maintain Anti-Virus software.I Use file sharing with caution. Keep your access point software patched and up to date. Check your internet provider’s router or router manufacturers wireless security options. Connect Using Virtual Private Network (VPN). A more detailed discussion of this tip can be found in this post: US CISA: Security Tip (ST 005-003) Securing Wireless Networks End Notes US CISA: Security Tip Disclaimer This article is a result of my personal research and is not a substitute for legal advise. Ple

MORE of My InfoTech Journal »

Information Security Tenets (The CIA Triad)

My InfoTech Journal: Information Security Tenets The CIA Triad The three tenets or fundamental principles of Information Security are Confidentiality , Integrity , and Availability . This is also commonly known as the CIA Triad . The Information Security programs refers to the controls designed and implemented to protect these three tenets: Confidentiality , Integrity , and Availability . What is Confidentiality? Confidentiality ensures that private information remains private and that these private information can only be accessed or viewed by authorized individuals on need to know basis. Information Security controls must therefore be put in place to protect the data from unauthorized disclosure. Examples of Information Security controls to ensure Data Confidentiality : Access Control List (ACL) Username and Password Encryption Two-Factor Authentication (Password, Token, PIN, Biometric, etc) What is Integrity? Integrity refers to the accuracy and completeness of t

MORE of My InfoTech Journal »

How to Improve Employees’ CyberSecurity Awareness (From Weakest Link to Fist Line of Defence)

My InfoTech Journal: How to Improve Employees’ CyberSecurity Awareness (From Weakest Link to Fist Line of Defence) Your Employees may be the weakest link in the CyberSecurity chain, BUT, You can train them to be part of your first line of defence. Improving Employees’ CyrberSecurity know-how will depend greatly on your company’s CyberSecurity Awareness Program. This must be aimed to strengthen your first line of defence. There must be a CyberSecurity Awareness Program to ensure everyone is aligned with the company’s principles, policies and procedures. The CyberSecurity Awareness Program should promote everyone’s inclusion and a culture that CyberSecurity is everyone’s responsibility. The CyberSecurity Awareness Courses will also help everyone in the company to be in the same page against malicious attacks. The CyrberSecurity Training should be regularly deployed to the Employees. The CyberSecurity courses should be designed to include training Employees on the different human-ba

MORE of My InfoTech Journal »

Information Security

My InfoTech Journal: Information Security Information Security is always a very interesting domain for discussion. Over the years, Information Security has evolved as a domain that requires more and more stringent security controls in order to comply with growing compliance requirements and most importantly to protect corporate sensitive data, confidential, personal information, and other critical data. There are several Information Security Standards or Frameworks available in the industry to choose from. But there is no one standard that can claim the title of being an all-in-one package solution. So if you are into Information Security compliance, you need to understand your organization to know what standards will best fit your compliance requirement. In some cases, you will have to implement combinations of industry standards for your compliance governance program. Back in the days, I was involved in an outsourcing project as an Account Security Officer (ASO) for a large corpo

MORE of My InfoTech Journal »

Introduction to SOX Compliance

My InfoTech Journal: Introduction to SOX Compliance Sarbanes-Oxley Act of 2002 is defined as “An Act to protect investors by improving the accuracy and reliability of corporate disclosures made pursuant to the securities laws, and for other purposes.” 1 Sarbanes-Oxley Act or more commonly known as SOX , is a Federal Law which was enacted on 30-July-2002. The Sarbanes-Oxley Act was known in the US Senate as the “ Public Company Accounting Reform and Investor Protection Act ” and known in the US House as the “ Corporate and Auditing Accountability, Responsibility, and Transparency Act ”. This law was enacted as a response to a number of major corporate and accounting scandals including Enron and WorldCom. 2 The Sarbanes-Oxley Act defined “ A violation by any person of this Act, any rule or regulation of the Commission issued under this Act, or any rule of the Board shall be treated for all purposes in the same manner as a violation of the Securities Exchange Act of 1934 (15

MORE of My InfoTech Journal »

CyberSecurity Predictions for 2022 and Beyond

My InfoTech Journal: CyberSecurity Predictions for 2022 and Beyond Today’s post will focus on the latest report released by Mandiant titled “ 14 CyberSecurity Predictions for 2022 and Beyond ”. Mandiant identified 14 predictions which are focused on seven main CyberSecurity threat areas: 1. Ransomware and multifaceted extortion in the spotlight 2. Outlook on major nation-state actors: The Big Four 3. Events in the Afghanistan trigger espionage and information operations 4. Deepfakes: Not just for information operations 5. Cyber outsourcing increases velocity and impact of malicious operations 6. Cloud and Third Parties introduce new chokepoints 7. More internet of things devices, more vulnerabilities, more attacks 14 CyberSecurity Predictions for 2022 and Beyond Here’s a snapshot of the 14 CyberSecurity Predictions for 2022 and Beyond Ransomware and multifaceted extortion in the spotlight 1. No End in Sight: Increased Frequency and Expanding Tactics The Ransomware Threat will c

MORE of My InfoTech Journal »

Network Security: How to Secure Your Network

My InfoTech Journal: Network Security To set the context of this domain, I have here several definitions from different service providers. Network Security refers to the practices of protecting computer network from intruders, including both wired and wireless connections. - US CISA Network Security is any activity designed to protect the usability and integrity of your network and data. It includes both hardware and software technologies. Effective network security manages access to the network. It targets a variety of threats and stops them from entering or spreading on your network. - Cisco Network Security combines multiple layers of defenses at the edge and in the network. Each network security layer implements policies and controls. Authorized users gain access to network resources, but malicious actors are blocked from carrying out exploits and threats. - Cisco Network Security are measures taken to protect a communications pathway from unauthorized access to, and accidenta

MORE of My InfoTech Journal »

What is General Data Protection Regulation (GDPR)

My InfoTech Journal: General Data Protection Regulation (GDPR) The General Data Protection Regulation , also known as GDPR is regulation under the European Union (EU) Law that mandates data security and privacy. The General Data Protection Regulation ( GDPR) was passed by the European Parliament in 14-Apr-2016 and which became effective on 25-May-2018. The main objective of GDPR is to ensure that individuals under the European Economic Area (EEA) have control and rights over their personal information. The GDPR also aims to simplify the regulatory requirements for international business. GDPR Protection Principles 1 Lawfulness, fairness and transparency — Processing must be lawful, fair, and transparent to the data subject. Purpose limitation — You must process data for the legitimate purposes specified explicitly to the data subject when you collected it. Data minimization — You should collect and process only as much data as absolutely necessary for the purposes s

MORE of My InfoTech Journal »

CyberSecurity Vulnerabilities in Control Systems

My InfoTech Journal: CyberSecurity Vulnerabilities in Industrial Control Systems For this article, I will be presenting an overview of CyberSecurity Vulnerabilities, using the US CyberSecurity & Infrastructure Security Agency (CISA) guidelines for Industrial Control Systems . Please note that this US CISA CyberSecurity guideline is specific to Industrial Control Systems. Nonetheless the framework and line of thought can be used as reference for any other similar environment. CyberSecurity aims to protect sensitive information hosted in critical systems from different faces of evolving threats. Year-by-year business reports would publish the cost of data breaches globally in millions of US dollars. This includes losses in business revenues, cost of responding to the breach, cost of deciphering the extent of the data breach, performing root cause analysis, and most of all the long term damage of the company reputation and brand. In order to protect your Control System’s risk and

MORE of My InfoTech Journal »