How gvenzl/sample-data works
Main Components
a. Data Collections Layer
• Countries-Cities-Currencies
• Departments-and-Employees
• National-Parks
• Solar-System
b. Data Source Layer
• External Data Sources:
• National Geographic Atlas
• GeoNames.org
• NPS Data API
• NASA Planetary Fact Sheets
c. Database Installation Layer
• SQL Scripts:
• Standard SQL installations
• Oracle-specific installations
• Uninstallation scripts
• [Data Sources] → [Data Collections] → [Database Installation]
Specific Component Details
• Blue: Raw data files (CSV)
• Green: Installation scripts
• Orange: External data sources
• Purple: Utility scripts
• Red: Compressed files
• Rectangles: Data collections
• Clouds: External data sources
• Hexagons: Utility scripts
Relationship Representations
• Double lines: Installation paths
Additional Details
a. Metadata Annotations:
• License information (Creative Commons Attribution 4.0)
• Data update frequency (if applicable)
• File format specifications
b. Version Information:
• SQL script compatibility
• Data source versions
Remember to include a note about the utility scripts and their role in data acquisition/maintenance, particularly for the National Parks dataset.
• How the data is organized
• Where the data comes from
• How to install the data into different database systems
• Relationships between different data files within each collection