Getting started with Greenplum for big data analytics

Getting started with Greenplum for big data analytics

A hands-on guide on how to execute an analytics project from conceptualization to operationalization using Greenplum Explore the software components and appliance modules available in Greenplum Learn core Big Data Architecture concepts and master data loading and processing patterns Understand Big D...

Descripción completa

Detalles Bibliográficos
Autor principal: Gollapudi, Sunila (-)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Birmingham : Packt Publishing [2013]
Edición:1st edition
Materias:
Big data.
Database management.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628124706719
Tabla de Contenidos:
  • Intro
  • Getting Started with Greenplum for Big Data Analytics
  • Table of Contents
  • Getting Started with Greenplum for Big Data Analytics
  • Credits
  • Foreword
  • About the Author
  • Acknowledgement
  • About the Reviewers
  • www.PacktPub.com
  • Support files, eBooks, discount offers and more
  • Why Subscribe?
  • Free Access for Packt account holders
  • Instant Updates on New Packt Books
  • Preface
  • What this book covers
  • What you need for this book
  • Who this book is for
  • Conventions
  • Reader feedback
  • Customer support
  • Errata
  • Piracy
  • Questions
  • 1. Big Data, Analytics, and Data Science Life Cycle
  • Enterprise data
  • Classification
  • Features
  • Big Data
  • So, what is Big Data?
  • Multi-structured data
  • Data analytics
  • Data science
  • Data science life cycle
  • Phase 1 - state business problem
  • Phase 2 - set up data
  • Phase 3 - explore/transform data
  • Phase 4 - model
  • Phase 5 - publish insights
  • Phase 6 - measure effectiveness
  • References/Further reading
  • Summary
  • 2. Greenplum Unified Analytics Platform (UAP)
  • Big Data analytics - platform requirements
  • Greenplum Unified Analytics Platform (UAP)
  • Core components
  • Greenplum Database
  • Hadoop (HD)
  • Chorus
  • Command Center
  • Modules
  • Database modules
  • HD modules
  • Data Integration Accelerator (DIA) modules
  • Core architecture concepts
  • Data warehousing
  • Column-oriented databases
  • Parallel versus distributed computing/processing
  • Shared nothing, massive parallel processing (MPP) systems, and elastic scalability
  • Shared disk data architecture
  • Shared memory data architecture
  • Shared nothing data architecture
  • Data loading patterns
  • Greenplum UAP components
  • Greenplum Database
  • The Greenplum Database physical architecture
  • The Greenplum high-availability architecture
  • High-speed data loading using external tables.
  • External table types
  • Polymorphic data storage and historic data management
  • Data distribution
  • Hadoop (HD)
  • Hadoop Distributed File System (HDFS)
  • Hadoop MapReduce
  • Chorus
  • Greenplum Data Computing Appliance (DCA)
  • Greenplum Data Integration Accelerator (DIA)
  • References/Further reading
  • Summary
  • 3. Advanced Analytics - Paradigms, Tools, and Techniques
  • Analytic paradigms
  • Descriptive analytics
  • Predictive analytics
  • Prescriptive analytics
  • Analytics classified
  • Classification
  • Forecasting or prediction or regression
  • Clustering
  • Optimization
  • Simulations
  • Modeling methods
  • Decision trees
  • Association rules
  • The Apriori algorithm
  • Linear regression
  • Logistic regression
  • The Naive Bayesian classifier
  • K-means clustering
  • Text analysis
  • R programming
  • Weka
  • In-database analytics using MADlib
  • References/Further reading
  • Summary
  • 4. Implementing Analytics with Greenplum UAP
  • Data loading for Greenplum Database and HD
  • Greenplum data loading options
  • External tables
  • gpfdist
  • gpload
  • Hadoop (HD) data loading options
  • Sqoop 2
  • Greenplum BulkLoader for Hadoop
  • Using external ETL to load data into Greenplum
  • Extraction, Load, and Transformation (ELT) and Extraction, Transformation, Load, and Transformation (ETLT)
  • Greenplum target configuration
  • Sourcing large volumes of data from Greenplum
  • Unsupported Greenplum data types
  • Push Down Optimization (PDO)
  • Greenplum table distribution and partitioning
  • Distribution
  • Data skew and performance
  • Optimizing the broadcast or redistribution motion for data co-location
  • Partitioning
  • Querying Greenplum Database and HD
  • Querying Greenplum Database
  • Analyzing and optimizing queries
  • The ANALYZE function
  • The EXPLAIN function
  • Dynamic Pipelining in Greenplum
  • Querying HDFS
  • Hive
  • Pig.
  • Data communication between Greenplum Database and Hadoop (using external tables)
  • Data Computing Appliance (DCA)
  • Storage design, disk protection, and fault tolerance
  • Master server RAID configurations
  • Segment server RAID configurations
  • Monitoring DCA
  • Greenplum Database management
  • In-database analytics options (Greenplum-specific)
  • Window functions
  • The PARTITION BY clause
  • The ORDER BY clause
  • The OVER (ORDER BY…) clause
  • Creating, modifying, and dropping functions
  • User-defined aggregates
  • Using R with Greenplum
  • DBI Connector for R
  • PL/R
  • Using Weka with Greenplum
  • Using MADlib with Greenplum
  • Using Greenplum Chorus
  • Pivotal
  • References/Further reading
  • Summary
  • Index.

Ejemplares similares