[Book Cover]

Oracle: A Database Developer's Guide, 2/e

Ulka Rodgers, GroupWorks

Published December, 1998 by Prentice Hall PTR (ECS Professional)

Copyright 1999, 400 pp.
Paper
ISBN 0-13-841420-3
$49.99


Sign up for future
mailings on this subject.

See other books about:
    ORACLE

 [Preface]





Streamline Oracle development-and supercharge your applications! From strategic business analysis through rollout and optimization, Oracle: A Database Developer's Guide will help you streamline your entire Oracle development process. It's replete with proven solutions and worked examples for Designer/2000, Developer/2000, the Oracle database engine, PL/SQL coding, and more-all designed to maximize performance, even on tight development schedules. Top Oracle consultant Ulka Rodgers demonstrates key techniques for building Web, client/server, and data warehousing applications, including:

  • Making the most of the Oracle Application Server and Oracle Designer/2000 application generator.
  • Practical object-oriented, data and process modeling.
  • Better ways to develop screens, reports and procedural code.
  • When and how to use third-party alternatives to Oracle's tools.
Oracle: A Database Developer's Guide delivers extensive tuning guidance, covering query optimization, Enterprise Manager monitor facilities, dynamic performance tables and more. You'll also find crucial design and coding information for optimizing today's distributed applications. Whether you're a manager, analyst, Oracle data administrator, designer or developer, this book will help you achieve more, and get it done faster.



Author Bio

ULKA RODGERS is a consultant specializing in database management systems. A widely-respected lecturer on the use of Oracle products, she is author of UNIX Database Management Systems (Prentice Hall PTR). Rodgers has extensive experience helping clients to plan information systems, develop business models, and implement Oracle-based applications. She is currently based in Annandale, NJ.



    1. Introduction.

      The Productivity Challenge. Another Silver Bullet?! Successful Information Systems. Where Does Oracle Fit? Expectations and Infrastructure.
I. MANAGING THE IMPLEMENTATION.
    2. Management Strategies.

      The Preparation. Why Model Your Business? Roles and Responsibilities. Obtaining Budgets. Typical Benefit Items. Methods: Waterfall, RAD, or Object-oriented. Business Process Reengineering. A Case Study: Widgets, Inc.

    3. Strategy Techniques.

      Strategic Business Analysis Phase. Information Gathering. Components of a Business Model. Organization Model. Business Objects. Business Process Flow. Modeling the Dynamics. Mapping Models into Oracle Designer. Formulating Your Strategy. Case Study: WI Strategy Study.

    4. Analysis Techniques.

      Project Methodology. Entity relationship Models. Function Hierarchy Diagram. Process and Data Flow Models. Normalization. Analysis of Business Rules. Models for Flexibility. Convergent Modeling. Completeness Checks. Case Study: Widgets' Sales System.

    5. Application Architecture.

      The System Environment. Desktop and Roaming Requirements. Two- or Three-tier Architecture. Protocol Choices. Choosing the Tools. Infrastructure Design. Case Study: WI Sales Application Architecture.
II. DESIGNING ORACLE APPLICATIONS.
    6. Database Design for Performance.

      Real-time, Real Quick, or Human Time. Deriving a Design from Object Models. From Models to Database Design. When to Denormalize? Oracle7 Architecture. Oracle8 Architecture. Physical Design Considerations. The Database Transformer. Designing Security. Case Study: Widgets Sales Database.

    7. Application Design for Performance.

      Performance Considerations. Designing Programs. Forms Specification. Report Specification. Procedural Program Specification. Reusable Tools Design. Project Controls. Case Study: Orders Module Design.

    8. Database Administration.

      Data and Database Administration. Development versus Production DBA. Oracle Instance Architecture. Database Space Management. Database Monitoring. Disaster Recovery Planning. Performance Tuning. Planning for Rollout. Case Study: Widgets Database.
III. DEVELOPING ORACLE APPLICATIONS.
    9. Interactive Screen Programs.

      Oracle Tools. Oracle Forms Components. Global Objects. Generating a Module. Building a Common User Interface. The Upgrade Issue. Development Management Issues. Widgets Case Study: Orders Form.

    10. Report Programs.

      Report Development Tools. Performance Considerations. Report Generator. Tabular Reports. Form Reports. Matrix Reports. Embedded Data Reports. Development Management Issues.

    11. Interfaces for Server-side Code.

      Database Objects. Integrity Constraints. Database Triggers. Stored Procedures, Functions, and Packages. Using PL/SQL. Embedded SQL Interface. Development Management Issues.

    12. Making Systems Perform.

      How Oracle Chooses Access Paths. Unearthing the Optimizer's Plan. Do's and Don'ts of SQL. How Oracle Manages Database Access. Finding Bottlenecks. Finding and Reducing Multi-user Contention. Development Management Issues.
IV. DATA WAREHOUSES, DISTRIBUTED DATABASES AND THE WORLD WIDE WEB.
    13 Data Warehouse.

      Overview of a Data Warehouse. Analyzing Requirements. Meta data for a Warehouse. Data Warehouse Design. Data Warehouse Implementation.

    14. Distributed Databases.

      Overview of Distributed Systems . Data Distribution Analysis. Formulating a Distribution Strategy. Distributed Database Design. Data Distribution. Development Management Issues.

    15. The World Wide Web.

      The Internet, the Intranet and the Extranet. Formulating a WWW Strategy. Suitability Analysis. Running a Webserver Application. Web Application Concepts. Implementing Security. Webserver Generator. Development and Rollout Issues. Case Study: Order Status Inquiry.

    Appendix: Recommended Standards.
    Bibliography.

[Help] [Home]

© Prentice-Hall, Inc. A Pearson Education Company
Comments To webmaster@prenhall.com