Access over 20 million homework & study documents

concept of recivable_management

Content type
User Generated
Type
Study Guide
Rating
Showing Page:
1/5
Teradata Architecture:
Teradata is a massively parallel processing system running a shared nothing architecture.
Symmetric multiprocessing (SMP) A single node that contains multiple CPUs sharing a memory pool.
Massively parallel processing (MPP) Multiple SMP nodes working together comprise a larger
configuration. The nodes are connected using the BYNET, which allows multiple virtual processors on
multiple system nodes to communicate with each other.
Shared Nothing Architecture(MPP) means that each vproc (Access Module Processors and Parsing
Engines are Virtual processors) is responsible for its own portion of the database and do not share
common components.each AMP manages its own dedicated memory space and the data on its own
vdisk these are not shared with other AMPs. Each AMP uses system resources independently of the
other AMPs so they can all work in parallel for high system performance overall
A node is made up of various hardware and softwares
A clique is a set of Teradata nodes that share a common set of disk arrays. Cabling a subset of nodes to
the same disk arrays creates a clique.
A disk array is a configuration of disk drives that utilizes specialized controllers to manage and distribute
data and parity acroos the disks while providing fast access and data integrity
RAID 5 Data and parity protection striped across multiple disks
RAID 1 Each disk has a physical mirror replicating the data.
VPROCs:
Teradata software components are known as "Virtual Processors" or VPROCs
VPROCs are software threads or processes and there are two kinds of VPROCs:
1. Access Module Processors (AMPs)
An AMP reads, writes and manipulates all database rows in the partition that the AMP “owns”
2. Parsing Engines (PEs)
PE parse SQL statements, reducing them to their component executable steps
The number of VPROCs is configurable
VPROCs are in every Teradata node
VPROCs can migrate around the complex, as in the case of a failed node
VPROCS provide parallelism within a node

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/5
A Logical View of the Teradata Architecture
Teradata Storage Process
The Parsing Engine interprets the SQL command and converts the data record from the host into an
AMP message
The BYNET distributes the row to the appropriate AMP
The AMP formats the row and writes it to its associated disks
The disk holds the row for subsequent access
Teradata Retrieval Process
The Parsing Engine dispatches a request to retrieve one or more rows
The BYNET ensures that appropriate AMP(s) are activated
The AMPs locate and retrieve desired rows in parallel access and will sort, aggregate or format if needed
The BYNET returns retrieved rows to parsing engine
The Parsing Engine returns row(s) to requesting client application
The BYNET is responsible for
Point-to-point communications between nodes and virtual processors
Merging answer sets back to the PE
making Teradata parallelism possible
The Parsing Engine is responsible for
Managing Individual sessions (up to 120)
Parsing and optimizing SQL requests

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/5

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 5 pages?
Access Now
Unformatted Attachment Preview
Teradata Architecture: Teradata is a massively parallel processing system running a shared nothing architecture. Symmetric multiprocessing (SMP) – A single node that contains multiple CPUs sharing a memory pool. Massively parallel processing (MPP) – Multiple SMP nodes working together comprise a larger configuration. The nodes are connected using the BYNET, which allows multiple virtual processors on multiple system nodes to communicate with each other. Shared Nothing Architecture(MPP) – means that each vproc (Access Module Processors and Parsing Engines are Virtual processors) is responsible for its own portion of the database and do not share common components.each AMP manages its own dedicated memory space and the data on its own vdisk — these are not shared with other AMPs. Each AMP uses system resources independently of the other AMPs so they can all work in parallel for high system performance overall A node is made up of various hardware and softwares A clique is a set of Teradata nodes that share a common set of disk arrays. Cabling a subset of nodes to the same disk arrays creates a clique. A disk array is a configuration of disk drives that utilizes specialized controllers to manage and distribute data and parity acroos the disks while providing fast access and data integrity RAID 5 Data and parity protection striped across multiple disks RAID 1 Each disk has a physical mirror replicating the data. VPROCs: Teradata software components are kno ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Really useful study material!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Documents