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(TM) 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(TM) 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(TM) 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
Practical Oracle8i(TM) 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(TM) 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(TM) 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