RE: [cms-list] managing metadata

2003-02-05 Thread Vap, David
Well, after the little amichi vendor slamming, I am a little leary about posting this, since it does indirectly support a product offered by my company, but I think it is still useful information based on your question about metadata. This is a short article I wrote talking about storing metadata/

Re: [cms-list] managing metadata

2003-02-05 Thread Donna M. Fritzsche
Hi Mattias The other method is using a dynamical database implemented in sql where you can define different attributes for each document. I haven't programmed in awhile, but I would be surprised if you couldn't add this feature using XML also. Correct me if I am wrong - and from the spunkines

Re: [cms-list] managing metadata

2003-02-05 Thread Mattias Konradsson
From: "Vap, David" <[EMAIL PROTECTED]> > It would be really nice if next generation CMS knew more about the actual > content of the content and, that is exactly what is happening. Next > Generation CMS vendors are storing content directly in a native XML store. > The benefits of this are numerou

Re: [cms-list] managing metadata

2003-02-05 Thread leon . obrien
Mattias, For the benefit of reviewing other approaches, you might want to look at the solution produced by ww.dstc.com, they have a product called HotMeta. Developing a Metadata solution that supports current and future metadata schema's can become overly, and unnecessarily complex, and the HotMe

Re: [cms-list] managing metadata

2003-02-05 Thread Hilary Marsh
there are several issues to consider: 1, what you will use the metadata for, both in the short-term and in the long-term. If you plan to have extensive personalization, for example, you'll want to begin collecting lots of metadata. 2, you'll need two kinds of metadata -- * attributes of the co

RE: [cms-list] managing metadata

2003-02-05 Thread tonyl/pillarsoftware
>>>convert the incoming XML stream into a set of relational tables that >>>meta-modeled XML structures. Anyone who has done this before knows, XML >>>to Relational Mapping can get quite complicated. I have. The worst is the nesting and finding what nodes to update. There almost has to be ground

Re: [cms-list] managing metadata

2003-02-05 Thread Charles Reitzel
Hi Mattias, I second the comments from Donna, Hillary and Tony, but allow me add a couple thoughts of my own. This is one of my favorite topics, so please excuse the long post. I would submit that neither SQL nor XML are really the best data model for CMS metadata. If you are limited to the

Re: [cms-list] managing metadata

2003-02-06 Thread Jonathan Peterson
I would submit that neither SQL nor XML are really the best data model for CMS metadata. If you are limited to these two, I would go with XML and rely on the capabilities of a decent XML database that allows you to treat the XML interchangeably as either deep or shallow and provides a decent q

Re: [cms-list] managing metadata

2003-02-06 Thread Mattias Konradsson
> > I would submit that neither SQL nor XML are really the best data model > > for CMS metadata. If you are limited to these two, I would go with XML > > and rely on the capabilities of a decent XML database that allows you to > > treat the XML interchangeably as either deep or shallow and provi

Re: [cms-list] managing metadata

2003-02-06 Thread Charles Reitzel
At 05:00 PM 2/6/2003 +0100, Mattias Konradsson wrote: [Relational Method.] This method would allow you to create a "dynamic database" inside of sql server. Luckily I already developed this part for handling user prefences when I realized that i couldnt fix them to a certain set of attributes bu

Re: [cms-list] managing metadata

2003-02-06 Thread Charley Bay
Jonathan Peterson wrote: > I often hear that databases are 'bad' because a > change to the taxonomy requires much work re-writing > SQL queries, whilst in XML, a change merely requires > updating a schema. I can't say agree. All data > processing makes assumptions about the data. Well, I suppose

RE: [cms-list] managing metadata

2003-02-07 Thread Nuno Lopes
Charley wrote: >The ever-present "Databases V. XML: Battle To The >Death" comes from the fact that (relational) >databases are *highly* structured, and XML offers >more degrees of freedom from *highly* to *partially* structured. >From experience the degree of freedom that XML gives within the s

RE: [cms-list] managing metadata;

2003-02-09 Thread Charley Bay
Nuno wrote: > Hi Charley, very interesting indeed your little MV > query engine, how have you implemented it? In other > words what is the underlying data store? > > 1) Is it an RDBMS? > 2) Is it a file or multiple files in the FS? If so > what is the format of those files, XML? Our data store is

RE: [cms-list] managing metadata

2003-02-09 Thread Charles Reitzel
Hi Nuno, At 12:03 AM 2/8/2003 +, Nuno Lopes wrote: Hi Charley, very interesting indeed your little MV query engine, how have you implemented it? In other words what is the underlying data store? Me and Charley Bay are two different people. I actually go by Charlie most places. I decided

RE: [cms-list] managing metadata

2003-02-09 Thread Charley Bay
Charles Reitzel wrote: > Hi Nuno, > > Nuno Lopes wrote: > >Hi Charley, > > Me and Charley Bay are two different people. I > actually go by Charlie most places. I decided to > go by Charles on this list to avoid confusion with > you, Charley! No biggie. Ooops. Sorry to interject. ;-) I'll

RE: [cms-list] managing metadata

