1 / 30

Hencie Consulting Services hencie

Hencie Consulting Services http://www.hencie.com. Building a Knowledge Share System Using Oracle Designer SCOUG 2000 Conference. By Murli Manickam Sameer Jejurkar. Agenda. Knowledge Share System (KSS) Introduction to Oracle Designer HKSS Architecture and components

wesley
Download Presentation

Hencie Consulting Services hencie

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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

More Related