Home » Other » General » How to make distributed DBMS in Oracle (Oracle, 10G, Solaris 5.10)
icon5.gif  How to make distributed DBMS in Oracle [message #446546] Tue, 09 March 2010 05:01 Go to next message
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
Senior Member
Sorry, I can't find relaited topic of this issue.

How to make distributed DBMS in Oracle?

I have read some materials about D-DBMS.
Database link is approach of D-DBMS system in Oracle. Is it true or not?
The Oracle database replication is method of D-DBMS. Is it true or not?

What is different D-DBMS, Oracle RAC, Oracle Replication?
Re: How to make distributed DBMS in Oracle [message #446547 is a reply to message #446546] Tue, 09 March 2010 05:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ True
2/ Not really

Oracle RAC is NOT a distributed database as there is only ONE database.
Replication is NOT a distributed database in the common meaning, just a pull or push of data.

Distributed database means making query/modification in several databases during a single transaction.

Regards
Michel
Re: How to make distributed DBMS in Oracle [message #446550 is a reply to message #446547] Tue, 09 March 2010 05:24 Go to previous messageGo to next message
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
Senior Member
Which component I use to do query in several databases during a single transaction?
Re: How to make distributed DBMS in Oracle [message #446559 is a reply to message #446550] Tue, 09 March 2010 05:54 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
A database link?
Re: How to make distributed DBMS in Oracle [message #446560 is a reply to message #446550] Tue, 09 March 2010 05:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database links.

Regards
Michel
Re: How to make distributed DBMS in Oracle [message #446588 is a reply to message #446560] Tue, 09 March 2010 07:55 Go to previous messageGo to next message
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
Senior Member
just db link?

I read about data fragmentation in D-DBMS.
Fragmentation is two type:

Horizontal subset of rows
Vertical subset of columns

Can I make horizontal fragmentation in Oracle using db link?

I'm working large historical data.
Re: How to make distributed DBMS in Oracle [message #446591 is a reply to message #446588] Tue, 09 March 2010 08:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
With partitions but not accross db links.
If you have tables in different databases concerning the same data there are partitioned as you want yet.

Regards
Michel

[Updated on: Tue, 09 March 2010 08:16]

Report message to a moderator

Re: How to make distributed DBMS in Oracle [message #446597 is a reply to message #446591] Tue, 09 March 2010 08:42 Go to previous messageGo to next message
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
Senior Member
The table partition can't run over db link.

I make a select query then run parallel in several databases. I want this approach from Oracle DBMS.
Re: How to make distributed DBMS in Oracle [message #446602 is a reply to message #446546] Tue, 09 March 2010 08:52 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
And we're back to using database links.
Why do you think they won't work for you?
Re: How to make distributed DBMS in Oracle [message #446603 is a reply to message #446597] Tue, 09 March 2010 08:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't have a table spread across several databases in Oracle.

Regards
Michel
Re: How to make distributed DBMS in Oracle [message #446605 is a reply to message #446603] Tue, 09 March 2010 09:01 Go to previous messageGo to next message
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
Senior Member
Ok, thank you advice.
Re: How to make distributed DBMS in Oracle [message #446665 is a reply to message #446605] Tue, 09 March 2010 22:17 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
What about partitioning? Use the geographical location as part (or all) of the partition key. When you search your geographical location your search is nearly purely local, but you can do a worldwide search that will do a search in each location and return the results to the enquirer.

David
Re: How to make distributed DBMS in Oracle [message #446808 is a reply to message #446546] Wed, 10 March 2010 09:34 Go to previous messageGo to next message
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
Senior Member
I try explain distributed DBMS in oracle by own knowledge:

1. I install oracle database server on two or more separate servers in different locations.
2. I make connection those servers using db link over network.
3. I write an application. this application can work over all databse servers without any extra connection.

I think the application is using distributed DBMS.
Is it true or not?
Re: How to make distributed DBMS in Oracle [message #446812 is a reply to message #446546] Wed, 10 March 2010 09:49 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
It is.

Question is why would you want to?
That's going to be far harder to manage than a single instance.
Re: How to make distributed DBMS in Oracle [message #446813 is a reply to message #446808] Wed, 10 March 2010 09:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Distributed database means making query/modification in several databases during a single transaction.

Does what you posted fit this definition?

Regards
Michel
Re: How to make distributed DBMS in Oracle [message #446898 is a reply to message #446813] Wed, 10 March 2010 23:23 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
For partitioning have a look at http://www.oracle.com/us/solutions/datawarehousing/partioning/index.htm

For distributed have a look at http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/ds_concepts.htm

David
Re: How to make distributed DBMS in Oracle [message #447010 is a reply to message #446546] Thu, 11 March 2010 08:42 Go to previous message
Tlg13team
Messages: 100
Registered: June 2008
Location: MGL
Senior Member
Thank you all replies.

I'm studying master of information system in Mongolia.
My diploma topic is "Improvement of performance weight area database system".

I'm research approach of Dist DBMS and Database Replication technology.
Previous Topic: knowledge about pl/sql
Next Topic: How to know RDBMS latest market share report
Goto Forum:
  


Current Time: Thu Mar 28 06:29:11 CDT 2024