Sunday, October 19, 2008

What do you know about Teradata?

I don't know much :-), but I need to know, so I decided to create this post, and will try to keep it updated
First of all: some tools to work with Teradata, and on next Monday, I will try, and ask my colleage to show me


BTEQ
http://en.wikipedia.org/wiki/BTEQ

Teradata Parallel Transporter
http://en.wikipedia.org/wiki/Teradata_Parallel_Transporter

TPump
http://en.wikipedia.org/wiki/TPump

Fast Export
http://en.wikipedia.org/wiki/FastExport

Fast Load
http://en.wikipedia.org/wiki/FastLoad

Shared Nothing architecture

Shared Nothing, the term is used in clustering model, eg. Exchange, DBMS, etc. There any 2 main kinds of resource sharing between servers in cluster model.
1. Shared Nothing: in this model, the servers in cluster need to communicate through some other kinds of connection like: Network, heartbeat to share and access information
2. Shared Resource (i don't remember, will update later) in this model, the severs in cluster share harddisk, memory, etc. it can boost the performance of the system, but the trade off is single-point of failture

Digital Inspiration Technology Guide

Change the world with your passion