Database Management

Define each of the following terms:

a. Data administration: Data administration is a information or a computer science department in the organization which plans, controls, organizes , and executes data resources

b. Database administration: A database administrator is in charge for logical and physical design of databases. Apart from that he is also responsible for their recoverability, integrity, security , availability , and their performance

c. Two-phase locking protocol: the two phase locking protocol occurs in two different sequential phases during the transactions execution

They are 1) expanding phase

2) Shrinking phase

In this we can’t achieve the lock if once lock is released

d. Information repository: A Information repository is a gathering of interrelated information kept up over a system on different servers. It makes a brought together asset for anybody associated with the system work to get to when they require data. Various organisations use data archives to handle their information and may connect with others to share material as essential

e. Locking: Locking is the widely used universal type of concurrency control mechanism

Data can be obtained by an active user for updating. other users must be denied or locked until updating is complete

f. Versioning: A way to deal with simultaneousness control in which every exchange is confined to a perspective of the database as of the time that exchange began, and when an exchange changes a record, the DBMS makes another record adaptation as opposed to overwriting the old record. Consequently, no type of locking is required.

g. Deadlock: An impasse that outcomes when two or more exchanges have lockeda regular asset, and eachwaits for the other to unlock that asset.

h. Transaction: A discrete unit of work that should be totally handled or not prepared at all inside of a PC framework. Entering a client request is a case of an exchange.

i. Encryption: The change of a...