Course Preparation:

we read this article before the semester was started:

According to our previous work on Main Memory Database Systems, for course preparation we read some articles about main memory's architectures. Maurice van Keulen. Main-Memory Databases - Main-Memory DBMS architecture. January 14, 2003. Live Copy [P1]

Technical Reports:

The First Report With Global View:

A Survey on Main Memory Database Systems:
In this step of our work, we do a global research on main memory database systems[Persian Version] [English Version].
Reference: [MM1], [MM2], [MM3]

The Second Report With Subtle View:

Main Memory Database Systems Architecture:
We study the architecture of two different main memory databases, an object oriented main memory database (PerstDB) and a object relational main memory database (FastDB) [Persian Version] [English Version].
Reference: [MM1], [MM2], [MM4], [MM5], [MM12], [MM13]

The Third Report With Detail View of Impelementation:

Main Memory Database Systems Comparison:
In this report we study the behavior of above main memory databases based on their resource usage (like CPU, Memory, Page Fault,..). We also evaluate the tps (Transaction per Second) measure for PerstDB and FastDB using TPC-B Benchmark. [Persian Version] [English Version]
Reference: [MM1], [MM2], [MM3], [MM4], [MM5], [MM6], [MM7], [MM8], [MM9], [MM10], [MM11] [MM12] [MM13]

Presentations:

Main Memory Database Systems, Overview [ Persian Version] [English Version]

Main Memory Database Systems, Implementation [Persian Version] [English Version]

Main Memory Database Systems Comparsion (SQL Server and PerstDB) [Persian Version] [English Version]

Final Project

Main Memory Database Systems Comparison. [English Version]
In this report we study the behavior of PerstDB and FastDB databases based on their resource usage (like CPU, Memory, Page Fault, etc). We also evaluate the tps (Transaction per Second) measure for PerstDB and FastDB using TPC-B Benchmark. Experimental result shows that OOMMDBs outperform ORMMDBs.

 

Conference Papers

Object Oreinted Versus Object Relational Main Memory Databases. [English Version]

Today with decreasing cost and increasing size and speed of RAM memories, many applications are emerging for memory resident databases in which all data are saved in main memory that increases speed and efficiency of the database. Main memory database can be used to run many query-intensive and real-time applications like data mining applications, OLAP, GIS and multimedia systems. In this paper we evaluate performance of two open source databases, an object relational main memory database, FastDB, and an object oriented main memory database, PerstDB, based on TPC-B benchmark. Experimental result shows that object oriented main memory databases can handle huge amount of data and outperform object relational main memory databases.

Main Memory Versus Disk Resident Databases. [English Version]

In this paper we evaluate performance of two kinds of databases, a disk resident database, SQL Server, and two main memory resident databases, PerstDB and FastDB, based on their resource usage at same condition. Experimental result shows that if we have enough available memory, main memory resident databases outperform disk resident databases.

Mining in System Resource Data [English Version]

In this paper we use data mining algorithms to find some association rule between different system resources that used by main memory database. The main system resources (parameters) are CPU, Memory (Memory Available, Page Fault), Disk (Read, Write). This is an idea and we will try to implement this idea precisely.

References:

Preperation:

[P1]Maurice van Keulen. Main-Memory Databases - Main-Memory DBMS architecture. January 14, 2003. 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

[MM 12] PerstDB, http://www.mcobject.com/perst/

[MM 13] TPC BENCHMARK™ B, Standard Specification Revision 2.0, Transaction Processing Performance Council (TPC) © 1994 Transaction Processing Performance Council

Some Additional Information About This Course:

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