Thursday, 14 March 2013

Advanced Database Management Systems(ADBMS) lab report 1st sem cs vtu

19:39 - By rajshekar t 8


1. Develop a database application to demonstrate storing and retrieving of BLOB and CLOB objects.

The document repository will use one database containing one table to store its data. Using the MySQL console application (c:\mysql\bin\mysql.exe for Win32 or /usr/bin/mysql for *nix users), create the database and switch to it with the following commands:

create database myFiles;
use myFiles;

Next create the table that will actually store the BLOB's as part of the myFiles database:

create table myBlobs
Image credit
blobId int auto_increment not null,
blobTitle varchar(50),
blobData longblob,
blobType varchar(50),
primary key(blobId),
unique id(blobId)

Now there is one database named myFiles, which contains one table named myBlobs. The details of each field in the myBlobs table are shown below:
·         blobId: An integer that will provide a unique numerical identifier for each blob (ie 1, 2, 3, etc). It is incremented and tracked internally by MySQL whenever a new record is added.

·         blobTitle: A description of each blob in the table, for example "My word document about golf", or "Picture of the sky". It serves no real purpose, but will come in handy when viewing the files  through a web page later on.

The above is sample. Click on Download to get the complete 



                                                         How to download?

About the Author

Rajshekar Targar is a tech passionate guy who loves to code,blog,surf tech news, reading motivational articles, and tries out something new and interesting on technology every now and then. Follow me Rajshekar

Share This Post


  1. ADBMS files are corrupted please update again or mail me


      Thank You

    2. i rechecked the files. they are working fine. anyways will mail you

  2. not able to download .............. Its asking for a survey to be completed to download but not able to complete the survey ...... Please upload to some other file sharing site

  3. Pleass can u mail the dbms lab program
    Its not opnening so please mail me to
    Reply me please as soon as possible

  4. Hi Rajshekjar,
    Can you forward the ADMBS lab programs to me at

  5. Boss if any 1 is having these programs wit u den would u pls mail me on


© 2014 MTech CS. WP Theme-junkie converted by Bloggertheme9
Powered by Blogger.
back to top