eBook - ePub
Aster Data Database Administration
Tom Coffing, Todd Wilson
This is a test
Compartir libro
- 759 páginas
- English
- ePUB (apto para móviles)
- Disponible en iOS y Android
eBook - ePub
Aster Data Database Administration
Tom Coffing, Todd Wilson
Detalles del libro
Vista previa del libro
Índice
Citas
Información del libro
The Aster Data Database Administration book is the Swiss Army Knife for the DBA. This book describes almost every subject on Aster Data. The DBA will be able to utilize the Aster Data AMC to perform heavy Aster Data DBA functions, be able to perform Backups and Recoveries, understand how to create and design tables for maximum performance, setup the workload management, have advanced SQL and Analytic examples at their fingertips, and understand the complicated MapReduce capabilities of Aster Data. This book is nearly 800 pages of beautiful colored examples that no Aster Data DBA should be without.
Preguntas frecuentes
¿Cómo cancelo mi suscripción?
¿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 Aster Data Database Administration un PDF/ePUB en línea?
Sí, puedes acceder a Aster Data Database Administration de Tom Coffing, Todd Wilson en formato PDF o ePUB, así como a otros libros populares de Computer Science y Data Warehousing. Tenemos más de un millón de libros disponibles en nuestro catálogo para que explores.
Información
Categoría
Computer ScienceCategoría
Data WarehousingChapter 1 – The Aster Data Architecture
“Design is not just what it looks like and feels like. Design is how it works.”
- Steve Jobs
What is Parallel Processing?
“After enlightenment, the laundry”
- Zen Proverb
“After parallel processing the laundry, enlightenment!”
-Aster 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!
Aster Data is a Parallel Processing System
Each vworker holds a portion of every table and is responsible for reading and writing the data that it is assigned to and from its disk. Queries are submitted to the queen who plans, optimizes, and manages the execution of the query by sending the necessary subqueries to each vworker. Each vworker performs its subquery or subqueries independent of the others, completely following only the queen’s plan. The final results of queries performed on each vworker is returned to the queen where they can be combined and delivered back to the user.
Each vworker holds a Portion of Every Table
When a table is created on Aster, each vworker receives that table. When data is loaded, the rows are hashed by a distribution key, so each vworker holds a certain portion of the rows. If the queen orders a full table scan of a particular table, then all vworkers simultaneously read their portion of the data. This is the concept of parallel processing.
The Rows of a Table are Spread Across All vworkers
A Distribution Key will be hashed to distribute the rows among the vworkers. Each vworker will hold a portion of the rows. This is the concept behind parallel processing.
The Aster Data Architecture
Aster can scale to thousands of nodes which are standard, inexpensive commodity x86 servers with locally-attached disk storage and networked with other nodes using commodity Gigabit Ethernet (GigE) technology. The Queen Node is the brains behind the operation. The Worker Nodes hold the data and do the processing based on the Queen's plan. The Loader Nodes load the data and export data off of Aster. The Backup node provides large disks that backup and restore data to the Aster system.
The Queen Node
Queen Node
• The queen node comes up with a plan for the vworkers to retrieve their portion of the data.
• The queen is the coordinator of how the data is distributed across vworkers.
• The queen delivers the answer set to the end user.
• The queen node is the software coordinator and keeper of the data dictionary and other system tables.
• You can maintain an inactive queen as a backup.
• The queen provides the cluster logic that glues all nodes of the system together. The queen is responsible for all cluster, transaction, and storage management aspects of the system.
The Worker Node
• Worker nodes are where the data is stored and analyzed.
• A worker node is comprised of multiple vworkers.
• Each vworker has their own storage, and the vworkers work in parallel to process data simultaneously.
• The queen communicates with vworkers via standard SQL, and the vworkers on various worker nodes communicate with each other.
The Loader Node
• The Aster Database Loader utility and loader nodes form the massively parallel backbone of the Aster Database for performing data loads and exports.
• Loader nodes are designed to be CPU-heavy nodes that have no major disk capacity.
• These independent nodes also help isolate loads and exports from query processing.
• The Aster Database Loader utility communicates with loader nodes and acts as a landing zone for bulk data during both loads and exports.
• Because of this brilliant design, Aster can process queries while loading fresh data, and it can process queries and loads while exporting data off of Aster.
The loader nodes handle all aspects of load and export: transforming and reformatting data. When loading, the loader nodes also generate the hash keys and perform compression. The loader nodes handle the processor intensive functions normally required by the host in most systems, thus providing great import and export capabilities while queries and backups are running simultaneously.
The Backup Node
• Aster can backup your entire Aster system or just individual tables on backup nodes.
• The backup nodes are not an Aster Database. Instead, they are a set of disk-heavy Aster Database Backup Nodes designed for backup purposes only.
• The Backup Nodes can be used to restore data to the Aster Dat...