Course Catalog URL
Identifier
COMS 5610
Professor(s)
Last Updated: Fall 2024
- Credits and contact hours: 3 credits
- Instructor’s or course coordinator’s name: Ying Cai
- Text book, title, author, and year: None required
- Other supplemental materials: Database Management Systems, 3rd edition, R. Ramakrishnan and J. Gehrke.; Fundamental of Database Systems, 5th Edition, R. Elmasri and S.B. Navathe
Specific course information
- Brief description of the content of the course: Database design including entity-relationship model, dependency and normalization. Database management including physical storage, access methods, query processing, and transaction management. Database systems of special purposes such as spatial databases, mobile object databases, and multimedia databases. Introduction to current research such as cloud data management and Internet information retrieval.
- Prerequisites or co-requisites: COM S 3110, ENGL 2500, SP CM 2120; for graduate credit: graduate standing or permission of instructor
- Required, elective, or selected elective? Selected Elective
Specific goals for the course
- Specific outcomes of instruction:
- To understand good database design techniques and database theories behind
- To understand the design of important components of large-scale database management software
- To understand a few advanced topics in database research
- To be familiar with some commercial relational database management system software
Brief list of topics to be covered
- Conceptual database designs
- Review of SQL
- Functional dependencies and normalization
- Relational algebra and calculus
- Storage and indexing
- Query optimization
- Query evaluation
- Transaction management
- As Time Permits:
- Complex queries
- Spatial databases
- Mobile object databases
- Cloud data management
- Data mining
- Internet search