Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184

    Question Unanswered: Homogeneous connectiity among Oracle databases

    Given the Limitations:
    Oracle Database data in geographical region X cannot be physically moved to region Y due to legal constraints
    Oracle Database data in region X can only be accessed remotely from region Y

    Given that the volume of data accessed across region with be medium i.e., the OLTP application Z at region Y will access Oracle data from region X remotely. There will be no OLTP application Z at region X where Oracle database data is located.

    Questions:
    1. What is the recommended (best practice) method of accessing region X Oracle data remotely from region Y using OLTP application Z?
    2. What other options are available to remotely access region X Oracle data from region Y?
    3. What are the pros & cons of using Oracle DB links to access region X Oracle data from region Y?
    4. Is Oracle Gateway required for access of region X Oracle data from region Y given that end-to-end it is only Oracle database data?

    Thanks in advance for your valuable inputs.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I only see one database & it reside in region X.
    If above is correct, then it eliminates from this discussion anything involving DB links.
    In order for any solution to be viable, sufficient network bandwidth must exist between 2 sites.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184
    Thanks for your valuable inputs.

    If the business requirement is to implement federation, we need to consider DB links OR Gateway...Do we have any other options with Oracle Corp?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >If the business requirement is to implement federation,

    what is "federation"?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184
    Data federation technology is also referred to as data virtualization technology where it provides the ability to aggregate data from disparate sources aka hetrogeneous databases. This is made possible by using a single virtual database. Even though this virtual database does not contain any data, it has pointers to data in different regions.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Quote Originally Posted by ggnanaraj View Post
    Data federation technology is also referred to as data virtualization technology where it provides the ability to aggregate data from disparate sources aka hetrogeneous databases. This is made possible by using a single virtual database. Even though this virtual database does not contain any data, it has pointers to data in different regions.
    That is nice.
    What does above have to do with a single Oracle DB in Region X?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •