Berkeley XML Database

Next topic

Author	Message
Tom C	Friday 11 February 2005 2:07:13 pm Has anyone tried integrating eZ publish with a berkeley database? Does anyone see potential for their XML database as an open source alternative to mysql or postgre, particularly for legal firms and other clients who may require feature-rich xml-based, structured knowledge and document management? (see www.sleepycat.com) Is there any chance that mysql will develop their own XML database? These are key questions for my project, since if we have to redesign, the last thing I want to do is migrate from one database format to another. Additionally, we may wish to use a DTD that is not native to eZ publish for xml data storage or at least for export or transformation for publishing. I'm not sure that's possible. These xml capabilities were the key attraction for me to the Apache Lenya CMS (lenya.apache.org), but I'm hoping eZ publish can be made to do the job. Then, I would gain all the other benefits of eZ publish. Lenya wouldn't work at all for me right now. Another way to get at these questions is to ask, how easily could eZ publish be modified to mimic the xml pipeline architecture of the Apache Cocoon framework or use an equally-effective model? I'm heartened that eZ is gaining functionality to import/export to OpenOffice. This may satisfy our needs, although the industry sector-specific DTD is still an issue. Thanks, Tom
Gabriel Ambuehl	Saturday 12 February 2005 1:25:33 am Personally, I'm not much of a believer in the whole XML DB thing. The concept just seems weird to me. I know there are uses when it makes sense, but all in all, it's really not a general purpose solution. I think Coocoon both gains and suffers from the XML pipe. While very flexible, it's also a pretty slow way to go about assembling pages. If you simply need to import/export a custom DTD, that's probably more within the league of a custom XSLT template, I guess. If it's just one not overly complex DTD you might be able to simply write an import to ezcontentobjects anyhow. Else I'd probably store the XML as you got it and filter it through XSLT upon display. Visit http://triligon.org

Author

Message

Friday 11 February 2005 2:07:13 pm

Has anyone tried integrating eZ publish with a berkeley database?

Does anyone see potential for their XML database as an open source alternative to mysql or postgre, particularly for legal firms and other clients who may require feature-rich xml-based, structured knowledge and document management? (see www.sleepycat.com)

Is there any chance that mysql will develop their own XML database?

These are key questions for my project, since if we have to redesign, the last thing I want to do is migrate from one database format to another. Additionally, we may wish to use a DTD that is not native to eZ publish for xml data storage or at least for export or transformation for publishing. I'm not sure that's possible.

These xml capabilities were the key attraction for me to the Apache Lenya CMS (lenya.apache.org), but I'm hoping eZ publish can be made to do the job. Then, I would gain all the other benefits of eZ publish. Lenya wouldn't work at all for me right now.

Another way to get at these questions is to ask, how easily could eZ publish be modified to mimic the xml pipeline architecture of the Apache Cocoon framework or use an equally-effective model? I'm heartened that eZ is gaining functionality to import/export to OpenOffice. This may satisfy our needs, although the industry sector-specific DTD is still an issue.

Thanks,

Tom

Gabriel Ambuehl

Saturday 12 February 2005 1:25:33 am

Personally, I'm not much of a believer in the whole XML DB thing. The concept just seems weird to me. I know there are uses when it makes sense, but all in all, it's really not a general purpose solution.

I think Coocoon both gains and suffers from the XML pipe. While very flexible, it's also a pretty slow way to go about assembling pages. If you simply need to import/export a custom DTD, that's probably more within the league of a custom XSLT template, I guess. If it's just one not overly complex DTD you might be able to simply write an import to ezcontentobjects anyhow. Else I'd probably store the XML as you got it and filter it through XSLT upon display.

Visit http://triligon.org

eZ debug

Timing:	Jan 18 2025 22:40:47
Script start
Timing:	Jan 18 2025 22:40:47
Module start 'layout'
Timing:	Jan 18 2025 22:40:47
Module start 'content'
Timing:	Jan 18 2025 22:40:48
Module end 'content'
Timing:	Jan 18 2025 22:40:48
Script end

Main resources:

Total runtime	1.1965 sec
Peak memory usage	4,096.0000 KB
Database Queries	54

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0045	588.9375	152.6094
Module start 'layout'	0.0045	0.0026	741.5469	39.4141
Module start 'content'	0.0071	1.1876	780.9609	487.0313
Module end 'content'	1.1947	0.0018	1,267.9922	8.1875
Script end	1.1965		1,276.1797

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0030	0.2473	16	0.0002
Check MTime	0.0013	0.1060	16	0.0001
Mysql Total
Database connection	0.0007	0.0548	1	0.0007
Mysqli_queries	1.1562	96.6334	54	0.0214
Looping result	0.0005	0.0407	52	0.0000
Template Total	1.1692	97.7	2	0.5846
Template load	0.0019	0.1599	2	0.0010
Template processing	1.1673	97.5608	2	0.5837
Template load and register function	0.0002	0.0136	1	0.0002
states
state_id_array	0.0008	0.0705	1	0.0008
state_identifier_array	0.0008	0.0647	2	0.0004
Override
Cache load	0.0015	0.1283	14	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0010	0.0864	2	0.0005
Fetch class attribute name	0.0009	0.0783	2	0.0005
XML
Image XML parsing	0.0002	0.0207	2	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0004	2	0.0000
General
dbfile	0.0006	0.0520	10	0.0001
String conversion	0.0000	0.0006	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
2	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 6 Number of unique templates used: 4

Time used to render debug report: 0.0001 secs