Select is an exclusive member benefit of the IOUG. Click here to find out how to join.

Click here to see other SELECT Journal issues

SELECT Journal
November 2000, Volume 8, No. 2

Features

• Using XSL as an Application Development Paradigm
  By Jeff Bernknopf
  XML was initially used in document-centric applications to store and transmit data between organizations. From these beginnings, XML has moved into a variety of other types of applications and has become an instrumental technology for ubiquitous web applications. This has moved the use of XML into such diverse application development areas as messaging applications, web-based portal applications, database web applications and server-side Java applications like servlets, JSPs and EJBs.
• The Need for Speed: Parallelize Your Database Script
  By Howard Fosdick
  For the past several years, Oracle Corp. and other database vendors have been "parallelizing" their products. Implementing parallelism in the DBMS dramatically reduces wall clock runtimes for common database operations.
• Documentation-Driven System Management Methodology
  By Eric Saperstein
  Everyone wants to jump at implementing the build documentation for applications and databases. Why not use a proven method for managing components to be assembled in a specific fashion into a finished product? Build documentation can and should be used as a blueprint for the construction of the entire workstation or server.
• Use EXPLAIN PLAN and TKPROF To Tune Your Applications
  By Roger Schrag
  Developers and DBAs use the EXPLAIN PLAN and TKPROF functions built into the Oracle 8i server to get the best performance out of their applications. Explore here how to invoke these tools both from the command line and from graphical development tools, and how to read and interpret Oracle 8i execution plans and TKPROF reports.
• Taming Ad-hoc Queries in a Very Large Data Warehouse
  By Sundaresh Valiveti
  In a large and geographically dispersed user population, understanding what users run against our databases is difficult, time consuming and an inexact science. To battle these problems, a series of SQL code was developed to identify potential end user-query issues.

Regular Columns

• From The Editor

Download Acrobat Reader
Copyright 2006 by the International Oracle Users Group

Contact Us | Download Acrobat Reader | Privacy Statement | Refund Policy
Copyright and Disclaimer | Discussion Forum Access | Secured Area Access Agreement

IOUG Headquarters • 401 N. Michigan Ave., 22nd Floor • Chicago, IL 60611 • (312) 245-1579 • ioug@ioug.org
Copyright 2000 - 2006 by the Independent Oracle Users Group