Oracle8 Design Tips
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology > Databases > Database software > Oracle8 Design Tips: (A Nutshell handbook)
Oracle8 Design Tips: (A Nutshell handbook)

Oracle8 Design Tips: (A Nutshell handbook)


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

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: 1. What's New in Oracle8? An overview of Oracle8 and Oracle's approach. 2. 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? 3. Miscellaneous Oracle8 Enhancements. Discussions of a variety of new features, including triggers and backups. 4. 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. 5. 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? 6. Tools Support for Oracle8. The use of tools like Sedona, Developer/2000, Designer/2000, Object Designer, SQL*Plus, C/C++, and Java with Oracle8.

Table of Contents:
Preface. 1. What's New in Oracle8? Oracle's Marketing Message Oracle8 Features Scalability Reliability Security More Manageable Data More Copies of Data More Ways to Represent Data Faster Access to Data Towards Object Orientation The Type System Object Views. 2. Methodologies for Oracle8 Oracle8 and Traditional Methods Oracle8 and OOAD Component-Based Development Bottom-Up or Top-Down Development. 3. Miscellaneous Oracle8 Enhancements INSTEAD OF Triggers How INSTEAD OF Triggers Work A Trigger Example The Role of INSTEAD OF Triggers PL/SQL Improvements 3GL Callouts Restrictions on 3GL Callouts Example of a 3GL Callout Deferred Constraint Checking ENFORCE Option Safeguarding Data DB_VERIFY Utility Recovery Manager Utility Using the Recovery Catalog Recovery Manager features. 4. Oracle8's "Big" Features What Is a Really Big Database? Partitioned Objects Partitioned Tables Declarative partitioning Selecting a partition strategy Date-based partitioning Using partitions explicitly Determining the partition key Partitioned Indexes Unusable index partitions Locally prefixed partitions Locally non-prefixed partitions Global partitions Index-Only Tables Reversed Key Indexes Unstructured Data and LOBs Long and Unstructured Data in Oracle7 Introducing LOBs Design Considerations BFILE or LOB Recoverability and consistency Multiple LOBs Using LOBs in cartridges Primary key indexes Piecewise operations Supporting Large Populations of Users Connection Sharing User Identification Bitmap Indexes Cooperative Indexing NOLOGGING Option APPEND Hint Direct-Path Inserts. 5. Objects Introducing ORDBMS Pick Your Analogy Carefully Arguments For and Against Decomposition The Role of the LOB Interfaces Client-side Cache The Type System Reference Pointers (REFs) Abstract Data Types (ADTs) Methods MAP function ORDER function Collections VARRAYs Nested Tables Which Collection Type? Object Views Looking Ahead. 6. Tool Support for Oracle8 Sedona Developer/2000 Designer/2000 Object Designer SQL*Plus PL/SQL C, C++, and OCI Approaches to Extracting the Data Reasons to Use OCI Java Other Tools Conclusion.

About the Author :
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.


Best Sellers


Product Details
  • ISBN-13: 9781565923614
  • Publisher: O'Reilly Media
  • Publisher Imprint: O'Reilly Media
  • Height: 228 mm
  • Returnable: N
  • Weight: 230 gr
  • ISBN-10: 1565923618
  • Publisher Date: 07 Oct 1997
  • Binding: Book
  • Language: English
  • Series Title: A Nutshell handbook
  • Width: 152 mm


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Oracle8 Design Tips: (A Nutshell handbook)
O'Reilly Media -
Oracle8 Design Tips: (A Nutshell handbook)
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Oracle8 Design Tips: (A Nutshell handbook)

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    Fresh on the Shelf


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!