ISODataDreamer

1
ISODataDreamer

• When the Data Dreams come true !

2
10,000 feet overview

• ISODataDreamer is an application which extracts
  the information from the already existing tables
  and generates a standard object oriented java
  code according to table relations.
• Even more if you have not created your tables yet
  , Then you can create the Tables and web
  application from your class diagram in Rational
  Rose !
• It also generates a Java Server Page User
  Interface. The end user is able to insert,
  update, remove, search and sort the data through
  this fully configurable web interface.

3
ISODataDreamer requirments

• Tables should be related with the wellknown oid,
  whose unique value is gained through OID table.
• JDBC driver for your DataBase.

4
Quick Start

• Start with these two simple tables which are
  related through LAND_OID.

LAND Table
BUNDESLAND Table
5
What are your Data Dreams ?
Using ISODataDreamer You are just Six steps away
from your Data Dreams !

• Accessing your data through a web based
  application
• User friendly data manipulation
• A Standard reusable Java Data Layer
• Bug free Java Source code
• Lazy on Load Pattern Implementation
• General OID Implementation
• All main data types support

• Implementation of Object relations such as
  aggregation and refrences
• Exception handling
• Scrollable Recordset
• Data Caching
• Running User made queries through a query
  designer
• Sorting on selected fields
• Forward and Backward lookup

6
Step 1 Create an ISODataDreamer Project

• Create a new IsoDataDreamer project using the
  provided wizard in JBuilders Object Gallery.

7
Step 2.a Connect to DataBase

• If the tables already exist, Open the created
  ISODataDreamer configuration file ( .idd files )
  to load the project configurations and then
  connect to the database.

8
Step 2.b Create XMLs and tables from Rational
Rose

• Or If you do not have the tables yet, just create
  them from your class diagram using the
  ISODataDreamer add-in for Rational Rose! and then
  jump to step 5.

9
Step 3 Set the Relations

• ISODataDreamer then extracts the relations out of
  tables and constructs the relations data.
• The only thing you should specify is the name of
  field showing the inter table relation in the
  user interface.
• This field will be shown as a list of selections
  in the user interface.

10
Step 4 Generate XML Metadata

• Then you should create the intermediate XML files
  for each table.
• To do this simply set the UI settings such as
  Insert row, Edit row, Delete row, Search, number
  of page rows and cascading style sheet name, and
  then generate the XML files.

11
Step 5 Customizing Views

• Then Customize the user interfaces by selecting
  the visible fields of table and editable fields.

12
Step 6 Generate Java Sources

• And finally generate the java Code. The generated
  codes will be placed in the specified paths and
  you can easily compile and run the results.

13
And Now you Data Dreams come true !
14
Generated View for LAND Table
15
Technologies and softwares used

• Apache Xalan-Java
• Apache Cocoon
• Apache Xerces
• Jakarta Ant
• JDBC,JSP
• Rational Rose Scripting
• JBuilder Opentool
• Cascading Style Sheets