BC remote Oracle DBA - Call (800) 766-1884  
Oracle Consulting Oracle Training Development

Remote DBA

Remote DBA Plans  

Remote DBA Service

Remote DBA RAC

   
Remote DBA Oracle Home
Remote DBA Oracle Training
Remote DBA SQL Tuning Consulting
Remote DBA Oracle Tuning Consulting
Remote DBA Data Warehouse Consulting
Remote DBA Oracle Project Management
Remote DBA Oracle Security Assessment
Remote DBA Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Links
Remote DBA Oracle Monitoring
Remote DBA Support Benefits
Remote DBA Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices





   

 

 

 

Remote DBA services

Remote DBA Support

Remote DBA RAC

Remote DBA Reasons

Remote Oracle Tuning

Remote DBA Links

Oracle DBA Support

Oracle DBA Forum

Oracle Disaster

Oracle Training

Oracle Tuning

Oracle Training

 Remote DBA SQL Server

Remote MSSQL Consulting

Oracle DBA Hosting

Oracle License Negotiation

 

 


 

 

 

 

 

 
 

Oracle Tips 

by Burleson Consulting

The Data Warehouse Development Life Cycle

Oracle Data Warehouse Design
Creating An SQL Generating Front End

After setting the constraints, the user selects which fields will be displayed in the query results. The next screen, shown in Figure 4.19, adds a tremendous amount of flexibility to the front end, allowing end users to create an almost infinite variety of custom reports. The screen determines the objects of the SQL SELECT and ORDER BY statements.

Figure 4.18  Choosing the display values and sort order.

By interrogating the values from the screen, the appropriate mainframe Job Control Language (JCL) and SQL are created and shipped to the internal reader of the IBM mainframe. Users are notified that JOB xxx HAS BEEN SUBMITTED, and they are notified of the completion by using the NOTIFY JCL statement. Users are then free to browse or print the results of their SQL statement. As is true with most decision support systems, the answer to one query often stimulates additional questions. Users can swap screens, thereby viewing output on one screen while creating a new query on another.

REXX routines are very simple to generate, and an understanding of the structure of SQL allows for very quick development of an SQL generator that can display any of the data items in the desired form or sequence. The screens are generated very quickly with SDF in ISPF, and, as, mentioned, the REXX routines are very straightforward.

It is not enough to have SQL used only as an access tool. End users demand simple, check-the-box access to their data, and they are often unwilling to use ad hoc SQL tools such as QBE. By creating this simple front end for SQL, the best possible outcome for the IS project is achieved. Listing 4.2 shows the REXX code used to generate the SQL. It is in three sections: the SELECT portion, the FROM portion, and the WHERE clause. Note that this system has two levels of aggregate details, and the SQL generator points to either detail or summary tables depending on the type of end user query.


This is an excerpt from "High Performance Data Warehousing". To learn more about Oracle, try "Oracle Tuning: The Definitive Reference", by Donald K. Burleson.  You can buy it direct from the publisher at 30% off here:
http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm
 

 


Expert Remote DBA

BC is America's oldest and largest Remote DBA Oracle support provider.  Get real Remote DBA experts, call
BC Remote DBA today.

 

 

Remote DBA Service
 

Oracle Tuning Book

 

Advance SQL Tuning Book 

BC Oracle support

Oracle books by Rampant

Oracle monitoring software

 

 

 

 

 

 

BC Remote Oracle Support

Remote DBA

Remote DBA Services

Copyright © 1996 -  2013 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.