Oracle Development

by Hotka, Dan; Hotha, Dan; Advanced Information Systems, Inc.

• ISBN13: 9780672315756
• ISBN10: 0672315750
• Edition: 3rd
• Format: Paperback
• Copyright: 1999-06-01
• Publisher: Sams

Summary

Written by experienced Oracle developers, Oracle Unleashed teaches you how to build complex and sophisticated applications from start to finish using the newest features of Oracle8i, including SQLJ, JavaBeans, CORBA, and the Java Virtual Machine. Learn how to use the latest versions of Oracle Designer, Oracle Developer, and Oracle Discoverer, as well as develop programs that use Oracle's new enterprise management tools. You will also explore the fundamentals of Oracle database design, development, and administration and progress quickly to using Oracle's tools and products to make these tasks easier and faster. This edition focuses specifically on the tools Oracle developers use or need to understand.

Author Biography

Dan Hotka brings two decades of technology expertise--including almost 15 years with Oracle systems--to his role as a Senior Technical Marketer with Platinum Technologies. He's worked as a developer, consultant and Oracle DBA.

Table of Contents

Introduction	p. 1
Oracle Company Overview	p. 5
Understanding the Oracle Corporation	p. 6
Oracle's Soul Kitchen: The Database Appliance	p. 12
Introducing the Cartridge	p. 15
The Universal Data Server, Oracle8i	p. 18
The Oracle Alliance	p. 18
Oracle Alliance Value Service	p. 19
Oracle Support	p. 20
The Support Olympics: Bronze, Silver, or Gold?	p. 20
Customer Support Identification Number	p. 21
Crossing the TAR Pits	p. 21
Oracle's Automated Support	p. 23
The Oracle Technology Network	p. 24
Oracle: A Step Further	p. 25
What is an RDBMS?	p. 29
The Relational Database Model	p. 30
RDBMS Components	p. 35
Nonprocedural Data Access (SQL)	p. 37
Databases and the World Wide Web	p. 38
Oracle, Client/Server, and Enterprise Computing	p. 41
Client/Server Computing	p. 42
An Overview of Client/Server Computing	p. 42
Databases in a Client/Server Architecture	p. 43
Oracle and Client/Server Computing	p. 44
Oracle Directions	p. 49
Overview of the Oracle Architecture	p. 51
Architecture	p. 52
Computer Architecture Fundamentals	p. 52
Global View of the Oracle Architecture	p. 53
Oracle Files	p. 58
System and User Processes	p. 60
Oracle Memory	p. 67
Storage	p. 70
System Database Objects	p. 74
Protecting Your Data	p. 76
Backup and Recovery	p. 83
Distributed Databases	p. 90
National Language Support	p. 91
Data Warehousing	p. 91
Following a SQL Statement Through the Architecture	p. 92
Oracle7 Workgroup Server	p. 95
Overview of the Oracle7 Workgroup Server	p. 96
System Requirements	p. 102
Oracle7 Workgroup Server Tools and Utilities	p. 106
Oracle7 Workgroup Server Distributed and Replication Features	p. 111
When to Use Oracle7 Workgroup Server	p. 113
Oracle8i Server	p. 117
Architectural Overview	p. 118
Oracle SGA	p. 119
New Features for Oracle8 and Oracle8i	p. 123
Oracle8i Enterprise Server	p. 159
An Oracle8 Server Feature Overview	p. 160
An Overview of Oracle8i Server	p. 161
Personal Oracle8i Overview and Features	p. 161
Oracle8i Server Overview and Features	p. 163
Oracle8i Enterprise Edition Overview and Features	p. 164
Oracle Application Servers Overview	p. 165
Oracle8i Database Tools and Utilities	p. 166
Oracle8i Feature Summary	p. 168
Oracle Web Application Server	p. 171
Architectural Overview	p. 173
Component Interaction	p. 177
Installation and Configuration	p. 181
Using Supplied Cartridges	p. 185
Developing Cartridges with the WRB API	p. 197
Electronic Commerce Server	p. 201
What Is Electronic Commerce?	p. 202
Is Electronic Commerce a Solution for My Business?	p. 206
The Architecture of Oracle's Internet Commerce Server	p. 210
A Peek at Some of the Third-Party Internet Commerce Server Cartridges	p. 214
Oracle Applications for the Web	p. 215
Encryption and Electronic Commerce	p. 217
SQL	p. 223
Oracle's SQL: An Overview	p. 224
Datatypes	p. 225
The Create Statement	p. 228
Writing Queries	p. 237
The Decode Statement	p. 253
Inserts, Updates, and Deletes	p. 254
Master/Detail or Parent/Child SQL	p. 258
Additional Tips	p. 259
PL/SQL--SQL Procedural Language	p. 261
Packaged Procedures	p. 262
Creating Package Subprograms	p. 264
Cursors	p. 267
Procedure Variables	p. 270
Scalar Datatypes	p. 273
Composite Datatypes	p. 275
Processing Control	p. 277
Exception Handling	p. 281
Comments	p. 283
Stored Procedures	p. 284
Commits	p. 286
The Standard Package	p. 287
Additional Topics	p. 288
Oracle8 Enhancements	p. 296
SQL*Plus	p. 299
A Brief History of SQL*Plus	p. 300
Use and Limitations	p. 300
Platforms	p. 301
SQL*Plus Commands	p. 302
Character-Mode Environments	p. 303
Graphical-Mode Environments	p. 305
SQL*Plus Reporting	p. 313
SQL*Plus Additional Functionality	p. 323
Server Manager	p. 331
Introduction to Server Manager	p. 332
Server Manager Operation Modes	p. 334
Server Manager in Line Mode	p. 334
Server Manager in Command Mode	p. 337
Server Manager Command Reference	p. 342
Enterprise Manager	p. 361
Oracle Tools and Utilities	p. 362
Installing Enterprise Manager	p. 363
The Enterprise Manager Console	p. 363
Backup Manager	p. 371
Data Manager	p. 373
Instance Manager	p. 377
Schema Manager	p. 378
Security Manager	p. 379
Software Manager	p. 380
SQL Worksheet	p. 380
Storage Manager	p. 381
SQL*Loader	p. 383
Basic SQL*Loader Components	p. 384
Physical Versus Logical Records	p. 389
Concatenated Records	p. 390
SQL*Loader Paths	p. 390
Parallel Data Loading	p. 394
Control File Syntax	p. 396
Command-Line Options and Parameter Files	p. 410
Import and Export	p. 413
Import and Export	p. 414
Export	p. 414
Import	p. 427
Import and Export Hints and Tips	p. 438
Managing the Database	p. 441
The Parameter File: INIT.ORA	p. 442
The Oracle SID	p. 448
Creating a New Database	p. 448
Startup and Shutdown	p. 452
The Data Dictionary	p. 457
Redo Logs	p. 460
Control Files	p. 462
Trace and Alert Files	p. 463
Database Modes	p. 464
Useful Data Dictionary Views	p. 466
Managing Disk Space	p. 483
Obtaining Object Storage	p. 484
Using the ROWID in Oracle8 and 8i	p. 489
Using the Storage Clause	p. 490
Using Rollback Segments	p. 493
Using Tablespaces	p. 496
Using Temporary Segments	p. 499
Analyzing Storage	p. 499
Estimating Storage for a Table	p. 500
Managing Users	p. 501
User Needs Analysis	p. 502
User Authentication Methods	p. 507
User Configuration Setup	p. 509
Resource Management	p. 512
User Database Accounts	p. 522
Special Account Considerations	p. 528
Maintaining User Data	p. 530
Backup and Recovery	p. 533
Importance of Backups	p. 534
Terminology	p. 535
Requirements for Backups	p. 545
Optimal Flexible Architecture	p. 548
Types of Backups	p. 549
Alternative Backup Methods	p. 560
Types of Database Failure	p. 565
Recovery Methods	p. 569
Sample Database Backup Scripts	p. 574
Performance Tuning and Optimization	p. 579
General Concepts in Database Tuning	p. 580
Parallel Processing	p. 588
Parallel Server Option	p. 588
Parallel Query Option	p. 589
Performance Tools	p. 590
Tuning Database SGA	p. 603
Contention Issues	p. 612
Database Objects	p. 619
Database Locking	p. 627
Database Security	p. 631
Authentication	p. 633
Why Protect Passwords?	p. 637
Privileged Accounts	p. 640
Remote Passwords	p. 643
Object Versus System Security	p. 644
Object Seucrity Model	p. 655
Defining Database Roles	p. 658
Database Auditing	p. 666
Designing a Database	p. 675
Defining Requirements	p. 676
The Logical Model	p. 679
The Physical Model	p. 687
Object-Oriented Programming with Packages	p. 707
The Package Specification	p. 709
The Package Body	p. 711
Package Privileges	p. 720
Accessing Oracle Packages from Client Applications	p. 723
Object-Oriented Concepts	p. 725
Transaction Processing	p. 733
Introduction to Transactions	p. 734
Transaction Control	p. 735
Read Consistency	p. 737
Types of Transactions	p. 738
Processing a Standard Transaction	p. 743
Processing a Remote or Distributed Transaction	p. 752
Transaction Space	p. 755
Enforcing Integrity	p. 757
A Common Integrity Problem	p. 758
Column Constraints	p. 761
Table Constraints	p. 768
Using Sequences	p. 772
Using Triggers	p. 774
Application and performance Considerations	p. 780
Application Security	p. 785
Reasons for Using Application Security	p. 786
Using Application-Specific Database Objects	p. 787
Table-Driven Application Security	p. 792
Application and Performance Considerations	p. 802
Oracle8 Cartridges	p. 805
What Do We Mean by Secure I-Commerce?	p. 808
What Is SSL X.509 v3?	p. 808
CORBA/IIOP and Cartridges	p. 811
Oracle Web Request Broker and Cartridges	p. 812
Developing Cartridge-Driven Applications	p. 815
Cartridge Implementations	p. 816
PL/SQL Cartridge with Java Class Wrapper and HTML Output	p. 817
Introduction to and Installation of Oracle Designer	p. 821
Business Process Reengineering	p. 823
Information Engineering	p. 824
Rapid Application Development	p. 825
Legacy-Led Development	p. 826
Installing Oracle Designer	p. 826
System Requirements	p. 827
Back Up, Back Up, Back Up	p. 829
Upgrading to Oracle Designer	p. 829
Client Installation	p. 830
Server Installation	p. 836
Repository Administration	p. 843
The Repository Administration Utility	p. 845
The Matrix Diagrammer	p. 854
The Repository Object Navigator	p. 855
Repository Reports	p. 860
System Modeling and Design	p. 861
General User Interface	p. 863
Entity Relationship Diagrammer	p. 864
Functional Hierarchy Diagrammer	p. 872
Dataflow Diagrammer	p. 878
Modeling System Requirements	p. 882
Database Transformer	p. 883
Application Design Transformer	p. 884
Design Editor	p. 885
Introduction to Oracle Developer	p. 887
What Is Oracle Developer?	p. 888
Features of Oracle Developer	p. 892
Common Tool Set Features	p. 894
Form Builder	p. 897
The Forms Environment	p. 898
Using Boilerplate Text and Graphics to Enhance Forms Applications	p. 911
Customizing Forms with Properties	p. 913
Implementing Triggers and Program Units	p. 914
Using Record Groups and Lists of Values for Data Validation	p. 918
Using Relationships to Link Separate Blocks in a Form	p. 921
Mouse Events, Timers, and Other Advanced Widgets	p. 923
Considerations for Multiple-Form Applications	p. 932
Techniques for Dynamic Runtime Applications	p. 933
Working with Menus	p. 935
Libraries, Object Classes, and Visual Attributes	p. 937
Quality Considerations for Forms	p. 938
Report Builder	p. 941
The Reports 3.0 Environment	p. 942
Constructing a Tabular Report	p. 950
Creating a Group Above Report	p. 953
Using Secondary Queries	p. 954
Adding Report Break Levels	p. 956
Customizing Reports with Boilerplate Text and Graphics	p. 960
Working with Summary and Formula Columns	p. 967
Formatting Reports	p. 970
Exploring Complex Reports	p. 973
Creating Dynamic Reports	p. 976
Graphics Builder	p. 979
The Oracle Developer Graphics Environment	p. 980
Defining Displays	p. 985
Defining Parameters for Charts	p. 990
Multiple Chart Applications	p. 991
Formatting Charts with Text and Breaks	p. 996
Advanced Formatting Techniques	p. 1000
Oracle Developer Integration	p. 1003
Displaying Graphics in Form Builder	p. 1004
Executing Reports from Form Builder	p. 1007
Displaying Graphics in Report Builder	p. 1008
Interfacing with Non-Oracle Applications	p. 1008
Interfacing with the Windows API and Other DLLs	p. 1011
Looking Ahead to Developer 6.0	p. 1012
Introduction to Oracle Objects for Ole	p. 1013
Components of OO4O	p. 1014
OO4O and the Open Database Connectivity API	p. 1017
Host Environments	p. 1017
Oracle Ole Automation Server	p. 1019
Understanding the OO4O Background	p. 1020
Getting Started	p. 1021
Executing SQL Statements and PL/SQL Blocks	p. 1023
Using Parameters	p. 1026
The OraDynaset Edit, Update, and AddNew Methods	p. 1032
LONG and LONG RAW Column Support	p. 1034
Transactions	p. 1035
Error Handling	p. 1037
Performance Tuning	p. 1038
Thread Safety	p. 1041
The Oracle Data Control	p. 1043
Using the ODC in Visual Basic	p. 1044
Using the ODC and OO4O Automation Server Objects	p. 1044
Introduction to Oracle Discoverer	p. 1047
Multidimensional Database Primer	p. 1048
A Semi-Formal Definition of OLAP	p. 1054
Multidimensional Storage Strategies--A Star Schema Is Born	p. 1056
Discoverer as a Tool for Data Warehousing	p. 1059
Discoverer 3.1--Features, Functions, and Benefits	p. 1060
Using Discoverer for Reports	p. 1065
Creating the Tutorial and Video Databases	p. 1067
Creating the OLAP Database	p. 1069
Creating the Sample Database	p. 1070
Mapping Data from a Database into Discoverer: The Load Wizard	p. 1071
Moving Around in the Land of Folders and Items	p. 1073
The Administration Tasklist: Don't Enter the Dimensions Without It!	p. 1074
The Discoverer 3.1 User Edition	p. 1082
Multidimensional Databases: The Possibilities Are Endless	p. 1085
OLAP of the Mind	p. 1087
Programmer/2000	p. 1089
Oracle Precompilers	p. 1090
Why Precompile Source Code?	p. 1090
General Precompiler Features	p. 1091
Precompiler Languages	p. 1091
ANSI/IO Standards	p. 1092
Precompiler Options	p. 1092
How to Precompile a Program	p. 1094
Conditional Precompiling	p. 1094
Embedded SQL Host Programs	p. 1095
Basics of a Host Program	p. 1095
Host Program Requirements	p. 1098
Error Handling	p. 1106
Host Arrays	p. 1111
Dynamic SQL	p. 1112
Coding Methods for Dynamic SQL Statements	p. 1115
User Exits	p. 1118
Performance Tuning	p. 1119
Oracle Call Interface (OCI)	p. 1122
SQL*Module	p. 1122
Productivity, Security, and Performance	p. 1122
New Features in Version 8.0	p. 1123
Using PowerBuilder	p. 1125
Connecting to the Database	p. 1126
Communicating with the Database	p. 1128
Using Visual Basic	p. 1137
Third-Party Products That Decrease Development Time and Add Value	p. 1138
Immediate Benefits to RAF Users	p. 1139
Rapid Application Foundation	p. 1139
RAF Courses	p. 1139
Connecting to the Database	p. 1140
Using Delphi	p. 1151
Configuring a Data Source	p. 1152
Communicating with the Database	p. 1154
Putting Information on the Web	p. 1163
The Birth of the Web	p. 1164
Why Put Information on the Web--Benefits and Pitfalls	p. 1168
HTML	p. 1170
The Medium Is the Message	p. 1180
The Role of the Browser	p. 1183
HTML and Oracle's Web Server	p. 1184
Oracle's interMedia Product	p. 1187
VRML and Oracle8i Spatial	p. 1188
Oracle Web Programming with Java and Perl	p. 1191
Java Basics	p. 1192
The Java Object Model	p. 1192
The Java Language	p. 1195
Advantages of Using Java	p. 1204
CORBA Fundamentals	p. 1205
CGI Programming with Perl	p. 1229
Web Database Connectivity	p. 1237
Writing JDBC Applets and Applications	p. 1240
Handling JDBC Exceptions	p. 1256
JDBC Debugging	p. 1260
Deployment Issues	p. 1261
Using RMI	p. 1264
Using JavaIDL	p. 1266
Applets Versus Java Application and Security Considerations	p. 1269
Advanced JDBC Application Design	p. 1271
Performance Considerations and Multi-Threading	p. 1271
Writing a JDBC Driver	p. 1273
JDBC-Native Interface Mapping	p. 1273
JDBC Conformance	p. 1274
Using JNI	p. 1275
The Future of JDBC	p. 1277
Putting an Application on the Web	p. 1279
Planning Your Web Applications	p. 1280
Oracle8i and the Cartridge	p. 1286
PL/SQL Web Applications	p. 1290
Creating a Cartridge Using C	p. 1294
Java	p. 1301
Networking	p. 1307
A Quick and Dirty Introduction to Networking	p. 1309
An Overview of Oracle Networking	p. 1312
Host/Terminal Connections	p. 1314
Client/Server Connections	p. 1315
Web/Internet Connections	p. 1318
Database-to-Database Connections	p. 1321
Net/8 and SQL*Net	p. 1324
ODBC, JDBC, and OLE	p. 1330
Sample Configurations	p. 1331
Network Development Tips	p. 1334
Parallel Processing	p. 1337
Understanding the Requirements for Parallel Processing	p. 1338
Leveraging Parallel Processing Platforms	p. 1340
Oracle8i's New Cache Fusion Technology	p. 1344
Oracle Server Scalable Parallel Architecture for Open Data Warehousing	p. 1344
Oracle Parallel Architecture: An Overview	p. 1348
The Oracle Advantage over Pure Systems	p. 1358
Parallel Processing Platform Hardware Configuration Requirements	p. 1363
Making the Right Choice	p. 1369
Routine Parallel Platform Server Maintenance	p. 1373
ODBC	p. 1377
Components of ODBC	p. 1378
Configuring an ODBC Data Source	p. 1379
Connecting to an ODBC Data Source Using the ODBC API	p. 1383
Setting Connection Options	p. 1387
Applying SQL Transactions	p. 1388
Retrieving Result Sets	p. 1392
Handling Errors	p. 1396
Calling Stored Procedures and Functions	p. 1398
Disconnecting and Freeing Resources	p. 1401
Debugging ODBC Applications	p. 1402
Limitations of ODBC	p. 1403
JDBC	p. 1405
JDBC Setup	p. 1407
Using the JDBC Drivers	p. 1419
JDBC Capabilities and Limitations	p. 1423
Data Warehouses and Data Marts	p. 1433
An Introduction to Data Warehouses and Data Marts	p. 1435
Typical Uses of Data Warehouses	p. 1443
Designing a Data Warehouse	p. 1444
Star Join Schema	p. 1450
Tuning Data Warehouses in Oracle	p. 1451
Oracle Data Marts	p. 1451
OLAP Engines	p. 1453
Index	p. 1455
Table of Contents provided by Syndetics. All Rights Reserved.