IBM PureData System for Analytics for Developers and Administrators

dettagliati del corso
Data warehouse overview
Architecture
Connecting to the IBM PureData System for Analytics host
Managing user access to the IBM PureData System for Analytics database
Administration tools
Databases and tables and schemas
Distributions
Loading and unloading tables
ODBC, JDBC, OLEDB client connectivity
Optimizer and query plans
Zone maps and Clustered Base Tables (CBT)
Materialized views
Generate statistics
Cross-database access
Transactions
GROOM
Stored procedures
High availability architecture
DBOS internals and system log files
nzsql and scripting
nzevents and event processing
Analyzing plan files
Analyzing and optimizing query performance
Workload management
System management
Configuring query history
Backup and restore
Security including authenticating users with LDAP, SSL