Re: [PHP-DB] PHP with a XML database
I would tend to agree with this Bastien From: Edward Vermillion [EMAIL PROTECTED] To: Ritesh Nadhani [EMAIL PROTECTED] CC: PHP DB php-db@lists.php.net Subject: Re: [PHP-DB] PHP with a XML database Date: Fri, 26 Jan 2007 15:36:33 -0600 I would imagine that parsing the XML file you get once a month and storing the information in *some* kind of real database, whether it's oracle, mysql, postgresql or whatever would give you better performance than parsing the XML on each page request. Unless the XML is of a trivial size of course, but I didn't get that impression from the original post. Just a thought... On Jan 26, 2007, at 2:24 PM, 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 [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: 26 January 2007 06:43 To: php-db@lists.php.net Subject: [PHP-DB] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ Buy, Load, Play. The new Sympatico / MSN Music Store works seamlessly with Windows Media Player. Just Click PLAY. http://musicstore.sympatico.msn.ca/content/viewer.aspx?cid=SMS_Sept192006 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PHP with a XML database
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:[EMAIL PROTECTED] Sent: 26 January 2007 06:43 To: php-db@lists.php.net Subject: [PHP-DB] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP with a XML database
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 [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: 26 January 2007 06:43 To: php-db@lists.php.net Subject: [PHP-DB] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP with a XML database
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 [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: 26 January 2007 06:43 To: php-db@lists.php.net Subject: [PHP-DB] 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: [EMAIL PROTECTED]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
Re: [PHP-DB] PHP with a XML database
I would imagine that parsing the XML file you get once a month and storing the information in *some* kind of real database, whether it's oracle, mysql, postgresql or whatever would give you better performance than parsing the XML on each page request. Unless the XML is of a trivial size of course, but I didn't get that impression from the original post. Just a thought... On Jan 26, 2007, at 2:24 PM, 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 [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: 26 January 2007 06:43 To: php-db@lists.php.net Subject: [PHP-DB] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP with a XML database
Writing our own parsing thing is out of question. The group has finalised to use a proper DB rather then writing our own code. Moreover, we believe that the code written by a good DB engine would be much more efficient then writing our own module and we are no database experts :) So now its a question of which XML DB to use. After Christophers mail, we would give Oracle a run in next weeks. Lets see On 1/26/07, Edward Vermillion [EMAIL PROTECTED] wrote: I would imagine that parsing the XML file you get once a month and storing the information in *some* kind of real database, whether it's oracle, mysql, postgresql or whatever would give you better performance than parsing the XML on each page request. Unless the XML is of a trivial size of course, but I didn't get that impression from the original post. Just a thought... On Jan 26, 2007, at 2:24 PM, 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 [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: 26 January 2007 06:43 To: php-db@lists.php.net Subject: [PHP-DB] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Ritesh http://www.riteshn.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP with a XML database
Hello Ritesh, Ritesh Nadhani [EMAIL PROTECTED] wrote on 01/26/2007 05:48:27 PM: Writing our own parsing thing is out of question. The group has finalised to use a proper DB rather then writing our own code. Moreover, we believe that the code written by a good DB engine would be much more efficient then writing our own module and we are no database experts :) So now its a question of which XML DB to use. After Christophers mail, we would give Oracle a run in next weeks. Lets see pureXML in DB2 v9 may be an option to explore. It treats XML as a native data type. You could load in the benchmark data XML and query it with SQL to get your reports. Look for the free Express-C edition and use the new PECL extension ibm_db2 (not the odbc_* functions). DB2 9: pureXML Guide http://www.redbooks.ibm.com/redpieces/abstracts/sg247315.html DB2 XML (pureXML) wiki http://www.ibm.com/developerworks/wikis/display/db2xml/Home DB2 Express-C http://www.ibm.com/software/data/db2/express/download.html Daniel Krook Content Tools Developer - SCSA, SCJP, SCWCD, ZCE Global Production Services - Tools, ibm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP with a XML database
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 [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: 26 January 2007 06:43 To: php-db@lists.php.net Subject: [PHP-DB] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP with a XML database
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 [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: 26 January 2007 06:43 To: php-db@lists.php.net Subject: [PHP-DB] 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: [EMAIL PROTECTED]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
[PHP-DB] 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
