eBook - ePub
Teradata Database Administration â The Fundamentals
Tom Coffing, Thomas Coffing
This is a test
Partager le livre
- 449 pages
- English
- ePUB (adapté aux mobiles)
- Disponible sur iOS et Android
eBook - ePub
Teradata Database Administration â The Fundamentals
Tom Coffing, Thomas Coffing
DĂ©tails du livre
Aperçu du livre
Table des matiĂšres
Citations
Ă propos de ce livre
'This is the first of a series of 3 DBA books. The most important aspect of being a DBA is understanding the landscape as well as having strong fundamentals so you can do your job. That is what this book lays out. You'll understand how Teradata works, you'll understand the environment and the data base. You'll understand your roles and profiles. You are set to be an excellent DBA by reading this book.
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 Teradata Database Administration â The Fundamentals est un PDF/ePUB en ligne ?
Oui, vous pouvez accĂ©der Ă Teradata Database Administration â The Fundamentals par Tom Coffing, Thomas Coffing en format PDF et/ou ePUB ainsi quâĂ dâautres livres populaires dans Informatik et Data-Warehousing. Nous disposons de plus dâun million dâouvrages Ă dĂ©couvrir dans notre catalogue.
Informations
Sujet
InformatikSous-sujet
Data-WarehousingChapter 1 â Introduction and Good Advice
âSome birds aren't meant to be caged; their feathers are just too bright. And when they fly away, the part of you that knows it was a sin to lock them up does rejoice.â
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!
Start Small and Think Big
âA Journey of a thousand miles begins with a single step.â
-Lao Tzu
Teradata was born to be parallel, and with each query, a single step is performed in parallel by each AMP. A Teradata system consists of a series of AMPs that will work in parallel to store and process your data. This design allows you to start small and grow infinitely. If your Teradata system provides you with an excellent Return On Investment (ROI), then continue to invest by purchasing more AMPs. Most companies start small, but after seeing what Teradata can do, they continue to grow their ROI from the single step of implementing a Teradata system to millions of dollars in profits.
Give your Enterprise the Tools they need
âTo have everything is to possess nothing.â
-Buddha
When you possess a tool like Nexus, you have access to everything! The Nexus Query Chameleon is the only tool that works on all systems. Its Super Join Builder allows for the ERwin Logical Model to be loaded, and then Nexus shows tables and views visually as well as guiding users to what joins to what. Then, Nexus builds the SQL perfectly with each click of the mouse. Nexus was designed for Teradata and Hadoop, but works on all platforms. Nexus even converts table structures between vendors, so querying and managing multi-vendor platforms is transparent.
Model the Business with ERwin
âThe only true wisdom is in knowing you know nothing.â
-Socrates
The true wisdom of modeling your business is in knowing that your experts know everything. You build models for the same reasons that architects build designs. They can be inexpensively tested and altered. Use ERwin from Computer Associates to design your data models. ERwin allows you to model both your tables, views and the physical model. It doesn't have to be perfect, but should be done in a normalized 3rd normal form manner. Allow your business and modeling experts to model everything, but as they say, âModel the business, but don't make a business of modeling.â
Educate the Business on the Business by Sharing the Model
âIf I have seen farther than others, it is because I was standing on the shoulders of giants.â
-Isaac Newton
Great companies model the business but don't allow the masses to reap its rewards. Allow your business users to stand on the shoulders of giants and understand the business. Start first by allowing users to visually see what tables join to what tables.
Load Your Models and have the SQL Built Automatically
âFollowing the light of the sun, we left the Old World.â
-Christopher Columbus
Don't let Christopher Columbus follow the sun and navigate the SQL West because your profits will soon be going south. Some users like to build their SQL by hand, but this makes as much sense as an assembly line baker wanting to churn his/her own butter. Load the logical models for every system in your enterprise, show the tables and views visually, allow users to click on the columns they want, and then let the tool build the SQL perfectly every time. You can save magnitudes of order in development costs.
Five Brilliant Pieces of Teradata (1 of 5) is MPP
â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 is the ability to analyze every aspect of your business. So, do what you've never done, and get something that you've never got.
Five Brilliant Pieces (2 of 5) are Tactical Queries
âThe entire sum of existence is the magic of being needed by just one other person.â
-Vi Putnam
Forget about the quote above and the magic of being needed by just one person. The real magic is that Teradata can find a single row in under a second using just one AMP! That is of major importance. Imagine a table with trillions of rows, and yet if the user searches on the Primary Index column, the query is lightning fast and sub second. Count on Teradata for analyzing mass amounts of data, but realize that Teradata can find individual rows in a moment's notice with only a single AMP being contacted.
Five Brilliant Pieces (3 of 5) Is a Traffic System
âTwo roads diverged in a wood and I took the one less traveled by, and that has made all the difference.â
-Robert Frost
Imagine our highways with only one lane or our roads with no stop signs or lights. Teradata has the most sophisticated traffic system in the industry. Teradata allows for rules, times, delays, green lights to query, and red lights to wait. Why put a long-haul trucker with an oversized load in the fast lane? Marathon runners don't run at the same speed as sprinters, so you need to give your fastest speeds to your tactical queries and slower speeds for your batch processing. Teradata Active System Management (TASM) controls the query traffic so users can take the route less traveled.
Five Brilliant Pieces (4 of 5) Is Viewpoint
âA man who views the world at 50 the same as he did at 20 has wasted 30 years of his life.â
-Muhammad Ali
Teradata allows your queries to float like a butterfly and not sting at all! This is because Viewpoint gives the DBA and the users their own view of their Teradata world, so everyone knows exactly what is going on with the system.
Five Brilliant Pieces (5 of 5) Are Data Processing Options
âHe who walks in another's tracks leaves no footprints.â
-Joan L. Brannon
The Teradata environment allows for everyone to walk in their own tracks b...