Web Services w/Oracle and lots of data - practical?
From: Roy Zolnoski <ulrich_at_ulrichandhelvas.com>
Date: 6 Jul 2004 08:17:56 -0700
Message-ID: <a419c803.0407060717.39cbbf4_at_posting.google.com>
[Quoted] [Quoted] I'm involved in a project where we are extracting data from multiple [Quoted] [Quoted] source systems and placing in a data warehouse. The central [Quoted] database/DW is Oracle 9i. The source systems are Oracle 8i and possibly other databases (unknown at this point, it's still early). I'd also like to prepare for non-Oracle databases.
Date: 6 Jul 2004 08:17:56 -0700
Message-ID: <a419c803.0407060717.39cbbf4_at_posting.google.com>
[Quoted] [Quoted] I'm involved in a project where we are extracting data from multiple [Quoted] [Quoted] source systems and placing in a data warehouse. The central [Quoted] database/DW is Oracle 9i. The source systems are Oracle 8i and possibly other databases (unknown at this point, it's still early). I'd also like to prepare for non-Oracle databases.
Data transfer would be once per day after an end of day process is run in the source system. Each system would transfer 150,000+ records to the DW each day. The records are from large, denormalized tables. The average row length from one system is ~370, others might be somewhat less or more.
Are web services practical in this environment? Can web services be used to transfer large amounts of data like this? Any horror or success stories to share?
Any help to this open ended request would be most appreciated. Received on Tue Jul 06 2004 - 17:17:56 CEST