Data Dictionary and Transaction Log
What is Data dictionary?
Data dictionary is otherwise names as metadata repository, which contains the information about the data such as relationship, meaning, datatypes used etc. During the operation of a database, this data dictionary will be always checked.Passive data dictonary means, if the data dictionary is used only be the designers of the database and administrators while active data dictionary means the dictionary used by DBMS software too.
What is Transaction log?
It means the history of actions done by the DBMS software. It should be properly kept to ensure the acid properties.
Data dictionary is otherwise names as metadata repository, which contains the information about the data such as relationship, meaning, datatypes used etc. During the operation of a database, this data dictionary will be always checked.Passive data dictonary means, if the data dictionary is used only be the designers of the database and administrators while active data dictionary means the dictionary used by DBMS software too.
What is Transaction log?
It means the history of actions done by the DBMS software. It should be properly kept to ensure the acid properties.
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home