comparing database
I need to choose a database for storing xml documents. I know i can use the followind databases : Oracle 8i, Microsoft SQL Server 2000,Informix and MySQL. I don't know which data to choose for my application. In fact i'm buildind an HTML code builder and i'll need to save my docs in a database. I'd be most grateful if someone could help me
Thanxs
Cookie
Peter J. Boettcher posted this at 19:05 — 3rd September 2001.
They have: 812 posts
Joined: Feb 2000
SQL Server 2000 is great with XML since it can handle it natively, I'm pretty sure the latest version of Oracle can also, I can't comment on the other ones. So instead of storing the actual document you can just store the data and the database generates the XML.
PJ | Are we there yet?
pjboettcher.com
cookie posted this at 14:14 — 5th September 2001.
They have: 8 posts
Joined: Sep 2001
Hi
First of all thanks . Just wanted to know which database u'd advice me to choose between SQL Server 2000 and Oracle 8i.
By the way could u tell me something about XML parsers for databases . Does SQL SERVER 2000 needed and XML parser too.
Thanks again
Cookie
Peter J. Boettcher posted this at 15:07 — 5th September 2001.
They have: 812 posts
Joined: Feb 2000
SQL Server 2000 has it's own built in parser, the version of the parser depends on the service packs you have installed. I think the latest version is around 3.0
You might want to check out these links:
http://www.microsoft.com/sql/evaluation/compare/discussion.asp
http://www.microsoft.com/sql/evaluation/compare/mythandreality.asp
PJ | Are we there yet?
pjboettcher.com
cookie posted this at 14:18 — 6th September 2001.
They have: 8 posts
Joined: Sep 2001
Hi
thanks once again Peter.
Could u please tell me what is the difference between a database server and database.
Also i would like to know where can i find a JDBC driver for SQL Server 2000 if possible type 4 and free.
If not free which driver to u advise me to choose.
Cookie.
Peter J. Boettcher posted this at 14:46 — 6th September 2001.
They have: 812 posts
Joined: Feb 2000
The difference between a database server (SQL Server, Oracle, etc) and a simple database (Access, text file, etc)is features & performance. A simple database just offers data storage, whereas a database server offers much more, including better performance, better security, enhanced features like stored procedures, views, triggers, the ability to schedule jobs (queries) to run.
As for the JDBC question, I don't use Java to connect to my databases so I can't really advise you on that, but from what I hear, a couple of the ones most commonly used are:
WebLogic
weblogic.com
&
OpenLink
openlinksw.com
Although I haven't used it, I think Microsoft provides a tool that bridges between JDBC & ODBC, you might find more on that here: microsoft.com/java
PJ | Are we there yet?
pjboettcher.com
Vincent Puglia posted this at 22:08 — 24th September 2001.
They have: 634 posts
Joined: Dec 1999
Hi Peter & how are u?
seeing as how I don't have sql server, I was wondering about the xml parser. Specifically, does it follow irt standards? Or, is it like Front Page (which tends to flaunt html standards and relocate javascript where ever it pleases)?
Vinny
Where the world once stood
the blades of grass cut me still
Peter J. Boettcher posted this at 22:27 — 24th September 2001.
They have: 812 posts
Joined: Feb 2000
Hey Vincent, I haven't seen you for a while!
In regards to the XML standards in SQL 2000, for a Microsoft Product, they're pretty good. The XML is well formed, without any nasty surprises.
I'm still learning most of the XML features in 2000, and how I can apply them to applications, but so far it's pretty solid.
PJ | Are we there yet?
pjboettcher.com
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.