Teradata Database Administration – The Fundamentals
eBook - ePub

Teradata Database Administration – The Fundamentals

Tom Coffing, Thomas Coffing

Compartir libro
  1. 449 páginas
  2. English
  3. ePUB (apto para móviles)
  4. Disponible en iOS y Android
eBook - ePub

Teradata Database Administration – The Fundamentals

Tom Coffing, Thomas Coffing

Detalles del libro
Vista previa del libro
Índice
Citas

Información del libro

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

Preguntas frecuentes

¿Cómo cancelo mi suscripción?
Simplemente, dirígete a la sección ajustes de la cuenta y haz clic en «Cancelar suscripción». Así de sencillo. Después de cancelar tu suscripción, esta permanecerá activa el tiempo restante que hayas pagado. Obtén más información aquí.
¿Cómo descargo los libros?
Por el momento, todos nuestros libros ePub adaptables a dispositivos móviles se pueden descargar a través de la aplicación. La mayor parte de nuestros PDF también se puede descargar y ya estamos trabajando para que el resto también sea descargable. Obtén más información aquí.
¿En qué se diferencian los planes de precios?
Ambos planes te permiten acceder por completo a la biblioteca y a todas las funciones de Perlego. Las únicas diferencias son el precio y el período de suscripción: con el plan anual ahorrarás en torno a un 30 % en comparación con 12 meses de un plan mensual.
¿Qué es Perlego?
Somos un servicio de suscripción de libros de texto en línea que te permite acceder a toda una biblioteca en línea por menos de lo que cuesta un libro al mes. Con más de un millón de libros sobre más de 1000 categorías, ¡tenemos todo lo que necesitas! Obtén más información aquí.
¿Perlego ofrece la función de texto a voz?
Busca el símbolo de lectura en voz alta en tu próximo libro para ver si puedes escucharlo. La herramienta de lectura en voz alta lee el texto en voz alta por ti, resaltando el texto a medida que se lee. Puedes pausarla, acelerarla y ralentizarla. Obtén más información aquí.
¿Es Teradata Database Administration – The Fundamentals un PDF/ePUB en línea?
Sí, puedes acceder a Teradata Database Administration – The Fundamentals de Tom Coffing, Thomas Coffing en formato PDF o ePUB, así como a otros libros populares de Informatik y Data-Warehousing. Tenemos más de un millón de libros disponibles en nuestro catálogo para que explores.

Información

Año
2013
ISBN
9781940540160
Categoría
Informatik

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
images
“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
images
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
images
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
images
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
images
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
images
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
images
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
images
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
images
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
images
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
images
The Teradata environment allows for everyone to walk in their own tracks b...

Índice