Teradata: Shared nothing(Ex: Each VPROC is associated with one VDisk)
Other: Shared Everything
Process Million of Instructions per second
Process Thousands of Instructions per second
Stores billions of rows
stores millions of rows
unconditional parallelism(Each AMP works with its own drive)
Conditional Parallelism
Better storage and fast retrieval(using indexes)
fast retrieval only
bulk load utilities(BTEQ,FLOAD,MLOAD,TPUMP)
limited utilities
Other: Shared Everything
Process Million of Instructions per second
Process Thousands of Instructions per second
Stores billions of rows
stores millions of rows
unconditional parallelism(Each AMP works with its own drive)
Conditional Parallelism
Better storage and fast retrieval(using indexes)
fast retrieval only
bulk load utilities(BTEQ,FLOAD,MLOAD,TPUMP)
limited utilities
No comments:
Post a Comment