Fundamentals of Geotechnical and Geoenvironmental Data Management
GeoFlorida Short Course, 20th February 2010.
To register visit the GeoFlorida web site.
Join gINT Software founder Salvatore Caronna (now Director of Product Management, Geotechnical and Geoenvironmental Products for Bentley Systems) for a short course in the Fundamentals of Geotechnical and Geoenvironmental Data Management.
Course Outline
1. Database Design
- Introduction:
- What do you want to do with your data?
- What is data management
- Why is it important
- What's in it for you
- Basic database concepts
- Terminology
- Normalization
- Relationships
- What do you know about a bad database design?
- Examining a "Bad" Database:
- Introduction
- Building a bad database
- Improper or non-existent table indexes
- Lack of relationships
- Improper Field Types and Overloaded Fields
- Redundant data
- Formatted data
- Calculated data
- Misplaced Fields
- Combined Data Issues
- Fat tables
- External data not tied to the database
- How to Make it a Good Database:
- Normalization
- Key Identifiers
- Granularity
- Calculated Fields
- Appropriate Data Types
- Referential Integrity
- Database Should Reflect the Data Collected
- Elements of a Great Database
- Meta Data
- Validation
- Consistency
- Transparency
- Granularity
2. What you can do with a great Database
- Digital Photos
- Reports, Queries
- Site Characterization and Modeling (Surfer , RockWorks , etc.)
- Billing, Lab Management and Project Progress
3. Populating the Database Electronically
- Digital Data Collection
- Electronic Data Measurements (Fields & Lab) (CPT and lab testing)
- Data Interchange Standards
4. Knowledgebase
(Database + Validation + Analytics + Process Encapsulation)
- Scalability & Appropriate Size & Tools
- Process Encapsulation
- Analytics
- GIS Integration
5. Summary, Q&A
NEWS AND EVENTS
ABOUT gINT
CONTACT US