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 Oracle8ioffers 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 Oracle8ipresents 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 Oracle8ireveals 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. 0201715848B04062001Lewis, Jonathan is the author of 'Practical Oracle8I Building Efficient Databases' with ISBN 9780201715842 and ISBN 0201715848.