Part 5 Selected Database Issues
Part 5 of the book examines four specific topics that the authors consider necessary for a
modern course in database management.
Chapter 19 considers database security, not just in the context of DBMS security but also
in the context of the security of the DBMS environment. It illustrates security provision
with Microsoft Office Access and Oracle. The chapter also examines the security problems
that can arise in a Web environment and presents some approaches to overcoming them.
Chapter 20 concentrates on three functions that a Database Management System should
provide, namely transaction management, concurrency control, and recovery. These
functions are intended to ensure that the database is reliable and remains in a consistent
state when multiple users are accessing the database and in the presence of failures of
both hardware and software components. The chapter also discusses advanced transaction
models that are more appropriate for transactions that may be of a long duration. The
chapter concludes by examining transaction management within Oracle.
Chapter 21 examines query processing and query optimization. The chapter considers
the two main techniques for query optimization: the use of heuristic rules that order the
operations in a query, and the other technique that compares different strategies based on
their relative costs and selects the one that minimizes resource usage. The chapter concludes
by examining query processing within Oracle.
Part 5 of the book examines four specific topics that the authors consider necessary for a
modern course in database management.
Chapter 19 considers database security, not just in the context of DBMS security but also
in the context of the security of the DBMS environment. It illustrates security provision
with Microsoft Office Access and Oracle. The chapter also examines the security problems
that can arise in a Web environment and presents some approaches to overcoming them.
Chapter 20 concentrates on three functions that a Database Management System should
provide, namely transaction management, concurrency control, and recovery. These
functions are intended to ensure that the database is reliable and remains in a consistent
state when multiple users are accessing the database and in the presence of failures of
both hardware and software components. The chapter also discusses advanced transaction
models that are more appropriate for transactions that may be of a long duration. The
chapter concludes by examining transaction management within Oracle.
Chapter 21 examines query processing and query optimization. The chapter considers
the two main techniques for query optimization: the use of heuristic rules that order the
operations in a query, and the other technique that compares different strategies based on
their relative costs and selects the one that minimizes resource usage. The chapter concludes
by examining query processing within Oracle.
No comments: