Practical Oracle8i: Building Efficient Databases

What is really involved in building effective Oracle database systems, and how do you approach the endeavor in a way that increases your chances for success?

Practical Oracle8i™ offers a real-life approach to constructing Oracle databases--one that is geared toward solving important business problems. This book will help you devise appropriate strategies for database design that takes into account Oracle's technical underpinnings, hardware and user limitations, and tradeoffs between simplicity and efficiency. It discusses selecting the Oracle features needed to perform specific functions and demonstrates how to structure code most effectively for the features being implemented.

Practical Oracle8i™ presents an overview of Oracle that clearly explains the central functions that are key to Oracle's operation. In addition, the book presents the fundamentals of the system, covering the way in which data is stored, packed, and made visible, as well as the dynamic features involved in transactions and calculations. Specific topics covered include:

• A discussion of why Oracle projects fail
• Leveraging tablespaces
• Partitioning
• LOBs
• Autonomous transactions
• Row-level security for virtual private databases
• Parallel query and parallel server
• The new analytical functions introduced in Oracle 8.1.6

This book also provides a summary of the most useful new features of Oracle 8.1.5, practical tips for tuning performance and testing features, and information on the major space-management features of an Oracle database.

Written by one of the world's most knowledgeable and experienced Oracle database designers and programmers, Practical Oracle8i™ reveals the strategies, techniques, and insights that will enable you to understand the technology's full potential and put Oracle to work for successful database systems.

0201715848B04062001

What is really involved in building effective Oracle database systems, and how do you approach the endeavor in a way that increases your chances for success?

Practical Oracle8i™ offers a real-life approach to constructing Oracle databases--one that is geared toward solving important business problems. This book will help you devise appropriate strategies for database design that takes into account Oracle's technical underpinnings, hardware and user limitations, and tradeoffs between simplicity and efficiency. It discusses selecting the Oracle features needed to perform specific functions and demonstrates how to structure code most effectively for the features being implemented.

Practical Oracle8i™ presents an overview of Oracle that clearly explains the central functions that are key to Oracle's operation. In addition, the book presents the fundamentals of the system, covering the way in which data is stored, packed, and made visible, as well as the dynamic features involved in transactions and calculations. Specific topics covered include:

• A discussion of why Oracle projects fail
• Leveraging tablespaces
• Partitioning
• LOBs
• Autonomous transactions
• Row-level security for virtual private databases
• Parallel query and parallel server
• The new analytical functions introduced in Oracle 8.1.6

This book also provides a summary of the most useful new features of Oracle 8.1.5, practical tips for tuning performance and testing features, and information on the major space-management features of an Oracle database.

Written by one of the world's most knowledgeableand experienced Oracle database designers and programmers, Practical Oracle8i™ reveals the strategies, techniques, and insights that will enable you to understand the technology's full potential and put Oracle to work for successful database systems.

Booknews

This book offers a practical approach to constructing Oracle databases geared towards solving business problems. With numerous charts and tables, it presents an overview of the program, explaining the central functions and its technical underpinnings, to allow the reader to devise appropriate strategies for database design given user or hardware limitations. It also provides insight on why many Oracle projects fail, and information on leveraging tablespaces, partitioning, LOBs, row-level security and parallel queries and servers. Annotation c. Book News, Inc., Portland, OR (booknews.com)

Jonathan Lewis is a leading independent database consultant with over fifteen years' experience helping clients design and implement Oracle database systems. Much of his career has been spent working around the problems caused by the inappropriate use of the technology. In addition, he is the Director for Products and Services for the UK Oracle Users Group and maintains a Web site of Oracle tips and advice.