BLOB (Binary Large OBject)
A BLOB (Binary Large OBject) is a large chunk of data which is stored in a database.
A BLOB differs from regular database data in that it is not forced into a certain structure. A normal database field might be structured to be 14 characters long and only accept lowercase letters. A BLOB field is not usually restricted in content type and content can be several gigabytes in size. Normal database fields have space allocated for them whether they are utilized or not. BLOB fields are only allocated space when they are utilized.
BLOB fields are normally used to store graphics, audio, video, or documents.
BLOB fields can be added, changed, and deleted. However, they cannot be searched and manipulated with standard database commands.
|
|
Comments (2)
Leave a Reply
- Object
A Java object is a set of data combined with methods for manipulating that data. An object is made from a class; a class is the blueprint for the object. Each object made from a class will have its own values for the instance variables of that class. Instance variables are things an object knows [...]...
- Large Hadron Collider
The Large Hadron Collider, abbreviated as LHC, is an energy particle accelerator or collider instrument. It is the world’s biggest instrument used by scientists to study and examine the smallest identified particles; which are the primary building blocks of everything. The Large Hadron Collider is a worldwide project with UK playing the major part. This [...]...
- Database Normalization
Database normalization is the process of organizing data into distinct and unique sets. The purposes of normalization are to: Reduce or eliminate storage of duplicate data Organize data into an efficient and logical structure The process of normalization involves determining what data should be stored in each database table. By tradition, the process of normalization [...]...
- Data Dictionary
A data dictionary is an integral part of a database. It holds information about the database and the data that it stores, i.e., the meta-data. Any well designed database will surely include a data dictionary as it gives database administrators and other users easy access to the type of data that they should expect to [...]...
- Binary
At its most general meaning, “binary” refers to any system composed of two elements. For example, a binary star system is a system in which there are two stars that orbit each other. Binary is also a numbering system that is comparable to our standard decimal system. The decimal system uses 10 digits; 0 through [...]...
nice and simple explanation
how audio or video is inserted in multimedia databases?, is sql used for inserting or deleting audio and video? and how these BLOBs are indexed in database?