Teradata Intelligent Memory (TIM)- Running at the speed of Business

Overview of Teradata

Teradata is a RDBMS (Relational Database Management System). This system is solely based on off-the-shelf (readymade) symmetric multiprocessing (SMP) technology combined with communication networking, connecting SMP systems to form large Massively parallel processing systems (MPP). It is wholly used to manage large data warehousing operations. Teradata acts as a single data store that can accept large number of concurrent requests from multiple client applications.

Parallelism along with load distribution shared among several users, Execution of complex queries with a maximum of 256 joins, Parallel efficiency, Complete scalability , Teradata Intelligent Memory are some of Teradata’s widely shown Features.

Teradata Disk Space Queries

Teradata Disk Space Queries

1) To find AMP usage and CPU utilization on TD server.

  You could query DBC.Tablesize, DBC.ProfileInfo, DBC.AllRoleRights, and  

  DBC.RoleInfo and others. The query should return on the AMP Usage and CPU  

  Utilization The following query is dbc.ampusage                 

  Select Account Name, UserName, sum(diskio),sum(cputime)

from    dbc.ampusage

  Group by 1,2;

Netezza Advanced Security

Netezza Advanced Security

1.System Security

SYSTEM(ADMIN)=> CREATE USER dso;

CREATE USER

SYSTEM(ADMIN)=> GRANT MANAGE SECURITY TO dso;

GRANT

SYSTEM(ADMIN)=> GRANT USER TO dso;

GRANT

2.User Login Control

Client Communication with Teradata

Client applications can connect to Teradata Database using one of the following methods:

• Network-attached through a Local Area Network (LAN)- Workstation Attachment Methods

• Channel-attached through an IBM mainframe- Mainframe Attachment Method

Workstation Attachment Methods

Workstation-attached methods include:

• .NET Data Provider for Teradata

• Java Database Connectivity (JDBC)

• OLE DB Provider for Teradata

• Open Database Connectivity (ODBC)

• Teradata CLIv2 for workstation-attached systems