What Is Data Integrity And Why Is It Important In Databases?
To first understand what data integrity is, we must first and foremost understand what data exactly is and how it used within technology today.
Data, in the terms that we are using in it in development terms, consist of information. This information can be gathered by the developer, the web designer when using online forms. The items that we consider data, would be a user’s name, email address, password and even more. We can complete loan applications that require more personal and detailed information than just our first, last name and email address. We gather social security numbers, home addresses, and so much more information that is considered data, but also considered sensitive data.
According to Vera Code, to define data integrity would be
“Data integrity is a fundamental component of information security. In its broadest use, “data integrity” refers to the accuracy and consistency of data stored in a database, data warehouse, data mart or other construct.”
How Does User Input And User Interfaces Affect Data Quality And Data Integrity?
Although this article was written in 2012, the terms has not changed, but how we use it and collect has changed. Because of increase of online data breaches, consumers are warned daily to hold close to them who they trust when submitting data. Even just email address, or a phone number. Something we think is so simple, and usually request this type of data to create E-Marketing campaigns, our intentions are pure at heart.
However, I am sure that companies from Yahoo! to Equifax, thought the same thing until 2013 when Yahoo! (known for as an email account provider) encountered a massive data breach affected all three billion accounts. (Marcus, 2017)
According to Lucy Marcus, whom published an article titled Data Breaches: An Artifact of Indifference:
“Breaches can cripple companies both operationally and financially, owing to the direct theft of funds or intellectual property and the cost of plugging the security hole or paying punitive fines. They can also diminish a company’s reputation and credibility among investors, business partners, and communities, even in cases when the breach is minor and doesn’t compromise sensitive information.” (Marcus, 2017)
So how does this affect us, why are we even discussing this? Users trust that you have coded your input fields correctly, that the data you the developer request is secure, maintained, updated if need be, but the users relay on the developers, to create a safe secure user interface that will not only collect and store their personal information that we call data, but guard it.
Data, user interfaces, forms, controls, something we are all familiar with, there are many users that only understand the basics of that form, and that is that they need to fill it out. This could be to get SSI, Food Stamps, or anything. Government to small businesses, there is no in-between line. Data is data, it’s our information, our personal lives, and it effects more people know than before.
Marcus, L. P. (2017, October 23). Data Breaches: An Artifact of Indifference. Retrieved from Project Syndicate: https://search.proquest.com/docview/1954333141?accountid=41759
Teeling, M. (2012, May 14). What is Data Integrity? Learn How to Ensure Database Data Integrity via Checks, Tests, & Best Practices. Retrieved from VeraCode: https://www.veracode.com/blog/2012/05/what-is-data-integrity