Structure of the ThermalTrend Lean Database


Structure of the Thermal Trend Lean Database

Thermal Trend - Lean is a Relational Database Management System (RDBMS) developed in a .NET environment and Microsoft SQL, which follows an Indexed Hierarchical Relationship structure for the way data is structured in the SQL database. By utilizing a “one too many” hierarchical architecture, it allows for all inspection data to be stored in the SQL database without any data redundancies or errors that are typically associated with “Flat File” report document schema, for example using only MS Word as a report generator.


Microsoft SQL: Client – Server Synchronization between Desktop and Pocket PC (Windows Mobile)

Thermal Trend – Lean uses a Client – Server model to store, manipulate, and synchronize the data between the host server and the field collection. A web based user interface is used to communicate between the field and the server.  Prior to an inspection, all the data (locations and equipment to be inspected, past history and all problem records for past problems) for a site is synchronized from our server to the Infrared Thermographer's portable device, so that all of the relevant data is easily accessible while they are conducting the inspection.  During the inspection, all of the past problems are reconciled as either repaired, or still open; test statuses are updated and any new findings are entered into the tablet at the time of the inspection.  Data is then synchronized back to the portable device, and a field report is generated at the completion of the inspection.  The Thermographer will then synchronize their portable device back up to the server. The Customers Site data can be made available through a secure web server allowing the customers to be able to directly access their own data.   Return to Top of Page
  "Click" to enlarge!