Systems Across Domains
Why cross-domain systems understanding matters, and a library of system-domain notes.
What It Is
Data Modeling is the creation of data structures and relationships to support efficient storage and retrieval. On this site, it matters because it transfers across technical, operational, and venture work instead of staying trapped in one narrow context.
Learn more: https://en.wikipedia.org/wiki/Data_model
Amazon Aurora
Amazon Aurora is a managed relational database compatible with MySQL and PostgreSQL.
Audience Intent Data Model Development
Designed a unified data model to integrate any data source into a big data geospatial analytics program, handling over 100TB of data in GCS and BigQuery with...
Data Engineering and Big Data
Projects building data pipelines, warehouses, lakes, and large-scale analytics infrastructure.
Data modeling systems
Abstract representations of entities and relationships are structured for efficient storage, querying, and interpretation.
Data Reporting Transformation for Hotel Chain
Solutions architect role redesigning a fundamentally flawed Pentaho ETL into a scalable AWS Redshift data warehouse for a hospitality leader. Identified root...
Geospatial Human Risk Quantification
Using SafeGraph location observation data and Databricks/Spark, built a geospatial model to quantify human risk around utility infrastructure — helping...
Hypersonix
A BI and analytics SaaS company where Michael Orlando supported reporting architecture and enterprise data work.
MongoDB
MongoDB is a noSQL database for flexible document storage.
MySQL
MySQL is a relational database management system.