Re: How will you use SQL server for unstructured information analy

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: lollipop (lollipop_at_discussions.microsoft.com)
Date: 11/21/04 

Date: Sat, 20 Nov 2004 20:28:07 -0800

so is there any software we can use to transform unstructured information
into semi-structured or structured ones? if not, then SQL server can't
manipulate this knid of data, right?

"David Portas" wrote:

> SQL Server is a relational database (RDBMS - strictly speaking a
> pseudo-relational SQL database). The Relational model is a powerful way to
> represent and manipulate many kinds of data but to use an RDBMS effectively
> you need to have some prior knowledge about the metadata - the structure and
> rules for the data you need to represent - and be able to model that
> metadata in relational terms. The metadata should be more or less static
> during the life of the system as it isn't usually feasible to change the
> model frequently during everyday usage.
>
> So in a nutshell, yes, there needs to be some kind of structure to the
> information you are modelling to make effective use of a database such as
> SQL Server. However I would still ask you to define "unstructured" before I
> could give you a definite answer about SQL Server's suitability for a
> particular scenario. Digital data is rarely entirely unstructured: Images;
> recorded media; free-form text documents; programs; web pages - all of these
> have metadata with identifiable attributes that you may find it appropriate
> to model in a relational database.
>
> As for what advantage SQL Server would give you - that really depends on
> what you want to do. Advantage relative to what?
>
> --
> David Portas
> SQL Server MVP
> --
>
>
>

Relevant Pages

  • Re: SQL2005 sys tables
    ... system objects are stored in a new system database ... there is an equivalent catalog view for every system table. ... Another important change related to system metadata is that in SQL Server ...
    (microsoft.public.sqlserver.security)
  • Meta Data Cleanup options SQL Server 2008
    ... We are currently on SQL Server 2008 and have laptops that we transfer data to ... the best way to handle the metadata cleanup is by changing the subscription ...
    (microsoft.public.sqlserver.server)
  • SQLServer Fmtonly and ADO
    ... ADO uses FMTONLY ON to get metadata from sql server. ...
    (microsoft.public.data.ado)
  • Re: Difference between catalog and metadata?
    ... be stored in the catalog / metadata? ... DB2, Oracle, and SQL server all came into being before there was a standard ...
    (comp.databases.theory)
  • Re: Protecting database
    ... I meant the metadata is available to anyone who can connect! ... "Kalen Delaney" wrote in message ... > SQL Server MVP ...
    (microsoft.public.sqlserver.security)