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

Why You Must Learn About Teradata Parsing Engine

Teradata+Jobs
Teradata+Jobs
Basic functionalities of Teradata Parsing Engine

It handles session control
Logon/Logoff
Managing Session
BYNET
AMP

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
- LOCKS
- Sorting
- Joins
- Output data conversion
-Accounting/Journaling


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

×