Explain database security issues - Essay Example

College: Explain Database Security Issues What is Metadata? Metadata refers to the data used in of other data. Metadata illustrates the quality, content, condition, as well as other features concerning data inscribe in an ordinary FGDC layout. The role of metadata is helping individuals in locating, as well as understanding, data. It also offers the history of given data by describing the data’s structure and content, its generator and preserver, its time of collection and publication, its geographic or storage location, reason for its creation, and means of producing, processing, or modelling it (Cox et al, 2012).

A Concurrent Update A concurrent update refers to the situation in which more than one user make an update to one database within the same time (Pratt & Adamski, 2011). Locking and What it Accomplishes Locking refers to the means of synchronization of potentially simultaneous database or even other ordinary resource’s utilization. In operating systems, locking helps in enforcing and ascertaining the occurrence of events in the appropriate series (Pratt & Adamski, 2011). Encryption and Relation to Security As the most effective means of enhancing security of data, encryption refers to the translation of data into ciphertext form, which cannot be understood easily by illicit individuals.

Therefore, encryption involves the conversion of essential data into secret codes. Encrypted data is sent in codes instead of plain, simple words making it necessary for the receiver’s computer to decrypt such data for one’s display. The reader of such data requires a secret password or key to enhance decryption of the data (Pratt & Adamski, 2011).Use of Views in Improving Security Views refer to the saved select statements, which permit an individual to work upon the outcomes returned from them.

Views are essential in provision of column- or row-level data access, wrapping up sophisticated joints, executing sophisticated collective queries, and tailoring data display (Singh & Kanjilal, 2009). Views are fundamental security tools, habitually utilized in thwarting users from having unrestricted access to tables whereas permitting them to operate with the presented data. All consents can be eradicated from the principal tables, and provided the table’s owner is the view’s owner, the user will have the ability of interacting with the given data, but based on authorizations approved to the view (Pratt & Adamski, 2011).

What is Replication? Duplication (replication) refers to a set of catalog objects and data copying and distribution technologies from a given folder into another. This is followed by the sychronization between the two databases in order to uphold uniformity. In the process, a database is copied from one server into another, followed by protection of the dissimilar copies in concurrence. Data replication, on the other hand, denotes copying of a given set of data from one data site into another during replication of data (Pratt & Adamski, 2011).

What is Synchronization? Sychronization refers to the process via which DPM (data protection manager) shifts data alterations into DPM servers from protected file servers, followed by the application of such changes in duplication of protected data. It is a precise process of toning or orchestrating multiple devices, processes, or activities in time. Synchronization takes place when mobile devices correspond with a server or personal computer’s applications. The DPM depends on synchronization in order to maintain the synchronization of the copies with the cosseted data on file servers (Singh & Kanjilal, 2009).

ReferencesCox, M., Mulder, E., & Tadic, L. (2012). Descriptive Metadata for Television: An End-to-End Introduction. London: CRC Press.Pratt, P.J., & Adamski, J.J (2011). Concepts of Database Management. London: Cengage Learning. Singh, R., & Kanjilal, J. (2009). Pro Sync Framework. Berkeley, CA: Apress.