Database Systems Lecture Notes
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
NA Pages 
Introduction to Database Systems
The purpose of this note is to give students about an understanding of what database systems are, why we use them, how to use common database systems efficiently and how database systems work internally. Also teaches about variety of data management tasks and different approaches to them.
Author(s): University of California at Berkeley
NA Pages
This book explains you how to use this document oriented database as a standalone application framework or with high volume, distributed applications.
Author(s): J. Chris Anderson, Jan Lehnardt and Noah Slater
NA Pages
Database Management Systems by Rich Maclin
This note covers the following topics: database design and organization, ER(entityrelationship)model, the relational data model, query languages, language basics, relational algebra, domain calculus, sql, programming with dbs, sql interfaces, internet applications, dbms implementation, physical representation, organization overview, file organization, tree indices, hash indices, query evaluation, query evaluation overview, external sorting, join evaluation, other operations, query optimization, transaction management, overview of transactions, concurrency control, crash recovery, security.
Author(s): Rich Maclin
NA Pages
Covered topics: Introduction to databases, Relational model, algebra, calculus, Basics of SQL programming, Advanced SQL programming, Database design and normalization, Basics of query and transaction processing, Introduction to XML (data format and query languages).
Author(s): Leonid Libkin
NA Pages
Database Template Library (DTL) Programmers Guide
Currently this section contains no detailed description for the page, will update this page soon.
Author(s):
Pages
Concurrency Control and Recovery in Database Systems (P. Bernstein, et al)
Currently this section contains no detailed description for the page, will update this page soon.
Author(s):
Pages
The Relational Data Model, Normalisation and effective Database Design (T. Marston)
Currently this section contains no detailed description for the page, will update this page soon.
Author(s):
Pages
A Simple Guide to Five Normal Forms in Relational Database Theory (W. Kent)
Currently this section contains no detailed description for the page, will update this page soon.
Author(s):
Pages
Currently this section contains no detailed description for the page, will update this page soon.
Author(s):
Pages
Representing Trees in a Relational DB
Currently this section contains no detailed description for the page, will update this page soon.
Author(s):
PagesAdvertisement
