April 1999
Intermediate to advanced
552 pages
15h 39m
English
Content preview from Oracle Distributed SystemsBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Loosely Coupled Federation
If nothing else, you probably have a distributed system configuration that can best be described as aloosely coupled federation. Are you sending sales transactions from an Oracle database to a mainframe for billing? Are you extracting audit trails from your web server into a data warehouse? Are you reconciling the phone company’s electronic invoices with your voice mail system? Each of these scenarios could be classified as a database federation. The data may be in disparate forms, and there are no real-time transactions taking place.
If one or more of the databases in your federation is Oracle based, you can use a variety of techniques to move data from one database to another, including:
- Database links
If both sites are Oracle based, data can be selected, inserted, or updated over a database link.
- SQL*Loader
This tool loads non-Oracle data from a formatted text file into an Oracle table.
- Pro*C/C++, Pro*COBOL, Pro*FORTAN, Pro*Ada
Oracle precompilers allow you to embed SQL statements into programs, allowing you to migrate data from a file or other external source into Oracle.
- Oracle Gateway products
These products provide SQL access from an Oracle database to a foreign data source.
The key to success with a federated database system is a written specification and robustness. Because these systems are often cobbled together over time and often viewed as informal stopgaps, their quality often suffers. It is not uncommon for such a system to come completely unraveled ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.