01.TD员工入职技术培训之数据仓库基础V1解读.ppt

议题 议题 议题 议题 议题 Database – User Comparison User Database Unique Name Unique Name Password = Value Define and use Perm space Define and use Perm space Define and use Spool space Define Spool space Define and use Temporary space Define Temporary space Set Fallback protection default Set Fallback protection default Set Permanent Journal defaults Set Permanent Journal defaults Multiple Account strings One Account string Logon and establish a session with a priority May have a startup string Default database, dateform, timezone, and default character set Collation Sequence You can only LOGON as a known User to establish a session with Teradata. Tables, Join/Hash Indexes, Stored Procedures, and UDFs require Perm Space. Views, Macros, and Triggers are definitions in the DD/D and require NO Perm Space. A database (or user) with zero Perm Space may have views, macros, and triggers, but cannot have tables, join/hash indexes, stored procedures, or user-defined functions. Hierarchy of Databases and Users User DBC User SYSDBA Database_1 User_A User_D Database_3 User_C User_B Database_2 Maximum Perm Space - available but not yet assigned Current Perm Space - contains tables, stored procedures, UDFs No Perm Space No Box A new database or user must be created from an existing database or user. All Perm space specifications are subtracted from the immediate owner or parent. Perm space is a zero sum game – the total of all Perm Space allocations must equal the total amount of disk space available to Teradata. Perm space is only used for tables, join/hash indexes, stored procedures, and UDFs. Perm space currently unused is available to be used as Spool or Temp space. Permanent Space CREATE DATABASE CS_Tables FROM Customer_Service AS PERMANENT = 100e9 BYTES, ... Perm Space Limit per AMP Table rows, index subtable rows, join indexes, hash indexes, stored procedures, and UDFs use Perm space. Fallback protection uses twice the Perm space of No Fallback. Perm space is de