AirAsia Airlines
Database Metadata & Data Dictionary System
Developing a comprehensive database metadata management system for Southeast Asia's leading low-cost airline
Client
Year
Team Members
Weeks
Industry
Project Overview
AirAsia, Southeast Asia's largest low-cost carrier, required a robust Database Metadata and Data Dictionary system to manage their extensive data infrastructure. Steel Horizon Solutions assembled a specialized team of database engineers and developers to design and implement this critical system.
The system provides comprehensive metadata management, enabling AirAsia's data teams to efficiently catalog, document, and govern their database assets across multiple systems and platforms.
"Steel Horizon Solutions provided us with highly skilled database professionals who understood our complex requirements and delivered a solution that exceeded our expectations."
— IT Project Manager, AirAsia
The Challenge
Complex Data Infrastructure
Managing metadata across multiple database systems, including legacy and modern platforms used throughout AirAsia operations.
Documentation Requirements
Need for comprehensive data dictionary to document database schemas, tables, columns, relationships, and business rules.
Data Governance
Ensuring data quality, consistency, and compliance across the organization with proper metadata tracking.
Multi-Team Collaboration
Enabling data engineers, analysts, and business users to access and understand database structures efficiently.
Our Solution
Team Composition - 8 Specialized Professionals
Full Stack Developers
- Frontend & backend development
- API development
- System integration
Solution Architect / Tech Lead
- System architecture design
- Technical leadership
- Technology decisions
QA Engineers
- Manual testing
- Performance testing
- UI automation
Database Engineer
- Database schema design
- Metadata extraction
- Performance optimization
UI/UX Designer
- User interface design
- User experience research
- Design systems
Key Features Delivered
Automated Metadata Extraction
Automated tools to extract and catalog metadata from various database systems including Oracle, MySQL, PostgreSQL, and MS SQL Server.
Comprehensive Data Dictionary
Detailed documentation of all database objects including tables, views, columns, data types, constraints, and relationships.
Lineage Tracking
Data lineage visualization showing the flow of data across different systems and transformations.
Search & Discovery
Powerful search functionality enabling users to quickly find and understand database assets.
Business Glossary Integration
Linking technical metadata with business terms and definitions for better understanding.
Version Control
Tracking changes to database schemas and metadata over time with full version history.
Access Control
Role-based access control ensuring sensitive metadata is only accessible to authorized personnel.
API Integration
RESTful APIs for integration with other data management and BI tools in AirAsia ecosystem.
Technologies & Tools
React
Typescript
Node.js
Express
PostgreSQL
Docker
REST APIs
Results & Impact
Faster data discovery and understanding
Database documentation coverage achieved
Data professionals using the system daily
Business Benefits
Project Timeline
Discovery & Planning
- Requirements gathering & analysis
- System architecture design
- Team assembly and onboarding
- Technology stack finalization
Development Phase 1
- Core metadata extraction engine
- Database schema crawler development
- Initial data dictionary structure
- UI/UX design & prototyping
Development Phase 2
- User interface development
- Search and discovery features
- Lineage tracking implementation
- API development & integration
Testing & Deployment
- Manual & automated testing
- Performance & UI automation testing
- User acceptance testing (UAT)
- Production deployment
- User training and documentation