The Relational Data Model, Normalisation and effective Database Design (T. Marston)

Database Management Systems Lecture Notes

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.

Author(s): University of Anbar

60 Pages

Databases by Ken Moody

The contents include: What is DBMS, The relational data model, Entity-Relationship (E/R)modelling, Relational algebra and relational calculus, SQL, Case Study - Cancer registry for the NHS –challenges, Schema refinement I, Schema refinement II, Schema refinement III and advanced design,On-line Analytical Processing (OLAP), Case Study - Cancer registry for the NHS -Experiences, XML as a data exchange format.

Author(s): Ken Moody, Computer Laboratory, University of Cambridge,UK

88 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

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

Database Systems The Complete Book

This book covers the following topics: Databases, Automata, Compilers, Operating Systems, Introductory Java, Data Structures, and Data Mining.

Author(s): Hector Garcia Molina, Jeff Ullman and Jennifer Widom

NA Pages

Database Systems by Raj Sunderraman

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.

Author(s): Dr. Raj Sunderraman

NA Pages

Data Mining notes

This note covers the following topics: Introduction, inductive learning, Decision trees, Rule induction, Instance-based learning, Bayesian learning, Neural networks, Model ensembles, Learning theory, Clustering and dimensionality reduction.

Author(s): Pedro Domingos

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

Database systems I

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