Transcript No Slide Title

Hencie Consulting
Services
http://www.hencie.com
Building a Knowledge Share
System Using Oracle Designer
SCOUG 2000 Conference
By
Murli Manickam
Sameer Jejurkar
1
Agenda





Knowledge Share System (KSS)
Introduction to Oracle Designer
HKSS Architecture and components
Demo - HKSS and generation of a web
server module from designer
Q&A
SCOUG 2000 Conference
2
Need for a KSS







Similar situations, similar problems
Avoid re-inventing the wheel
Save time and money
Human turnaround
Jumpstart for new users
Can help to build metrics
Custom build to your requirements
SCOUG 2000 Conference
3
What is a KSS



A central repository of information
Keep track of problems and solutions
Evolves over a period of time
SCOUG 2000 Conference
4
Our Goals

Quick, easy access

to enter information
 retrieve information
 from anywhere




Easy to use - no training needed
Accessible by developers, DBAs, clients
Develop quickly, but systematically
Flexible, Extensible
SCOUG 2000 Conference
5
Why Oracle Designer






Complete integrated life cycle CASE tool
Supports a variety of methodologies including
classical SDLC, RAD, prototyping etc.
Supports generation for a variety of
applications
Strong support for modeling
System documentation
Good Oracle skills in-house
SCOUG 2000 Conference
6
Support for Various Phases





Analysis - support for logical models
Design - support for physical database design
and application design
Development - support for SQL DDL and
application code generation
Deployment - support for multiple schemas,
instances and databases
Variety of QA and other reports
SCOUG 2000 Conference
7
Designer Repository





Designer adopts a repository driven approach
Repository - most important part of Designer
A schema in Oracle database
Store for all meta-data
Multi user capability
SCOUG 2000 Conference
8
Analysis Tools





Business process modeling
Entity Relationship modeling
Data Flow modeling
Function Hierarchy diagramming
All tools are integrated
SCOUG 2000 Conference
9
ER Modeling in Designer




Graphical ER diagrammer
Support for M:1, M:M, 1:1 relationships
Extensive data dictionary support for
information about entities, attributes, domains
and relationships
Support for advanced features like arcs and
super/sub type entities
SCOUG 2000 Conference
10
ER Diagram
SCOUG 2000 Conference
11
Database Design Tools



Database design transformer for first cut of
database design
Graphical server modeling
Manage definitions for

tables
 columns
 constraints
 views
 snapshots
SCOUG 2000 Conference
12
Server Model
SCOUG 2000 Conference
13
Server side PL/SQL


Logic editor to define the procedural logic for
business rules
Support for

Drag and drop editing
 Automatic text formatting
 Syntax checking against repository definitions

Define logic for pre-defined events

before/after insert/update/delete row/statement
SCOUG 2000 Conference
14
Logic Editor
SCOUG 2000 Conference
15
Physical Design



Report with Estimates the size of tables and
indexes
Define table storage characteristics
Define tablespaces, data files
SCOUG 2000 Conference
16
Database Deployment




Server model generator to generate SQL DDL
scripts for database objects based on
repository definitions
Generates Table API
Define deployment properties separately
Generate DDL for multiple databases and
schemas
SCOUG 2000 Conference
17
Function Hierarchy Diagram
SCOUG 2000 Conference
18
Application Design





Application Design Transformer for first cut
module design
Graphical module design editor
Multiple views - data view and display view
Define table usage - base and look ups
Define column usage - appearance, format,
order
SCOUG 2000 Conference
19
Module Diagram
SCOUG 2000 Conference
20
Application Generation

Generate applications for

Oracle Developer - Forms, Reports
 Visual Basic
 Oracle Web Server (PL/SQL)


Generate MS Help
Control generation using

preferences at module/table/column levels
 templates
SCOUG 2000 Conference
21
Generated Module
SCOUG 2000 Conference
22
Repository Reports

Matrix Diagrammer


CRUD matrix for entities v/s functions
Repository reports

quality assurance
 matrix reports
 impact analysis
 function point analysis
 table and index size estimation
SCOUG 2000 Conference
23
HKSS Architecture

Uses three tier architecture

backend - Oracle database
 middle tier - Oracle Application Server
 client - any browser that supports HTML and
JavaScript
SCOUG 2000 Conference
24
Design and Generation



Completely designed and generated using
Designer with the web server generator
PL/SQL packages that use the PL/SQL tool
kit supplied with OAS
Hand coding for

Main menu
 Page header
SCOUG 2000 Conference
25
WSG in Designer
SCOUG 2000 Conference
26
HKSS Components






Incidence/Problem Logging
Log in new incidence request
Assign request to a knowledge worker
View incidence requests and their status
Record steps in incidence resolution
Keep track of time spent
SCOUG 2000 Conference
27
Possible Enhancements





Upload scripts and documents
Intelligent search capabilities
Portal interface
Workbench for employees
Metrics
SCOUG 2000 Conference
28
Demo
SCOUG 2000 Conference
29
Contact Information
Hencie Consulting Services
http://www.hencie.com
Murli Manickam
([email protected])
Sameer Jejurkar
([email protected])
SCOUG 2000 Conference
30