This up-to-date book on client/server computing covers all versions of Oracle7. It contains a thorough introduction to the SQL and PL/SQL languages, practical ways to exploit Oracle7's client/server architecture, and smart ways to distribute applications between client and server. It also features a tutorial chapter on CASE Tools. This is essential reading for application developers, database administrators, and managers who must evaluate Oracle7 and its capabilities before purchase.
Table of Contents
Foreword xxviiIntroduction xxxi PART I Introduction to Client/Server Computing 1 and Oracle7 What Are Client/Server and Oracle7 Anyway 3 The Server in Client/Server 17 The Client in Client/Server 71 Between Client and Server: Networking Issues 95 Client and Server Communication: SQL and 111 PL/SQL PART II Database Administration in an Oracle7 153 System Understanding Oracle7 Database Administration 155 and Administrative Utilities Basic Database Administration 191 Configuring the Oracle7 Server for User 229 Connections Securing an Oracle7 Database 271 Database Administration on Behalf of 299 Applications Protecting Work and Data 337 Monitoring and Tuning Database Server 381 Performance PART III Application Development in an Oracle7 407 System Application Development for Oracle7 409 Designing an Application's Schema 423 Tuning Applications with Database Structures 457 Tuning Application Logic 479 Centralizing Application Logic in the 511 Database Server Securing Applications 551 Rapid Application Development with Oracle's 563 Designer/2000: A Tutorial APPENDICES Index 681