RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE

[Mohan, Ross]

Title: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE

right.

 

kind of an Akamai-like localization of content.

 

Now, the interesting behavior arises when the local server "blows up"

and the users have to go back to the central server to get the data.

 

The localization of data for fast access makes it look federated and

the existence of a "Mother of all Single Points of Failure" central site

makes it look like good old OPS.

 

<shrug>

 

 

I agree wholeheartedly with the partitioning observation you made.

Now, put your data on physically distinct machines and you've

federated your database. In Oracle!  neat trick.

-----Original Message-----
From: Tony Johnson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 11:11 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE

The whole idea behind 9i is CacheFusion which uses a high-speed

interconnect to solve the pinging issues. At least that is the marketing

line that will only be proved in time. Any database of any size should

be using partititioning if you want it to perform and be able to manage it.

------------------------------------------------------------------------------
Tony Johnson                                    Email  : [EMAIL PROTECTED]
Senior Database Administrator                   Voice  : ( 480 ) 682 - 0849
GridData                                        Cell   : ( 602 ) 363 - 7328                    
7408 W. Detroit #100                            Fax    : ( 480 ) 961 - 8801
Chandler, AZ 85226
------------------------------------------------------------------------------
Murphy's Data Constant:Data will be damaged in direct proportion to its value

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mohan, Ross
Sent: Tuesday, February 06, 2001 6:53 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE

I understand the argument, Rodd and it raises three points/questions:

 

1) I can always back up a "state" ( part of a federation?) just like EMC/SRDF/BFD SAN does

    for the Oracle solution, and at less cost, and

 

2) Do you believe you can simply "add nodes" to an OPS farm to improve performance? I have

    personally never gone over a humble two nodes in OPS, and even then, locking issues must

    be addressed. One way out of this is the geographically segregate and partition the data. But

    this would be "federated."  In a pure play OPS scenario, I would imagine the system would

    choke to death after the fourth or sixth node, without special tweaks like partitioning, either

    by data or application.

 

3) Loss of a SS "state", just like loss of an oracle partition, does not "kill the operation of the system".

    here, they are the same. ......

 

just a thought......

 

 

   

 

 -----Original Message-----
From: Holman, Rodney [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 5:21 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE

Ross,

I was at the Open World conference session where Jeremy Burton made the comments about clustering, OPS, data segmentation, etc.  The data segmentation part was about MS SQLServer, and about how it creates significant work to add cluster nodes. C|net has their terms and comments a little scrambled. The Oracle 9i solution used OPS for the instances and an EMC/SRDF SAN for the data storage.  Each OPS cluster node had full access to every piece of data.  By doing this no node is a single point of failure (as Larry demonstrated and was chastised for by MS).  Also it creates greater capability for scalability.  Just configure and add a node and it improves performance (also part of Larry's demo).  As described with the MS federated database configuration you would need to resegment the data to add a node.  This would then destabilize the system even further by adding another single point of failure.  Failure of an OPS cluster node with the data on a SAN  with redundancy, such as the EMC/SRDF option, only decreases performance, it doesn't kill the operation of the system.

 

Rodd Holman

-----Original Message-----
From: Mohan, Ross [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 05, 2001 5:09 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: OT RE: Async I/O on Windows - WHAT is a FEDERATED DATABASE

Very Interesting!  It appears Oracle 9i, is, in fact, a Hybrid Federated Database!

http://news.cnet.com/news/0-1003-200-2897140.html?tag=st.ne.ni.metacomm.ni

A snippet: