db-UIM/X Development of Database GUIs

Course Length: 2 Days

Key Objectives

• Visually connect database objects to GUI components across the network.
• Comprehend the Industry Standards of the software generated by db-UIM/X (e.g., CORBA).
• Achieve rapid client-server development capabilities maximizing use of db-UIM/X.

Course Overview

db-UIM/X is an enhanced version of UIM/X that allows GUI components to be graphically connected to relational databases in a client- server architecture. The course begins by reviewing the tool's application, its relation to UIM/X and the underlying industry standards by which it operates and generates code. db-UIM/X is then broken down into its functional layers and presented in a series of instructor-led demos and student exercises. Students will connect a simple GUI to a relational database and progress to more complex application development issues, while learning all of the tool's powerful features and flexibility. Seventy percent of the course is hands-on time.

Audience

This course is designed for UIM/X Applications and Database programmers, project leaders, and managers who want to understand how to use db-UIM/X to bind database components to GUIs across networks to develop production quality Client-Server systems using industry standards.

Prerequisite

• UIM/X 2.5

• Competence with the OSF/Motif widget set

Course Content

Introduction and Objectives of db-UIM/X

• Graphical User Interfaces
• Object Oriented Technology
• Client-Server Architectures
• Relational Databases
• Visual Programming

Architecture of db-UIM/X

• UIM/X Builder Engine
• CORBA and Object Request Broker (ORB)
• Network Object Toolkit
• Network Services
• C and C++ code generation
• Database systems (Sybase, Oracle, etc.)
• Stored Procedures

Introduction to Databases and SQL

• Tables, SQL, ISQL, Queries
• Stored procedures
• Client-Server model
• Connecting a simple GUI to a database
• Introduction to db-UIM/X project interfaces

Specific Reply Services

• Network Object Browser
• Stored Procedure Viewer and Selector
• Network Object Bind Editor
• Server Manager

Data Caching

• Programming the cache
• Cache options
• Insert, Update, and Delete

Additional Features

• Conditional Logic
• Multiple Stored Procedures in a callback
• Synchronous versus Asynchronous mode
• Control flow logic
• Object Oriented Techniques

Enhancements and Customizing db-UIM/X

• Integrating Xm, Ux, C function calls
• Population Callback Functions
• db-UIM/X Populate and Extract Operations
• Programming drop and drag actions of db-UIM/X
• Writing a Population Callback
• Periodic updates

Project Management Issues

• Map files
• Duplicating components
• Duplicating Interfaces
• Using instances, components and palettes
• Duplicating Bindings
• Refreshing Procedures
• Replacing and Aliasing Server Names

Configuration Issues

• Environment Variables
• Resource Files
• Starting the Orb