CM4D uses the data it collects to generate results according to your business rules, which are then stored in a data warehouse called the Results database. Business Intelligence (BI) or other reporting tools are used to extract, transform, and load the stored results data for aggregation and analysis.
Results always overwritten; last data in always wins
Database can be recreated at any time with no loss
Data synchronization – results are updated any time data changes
Reporting side – when user runs the query, they get the data that is available at that time
Multiple clients run their own service to get data to the db
A very simple and fast cache of all the data in all CM4D databases in a CM4D Site database
All data is pre-evaluated to Tolerance and all 3D math is already done
Results services keep all data synchronized with CM4D
Data is evaluated appropriately for each data type
CM4D database not suited to Dashboards
Complex and highly relational
Optimized for small size
Contains items for complex analysis
Contains full 3D CAD information
Need a database with “pre-evaluated” data for speed
Need a “simple” database structure
Need more filters for drilling down
Need Monthly and Weekly rolls ups of large DataSets
Need easy exports to other systems
DataSmith loads, verifies and manipulates data files
CM4D does the evaluation and analysis that feeds results
CM4D has raw data for re-evaluation, if things change
The Actual measurements and Nominals are loaded in the CM4D database
CM4D can do alignments, constructions, pattern matching, 3D transformations, etc
CM4D can relate all measurements directly to CAD to in 3D space
Complex reports cannot be reproduced in dashboards
BI Tools are to slow when calculating complex statistics (e.g., Cp/Cpk)
Automatic alarming and e-mailing is more structured
See also:
Can we improve this topic?