Greenplum Training | Greenplum Postgresql online course – GOT

1
SAP GREENPLUM TRAINING
For More Details Email info_at_globalonlinetrain
ings.com IND 914060501418 UK 44(0) 203 371 00
77 What's app 1 516 8586242 visit
www.globalonlinetrainings.com

2
GLOBAL ONLINE TRAININGS

• Global Online Trainings has proven track record
  of delivering successful trainings on various
  technologies globally to improve the bottom line
  of the business for competencies of the corporate
  and careers growth of the individuals
  consultants.
• We are providing best online training center that
  provides you training on all modules of SAP,
  Oracle, SAS, PHP and Testing Tools, Data
  Warehousing, PLSQL and SQL. our professional and
  efficient team of trainers brings out their years
  of expertise to let their students understand the
  complexities of the technology that they are
  training on.

3

• Global Online Trainings provide online training
  through virtual classes but at no time during our
  training program will you feel that you are not
  connected to us physically.
• Global Online Trainings subject matters experts
  will provide you online tutorials in such an
  engaging and engrossing way that you will never
  feel you are not in a physical classroom.
• Global Online Trainings application sharing,
  remote desktop support, chat to clear doubts,
  virtual white board sharing and question/answer
  sessions are some of our prominent features that
  truly sets us apart from other online training
  provider.

4
Greenplum

• Greenplum Training may be a massively parallel
  processing (MPP) information base server
  supported postgresql open supply technology, An
  MPP system may be a cluster with two or a lot of
  Greenplum postgresql data instances cooperating
  to accomplish a task, every host or instance with
  its own memory and storage. MPP multiple
  processor architecture, has its own memory and
  disk storage in which each processor is a part of
  complete systems.

5
Greenplum MPP architecture

• Greenplum MPP architecture allows many operations
  to process any time by many processors for
  enhance speed and performance of databases that
  deals with huge amounts of data, so the data is
  divided across multiple nodes of server to
  process. Data locally in an MPP architecture
  there is no risk of sharing because there is no
  disk level sharing to be concerned ,this is the
  reason why is called shared nothing architecture.
• Greenplum Training database uses the high
  performance system architecture. Greenplum
  Training database architecture has a master host
  and one or more segment host. But it is mostly
  connected with master host. 

6
 Shared nothing architecture vs. Shared disk
architecture

• Shared nothing architecture is nothing but
  Greenplum architecture. Due to the segment
  independently handles an amount of the data with
  its own CPU. A distributed DBMS system with a
  shared disk (or shared everything) architecture
  has multiple database server hosts managing a
  single database host on a shared collection of
  disk.
• In shared disk system, all the data is local to
  each database server. There is no need to send
  data over the network to another server to
  process quires that join tables.In network disk
  storage solution and the software that
  coordinates disk sharing between servers can
  limit the amount of data and the number of
  database servers that can be added to the
  database cluster.

7

• Advantages and disadvantages of shared nothing
  architecture and Shared disk architecture is,
  firstly Advantage of the Greenplum training
  shared nothing architecture are greater
  scalability, lower cost, and faster query
  execution.
• When data is unevenly distributed among the
  segments or it distributed in a way that requires
  sending large columns of data between segments to
  execute quires, Performance on the shared nothing
  architecture can suffered.In shared nothing
  designs needs about to make sure that all of the
  segments participate totally and their resources
  area unit used effectively.

8
Greenplum database MPP features

• Pivotal has changed and supplemented the
  internals of Greenplum postgresql to support the
  parallel structure of Greenplum Training
  database.
•  It includes options designed to optimize
  Greenplum postgresql for business intelligence
  (BI) workloads.
•  In Greenplam Training database Storage
  enhancements is embody column familiarized
  tables, append solely tables, and information
  partitioning.
• Built in cost based query capable of handling
  optimization penta bytes of data without
  degrading query performance.

9

• Greenplum training is a open source technology
  under apache license v.2.0 polymorphic data
  storage and execution.
• Built on a standard database interface Greenplum
  postgresql.
• Machine learning capabilities through MADlib.
• Data federation with Hadoop.
• Supports PL/SQL, PL/python and POST GIs.

10
THANK YOU!
www.globalonlinetrainings.com