eBook - ePub
Aster Data Database Administration
Tom Coffing, Todd Wilson
This is a test
Partager le livre
- 759 pages
- English
- ePUB (adapté aux mobiles)
- Disponible sur iOS et Android
eBook - ePub
Aster Data Database Administration
Tom Coffing, Todd Wilson
DĂ©tails du livre
Aperçu du livre
Table des matiĂšres
Citations
Ă propos de ce livre
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.
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 Aster Data Database Administration est un PDF/ePUB en ligne ?
Oui, vous pouvez accĂ©der Ă Aster Data Database Administration par Tom Coffing, Todd Wilson 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 â 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...