| Groups | Blog | Home |
sql server data warehouse : Using BLOBs in SQL
Can anyone tell me what the pros/cons are of using blobs in sql?
We are looking at scanning certain paperwork and storing it with the appropriate records in our database. The two options are to store the images as blobs or to store them as file system objects with a referral pointer in the db. I have heard a number of different people say that storing blobs is inherently evil but they haven't explained why that is. Any help will be appreciated.
I am also curious about this...
I've been looking at methods of storing PDF files and I'd have the exact same questions.... Any help is appreciated. TIA Carter Lekatz *xnoxspamx*c.lekatz@*xnoxspamx*halconcorp.com remove *xnoxspamx* to reply [quoted text, click to view] "Jawallaby" <Jawallaby@discussions.microsoft.com> wrote in message news:FDC4B228-66A2-4469-9262-E3DD3851A3DB@microsoft.com... > Can anyone tell me what the pros/cons are of using blobs in sql? > > We are looking at scanning certain paperwork and storing it with the > appropriate records in our database. The two options are to store the images > as blobs or to store them as file system objects with a referral pointer in > the db. > > I have heard a number of different people say that storing blobs is > inherently evil but they haven't explained why that is. > > Any help will be appreciated. >
Here are some views:
http://www.aspfaq.com/show.asp?id=2149 -- Adam Machanic SQL Server MVP http://www.datamanipulation.net -- [quoted text, click to view] <someone@work.com> wrote in message news:domdnQFMVKa27JLeRVn-tQ@onvoy.com... > I am also curious about this... > I've been looking at methods of storing PDF files > and I'd have the exact same questions.... > Any help is appreciated. > > TIA > > Carter Lekatz > *xnoxspamx*c.lekatz@*xnoxspamx*halconcorp.com > remove *xnoxspamx* to reply > "Jawallaby" <Jawallaby@discussions.microsoft.com> wrote in message > news:FDC4B228-66A2-4469-9262-E3DD3851A3DB@microsoft.com... > > Can anyone tell me what the pros/cons are of using blobs in sql? > > > > We are looking at scanning certain paperwork and storing it with the > > appropriate records in our database. The two options are to store the > images > > as blobs or to store them as file system objects with a referral pointer > in > > the db. > > > > I have heard a number of different people say that storing blobs is > > inherently evil but they haven't explained why that is. > > > > Any help will be appreciated. > > > >
I've not reviewed all of the referenced KB articles in the aspfaq.com link,
a brief review tells me that not one makes reference to Full-text Search of files stored in SQL Server 2000 tables! Adam, perhaps you could get them to add a few? <G> I just blogged how to upload (import) PDF files into a SQL Server 2000 table's IMAGE column (with "file extension" column) and Full-Text Index (FTI) and Full-Text Search (FTS) the contents of these files after downloading & installing the Adobe IFilter: Full Text Search Adobe PDF files stored in SQL Server... http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!537.entry Enjoy! John -- SQL Full Text Search Blog http://spaces.msn.com/members/jtkane/ [quoted text, click to view] "Adam Machanic" <amachanic@hotmail._removetoemail_.com> wrote in message news:un0%23IpnqFHA.3604@tk2msftngp13.phx.gbl... > Here are some views: > > http://www.aspfaq.com/show.asp?id=2149 > > > -- > Adam Machanic > SQL Server MVP > http://www.datamanipulation.net > -- > > > <someone@work.com> wrote in message > news:domdnQFMVKa27JLeRVn-tQ@onvoy.com... >> I am also curious about this... >> I've been looking at methods of storing PDF files >> and I'd have the exact same questions.... >> Any help is appreciated. >> >> TIA >> >> Carter Lekatz >> *xnoxspamx*c.lekatz@*xnoxspamx*halconcorp.com >> remove *xnoxspamx* to reply >> "Jawallaby" <Jawallaby@discussions.microsoft.com> wrote in message >> news:FDC4B228-66A2-4469-9262-E3DD3851A3DB@microsoft.com... >> > Can anyone tell me what the pros/cons are of using blobs in sql? >> > >> > We are looking at scanning certain paperwork and storing it with the >> > appropriate records in our database. The two options are to store the >> images >> > as blobs or to store them as file system objects with a referral >> > pointer >> in >> > the db. >> > >> > I have heard a number of different people say that storing blobs is >> > inherently evil but they haven't explained why that is. >> > >> > Any help will be appreciated. >> > >> >> > >
I suggest you store it as a blob in the database
rather using pointer to files. the reason is security. as long as no one enters the db then no one gets the files the second reason is that i have my files organized in the db providing fields and attributes that can properly describe the files such as authors, datecreated and version. if you are designing as system that uses versioning and check-in checkout feature i suggest you use this approach. you must however store the blob field in a separate file group to avoid fragmentation -- Jose de Jesus Jr. Mcp,Mcdba Data Architect Sykes Asia (Manila philippines) MCP #2324787 [quoted text, click to view] "Jawallaby" wrote:
> Can anyone tell me what the pros/cons are of using blobs in sql? > > We are looking at scanning certain paperwork and storing it with the > appropriate records in our database. The two options are to store the images > as blobs or to store them as file system objects with a referral pointer in > the db. > > I have heard a number of different people say that storing blobs is > inherently evil but they haven't explained why that is. > > Any help will be appreciated.
i've designed similar appilcation before.
i use msoffice 2003 to do the OCR store the the granular text to a text field and then i store the image into the blob then i made use of the textfield for my full text search when i want to retrieve the document i retrieve the scanned image its neat if everything is in sql i'm in full control of versioning -- Jose de Jesus Jr. Mcp,Mcdba Data Architect Sykes Asia (Manila philippines) MCP #2324787 [quoted text, click to view] "Jawallaby" wrote:
> Can anyone tell me what the pros/cons are of using blobs in sql? > > We are looking at scanning certain paperwork and storing it with the > appropriate records in our database. The two options are to store the images > as blobs or to store them as file system objects with a referral pointer in > the db. > > I have heard a number of different people say that storing blobs is > inherently evil but they haven't explained why that is. > > Any help will be appreciated.
I will mention it to the author (Aaron Bertrand)!
-- Adam Machanic SQL Server MVP http://www.datamanipulation.net -- [quoted text, click to view] "John Kane" <jt-kane@comcast.net> wrote in message news:O2ORjKRrFHA.3788@TK2MSFTNGP12.phx.gbl... > I've not reviewed all of the referenced KB articles in the aspfaq.com link, > a brief review tells me that not one makes reference to Full-text Search of > files stored in SQL Server 2000 tables! Adam, perhaps you could get them to > add a few? <G> > > I just blogged how to upload (import) PDF files into a SQL Server 2000 > table's IMAGE column (with "file extension" column) and Full-Text Index > (FTI) and Full-Text Search (FTS) the contents of these files after > downloading & installing the Adobe IFilter: > > Full Text Search Adobe PDF files stored in SQL Server... > http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!537.entry > > Enjoy! > John > -- > SQL Full Text Search Blog > http://spaces.msn.com/members/jtkane/ > > > > "Adam Machanic" <amachanic@hotmail._removetoemail_.com> wrote in message > news:un0%23IpnqFHA.3604@tk2msftngp13.phx.gbl... > > Here are some views: > > > > http://www.aspfaq.com/show.asp?id=2149 > > > > > > -- > > Adam Machanic > > SQL Server MVP > > http://www.datamanipulation.net > > -- > > > > > > <someone@work.com> wrote in message > > news:domdnQFMVKa27JLeRVn-tQ@onvoy.com... > >> I am also curious about this... > >> I've been looking at methods of storing PDF files > >> and I'd have the exact same questions.... > >> Any help is appreciated. > >> > >> TIA > >> > >> Carter Lekatz > >> *xnoxspamx*c.lekatz@*xnoxspamx*halconcorp.com > >> remove *xnoxspamx* to reply > >> "Jawallaby" <Jawallaby@discussions.microsoft.com> wrote in message > >> news:FDC4B228-66A2-4469-9262-E3DD3851A3DB@microsoft.com... > >> > Can anyone tell me what the pros/cons are of using blobs in sql? > >> > > >> > We are looking at scanning certain paperwork and storing it with the > >> > appropriate records in our database. The two options are to store the > >> images > >> > as blobs or to store them as file system objects with a referral > >> > pointer > >> in > >> > the db. > >> > > >> > I have heard a number of different people say that storing blobs is > >> > inherently evil but they haven't explained why that is. > >> > > >> > Any help will be appreciated. > >> > > >> > >> > > > > > >
Don't see what you're looking for? Try a search.
|
January 2003
March 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |