Oracle8 Design Tips

Larger Cover

Oracle8 Design Tips

By Dave Ensor, Ian Stevenson

Publisher: O'Reilly Media

Released: September 1997

Pages: 136

The latest version of the Oracle relational database management system, Oracle8, was released in the summer of 1997. The new version offers some dramatically different features from previous versions, including better scalability, reliability, and security; an object-relational model; additional datatypes; and much more. To get peak performance out of an Oracle8 system, databases and code need to be designed with these new features in mind. This small book tells Oracle designers and developers just what they need to know to use the Oracle8 features to best advantage.

O'Reilly's Oracle Design, released in April 1997, has been very well received by the Oracle community. The design of both databases and applications is an often-neglected area of Oracle, but one that has an enormous impact on the ultimate power and performance of a system. If the initial design is poor, then the most powerful hardware, the most sophisticated software tools, and the most highly tuned data and programs won't make a system run smoothly and efficiently. Oracle Design focuses on both database and code design, including such special design areas as data models, denormalization, the use of keys and indexes, temporal data, special architectures (client/server, distributed database, parallel processing), and data warehouses. Written primarily for Oracle7 (through 7.3), it also takes a look ahead at some of the features announced for Oracle8.

Oracle8 Design Tips is a companion volume for Oracle Design. Written by Dave Ensor and Ian Stevenson, authors of the original volume, the mini-book focuses on the new features of Oracle8 and on the object-relational model of the new version. Virtually all of the advice in the original book is still absolutely on target (regardless of what version of Oracle you are running). But the mini-book updates that advice to tell you how to capitalize on the latest features. Used together, the two volumes provide immensely valuable and up-to-the-minute information for anyone trying to design for the latest version of the Oracle RDBMS.

Chapters include:

What's New in Oracle8? An overview of Oracle8 and Oracle's approach.
Methodologies for Oracle8. Can traditional methodologies be used for development in an object-oriented environment? What approaches are best for Oracle's new object-relational model?
Miscellaneous Oracle8 Enhancements. Discussions of a variety of new features, including triggers and backups.
Oracle8's "Big" Features. Design hints for using features that support very large databases, including large objects (LOBs), partitioned objects, indexes and tables, cooperative indexing, etc.
Objects. A general discussion of the object-oriented technology that underlies Oracle8--for example, how do such features as encapsulation, inheritance, and polymorphism apply in an Oracle environment?
Tools Support for Oracle8. The use of tools like Sedona, Developer/2000, Designer/2000, Object Designer, SQL*Plus, C/C++, and Java with Oracle8.

Dave Ensor

Dave Ensor is manager of Worldwide Solutions, PATROL R&D, with BMC Software where his roles are to assist customers in their use of both BMC's PATROL product and the Oracle Server, and to feed the results of his field work back into product planning. He has more than 30 years of IT experience and has been involved with the design and performance issues surrounding Oracle since 1987. For many years he led Oracle Worldwide's Performance Studies Group based in the UK, which provided consultancy support to both customer and internal projects with critical performance requirements. Dave is well known as a speaker on performance management and design; he presents his papers at user conferences and writes and delivers one-day seminars. He lives in the UK just outside London, but spends much of the year traveling to user sites and meetings. In his spare time he also travels, but in this case without his laptop and with his wife. He can be reached at dave_ensor@compuserve.com. Ian Stevenson is a freelance consultant specializing in database design and development. He has worked with database technology for 19 years, starting with early hierarchical models. He worked for Oracle (UK) for two years in post-sales support and Human Resources Development. This is where he formed his friendship with Dave Ensor. Ian has a first-class honors degree in mathematics from the University of Southampton and is a member of the British Computer Society. He is married to Brenda and has two children, Todd and Tara. He is a fanatic supporter of the Southampton football club. He can be contacted via ian@westmail.demon.co.uk.

View Dave Ensor's full profile page.
Ian Stevenson

Ian Stevenson is a freelance consultant specializing in database design and development. He has worked with database technology for 19 years, starting with early hierarchical models. He worked for Oracle (UK) for two years in post-sales support and Human Resources Development. This is where he formed his friendship with Dave Ensor. Ian has a first-class honors degree in mathematics from the University of Southampton and is a member of the British Computer Society. He is married to Brenda and has two children, Todd and Tara. He is a fanatic supporter of the Southampton football club. He can be contacted via ian@westmail.demon.co.uk.

View Ian Stevenson's full profile page.

Colophon

Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The insect featured on the cover of Oracle Design is a dragonfly of the family Libellulidae, or common skimmer. Dragonflies, along with damselflies, com prise the order Odonata. Dragonflies are predatory insects. Young dragonflies are aquatic insects. They are equipped with a unique "jet propulsion" ability. By drawing water in through their gills, located in the posterior of their abdomens, and quickly forcing it out again they are able to powerfully propel themselves across the water surface. This technique is used in emergencies when a quick getaway is called for.

Mature dragonflies are among nature's most impressive fliers. Because they achieve great speed and power relative to their size, their flying techniques have been studied extensively by aviation engineers. Dragonflies are able to fly as fast as 35 miles per hour, and to perform impressive mid-air acrobatics. Unlike most flying insects, dragonflies operate their front and rear wings in dependently. They twist their wings slightly on the downstroke, thus creating mini-whirlwinds that move over the wing surface faster than still air would.

Adult dragonflies catch and eat their prey while flying. They fly with their long, bristle-covered legs bent in front of them, forming something like a basket, which they use to scoop up other insects. Dragonflies are quite popular with humans both because of their beauty and grace and because their diet is largely made up of mosquitoes and flies. Edie Freedman designed the cover of this book, using a 19th-century engraving from the Dover Pictorial Archive. The cover layout was produced with Quark XPress 3.3 using the ITC Garamond font. Whenever possible, our books use RepKoverTM, a durable and flexible lay-flat binding. If the page count exceeds RepKover's limit, perfect binding is used. The inside layout was designed by Edie Freedman and Nancy Priest and implemented in FrameMaker by Mike Sierra. The text and heading fonts are ITC Garamond Light and Garamond Book. The illustrations that appear in the book were created in Macromedia Freehand by Chris Reilley and Robert Romano. This colophon was written by Clairemarie Fisher O'Leary.

Description

Product Details

About the Author

Colophon

Recommended for You

Dave Ensor

Ian Stevenson

About O'Reilly

Community

More O'Reilly Sites

Partner Sites

Shop O'Reilly