10 апреля 2009 | Автор: Admin | Рубрика: Компьютерная литература » Програм-ние и разработка » Databases and SQL | Комментариев: 0
Robert G. Freeman, Mark D. Blomber, Mark D. Blomberg, "Mastering Oracle8i"
Publisher: Sybex Inc | Number Of Pages: 1200 | 2001-12-13 | ISBN: 0782129293 | PDF | 4.9 MB
--For daily use by working database administrators, this comprehensive reference to Oracle8i covers installation, upgrades, and database creation.
--Intermediate to advanced administrators will love the in-depth coverage of administration best practices, data warehousing, distributed databases, and Internet computing with Oracle8i.
--The CD includes many utilities, and a fully searchable electronic version of the book.
Massive in size, comprehensive in scope, and unfortunately quite dry in tone, Mastering Oracle 8i has the answers you need if you're working with the Oracle 8i database management system. The authors, one of whom holds an Oracle certification, go into considerable detail on the procedures to be followed for administrative tasks like backing up data, rolling back transactions, and configuring monitoring schemes. They usually share their thoughts on when and why you'd want to put the procedures to use, as well. Better yet, they go beyond everyday administrative work to cover subjects like materialized views, advanced user management, and performance-tuning techniques. There's some discussion of hooks for software developers, as well.
The authors' approach is to take a feature of the Oracle 8i environment--locks, say--and explain what purpose it serves, then break it down into component types with more detailed explanations. From there, the authors provide the commands and codes for viewing and manipulation of the feature, often with extensive tables. The really useful information comes next, in the form of sections on how to deal with related problems. The section on locks, for example, shows how to zero in on blocking locks. Other excellent coverage deals with how to dimension hardware, while a commendable section explains the object-oriented features of Oracle 8i. --David Wall
Topics covered: How to design and run a tight Oracle 8i ship, with special attention to object orientation, network connectivity, tablespaces, Recover Manager, parallel processing, security, and the special demands of distributed databases.