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 is 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.

Training Date(s) / Location
This 2-day course can be taught immediately following UIM/X or independently. Call Keith Kaufman at 800-639-9566 or email keith@Bluestone Consulting.com for scheduling information.

Key Benefits

• 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.

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.

• UIM/X course or development experience
• 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
• Stored Procedure Selector
• Network Object Bind Editor
• Network Bind Browser
• Server Manager

Data Caching

• Programming the cache
• Cache options
• Insert, Update, and Delete operations using data caching

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