Akademik Dersler - Tanıtım


Code - Course Title	RYL5502 - Database Management in Railway Systems
Course Type	Elective Courses
Language of Instruction	Türkçe
Laboratory + Practice	3+0
ECTS	7.5
Course Instructor(s)	DOKTOR ÖĞRETİM ÜYESİ MEHMET FİDAN
Mode of Delivery	Face-to-face
Prerequisites	None
Courses Recomended	None
Required or Recommended Resources	Ramez Elmasri, Shamkant Navathe – Fundamentals of Database Systems (7th ed., Pearson, 2016); Raghu Ramakrishnan, Johannes Gehrke – Database Management Systems (3rd ed., McGraw-Hill, 2002); ERA – ERTMS/ETCS System Requirements Specification; CENELEC EN 50126/50128/50129 Standarts
Recommended Reading List	IEEE Transactions on Intelligent Transportation Systems; Journal of Rail Transport Planning & Management; Computers in Railways (WIT Press); SAP for Railways teknik dokümantasyonu; IBM Maximo Asset Management manuals
Assessment methods and criteria	Midterm: 30%; Project:30 %; Final Exam: 40 %
Work Placement	None
Sustainability Development Goals

Weeks	Topics
Week - 1	Introduction to database management in railway systems; fundamental concepts, historical development, application areas
Week - 2	Data modeling techniques: entity-relationship (ER) model, relational model, schema design
Week - 3	Relational database management systems; SQL and advanced query techniques
Week - 4	Railway operation databases: service, line, vehicle and personnel data management
Week - 5	ERP systems: SAP for Railways, IBM Maximo, Oracle Transportation Management
Week - 6	EN: CMMS and RAMS data management; database-supported maintenance processes
Week - 7	AFC systems and passenger data management; ticketing database architectures
Week - 8	ERTMS/ETCS and GSM-R data management; safety-critical database requirements
Week - 9	IoT sensor data and real-time data streams; railway asset monitoring systems
Week - 10	Big data analytics: Hadoop, Spark, data mining in railway operations
Week - 11	NoSQL database architectures: document, column, graph and key-value stores
Week - 12	Compliance with TSI and CENELEC standards; data security and audit requirements
Week - 13	Database performance optimization: indexing, query planning, caching
Week - 14	Cloud-based and distributed database systems; digital transformation and future trends

Assessment Method and Passing Requirements
	Quamtity	Percentage (%)
Toplam (%)		0