TERA DATA ONLINR TRAINING
Teradata could be a company develops and retails a electronic information service Management.wherever information given will manage store information and backup information, archiveinformation and restore information.
Teradata is thought as “Data warehouse Systems”. wherever multiple tasks square measuregathering and analyze the info.
There square measure totally different missions embody in Teradata DBA:
-> USER MANAGEMENT
-> OBJECT MANAGEMENT
-> house MANAGEMENT
-> RESTORE MANAGEMENT
-> INDEX MANAGEMENT
-> computer file SYSTEM
-> employment MANAGEMENT
USER MANAGEMENT: User Management accustomed assign profiles it contains grant and revoke it provides removing rights to different users and roles ex: we are able to modify passwords and moreinfo which may be rechanged etc…
OBJECT MANAGEMENT: it's accustomed produce, modify, update and delete the info from the info.
SPACE MANAGEMENT: it's accustomed reapportion the info that manages entire info from the system. By exploitation totally different techniques; we are able to manage house within the disk. Techniques like MULTI-VALUE Compression we are able to scale back the house in info.
RESTORE MANAGEMENT: Restoring Management is nothing however storing the data in info. Byexploitation “Teradata ARCMAIN”Utility.
INDEX MANAGEMENT: In DBA contains 2 kinds of indexes
i) Primary Index
ii) Secondary Index
Primary index contains distinctive key and info administrator itself defines primary index.Which distributes the info and access key.
Secondary index that allow’s foreign key operations info.
DISK FILE SYSTEM: computer file system is employed to store and retieve the info from directionsystem.
WORKLOAD MANAGEMENT: There square measure 2 kinds of question Management
i) Dynamic question
ii) info question
Dynamic question Manager that allows info administrator it classify question before execution of info.
Database question accustomed perform analysis.