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,
Danny
0  1530  Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Gary Stollman |
last post by:
My Father is a Clone//ETs plotting to overthrow the human race!
On August 19, 1987 a gun-carrying Gary Stollman entered the studio of Los
Angeles's KNBC television, crashing consumer reporter David Horowitz's live
newscast. Stollman handed Horowitz a written statement and ordered him to read
it while holding a gun on him. Unbeknownst to Stollman, KNBC immediately
switched to a commercial, not permitting the statement to be transmitted. ...
|
by: Pramod Ramachandran |
last post by:
Hi group,
I am a software professional working at Trivandrum, south India, with
around 4 years mixed experience in J2EE development, Crystal Reports,
Customer support, Oracle DBA activities and developer support in
PL-SQL. My worry is that I was not able to succeed careerwise in any
one of these areas since I have all these multiple responsibilities -
obviously because ours is a small organization. So last year I
thought of pursuing...
|
by: Alex |
last post by:
Hello people,
The following is not a troll but a serious request.
I found myself in a position where I have to present a Pro/Con list to management and architects in our company with regard to developing new products (specifically - desktop products) in C#/.NET instead of the usual C++/COM that we do.
Since I am not an experienced .NET developer by any definition, I don't have a good grip on the "Pro" part.
The argument that I hear...
|
by: Joel Finkel |
last post by:
Folks,
I am confused as to how to implement the following solution.
I have a series of processing steps, each of which contains similar features
(forms, etc). Therefore, I create a base class, Step, and subclass from that
for specific steps. The Step class has a method, Execute(), which can return
either Success or Failure.
I have a Step Driver, which instantiates the first Step, calls its Execute()
|
by: apattin |
last post by:
Hi all,
I need some expert advice on a ROLLUP fine point.
summary_table table has 4 columns:
file_id
primary_site
morphology
primary
| | |
by: robert maas, see http://tinyurl.com/uh3t |
last post by:
I'm working on examples of programming in several languages, all
(except PHP) running under CGI so that I can show both the source
files and the actually running of the examples online. The first
set of examples, after decoding the HTML FORM contents, merely
verifies the text within a field to make sure it is a valid
representation of an integer, without any junk thrown in, i.e. it
must satisfy the regular expression: ^ *?+ *$
If the...
|
by: Firecore |
last post by:
Are there any expert game programmers here?
Me and my friends have some cool concepts for some games.
They wanted me to give them advice on the programming aspect of making games.
Their ideas were way to complex for me so I was wondering if someone here would help.
All I know is Basic level C,C++.
Please reply to this post if you would be interested in helping me.
Note: There is a good chance there is NO financial profit after making the...
|
by: Ramon F Herrera |
last post by:
My goal is to study (in the RMS sense) and familiarize myself with
some OSS code, until I reach the point at which I can make non-trivial
modifications to it. The class of applications I have in mind are
almost always written in C and run on Unixes. Historically, I have
used a terminal emulator, vi, and gcc/gdb for this type of project,
but would like to become more productive and take advantage of the
facilities provided by an IDE.
...
|
by: Cirene |
last post by:
I am working on an ASP.NET 2.0/SQL Server enterprise application which is
basically a online scheduler (like Outlook functionality.) There will be
many simultaneous users hopefully.
For my sql related tasks I was thinking that most of the work can be done
using Visual Studio's GUI Wizards (drag/drop, etc...) without writing any
SQL related code.
Is there any benefit to choosing to write stored procedures or inline SQL
code (like in a...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
