Re: SQL SERVER

From: Philippe [MS] (ptrotin_at_online.microsoft.com)
Date: 10/19/04 

Date: Tue, 19 Oct 2004 22:35:12 +0200

It's not only an Explorer problem. You have limitation linked with the
number of files you need to store : it's the same problem in every file
system even if the limitation is not the same (try to use FAT and not NTFS
and you will see !!!). I have worked on a project where a robot put
togeather two piece of material and a camera take a picture each time. The
file system was not accessible even in the command prompt because we have
reached the l:imit (it was in FAT).

Here is sample you want for why storing XML in a database :

I am working today on a project where we have creating a rule engine needed
to calculate promotions (for e-commerce purpouse). The problem of that rule
engine is that you can define many different parameters depending on how you
want the engine work (many different kind of rules). For that kind of
problem, you have the possibility to define a specific table for each case
you have (which means maybe 50 different relational tables) or to store in a
XML column of the table the definition you want (it's not relational any
more even if the whole database is a relational one : product catalog,
orders, ...). We stored those files into the database beacause many other
things where better stored in a relational database than in a file.

Today with SQL 2000, you cannot index that XML column and it's not so easy
to extract a specific node contain in that XML. That would be possible in
SQL 2005 by defining which node you want to extract (you can construct a
specific column with the node you want) and index it.

If your web site is a static one maybe not using a database could be a good
choice for you but if you need to store information concerning users where
are you going to store informations ???

P.S. Please do not be so agressive in your e-mail even if the answer does
not correspond to what you expect, just ask for a better answer (everybody
in a Forum is spending times for you) !!! :-(

Phil.

"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:uSrKREhtEHA.2536@TK2MSFTNGP11.phx.gbl...
> > The main things you are going to gain concern performance.
> >
> > Try to put many many files (more than 10.000 XML files) into a folder
and
> > access it (even in NTFS).
>
> This is a windows explorer problem specifically, and has nothing to do
with
> the type of files or even the type of file system. I have no problems
> listing such a folder from a command prompt, but Explorer's dumb GUI
always
> stuffs things up because it requires so much overhead.
>
> > You can put in a database indexes that allow you to access directly to
the
> > information you need. In SQL Server 2005, you will also can add columns
> > based on XML you store in the database and also add index on these
> columns.
>
> Can you explain a real-world business case, rather than a vague "you can
do
> this" story, that makes XML files stored in the database preferable over
no
> database at all, especially given the cost? Pretend for a minute that
users
> aren't going to be browsing folders containing 10s of 1000s of files in a
> klunky interface like Windows explorer (but even then, they aren't going
to
> be able to just browse the XML files that are in the database, at least
not
> in current versions).
>
>

Relevant Pages

  • Re: DataBase
    ... > You can use XML to store the data pretty easily. ... > with ADO.net you can import or export the data to XML. ... > Andrew J. Kelly SQL MVP ... >> database, but I need it not to use any SQl server. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: RSS SQL tables
    ... optimal database structure. ... Define all the elements you want to store. ... xml does not translate well to a relational database. ...
    (comp.databases)
  • XML in DataBase
    ... We need to store an entire XML document intact (not breaking the ... the SQL database to the file). ...
    (microsoft.public.sqlserver.xml)
  • Re: storing data in xml?
    ... >>I want to store a few informations the user entered on my website. ... >>However I don't want to use a MySQL database for this. ... > service, etc. then use XML. ... format for storage and retrieval. ...
    (alt.php)
  • Re: public and private mailboxes randomly dismounting
    ... When posting logs an important piece is the Event ID and Source. ... Information Store First Storage Group: An attempt to move the file ... An error occurred while writing to the database log file of storage group ...
    (microsoft.public.windows.server.sbs)