2003-02-10 Thread Nuno Lopes
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Charley Bay Sent: segunda-feira, 10 de Fevereiro de 2003 3:26 To: Charles Reitzel; Nuno Lopes Cc: [EMAIL PROTECTED]; Charley Bay Subject: RE: [cms-list] managing metadata Charles Reitzel wrote: > Hi N

RE: [cms-list] managing metadata

2003-02-10 Thread Charles Reitzel
Hi Charley, Interject away. I read your post with great interest. And, please, you all ;-> were here first, and lots of people call me Charles anyway. Nuno's just used to talking to you. The code I originally inherited (before I created the query engine) was a grab bag of Perl scripts that

RE: [cms-list] managing metadata; Perfomance

2003-02-06 Thread tonyl/pillarsoftware
On Behalf Of Jonathan Peterson Sent: Thursday, February 06, 2003 6:47 AM To: [EMAIL PROTECTED] Subject: Re: [cms-list] managing metadata > I would submit that neither SQL nor XML are really the best data model > for CMS metadata. If you are limited to these two, I would go with XML &

RE: [cms-list] managing metadata; Perfomance

2003-02-06 Thread Hendler, Josh
'Jonathan Peterson'; [EMAIL PROTECTED] Subject: RE: [cms-list] managing metadata; Perfomance >Would you store XML as BLOBs in a RDBMS? Pros/cons? I've actually recently been starting to store XML files as BLOBS within Oracle. This seems to work really well, except for the case

RE: [cms-list] managing metadata; Perfomance

2003-02-06 Thread Charles Reitzel
AIL PROTECTED]] Sent: Thursday, February 06, 2003 8:00 AM To: 'Jonathan Peterson'; [EMAIL PROTECTED] Subject: RE: [cms-list] managing metadata; Perfomance >Would you store XML as BLOBs in a RDBMS? Pros/cons? I've actually recently been starting to store XML files as BLOBS within

Re: [cms-list] managing metadata; Perfomance

2003-02-06 Thread Mattias Konradsson
Here's some of my experience: > Tony Wrote: > Would you store XML as BLOBs in a RDBMS? Pros/cons? > Would you store XSLTs as BLOBs in a RDBMS? Pros/cons? > I think XSLTS should be stored on disk...but XML data can be stored in > many ways...Mapped, as BLOBS, etc. I came to the overall conclusio

RE: [cms-list] managing metadata; Versioning

2003-02-06 Thread tonyl/pillarsoftware
; 'Jonathan Peterson'; [EMAIL PROTECTED] Subject: Re: [cms-list] managing metadata; Perfomance Here's some of my experience: > Tony Wrote: > Would you store XML as BLOBs in a RDBMS? Pros/cons? > Would you store XSLTs as BLOBs in a RDBMS? Pros/cons? > I think XSLTS should

Re: [cms-list] managing metadata; Versioning

2003-02-06 Thread Jonathan Peterson
tonyl/pillarsoftware wrote: How do you believe Metadata changes should be approached in the following cases? 1) If the reason for the Metadata change is the introduction of a new business rule that will require code changes. 2) If the reason for the Metadata change is simply to capture more da

RE: [cms-list] managing metadata; Versioning

2003-02-06 Thread Adam Gaffin
> How do get people to add the metadata and when If you ask me, this is at least as important (if not more so than) than figuring out how to store the stuff. GIGO and all that. One example: Our print production system is based on a page metaphor - there are places to enter meta-data for each doc

Re: [cms-list] managing metadata; Versioning

2003-02-06 Thread Mattias Konradsson
> tonyl/pillarsoftware wrote: > > 1) If the reason for the Metadata change is the introduction of a new > > business rule that will require code changes. > > > > 2) If the reason for the Metadata change is simply to capture more data > > that is non-essential to any transaction processing. Can you

RE: [cms-list] managing metadata; Versioning

2003-02-06 Thread Nuno Lopes
Hi all, this topic is of great interest for me too. Me and a couple of friends we have been developing a brand new CMS system using the .NET framework. We are using a relational database to store and manage metadata. We had a couple of brainstorm around how to store metadata effectively. We all ha

RE: [cms-list] managing metadata; Versioning

2003-02-07 Thread Charles Reitzel
At 01:08 AM 2/7/2003 +, Nuno Lopes wrote: Quite often multi values are used to define semantic categories (World(Region(Continent(Country(Country(Region(City))). When querying this is a simple conjuction: Look for companies in: [Region] AND [Continent] AND [Country] AND [Country Region]

RE: [cms-list] managing metadata; Versioning

2003-02-07 Thread Nuno Lopes
Hi Charley, very interesting indeed your little MV query engine, how have you implemented it? In other words what is the underlying data store? 1) Is it an RDBMS? 2) Is it a file or multiple files in the FS? If so what is the format of those files, XML? In the case of 1) do you use the LIKE state

Re: [cms-list] managing metadata; Versioning

2003-02-08 Thread Mattias Konradsson
Thanks everyone for the input, interesting discussion for sure. I decided to go with my dynamic database approach using entity and attributes. Storing metadata simply in the database while clean and flexible solution simple isn't viable since it in effect renders the metadata invisible from the sta