Teradata基础教程(第一版中文).doc

Teradata基础教程

目 录

http://teradata.ncr-education.com/cgi-shell/wbt/tester.pl?/learning/TDCert/test-1.htm

TERADATA基础教程.........................................................................................................................1

目 录.......................................................................................................................................................I

第一章 数据仓库基本概念.................................................................................................................1

一.1 背景介绍............................................................................................................................ 1

一.2 OLTP与OLAP.................................................................................................................... 2

一

.7.2 TPC-H/R..........................................................................................................................17

TPC-H，3TB测试结果......................................................................................................................19

TPC-R，1TB测试结果......................................................................................................................19

一.8 NCR可扩展数据仓库方法论与实施框架........................................................................19

一

.8.1 NCR

可扩展数据仓库方法论

.........................................................................................20

一

.8.2 NCR

可扩展数据仓库框架

.............................................................................................24

一

.8.3 NCR

可扩展数据仓库合作伙伴

第二章 TERADATA关系型数据库管理系统概要........................................................................28

二.1 TERADATA数据库的设计思想...............................................................................................28

二.2 TERADATA数据库的体系结构...............................................................................................28

二.4 WINDOWS平台的TERADATA数据库.......................................................................................51

二.5 TERADATA多媒体数据库.......................................................................................................52

第三章 TERADATA数据库的数据分配机制................................................................................54

三.1 哈希算法、主索引、与数据分配....................................................................................54

三.2 TERADATA数据分配示例.......................................................................................................56

三.3 主索引与表的创建..........................................................................................................58

CREATE TABLE EMPLOYEE.....................................................................................................58

三.4 哈希冲突与不唯一主索引...............................................................................................59

三.5 TERADATA数据库系统的在线升级.......................................................................................61

第四章 TERADATA数据库的数据访问机制................................................................................63

四.4 全表扫描.......................................................................................................................... 72

四.5 总结................................................................................................................................. 73

第五章 如何选择主索引...................................................................................................................76

五.1 TERADATA数据库中的AMP与PDISK..............................................................................76

五.2 数据记录的分配..............................................................................................................77

五.3 选择主索引的基本原则................................................................................................... 81

第六章 数据库的空间管理、用户管理、访问权限.......................................................................83

六.1 TERADATA中的用户与数据库...............................................................................................83

六

.1.1

.............................................................................................................................83

2000MB – 500MB – 500MB – 500MB = 500MB............................................................................84

SELECT PARENT FROM DBC.CHILDREN WHERE CHILD = 'APPL1';............................91

SELECT CHILD FROM DBC.CHILDREN WHERE PARENT = 'USERADMIN';................91

六.4 TERADATA数据库的访问权限...............................................................................................92

六

.4.1

.................................................................................................................92

GRANT SELECT ON USERA TO USERB WITH GRANT OPTION;.....................................93

GRANT SELECT, INSERT ON ADMIN.TABLEC TO DBC;....................................................95

GRANT SELECT ON USERA TO ADMIN;..................................................................................96

GRANT SELECT ON USERA TO USERA WITH GRANT OPTION;.....................................96

GRANT TABLE, VIEW, MACRO, SELECT, INSERT, UPDATE,...........................................97

DELETE, DUMP, RESTORE, CHECKPOINT, EXECUTE.......................................................97

GRANT CREATE USER ON USERADMIN TO ADMIN2;......................................................100

CREATE USER USER9 FROM USERADMIN...........................................................................100

AS PERM = 100000000 SPOOL = 50000000 PASSWORD = USER9;......................................100

六

.4.2

.......................................................................................................................101

六

.4.3

.......................................................................................................................101

六

.4.4

GRANT SELECT ON USERA TO PUBLIC;..............................................................................103

六

.4.5 GRANT

六

.4.6 REVOKE

第七章 数据保护与恢复.................................................................................................................108

第八章 客户端访问TERADATA数据库的方法..........................................................................119

八.2 TERADATA数据库的编程接口.............................................................................................121

八

.2.1

八

.2.2

...........................................................................................................122

八

.2.3 ODBC............................................................................................................................122

八.3 TERADATA应用工具.............................................................................................................123

八

.3.1 BTEQ.............................................................................................................................124

八

.3.2 FastLoad........................................................................................................................124

八

.3.3 MultiLoad......................................................................................................................126

八

.3.4 FastExport.....................................................................................................................126

八

.3.5 TPump............................................................................................................................127