Database integrity controls

5 Conclusion………………………………………………………………………………. 6 DATABASE INTEGRITY CONTROLS Abstract Data integrity has been defined as the ability of a set of data to accurate and reliable over the whole period it will be used. The security and the integrity of data might be two concepts with different components but they go hand in hand such that data cannot be insecure and expect it to be uncorrupted. Secure data is also consistent throughout its lifetime and this is what is needed for data to be relied upon. Introduction Over the past few years, data integrity and issues about the interference of other person's data by intruders have become an issue of great concern all over the world. Many users will use the excess privileges given to them to access the database for day to day job opportunities and get access to private information either intentionally or unintentionally (Grefen & Apers 2014).

This can create a great risk to the organization because the users can sell out the data to rivals. To control this, the organization can use query-level access control where the user privileges are restricted to what is required for their daily operations. Weak authentication is also a threat to database security and this gives attackers the ability to become the authorized database users. The attacker can do anything to these databases because they have full access to them. Despite the numerous advantages posed by blockchain based databases, they also have limitations in their operations. Skilled personnel and the relevant technical expertise are needed for the success of these databases to be realized. The organization also needs to have a clear vision of why it needs to use the blockchain database as a solution in its operations.

Most organizations and companies are however finding it difficult to use this technology because of the issues associated with compliance with the General Data Protection Regulation set by the European Union. It provides that users have the right to control the access to personal data as well as forgetting it but this is not permitted with blockchain databases. Conclusion Blockchains have been able to offer solutions to the problem of having immutable and a consistent sharing of data among applications which conventional datastores have been unable to provide. They are however faced by the problem of inefficient energy use and are also hard to scale. References Coronel, C. , & Morris, S. Database systems: design, implementation, & management. , & Apers, P. M. Integrity control in relational database systems—an overview.