goAskem.com Part II - Interesting Problems, Effective Solutions

John M. Thompson


Introduction

Object Ids

Problem Statement

Solution

Table GlobalIds

ClassName VARCHAR(32) Primary Key
AvailableId INTEGER
BlockSize INTEGER

top


Initializing The App

System 'Dead Start' - Initial System Install

Web App Servers are easy - all handled at Linux bootup

Web App Runtime Initialization

top


Encapsulating The SQL Encapsulation(!)

Selected Objects -- Tables (20 total)

ITestAdmin A goAskem assessment Administrator
ITest Any assessment - test or survey
ITestElement Any assessment element - text or question
ITestRespondent A Respondent to any assessment - single-access
ITestResponse An assessment element's response data

 

A New Table - IAdminAction: An account action taken by its Admin.

Question: How to introduce this class and table into the Web App?

Answer:

Generator Input:

Tablename: IAdminActionsXXX

int    id          Id          true    12
int    testAdminId TestAdminId true    12
Date   actionDate  ActionDate  tru
byte   actionType  actionType  true    4  0 
String notes       Notes       true    IGlobals.gVarChar100

Code walkthrough of generated code - especially
marshallData() and unMarshallData().

top


Everybody Into The Pool

Connection management can be the most performance-critical aspect of database application performance.

Requirements:

Solution:

top


Client-side Application Logic Without Applets

Chief advantages to Applets

Chief problems with Applets

Alternative - Use common HTML and JavaScript Constructs

Problems with HTML/JavaScript Alternative

Code walkthrough on goAskem.com Assessment Creation Wizard

top


TOC

Originals are accessible from  http://www.iwaytechnology.com/jt/index.html.


Copyright 2001
by John M. Thompson
Boulder, Colorado USA
jt@iwaytechnology.com
A limited right to copy this page for
individual (non-commercial)
educational use only
is hereby granted.