Current location - Music Encyclopedia - QQ Music - How does the database store and extract music files?
How does the database store and extract music files?

The database does not store files directly. \x0d\The address where music files are stored on the hard disk in the database is in string format. Then when used, it is OK to read the corresponding address from the database\x0d\The database is organized according to a certain data model and stores secondary A collection of data in memory. This kind of data collection has the following characteristics: it is as non-duplicate as possible, serves multiple applications of a specific organization in an optimal way, its data structure is independent of the applications that use it, and the addition, deletion, modification and retrieval of data are performed by Unified software for management and control. \x0d\You can imagine a database as a collection of a lot of data tables, and the data is stored in each table\x0d\Pictures, files, etc. can also be stored in database tables, but they need to be converted into binary encoding in the data format Store, and then convert it into the original format through the program when it needs to be taken out\x0d\For example, the message board, the content you see is stored in a record table in the database, and one message occupies one record row. When needed, it can be read through SELECT and other statements. Take out its content, display that the content has been updated, and also update the data of the corresponding record row in the database through UPDATE and other statements.