Inside IoT Query: PTL, Layers & Governance
A PostgreSQL-compatible lakehouse with layered schemas, strong client isolation, and regional hosting options — built for architects, security teams, and senior data engineers.
Data Architecture at a Glance
IoT Query is built around the Private Telematics Lakehouse (PTL) — a multi-schema, layered data warehouse that combines the scalability of a data lake with the performance of a structured warehouse.
Bronze, Silver, Gold – Technical View
IoT Query employs a medallion architecture with three progressive layers — each optimized for different analytical needs and user personas.
Bronze Layer – Raw Data Foundation
The foundational layer containing all raw, minimally processed telematics and business data. Original detail and schema are preserved with uniform naming conventions.
Use Cases
- •Troubleshooting anomalies and tracing issues at the source level
- •Advanced analytics requiring full-fidelity, time-series data
- •Exploratory data science and custom feature engineering
Example: Correlate engine RPM, throttle position, and fuel level readings at each timestamp to detect anomalies invisible in aggregated reports.
Silver Layer – Cleansed & Analytics-Ready
Validated, cleaned, and enriched data merged with business context. Structured into query-friendly tables with computed derived fields and standardized units.
Key Features
- •Data validation, outlier filtering, and time regularization
- •Trip segmentation, idle events, geofence visits, driver assignments
- •Pre-built joins between IoT streams and business entities
Example: Query 'idle time within geofences by driver and time of day' without manually joining multiple raw tables.
Gold Layer – Business-Ready KPIs
Pre-aggregated, highly curated data marts tailored to business-level metrics. Ready for immediate use in dashboards and decision-making.
Benefits
- •Daily/weekly KPIs per region, vehicle, or driver — no complex SQL required
- •Plug-and-play datasets for executive dashboards and operational reports
- •Feature-rich datasets optimized for training ML models
Example: A table of weekly fleet utilization and maintenance status metrics, normalized across currencies and time zones for global comparisons.
Roadmap: Advanced Query Capabilities
Both Silver and Gold layers are expected within the next 12 months, along with:
- •PostGIS-compatible geospatial queries — easily check if coordinates fall inside geofences or perform geo-joins
- •Time-based query aids inspired by iCalendar logic — filter by shift schedules, working hours, or custom time windows
Navixy Repository: Your Fleet Digital Twin
An entity-centric data modeling layer that unifies telematics data with business context — vehicles, drivers, trailers, geofences, jobs, and their relationships.
Custom Entities & Relationships
Define flexible entity types (vehicles, drivers, cargo, zones) with custom properties. Link them in a unified data graph to represent your operations.
OpenAPI REST Interface
Full programmatic control via REST API. Create, update, and query entities on the fly. Integrate with CRM, ERP, or custom business systems.
Real-Time Sync with PTL
All business data is synchronized in real-time with the PTL warehouse. Join custom entities with raw telematics data in SQL queries instantly.
Entity Relationship Example
Ingestion & Transformation with IoT Logic
IoT Logic acts as the real-time data pipeline — receiving, decoding, enriching, and normalizing raw tracker data before writing it to the Bronze layer.
Security & Compliance Posture
Enterprise-grade security with tenant isolation, encryption, regional hosting, and compliance alignment to SOC 2, ISO 27001, and GDPR/CCPA standards.
Tenant Isolation
Each client's data resides in a dedicated schema or database instance. No cross-tenant joins or data leakage — complete logical separation.
End-to-End Encryption
TLS 1.3 in transit, AES-256 at rest. Region-specific key management with hardware security modules (HSMs) for enhanced protection.
Role-Based Access Control
Fine-grained permissions via Navixy platform roles. Optional two-factor authentication (2FA) and IP whitelisting for sensitive environments.
Compliance Alignment
Designed to meet SOC 2 Type II and ISO 27001 standards. GDPR and CCPA compliant with data residency options.
Continuous Monitoring
24/7 security monitoring, regular audits, and incident response procedures. XSS and SQL injection prevention with strict input validation.
Regional Data Residency
Host your data in EU, North America, Middle East, or APAC to meet local data sovereignty and compliance requirements.
Certification Status
Navixy's security program is aligned with SOC 2 and ISO 27001 best practices. Formal certifications are in progress and expected within 2025.
Data Residency & Deployment Options
Choose the deployment model that fits your scale, compliance, and control requirements — from shared multi-tenant cloud to dedicated private instances.
Shared Multi-Tenant Cloud
Cost-effective, fast onboarding for mid-sized fleets and TSPs.
- Logical tenant separation with dedicated schemas
- Shared infrastructure managed by Navixy
- Suitable for fleets of 50-5,000 assets
Dedicated / Private Instances
For large enterprises, government fleets, or highly regulated sectors.
- Full database isolation with dedicated compute and storage
- Custom retention policies and performance tuning
- VPN/VPC peering and custom SLA options
Available Regional Zones
IoT Query can be deployed in multiple geographic zones to ensure data never leaves your required jurisdiction.
Performance, Retention & Scalability
Built to handle high-volume, high-frequency telematics data — billions of records with fast query performance and flexible retention strategies.
Virtually Unlimited Storage
Retain years of detailed tracking data. Configurable retention policies — 6 months, 1 year, 5 years, or more — based on your needs.
Fast Interactive Queries
Complex joins and aggregations execute efficiently thanks to indexing, partitioning, and query optimization under the hood.
Flexible Retention Policies
Choose retention windows that balance cost and compliance. Archive older data to cold storage while keeping recent data hot.
Discuss Architecture with Navixy Experts
Whether you're evaluating IoT Query for your organization or planning integration — our team is ready to walk you through the architecture, security, and deployment options.