Thor Solutions

Information Systems Design & Management

End-to-end Information Technology solutions; employing commercial best practices,  solving simple to complex problems across a diverse client base.

  • Web Application Services - played a critical role in the implementation of several online environmental tools for the USN, including the EPR Portal from its inception to current day support
  • GIS Services - developed procedures for standardizing the process for developing geohazard assessment maps for Shell Oil
  • Full Database Design and Development/ Customized Database Solutions - designed/ developed the Environmental Quality Needs database for NSWCCD 63 to identify and prioritize Navy environmental needs
  • Provide Legacy Application and Data Migration Services
  • Strategic IT Architecture Services

Database Development and Project Management. THOR has vast experience in leading various database projects and helping execute throughout all phases of development, including systems analysis and design, database development, creation of user manuals/ quick start guides/video tutorials and onsite user training.  The databases are relational in their infrastructure and are based on MS Access with programming in Visual Basic for Applications (VBA) to drive much of the customized functionality.

Typically, the databases are designed for non-database users and therefore extensive graphical user interface (GUI) is incorporated through the use of interactive forms consisting of free-text fields, drop-down menus, list boxes, check boxes (or radio boxes). Generally, the databases consist of an administrative module (for managing the underlying baseline data), a main module (where the user enters the “meat” of the data), a search module (for finding records to view and/or edit), a reports module (for viewing and/or exporting pre-defined or user defined reports, and a help/documentation module (includes a summary of the purpose of the database, key instructional information and who to contact if there are questions or technical issues). A few examples (not all inclusive) of some of the objects that we can create are:

  • Relational Tables (indexed with pre-defined or custom field formats)
  • Forms/Subforms (GUI)
  • Queries (select, make-table and action)
  • Reports (pre-defined and user-defined)
  • Text Boxes
  • List Boxes
  • Drop-down Menus
  • Cascading Combo Boxes/ List Boxes (where the contents of one change based on the user’s selection of another)
  • Buttons (where some action is performed when clicked (e.g., save records, open another form, open a report, etc.))
  • Check Boxes/ Radio Boxes
  • Option Groups
  • Hyperlinks
  • Navigation Controls
  • Charts/Graphs
  • Embedded Objects (e.g., a PDF file)

Using VBA programming, we can implement much functionality that is beyond the native capabilities of MS Access, including:

  • Tool-tips that pop up when the cursor is placed over text (usually something implemented on webpages, not an Access database)
  • Code to prevent mouse scrolling (in Access mouse scrolling on a form will move from one record to the next)
  • Password-protecting individual form
  • Automatic checklists (to verify that required data was entered)
  • Editable checkboxes (list grows based on user input)
  • Track Changes (automatically records every character change within each field)
  • “Data last modified” date (at the record level and/or database as a whole)

The databases can also be made to support multiple users through implementation of a split design, whereby the GUI is stored in a front-end file and the actual data (i.e., tables) is stored in a back-end file.  With a split design setup, more than one user can access and modify records at the same time.

Geographic Information Systems (GIS). GIS is part of a larger enterprise known as Geographic Information Science, is a relatively broad term. At the most basic level, a GIS is a useful technology that transforms raw data into something more valuable (information). It is an integrated collection of computer software and data used to view and manage information about geographic places, analyze spatial relationships, and model spatial processes. A GIS provides a framework for gathering and organizing spatial data and related information so that it can be displayed and analyzed.
GIS merges traditional cartography, statistical analysis and database technology. A GIS is often developed as a decision-making tool and can be made to include interactive queries (user-created searches), analyze spatial information, edit data in maps, and present the results of all of these operations. The value of GIS is recognized across a broad range of industries and disciplines. The ability to collect, organize, analyze, and represent data helps organizations do everything from modeling animal migrations and mapping the spread of diseases to analyzing demographic information for commercial development and creating new political districts. Any phenomenon that has a spatial component to it (just about everything) can benefit from a GIS.

Using ESRI ArcGIS products and other tools (e.g., U.S. Geological Survey), examples of some of the GIS services we can provide are:

  • Spatial Analysis
  • Cartography and Visualization
  • Map projection and Transformation
  • Thematic Mapping
  • Decision Support (e.g., site suitability, risk assessment)
  • Geocoding
  • Surface Interpolation
  • Land Characterization
  • Gap Analysis
  • Georeferencing
  • GIS Development  (systems analysis and design, UML, use-case modeling, digitizing, import techniques, edgematching, data quality assurance and correction, etc.)
  • Geostatistics
  • GIS Programming (VBA) and Application Customization, Human Factors and User Interface
GIS, Mapping, Spatial Analysis
Modeling
Customized Database Solutions