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
What is meant by a Clique?
what is sysdba and sysdbc ? which has high priority ?
What are the available primary index types?
What is spool space? Why do you get spool space errors?
What is the purpose of joins in teradata?
What are the 5 phases in a multiload utility?
How to eliminate product joins in a teradata sql query?
What are the different design perspectives used in teradata?
Explain amp in teradata?
While creating table my dba has fallback or no fallback in his ddl. What is that?
How do you see a ddl for an existing table?
How to run a query in teradata?
How do you do backup and recovery in teradata?
Why teradata is used?
What is meant by a Virtual Disk?