Tous nos rayons

Déjà client ? Identifiez-vous

Mot de passe oublié ?

Nouveau client ?

CRÉER VOTRE COMPTE
Software Engineering with Oracle
Ajouter à une liste

Librairie Eyrolles - Paris 5e
Indisponible

Software Engineering with Oracle

Software Engineering with Oracle

Best Practices for Mission-Critical Systems

Elio Bonazzi

770 pages, parution le 15/09/2001

Résumé

Mission Critical Applications—Engineered for Success with Oracle.

This book is unique. If you are looking for a book that applies time-honored software engineering principles to enterprise-wide, Oracle-based projects, then this book will meet your needs. Too many large projects run into too much difficulty, because fundamental software engineering principles were not considered. Not here. . . .

In addition, Software Engineering with Oracle links Oracle's own architectural components with crucial externals such as compilers, Version Control Systems, Bug Track systems, and management tools. Build on your existing knowledge of relational theory to put the power of Oracle to work. Learn advanced techniques to design and implement high-end systems using middleware technologies and classical software engineering methods.

As you walk through the implementation of two realistic software projects, you'll master innovative solutions with insider's tips from an experienced expert who will show you how to:

  • Look at the big picture: architecture and scalability
  • Manage timing and performance issues
  • Document as you go
  • Use tools like C++, Pro C, OCI, and PL/SQL
  • Develop in Visual Basic, Powerbuilder, Delphi, and Oracle Developer

Filled with code examples and real-life Do's and Don'ts, Software Engineering with Oracle will show you how to get it right the first time.

The CD-ROM includes all the code used in the book, along with an Oracle System Global Area SQL Statement browser, and the author's own freeware application for advanced performance monitoring.

Contents

1. Software Engineering in Oracle Projects.

Mid-Range: The Domain of Rightsizing. Typical Mistakes to Avoid. How This Book Is Structured.

2. The Software Development Life Cycle.
The Traditional Approach. The Waterfall Model. Entrenched in the Large Corporations. Issues and Problems Associated to the Waterfall Model. Risk Analysis, Prototyping, and the Spiral Model. Different Methodologies, Same Development Paradigm. Object Orientation and the Fountain Model. Software Development Life Cycle in Oracle Projects. Summary.

3. Documentation as an Integral Part of Software Projects.
Three Fundamental Requisites. Traceability. Traceability through SGML. XML. Traceability Through HTML. Using Oracle ConText to Manage Project-Related Documentation. Oracle ConText: Text Retrieval Features. The Oracle ConText Option in Action. Synchronization. Synchronization Through Change Management. Project Deliverables: They Are All Documents! Summary.

4. Designing an Oracle Application.
The Intellectual Tools in the Software Engineer's Bag. Design for Flexibility. Design for Performance. Design for Scalability. Design for Reliability. Design for Distribution and Replication of Data. Design for Very Large Database/Data Warehouse. Summary.

5. Detailed Design.
Choosing a Development Environment/Language. Application Architecture Paradigms. Rapid Application Development Tools: Compatibility and Performance Issues. DetailedDesign Issues. Summary.

6. Data Modeling and CASE Tools.
Data Modeling Methodologies. The Role of Domains. The Importance of a Repository. CASE Tools. Design Deliverables. Summary.

7. How to Structure the Server Code.
Beyond the Oracle Manuals. Procedural Code Lls the Error Handler Function. Using Composition in OO. Error/Exception Handling. Application Event Logging. Summary.

8. Software Engineering Essentials.
Version Control. Release Building. Tools for Better Code. Writing Performance Conscious SQL Statements. Testing Strategies. Internationalization Issues. Summary.

9. Managing Multiple Environments.
Development, Test, Production. Synchronizing the Environments. The Oracle Security Model. Application Objects Owner. Environment Setup. Summary.

10. Developing the Client.
There Is No Such Thing as the “Best Tool”. The Major Players in the Client-Server Arena. Connecting to Oracle. The Software Engineering Focus. Summary.

11. Oracle Tools: Pro*C/C++.
Error Handling in Pro*C. Host Array Processing. Pro*C and PL/SQL. Support for C++. Precompiler Options. Dynamic SQL in Pro*C. Interfacing Pro*C to OCI. Developing Multi-Threaded Applications. Handling LOB Types in Pro*C. The Object-Relational Paradigm. Oracle Type Translator (OTT). The Object Navigational and Associative Interfaces. Summary.

12. Beyond Pro*C: The Oracle Call Interface.
OCI release. The OCI release. The OCI Advantage. The OCI: Best Companion for C++. Summary.

13. Oracle Trace.
Oracle Trace Components. Using Oracle Trace—Deciding What to Sample. Oracle Trace APIs. Formatting and Analyzing Oracle Trace Data. Summary.

14. Procedural SQL.
Oracle Extension to ANSI SQL. Business Logic and PL/SQL. Database Triggers. PL/SQL as a Query Helper. Packages. Supplied Packages. External Procedures. Hiding PL/SQL Code. Third Party Tools. Summary.

15. Getting Data In/Out of Oracle.
Communicating with the External World. Oracle Advanced Queuing. Perl—OraPerl/PerlDBI. Summary.

16. Communicating with the Server.
SQL*Net/Net8: The Main Road To Connect to an Oracle Server. When SQL*Net Is Not To Be Used. Middleware and ACID Messages. Summary.

17. Client Development Tools: Putting Them Into Practice.
ShrPool, an Oracle Shared Pool Browser. ShrPool Source Code. ShrPool in Visual Basic. ShrPool in Oracle Developer. ShrPool in Delphi. ShrPool in Powerbuilder. Summary.

18. Oracle Performance Tuning.
Two Areas Where Oracle Performance Can Fail. The Tool DBAs Need. OPERA Design. The OPERA Java Client. OPERA Server Source Code. Summary.

Index.
About the CD-ROM.

Caractéristiques techniques

  PAPIER
Éditeur(s) Prentice Hall
Auteur(s) Elio Bonazzi
Parution 15/09/2001
Nb. de pages 770
Format 17,8 x 23,3
Couverture Relié
Poids 1310g
Intérieur Noir et Blanc
EAN13 9780130200914

Avantages Eyrolles.com

Livraison à partir de 0,01 en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
satisfait ou remboursé
Satisfait ou remboursé
Paiement sécurisé
modes de paiement
Paiement à l'expédition
partout dans le monde
Livraison partout dans le monde
Service clients sav@commande.eyrolles.com
librairie française
Librairie française depuis 1925
Recevez nos newsletters
Vous serez régulièrement informé(e) de toutes nos actualités.
Inscription