Synopsis: Phantom Files
Let's learn the challenges related to the storage of images in databases.
We'll cover the following...
Imagine that a catastrophe strikes your database server. While relocating a rack full of hard drives, the rack tips over and crashes. Fortunately, no one gets hurt, but the massive hard drives shatter. Even the raised floor breaks where they fall. Fortunately, the IT department is prepared: they have made good backups of every important system every day, and they quickly deploy a new server and restore your database.
It doesn’t take long during smoke testing to notice a problem: your application associates graphic images with many database entities, but the images are missing! You call the IT technician immediately.
“We restored the database and verified that it was complete until the last backup,” the technician says. “Where were the images stored?”
You remember now that in this application, images are stored outside the database, and ...