Complex Welding Search System

Alberta Innovates Technology Futures

A graphic of a clipboard with paper attachedThe Client’s Need

A new initiative, Materials and Reliability in Oil Sands, aimed to provide data to oil sands organizations to tackle industry-wide problems relating to maintenance and reliability issues. The first version the program involved a massive excel sheet that detailed dozens of measures, tests, and values of thousands of materials. They needed something that could be accessed and easily used by any of their member users.

A graphic of 4 interlocked puzzle piecesThe Project

The unwieldly spreadsheet was converted into a database and web application. There are dozens of search parameters, and users can select which ones to display to minimize confusion and clutter. Reports can be generated for the results at multiple levels of detail as needed.

Precision can make even the most confusing data clear and usable.

A graphic of gearsComponents

  • ActiveDirectory integration module
  • Advanced report module
  • User and group permissions system
  • Universal measurements converter

Common

  • Pleasant reusable core
  • Pleasant Visual Data Modeller

A graphic of a USB thumb driveTechnology

  • Microsoft .NET Framework
  • C#
  • MVC with AJAX
  • LINQ
  • Excel

Database

  • MS SQL Server