PUMA data model

The printer usage monitoring application uses the following tables to store the information gathered from the printer monitoring services as they record details of printer jobs:

Printer related data tables

  • Printers has one record for each printer being monitored

Print Job related tables

  • Print Jobs has one record for each print job submitted against any of the printers being monitored
  • Print Job Events occur for each event (added, set, written, deleted) in the print job life cycle
  • Print Job Paragraphs (not yet used) Holds the text elements of each print job to allow the print jobs to be searched using a text query macthing tool

Reporting

Reference data tables

  • Clients (new) holds a list of clients that are being catered for on this database ( this allows for multiple clients on a single database for use with SQL Azure )

Stored procedures

Views

The following pre-built data views provide quick access to the most commonly sought printer monitoring information:

Source code

Complete database create script (Pre-Azure version)

Last edited Dec 7, 2009 at 7:21 PM by Merrion, version 16

Comments

No comments yet.