CENG 435
Database System Design and Implementation
Revisiting database systems, data definition, relational algebra, disk management, file management, memory management, transaction management, record management, metadata management, query processing, parsing, planning, database server, indexing, query optimization
Course Objectives
To master the topic of data management in computer science field, to be able to produce parts of a database management system, to gain to skill of researching
Recommended or Required Reading
E. Sciore, Database Design and Implementation, Secon Edition, Wiley, 2020., M. Fisher, J. Ellis, J. Bruce, JDBC(TM) API Tutorial and Reference , 3rd Edition (Java Series), Addison Wesley, Reading, Massachisetts, 2006.
Learning Outcomes
1. To install SimpleDB database management system, customize it as required
2. To develop applications that realize all the functions of a database management system
3. To learn the approaches and methods behind the functions of a database management system
4. Finding, implementing and presening solution to an engineering problem by means of software development in a team
| Topics |
| Introduction to Database Systems and Data Definition |
| Relational Algebra |
| Relational Algebra |
| Disk and File Management |
| Memory Management |
| Transaction Management |
| Record Management |
| Metadata Management |
| Recovery and Concurrency |
| Query Processing |
| Query Parsing |
| Query Planning |
| Query Optimization |
| Term Projects |
Grading
Midterm 30%
Research Presentation 30%
Final 40%
Instructor(s)
- CENG 400
- CENG 411
- CENG 415
- CENG 416
- CENG 418
- CENG 421
- CENG 422
- CENG 424
- CENG 431
- CENG 432
- CENG 433
- CENG 434
- CENG 436
- CENG 437
- CENG 441
- CENG 442
- CENG 443
- CENG 444
- CENG 451
- CENG 452
- CENG 461
- CENG 462
- CENG 463
- CENG 464
- CENG 465
- CENG 467
- CENG 471
- CENG 472
- CENG 473
- CENG 481
- CENG 482
- CENG 483
- CENG 484
- CENG 485
- CENG 486
- CENG 487
- CENG 488
- CENG 491
- CENG 499

