| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
ASA User's Guide |
![[-]](/dwicons/i_colpse.gif)
| Part 4 Database Administration and Advanced Use |
This part focuses on administrative tasks and getting the most out of Adaptive Server Anywhere.
|
| Chapter 20: Backup and Data Recovery |
![[+]](/dwicons/i_expand.gif)
| Introduction to backup and recovery |
|
| Understanding backups |
|
| Designing backup procedures |
|
| Configuring your database for data protection |
|
| Backup and recovery internals |
|
| Backup and recovery tasks |
|
| Chapter 21: Managing User IDs and Permissions |
|
| Database permissions overview |
|
| Managing individual user IDs and permissions |
|
| Managing groups |
| Database object names and prefixes |
|
| Using views and procedures for extra security |
| How user permissions are assessed |
| Managing the resources connections use |
| Users and permissions in the system tables |
|
| Chapter 22: Keeping Your Data Secure |
| Security features overview |
| Security tips |
|
| Controlling database access |
|
| Controlling the tasks users can perform |
|
| Auditing database activity |
|
| Running the database server in a secure fashion |
|
| Chapter 23: Working with Database Files |
| Overview of database files |
|
| Using additional dbspaces |
| Working with write files |
|
| Using the utility database |
|
| Chapter 24: Monitoring and Improving Performance |
|
| Top performance tips |
|
| Using keys to improve query performance |
|
| Using indexes to improve query performance |
| Search strategies for queries from more than one table |
| Sorting query results |
| Temporary tables used in query processing |
|
| How the optimizer works |
|
| Monitoring database performance |
|
| Chapter 25: Query Optimization |
| The role of the optimizer |
| Steps in optimization |
| Reading access plans |
|
| Underlying assumptions |
|
| Physical data organization and access |
|
| Indexes |
| Predicate analysis |
|
| Semantic query transformations |
|
| Selectivity estimation |
|
| Join enumeration and index selection |
|
| Cost estimation |
| Subquery caching |
|
| Chapter 26: Client/Server Communications |
|
| Network communication concepts |
|
| Real world protocol stacks |
| Supported network protocols |
|
| Using the TCP/IP protocol |
|
| Using the IPX protocol |
|
| Using the NetBIOS protocol |
| Using Named Pipes |
|
| Troubleshooting network communications |
| Configuring your network adapter board |
| Evaluating network performance |
|
| Chapter 27: Deploying Databases and Applications |
|
| Deployment overview |
|
| Operating systems and installation directories |
|
| Using a silent installation for deployment |
|
| Deploying client applications |
|
| Deploying database servers |
|
| Deploying embedded database applications |
| File naming conventions |
|
| Chapter 28: Accessing Remote Data |
|
| Introduction |
|
| Basic concepts |
|
| Working with remote servers |
|
| Working with external logins |
|
| Working with proxy tables |
| Example: a join between two remote tables |
| Accessing multiple local databases |
| Sending native statements to remote servers |
| Using remote procedure calls (RPCs) |
|
| Transaction management and remote data |
|
| Internal operations |
|
| Troubleshooting remote data access |
|
| Chapter 29: Server Classes for Remote Data Access |
| Overview |
|
| JDBC-based server classes |
|
| ODBC-based server classes |
|
|