Sunday, May 29, 2011

Categorisation of Requirements to Process Data Warehouse


Here a general overview of the categories of requirements to a PDW is given.

  • data
    • general
      • large amount → scalable
    • audit trail logs
      • distributed heterogen
        • beside workflow engine also excel time sheets
      • systems can vary, but one system per enterprise
      • core information should be the same
        • each format can be reduced to a common core
    • business data
      • extremly large
      • distributed heterogen
        • ERP
        • CRM
        • other
      • often managed by data warehouse
        • link to or integrate with existing warehouse
    • process data
      • process models
        • can change → support versioning
        • differ in language and format
        • match to label of log instances
      • process compliance rules
        • linked to one or more process models
        • can be match again process
          • not necessary  to match against instance?
        • KPI definition?


  • decision support system
    • strategic (historical)
      • leads to policy changes
      • leads to new processes
    • tactical (historical)
      • leads to process improvements
    • operative (to runtime)
      • alert stakeholders
        • with context
          • why, who, where, what ...
      • automatic decisions
      • allow insights
        • history of an instance

  • metrics
    • general costing
    • process performance
      • cycle time
      • net processing time
      • idle time
      • branch probabilities
    • overdue / late cases

  • accessibility
    • discoverability
      • non-technical user can get new perspectives
    • simulation
      • after changing a process the system should be able to predict runtime
        • use of probabilities
        • use of historic business data
        • use of average times

No comments:

Post a Comment