What is the full form of BLOB


BLOB: Binary Large Object

BLOB stands for Binary Large Object. It is a complex data type, a collection of binary data stored in a database management system. It stores binary data. The variables of this data type have a variable length unlike most of the other data types like integers, floating point numbers, characters and strings. It is used to store images, audio files, and video clips etc. For example, a photo album can be stored in a database through BLOB data type for images and through a string data type for the captions.

Typical BLOB files and types:

  • Video .avi
  • Audio .mp3
  • Images .jpeg
  • Graphics. giff
BLOB full form

BLOB can be up to 2,147,483,647 characters long. It requires more space than other data types as it is used to store multimedia files. Generally, its size is determined by the disk storage capacity of your system. The minimum size in C/SIDE is 2 GB. Furthermore, BLOB strings are linked with a code page, and do not hold character data.

Managing binary large objects

Managing binary large objects is a problem that many firms have to deal with. Because BLOB files are binary in nature, a database frequently is unable to read all of them. Again, this is a result of databases' inability to precisely identify such vast amounts of data. Digital asset management (DAM) is a selection for BLOB storage solutions. Through the use of consolidated cloud storage, this eliminates the need for additional servers and enhances productivity.

BLOBs in Databases

Database BLOBs require specialised processing. Unavoidable special data types exist. The unstructured data in BLOBs cannot be read or understood by databases. All of it must be stored. Only the file name, type, and size of the BLOB can be read by databases. As a result, using database features like sorting, filtering, and searching for particular content in a BLOB is not possible.

Different database systems store binary large objects in various ways. BLOBs are typically saved outside since the nature of databases frequently makes it impractical to store them directly. Thus, the database itself merely provides a link to the location of the external file's actual storage. Depending on the database system being utilised, there are also several names for huge binary files. Even the words for files of particular sizes are different in some solutions, like MySQL. The following table lists some of the most well-liked systems along with their corresponding terminology for Binary Large Objects.

DatabaseData type
MySQLUp to 0.255 KB: TINYBLOBUp to 64 KB: BLOBUp to 16 MB: MEDIUMBLOBUp to 4 GB LONGBLOB
PostgreSQLBYTEA and Object Identifier
OracleBLOB
DB2BLOB
Microsoft SQL Serverbinary, varbinary, text, ntext

Where are BLOBs used?

The big data industry is the main use for BLOBs. Massive amounts of raw data are gathered from website users, combined into collections, and kept in databases all around the world. Since this acquired data is unstructured in its unprocessed state, database systems can gather in the simplest method possible. Databases can also be used to store movies or TV programmes in a semi-encrypted form using BLOBs.

In the world of open source, binary large objects are also utilized. Even while all components of an open-source project should be able to be produced from a publicly available source code by definition, this isn't always the case.

In some instances, proprietary components that are only available in binary form are also provided. This data is also referred to as "BLOBs," but it is debatable whether or not open-source projects should incorporate them.

Advantages and disadvantages of Binary Large Objects

AdvantagesDisadvantages
BLOBs are a good option for adding large binary data files to a database and can be easily referencedNot all databases permit the use of BLOBs
It is easy to set access rights using rights managementBLOBs are inefficient due to the amount of disk space required and access time
Database backups or dumps contain all the dataCreating backups is highly time consuming due to the file size of BLOBs

Next TopicFull Form




Latest Courses