What are the functions of a Teradata DBA?

1. User Management – Creation and managing Users, Databases, Roles, Profiles and Accounts.
2. Space Allocation – Assigning Permanent Space, Spool Space and Temporary Space.
3. Access of Database Objects – Granting and Revoking Access Rights on different database objects.
4. Security Control – Handling logon and logoff rules for Users.
5. System Maintenance – Specification of system defaults, restart etc.
6. System Performance – Use of Performance Monitor(PMON), Priority Scheduler and Job Scheduling.
7. Resource Monitoring – Database Query Log(DBQL) and Access Logging.
8. Data Archives, Restores and Recovery – ARC Utility and Permanent Journals.

Datawarehousing and its uses

Datawarehousing and its uses

• Analysis of data and History maintenance.
• Eg. Sales data or customer data history maintenance
• Eg. Analysis of sales based on geography and seasons
• Strategic data for organizations
• The operational software and databases are not suited to store strategic data
• Single place of storage
• Most data in large or medium sized organizations are stored in different databases and joining them to get a complete picture is difficult. Datawarehouses help in storing all data in a single system as they are capable to hold large amounts of data

Teradata Architecture