Curso especializado de Tratamiento-Validación de Base Datos

Learn to ensure your database is accurate and ready for 3D modeling with this comprehensive course! Discover how to identify and correct common database errors to create a reliable and auditable database suitable for generating plans, sections, and 3D models.

Introduction to Database Quality

• Understanding the Impact of Errors: Explore the consequences and root causes of inaccuracies within geological databases.
• Course Overview: Get a clear understanding of the course structure and what you will learn.
• Geological Database Basics: Gain familiarity with different types of geological databases.

Data Consolidation & Excel for Database Preparation

• Mastering Excel Macros: Learn to automate tasks using MS Excel Macros for efficient data handling.
• Data Consolidation Techniques: Consolidate data from various sources into a unified database.
• Extracting Data with Macros: Efficiently extract specific data sets using Excel Macros.

Error Detection Strategies

• Table Reconciliation: Identify discrepancies between Collar, Survey, and Assay tables within your database.
• Inconsistent Data Identification: Detect illogical or nonsensical data entries across all tables.
• XY Location Errors: Pinpoint inaccuracies in location data using XY coordinates from GIS tables and plans.
• Datum Error Detection: Ensure proper datum application and identify potential errors.
• Data Redundancy: Identify and eliminate duplicate information within your database.
• Missing Data Detection: Find and address instances of incomplete data.
• Overlapping Information: Detect and resolve overlapping data entries.
• 3D Location Verification: Identify errors in 3D location data.
• Loading & Manipulation Errors: Utilize original certificates to detect errors introduced during data loading and manipulation.

Database Protection & Validation

• Database Security: Implement measures to protect your database from unauthorized access and modifications.
• QA/QC Implementation: Learn to integrate Quality Assurance/Quality Control (QA/QC) procedures into your database workflow.
• 3D Software Verification: Leverage 3D software (e.g., Leapfrog Geo) for automated error verification and validation.