Teradata tools
来源:互联网 发布:pdm 软件 编辑:程序博客网 时间:2024/06/05 12:43
Query Submitting Tools
BTEQ
- Basic Teradata Query utility
- SQL front-end
- Report writer features
- Interactive and batch queries
- Import/Export across all platforms
- The default number of sessions, upon login, is 1.
Teradata Query Manager
- SQL front-end for ODBC databases
- Historical record of queries including:
– Timings
– Status
– Row counts
- Random sampling feature
- Limit amount of data returned
- Import/Export between database and PC
- Export to EXCEL or ACCESS
Application Utilities
FastLoad
- •Data loading utility
- •Loads empty tables
- •Block transfers with multi-session parallelism MultiLoad
- •Table loading/maintaining utility
- •Runs against multiple tables
- •Block transfers with multi-session parallelism
- •Multiple input source files
FastExport
- •Data extraction utility
- •Exports tables to client files
- •Block transfers with multi-session parallelism
TPump
- •Teradata Parallel Data Pump
- •Maintains up to 60 tables at a time
- •Uses standard DML—not block transfers
- •User may adjust throttle to change apply rate
- •Same restartability, portability and scalability as MultiLoad
Administrative Tools
Teradata Manager
Database Query Manager (DBQM)
- Query workload management tool
- Runs, suspends, schedules later or rejects query based on current workload
- Restricts queries based on analysis control:
- Restricts queries based on object control:
- Logs workload performance for analysis
- Restricts based on environmental factors:
– CPU
– Disk utilization
– Network activity
– Number of users