Course Preparation:

we read this article before the semester was started:

Zhiyuan Chen, Chen Li, Jian Pei, Yufei Tao, Haixun Wang, Wei Wang, Jiong Yang, Jun Yang, Donghui Zhang. Recent Progress on Selected Topics in Database Research A Report from Nine Young Chinese Researchers Working in the United States. ACM Journal of Computer Science and Technology Volume 18 , Issue 5 (September 2003)
Reference: [P1]

Technical Reports:

The First Report With Global View:

Distributed Database Systems:
A distributed database is a database that is under the control of a central database management system in which storage devices are not all attached to a common CPU. It may be stored in multiple computers located in the same physical location, or may be dispersed over a network of interconnected computers. [Persian Version] [English Version]
Reference: [DD1], [DD2], [DD3], [DD4], [DD5], [DD6]

The Second Report Whit Subtle View:

Main Memory Database Systems:
Main memory database systems store their data in main physical memory and provide very high-speed access. Conventional database systems are optimized for the particular characteristics of disk storage mechanisms. Memory resident systems, on the other hand, use different optimizations to structure and organize data, as well as to make it reliable. [Persian Version] [English Version]
Reference: [MM1], [MM2], [MM3], [MM4], [MM5], [MM6], [MM7], [MM8], [MM9], [MM10], [MM11]

Presentations:

Distributed Database Systems. [Persian Version]

Main Memory Database Systems. [ Persian Version] [English Version]

Final Project

Project Report. Main Memory Performance TPCB Benchmark. [English Version]
TPC Benchmark™ B exercises the database components necessary to perform tasks associated with that class of transaction processing environments emphasizing update-intensive database services. Such environments are characterized by:

• Significant disk input/output
• Moderate system and application execution time
• Transaction integrity This benchmark is not OLTP in that it does not require any terminals, networking, or think time.

This document discuss TCBP benchmark of FastDB implemented with VC++ and its experimental results.

Conference Papers

Disk Resident Databases Versus Main Memory Databases. [English Version]

Today with decreasing the cost of architecture, main memory-based databases are growing very fast and because they are applicable in many query intensive and real-time applications such as data mining, OLAP, GIS and Multimedia systems they will be very public. In this paper the authors do a benchmark based on TCPB on tow kind of databases, a disk resident database, SQL Server, and a Main Memory resident database, FastDB1, and study there performance and there availability.

A Detaile Comparision of Main Memory Databases. [English Version]

References:

Preperation:

[P1] Zhiyuan Chen, Chen Li, Jian Pei, Yufei Tao, Haixun Wang, Wei Wang, Jiong Yang, Jun Yang, Donghui Zhang. Recent Progress on Selected Topics in Database Research A Report from Nine Young Chinese Researchers Working in the United States. ACM Journal of Computer Science and Technology Volume 18 , Issue 5 (September 2003)

Distributed Database Systems:

[DD1] Abraham Silberschatz, Henry F. Korth, S. Sudarshan. Database System Concepts (4th edition). 2001 McGraw-Hill College

[DD2] R. Ramakrishnan, J. Gehrke. Database Management Systems. 2000 McGraw-Hill Professional

[DD3] C.J. DATE, An Introduction to database systems (7th edition), 2000 McGraw-Hill Professional

[DD4] MIT University Database Open Course web site. [6.893] Database Systems, Fall 2004.

[DD5] Microsoft Corporation. Active Directory LDAP Compliance. Microsoft Corporation Published: October 2003.

[DD6] Ken Birman, Cornell University. Multi-phase Commit Protocols. September 2004. Live Copy

Main Memory Database Systems:

[MM1] Stefan Manegold. Understanding, Modeling, and Improving Main-Memory Database Performance. November 2002

[MM2] Hector Garcia-Molina, Kenneth Salem. Main Memory Database Systems An Overview. December 1992.

[MM3] Nicholas Carriero, Michael V. Osier, Kei-Hoi Cheung, Peter Masiar, Perry L. Miller, Kevin White, Martin Schultz. Exploring the Use of Main Memory Database (MMDB) Technology for the Analysis. Yale University, New Haven, April, 2004

[MM4] MonetDB A Main Memory Database Management System.

[MM5] University of Konstanz. Main Memory Databases Systems.

[MM6] Maurice van Keulen. Main-Memory Databases - Introduction to MMDB. October 16, 2002. Live Copy

[MM7] Maurice van Keulen. Main-Memory Databases - MIL introduction. October 29, 2002. Live Copy

[MM8] Maurice van Keulen. Main-Memory Databases - Main-Memory DBMS architecture. January 14, 2003. Live Copy

[MM9] FastDB - Main Memory Relational Database Management System.

[MM10] Piyush Burte, Boanerges Aleman-Meza, D. Brent Weatherly, Rong Wu. Transaction Management for a Main-Memory Database. 2002. Live Copy

[MM11] Fahimeh Raja, Niloofar Razavi, Melody Siadaty, Maseud Rahgozar. A Comparison Study of Main Memory Databases And Disk-Resident Databases. Department of ECE University of Tehran, Tehran, Iran, 2005

Some Additional Information About This Course:

[ECE-596] http://ece.ut.ac.ir/classpages/F83/AdvancedDataBaseSystem/