Monday, 23 November 2015

Why You Must Learn About Teradata Parsing Engine

Parsing Engine
Teradata Parsing Engine
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

No comments:

Post a Comment