Traditional Culture Encyclopedia - Traditional customs - What are the main problems in using traditional database to store and manage multimedia data such as audio, video and video?

What are the main problems in using traditional database to store and manage multimedia data such as audio, video and video?

It is very good to manage pictures with a database. I have been using this database, but considering that the database may become huge, there are several ways to reduce the space:

1. Make the picture smaller;

2. In many cases, not every recorded picture is different, and sometimes many records will reuse the same picture. At this point, you can create a separate database table for pictures and set an ID field in the table to uniquely index and store each picture. After that, the field type in the data table where you want to store pictures is changed from Image to int. In BCB design, the ID field from the stored picture can be found in the combo box of LookUp, which will reduce the problems caused by repeated reference of the picture.

In addition, for the convenience of management, the pictures should be put in the database, not in the file.