Topics Covered in COSC 3480

1
Topics Covered in COSC 3480

• Data models (ER, Relational, XML)
• Using data models learning how to store real
  world information in a database
• Application development using a DBMS
• Algorithms that access disks (and not the main
  memory)
• Database design (logical, physical)
• Index Structures and Storage Structures
• SQL, PL/SQL, using Oracle 9i,
• Other Data warehousing, data mining, internet
  databases, transactions, other interfaces to
  databases

2
Important TopicsNot or Little Covered in COSC
3480

• Implementation of DBMS
• Transaction Management
• Query Optimization
• Crash Recovery
• Implementation of Joins,
• Databases and Internet Computing
• Object-relational and Object-Oriented Databases
• Active Databases
• Data Mining and Data Warehousing
• Distributed Databases

3
Recent Trends in the Area of Databases

• Support for web-based interfaces to databases
• Support for semi-structured data and XML
• Support for decision support (data warehouses,
  OLAP, data mining)
• Support for unusual data types (images, long
  strings, gene sequences, spatial databases)
• Object-relational databases (in response to
  object-oriented databases e.g. Oracle 9)
• Hiding SQL from the user though high level
  interfaces
• Making SQL to be a real programming language
  (SQL3)
• Research Querying and Mining Data Streams