Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Why You Must Learn About Teradata Parsing Engine

Basic functionalities of Teradata Parsing Engine

It handles session control
Managing Session

Other functions

  • Acts like parser
  • Parse and Optimize SQL requests
  • Dispatcjing optimized plan to Amps over BYNET
  • Send Query result back to requesting client
  • Responsible for Hashing data
Flow diagram:

Session control --> Parser --> Optimizer--> Dispatcher

  • Locally couples SMP Nodes in multi node system
  • Carries message between AMPs and PEs
  • Communication between nodes -point to point broadcasr
  • Merges answer sets back to PE
Performs DB and file management operations:

- Finding requested rows
- Sorting
- Joins
- Output data conversion

This post first appeared on SriniTera - Data Analysis Solutions, please read the originial post: here

Share the post

Why You Must Learn About Teradata Parsing Engine


Subscribe to Srinitera - Data Analysis Solutions

Get updates delivered right to your inbox!

Thank you for your subscription