System and method for managing binary large objects

A method (100) of creating a specified file (40) including a specified Binary Large Object (BLOB) (50) in a system (10), which system (10) comprises a file subsystem (20) arranged to create, store, modify and/or delete files, said BLOB (50) having a BLOB name, characterized in comprising the steps of:

• generating (130-150) a file name;
• in a database subsystem (30) that is part of said system (10), creating a relation (160) between said file name and said BLOB name;
• and
• creating said specified file (40) in said file subsystem (20),
• associating said file name with said specified file (40);
• and
• writing said specified BLOB (50) associated with said BLOB name to said specified file (40).

A method (200) of modifying a specified file (40) including a specified BLOB (50) having a BLOB name in a system (10), which system (10) comprises a file subsystem (20) arranged to create, store, modify and/or delete files, said specified BLOB (50) having a BLOB name, characterized in that the method (200) further comprises the steps of:

• starting a database transaction (210) in a database subsystem (30), that is part of the system (10);
• retrieving (220) the file name for a specified file (40) comprising said specified BLOB (50);
• creating (230-250) a new file name;
• combining (260) the new file name and the BLOB name;
• modifying the specified BLOB (50) and writing (270) the modified specified BLOB to a new file in the file subsystem (20), where said new file is associated with said new file name;
• checking (280) if all previous steps were successful;
• and
• if the check (280) shows that the previous steps were successful, committing (290) said database transaction.

A method (300) of deleting a specified file (40) including a specified BLOB (50) in a system (10), which system (10) comprises a file subsystem (20) arranged to create, store, modify and/or delete files, said specified BLOB (50) having a BLOB name, characterized in that a relation exists between said BLOB name and a file name in a database subsystem (30), and in further comprising the steps of:

• starting (320) a database transaction in said database subsystem (30);
• in said database subsystem (30), deleting (330) the relation between said BLOB name and said file name;
• committing (350) the database transaction, if the previous steps (320-330) were successful;
• and
• in said file subsystem (20), deleting (360) said existing file including said specified BLOB (50), if the previous steps (320-350) were successful.