U.S. Department of Transportation builds a real-time aviation database with Databricks
The U.S. Department of Transportation used the Databricks Data + AI Platform on Azure with Delta Lake and Apache Kafka to unify FAA SWIM streaming data with on-premises Oracle and Sybase databases into a real-time commercial flight database, powering ML-driven predictions of air traffic patterns and reducing the cost of collecting and ingesting streaming data by 90% compared to other cloud solutions.
Overview
The U.S. Department of Transportation used the Databricks Data + AI Platform on Azure with Delta Lake and Apache Kafka to unify FAA SWIM streaming data with on-premises Oracle and Sybase databases into a real-time commercial flight database, powering ML-driven predictions of air traffic patterns and reducing the cost of collecting and ingesting streaming data by 90% compared to other cloud solutions.
This entry has 12 published fields tied to exact passages in an immutable source capture.
Inspect the highlighted sourceThe challenge
USDOT needed to unify fragmented on-premises databases (Oracle, Sybase) and public FAA SWIM streaming data into a real-time commercial flight database to comply with updated Bureau of Transportation requirements, in an industry that traditionally relied on on-premises platforms rather than the cloud, making it hard to control data quality and scale without heavy manual review.
The solution
USDOT chose Microsoft Azure and the Databricks Data + AI Platform to democratize its various data sources, including on-premises databases like Oracle and Sybase, with real-time streaming via Apache Kafka, using Delta Lake to build reliable pipelines that feed Tableau and Power BI dashboards and machine learning models predicting air traffic patterns and passenger impact.
Reported business value
USDOT reduced the cost of collecting and ingesting streaming data by 90% compared to other cloud-based solutions, and its data engineers, scientists and analysts now collaborate on one platform to deliver real-time aviation dashboards and more accurate predictions about resource needs.
Sources
Open any source and check the claim yourself — that is the point of the register.
This record was researched and written with AI assistance, and its claims were checked against the sources above. (EU AI Act art. 50 transparency notice.)
Other government & public sector entries in the register.
GovTech unlocks data insights to improve nationwide services with Databricks
Singapore's Government Technology Agency (GovTech) migrated from an on-premises dashboarding system to the Databricks Data + AI Platform on AWS with Unity Catalog and Delta Lake, cutting dashboard creation time from 90 to 30 days, democratizing data across 50% of corporate divisions in the first year, and saving 8,000 labor hours annually.
GovTech· SingaporeDelta Lake · Lakeflow Connect · Lakeflow Jobs +1Estonia rolls out Bürokratt, an AI-guided virtual assistant network for public services
Bürokratt is a network of chatbots deployed on Estonian public sector institutions' websites, letting people obtain information from institutions and use public and information services via virtual assistants. It is a state-created, AI-based digital assistant that helps institutions deliver modern, efficient, around-the-clock customer service using large language models.
VA Advances Healthcare Insights With AI
The U.S. Department of Veterans Affairs leverages Databricks Data Intelligence to modernize healthcare analytics for millions of veterans, unifying massive distributed datasets into a single secure environment and streaming petabytes of health data in real time, reducing processes that once took hours to seconds. Databricks enables AI and large language models to detect risk early and enhance governance.
U.S. Department of Veterans AffairsDatabricks
Austrian Academy of Sciences unlocks Ancient Greek with Mistral
The Austrian Academy of Sciences (OeAW), together with its Austrian Archaeological Institute, partnered with Mistral and services partner Reply to build Apollo, described as the first advanced large language model for Ancient Greek. Apollo is trained on a specialized corpus of 600 million words of historical Greek text plus tens of thousands of published inscriptions and papyri, helping researchers reconstruct damaged texts and identify thematic connections across collections. The OeAW reports Apollo turns work that once took years into hours, addressing over one million unread Greek papyri worldwide, with future phases planned for semantic search and handwritten inscription decipherment.
Austrian Academy of Sciences· AustriaMistralWas this helpful?
Your feedback helps us improve our use case database