Databases Reference
In-Depth Information
6. Concurrent Update
a. Level of locking
(1) Field value
(2) Row
(3) Page
(4) Table
(5) Database
b. Type of locking
(1) Shared
(2) Exclusive
(3) Both
c. Responsibility for handling deadlock
(1) Programs
(2) DBMS (automatic rollback of transaction causing
deadlock)
7. Backup and Recovery
a. Backup services
b. Journaling services
c. Recovery services
(1) Recover from backup copy only
(2) Recover using backup copy and journal
d. Rollback of individual transactions
e. Incremental backup
8. Security
a. Encryption
b. Passwords
c. Authorization rules
(1) Access to database only
(2) Access/update access to any column or combination of
columns
d. Views
e. Difficulty in bypassing security controls
9. Integrity
a. Support for entity integrity
b. Support for referential integrity
c. Support for data integrity
d. Support for other types of integrity constraints
10. Replication and Distributed Databases
a. Partial replicas
b. Handling of duplicate updates in replicas
c. Data distribution
d. Procedure support
(1) Language used
(2) Procedures stored in database
(3) Support for remote stored procedures
(4) Trigger support
11. Limitations
a. Number of tables
b. Number of columns
c. Length of individual columns
d. Total length of all columns in a table
e. Number of rows per table
f. Number of files that can be open at the same time
g. Sizes of database, tables, and other objects
h. Types of hardware supported
i. Types of LANs supported
j. Other
12. Documentation and Training
a. Clearly written manuals
b. Tutorial
(1) Online
(2) Printed
c. Online help available
(1) General help
(2) Context-sensitive help
d. Training
(1) Vendor or other company
(2) Location
(3) Types (DBA, programmers, users, others)
(4) Cost
13. Vendor Support
a. Type of support available
b. Quality of support available
c. Cost of support
d. Reputation of support
14. Performance
a.
262
External benchmarking done by various organizations
b.
Internal benchmarking
c.
Includes a performance monitor
FIGURE 8-8
DBMS evaluation checklist (continued)
