Oracle XML DB support (often called "XDB") is built into the
Oracle database and therefore free once you have a DB.
And the Oracle XE database is free.
Best place to continue the discussion is on the forums
http://www.oracle.com/technology/forums/xmldb.html
and
http://www.oracle.com/technology/forums/xml.html
The people who monitor those lists are specialists.
Chris
Ritesh Nadhani wrote:
I just checked: http://www.oracle.com/technology/tech/xml/xmldb/index.html
Is the solution free or we have to pay license cost? I dont see any
information about that.
Christopher Jones wrote:
What computing power would that be? XE (and even other "editions"
of Oracle DB) install fine on small PCs with Linux or Windows.
What performance you get will depend on your load. Best to benchmark
it yourself, like you would benchmark the alternatives.
On the use of PL/SQL, if you want to avoid this, you could return
the XML to PHP. It may not be the most scalable solution, but
it might satisfy your load.
Chris
Ritesh Nadhani wrote:
Thank you.
I dont think we have the computing power for this project to use
Oracle 10g. Also, the system is too big and nobody out here has
actual knowledge of Oracle but anyway I will keep it in mind.
Ritesh
N.A.Morgan@xxxxxxxxxx wrote:
Ritesh,
Don't know of a suitable XML database to use with PHP, but I could
recommend using Oracle 10g. There are built in XML services that
should
help with your project. Furthermore, PHP has a well documented Oracle
interface (OCI8) just for this. To handle the XML though, you would
probably need to get to grips with PL/SQL, Oracle's own stored
procedure
and trigger language. And the best part, you could use OracleXE for
free, although it only gives you a database with up to 4GB user
data, up
to 1GB of RAM and use of only one processor in a multi-processor
environment.
Regarsd,
Neil
-----Original Message-----
From: Ritesh Nadhani [mailto:riteshn@xxxxxxxxx] Sent: 26 January
2007 06:43
To: php-db@xxxxxxxxxxxxx
Subject: PHP with a XML database
Hello all
As part of my research under my professor I have to implement a web
interface to their benchmarking data.
PHP is the chosen web language but we are little worried about the
database. The benchmark data comes to us in XML format (e.g.
http://www.matf.bg.ac.yu/~filip/ArgoLib/smt-lib-xml/Examples/FolEq1.xml)
.
We have to implement an interface to query them, get data, update etc.
We even can change schema in the form of attributes. . The data size
would be around 100 MB each XML with around 100 different XMLs.
The load would be max 5-10 users any given time, batch updates once a
month and heavy load prolly 2-3 times a month. Mission criticality is
not important, we can get it down sometimes. Which db would you
suggest?
i did google research and as of now - I like eXist, Sedna (they seem to
have good PHP wrapper support) and TImber.
Any suggestions?
Ritesh
--
PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:
http://www.php.net/unsub.php
--
Christopher Jones, Oracle
Email: Christopher.Jones@xxxxxxxxxx Tel: +1 650 506 8630
Blog: http://blogs.oracle.com/opal/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
