close
test_template

The Integrity of Database System

About this sample

About this sample

close

Words: 487 |

Page: 1|

3 min read

Published: Nov 16, 2018

Words: 487|Page: 1|3 min read

Published: Nov 16, 2018

The integrity of the system refers to the correctness and uniformity of that particular system. The integrity of database system refers to the correctness and constancy of that particular data placed in the database.

'Why Violent Video Games Shouldn't Be Banned'?

The integrity check is categorized into two modes

  • Implicit check mode
  • Explicit check mode

Implicit checks are those which allow domain, tabular and referential constraints same as they applied in the rules of the relational model. Explicit checks are those, which enforces to apply the rules of the administration and management control provided by the DDBMS. As specified explicit checks are one of the two key elements (along with views) of certificate endorsement of the relational database architectures.

According to Bell and Grisom [BellGris92], security of data integrity is quite difficult in a heterogeneous distributed environment as compared to homogeneous one. The extent of main central control states the level of complexity to manage the integrity constraints. High main central control is inversely proportional to hard to manage the integrity checks. In homogenous distributed environment has very strong central control because the DBMS schemas of each database site are same. However, the integrity checks are easily satisfied in the homogenous environment. While on the other hand in heterogeneous distributed network the DBMS schemas of multiple organizations on some site are dissimilar, so in heterogeneous environment, many problems will arise that threaten the integrity of distributed data.

There is a list of 3 problems that arise due to heterogeneous behavior:

  • Contradiction among local integrity checks
  • Hard to defining global integrity checks
  • Contradiction among local and global checks

Local integrity checks are easy to implement in a distributed environment because it is confined to respective site organization. While on the other hand global integrity checks are separated from the respective organizations. It was taken into account as a whole database. It may not ever be applicable to alter the structure of whole organization just to configure the distributed environment conformably.

Bell and Grisom explain that local integrity checks relatively differ in the heterogeneous distributed database. The differences check from the differences in the respective organizations. This contradiction can lead to the problems, peculiarly with particular composite queries that depend on data that reside on multiple sites in the database. The strategy adopted to accomplish global integrity checks can reduce the inconsistency between individual databases. But it is not as simple to implement as simple to say .while alternatively global integrity checks are placed estranged from the individual organizations. An accomplishment of the distributed environment by changing the architectural model of individual site databases is the very impractical way.

Get a custom paper now from our expert writers.

Eventually, it will result in a contradiction between local and global checks. The level of central control is related to the Inconsistencies present. If there is strong global control, the global integrity check will take primacy. If central control is not sufficiently strong, local integrity checks will be prior.

Image of Alex Wood
This essay was reviewed by
Alex Wood

Cite this Essay

The Integrity of Database System. (2018, November 15). GradesFixer. Retrieved March 29, 2024, from https://gradesfixer.com/free-essay-examples/the-integrity-of-database-system/
“The Integrity of Database System.” GradesFixer, 15 Nov. 2018, gradesfixer.com/free-essay-examples/the-integrity-of-database-system/
The Integrity of Database System. [online]. Available at: <https://gradesfixer.com/free-essay-examples/the-integrity-of-database-system/> [Accessed 29 Mar. 2024].
The Integrity of Database System [Internet]. GradesFixer. 2018 Nov 15 [cited 2024 Mar 29]. Available from: https://gradesfixer.com/free-essay-examples/the-integrity-of-database-system/
copy
Keep in mind: This sample was shared by another student.
  • 450+ experts on 30 subjects ready to help
  • Custom essay delivered in as few as 3 hours
Write my essay

Still can’t find what you need?

Browse our vast selection of original essay samples, each expertly formatted and styled

close

Where do you want us to send this sample?

    By clicking “Continue”, you agree to our terms of service and privacy policy.

    close

    Be careful. This essay is not unique

    This essay was donated by a student and is likely to have been used and submitted before

    Download this Sample

    Free samples may contain mistakes and not unique parts

    close

    Sorry, we could not paraphrase this essay. Our professional writers can rewrite it and get you a unique paper.

    close

    Thanks!

    Please check your inbox.

    We can write you a custom essay that will follow your exact instructions and meet the deadlines. Let's fix your grades together!

    clock-banner-side

    Get Your
    Personalized Essay in 3 Hours or Less!

    exit-popup-close
    We can help you get a better grade and deliver your task on time!
    • Instructions Followed To The Letter
    • Deadlines Met At Every Stage
    • Unique And Plagiarism Free
    Order your paper now