Hi,
In this post we will discuss about Teradata DBA basic concepts:
1). Some of the functions of a Teradata Database Administrator (DBA) include:
- User and Database Management
- Space Allocation and Usage
- Access of Objects (e.g., tables, views, etc.)
- Access Control and Security
- System Maintenance
- System Performance
- Resource Monitoring
- Data Archives, Restores, and Recovery
2). Examples of tools available to the Teradata DBA include:
- Use of Data Dictionary/Directory tables and views to manage the system
- Teradata Administrator – Windows administration utility
- Teradata Manager – suite of Windows tools
- Teradata Analyst Toolset – Index Wizard, Statistics Wizard, and Teradata SET
- Teradata Dynamic Query Manager (DQM)
- Database Console Window and System utilities – e.g., dbscontrol, ferret, rebuild, etc.
- User scripts and 3rd party applications
3). To do these functions, it is important to understand key concepts such as …
- Teradata hierarchy and the concepts of ownership (parents and children)