470,811 Members | 1,154 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,811 developers. It's quick & easy.

Need Expert Advice with decision making

G'day Y'all,

I was hoping to get some expert feedback on a proposal I am considering regarding a new internal application to help fill some gaps in our IT department. I have some configuration data that would work well (very well in fact) defined as XML documents and I want to enrich that data with additional User defined information (child and/or attribute) using an XML application.

Document specifics

1. Document size 150k - 300k each
2. Number of documents 30,000 - 40,000
3. Configuration data relatively static < 1000/week element add/mod/del
4. Modification rate/day of enrichment would vary (initial high but eventually low)

Architecture specifics

1. Embedded DB (Oracle Berkeley DB XML)
2. Apache/Perl UI
3. Solaris 10 Sunfire 480R 16G

XML DB Specifics

1. Master DB read/write - used for automation feeds (new configuration data) and UI (forms/updates enrichment data) not performance dependent
2. Sync (not sure if live sync or timed sync)
3. Replicated DB read only - used for high performance XQuery

Application Specifics- Master DB

1. Configuration (raw/un-enriched XML document) accepted - this only happens when config data changes at source or is new
2. Configuration (raw/un-enriched XML document) DB lookup - if exist step 3 else step 4
3. Configuration (raw/un-enriched XML document) compared and differential analysis to create new document add/mod/del
4. If new document add enrichment elements and insert into DB, if modified document delete original in DB and insert replacement document
5. UI to generate enrichment forms across multiple documents using XPath/RegEx/Whatever (not sure yet)
6. UI updates to enrichment elements/attributes

Application Specifics - Replicated DB

1. UI reporter - generate reports with multiple capabilities even across documents based off element/attributes etc... with reports being display using XLS
2. WebSvcs - SOAP interface to extract a single enriched element using Indexed search capabilities in XML database - MUST be fast when queried

What I would like to know does any of the expert XML programmers out there see a problem with my idea for the architecture/DB/application or see any technical difficulties and/or assumptions I am making that probably wouldn't work?

I am looking for real advice from experience as this would be my first attempt going down the XML highway and moving away from a standard RDBMS multi-tiered application...

Any suggestions/recommendations would be greatly appreciated...

Thanks for your attention,
Sep 14 '08 #1
0 1379

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Gary Stollman | last post: by
3 posts views Thread by Pramod Ramachandran | last post: by
55 posts views Thread by Alex | last post: by
16 posts views Thread by Joel Finkel | last post: by
3 posts views Thread by apattin | last post: by
232 posts views Thread by robert maas, see http://tinyurl.com/uh3t | last post: by
4 posts views Thread by Firecore | last post: by
22 posts views Thread by Ramon F Herrera | last post: by
2 posts views Thread by Cirene | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.