Blob

A solution for storing data exchange files (earlier stored on web servers) as BLOBs (Binary Large Objects) in a SQL Server 2000 database.

In case of credit reports, there are so many files that it is impossible to explore the file directory in explorer. So instead off storing uploaded file in a directory structure BLOB (Binary Large Objects) helps these files to be stored in a database thus making the system not only secure but also foolproof. For security reasons, applications should not create files on web servers, but store them in a database.

This application facilitates uploading of files in Blob records, view a list of blob records for an application, sort the list of records, delete a blob record and retrieve /save the contents of a blob record on local hard disk.

All data exchange applications access files. These include files that are received from external vendors (MORNET, Credit Reports, XML, Excel, etc), submitted to them (Response files, Credit Report Requests, etc.) and those that are logged.

Some of these files are transactional in nature - needed only for the duration of the transaction. These files can be safely deleted/purged while others can be archived for audit reasons.

Technology:
Visual Basic 6.0 for COM, ASP 3.0, MS-SQL Server 2000, MS-XMLParser 3.0, XML and XSLT

Duration:
2 Months

Team Size:
One Project Manager and Two Software Engineers