Maybe I'm missing something in what you said, but have you exposed Web
services interfaces which you've now integrated into the same overall
approach to the problem? Is it possible to generate triggers on the
databases which will push updates to the centralized repository as they
happen so the data is always "just there"? Maybe not.
SOA isn't really an architectural style designed for batch processing
types of activities. What you want to do is isolate the data you need
to move and the move it when it changes (providing you've already
decided you want/need to replicate it), or you just aggregate meta-data
about the data and then go fetch it as you are actually going to use it.
SOA is as much about re-thinking the problem as it is loose coupling and
Web services.
Cheers,
ast
On Thu, 2006-06-01 at 22:10, Lukas Barton wrote:
> Hi,
>
> I am a developer of software that queries banks' data (eg. ask
> executors, tax burear etc. questions about clients property).
> It is now uses in 16 banks. In most of them we integrate through "SQL
> interface" - tables which are cache of canonicalized distributed data
> (eg. 3 or more banking IS - accounts, safe boxes, credit card, stocks
> and bonds...). Quite interesting and specific application from EAI view
> ;-) (integrate with all important IS)
> Now we're transfering from database to web services and we face up
> performance issues:
> - replicating database takes at most tens of minutes (AS/400, 5 mil
> rows) performed nightly
> - answering one query takse 10-20 ms (eg. 3 inserst via INSERT INTO
> ... SELECT FROM ...)
> - using web service against live system means (per query)
> - WS call means
> - WS encapsulates EJB
> - EJB encapsulates COBOL
> - COBOL read from more than one database
> - for each query we have at least 5 WS calls over local network
> (that's how WS usualy work when you have legacy systems)
>
> Other benefits:
> - using web services is not yet quite common practice, while using
> databases is - every one knows SQL
> - they can store derived fields that computes long time or it's
> imposible to have it computed online - eg. last transaction on account
> - you can do some trick that web services usually does not support -
> like with *,?; seach by every column you want
>
> But we view our tables as well defined interface between bank and our
> application. It does not change between minor versions. Of course it
> does between main version. The last version of application is independet
> of tables structure (it could be used for queries over bank accounts, in
> telecomunication company, insurance company etc.).
>
> BI viewpoint:
> You must have some DWH for BI, eg. DWH hidden behind services. Some
> data cannot be computed online from other services.
>
> Lukas
>
> http://www.archaebacteria.net
>
> >
> > In the context of SOA-based "master data management", one can do
> > parallel service invocations out to the "freshest data", certainly.
> > But there are some areas where an ODS is still needed:
> > - a persistent cross-reference
> > - master key management
> > - a cache of canonicalized distributed data
> > - a store for derived and/or invented fields (such as those created by
> > a cleansing process)
> >
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
***************************************************************************************************
The information in this email is confidential and may be legally privileged Access to this email by anyone other than the intended addressee is unauthorized. If you are not the intended recipient of this message, any review, disclosure, copying, distribution, retention, or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. If you are not the intended recipient, please reply to or forward a copy of this message to the sender and delete the message, any attachments, and any copies thereof from your system.
***************************************************************************************************
SPONSORED LINKS
| Computer software | Computer aided design software | Computer job |
| Soa | Service-oriented architecture |
YAHOO! GROUPS LINKS
- Visit your group "service-orientated-architecture" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
