What is it about a 200 MB video or audio file that makes it so much more of a database management challenge than a relational database the same size?
What can be done to make the data in these multimedia files more manageable, queryable, reportable and analyzable?
Large file objects such as video or audio clips are types of BLOBs. BLOBs are binary large objects - collections of binary data stored as a single entity in a database management system. BLOBs can be stored within the database or outside of it with reference pointers stored in the database.
The biggest areas of impact of BLOBs are:
The biggest advantage to storing a file-pointer as opposed to the binary data in a database table is speed. This issue can be circumvented in binary storage solutions by keeping the actual BLOB column in a table all by itself with a foreign-key relationship to the other tables -- no need to be reading this table into memory. In my experience, allowing the HTTP server to retrieve an image from the filesystem versus reading binary data from the database table has always been faster.?
As a database grows it will become more difficult to back up. Restoring a backup of a table with over 100 GB of data is time consuming to say the least. Another issue is that all table management functions get slower and slower as the dataset grows.
The database is going to be a fraction of the size when using file-pointers as opposed to blobs but the filesystem is going to be the same either way. Directories and databases can be secured, backed up and restored equally as well when structured correctly.
If and when I need to port my application ...
1. What is it about a 200 MB video or audio file that makes it so much more of a database management challenge than a relational database the same size?
2. What can be done to make the data in these multimedia files more manageable, queryable, reportable and analyzable?
Database Back up
Please discuss what you believe to be a good backup and crisis management strategy considering the following scenario. Provide a detailed explanation of your choices. Be sure to cite your sources.
You work for a small consulting firm with a sterling reputation for high-quality work and outstanding technical aptitude. You've been assigned as the SQL Server 2000 DBA for an e-commerce project based in coastal Florida. Your client is a well-financed, Internet startup firm focusing on creating an online billing system for large hospitals. As a startup firm, they have limited financial resources and must stringently manage their budget.
There are three database environments for your project: development, staging, and production. The development environment is for the web development to create and test their modules and code. The staging environment is where the various components are assembled and tested as a whole. The production environment is the environment that will eventually be your deliverable to the client and will migrate to become the live web presence for the start up.
The client has approached you in the database server room. She's heard there is severe weather coming to the area that may escalate to hurricane status. She would like you to describe in the detail the backup strategies you've developed for each database environment. She'd really like to know how you can save the company money by applying differing backup and crisis management systems to the varying database environments.View Full Posting Details