eBook - ePub
V14 Certification: Teradata Basics
Tom Coffing, John Nolan
This is a test
Partager le livre
- 668 pages
- English
- ePUB (adapté aux mobiles)
- Disponible sur iOS et Android
eBook - ePub
V14 Certification: Teradata Basics
Tom Coffing, John Nolan
DĂ©tails du livre
Aperçu du livre
Table des matiĂšres
Citations
Ă propos de ce livre
You are going to love this book because your confidence and knowledge will soar. V14 Certification: Teradata Basics has been designed to help you pass the test, but it is so much more. It is an incredible reference guide, learning tool, and foundation for passing all the tests and becoming a Teradata Certified Master.
Foire aux questions
Comment puis-je résilier mon abonnement ?
Il vous suffit de vous rendre dans la section compte dans paramĂštres et de cliquer sur « RĂ©silier lâabonnement ». Câest aussi simple que cela ! Une fois que vous aurez rĂ©siliĂ© votre abonnement, il restera actif pour le reste de la pĂ©riode pour laquelle vous avez payĂ©. DĂ©couvrez-en plus ici.
Puis-je / comment puis-je télécharger des livres ?
Pour le moment, tous nos livres en format ePub adaptĂ©s aux mobiles peuvent ĂȘtre tĂ©lĂ©chargĂ©s via lâapplication. La plupart de nos PDF sont Ă©galement disponibles en tĂ©lĂ©chargement et les autres seront tĂ©lĂ©chargeables trĂšs prochainement. DĂ©couvrez-en plus ici.
Quelle est la différence entre les formules tarifaires ?
Les deux abonnements vous donnent un accĂšs complet Ă la bibliothĂšque et Ă toutes les fonctionnalitĂ©s de Perlego. Les seules diffĂ©rences sont les tarifs ainsi que la pĂ©riode dâabonnement : avec lâabonnement annuel, vous Ă©conomiserez environ 30 % par rapport Ă 12 mois dâabonnement mensuel.
Quâest-ce que Perlego ?
Nous sommes un service dâabonnement Ă des ouvrages universitaires en ligne, oĂč vous pouvez accĂ©der Ă toute une bibliothĂšque pour un prix infĂ©rieur Ă celui dâun seul livre par mois. Avec plus dâun million de livres sur plus de 1 000 sujets, nous avons ce quâil vous faut ! DĂ©couvrez-en plus ici.
Prenez-vous en charge la synthÚse vocale ?
Recherchez le symbole Ăcouter sur votre prochain livre pour voir si vous pouvez lâĂ©couter. Lâoutil Ăcouter lit le texte Ă haute voix pour vous, en surlignant le passage qui est en cours de lecture. Vous pouvez le mettre sur pause, lâaccĂ©lĂ©rer ou le ralentir. DĂ©couvrez-en plus ici.
Est-ce que V14 Certification: Teradata Basics est un PDF/ePUB en ligne ?
Oui, vous pouvez accĂ©der Ă V14 Certification: Teradata Basics par Tom Coffing, John Nolan en format PDF et/ou ePUB ainsi quâĂ dâautres livres populaires dans Computer Science et Data Warehousing. Nous disposons de plus dâun million dâouvrages Ă dĂ©couvrir dans notre catalogue.
Informations
Sujet
Computer ScienceSous-sujet
Data WarehousingChapter 1 â Teradata Basics and Data Warehouse Concepts
âI find that the harder I work the more luck I seem to have.â
â Thomas Jefferson
Passing Your Teradata Certification Tests
All exams must be taken and passed in the order listed. Teradata V12 Masters can take one test to achieve a V14 Masters Upgrade and that is TE0-147. Go to www.prometric.com/Teradata to register for an exam.
What is Parallel Processing?
âAfter enlightenment, the laundryâ
- Zen Proverb
âAfter parallel processing the laundry, enlightenment!â
-Teradata Zen Proverb
Two guys were having fun on a Saturday night when one said, âIâve got to go and do my laundry.â The other said, âWhat?!â The man explained that if he went to the laundry mat the next morning, he would be lucky to get one machine and be there all day. But, if he went on Saturday night, he could get all the machines. Then, he could do all his wash and dry in two hours. Now thatâs parallel processing mixed in with a little dry humor!
The Basics of a Single Computer
Data on disk does absolutely nothing. When data is requested, the computer moves the data one block at a time from disk into memory. Once the data is in memory, it is processed by the CPU at lightning speed. All computers work this way. The "Achilles Heel" of every computer is the slow process of moving data from disk to memory. That is all you need to know to be a computer expert!
Teradata Parallel Processes Data
Teradata has been the pioneer in parallel processing since 1988 when Wells Fargo bought the first Teradata system. In the picture above, you see that we have 16 orders with four orders placed on each disk. It appears to be four separate computers, but this is one system. Teradata systems work just like a basic computer as they still need to move data from disk into memory, but Teradata divides and conquers.
Parallel Architecture
The rows of a Teradata table are spread across the AMPs, so each AMP can then process an equal amount of the rows when a USER queries the table.
The Teradata Architecture
The Parsing Engine (PE) takes the Userâs SQL and builds a Plan for each AMP to follow to retrieve the data. Parallel Processing is all about each AMP doing an equal amount of the work. If they start at the same time and end the same time, they are performing true Parallel Processing. All communication is done over the BYNET.
All Teradata Tables are spread across ALL AMPS
Each table dreams of spreading their rows equally across the AMPs. Above, are three tables with each table holding 9 rows (3-rows per AMP).
Teradata Systems can Add AMPs for Linear Scalability
Linear Scalability means if you double your AMPs and their supporting nodes the performance doubles! System number one has only 4-AMPs, but system two has 8-AMPs and is twice as fast. When a customer buys more hardware, they are adding AMPs to the system. Once the hardware is configured, the AMPs will redistribute the data to include the new AMPs.
Understand that Teradata can scale to incredible size
âIf you do what you've always done, you'll get what you've always got.â
- Anonymous
The largest systems in the world have used Teradata for market dominance for the past 20 years. Its Massively Parallel Processing (MPP) technology analyzes on such a large scale that companies can run queries they have never been able to run before. Recognize that you now have something very powerful and that has the ability to analyze every aspect of your business. So do what youâve never done, and get something that youâve never got.
AMPs and Parsing Engines (PEs) live inside SMP Nodes
AMPs and PEs are called Virtual Processors because each is a process that lives inside a nodeâs memory. Think of a node as a very powerful personal computer. SMP stands for symmetric multi-processing which means each CPU processor performs equally, and all CPUs share a pool of memory and operate under one opera...