Data Design Tutorial

By Kathleen Holcomb over 7 years ago in OpenGround | gINT | Keynetix > OpenGround | gINT | Keynetix Files

2 comments

This tutorial is designed for intermediate level gINT users, and is intended for self-study. It covers the DATA DESIGN tab in detail, including an in-depth demonstration of project database and template construction, as well as library tables, user system data, correspondence files, and setting up component lithology descriptions. The tutorial employs detailed explanations of conceptual topics, and also has you perform step-by-step instructions in gINT.

You should be familiar with gINT data entry and basic output (including preview and printing, and the zoom tools) before working through this tutorial.

Table of Contents:

• Using this Tutorial  
  • Setting up Sample Files  
• Overview of DATA DESIGN  
• Relational Databases and gINT  
  • Keys and Key Sets  
• Creating and Customizing a Database
  • Customizing the PROJECT and POINT Tables  
  • Adding the SAMPLE Table  
  • Adding the LITHOLOGY Table  
  • Adding a WATER LEVELS Table  
  • Adding WELL DETAILS and WELL CONSTRUCTION Tables  
  • Generating a Project and Importing the Data  
• Considerations for Good Database Design   
  • Data Type  
  • Calculated Fields  
  • Lookups  
  • Required Fields  
  • Unrelated Fields in the Same Table   
  • Metadata: Data about Data   
  • Table Relationships   
  • Validations using Field Rules and gINT Rules Code   
  • Transparency and Documentation   
• Library Tables   
  • Attribute Tables   
• Correspondence Files   
• User System Data   
• Component Lithology Descriptions   
  • Generating Component-Based Lithology Descriptions   
  • Benefits of Component Lithology  
  • Understanding How a Component Description Structure Works   
  • The Component Data Entry Table and Lookup Tables   
  • The Component Formatting Library Table   
  • Adding Component Fields
  • Adding Formatting Elements  
  • Understanding the ComponentDesc() Function   
• DATA DESIGN Utilities   
  • User Interface Manipulation Utilities   
    • List (Tables Menu)   
    • Input Sequence (Tables Menu)   
    • Group Sequence (Tables Menu)   
  • Utilities to Import or Merge Tables and Fields   
    • Import Table (Tables Menu)   
    • Import Multiple Tables (Tables Menu)   
    • Merge Fields from Current File (Tables Menu)   
    • Merge Fields from Other File (Tables Menu)  
    • Merge All Tables and Fields (Tables Menu)  
    • Build From Reports (File u New Data Template menu)   
    • Convert Projects (UTILITIES tab)   
  • Information Gathering Utilities   
    • Print (File Menu)   
    • Compare Databases (Tools Menu)   
    • Combined Database Characteristics (Tools Menu)   
    • References to Current Field (Tables u References menu)   
    • References to All Fields in Current Table (Tables u References menu)  
    • References to All Fields in All Tables (Tables u References menu)   
    • References to Current Field (File Menu in User System Data Application)   
    • References to All Fields (File Menu in User System Data Application)   
    • References to This Lookup (File Menu)   
  • Miscellaneous Utilities   
    • Replace Field Names (Tools Menu)   
    • Assign Data Template to Reports (Tools Menu)   
    • Last Update Field and Point Sort Field (Tables Menu)