Database Answers

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Template

  Dynamic PSP Page
 

This page discusses Dynamic PL/SQL Pages which build on Oracle's PL/SQL.

1) A Data Dictionary is central and stores the specifications
    1.1 Requirements - The DBA_ADMIN Role can enter new Types and new Data. 
    1.2 Requirements - The PUBLIC Role can look at any Data but cannot make changes.
    1.3 Review the Data Model

2) Generic Standard Templates provide MetaData-driven Applications development.

3) Performance Reporting and KPIs ...

And here's a couple of related Pages :-

  • KPI Definitions
  • KPI Reporting.
  • Data Models have been created for for simple KPIs and complex KPIs Here's an example of the World Language Classification,and the WebRecruiter Site, which was developed using Dynamic PSP. Finally, here's a Template, and an application of the Template to a Data Dictionary.

  •   Development Prototypes
     

    Some Useful Links
     
    Getting Started with Dynamic PSP
      The Editor
      Getting Started with Dynamic PSP
    Specifications
    Data Dictionary Sample Page to display Data Dictionary
      Display Best Practice entries in the Data Dictionary
      Display Glossary of Terms in the Data Dictionary
      Template to display Entries in the Data Dictionary
    Demonstrations
    Data Dictionary (1) Data Dictionary Page - Desperado in draft.
    Data Dictionary (2) Data Dictionary Page - currently not working.
      Display the Entry Types in the Dictionary. with each Type being clickable to display all Contents of that Type.
      Table Column Mapping - currently not working.
      Table Mapping (1) - currently not working.
      Table Mapping (2) - currently not working.
    Tracking Evidence This Application has been developed using Dynamic PSP for a Police Department in Florida.
    World Languages This Application combines the power of Dynamic PSP with Oracle's extensions to SQL to display hierarchies.
     

    Home Ask a Question Careers Contact us Data Models First Timers Search Site Map