Find some data for experiments. You can use all films with titles, directors, actors and other related information. Some other data such as Infected cases by COVID-19, Stock data, Library data etc. is also fine. But the size should be reasonably large.

Store the data into a database table. Then use select in SQL to find the films with word XXX in titles, and record the execution time.

Store the data into a file, and then load it into RAM. The data in RAM can be any format you preferred. Design an algorithm to search XXX in titles. Record the execution time of your algorithm.

Some other comparisons and experiments you would like to do. Such as you can reorganize data into some other format for faster retrieval. You are recommended to study the mechanism of DMBS for storing and retrieval

SUGGESTED structure of your report

1. Title

Please give your report a title that can reflect the core point of your work.

2. Introduction

To introduce what you want to prove in the experiments. DO NOT copy any text from Internet.

3. Experimental design

3.1 Experimental data and environments.

Introduce the data, DBMS and the programming language you choose. How you organize the data.

3.2 Experiments

Describe your experiments here. To make sure the experiments should be reasonable and the comparisons should be fare.

3.3 Experimental results

Show your results in tables and figures, and analysis the differences of different methods.

4. Conclusions

Give your conclusions here. You can also present you options on DBMS.

Several website can give you some ideas to research, but those are only theory description:

1. Advantage of database management system over file system
2. Advantages of Database Management System
3. Characteristics and benefits of a database

Basic Requirement

1. Clearly and easy understanding design.
2. You need to show that you really do the experiments by some experimental details and reasonable analysis.

Bonus

If you can do some of the following functions (but not limit to the following ones), you will win bonus.

1. High concurrency and transaction management
2. User privileges management
3. Database index and file IO
4. Large data sets (the data is large enough and cannot be stored into RAM)
5. Compare performance of multiple databases with file system over different operation systems