This note is designed to introduce
graduate students to the foundations of database systems, focusing on basics
such as the relational algebra and data model, query optimization, query
processing, and transactions. Topics covered includes: The relational model,
Schema design, database internals, Database operators and query processing,
Indexing and access methods, Buffer pool design and memory management, Join
algorithms, Query optimization, Selinger optimizer, Transactions and locking,
Optimistic concurrency control, Distributed transactions, Parallel databases,
Scientific databases, NOSQL , ORM, DryadLINQ, Streaming databases, database as a
service.
Author(s): Prof. Samuel Madden, Prof. Robert Morris,
Prof. Michael Stonebraker, Dr. Carlo Curino
This lecture
note covers introduction to database, management system, Introduction to basic
concepts of database systems, History of database systems, View of data,
Database languages, Database architecture and relational model.
This note is designed to introduce
graduate students to the foundations of database systems, focusing on basics
such as the relational algebra and data model, query optimization, query
processing, and transactions. Topics covered includes: The relational model,
Schema design, database internals, Database operators and query processing,
Indexing and access methods, Buffer pool design and memory management, Join
algorithms, Query optimization, Selinger optimizer, Transactions and locking,
Optimistic concurrency control, Distributed transactions, Parallel databases,
Scientific databases, NOSQL , ORM, DryadLINQ, Streaming databases, database as a
service.
Author(s): Prof. Samuel Madden, Prof. Robert Morris,
Prof. Michael Stonebraker, Dr. Carlo Curino
This note covers the following topics: Databases and database users, database system
concepts and architecture, relational data model, lab manual, the relational
data model and constraints, Relational algebra and calculus, sql, basic sql,
JDBC API to access relational databases in java, JDBC API javadoc, sun JDBC,
JDBC scrollable resultsets, oracle JDBC drivers for java 6, ER model, enhanced
ER model.