Thursday, 14 March 2013

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

07:09 - By rajshekar targar 8




PROGRAMS

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 

resources

                       DOWNLOAD


                                                         How to download?

Tags:
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

8 comments:

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

    ReplyDelete
  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

    ReplyDelete
  3. Pleass can u mail the dbms lab program
    Its not opnening so please mail me to siddu.jain7@gmail.com
    Reply me please as soon as possible

    ReplyDelete
  4. Hi Rajshekjar,
    Can you forward the ADMBS lab programs to me at nidugala2@yahoo.com
    Thanks,
    Shree.

    ReplyDelete
  5. Boss if any 1 is having these programs wit u den would u pls mail me on reddy9125@gmail.com

    ReplyDelete
  6. can anyone please forward these adbms lab programs to my mail id-a123alfiya@gmail.com.
    Thanks

    ReplyDelete
  7. This comment has been removed by the author.

    ReplyDelete
  8. Please can anyone mail me adbms lab programs on my mail id-- almas0603@gmail.com....it is very urgent.plzz plzz plzzzzzz

    ReplyDelete

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