On 6/21/06, Houghton,Andrew <houghtoa_at_oclc.org> wrote:
> I disagree with this statement. Many modern relational databases,
> such as SQL Server, Oracle, etc. support XML columns and full text
> indexing on columns. Those two features can be used to effectively
> handle semi-structured data.
I think this was talking abbout standards, especially things like
SQL-99 which does not include full-text indexing nor XML structures.
But it's not that hard to change the SQL between databases, so I don't
think it's such a big issue, reall.
> Some relational database engines
> have incorporated object-oriented features and there are a number
> of fully object-oriented database engines that exist, but no standards
> have evolved. With modern relational databases incorporating XML
> columns, *one could*, implement objects in a relational architecture.
Use XML as an import/export format so that we don't have to care about
what the RDBMS might need or do with it. It's the strength of XML.
We did the opposite to what Eric proposes; we dumped everything in a
myriad of XML files on a hard drive, and use Lucene to index it all,
and XSLT to display results. It's lightning fast, powerful and don't
require a single SQL statement nor RDBMS to work, and all the files
are there for any filesystem to see. Simple, elegant, efficent; all
very KISS.
Alex
--
"Ultimately, all things are known because you want to believe you know."
- Frank Herbert
__ http://shelter.nu/ __________________________________________________
Received on Tue Jun 20 2006 - 21:35:58 EDT