- Shopping Bag ( 0 items )
-
All (1) from $186.31
-
Used (1) from $186.31
Ships from: Tualatin, OR
Usually ships in 1-2 business days
Developer Issues and Concerns | 1 | |
Improving Productivity | 1 | |
Current Development Problems | 1 | |
Performance Issues | 1 | |
Recovery and Data Integrity | 2 | |
Security and Access Control | 2 | |
Concurrency and Throughput | 3 | |
Deadlock | 3 | |
Reusability of Code and Designs | 3 | |
Client-Server Architecture and Database Servers | 4 | |
The Client-Server Architecture Solution | 4 | |
File-Server Constraints | 4 | |
Working Together | 5 | |
The Database Server | 5 | |
What Is a Database Server? | 5 | |
The Data Dictionary | 6 | |
Taking Advantage of Distributed Processing | 6 | |
Less Pain, More Gain - Advancing Developer Productivity | 6 | |
A Common Data Access Language - SQL | 7 | |
What is SQL? | 7 | |
The Relational Data Model | 7 | |
Declarative and Procedural Languages | 7 | |
Types of SQL Commands | 7 | |
Why Use SQL? | 8 | |
Practical Advantages of Database Servers | 8 | |
Reduced Coding | 8 | |
Security | 8 | |
Reliability and Recovery | 8 | |
Efficient Use of Computing Resources | 9 | |
Performance Improvements | 9 | |
Transaction Integrity | 9 | |
What to Look for in a Database Server | 12 | |
Standards | 12 | |
Standard SQL and SQL Extensions | 12 | |
Connectivity Standards | 13 | |
Performance | 13 | |
Measuring Performance | 14 | |
Monitoring Performance | 14 | |
Managing Performance | 15 | |
Improving Performance Through Storage Management | 15 | |
Configuration Options | 16 | |
Query Optimization | 17 | |
Benchmarks | 18 | |
Concurrency | 19 | |
Isolation Levels | 19 | |
Locking | 19 | |
Locking vs. Multi-Versioning | 20 | |
Row-Level vs. Page-Level Locks | 20 | |
Other Locking Issues | 21 | |
Deadlock Detection and Resolution | 22 | |
Communication and Connectivity | 22 | |
Scalability and Portability | 24 | |
Server Scalability | 24 | |
Server and Client Application Portability | 24 | |
Recovery and Transaction Integrity | 25 | |
Transaction Integrity | 25 | |
Recovery from Failures | 27 | |
Security | 28 | |
Levels of Security | 28 | |
Security and Application Development | 29 | |
SQL and Access Privileges | 29 | |
User Groups | 29 | |
Alternate Database Administrators | 30 | |
Distribution of Privilege Control | 30 | |
Audit Logging of User Actions | 30 | |
Distributed Systems | 31 | |
Problems Unique to Distributed Systems | 32 | |
Location Transparency | 32 | |
Site Autonomy | 33 | |
Distributed Queries | 33 | |
Distributed Updates | 33 | |
Online Access to Foreign DBMSs | 34 | |
Server Administration | 35 | |
Database Administration Tools | 35 | |
Database Loader Utilities | 35 | |
Application Development | 36 | |
Programming Language Interfaces | 36 | |
Application Building Tools | 39 | |
International Issues | 40 | |
Server Extensions | 41 | |
Data Integrity Enforcement | 42 | |
Stored Procedures | 44 | |
Other Considerations | 46 | |
Large Installed Base | 46 | |
Technical Support | 47 | |
Related Material | 49 |