Teradata Database Administration – The Fundamentals
eBook - ePub

Teradata Database Administration – The Fundamentals

Tom Coffing, Thomas Coffing

Share book
  1. 449 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

Teradata Database Administration – The Fundamentals

Tom Coffing, Thomas Coffing

Book details
Book preview
Table of contents

About This Book

'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.

Frequently asked questions

How do I cancel my subscription?
Simply head over to the account section in settings and click on “Cancel Subscription” - it’s as simple as that. After you cancel, your membership will stay active for the remainder of the time you’ve paid for. Learn more here.
Can/how do I download books?
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
What is the difference between the pricing plans?
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
What is Perlego?
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Do you support text-to-speech?
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Is Teradata Database Administration – The Fundamentals an online PDF/ePUB?
Yes, you can access Teradata Database Administration – The Fundamentals by Tom Coffing, Thomas Coffing in PDF and/or ePUB format, as well as other popular books in Informatik & Data-Warehousing. We have over one million books available in our catalogue for you to explore.



Chapter 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.”
-Shawshank Redemption
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.”
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.”
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.”
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...

Table of contents