August 3, 2003 at 12:00 am
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sjones/wheredoiwanttogotodayrichdatatypes.asp
September 29, 2003 at 11:58 am
Steve,
This functionality is already available in Site Server and whatever followed it (Commerce Server, I think.) It catalogs the objects and you have the option to store the metadata as well as links to the parent object in Sql Server.
Richard L. Dawson
Database Admin/Developer
ICQ# 867490
Edited by - Tinker on 09/29/2003 11:59:25 AM
Richard L. Dawson
Microsoft Sql Server DBA/Data Architect
I can like a person. People are arrogant, ignorant, idiotic, irritating and mostly just plain annoying.
September 29, 2003 at 1:45 pm
Thanks for the note. I haven't really worked with Site Server.
I'd like to see some of this in the core product, or as an option for SQL Server itself. Images, Word, multimedia, etc. are common types people want to store.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 2, 2003 at 2:21 pm
This is available in SQL 2000 according to BOL (SQL Server Architecture > Database Architecture > Logical Database Components > Full-Text Catalogs and Indexes) but I have never tried it:
Formatted text strings, such as Microsoft® Word™ document files or HTML files, cannot be stored in character string or Unicode columns because many of the bytes in these files contain data structures that do not form valid characters. Database applications may still have a need to access this data and apply full-text searches to it. Many sites store this type of data in image columns, because image columns do not require that each byte form a valid character. SQL Server 2000 introduces the ability to perform full-text searches against these types of data stored in image columns. SQL Server 2000 supplies filters that allow it to extract the textual data from Microsoft Office™ files (.doc, .xls, and .ppt files), text files (.txt files), and HTML files (.htm files). When you design the table, in addition to the image column that holds the data, you include a binding column to hold the file extension for the format of data stored in the image column. You can create a full-text index that references both the image column and the binding column to enable full-text searches on the textual information stored in the image column. The SQL Server 2000 full-text search engine uses the file extension information from the binding column to select the proper filter to extract the textual data from the column.
Bryant E. Byrd, MCDBA
Sr. SQL Server DBA/Systems Analyst
Intellithought, Inc.
[font="Tahoma"]Bryant E. Byrd, BSSE MCDBA MCAD[/font]
Business Intelligence Administrator
MSBI Administration Blog
October 2, 2003 at 4:25 pm
Interesting. Have to give that a try. I missed that. I wonder if there are other filters that extract from .MP3, .JPG, etc.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 6, 2003 at 2:56 am
Although SQL Server can store, index and search (to a certain degree) complex (non atomic) data types, it offers no native support for them.
BLOB's like audio, video are huge, non-atomic data types that consists of parts and subparts and that's non so easy to represent int a relational db.
BLOB's are mostly stored outside the DB and referenced through pointers. The manipulation itself is afaik done via traditional file IO operation.
I think this would be a move into object-relational (object-oriented) direction.
Maybe in the next release...because I think there is definitely a demand.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply