Oracle9i SQLJ Programming

Nirva Morisseau-Leroy, MSCS, is an Oracle Database Administrator and Application Developer at the National Oceanic and Atmospheric Administration (NOAA) University of Miami Cooperative Institute for Marine and Atmospheric Sciences, assigned to the Hurricane Research Division (HRD) of the Atlantic Oceanographic and Meteorological Laboratory (AOML). She has over sixteen years of information systems experience as an Oracle DBA, Application Developer, and MIS director utilizing, Java, JDBC, SQLJ, SQL, Oracle PL/SQL, and UNIX C/C++. Her major areas of expertise are in users' requirements elicitation, object-relational database analysis, design, implementation, and administration. She can be reached at nmorisseauleroy@data-i.com. Dr. Martin K. Solomon is an Associate Professor of Computer Science and Engineering at Florida Atlantic University. His major areas of research include the design, implementation, and theory of database systems, computational complexity theory, and the philosophical aspects of computability. Dr. Solomon has published articles on these topics in such prestigious journals as ACM Transactions on Database Systems, Communications of the ACM, Journal of Symbolic Logic, and British Journal for the Philosophy of Science. He has a strong professional internet in all aspects of the Oracle RDBMS, and is a frequent contributor to the South Florida Oracle Users Group Newsletter. Dr. Solomon can be reached by e-mail at: marty@cse.fau.edu. Gerald P. Momplaisir has been working professionally in the information technology field for over thirteen years. During this time, he served in the military in technical and management cpacities, and later at an NOAA environmental research laboratory where he functioned as a programmer/computer specialist--eventually ascending to Director of Computer Services. During the past eight years, he has specialized in Oracle, object-oriented systems, and internetworking technologies. His love for database systems and object-oriented technologies led him to attain a graduate degree in Computer Science after completing a thesis on the design and implementation of a financial system using a semantic (object-oriented) database and C++. A principal consultant and cofounder of Dati Inc., he currently works as a consultant, project manager, and certified trainer at midsize companies, government entities, and Fortune 500 corporations. He can be reached at gmomplaisir@data-i.com.

Part I: Basic Oracle9i SQLJ. Chapter 1: Introduction to Oracle9i SQLJ. Chapter 2: SQLJ Program Development. Chapter 3: Basic SQLJ Programming. Part II: Advanced SQLJ for Relational Processing. Chapter 4: Developing SQLJ Stored Programs and Triggers. Chapter 5: Advanced SQLJ Deployment. Chapter 6: Advanced SQLJ Functionality. Chapter 7: Advanced SQLJ Features. Part III: SQLJ and Object Deployment. Chapter 8: Object-Relational Processing Using SQLJ. Chapter 9: SQLJ Business and Scientific Object Deployment. Part IV: Effective Use of SQLJ. Chapter 10: SQLJ Applications: Performance Tuning. Chapter 11: Oracle9i Development Tools. Part V: Appendixes. A: Oracle SQL Basics. B: Java Basics. C: Introduction to Java Database Connectivity (JDBC). D: SQLJ Quick Reference Guide.