Skip to main content

My InfoTech Journal!

My InfoTech Journal: Decoding the Networking Enigma: OSI vs. TCP/IP Reference Models

My InfoTech Journal: Decoding the Networking Enigma: OSI vs. TCP/IP Reference Models The OSI (Open Systems Interconnection) Reference Model and the TCP/IP (Transmission Control Protocol/Internet Protocol) Reference Model: The OSI Reference Model and the TCP/IP Reference Model are both conceptual frameworks used to understand and standardize how different networking protocols and technologies interact. Here are some areas of comparison: 1. Number of Layers: OSI Model : It consists of seven layers: Physical, Data Link, Network, Transport, Session, Presentation, and  TCP/IP Model : It has four layers: Network Interface, Internet, Transport, and Application. 2. L ayer Functionality: OSI Model : Tends to be more comprehensive and abstract, defining each layer's functions independently. TCP/IP Model : Reflects the actual implementation of the Internet and focuses on how protocols are used in practice. 3. Adoption / Use: OSI Model : Less commonly used in practice, but it is still valuab...

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

Fortifying the Digital Frontier: Unmasking Network Security Risks and Solutions

Fortifying the Digital Frontier:  Unmasking Network Security Risks and Solutions It has been a while since my last post. I have been busy with work and learning Microsoft PowerBI and Power Automate. These are very good tools for dashboard creation and automation. Very easy to learn and use. Kudos to Microsoft for coming up with these great tools! Fast forward, I have recently enrolled in a Master of Information Systems (MIS) program via Distance Education. I am excited to be an online distance education student. It has been a    very long time since I was a student. I know there will be adjustments needed from me… to be diligent, to be disciplined in balancing my work-studies-life, and to persevere to achieve my goal of getting my Master’s Degree. I have decided to share my research in  MyInfoTech Journal  hoping these information will also be able to help those researching for similar topics. Today, I am researching on the  Network Layer  and its Secu...

MyInfoTechJournal: Never Let a Crisis Go to Waste: The Ultimate Business Continuity Plan (BCP) for Thriving in Any Situation (Part 3 of 3: EXAMPLE)

MyInfoTechJournal: Never Let a Crisis Go to Waste: The Ultimate Business Continuity Plan (BCP) for Thriving in Any Situation  (Part 3 of 3: EXAMPLE)

My InfoTech Journal: Unpacking the OSI Model: Your Guide to Networking Layers

My InfoTech Journal: Unpacking the OSI Model: Your Guide to Networking Layers The OSI (Open Systems Interconnection) reference model is a way to understand how different parts of computer networks communicate. Each layer having a specific job. 1. Physical Layer: This is the actual hardware, like cables and switches. Example: Ethernet cables connect devices in a network. 2. Data Link Layer: Ensures data is sent and received without errors within a local network. Example: Ethernet frames help in local data transfer. 3. Network Layer: Manages data routing between different networks. Example: IP (Internet Protocol) routers guide data between your home and a website. 4. Transport Layer: Ensures data arrives reliably and in order. Example: TCP (Transmission Control Protocol) guarantees error-free data transfer. 5. Session Layer: E stablishes, maintains, and ends connections between devices. Example: Setting up a video call on Skype. 6. Presentation Layer: Translates data into a format that ...

My InfoTech Journal: Decoding the Networking Enigma: OSI vs. TCP/IP Reference Models

My InfoTech Journal: Decoding the Networking Enigma: OSI vs. TCP/IP Reference Models The OSI (Open Systems Interconnection) Reference Model and the TCP/IP (Transmission Control Protocol/Internet Protocol) Reference Model: The OSI Reference Model and the TCP/IP Reference Model are both conceptual frameworks used to understand and standardize how different networking protocols and technologies interact. Here are some areas of comparison: 1. Number of Layers: OSI Model : It consists of seven layers: Physical, Data Link, Network, Transport, Session, Presentation, and  TCP/IP Model : It has four layers: Network Interface, Internet, Transport, and Application. 2. L ayer Functionality: OSI Model : Tends to be more comprehensive and abstract, defining each layer's functions independently. TCP/IP Model : Reflects the actual implementation of the Internet and focuses on how protocols are used in practice. 3. Adoption / Use: OSI Model : Less commonly used in practice, but it is still valuab...

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, Biome...

The Ultimate Guide to Protecting Your Company's Secrets and Personal Information - Don't Get Hacked!

My InfoTech Journal: The Ultimate Guide to Protecting Your Company's Secrets and Personal Information - Don't Get Hacked!

Are You Safe? The Shocking Truth About Privacy Risks and How to Protect Yourself

My InfoTech Journal: Are You Safe? The Shocking Truth About Privacy Risks and How to Protect Yourself

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 substitut...

Playbook for Conducting a Comprehensive IT Infrastructure Audit

Playbook for Conducting a Comprehensive IT Infrastructure Audit

Unlock the Secrets of the Top 10 Information Security Solutions and Safeguard Your Digital World!

{color: #000000; } My InfoTech Journal: Unlock the Secrets of the Top 10 Information Security Solutions and Safeguard Your Digital World!