The main objectives of this study are to propose a novel system architecture for processing different types of transactions, to design new and efficient concurrency control and scheduling algorithms to subtly handle the interplay between different types of transactions. A number of key issues identified are listed as follows:
- efficient handling of streaming data and on-time response to user transactions are two basic requirements of a typical monitoring system;
- traditional DBMSs are not designed to efficiently support applications with different types of transactions, and most recent research is mainly devoted to exploring systems with either type of transactions; and
- scheduling between CTs and UTs is also critical to the maintenance of database freshness and temporal consistency of UTs.
Upon successful completion of this project, a new system architecture for monitoring applications will be proposed. Together, new integrated algorithms handling concurrency control and scheduling of different types of transactions will be devised.
