Hencie Consulting Services hencie

1. Hencie Consulting Serviceshttp://www.hencie.com Building a Knowledge Share System Using Oracle Designer SCOUG 2000 Conference By Murli Manickam Sameer Jejurkar

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

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

4. What is a KSS • A central repository of information • Keep track of problems and solutions • Evolves over a period of time SCOUG 2000 Conference

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

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

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

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

9. Analysis Tools • Business process modeling • Entity Relationship modeling • Data Flow modeling • Function Hierarchy diagramming • All tools are integrated SCOUG 2000 Conference

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

11. ER Diagram SCOUG 2000 Conference

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

13. Server Model SCOUG 2000 Conference

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

15. Logic Editor SCOUG 2000 Conference

16. Physical Design • Report with Estimates the size of tables and indexes • Define table storage characteristics • Define tablespaces, data files SCOUG 2000 Conference

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

18. Function Hierarchy Diagram SCOUG 2000 Conference

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

20. Module Diagram SCOUG 2000 Conference

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

22. Generated Module SCOUG 2000 Conference

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

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

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

26. WSG in Designer SCOUG 2000 Conference

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

28. Possible Enhancements • Upload scripts and documents • Intelligent search capabilities • Portal interface • Workbench for employees • Metrics SCOUG 2000 Conference

29. Demo SCOUG 2000 Conference

30. Contact Information Hencie Consulting Services http://www.hencie.com Murli Manickam (mmanicka@hencie.com) Sameer Jejurkar (sjejurka@hencie.com) SCOUG 2000 Conference