Access MDB Glassbox Views

1
Access MDB Glassbox Views

• Barry Hynum, Ph.D. MaxQual Consulting
• bhynum_at_cox.netAccess, SQL Server, VB, ASP,

2
Features

• Access Architectural Glass-Box Views
• Change Tracking Any number of versions
• Snapshots of previous versions preserved
• Catalogues of Objects with Where-Used
• Entire call tree for each data channel
• Tree Views
• Who references an object
• What subobjects are used in an object
• Selective Viewing
• Visio available but not recommended
• Quickly overwhelmed
• Crossing channels
• Overloaded pages

3
Overview Status

• My Own New Tool
• VB DLL does the substructure assembly -- hidden
• Backend
• Glass-Box Backend Object Tables w/ Auxiliary
  Info
• Front ends
• Versioning Tool Creates a snapshot for
  comparison
• Diagrams Catalogues where-used in call tree
• Availability
• Beta Testing as a Service for now.
• Also available gtgt nTieriorTM
• Web Site Architecture, Versioning, TVs
• Also Web Site Search/List gt Access Table

4
Benefits

• Developers
• Impact assessment who will be affected by the
  change
• Documentation
• Design Spec what will be done
• Implementation Spec what has been
• QA
• Which UIF objects need re-test?
• Project Management
• Assembly process is visual
• You dont need to ask, you can see whats changed
• Quantification tracking object/code
  additions/changes
• Group Management select object sets for viewing

5
MDB Data Flow
6
Beta 4 LPL Financial

• Glass-Box Backend
• 275 Data Channel-Views
• 40 Tables
• 39 Queries
• 19 Forms
• 18 Reports
• 2 Modules
• TreeViews
• Object Referenced-By
• Object References Waterfall
• Table References Waterfall

7
Catalogues
8
Changed Tables
9
Changed Queries
10
Object Waterfall
11
Table Waterfall
12
Objects Where-Used
13
Beta 5 H. M. Pitt Labs

• Provided by Wayne Warren-Angelucci
• Glass-Box Backend
• 591 Channels to the Data
• 34 Tables
• 5 Queries
• 47 Forms
• 74 Reports
• 4 Modules

14
GBV Summary

• Object Relationships a la Table Relationships
• Informed Design
• Change Impact Assessment
• QA Test Planning
• Version Tracking
• Project Management
• Global views of objects dependencies
• System perspective