CODEWITHSUNDEEP
sql-serverdatabaseoracle-databasedatabase-designinformix
Eduardo
Eduardo

Reputation: 5943

Why not to use BLOB, CLOB and XML data types?

In the company I work for data administrators dislike using large data types. It doesn't matter the DBMS we are working with. As an alternative the ask developers to store data in file system or some kind of storage. If those types exist so why can't developers use it to store metadata? Are there any plausible reason?

EDIT: In my case I need to store system configuration. I mean very small data. 95% of records are about 50 kbytes and sometimes about 128 kbytes. No images just information. There is a rule of thumb here that you shall not use those data types at all and I cannot understand. Maybe folks here can explain why.

I believe that this happens on other companies also so please don't close my question.

Upvotes: 0

Views: 1448

Answers (1)

Guffa
Guffa

Reputation: 700670

Are there any plausible reason?

There is no definitive answer to that. For each situation there is a best place to store the data, and sometimes that can be the database, but definitely not all of the time.

There are several reasons not to store binary data in a database, but there are also several reason not to store it anywhere else. These vary for each situation, so you would need to consider each sitation separately to get the best decision. If you can isolate the most important variables you could perhaps create some guidelines, for example a size limitation for database storage.

If you for example have a load balanced application then the database is a very convenient place for several servers to store data in the same place. To get the same function for a different storage you need a way to access the storage and a way to synchronise the access. This means more work for the developers, so it comes down to a cost for software development and maintainence compared to a cost for database setup and maintainence.

Upvotes: 2

Related Questions