Archiving data dictionary
A dictionary's actual meaning is a resource of words for a particular language, which provides their meaning. Similarly, we have this feature in Teradata Database.
The Teradata data dictionary (DD) is a complete database composed of system tables, views, and macros that reside in the Teradata system, called DBC. Data dictionary tables are dumped when you install the system. Users reference some of these tables with SQL requests, while others are used for system or data recovery only. Data dictionary views reference data dictionary tables. Views and macros are created by running Database Initialization Program (DIP) scripts.
Data dictionary tables are used to:
- Store definitions of objects you create (for example, databases, tables, indexes, and so on)
- Control access to data
- Record system events (for example, logon, console messages, and so on)
- Hold system message texts
- Record and control system restarts
- Accumulate accounting information
As we saw, DD tables include current...
