School of Engineering Department of Computer Science and Engineering 146 Efficient Queries over Database Supervisor: WONG Raymond Chi Wing / CSE Student: SU Hong / DSCT Course: UROP1000, Summer Co-location spatial data mining is a popular topic currently, which can mine some implicit information behind it. Since spatial data mining is very important, temporal-spatial data mining will mine more information. This report will first briefly introduce my immature proposed problems concerning spatial co-location data mining with dynamic time, and then present the related work and preparations I made. After that, some attempts to tackle the problems including some challenges to solve in the future will be shown. Lastly, some reflections will be made to indicate what I have learnt in this summer urop. Efficient Queries over Database Supervisor: WONG Raymond Chi Wing / CSE Student: WEI Yuanjing / DSCT Course: UROP1100, Summer Session-based recommendation system, SBRS for short, has become a trending topic in recent years and has been widely applied in various domains such as e-commerce and online media platforms. However, although many related studies have been conducted and high practical value has been approved in real-life applications, this area has been relatively under-explored. In this report, I will show some widely applied methods for SBRS, summarize the relevant studies for each of the methods, and introduce an existing problem that represents a direction in which further research can be conducted. Knowledge Discovery over Database Supervisor: WONG Raymond Chi Wing / CSE Student: LIANG Houdong / DSCT Course: UROP1100, Fall T-Music is an algorithm that composes a series of musical notes from input lyrics using frequent pattern mining and other data mining techniques. T-Music Web System is a maintainable and scalable system that deploy the usage of the algorithm. It establishes an online interface and allows users to interact with T-Music. However, the implementation of the web system has not been completed yet and there is some future work to do. This project aims to equip the group members basic front-end web design skills as well as to implement some new features based on the original web system.