how can i answer for question like teradat architecture in
interveiw

Answer Posted / sai

Teradata Architecture is shared nothing architecture(Data
stored in one AMP can not shared with another AMP)
It(TD Architecture) mainly consist of 4 components
PE,BYNET,AMP,vdisks
PE-Parsing Engine -The main function of PE is it handeles
the user session and checks for syntax and gives the
execution plan for all AMPS
BYNET- is banyan n/w it is communication layer b/w PE and
AMP whatever execution plan given by PE is transfered to
all AMPs with the help of BYNET.It also sends answerset to
the PE from the AMPs
AMP-Access Module processor-It is a virtual processor and
it handles some amount of databse space.It also uses
DBsubmanagement system to process query(like
create/manipulation)
vdisk-Virtual disk-Each AMP consist of its own vdisk to
maintain their Data

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by a Clique?

589


what is sysdba and sysdbc ? which has high priority ?

3374


What are the available primary index types?

720


What is spool space? Why do you get spool space errors?

518


What is the purpose of joins in teradata?

546






What are the 5 phases in a multiload utility?

615


How to eliminate product joins in a teradata sql query?

605


What are the different design perspectives used in teradata?

554


Explain amp in teradata?

578


While creating table my dba has fallback or no fallback in his ddl. What is that?

697


How do you see a ddl for an existing table?

575


How to run a query in teradata?

587


How do you do backup and recovery in teradata?

552


Why teradata is used?

580


What is meant by a Virtual Disk?

580